Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21076 | 21076 | 5748 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 6005291.423690001 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | |||
| 19320 | 19320 | 5332 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6x7 | 6004849.91389 | 2107615.9681599997 | 37.7673861676625 | -122.42649738994601 | (37.7673861676625, -122.426497389946) | |||
| 19950 | 19950 | 5335 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 149 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X8 | 6004854.459 | 2107562.68516 | 37.7672401222731 | -122.42647787465 | (37.7672401222731, -122.42647787465) | |||
| 20211 | 20211 | 5689 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1535 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005306.00348 | 2099419.02782 | 37.74490505722029 | -122.424336766952 | (37.7449050572203, -122.424336766952) | |||
| 21156 | 21156 | 5334 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 140 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004762.96876 | 2107575.6784599996 | 37.7672706263574 | -122.426795251693 | (37.7672706263574, -122.426795251693) | |||
| 17131 | 17131 | 5742 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | |||
| 19035 | 19035 | 5708 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005329.17263 | 2098980.1167599997 | 37.743701215741794 | -122.424225442544 | (37.7437012157418, -122.424225442544) | |||
| 19766 | 19766 | 5379 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 299 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6004899.9834 | 2106715.40982 | 37.764916280383 | -122.426260083162 | (37.764916280383, -122.426260083162) | |||
| 20645 | 20645 | 5358 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004797.6722800005 | 2107012.30465 | 37.765725699015604 | -122.426635095043 | (37.7657256990156, -122.426635095043) | |||
| 21085 | 21085 | 5576 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1040 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005062.54747 | 2102282.8606 | 37.752754731270706 | -122.425382354736 | (37.7527547312707, -122.425382354736) | |||
| 17377 | 17377 | 12244 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005028.531359999 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | |||
| 20672 | 20672 | 26517 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | |||
| 20574 | 20574 | 23101 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | |||
| 16970 | 16970 | 23100 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6006427.47457 | 2101357.7543900004 | 37.7502916230775 | -122.42059651712098 | (37.7502916230775, -122.420596517121) | |||
| 39271 | 39271 | 126617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.798784587708504 | -122.446078403512 | (37.7987845877085, -122.446078403512) | |||
| 17762 | 17762 | 24449 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006348.4307699995 | 2102831.95647 | 37.7543349884778 | -122.420974512988 | (37.7543349884778, -122.420974512988) | |||
| 18141 | 18141 | 24446 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.754430080088895 | -122.420987008139 | (37.7544300800889, -122.420987008139) | |||
| 20215 | 20215 | 24447 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006347.0218400005 | 2102851.3253900004 | 37.754388091646 | -122.420980760555 | (37.754388091646, -122.420980760555) | |||
| 24881 | 24881 | 224536 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | |||
| 156833 | 156833 | 224526 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | |||
| 164944 | 164944 | 224679 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007366.7394199995 | 2101988.35955 | 37.752076011999605 | -122.417393153575 | (37.7520760119996, -122.417393153575) | |||
| 188891 | 188891 | 224697 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.752431548191296 | -122.415947634593 | (37.7524315481913, -122.415947634593) | |||
| 21797 | 21797 | 23099 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | |||
| 32232 | 32232 | 224696 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3164 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007892.65304 | 2102118.31873 | 37.752462426418205 | -122.415583660969 | (37.7524624264182, -122.415583660969) | |||
| 47489 | 47489 | 224527 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 171 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6006719.85919 | 2102790.50948 | 37.7542421146046 | -122.419687075893 | (37.7542421146046, -122.419687075893) | |||
| 58368 | 58368 | 224708 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3018 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008114.55455 | 2103302.41792 | 37.7557261650385 | -122.414900084483 | (37.7557261650385, -122.414900084483) | |||
| 72482 | 72482 | 116841 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | |||
| 85873 | 85873 | 38252 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.76680309330379 | -122.418866676369 | (37.7668030933038, -122.418866676369) | |
| 99975 | 99975 | 58797 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 772 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1979 12:00:00 AM | 24 | 3x3 | Permit Number 53459 | 6003043.36972634 | 2103781.55156302 | 37.756755493530896 | -122.43247206616199 | (37.7567554935309, -122.432472066162) | |
| 117709 | 117709 | 61473 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1984 12:00:00 AM | 24 | Permit Number 21416 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |
| 128320 | 128320 | 121150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |||
| 137665 | 137665 | 176427 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6010742.024730001 | 2089174.6470599999 | 37.7170816042145 | -122.40481880756201 | (37.7170816042145, -122.404818807562) | |||
| 18661 | 18661 | 598 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3070 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6008489.074019999 | 2102147.94889 | 37.75257729142999 | -122.41352322603399 | (37.75257729143, -122.413523226034) | |||
| 46392 | 46392 | 224600 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3318 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006204.33769 | 2103782.43262 | 37.7569366525255 | -122.421540324144 | (37.7569366525255, -122.421540324144) | |||
| 73094 | 73094 | 224603 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3360 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6005941.90978 | 2103767.20067 | 37.7568800285 | -122.42244681736 | (37.7568800285, -122.42244681736) | |||
| 130557 | 130557 | 224653 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 44 Elsie St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6007416.47838 | 2099024.91557 | 37.743941860842796 | -122.417011196208 | (37.7439418608428, -122.417011196208) | |||
| 150231 | 150231 | 224709 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006609.601919999 | 2103216.71936 | 37.755406177257704 | -122.42009861917299 | (37.7554061772577, -122.420098619173) | |||
| 163279 | 163279 | 224602 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3344 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006035.96544 | 2103769.71631 | 37.756892241295 | -122.422121716065 | (37.756892241295, -122.422121716065) | |||
| 185595 | 185595 | 199430 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | |||
| 18232 | 18232 | 630 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3176 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6007837.40103 | 2102111.35303 | 37.752440194268395 | -122.41577423901501 | (37.7524401942684, -122.415774239015) | |||
| 21673 | 21673 | 596 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3066 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6008530.73419 | 2102152.9446900003 | 37.752593347917596 | -122.413379510765 | (37.7525933479176, -122.413379510765) | |||
| 25064 | 25064 | 176406 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5998546.73235 | 2087959.10708 | 37.71305480791771 | -122.446884509935 | (37.7130548079177, -122.446884509935) | |||
| 50369 | 50369 | 224654 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 38 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007453.75758 | 2099095.22372 | 37.7441370083106 | -122.416887273228 | (37.7441370083106, -122.416887273228) | |||
| 74987 | 74987 | 224705 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2783 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | |||
| 126670 | 126670 | 60830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.42644917929199 | (37.7520575177016, -122.426449179292) | |
| 135158 | 135158 | 224706 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3200 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007512.60917 | 2102684.32552 | 37.753995182337 | -122.416938018377 | (37.753995182337, -122.416938018377) | |||
| 135639 | 135639 | 224644 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 7 Heyman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006402.40696 | 2098386.74463 | 37.7421324905292 | -122.42047233962099 | (37.7421324905292, -122.420472339621) | |||
| 150672 | 150672 | 224695 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3028 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6008772.76102 | 2102170.4878700003 | 37.7526551034509 | -122.412543777077 | (37.7526551034509, -122.412543777077) | |||
| 170568 | 170568 | 224647 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 11 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006471.9777 | 2098350.49655 | 37.74203688180479 | -122.420229213316 | (37.7420368818048, -122.420229213316) | |||
| 173633 | 173633 | 224486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | |||
| 173787 | 173787 | 224599 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3316 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006227.0887 | 2103782.97651 | 37.756939428723 | -122.42146168110901 | (37.756939428723, -122.421461681109) | |||
| 176263 | 176263 | 224698 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3196 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007749.279159999 | 2102109.5588 | 37.7524303134304 | -122.416078852874 | (37.7524303134304, -122.416078852874) | |||
| 18768 | 18768 | 622 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3150 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007969.891890001 | 2102118.08704 | 37.7524661316063 | -122.415316538925 | (37.7524661316063, -122.415316538925) | |||
| 19961 | 19961 | 600 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.41362163882401 | (37.7525711157729, -122.413621638824) | |||
| 20532 | 20532 | 627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3168 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.752457485548796 | -122.415658642859 | (37.7524574855488, -122.415658642859) | |||
| 21513 | 21513 | 604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.752563705358604 | -122.413779413197 | (37.7525637053586, -122.413779413197) | |||
| 41755 | 41755 | 126624 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 801x Greenwich St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.801926529358504 | -122.41279682292401 | (37.8019265293585, -122.412796822924) | |||
| 47541 | 47541 | 224710 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006579.99639 | 2103217.6190400003 | 37.755406979454996 | -122.42020106814199 | (37.755406979455, -122.420201068142) | |||
| 64255 | 64255 | 224659 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6009169.148580001 | 2102873.09479 | 37.754606542358296 | -122.41122262175 | (37.7546065423583, -122.41122262175) | |||
| 67018 | 67018 | 54789 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 21 | Permit Number 10638 | 6012677.12996 | 2087211.6465200002 | 37.7117995683772 | -122.39799240103001 | (37.7117995683772, -122.39799240103) | ||
| 75889 | 75889 | 224607 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3540 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6005920.828919999 | 2102594.51157 | 37.753658906948 | -122.42243640053002 | (37.753658906948, -122.42243640053) | |||
| 77150 | 77150 | 224642 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006381.67631 | 2098450.75503 | 37.742307080422 | -122.420548562565 | (37.742307080422, -122.420548562565) | |||
| 150164 | 150164 | 224694 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3022 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008827.838280001 | 2102168.91217 | 37.752653867804206 | -122.41235319816201 | (37.7526538678042, -122.412353198162) | |||
| 156313 | 156313 | 224601 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3328 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006122.42737 | 2103775.96782 | 37.756914282788 | -122.42182314201901 | (37.756914282788, -122.421823142019) | |||
| 157050 | 157050 | 224532 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.41486962353301 | (37.7523850181574, -122.414869623533) | |||
| 160939 | 160939 | 224678 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6007360.84858 | 2102028.60298 | 37.752186179864104 | -122.41741637677201 | (37.7521861798641, -122.417416376772) | |||
| 164846 | 164846 | 224634 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 248 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006846.03495 | 2097621.06949 | 37.740055107862 | -122.418884118001 | (37.740055107862, -122.418884118001) | |||
| 167655 | 167655 | 226484 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008470.16955 | 2105663.03593 | 37.7622278587398 | -122.413837225211 | (37.7622278587398, -122.413837225211) | |||
| 170500 | 170500 | 226479 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008278.21403 | 2105065.6529900003 | 37.7605768005893 | -122.414458856385 | (37.7605768005893, -122.414458856385) | |||
| 1962 | 1962 | 224700 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | |||
| 2012 | 2012 | 224703 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | |||
| 17117 | 17117 | 625 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | |||
| 18228 | 18228 | 633 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | |||
| 18462 | 18462 | 623 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3158 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6007941.8237 | 2102115.0630200002 | 37.7524562507759 | -122.415413389641 | (37.7524562507759, -122.415413389641) | |||
| 19935 | 19935 | 613 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3124 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008177.96308 | 2102131.82169 | 37.7525155358782 | -122.41459796353998 | (37.7525155358782, -122.41459796354) | |||
| 20158 | 20158 | 605 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3098 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008383.72095 | 2102142.9064 | 37.752557529712895 | -122.41388719964701 | (37.7525575297129, -122.413887199647) | |||
| 20778 | 20778 | 22835 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.743260073094504 | -122.44411845071899 | (37.7432600730945, -122.444118450719) | ||
| 21323 | 21323 | 5685 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.42467749309601 | (37.7452207246578, -122.424677493096) | |||
| 21465 | 21465 | 612 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3114 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6008205.07322 | 2102132.16672 | 37.7525180063146 | -122.41450423619601 | (37.7525180063146, -122.414504236196) | |||
| 25222 | 25222 | 224646 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006447.484730001 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | |||
| 41825 | 41825 | 226490 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008822.75268 | 2104167.00903 | 37.758139904958206 | -122.412512013916 | (37.7581399049582, -122.412512013916) | |||
| 52943 | 52943 | 224704 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007185.4124300005 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | |||
| 62389 | 62389 | 224645 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 7 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006421.94544 | 2098375.74609 | 37.742103392067 | -122.42040400106701 | (37.742103392067, -122.420404001067) | |||
| 63214 | 63214 | 224712 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3560 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006570.05679 | 2104384.7111400003 | 37.7586109842303 | -122.420318274095 | (37.7586109842303, -122.420318274095) | |||
| 76995 | 76995 | 224535 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3175 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007823.33257 | 2102073.06201 | 37.7523342649139 | -122.41582017907899 | (37.7523342649139, -122.415820179079) | |||
| 103877 | 103877 | 121142 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
| 122320 | 122320 | 121141 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
| 133723 | 133723 | 226474 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008423.54633 | 2105074.53683 | 37.7606093569454 | -122.41395684494101 | (37.7606093569454, -122.413956844941) | |||
| 138144 | 138144 | 126620 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.41656913265801 | (37.7920924400618, -122.416569132658) | |||
| 150883 | 150883 | 224586 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2757 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008370.39736 | 2106782.63343 | 37.765296411224604 | -122.414261518161 | (37.7652964112246, -122.414261518161) | |||
| 151532 | 151532 | 199431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6013045.4631900005 | 2103845.54885 | 37.7574933220764 | -122.39788541140499 | (37.7574933220764, -122.397885411405) | |||
| 154231 | 154231 | 226486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008522.957719999 | 2105665.90861 | 37.7622387108737 | -122.41365485348801 | (37.7622387108737, -122.413654853488) | |||
| 164912 | 164912 | 224713 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3546 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006637.61846 | 2104388.97132 | 37.7586264885425 | -122.420084917099 | (37.7586264885425, -122.420084917099) | |||
| 178284 | 178284 | 226485 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544938999 | (37.7622371604259, -122.41372544939) | |||
| 1492 | 1492 | 224530 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6008605.155040001 | 2102119.10209 | 37.752504601916 | -122.413119756879 | (37.752504601916, -122.413119756879) | |||
| 1970 | 1970 | 224702 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007468.557569999 | 2102099.5649099997 | 37.752387084812604 | -122.417048929078 | (37.7523870848126, -122.417048929078) | |||
| 26257 | 26257 | 226491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008819.815769999 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | |||
| 58035 | 58035 | 224572 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3149 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008508.49482 | 2105618.39976 | 37.762107450331605 | -122.413701514835 | (37.7621074503316, -122.413701514835) | |||
| 60202 | 60202 | 226476 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008336.71685 | 2105070.6667299997 | 37.7605938535513 | -122.414256875855 | (37.7605938535513, -122.414256875855) | |||
| 62058 | 62058 | 224491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998359.17902 | 2106895.28933 | 37.765038301310796 | -122.4488959273 | (37.7650383013108, -122.4488959273) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");