trees
168 rows where Fire Prevention Districts = 8 and qSpecies_id = 8 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1507 | 74233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010292.05063 | 2106000.69739 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | 8 | 4 | 8 | 28859 | 19 | |||
2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
9156 | 73920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008409.30532 | 2108731.32076 | 37.7706492380987 | -122.414264830382 | (37.7706492380987, -122.414264830382) | 8 | 2 | 9 | 28853 | 19 | |||
13425 | 223490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.30011 | 2107940.39716 | 37.768488553924 | -122.41353093232 | (37.768488553924, -122.41353093232) | 8 | 4 | 7 | 28853 | 19 | |||
14213 | 74019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.407628081878 | (37.7632482996846, -122.407628081878) | 8 | 4 | 8 | 28859 | 19 | ||
15417 | 224105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006280.26739 | 2109523.46395 | 37.7727044515829 | -122.421685485523 | (37.7727044515829, -122.421685485523) | 8 | 2 | 9 | 28853 | 19 | |||
18144 | 70989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 779764 | 6008399.52743 | 2108738.25581 | 37.770667730873 | -122.414299143103 | (37.770667730873, -122.414299143103) | 8 | 2 | 9 | 28853 | 19 | ||
18151 | 72422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.407794192953 | (37.7632466260627, -122.407794192953) | 8 | 4 | 8 | 28859 | 19 | ||
23459 | 223514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3349 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006548.63349 | 2106093.81796 | 37.763302585471 | -122.420513683285 | (37.763302585471, -122.420513683285) | 8 | 4 | 7 | 28859 | 19 | |||
30436 | 223435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006142.1002 | 2107638.15055 | 37.7675200389439 | -122.422029465401 | (37.7675200389439, -122.422029465401) | 8 | 4 | 7 | 28853 | 19 | |||
32151 | 22922 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.422034041273 | (37.7677716622264, -122.422034041273) | 8 | 4 | 7 | 28853 | 19 | |||
34878 | 224062 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004498.44679 | 2107387.20492 | 37.7667381638479 | -122.427696765417 | (37.7667381638479, -122.427696765417) | 8 | 4 | 5 | 28862 | 3 | |||
39142 | 223599 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007767.1377 | 2106084.40018 | 37.7633453203425 | -122.416298598605 | (37.7633453203425, -122.416298598605) | 8 | 4 | 7 | 28859 | 19 | |||
39376 | 223432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006137.48741 | 2107733.43659 | 37.7677814116141 | -122.422052190377 | (37.7677814116141, -122.422052190377) | 8 | 4 | 7 | 28853 | 19 | |||
39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
42967 | 173911 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
43767 | 223603 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007689.4598 | 2107580.51877 | 37.7674489448444 | -122.416673255272 | (37.7674489448444, -122.416673255272) | 8 | 4 | 7 | 28853 | 19 | |||
44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
46431 | 173910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
51660 | 122788 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007172 | 2109097 | 37.7715837270561 | -122.418570631079 | (37.7715837270561, -122.418570631079) | 8 | 2 | 9 | 28853 | 19 | ||||
55451 | 256092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007860.62906 | 2108997.35701 | 37.7713488754693 | -122.416181558888 | (37.7713488754693, -122.416181558888) | 8 | 2 | 9 | 28853 | 19 | |||||
56042 | 100781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 211 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007785.14748 | 2109092.4486 | 37.7716057300517 | -122.416449390639 | (37.7716057300517, -122.416449390639) | 8 | 2 | 9 | 28853 | 19 | |||
56742 | 191077 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 334 12th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008423.37153 | 2108669.51917 | 37.7704803355249 | -122.414211801833 | (37.7704803355249, -122.414211801833) | 8 | 2 | 9 | 28853 | 19 | |||
60680 | 223433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006139.56315 | 2107708.41808 | 37.7677128338021 | -122.422043233108 | (37.7677128338021, -122.422043233108) | 8 | 4 | 7 | 28853 | 19 | |||
61671 | 191072 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 4 | : | Tree | Private 2 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.7703385556015 | -122.413547385421 | (37.7703385556015, -122.413547385421) | 8 | 2 | 9 | 28853 | 19 | ||
63023 | 191073 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008306.80877 | 2108790.44152 | 37.7708058118746 | -122.41462355284 | (37.7708058118746, -122.41462355284) | 8 | 2 | 9 | 28853 | 19 | |||
63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
66319 | 251315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
69970 | 191076 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 12th St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6008335.79472 | 2108708.57829 | 37.7705826631 | -122.414517495805 | (37.7705826631, -122.414517495805) | 8 | 2 | 9 | 28853 | 19 | |||
71150 | 191672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007932.20387 | 2108945.73927 | 37.7712111695782 | -122.415930321737 | (37.7712111695782, -122.415930321737) | 8 | 2 | 9 | 28853 | 19 | |||
72439 | 246381 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6006946.7351 | 2109071.9998 | 37.7715023978524 | -122.419348063063 | (37.7715023978524, -122.419348063063) | 8 | 2 | 9 | 28853 | 19 | |||
81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
82399 | 224103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006296.39827 | 2109605.75372 | 37.7729313091609 | -122.421635532653 | (37.7729313091609, -122.421635532653) | 8 | 2 | 9 | 28853 | 19 | |||
82966 | 255270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6006259.41691 | 2109543.76315 | 37.7727590125447 | -122.421759051834 | (37.7727590125447, -122.421759051834) | 8 | 2 | 9 | 28853 | 19 | ||||
93307 | 224107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006435.98558 | 2109358.16079 | 37.7722593483308 | -122.421135098612 | (37.7722593483308, -122.421135098612) | 8 | 2 | 9 | 28853 | 19 | |||
95986 | 189246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2445 Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010268.3628 | 2105949.94091 | 37.7631164563708 | -122.407638156081 | (37.7631164563708, -122.407638156081) | 8 | 4 | 8 | 28859 | 19 | |||
103339 | 191673 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007961.75494 | 2108927.69321 | 37.771163280688 | -122.415826825061 | (37.771163280688, -122.415826825061) | 8 | 2 | 9 | 28853 | 19 | |||
105198 | 223491 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.65376 | 2107931.14375 | 37.768463166072 | -122.413529054538 | (37.768463166072, -122.413529054538) | 8 | 4 | 7 | 28853 | 19 | |||
105371 | 191674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007983.0809 | 2108917.80929 | 37.7711373406456 | -122.41575235758 | (37.7711373406456, -122.41575235758) | 8 | 2 | 9 | 28853 | 19 | |||
105700 | 191671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007916.30437 | 2108953.33208 | 37.7712311237499 | -122.415985856679 | (37.7712311237499, -122.415985856679) | 8 | 2 | 9 | 28853 | 19 | |||
106066 | 191079 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1559 Howard St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6007858.27887 | 2109378.13672 | 37.7723942745191 | -122.416216661379 | (37.7723942745191, -122.416216661379) | 8 | 2 | 9 | 28853 | 19 | |||
108207 | 223605 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007673.38803 | 2107757.3509 | 37.767933580499 | -122.416741374417 | (37.767933580499, -122.416741374417) | 8 | 4 | 7 | 28853 | 19 | |||
108528 | 191677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007442.31511 | 2109225.32703 | 37.7719512972482 | -122.417644690367 | (37.7719512972482, -122.417644690367) | 8 | 2 | 9 | 28853 | 19 | |||
113656 | 223497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 305 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007806.86285 | 2106132.88029 | 37.763480669211 | -122.416164635585 | (37.763480669211, -122.416164635585) | 8 | 4 | 7 | 28859 | 19 | |||
113778 | 224106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006301.05377 | 2109500.02866 | 37.7726412760089 | -122.421611918271 | (37.7726412760089, -122.421611918271) | 8 | 2 | 9 | 28853 | 19 | |||
114851 | 192937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 394 12th St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008622.94883 | 2108550.94003 | 37.770165953233 | -122.413513072694 | (37.770165953233, -122.413513072694) | 8 | 2 | 9 | 28853 | 19 | |||
116157 | 224110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006506.1757 | 2109285.60199 | 37.7720640758221 | -122.420887151946 | (37.7720640758221, -122.420887151946) | 8 | 2 | 9 | 28853 | 19 | |||
118346 | 105752 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6004519.3 | 2107402.1 | 37.7667802417179 | -122.427625698984 | (37.7667802417179, -122.427625698984) | 8 | 4 | 5 | 28862 | 3 | |||
124259 | 189245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2445 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010120.66455 | 2105943.60701 | 37.7630907960193 | -122.408148550138 | (37.7630907960193, -122.408148550138) | 8 | 4 | 8 | 28859 | 19 | |||
127723 | 251316 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
128623 | 223651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008609.3878 | 2107944.17122 | 37.7684991461388 | -122.413517060262 | (37.7684991461388, -122.413517060262) | 8 | 4 | 7 | 28853 | 19 | |||
128807 | 223600 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007768.16924 | 2106112.90661 | 37.76342365039 | -122.416297049994 | (37.76342365039, -122.416297049994) | 8 | 4 | 7 | 28859 | 19 | |||
129574 | 22918 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006138.94284 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | 8 | 4 | 7 | 28853 | 19 | |||
138977 | 191071 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6008644.67271 | 2108598.98896 | 37.7702991041399 | -122.413441328359 | (37.7702991041399, -122.413441328359) | 8 | 2 | 9 | 28853 | 19 | |||
141455 | 224101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2x Gough St | 5 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006607.58912 | 2109275.93798 | 37.7720432565284 | -122.420535668101 | (37.7720432565284, -122.420535668101) | 8 | 2 | 9 | 28853 | 19 | |||
142294 | 224104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006259.41691 | 2109543.76315 | 37.7727590125447 | -122.421759051834 | (37.7727590125447, -122.421759051834) | 8 | 2 | 9 | 28853 | 19 | |||
145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
146915 | 191670 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007891.80002 | 2108968.36802 | 37.7712710311727 | -122.416071683472 | (37.7712710311727, -122.416071683472) | 8 | 2 | 9 | 28853 | 19 | |||
147588 | 22920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006146.18632 | 2107684.74759 | 37.767648213805 | -122.422018642617 | (37.767648213805, -122.422018642617) | 8 | 4 | 7 | 28853 | 19 | |||
150896 | 191078 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 394 12th St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6008574.85023 | 2108580.21149 | 37.7702436249715 | -122.413681516591 | (37.7702436249715, -122.413681516591) | 8 | 2 | 9 | 28853 | 19 | |||
152175 | 251317 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
152460 | 223604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007683.47887 | 2107616.29854 | 37.7675468513265 | -122.416696477566 | (37.7675468513265, -122.416696477566) | 8 | 4 | 7 | 28853 | 19 | |||
153618 | 191068 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 106 Langton St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6010213.08223 | 2110716.24311 | 37.7762005309779 | -122.408165525739 | (37.7762005309779, -122.408165525739) | 8 | 2 | 9 | 28853 | 34 | |||
154436 | 224108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006456.73439 | 2109332.89582 | 37.7721911464267 | -122.42106153229 | (37.7721911464267, -122.42106153229) | 8 | 2 | 9 | 28853 | 19 | |||
154801 | 191074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6008299.25709 | 2108795.98424 | 37.7708206066084 | -122.414650066644 | (37.7708206066084, -122.414650066644) | 8 | 2 | 9 | 28853 | 19 | |||
154941 | 223598 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007773.13763 | 2106049.50965 | 37.7632498564254 | -122.41627537542 | (37.7632498564254, -122.41627537542) | 8 | 4 | 7 | 28859 | 19 | |||
154975 | 22919 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006146.38467 | 2107662.66758 | 37.7675875985285 | -122.422016387826 | (37.7675875985285, -122.422016387826) | 8 | 4 | 7 | 28853 | 19 | |||
155159 | 223492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008606.40077 | 2107919.47331 | 37.7684311637055 | -122.413525645189 | (37.7684311637055, -122.413525645189) | 8 | 4 | 7 | 28853 | 19 | |||
156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
156315 | 192936 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 394 12th St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6008599.77798 | 2108564.43517 | 37.7702017066658 | -122.413594175352 | (37.7702017066658, -122.413594175352) | 8 | 2 | 9 | 28853 | 19 | |||
157074 | 224102 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006317.41461 | 2109580.74517 | 37.77286382673 | -122.421561058002 | (37.77286382673, -122.421561058002) | 8 | 2 | 9 | 28853 | 19 | |||
159359 | 173644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
159400 | 223596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 376 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007789.56875 | 2105780.83552 | 37.7625130634521 | -122.416199515798 | (37.7625130634521, -122.416199515798) | 8 | 4 | 7 | 28859 | 19 | |||
161023 | 116584 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 GOUGH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006450 | 2109317 | 37.7721471206774 | -122.421083698286 | (37.7721471206774, -122.421083698286) | 8 | 2 | 9 | 28853 | 19 | |||
162095 | 251319 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
163011 | 223649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1812 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008605.94683 | 2107884.16729 | 37.7683341961038 | -122.413524717993 | (37.7683341961038, -122.413524717993) | 8 | 4 | 7 | 28853 | 19 | |||
169450 | 191070 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6008653.1077 | 2108592.53019 | 37.7702818434688 | -122.413411694812 | (37.7702818434688, -122.413411694812) | 8 | 2 | 9 | 28853 | 19 | |||
176477 | 223434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006140.81563 | 2107660.72515 | 37.7675819509849 | -122.422035512441 | (37.7675819509849, -122.422035512441) | 8 | 4 | 7 | 28853 | 19 | |||
176996 | 223650 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008607.48155 | 2107905.07917 | 37.7683917014338 | -122.413520888701 | (37.7683917014338, -122.413520888701) | 8 | 4 | 7 | 28853 | 19 | |||
177048 | 223597 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007773.49389 | 2106023.20364 | 37.7631776462561 | -122.416272279958 | (37.7631776462561, -122.416272279958) | 8 | 4 | 7 | 28859 | 19 | |||
177147 | 191675 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008016.56974 | 2108896.04904 | 37.7710794746583 | -122.415634977181 | (37.7710794746583, -122.415634977181) | 8 | 2 | 9 | 28853 | 19 | |||
177393 | 223646 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3434 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006604.84709 | 2105555.01905 | 37.7618263375482 | -122.420281015175 | (37.7618263375482, -122.420281015175) | 8 | 4 | 7 | 28859 | 19 | |||
178045 | 223513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3345 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006561.96009 | 2106094.72257 | 37.7633058203343 | -122.420467655081 | (37.7633058203343, -122.420467655081) | 8 | 4 | 7 | 28859 | 19 | |||
181867 | 191069 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008685.67935 | 2108575.69988 | 37.770237460112 | -122.413297838836 | (37.770237460112, -122.413297838836) | 8 | 2 | 9 | 28853 | 19 | |||
183853 | 191678 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 194 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007565.31413 | 2109155.0801 | 37.7717653363258 | -122.417214247857 | (37.7717653363258, -122.417214247857) | 8 | 2 | 9 | 28853 | 19 | |||
183924 | 191075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6008288.60526 | 2108804.28402 | 37.7708427973966 | -122.414687499122 | (37.7708427973966, -122.414687499122) | 8 | 2 | 9 | 28853 | 19 | |||
189658 | 224100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2x Gough St | 4 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006621.45587 | 2109260.75005 | 37.7720023355618 | -122.420486623569 | (37.7720023355618, -122.420486623569) | 8 | 2 | 9 | 28853 | 19 | |||
190274 | 223601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007724 | 2106220 | 37.7637152201621 | -122.416457403809 | (37.7637152201621, -122.416457403809) | 8 | 4 | 7 | 28859 | 19 | |||
191421 | 223375 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 12 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006422.52922 | 2105783.74221 | 37.7624440827408 | -122.42092782106 | (37.7624440827408, -122.42092782106) | 8 | 4 | 7 | 28859 | 19 | |||
193613 | 191676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 288 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008127.34613 | 2108835.28118 | 37.7709188467549 | -122.415247494384 | (37.7709188467549, -122.415247494384) | 8 | 2 | 9 | 28853 | 19 | |||
56214 | 38319 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
131944 | 38317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |
138809 | 38321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
59073 | 90431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770519 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | |
114581 | 22921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6006144.43338 | 2107707.65753 | 37.7677110201932 | -122.42202633352 | (37.7677110201932, -122.42202633352) | 8 | 4 | 7 | 28853 | 19 | ||
54350 | 90432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | ||
62515 | 90438 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 48X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006368.067431 | 2109508.884182 | 37.7726693696552 | -122.421380739497 | (37.7726693696552, -122.421380739497) | 8 | 2 | 9 | 28853 | 19 | ||
73566 | 90435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006637.011883 | 2109229.055885 | 37.7719161875872 | -122.420430563972 | (37.7719161875872, -122.420430563972) | 8 | 2 | 9 | 28853 | 19 | ||
96061 | 90436 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 8 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006637.011883 | 2109229.055885 | 37.7719161875872 | -122.420430563972 | (37.7719161875872, -122.420430563972) | 8 | 2 | 9 | 28853 | 19 | ||
103270 | 90433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 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) );