trees
969 rows where qSpecies_id = 97 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1108 | 627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.7524574855488 | -122.415658642859 | (37.7524574855488, -122.415658642859) | 2 | 4 | 7 | 28859 | 19 | |||
| 1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
| 2420 | 260860 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6013106 | 2103855 | 37.7575226440732 | -122.397676712285 | (37.7575226440732, -122.397676712285) | 10 | 3 | 8 | 28856 | 29 | ||
| 3343 | 23100 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6006427.47457 | 2101357.75439 | 37.7502916230775 | -122.420596517121 | (37.7502916230775, -122.420596517121) | 2 | 4 | 5 | 28859 | 19 | |||
| 3962 | 224532 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.414869623533 | (37.7523850181574, -122.414869623533) | 2 | 4 | 7 | 28859 | 19 | |||
| 4358 | 224705 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | 2 | 4 | 7 | 28859 | 19 | |||
| 5167 | 126631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 7 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013670.6132 | 2118002.84349 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | 3 | 1 | 10 | 28860 | 6 | |||
| 5652 | 657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.7523426205157 | -122.417681586846 | (37.7523426205157, -122.417681586846) | 2 | 4 | 7 | 28859 | 19 | |||
| 5744 | 26220 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | 2 | 7 | 7 | 28859 | 2 | |||
| 5761 | 224699 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6007526.74961 | 2102095.67359 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | 2 | 4 | 7 | 28859 | 19 | |||
| 6491 | 224533 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008085.98241 | 2102084.65077 | 37.7523808471161 | -122.41491271097 | (37.7523808471161, -122.41491271097) | 2 | 4 | 7 | 28859 | 19 | |||
| 6967 | 224529 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3035 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6008772.64154 | 2102127.57906 | 37.7525372787939 | -122.412541157349 | (37.7525372787939, -122.412541157349) | 2 | 4 | 7 | 28859 | 19 | |||
| 7021 | 5742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | 2 | 7 | 5 | 28859 | 7 | |||
| 7593 | 224702 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6007468.55757 | 2102099.56491 | 37.7523870848126 | -122.417048929078 | (37.7523870848126, -122.417048929078) | 2 | 4 | 7 | 28859 | 19 | |||
| 7928 | 5672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | 2 | 7 | 5 | 63 | 22 | |||
| 9589 | 243519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6007186.6119 | 2102035.21074 | 37.7521945183717 | -122.418019383909 | (37.7521945183717, -122.418019383909) | 2 | 4 | 7 | 28859 | 19 | |||
| 9655 | 587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3045 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.412706471622 | (37.7525282406021, -122.412706471622) | 2 | 4 | 7 | 28859 | 19 | |||
| 11115 | 580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 782763 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | 2 | 4 | 7 | 28859 | 19 | ||
| 11332 | 55316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11245 | 6011314.64048 | 2089535.2445 | 37.7181037214869 | -122.402864884726 | (37.7181037214869, -122.402864884726) | 10 | 7 | 8 | 309 | 39 | |
| 11585 | 224534 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.415731366506 | (37.752340521521, -122.415731366506) | 2 | 4 | 7 | 28859 | 19 | |||
| 13271 | 551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009445.64374 | 2102206.22318 | 37.7527909649347 | -122.41021934346 | (37.7527909649347, -122.41021934346) | 2 | 4 | 7 | 28859 | 19 | |||
| 15856 | 224535 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007823.33257 | 2102073.06201 | 37.7523342649139 | -122.415820179079 | (37.7523342649139, -122.415820179079) | 2 | 4 | 7 | 28859 | 19 | |||
| 16341 | 224695 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3034 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6008772.76102 | 2102170.48787 | 37.7526551034509 | -122.412543777077 | (37.7526551034509, -122.412543777077) | 2 | 4 | 7 | 28859 | 19 | |||
| 16785 | 224704 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007185.41243 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | 2 | 4 | 7 | 28859 | 19 | |||
| 19051 | 224694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008827.83828 | 2102168.91217 | 37.7526538678042 | -122.412353198162 | (37.7526538678042, -122.412353198162) | 2 | 4 | 7 | 28859 | 19 | |||
| 23203 | 6798 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.384038431137 | (37.7394266247399, -122.384038431137) | 10 | 3 | 8 | 58 | 1 | |||
| 25118 | 224700 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | 2 | 4 | 7 | 28859 | 19 | |||
| 32511 | 117226 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
| 36309 | 577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.7526513982496 | -122.412443801263 | (37.7526513982496, -122.412443801263) | 2 | 4 | 7 | 28859 | 19 | |||
| 38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
| 39862 | 7496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008261.67558 | 2102751.78327 | 37.754222512966 | -122.414352332587 | (37.754222512966, -122.414352332587) | 2 | 4 | 7 | 28859 | 19 | |||
| 39941 | 6742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.50063 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | 10 | 3 | 8 | 58 | 1 | ||
| 46703 | 633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | 2 | 4 | 7 | 28859 | 19 | |||
| 46860 | 126624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 801x Greenwich St | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.8019265293585 | -122.412796822924 | (37.8019265293585, -122.412796822924) | 3 | 1 | 10 | 308 | 4 | |||
| 51336 | 24449 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006348.43077 | 2102831.95647 | 37.7543349884778 | -122.420974512988 | (37.7543349884778, -122.420974512988) | 2 | 4 | 5 | 28859 | 19 | |||
| 54116 | 24446 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.7544300800889 | -122.420987008139 | (37.7544300800889, -122.420987008139) | 2 | 4 | 5 | 28859 | 19 | |||
| 57949 | 126628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 3 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | 3 | 1 | 10 | 28860 | 6 | |||
| 61290 | 576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3008 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008852.23919 | 2102169.31321 | 37.7526563382221 | -122.412268843556 | (37.7526563382221, -122.412268843556) | 2 | 4 | 7 | 28859 | 19 | |||
| 65040 | 622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3150 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007969.89189 | 2102118.08704 | 37.7524661316063 | -122.415316538925 | (37.7524661316063, -122.415316538925) | 2 | 4 | 7 | 28859 | 19 | |||
| 65463 | 224530 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008605.15504 | 2102119.10209 | 37.752504601916 | -122.413119756879 | (37.752504601916, -122.413119756879) | 2 | 4 | 7 | 28859 | 19 | |||
| 67963 | 117227 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 69321 | 16914 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004697.20239 | 2110157.08412 | 37.7743548226588 | -122.427206624104 | (37.7743548226588, -122.427206624104) | 7 | 9 | 11 | 28852 | 10 | |||
| 76501 | 5708 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005329.17263 | 2098980.11676 | 37.7437012157418 | -122.424225442544 | (37.7437012157418, -122.424225442544) | 2 | 7 | 5 | 28859 | 22 | |||
| 79322 | 25364 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000636.2417 | 2088870.05563 | 37.7156752201082 | -122.43972775363 | (37.7156752201082, -122.43972775363) | 9 | 7 | 6 | 28861 | 5 | |||
| 86094 | 117224 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 88021 | 115029 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 94910 | 251399 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008927.48691 | 2120274.72498 | 37.8023737344278 | -122.413288863041 | (37.8023737344278, -122.413288863041) | 3 | 1 | 10 | 308 | 32 | ||||
| 97647 | 602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3085 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6008423.83472 | 2102105.59165 | 37.7524573245683 | -122.413745839724 | (37.7524573245683, -122.413745839724) | 2 | 4 | 7 | 28859 | 19 | |||
| 102221 | 28251 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011988.71606 | 2089960.7357 | 37.7193096502899 | -122.400564754381 | (37.7193096502899, -122.400564754381) | 10 | 7 | 8 | 309 | 28 | |||
| 102347 | 24603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 407 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6007220.87336 | 2097309.53692 | 37.7392208076833 | -122.417566003264 | (37.7392208076833, -122.417566003264) | 2 | 7 | 7 | 28859 | 2 | |||
| 107274 | 24448 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006348.61536 | 2102840.94797 | 37.7543596874688 | -122.420974512988 | (37.7543596874688, -122.420974512988) | 2 | 4 | 5 | 28859 | 19 | |||
| 107405 | 597 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3067 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008545.44191 | 2102115.03145 | 37.7524900724667 | -122.41332596784 | (37.7524900724667, -122.41332596784) | 2 | 4 | 7 | 28859 | 19 | |||
| 107790 | 613 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008177.96308 | 2102131.82169 | 37.7525155358782 | -122.41459796354 | (37.7525155358782, -122.41459796354) | 2 | 4 | 7 | 28859 | 19 | |||
| 108091 | 644 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3245 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007452.42683 | 2102052.29911 | 37.75225639624 | -122.417101363131 | (37.75225639624, -122.417101363131) | 2 | 4 | 7 | 28859 | 19 | |||
| 108921 | 571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.00613 | 2102184.08314 | 37.7527082129358 | -122.411572138748 | (37.7527082129358, -122.411572138748) | 2 | 4 | 7 | 28859 | 19 | ||
| 112567 | 5335 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 149 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X8 | 6004854.459 | 2107562.68516 | 37.7672401222731 | -122.42647787465 | (37.7672401222731, -122.42647787465) | 8 | 4 | 5 | 28862 | 19 | |||
| 113783 | 126629 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | 3 | 1 | 10 | 28860 | 6 | |||
| 114985 | 5689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1535 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005306.00348 | 2099419.02782 | 37.7449050572203 | -122.424336766952 | (37.7449050572203, -122.424336766952) | 2 | 7 | 5 | 28859 | 22 | |||
| 115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
| 115641 | 5371 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 266 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6004805.70542 | 2106808.51316 | 37.7651665904864 | -122.42659279722 | (37.7651665904864, -122.42659279722) | 8 | 4 | 5 | 28862 | 3 | |||
| 115657 | 26548 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3085 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008470.90767 | 2102107.16108 | 37.752464277228 | -122.413583164054 | (37.752464277228, -122.413583164054) | 2 | 4 | 7 | 28859 | 19 | |||
| 117473 | 115032 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 121365 | 5338 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 158 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6004769.98156 | 2107435.4149 | 37.766885892799 | -122.426761005535 | (37.766885892799, -122.426761005535) | 8 | 4 | 5 | 28862 | 3 | |||
| 122705 | 115031 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 125391 | 554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2912X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009391.31353 | 2102200.13523 | 37.7527712032402 | -122.410406798162 | (37.7527712032402, -122.410406798162) | 2 | 4 | 7 | 28859 | 19 | |||
| 126791 | 23101 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | 2 | 4 | 5 | 28859 | 19 | |||
| 127353 | 23546 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2805 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005607.92942 | 2120044.70688 | 37.8015552343461 | -122.424759800825 | (37.8015552343461, -122.424759800825) | 13 | 9 | 1 | 57 | 17 | |||
| 127460 | 24447 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006347.02184 | 2102851.32539 | 37.754388091646 | -122.420980760555 | (37.754388091646, -122.420980760555) | 2 | 4 | 5 | 28859 | 19 | |||
| 127918 | 611 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3108 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008224.09237 | 2102134.47643 | 37.752525416718 | -122.414438627958 | (37.752525416718, -122.414438627958) | 2 | 4 | 7 | 28859 | 19 | |||
| 129099 | 10222 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | 2 | 4 | 5 | 28859 | 19 | |||
| 131474 | 16900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.7745003644325 | -122.426136940772 | (37.7745003644325, -122.426136940772) | 7 | 9 | 11 | 28852 | 10 | |||
| 132591 | 115030 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 135027 | 115025 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 135138 | 574 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3000 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6008882.07656 | 2102170.50291 | 37.7526612791072 | -122.412165744373 | (37.7526612791072, -122.412165744373) | 2 | 4 | 7 | 28859 | 19 | |||
| 136653 | 5127 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | 2 | 7 | 5 | 63 | 7 | ||
| 136983 | 626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3155 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6007952.38293 | 2102079.53558 | 37.7523592939498 | -122.415374359065 | (37.7523592939498, -122.415374359065) | 2 | 4 | 7 | 28859 | 19 | |||
| 142490 | 5334 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004762.96876 | 2107575.67846 | 37.7672706263574 | -122.426795251693 | (37.7672706263574, -122.426795251693) | 8 | 4 | 5 | 28862 | 3 | |||
| 143436 | 115026 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 144232 | 5748 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 6005291.42369 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | 2 | 7 | 5 | 63 | 7 | |||
| 145158 | 117225 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 145617 | 126630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 6 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | 3 | 1 | 10 | 28860 | 6 | |||
| 147724 | 5576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1040 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005062.54747 | 2102282.8606 | 37.7527547312707 | -122.425382354736 | (37.7527547312707, -122.425382354736) | 2 | 4 | 5 | 28862 | 22 | |||
| 150846 | 28252 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3342 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011993.05449 | 2089944.36853 | 37.7192649513087 | -122.400548608856 | (37.7192649513087, -122.400548608856) | 10 | 7 | 8 | 309 | 28 | |||
| 153957 | 5685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.424677493096 | (37.7452207246578, -122.424677493096) | 2 | 7 | 5 | 63 | 22 | |||
| 155173 | 28743 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 750 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.99358 | 2098694.18206 | 37.742932633526 | -122.42319261615 | (37.742932633526, -122.42319261615) | 2 | 7 | 5 | 28859 | 22 | |||
| 158181 | 612 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3114 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6008205.07322 | 2102132.16672 | 37.7525180063146 | -122.414504236196 | (37.7525180063146, -122.414504236196) | 2 | 4 | 7 | 28859 | 19 | |||
| 162216 | 126627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.395987070255 | (37.796538299751, -122.395987070255) | 3 | 1 | 10 | 28860 | 6 | |||
| 168632 | 590 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3049 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008590.89573 | 2102118.12773 | 37.7525011260356 | -122.413168999261 | (37.7525011260356, -122.413168999261) | 2 | 4 | 7 | 28859 | 19 | |||
| 171805 | 115033 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 177687 | 224701 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 3ft | 6007503.74003 | 2102097.04469 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | 2 | 4 | 7 | 28859 | 19 | |||
| 178369 | 556 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2934 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009338.07942 | 2102203.47128 | 37.7527773788967 | -122.410591127672 | (37.7527773788967, -122.410591127672) | 2 | 4 | 7 | 28859 | 19 | |||
| 178512 | 115027 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 183317 | 5133 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.7346064681217 | -122.433897334607 | (37.7346064681217, -122.433897334607) | 2 | 7 | 5 | 63 | 7 | |||
| 186316 | 224703 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | 2 | 4 | 7 | 28859 | 19 | |||
| 186380 | 596 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3066 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6008530.73419 | 2102152.94469 | 37.7525933479176 | -122.413379510765 | (37.7525933479176, -122.413379510765) | 2 | 4 | 7 | 28859 | 19 | |||
| 189515 | 23099 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | 2 | 4 | 5 | 28859 | 19 | |||
| 193914 | 115028 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
| 374 | 5332 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 6x7 | 6004849.91389 | 2107615.96816 | 37.7673861676625 | -122.426497389946 | (37.7673861676625, -122.426497389946) | 8 | 4 | 5 | 28862 | 19 | |||
| 443 | 107383 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );