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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113280 | 113280 | 105686 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 3 | Front Yard : Pot 30 | Tree 1 | Private 1 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 124771 | 124771 | 105685 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 2 | Front Yard : Pot 30 | Tree 1 | Private 1 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 126368 | 126368 | 105684 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 56265 | 56265 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 953 Indiana St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6015057.1 | 2104275.7 | 37.758786250670205 | -122.39095836980302 | (37.7587862506702, -122.390958369803) | |||||
| 93681 | 93681 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 768245 | 6003236.0 | 2116309.0 | 37.7911636966224 | -122.43270073645701 | (37.7911636966224, -122.432700736457) | |||
| 4385 | 4385 | 224618 | Planning Code 138.1 required 4 | Ficus microcarpa :: Chinese Banyan 94 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | ||
| 881 | 881 | 251399 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008927.4869099995 | 2120274.72498 | 37.802373734427796 | -122.413288863041 | (37.8023737344278, -122.413288863041) | ||||
| 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) | |||
| 1507 | 1507 | 590 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3049 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008590.89573 | 2102118.12773 | 37.7525011260356 | -122.413168999261 | (37.7525011260356, -122.413168999261) | |||
| 1961 | 1961 | 224699 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 6007526.74961 | 2102095.6735900003 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | |||
| 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) | |||
| 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) | |||
| 2011 | 2011 | 224701 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6007503.74003 | 2102097.0446900004 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | |||
| 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) | |||
| 2216 | 2216 | 122752 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | |||
| 2223 | 2223 | 43305 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | |
| 2231 | 2231 | 122750 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 6011285.1392 | 2105241.4016400003 | 37.761227830607204 | -122.40407158333299 | (37.7612278306072, -122.404071583333) | |||
| 2233 | 2233 | 122749 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 6011285.506709999 | 2105214.92948 | 37.761155164510605 | -122.404068449214 | (37.7611551645106, -122.404068449214) | |||
| 7271 | 7271 | 23546 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2805 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005607.92942 | 2120044.70688 | 37.801555234346104 | -122.424759800825 | (37.8015552343461, -122.424759800825) | |||
| 11743 | 11743 | 28251 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3340 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011988.71606 | 2089960.7357 | 37.7193096502899 | -122.40056475438101 | (37.7193096502899, -122.400564754381) | |||
| 12579 | 12579 | 28252 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3342 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011993.05449 | 2089944.3685299999 | 37.7192649513087 | -122.40054860885598 | (37.7192649513087, -122.400548608856) | |||
| 13606 | 13606 | 6798 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.38403843113701 | (37.7394266247399, -122.384038431137) | |||
| 16901 | 16901 | 16914 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004697.20239 | 2110157.0841200002 | 37.77435482265879 | -122.427206624104 | (37.7743548226588, -122.427206624104) | |||
| 16905 | 16905 | 26220 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | |||
| 16957 | 16957 | 5672 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | |||
| 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) | |||
| 17077 | 17077 | 551 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009445.64374 | 2102206.2231799997 | 37.752790964934704 | -122.41021934346 | (37.7527909649347, -122.41021934346) | |||
| 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) | |||
| 17222 | 17222 | 3468 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3231 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 4x4 | 6007477.096919999 | 2102052.55322 | 37.752258481762 | -122.41701606785601 | (37.752258481762, -122.417016067856) | |||
| 17372 | 17372 | 552 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.41031307080699 | (37.7527835545272, -122.410313070807) | |||
| 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) | |||
| 17445 | 17445 | 16902 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 427 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004930.51635 | 2110189.46412 | 37.7744569217764 | -122.42640185318899 | (37.7744569217764, -122.426401853189) | |||
| 17601 | 17601 | 577 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.752651398249604 | -122.41244380126301 | (37.7526513982496, -122.412443801263) | |||
| 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) | |||
| 17916 | 17916 | 587 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3041 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.41270647162202 | (37.7525282406021, -122.412706471622) | |||
| 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) | |||
| 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) | |||
| 18516 | 18516 | 580 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | |||
| 18722 | 18722 | 576 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3008 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008852.23919 | 2102169.31321 | 37.7526563382221 | -122.412268843556 | (37.7526563382221, -122.412268843556) | |||
| 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) | |||
| 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) | |||
| 19544 | 19544 | 24603 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 407 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6007220.87336 | 2097309.53692 | 37.739220807683296 | -122.41756600326401 | (37.7392208076833, -122.417566003264) | |||
| 19625 | 19625 | 571 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.006130001 | 2102184.0831400002 | 37.752708212935794 | -122.411572138748 | (37.7527082129358, -122.411572138748) | ||
| 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) | |||
| 19855 | 19855 | 602 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3085 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6008423.83472 | 2102105.59165 | 37.7524573245683 | -122.413745839724 | (37.7524573245683, -122.413745839724) | |||
| 19889 | 19889 | 597 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3067 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008545.44191 | 2102115.03145 | 37.7524900724667 | -122.41332596783998 | (37.7524900724667, -122.41332596784) | |||
| 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) | |||
| 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) | |||
| 20011 | 20011 | 644 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3245 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007452.42683 | 2102052.29911 | 37.75225639624 | -122.41710136313101 | (37.75225639624, -122.417101363131) | |||
| 20042 | 20042 | 24448 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006348.61536 | 2102840.94797 | 37.7543596874688 | -122.420974512988 | (37.7543596874688, -122.420974512988) | |||
| 20104 | 20104 | 26548 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3085 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6008470.90767 | 2102107.16108 | 37.752464277228 | -122.41358316405399 | (37.752464277228, -122.413583164054) | |||
| 20144 | 20144 | 16900 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.774500364432505 | -122.426136940772 | (37.7745003644325, -122.426136940772) | |||
| 20206 | 20206 | 5338 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 158 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6004769.98156 | 2107435.4149 | 37.766885892799 | -122.426761005535 | (37.766885892799, -122.426761005535) | |||
| 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) | |||
| 20213 | 20213 | 5371 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 266 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x6 | 6004805.70542 | 2106808.5131599996 | 37.765166590486395 | -122.42659279722 | (37.7651665904864, -122.42659279722) | |||
| 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) | |||
| 20360 | 20360 | 611 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3108 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008224.09237 | 2102134.47643 | 37.752525416718 | -122.41443862795799 | (37.752525416718, -122.414438627958) | |||
| 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) | |||
| 20538 | 20538 | 10222 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | |||
| 20570 | 20570 | 554 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2912X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009391.31353 | 2102200.13523 | 37.7527712032402 | -122.410406798162 | (37.7527712032402, -122.410406798162) | |||
| 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) | |||
| 20796 | 20796 | 626 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3155 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6007952.38293 | 2102079.53558 | 37.752359293949795 | -122.415374359065 | (37.7523592939498, -122.415374359065) | |||
| 20802 | 20802 | 574 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3000 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6008882.07656 | 2102170.50291 | 37.7526612791072 | -122.412165744373 | (37.7526612791072, -122.412165744373) | |||
| 21001 | 21001 | 5127 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 21401 | 21401 | 28743 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 750 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.9935800005 | 2098694.18206 | 37.742932633526 | -122.42319261615 | (37.742932633526, -122.42319261615) | |||
| 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) | |||
| 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) | |||
| 21680 | 21680 | 5133 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.734606468121704 | -122.433897334607 | (37.7346064681217, -122.433897334607) | |||
| 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) | |||
| 21969 | 21969 | 556 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2934 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009338.079419999 | 2102203.4712799997 | 37.7527773788967 | -122.410591127672 | (37.7527773788967, -122.410591127672) | |||
| 23078 | 23078 | 7496 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008261.6755800005 | 2102751.78327 | 37.754222512965995 | -122.414352332587 | (37.754222512966, -122.414352332587) | |||
| 23132 | 23132 | 25364 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000636.2417 | 2088870.0556299998 | 37.7156752201082 | -122.43972775363001 | (37.7156752201082, -122.43972775363) | |||
| 39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
| 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) | |||
| 71439 | 71439 | 126629 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | |||
| 85453 | 85453 | 117227 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 91179 | 91179 | 117224 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 93347 | 93347 | 115029 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 95832 | 95832 | 98577 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 301X Francisco St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6x7 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 106099 | 106099 | 115031 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 106354 | 106354 | 115030 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 107487 | 107487 | 115032 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 111118 | 111118 | 117225 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 111527 | 111527 | 115025 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 112402 | 112402 | 115026 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 127844 | 127844 | 117226 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 133542 | 133542 | 126631 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013670.6132 | 2118002.8434900003 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | |||
| 142948 | 142948 | 115033 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 143506 | 143506 | 115027 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 145077 | 145077 | 115028 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 173926 | 173926 | 126630 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | |||
| 174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) |
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");