trees
168 rows where Fire Prevention Districts = 8 and qSpecies_id = 8 sorted by qLegalStatus_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
42828 | 223602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280x Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 6007724 | 2106220 | 37.7637152201621 | -122.416457403809 | (37.7637152201621, -122.416457403809) | 8 | 4 | 7 | 28859 | 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 | ||||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | |
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||||
92376 | 85523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
105783 | 243307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1976 12:00:00 AM | 0 | Width 3ft | 6007430.34748 | 2106243.87464 | 37.7637642560428 | -122.417474751767 | (37.7637642560428, -122.417474751767) | 8 | 4 | 7 | 28859 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
150157 | 85520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 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 | |||
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 | |||
154045 | 85524 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
165019 | 90434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 4 | 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) );