trees
129 rows where Police Districts = 2 and qSpecies_id = 8 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159134 | 85529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | 8 | 2 | 9 | 28853 | 19 | ||
113152 | 85530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.50444 | 37.7722888802537 | -122.418030010287 | (37.7722888802537, -122.418030010287) | 8 | 2 | 9 | 28853 | 19 | |||
125971 | 85531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007317.96828 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | 8 | 2 | 9 | 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 | |||
64496 | 85535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.58584 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | 8 | 2 | 9 | 28853 | 19 | |||
81603 | 85537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007421.29052 | 2109238.78217 | 37.7719870587743 | -122.417718370032 | (37.7719870587743, -122.417718370032) | 8 | 2 | 9 | 28853 | 19 | |||
104744 | 85536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007398.39847 | 2109252.27561 | 37.7720228203246 | -122.417798512189 | (37.7720228203246, -122.417798512189) | 8 | 2 | 9 | 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 | |||
118077 | 85533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007332.25294 | 2109288.61069 | 37.7721188652314 | -122.418029891562 | (37.7721188652314, -122.418029891562) | 8 | 2 | 9 | 28853 | 19 | |||
149622 | 85534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007347.01879 | 2109279.74931 | 37.7720953650306 | -122.417978186861 | (37.7720953650306, -122.417978186861) | 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 | |||
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 | ||||
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 | |||
76303 | 85538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.7718521865557 | -122.417404262918 | (37.7718521865557, -122.417404262918) | 8 | 2 | 9 | 28853 | 19 | |||
80770 | 85540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 8 | 2 | 9 | 28853 | 19 | |||
119852 | 85539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007548.32218 | 2109164.73144 | 37.7717908806656 | -122.417273708325 | (37.7717908806656, -122.417273708325) | 8 | 2 | 9 | 28853 | 19 | |||
194004 | 85541 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 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 | |||
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 | ||
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 | |||
9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
160632 | 191058 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011781.36835 | 2111952.66121 | 37.7796831376017 | -122.402827343412 | (37.7796831376017, -122.402827343412) | 14 | 2 | 9 | 28856 | 34 | |||
95257 | 110438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775407 | 6007788.2 | 2109003.3 | 37.7713611206973 | -122.416432516069 | (37.7713611206973, -122.416432516069) | 8 | 2 | 9 | 28853 | 19 | |
70118 | 85528 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007748.883838 | 2109107.739625 | 37.771645676205 | -122.416575912394 | (37.771645676205, -122.416575912394) | 8 | 2 | 9 | 28853 | 19 | |||
31166 | 191060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.403252800969 | (37.7789796735174, -122.403252800969) | 14 | 2 | 9 | 28856 | 34 | |||
68081 | 191061 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | 14 | 2 | 9 | 28856 | 34 | |||
88212 | 191064 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6011636.45479 | 2111621.63376 | 37.7787661204973 | -122.403305371746 | (37.7787661204973, -122.403305371746) | 14 | 2 | 9 | 28856 | 34 | |||
92791 | 191062 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011643.64166 | 2111627.47024 | 37.7787825475055 | -122.403280920094 | (37.7787825475055, -122.403280920094) | 14 | 2 | 9 | 28856 | 34 | |||
153520 | 191063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6011640.41223 | 2111625.07225 | 37.7787757828176 | -122.403291923287 | (37.7787757828176, -122.403291923287) | 14 | 2 | 9 | 28856 | 34 | |||
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 | |||||
65939 | 85545 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
96936 | 85544 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
104675 | 85543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
116707 | 85542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007856.45059 | 2108988.34971 | 37.7713239085987 | -122.416195374412 | (37.7713239085987, -122.416195374412) | 8 | 2 | 9 | 28853 | 19 | |||
128307 | 191669 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 2 | Width 3ft | 6007874.13645 | 2108978.90348 | 37.771298965913 | -122.416133528945 | (37.771298965913, -122.416133528945) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
104786 | 191065 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Clara St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011631.45196 | 2111618.92007 | 37.7787583899224 | -122.403322487638 | (37.7787583899224, -122.403322487638) | 14 | 2 | 9 | 28856 | 34 | |||
14957 | 85546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
105140 | 85550 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
112674 | 85547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
129518 | 85548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | ||||
163766 | 85549 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 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 | |||
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 | |||
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 | |||
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 | |||
109402 | 255703 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782078 | 6009781.99069 | 2112750.42942 | 37.7817617797421 | -122.409800416291 | (37.7817617797421, -122.409800416291) | 14 | 2 | 9 | 28853 | 34 | |
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 | |||
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 | |||
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 | |||
92559 | 91019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
124716 | 91020 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
161508 | 91021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
32023 | 85527 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
43105 | 85526 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
124170 | 85525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 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 | |||
94102 | 28997 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008985.04718 | 2109404.34917 | 37.7725295406243 | -122.412320901705 | (37.7725295406243, -122.412320901705) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
17998 | 85553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 332 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008375 | 2108695 | 37.7705475827471 | -122.414380922989 | (37.7705475827471, -122.414380922989) | 8 | 2 | 9 | 28853 | 19 | |||
1156 | 31893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.7706159506067 | -122.414182168285 | (37.7706159506067, -122.414182168285) | 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 | |||
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 | ||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
69618 | 191057 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 351 Saint Francis Pl | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013212.85575 | 2113183.51616 | 37.78314260738 | -122.397961541709 | (37.78314260738, -122.397961541709) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
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 | |||
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 | |||
136185 | 28906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.7795285306637 | -122.402635398413 | (37.7795285306637, -122.402635398413) | 14 | 2 | 9 | 28856 | 34 | |
9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
70902 | 85555 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
99188 | 85556 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
24502 | 191066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011926.00282 | 2111797.31864 | 37.7792646776498 | -122.40231606173 | (37.7792646776498, -122.40231606173) | 14 | 2 | 9 | 28856 | 34 | |||
108598 | 191067 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2014 12:00:00 AM | 8 | Width 3ft | 6011934.76855 | 2111785.94153 | 37.779233928048 | -122.402284937117 | (37.779233928048, -122.402284937117) | 14 | 2 | 9 | 28856 | 34 | ||
18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
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 | |||
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 | |||
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 | ||
125701 | 85558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008677.32979 | 2108520.19339 | 37.7700845834737 | -122.413322794134 | (37.7700845834737, -122.413322794134) | 8 | 2 | 9 | 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 | |||
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 | |||
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 | |||
187727 | 85557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008653.68072 | 2108532.35146 | 37.7701166389055 | -122.413405456202 | (37.7701166389055, -122.413405456202) | 8 | 2 | 9 | 28853 | 19 | |||
21310 | 254733 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3x3 | 6008656 | 2108503 | 37.7700361768699 | -122.413395357755 | (37.7700361768699, -122.413395357755) | 8 | 2 | 9 | 28853 | 19 | |||
156242 | 254734 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3x3 | 6008656 | 2108503 | 37.7700361768699 | -122.413395357755 | (37.7700361768699, -122.413395357755) | 8 | 2 | 9 | 28853 | 19 | |||
15449 | 85521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
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 |
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) );