trees
3,587 rows where qSpecies_id = 28 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95012 | 100000 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
50134 | 100004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
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 | ||||
60809 | 100009 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
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 | ||||
175170 | 100019 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
72619 | 100020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
129974 | 100021 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
124561 | 100022 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
33339 | 100023 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
160909 | 100025 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
29882 | 100026 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
44949 | 100027 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
143924 | 100028 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
57271 | 100029 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
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 | |||
102360 | 100090 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 11X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007856.7 | 2107724 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | 8 | 4 | 7 | 28853 | 19 | |||
16242 | 100094 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 11X Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007856.7 | 2107724 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | 8 | 4 | 7 | 28853 | 19 | |||
159845 | 100167 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
24948 | 100206 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006736.3 | 2098711.7 | 37.7430435558186 | -122.4193408869 | (37.7430435558186, -122.4193408869) | 2 | 7 | 7 | 28859 | 2 | ||||
171128 | 100463 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 197 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000813.5 | 2094900.3 | 37.732242985333 | -122.439547106485 | (37.732242985333, -122.439547106485) | 9 | 7 | 4 | 63 | 40 | |||||
29258 | 100577 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1201 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5982377.2 | 2106858.6 | 37.7640106245379 | -122.504169987001 | (37.7640106245379, -122.504169987001) | 1 | 8 | 3 | 56 | 35 | |||
69740 | 100897 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
108059 | 100898 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
134640 | 100899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
69293 | 100901 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 4x4 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
139282 | 100902 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
74775 | 100903 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
125348 | 100904 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
85109 | 100905 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
41984 | 100907 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
145675 | 100909 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 111x 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
165053 | 100910 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
122721 | 101132 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1477 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||||
49751 | 101134 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1477 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||||
25000 | 101302 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 385 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |||
165379 | 101303 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 385 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |||
44972 | 101304 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 385 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |||
29983 | 101305 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010065.3 | 2110009.9 | 37.7742528016184 | -122.408626907078 | (37.7742528016184, -122.408626907078) | 8 | 2 | 9 | 28853 | 34 | |||
182986 | 101306 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010065.3 | 2110009.9 | 37.7742528016184 | -122.408626907078 | (37.7742528016184, -122.408626907078) | 8 | 2 | 9 | 28853 | 34 | |||
42032 | 101361 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1303 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007113.6 | 2115829 | 37.7900648810449 | -122.419250267251 | (37.7900648810449, -122.419250267251) | 13 | 9 | 10 | 28858 | 21 | ||||
83354 | 101437 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 31X College Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | 2 | 7 | 5 | 28861 | 2 | |||||
110962 | 101442 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 31X College Ave | 3 | Front Yard : Yard | Tree | DPW 1 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | 2 | 7 | 5 | 28861 | 2 | |||||
156633 | 101448 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 31X College Ave | 4 | Front Yard : Yard | Tree | DPW 1 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | 2 | 7 | 5 | 28861 | 2 | |||||
118040 | 101610 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 623 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 7x9 | 6011000.03713 | 2105307.95179 | 37.7613946287669 | -122.405062321479 | (37.7613946287669, -122.405062321479) | 10 | 3 | 8 | 28856 | 29 | |||
179254 | 10169 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005766.4364 | 2102791.42728 | 37.7541908811074 | -122.422984319668 | (37.7541908811074, -122.422984319668) | 2 | 4 | 5 | 28859 | 19 | |||
161799 | 102315 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2325 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x6 | 6010497.0299 | 2105967.33167 | 37.7631770050447 | -122.406848495572 | (37.7631770050447, -122.406848495572) | 8 | 4 | 8 | 28859 | 19 | |||
125642 | 102316 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2325 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x6 | 6010512.04072 | 2105967.73717 | 37.7631789583664 | -122.406796606491 | (37.7631789583664, -122.406796606491) | 8 | 4 | 8 | 28859 | 19 | |||
51951 | 102319 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3200X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008156.4 | 2105059 | 37.760551689018 | -122.414879686077 | (37.760551689018, -122.414879686077) | 2 | 4 | 7 | 28859 | 19 | |||
20149 | 102321 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3200X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008156.4 | 2105059 | 37.760551689018 | -122.414879686077 | (37.760551689018, -122.414879686077) | 2 | 4 | 7 | 28859 | 19 | |||
154529 | 102322 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3200X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008156.4 | 2105059 | 37.760551689018 | -122.414879686077 | (37.760551689018, -122.414879686077) | 2 | 4 | 7 | 28859 | 19 | |||
126641 | 102334 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201X 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | 2 | 4 | 7 | 28859 | 19 | |||
47881 | 102348 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Shotwell St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |||
6425 | 102410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
69228 | 102411 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
43947 | 102413 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1301 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6000345 | 2109213 | 37.7715155205087 | -122.442193873774 | (37.7715155205087, -122.442193873774) | 15 | 5 | 11 | 29492 | 9 | ||||
178182 | 102414 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1301 Page St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6000345 | 2109213 | 37.7715155205087 | -122.442193873774 | (37.7715155205087, -122.442193873774) | 15 | 5 | 11 | 29492 | 9 | |||||
56570 | 102458 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3267 20th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008409 | 2104449 | 37.7588909590293 | -122.413962902008 | (37.7588909590293, -122.413962902008) | 2 | 4 | 7 | 28859 | 19 | ||||
112387 | 102481 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 38 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007376 | 2099321 | 37.7447525653734 | -122.417172137784 | (37.7447525653734, -122.417172137784) | 2 | 7 | 7 | 28859 | 2 | |||
98345 | 102484 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1501X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999365.6 | 2109075.3 | 37.7710815652008 | -122.445571755181 | (37.7710815652008, -122.445571755181) | 15 | 5 | 11 | 29492 | 9 | ||||
157696 | 102605 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
30430 | 102606 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
129237 | 102733 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 227 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6x12 | 5987865.55593 | 2115301.49013 | 37.7875136738907 | -122.485807345479 | (37.7875136738907, -122.485807345479) | 11 | 6 | 1 | 55 | 33 | |||
158183 | 102845 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Ripley St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009339 | 2099105 | 37.744269714821 | -122.410369184032 | (37.744269714821, -122.410369184032) | 2 | 7 | 7 | 28859 | 2 | |||
87957 | 102863 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2750X Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x7 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.441054886769 | (37.792711153164, -122.441054886769) | 13 | 6 | 1 | 29490 | 27 | ||||
61157 | 102864 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2750X Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x7.5 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.441054886769 | (37.792711153164, -122.441054886769) | 13 | 6 | 1 | 29490 | 27 | ||||
116070 | 102865 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2750X Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x7 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.441054886769 | (37.792711153164, -122.441054886769) | 13 | 6 | 1 | 29490 | 27 | ||||
169352 | 103020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 40X Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | See 61 Fair Ave property permits | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 | |
72553 | 103455 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 953 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x9 | 6001548 | 2088631 | 37.7150706812167 | -122.436559205883 | (37.7150706812167, -122.436559205883) | 9 | 7 | 6 | 28861 | 5 | ||||
42596 | 103592 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
65764 | 103594 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
30511 | 103595 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
87538 | 103597 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31425 | 103598 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
156763 | 103599 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
151595 | 103669 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 20 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2016 12:00:00 AM | 3 | 3x3 | 6010632.36965 | 2089377.76421 | 37.7176331925972 | -122.405212129663 | (37.7176331925972, -122.405212129663) | 10 | 7 | 8 | 309 | 39 | ||
105204 | 104329 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002780 | 2106787 | 37.7649927917452 | -122.433597678013 | (37.7649927917452, -122.433597678013) | 15 | 5 | 5 | 28862 | 3 | ||||
133594 | 104367 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010110.7474 | 2087906.11213 | 37.7135631610019 | -122.406911484727 | (37.7135631610019, -122.406911484727) | 9 | 7 | 8 | 309 | 39 | |||||
50190 | 104428 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 390 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 6010699.78768 | 2089233.16834 | 37.7172399307634 | -122.404968919684 | (37.7172399307634, -122.404968919684) | 10 | 7 | 8 | 309 | 39 | |||
168693 | 104429 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 390 Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010684.07078 | 2089238.89414 | 37.7172547740586 | -122.405023648815 | (37.7172547740586, -122.405023648815) | 10 | 7 | 8 | 309 | 39 | |||
14878 | 104430 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 73-75 MIRABEL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 770914 | 6007834 | 2100080 | 37.7468623651304 | -122.415642186435 | (37.7468623651304, -122.415642186435) | 2 | 7 | 7 | 28859 | 2 | ||
33433 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
35139 | 104434 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
146533 | 104435 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 4 | Front Yard : Yard | Tree | Private 2 | 16 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
167961 | 104436 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 5992040 | 2096369 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | 1 | 8 | 4 | 59 | 40 | ||||
90905 | 104524 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 43X BONVIEW ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | |||||
149976 | 104650 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 346 LAKE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.463222305141 | (37.7868637456835, -122.463222305141) | 11 | 6 | 1 | 54 | 11 | ||||
150631 | 104803 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 101X5 Surrey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | Permit Number 776355 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | 2 | 7 | 5 | 63 | 7 | ||
151950 | 104804 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 101X Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | 2 | 7 | 5 | 63 | 7 | |||
146501 | 104806 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 101X4 Surrey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | Permit Number 776355 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | 2 | 7 | 5 | 63 | 7 | ||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
193712 | 104914 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 614 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
104508 | 104915 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 701 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 |
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) );