trees
142,615 rows where qLegalStatus_id = 1 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138186 | 1 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 10 10th Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.468982710496 | (37.7866097734767, -122.468982710496) | 11 | 6 | 1 | 54 | 11 | |||
| 34993 | 10 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 97 12th St | 4 | Median : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | 8 | 2 | 9 | 28853 | 19 | |||
| 60856 | 1000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1726 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X5PL | 6001385.76767 | 2092068.06757 | 37.724498876108 | -122.437365919005 | (37.724498876108, -122.437365919005) | 9 | 7 | 6 | 28861 | 25 | |||
| 139521 | 10000 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 2X2 | 6005403.54778 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | 8 | 4 | 5 | 28853 | 19 | |||
| 135793 | 100005 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011805.43211 | 2117563.29295 | 37.7950899532827 | -122.403138864979 | (37.7950899532827, -122.403138864979) | 3 | 1 | 10 | 28860 | 4 | ||||
| 123886 | 100006 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011806.48185 | 2117548.03354 | 37.7950481132234 | -122.403134158813 | (37.7950481132234, -122.403134158813) | 3 | 1 | 10 | 28860 | 4 | ||||
| 181241 | 10001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.7687236538132 | -122.424371552702 | (37.7687236538132, -122.424371552702) | 8 | 4 | 5 | 28853 | 19 | |||
| 85685 | 100011 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011807.60069 | 2117536.15907 | 37.7950155712566 | -122.40312945177 | (37.7950155712566, -122.40312945177) | 3 | 1 | 10 | 28860 | 4 | ||||
| 148244 | 100012 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011815.13883 | 2117505.52997 | 37.7949318920521 | -122.403101213045 | (37.7949318920521, -122.403101213045) | 3 | 1 | 10 | 28860 | 4 | ||||
| 109088 | 100014 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6011819.70044 | 2117479.02475 | 37.7948593698064 | -122.403083563865 | (37.7948593698064, -122.403083563865) | 3 | 1 | 10 | 28860 | 4 | ||||
| 75648 | 100015 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6011789.64079 | 2117672.98825 | 37.795390268386 | -122.403201225768 | (37.795390268386, -122.403201225768) | 3 | 1 | 10 | 28860 | 4 | ||||
| 136656 | 100016 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011790.6974 | 2117658.0677 | 37.7953493591435 | -122.403196519624 | (37.7953493591435, -122.403196519624) | 3 | 1 | 10 | 28860 | 4 | ||||
| 25628 | 100017 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011791.69231 | 2117640.10072 | 37.7953000816886 | -122.403191812578 | (37.7953000816886, -122.403191812578) | 3 | 1 | 10 | 28860 | 4 | ||||
| 76653 | 100018 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011793.71356 | 2117622.45121 | 37.7952517332473 | -122.403183576561 | (37.7952517332473, -122.403183576561) | 3 | 1 | 10 | 28860 | 4 | ||||
| 81417 | 10002 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2014 12:50:00 PM | 3 | 3X2 | 6005473.70519 | 2108134.2356 | 37.7688444498294 | -122.424376646466 | (37.7688444498294, -122.424376646466) | 8 | 4 | 5 | 28853 | 19 | ||
| 128526 | 10003 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X2 | 6005473.24802 | 2108147.80938 | 37.7688816943622 | -122.424379193367 | (37.7688816943622, -122.424379193367) | 8 | 4 | 5 | 28853 | 19 | |||
| 174330 | 100030 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 535@Clay Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6012036.24942 | 2117732.62521 | 37.7955677864875 | -122.402352109262 | (37.7955677864875, -122.402352109262) | 3 | 1 | 10 | 28860 | 4 | ||||
| 87213 | 100031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | 3 | 1 | 10 | 28857 | 21 | |
| 30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
| 153256 | 100033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 143356 | 100035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 178352 | 100036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 151278 | 100037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 85631 | 100038 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1925 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6005164.06417 | 2116434.37592 | 37.7916171042824 | -122.426038618789 | (37.7916171042824, -122.426038618789) | 13 | 9 | 1 | 28858 | 27 | ||||
| 58737 | 100039 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1925 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6005166.77799 | 2116408.45121 | 37.7915460749308 | -122.426027382675 | (37.7915460749308, -122.426027382675) | 13 | 9 | 1 | 28858 | 27 | ||||
| 119271 | 10004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.7688211546939 | -122.424619539876 | (37.7688211546939, -122.424619539876) | 8 | 4 | 5 | 28853 | 19 | |||
| 57848 | 100040 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1925 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6005169.80466 | 2116390.62846 | 37.7914973092018 | -122.426015641131 | (37.7914973092018, -122.426015641131) | 13 | 9 | 1 | 28858 | 27 | ||||
| 113537 | 100041 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1925 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005173.38835 | 2116375.34408 | 37.7914555446772 | -122.426002153097 | (37.7914555446772, -122.426002153097) | 13 | 9 | 1 | 28858 | 27 | ||||
| 5697 | 100042 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1925 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005174.91003 | 2116356.5458 | 37.7914040153291 | -122.425995549348 | (37.7914040153291, -122.425995549348) | 13 | 9 | 1 | 28858 | 27 | ||||
| 84856 | 100047 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 191@ 23rd Ave 23rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 5988664 | 2114068 | 37.7841733536199 | -122.482954484434 | (37.7841733536199, -122.482954484434) | 11 | 6 | 2 | 55 | 26 | ||||
| 153196 | 10005 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 156 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005408.68432 | 2108096.72474 | 37.7687377821415 | -122.424598880629 | (37.7687377821415, -122.424598880629) | 8 | 4 | 5 | 28853 | 19 | |||
| 189744 | 10006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 165 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1991 12:00:00 AM | 6 | 3X2 | 6005478.90232 | 2108028.91066 | 37.7685555462362 | -122.42435117769 | (37.7685555462362, -122.42435117769) | 8 | 4 | 5 | 28853 | 19 | ||
| 72431 | 10007 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005407.88099 | 2108072.95104 | 37.7686724598889 | -122.424599967939 | (37.7686724598889, -122.424599967939) | 8 | 4 | 5 | 28853 | 19 | |||
| 142036 | 100076 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 262 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776532 | 5990584.51145 | 2113652.92092 | 37.783145223942 | -122.476279940242 | (37.783145223942, -122.476279940242) | 11 | 6 | 2 | 54 | 26 | |
| 61328 | 100078 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 266 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776410 | 5990586.53381 | 2113609.7978 | 37.7830269371305 | -122.476269792865 | (37.7830269371305, -122.476269792865) | 11 | 6 | 2 | 54 | 26 | |
| 175764 | 100079 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1451 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x6 | 5982451.9345 | 2105243.3429 | 37.7595799838686 | -122.503791871245 | (37.7595799838686, -122.503791871245) | 1 | 8 | 3 | 56 | 35 | |||
| 68163 | 10008 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005410.95643 | 2108039.08035 | 37.7685796327732 | -122.424586920555 | (37.7685796327732, -122.424586920555) | 8 | 4 | 5 | 28853 | 19 | |||
| 170162 | 100080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774752 | 6007001 | 2113322 | 37.7831749319814 | -122.419461922492 | (37.7831749319814, -122.419461922492) | 7 | 9 | 9 | 28858 | 36 | |
| 179824 | 100088 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003201.40964 | 2118956.65929 | 37.7984315255609 | -122.433009662373 | (37.7984315255609, -122.433009662373) | 13 | 9 | 1 | 57 | 17 | |||
| 159081 | 100089 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.433055234626 | (37.7984262977915, -122.433055234626) | 13 | 9 | 1 | 57 | 17 | |||
| 84704 | 10009 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005412.73113 | 2108018.38384 | 37.7685229053392 | -122.4245793096 | (37.7685229053392, -122.4245793096) | 8 | 4 | 5 | 28853 | 19 | |||
| 149997 | 1001 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | 9 | 7 | 6 | 28861 | 25 | |||
| 162681 | 10010 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 174 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2002 12:00:00 AM | 6 | 3x3 | 6005413.24282 | 2107997.40019 | 37.7684653181587 | -122.424576046874 | (37.7684653181587, -122.424576046874) | 8 | 4 | 5 | 28853 | 19 | ||
| 108815 | 10011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.7681902730979 | -122.424555388522 | (37.7681902730979, -122.424555388522) | 8 | 4 | 5 | 28853 | 19 | |||
| 154195 | 100125 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6005967.88782 | 2116944.18436 | 37.7930623076392 | -122.423293649581 | (37.7930623076392, -122.423293649581) | 13 | 9 | 1 | 28858 | 27 | ||||
| 127780 | 100126 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6005948.98718 | 2116940.10629 | 37.7930500435754 | -122.423358756926 | (37.7930500435754, -122.423358756926) | 13 | 9 | 1 | 28858 | 27 | ||||
| 56463 | 100127 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6005919.01328 | 2116937.33835 | 37.7930407517779 | -122.423462271584 | (37.7930407517779, -122.423462271584) | 13 | 9 | 1 | 28858 | 27 | ||||
| 82331 | 100128 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6005897.30712 | 2116933.8296 | 37.7930298924771 | -122.423537126645 | (37.7930298924771, -122.423537126645) | 13 | 9 | 1 | 28858 | 27 | ||||
| 156977 | 100129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011082.10119 | 2112775.22352 | 37.7819026320456 | -122.405304366814 | (37.7819026320456, -122.405304366814) | 12 | 2 | 9 | 28853 | 34 | |
| 100677 | 10013 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.424272225299 | (37.7676948680391, -122.424272225299) | 8 | 4 | 5 | 28853 | 19 | |||
| 181095 | 100130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011065.09249 | 2112790.58254 | 37.7819438533601 | -122.405364291326 | (37.7819438533601, -122.405364291326) | 12 | 2 | 9 | 28853 | 34 | |
| 143498 | 100131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011051.59118 | 2112804.91213 | 37.7819824441767 | -122.405412009362 | (37.7819824441767, -122.405412009362) | 12 | 2 | 9 | 28853 | 34 | |
| 70912 | 100132 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011001.43438 | 2112862.15185 | 37.7821368065155 | -122.405589562524 | (37.7821368065155, -122.405589562524) | 12 | 2 | 9 | 28853 | 34 | |
| 109349 | 100133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010986.38868 | 2112879.38733 | 37.7821832897709 | -122.405642828459 | (37.7821832897709, -122.405642828459) | 12 | 2 | 9 | 28853 | 34 | |
| 181514 | 100134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010970.10593 | 2112898.88439 | 37.782235913593 | -122.405700533469 | (37.782235913593, -122.405700533469) | 12 | 2 | 9 | 28853 | 34 | |
| 143275 | 100136 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010957.25903 | 2112913.83939 | 37.7822762580963 | -122.405746031954 | (37.7822762580963, -122.405746031954) | 12 | 2 | 9 | 28853 | 34 | |
| 5282 | 10014 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 224 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:44:00 AM | 3 | 2x3 | 6005430.43675 | 2107671.80391 | 37.7675722796594 | -122.424493411759 | (37.7675722796594, -122.424493411759) | 8 | 4 | 5 | 28853 | 19 | ||
| 10710 | 10015 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 232 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2019 12:00:00 AM | 3 | 3x3 | 6005430.70254 | 2107623.59079 | 37.7674399129618 | -122.424489062615 | (37.7674399129618, -122.424489062615) | 8 | 4 | 5 | 28853 | 19 | ||
| 48746 | 100153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.466099823613 | (37.7773444498569, -122.466099823613) | 11 | 6 | 2 | 54 | 11 | |||
| 41837 | 100154 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995548.20979 | 2113421.38615 | 37.7827960924124 | -122.459090895565 | (37.7827960924124, -122.459090895565) | 11 | 6 | 2 | 54 | 11 | |
| 138493 | 100155 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768665 | 5995547.63901 | 2113410.08576 | 37.7827650317513 | -122.459092051698 | (37.7827650317513, -122.459092051698) | 11 | 6 | 2 | 54 | 11 | |
| 185437 | 100156 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995549.3318 | 2113386.41255 | 37.7827001287608 | -122.459084480701 | (37.7827001287608, -122.459084480701) | 11 | 6 | 2 | 54 | 11 | |
| 11894 | 10016 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 236 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:59:00 AM | 3 | 3x3 | 6005434.04749 | 2107587.52272 | 37.7673410675527 | -122.42447492707 | (37.7673410675527, -122.42447492707) | 8 | 4 | 5 | 28853 | 19 | ||
| 94130 | 100160 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1699 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 28164 | 6005505.58523 | 2118187.22554 | 37.7964492830571 | -122.424981725648 | (37.7964492830571, -122.424981725648) | 13 | 9 | 1 | 28858 | 27 | |||
| 38359 | 100161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 28164 | 6005519.03005 | 2118189.86695 | 37.7964572951359 | -122.424935391656 | (37.7964572951359, -122.424935391656) | 13 | 9 | 1 | 28858 | 27 | |||
| 115639 | 100162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 28164 | 6005532.34096 | 2118193.08724 | 37.7964668890905 | -122.424889562218 | (37.7964668890905, -122.424889562218) | 13 | 9 | 1 | 28858 | 27 | |||
| 87452 | 100163 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1814 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004278.90656 | 2118759.95598 | 37.7979524872736 | -122.429267157958 | (37.7979524872736, -122.429267157958) | 13 | 9 | 1 | 57 | 17 | ||||
| 68208 | 100164 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008231.9319 | 2115379.46118 | 37.7888934760005 | -122.41534908182 | (37.7888934760005, -122.41534908182) | 13 | 1 | 10 | 28858 | 21 | |||
| 99569 | 100165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008234.89338 | 2115366.55149 | 37.7888581955857 | -122.415337921201 | (37.7888581955857, -122.415337921201) | 13 | 1 | 10 | 28858 | 21 | |||
| 164886 | 100169 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 180X Manchester St | Back Yard : Yard | Tree | DPW 1 | Adjacent to rear of property - DPW parcel | 6008242 | 2099158 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | 2 | 7 | 7 | 28859 | 2 | |||||
| 166798 | 10017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2012 12:00:00 AM | 1 | 3x3 | 6005435.61743 | 2107572.1515 | 37.7672989505107 | -122.424468403392 | (37.7672989505107, -122.424468403392) | 8 | 4 | 5 | 28853 | 19 | ||
| 171295 | 100170 | DPW Maintained 1 | Tree(s) :: 17 | 2149 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769012 | 5997531 | 2110183 | 37.7740181145799 | -122.451997596236 | (37.7740181145799, -122.451997596236) | 15 | 5 | 11 | 29492 | 16 | |
| 148324 | 100175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1140 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 3x3 | Permit Number 768230 | 6001099 | 2109378.2 | 37.772012061027 | -122.439597598173 | (37.772012061027, -122.439597598173) | 15 | 5 | 11 | 29492 | 9 | ||
| 100479 | 100181 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6013794.16577 | 2112184.81721 | 37.7804327665865 | -122.39588042504 | (37.7804327665865, -122.39588042504) | 6 | 2 | 9 | 28856 | 34 | ||||
| 2882 | 100182 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966 | (37.7803937971776, -122.39583053966) | 6 | 2 | 9 | 28856 | 34 | ||||
| 126592 | 100184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 480 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6006818.05082 | 2091764.69226 | 37.7239732025834 | -122.418565697766 | (37.7239732025834, -122.418565697766) | 9 | 7 | 7 | 309 | 28 | |||
| 137124 | 100186 | DPW Maintained 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 2445 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008897 | 2104213 | 37.7582703522428 | -122.41225848425 | (37.7582703522428, -122.41225848425) | 2 | 4 | 7 | 28859 | 19 | |||
| 84320 | 100189 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 160 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 772698 | 5995944.7835 | 2113256.71049 | 37.7823667267913 | -122.457707006716 | (37.7823667267913, -122.457707006716) | 11 | 6 | 1 | 54 | 31 | ||
| 102142 | 100197 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 21 | Permit Number 769099 | 5994240.47669 | 2115083.18474 | 37.7872836759267 | -122.463735720083 | (37.7872836759267, -122.463735720083) | 11 | 6 | 1 | 54 | 11 | ||
| 12340 | 100198 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 22 | Permit Number 769099 | 5994239.22854 | 2115068.80691 | 37.7872441264014 | -122.463738994433 | (37.7872441264014, -122.463738994433) | 11 | 6 | 1 | 54 | 11 | ||
| 29237 | 1002 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1731 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | 9 | 7 | 6 | 28861 | 25 | |||
| 107304 | 10020 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.424441220501 | (37.767158847823, -122.424441220501) | 8 | 4 | 5 | 28853 | 19 | |||
| 43509 | 100201 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 255 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 51875 | 6008346.92713 | 2112747.04212 | 37.7816719523255 | -122.414764839028 | (37.7816719523255, -122.414764839028) | 7 | 10 | 9 | 28852 | 36 | ||
| 59943 | 100203 | DPW Maintained 1 | Shrub :: Shrub 66 | 2237 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6001906 | 2114287 | 37.7855362863546 | -122.437157652203 | (37.7855362863546, -122.437157652203) | 13 | 6 | 11 | 29490 | 13 | |||
| 47901 | 100204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | 13 | 6 | 11 | 29490 | 13 | |||
| 193537 | 100208 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 634 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x10 | 5992873.67037 | 2111136.23263 | 37.7763675669424 | -122.468177309737 | (37.7763675669424, -122.468177309737) | 11 | 6 | 2 | 54 | 11 | |||
| 8493 | 10021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 274 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2018 12:00:00 AM | 3 | 3x4 | 6005443.44254 | 2107417.66285 | 37.7668752034469 | -122.424430347706 | (37.7668752034469, -122.424430347706) | 8 | 4 | 5 | 28853 | 19 | ||
| 64775 | 100211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | 1 | Permit Number 769013 | 6011855.60136 | 2105068.89592 | 37.7607860251716 | -122.402086457638 | (37.7607860251716, -122.402086457638) | 10 | 3 | 8 | 28856 | 29 | ||
| 34760 | 100212 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 769013 | 6011854.68115 | 2105077.88991 | 37.7608106693075 | -122.402090272569 | (37.7608106693075, -122.402090272569) | 10 | 3 | 8 | 28856 | 29 | |||
| 134278 | 100213 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768999 | 5994920.57635 | 2114719.03859 | 37.786322995296 | -122.461356328132 | (37.786322995296, -122.461356328132) | 11 | 6 | 1 | 54 | 11 | |
| 78025 | 100214 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001088.1 | 2111178.5 | 37.7769546116117 | -122.439764396806 | (37.7769546116117, -122.439764396806) | 15 | 5 | 11 | 29492 | 41 | |||
| 57105 | 10022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.7667677623348 | -122.424419474005 | (37.7667677623348, -122.424419474005) | 8 | 4 | 5 | 28853 | 19 | ||
| 104977 | 100229 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 701X 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778265 | 5983807.97543 | 2110975.72776 | 37.7753991192247 | -122.499525725678 | (37.7753991192247, -122.499525725678) | 11 | 6 | 2 | 55 | 26 | |
| 76339 | 100230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983807.86909 | 2110960.60417 | 37.7753575879766 | -122.499524975598 | (37.7753575879766, -122.499524975598) | 11 | 6 | 2 | 55 | 26 | |||
| 66205 | 100231 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701X 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5983808.57379 | 2110941.00961 | 37.7753038283226 | -122.499521089497 | (37.7753038283226, -122.499521089497) | 11 | 6 | 2 | 55 | 26 | |||
| 182535 | 100232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983809.61939 | 2110917.38856 | 37.7752390330911 | -122.499515726535 | (37.7752390330911, -122.499515726535) | 11 | 6 | 2 | 55 | 26 | |||
| 82811 | 100233 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701X 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983810.5742 | 2110902.60741 | 37.7751985043441 | -122.499511331076 | (37.7751985043441, -122.499511331076) | 11 | 6 | 2 | 55 | 26 | |||
| 178489 | 100234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983811.49615 | 2110876.46915 | 37.7751267903243 | -122.499506209788 | (37.7751267903243, -122.499506209788) | 11 | 6 | 2 | 55 | 26 | |||
| 192326 | 100235 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701X 39th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5983812.70051 | 2110831.28107 | 37.7750027875677 | -122.499498703477 | (37.7750027875677, -122.499498703477) | 11 | 6 | 2 | 55 | 26 |
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) );