trees
969 rows where qSpecies_id = 97 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189333 | 224619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1324 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999058.14954 | 2104997.17372 | 37.7598664980489 | -122.446341813123 | (37.7598664980489, -122.446341813123) | 15 | 5 | 5 | 28862 | 3 | |||
33799 | 112160 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | 14 | 3 | 8 | 28856 | 29 | |||
94326 | 62670 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1328 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23002 | 6002790.04269178 | 2111680.73625558 | 37.7784303546549 | -122.433912768351 | (37.7784303546549, -122.433912768351) | 15 | 5 | 11 | 29490 | 41 | ||
90779 | 226499 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 133 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6005600.01114 | 2099028.12585 | 37.7438483268298 | -122.42329235907 | (37.7438483268298, -122.42329235907) | 2 | 7 | 5 | 28859 | 22 | |||
178899 | 61526 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | 11 | 6 | 2 | 54 | 26 | ||
187823 | 199429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1340 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013567.84766 | 2105719.02996 | 37.7626665705253 | -122.396210084142 | (37.7626665705253, -122.396210084142) | 14 | 3 | 8 | 28856 | 29 | |||
76352 | 61525 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.473716580773 | (37.7861960776153, -122.473716580773) | 11 | 6 | 2 | 54 | 26 | ||
135538 | 34978 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.7603911107583 | -122.433757281047 | (37.7603911107583, -122.433757281047) | 2 | 4 | 5 | 28862 | 3 | |||
90119 | 61733 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.427284356874 | (37.7492349189645, -122.427284356874) | 2 | 4 | 5 | 28862 | 22 | ||
23203 | 6798 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.384038431137 | (37.7394266247399, -122.384038431137) | 10 | 3 | 8 | 58 | 1 | |||
124236 | 30843 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | 10 | 3 | 8 | 28856 | 29 | ||
129099 | 10222 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | 2 | 4 | 5 | 28859 | 19 | |||
184130 | 224683 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1380 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006412.3793 | 2101568.56601 | 37.7508696128423 | -122.420663681196 | (37.7508696128423, -122.420663681196) | 2 | 4 | 5 | 28859 | 19 | |||
40635 | 24450 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.420651186023 | (37.7507621663522, -122.420651186023) | 2 | 4 | 5 | 28859 | 19 | |||
177810 | 23094 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1384 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1992 12:00:00 AM | 3 | 3x3 | 6006412.34173 | 2101544.72785 | 37.7508041565902 | -122.420662119057 | (37.7508041565902, -122.420662119057) | 2 | 4 | 5 | 28859 | 19 | ||
35053 | 224682 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.7506386642487 | -122.420640252069 | (37.7506386642487, -122.420640252069) | 2 | 4 | 5 | 28859 | 19 | |||
77938 | 224680 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006416.17369 | 2101511.36496 | 37.7507127656919 | -122.420646499657 | (37.7507127656919, -122.420646499657) | 2 | 4 | 5 | 28859 | 19 | |||
180250 | 224681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006415.87838 | 2101496.97772 | 37.7506732449771 | -122.420646499655 | (37.7506732449771, -122.420646499655) | 2 | 4 | 5 | 28859 | 19 | |||
111571 | 224487 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6007167.09986 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | 2 | 7 | 7 | 28859 | 2 | |||
170253 | 224641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.419323735419 | (37.7460721011655, -122.419323735419) | 2 | 7 | 7 | 28859 | 2 | |||
174424 | 224640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006790.58194 | 2099800.70275 | 37.7460367694939 | -122.41923042716 | (37.7460367694939, -122.41923042716) | 2 | 7 | 7 | 28859 | 2 | |||
142490 | 5334 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004762.96876 | 2107575.67846 | 37.7672706263574 | -122.426795251693 | (37.7672706263574, -122.426795251693) | 8 | 4 | 5 | 28862 | 3 | |||
128200 | 66311 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.437799727546 | (37.7336304648573, -122.437799727546) | 9 | 7 | 5 | 63 | 40 | ||
186297 | 63778 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24459 | 6004215.48168844 | 2101629.42267968 | 37.7509126493248 | -122.428265095141 | (37.7509126493248, -122.428265095141) | 2 | 4 | 5 | 28862 | 22 | ||
194157 | 224494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005454.36959 | 2096149.25289 | 37.7359353702183 | -122.423591316208 | (37.7359353702183, -122.423591316208) | 2 | 7 | 7 | 28859 | 2 | |||
30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
101216 | 199433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.392453325466 | (37.7354971746608, -122.392453325466) | 10 | 3 | 8 | 58 | 1 | |||
30441 | 116039 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008038.31567 | 2116541.76159 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | 5 | 1 | 10 | 28858 | 21 | |||
178511 | 116038 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008011.06753 | 2116537.17208 | 37.7920598504338 | -122.416195270994 | (37.7920598504338, -122.416195270994) | 5 | 1 | 10 | 28858 | 21 | |||
37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
41084 | 48790 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | ||
50226 | 48785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
58028 | 48791 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
181146 | 48788 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
3343 | 23100 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6006427.47457 | 2101357.75439 | 37.7502916230775 | -122.420596517121 | (37.7502916230775, -122.420596517121) | 2 | 4 | 5 | 28859 | 19 | |||
126791 | 23101 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | 2 | 4 | 5 | 28859 | 19 | |||
189515 | 23099 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | 2 | 4 | 5 | 28859 | 19 | |||
18694 | 255585 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 141 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2105290 | 37.7611036239675 | -122.419957321446 | (37.7611036239675, -122.419957321446) | 2 | 4 | 7 | 28859 | 19 | ||||
131423 | 5670 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | 2 | 7 | 5 | 63 | 22 | |||
189791 | 224495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005480.01407 | 2096145.74782 | 37.7359271935727 | -122.423502403815 | (37.7359271935727, -122.423502403815) | 2 | 7 | 7 | 28859 | 2 | |||
103250 | 111889 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011076.19973 | 2092521.56402 | 37.7262902239912 | -122.403899105983 | (37.7262902239912, -122.403899105983) | 10 | 3 | 7 | 309 | 28 | |||
91974 | 64063 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1421 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1988 12:00:00 AM | Permit Number 25296 | 6010151.38612308 | 2118964.80181049 | 37.7988456450066 | -122.408961074202 | (37.7988456450066, -122.408961074202) | 3 | 1 | 10 | 308 | 4 | |||
7928 | 5672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | 2 | 7 | 5 | 63 | 22 | |||
119041 | 63779 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 143 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24460 | 6004205.74848694 | 2101576.80650466 | 37.7507676268483 | -122.428295003883 | (37.7507676268483, -122.428295003883) | 2 | 4 | 5 | 28862 | 22 | ||
36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
118592 | 63854 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1437 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24553 | 6002713.14606438 | 2111964.58520586 | 37.779205368769 | -122.434199079816 | (37.779205368769, -122.434199079816) | 15 | 5 | 11 | 29490 | 41 | ||
82624 | 224655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | 2 | 7 | 7 | 28859 | 2 | |||
94866 | 30886 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.406014607975 | (37.8012494094877, -122.406014607975) | 3 | 1 | 10 | 308 | 23 | ||||
106151 | 126625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.403300781611 | (37.8033465696629, -122.403300781611) | 3 | 1 | 10 | 28860 | 6 | |||
44250 | 224525 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006711.81921 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | 2 | 4 | 7 | 28859 | 19 | |||
159096 | 224524 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | 2 | 4 | 7 | 28859 | 19 | |||
69007 | 64894 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1450 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/1989 12:00:00 AM | Permit Number 25920 | 6005836.52150612 | 2100535.66309095 | 37.7480010261231 | -122.422581663865 | (37.7480010261231, -122.422581663865) | 2 | 4 | 5 | 28859 | 19 | ||
167803 | 41049 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.7512256245579 | -122.402335016202 | (37.7512256245579, -122.402335016202) | 10 | 3 | 8 | 28856 | 29 | ||
104901 | 104050 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 145X Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012363 | 2119165 | 37.7995189786281 | -122.401322196982 | (37.7995189786281, -122.401322196982) | 3 | 1 | 10 | 28860 | 6 | |||||
74260 | 176431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 146 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008376.30406 | 2087394.4749 | 37.7120611046958 | -122.412870211214 | (37.7120611046958, -122.412870211214) | 9 | 7 | 8 | 309 | 39 | |||
118335 | 64335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 148 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25163 | 6004614.99091661 | 2097575.59980235 | 37.7398043808352 | -122.426594919866 | (37.7398043808352, -122.426594919866) | 2 | 7 | 5 | 63 | 7 | ||
154840 | 63853 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24552 | 6002495.53817147 | 2111986.73822711 | 37.7792538422906 | -122.43495345894 | (37.7792538422906, -122.43495345894) | 15 | 5 | 11 | 29490 | 41 | ||
112567 | 5335 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 149 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X8 | 6004854.459 | 2107562.68516 | 37.7672401222731 | -122.42647787465 | (37.7672401222731, -122.42647787465) | 8 | 4 | 5 | 28862 | 19 | |||
90644 | 61306 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1494 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21205 | 6011999.58311152 | 2101400.41872379 | 37.7507212274206 | -122.401330679383 | (37.7507212274206, -122.401330679383) | 10 | 3 | 8 | 28856 | 29 | ||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
181231 | 57942 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776219 | 5999289.47216 | 2086646.12526 | 37.7094920599881 | -122.444223069735 | (37.7094920599881, -122.444223069735) | 9 | 7 | 6 | 28861 | 5 | |
184895 | 218827 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.7300546412872 | -122.472613299773 | (37.7300546412872, -122.472613299773) | 9 | 8 | 4 | 64 | 40 | |||
82623 | 224638 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006127.41253 | 2098099.44281 | 37.7413281233964 | -122.421402787214 | (37.7413281233964, -122.421402787214) | 2 | 7 | 7 | 28859 | 2 | |||
161072 | 224639 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006112.4253 | 2098109.96948 | 37.7413561822494 | -122.421455355286 | (37.7413561822494, -122.421455355286) | 2 | 7 | 7 | 28859 | 2 | |||
23294 | 224483 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007282.93524 | 2107366.34912 | 37.7668380128917 | -122.418064187227 | (37.7668380128917, -122.418064187227) | 8 | 4 | 7 | 28853 | 19 | |||
87966 | 30505 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | 8 | 2 | 9 | 28853 | 19 | |||
22488 | 98718 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
168838 | 84930 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
153957 | 5685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.424677493096 | (37.7452207246578, -122.424677493096) | 2 | 7 | 5 | 63 | 22 | |||
95454 | 255584 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 151 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006696 | 2105242 | 37.7609719961735 | -122.41994353943 | (37.7609719961735, -122.41994353943) | 2 | 4 | 7 | 28859 | 19 | ||||
169407 | 224484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1514 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007262.01073 | 2107365.0441 | 37.7668332518872 | -122.418136469321 | (37.7668332518872, -122.418136469321) | 8 | 4 | 7 | 28853 | 19 | |||
57590 | 218841 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1522 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994017.40797 | 2105128.44374 | 37.7599377495509 | -122.463784669644 | (37.7599377495509, -122.463784669644) | 1 | 5 | 4 | 56 | 12 | |||
96429 | 224485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007214.09312 | 2107363.71404 | 37.7668269026679 | -122.418302114548 | (37.7668269026679, -122.418302114548) | 8 | 4 | 7 | 28853 | 19 | |||
54947 | 63166 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | 1 | 8 | 4 | 56 | 12 | ||
114985 | 5689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1535 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005306.00348 | 2099419.02782 | 37.7449050572203 | -122.424336766952 | (37.7449050572203, -122.424336766952) | 2 | 7 | 5 | 28859 | 22 | |||
131865 | 226500 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 155 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005540.15432 | 2099025.50317 | 37.7438377472209 | -122.423499143787 | (37.7438377472209, -122.423499143787) | 2 | 7 | 5 | 28859 | 22 | |||
135076 | 218835 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.25372 | 2098449.01305 | 37.7414296487733 | -122.473362202106 | (37.7414296487733, -122.473362202106) | 1 | 8 | 4 | 29491 | 40 | |||
163838 | 218836 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.22907 | 2098459.95547 | 37.7414596924238 | -122.473363085249 | (37.7414596924238, -122.473363085249) | 1 | 8 | 4 | 29491 | 40 | |||
24232 | 218833 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991183.94041 | 2098426.02106 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | 1 | 8 | 4 | 29491 | 40 | |||
73159 | 218834 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991139.93283 | 2098423.38649 | 37.7413611770786 | -122.473247341618 | (37.7413611770786, -122.473247341618) | 1 | 8 | 4 | 29491 | 40 | |||
120941 | 218832 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | 1 | 8 | 4 | 29491 | 40 | |||
184346 | 218831 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991205.91202 | 2098425.81226 | 37.7413716577778 | -122.473019387736 | (37.7413716577778, -122.473019387736) | 1 | 8 | 4 | 29491 | 40 | |||
61132 | 38252 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.7668030933038 | -122.418866676369 | (37.7668030933038, -122.418866676369) | 8 | 4 | 7 | 28853 | 19 | |
37941 | 184315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.7574413473895 | -122.498265228241 | (37.7574413473895, -122.498265228241) | 1 | 8 | 3 | 56 | 35 | |||
77132 | 184317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984033.1876 | 2104377.9194 | 37.7572966221146 | -122.498259277429 | (37.7572966221146, -122.498259277429) | 1 | 8 | 3 | 56 | 35 | |||
121365 | 5338 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 158 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6004769.98156 | 2107435.4149 | 37.766885892799 | -122.426761005535 | (37.766885892799, -122.426761005535) | 8 | 4 | 5 | 28862 | 3 | |||
1390 | 33763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
36413 | 33765 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
78943 | 33764 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
67398 | 224635 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007212.97385 | 2098214.14312 | 37.7417042108849 | -122.417657415761 | (37.7417042108849, -122.417657415761) | 2 | 7 | 7 | 28859 | 2 | |||
129041 | 33581 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | 2 | 7 | 7 | 28859 | 2 | |||
121030 | 101519 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 15X Bellair Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | 3 | 1 | 10 | 308 | 23 | |||
163520 | 101520 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 15X Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | 3 | 1 | 10 | 308 | 23 | |||
76501 | 5708 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005329.17263 | 2098980.11676 | 37.7437012157418 | -122.424225442544 | (37.7437012157418, -122.424225442544) | 2 | 7 | 5 | 28859 | 22 | |||
46826 | 110117 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
169076 | 110116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
33103 | 224636 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | 2 | 7 | 7 | 28859 | 2 | |||
42809 | 33580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | 2 | 7 | 7 | 28859 | 2 | |||
132605 | 218804 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991882.49508 | 2095116.63402 | 37.7323246389721 | -122.470439076297 | (37.7323246389721, -122.470439076297) | 9 | 8 | 4 | 59 | 40 | |||
5392 | 60144 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.474482571431 | (37.7577595366377, -122.474482571431) | 1 | 8 | 4 | 56 | 12 |
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) );