Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189126 | 189126 | 84279 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6016131.0603 | 2093656.105 | 37.7296865592841 | -122.386503619825 | (37.7296865592841, -122.386503619825) | ||
| 189053 | 189053 | 241893 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1305 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008569.76439 | 2097675.0673599998 | 37.7403002828328 | -122.412927964755 | (37.7403002828328, -122.412927964755) | |||
| 189047 | 189047 | 241523 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4264 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000734.8194 | 2102894.03072 | 37.754187397136505 | -122.440392210553 | (37.7541873971365, -122.440392210553) | |||
| 188983 | 188983 | 141704 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 154 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996607.8351 | 2111918.4266 | 37.778730220256 | -122.455316406199 | (37.778730220256, -122.455316406199) | |||
| 188975 | 188975 | 143021 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 685 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008591.686000001 | 2120703.4993 | 37.8035321827214 | -122.414481260898 | (37.8035321827214, -122.414481260898) | |||
| 188965 | 188965 | 182974 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2501 19th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5990445.6911 | 2097993.6128 | 37.7401409062913 | -122.475616387366 | (37.7401409062913, -122.475616387366) | |||
| 188960 | 188960 | 241552 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2825 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002458.1519 | 2095543.34833 | 37.734102115717 | -122.43390712642599 | (37.734102115717, -122.433907126426) | |||
| 188949 | 188949 | 141072 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 197 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996921.8999 | 2113055.5828 | 37.7818705666664 | -122.454312101068 | (37.7818705666664, -122.454312101068) | |||
| 188888 | 188888 | 97767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 375 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2011 12:00:00 AM | 1 | 2x2 | Permit Number 768293 | 5997562.8708 | 2113817.3703 | 37.783998971375 | -122.452149632238 | (37.783998971375, -122.452149632238) | |
| 188878 | 188878 | 181847 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1315 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988762.7194 | 2099646.8033 | 37.744582424890204 | -122.481556399027 | (37.7445824248902, -122.481556399027) | |||
| 188852 | 188852 | 241247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1330 Stevenson St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6006254.50183 | 2108932.02318 | 37.77107904388 | -122.421732594687 | (37.77107904388, -122.421732594687) | |||
| 188725 | 188725 | 217604 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5996041.3761 | 2091892.9599 | 37.7237127940596 | -122.455828002657 | (37.7237127940596, -122.455828002657) | |||
| 188704 | 188704 | 214865 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1350 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992421.59622 | 2106248.14745 | 37.76292007323771 | -122.46938526243 | (37.7629200732377, -122.46938526243) | |||
| 188678 | 188678 | 242041 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1606 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005876.6582 | 2099566.10875 | 37.745341115094206 | -122.422373993887 | (37.7453411150942, -122.422373993887) | |||
| 188657 | 188657 | 242224 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4188 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001112.535209999 | 2105841.46723 | 37.7623018396786 | -122.439297230202 | (37.7623018396786, -122.439297230202) | |||
| 188641 | 188641 | 62171 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 58 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 12 | Permit Number 22287 | 6000147.44249 | 2092048.11299 | 37.7243736086455 | -122.441645199974 | (37.7243736086455, -122.441645199974) | |
| 188626 | 188626 | 38656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2525 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1998 12:00:00 AM | 7 | Permit Number 40577 | 6002175.87869 | 2116963.69117 | 37.7929011302226 | -122.436415594627 | (37.7929011302226, -122.436415594627) | ||
| 188586 | 188586 | 241491 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1679 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003393.06435 | 2098454.10207 | 37.7421473895927 | -122.43088250402 | (37.7421473895927, -122.43088250402) | |||
| 188557 | 188557 | 143090 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 618 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009917.0126 | 2120239.8067 | 37.802333362696096 | -122.40986213721901 | (37.8023333626961, -122.409862137219) | |||
| 188546 | 188546 | 52085 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2672 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2005 12:00:00 AM | 6 | Permit Number 48282 | 6000189.160080001 | 2118535.00366 | 37.7971024507605 | -122.443402636239 | (37.7971024507605, -122.443402636239) | ||
| 188543 | 188543 | 99627 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2389 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2012 12:00:00 AM | 4 | 6x10 | Permit Number 768863 | 6003328.26592 | 2116532.46568 | 37.7917825084999 | -122.432397466871 | (37.7917825084999, -122.432397466871) | |
| 188476 | 188476 | 180337 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000013.17404 | 2092717.50555 | 37.7262039556431 | -122.442157374679 | (37.7262039556431, -122.442157374679) | |||
| 188448 | 188448 | 241931 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 350 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008586.47479 | 2106478.8225 | 37.7644743517262 | -122.413492666177 | (37.7644743517262, -122.413492666177) | |||
| 188423 | 188423 | 136794 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2475 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002861.63167 | 2116465.57959 | 37.791572385497396 | -122.43400723534599 | (37.7915723854974, -122.434007235346) | |||
| 188395 | 188395 | 136819 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2800 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002576.63344 | 2117903.94892 | 37.7955055983474 | -122.43509624511002 | (37.7955055983474, -122.43509624511) | |||
| 188370 | 188370 | 198036 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 333 11th St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008686.77489 | 2109006.56148 | 37.7714205668302 | -122.413324523514 | (37.7714205668302, -122.413324523514) | |||
| 188365 | 188365 | 246426 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 448 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003617.56416 | 2099843.55926 | 37.745975235172295 | -122.43020535771299 | (37.7459752351723, -122.430205357713) | |||
| 188312 | 188312 | 138178 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2093 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999596.2635 | 2111529.0603 | 37.777832132082 | -122.44495030600099 | (37.777832132082, -122.444950306001) | |||
| 188306 | 188306 | 123651 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 211 Cornwall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994690.7789 | 2114244.51563 | 37.7850068554102 | -122.46211693705901 | (37.7850068554102, -122.462116937059) | |||
| 188277 | 188277 | 181709 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3345 Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985298.0363 | 2107014.13 | 37.7646090072485 | -122.4940792882 | (37.7646090072485, -122.4940792882) | |||
| 188272 | 188272 | 242289 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 417 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003723.4326599995 | 2098337.1172 | 37.7418448891215 | -122.429731852052 | (37.7418448891215, -122.429731852052) | |||
| 188243 | 188243 | 180043 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000932.74205 | 2090913.3851700001 | 37.721302615409705 | -122.438849257207 | (37.7213026154097, -122.438849257207) | |||
| 188226 | 188226 | 248508 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 164 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998310.1076 | 2107801.4007 | 37.7675234471952 | -122.449130934869 | (37.7675234471952, -122.449130934869) | |||
| 188223 | 188223 | 241518 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 877 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000757.21639 | 2102564.9635 | 37.7532851334084 | -122.440291159127 | (37.7532851334084, -122.440291159127) | |||
| 188213 | 188213 | 136850 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2644 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004465.10829 | 2118307.74301 | 37.796721365752795 | -122.428590595277 | (37.7967213657528, -122.428590595277) | |||
| 188209 | 188209 | 242313 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1513 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005931.42593 | 2100183.60799 | 37.7470397168238 | -122.42222847906 | (37.7470397168238, -122.42222847906) | |||
| 188182 | 188182 | 79032 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1475 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/2001 12:00:00 AM | 6 | 6015238.0441 | 2092152.5097 | 37.725508510693295 | -122.38948593447901 | (37.7255085106933, -122.389485934479) | ||
| 188119 | 188119 | 142643 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2360 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008894.7015 | 2121338.3744 | 37.8052924087646 | -122.413477585873 | (37.8052924087646, -122.413477585873) | |||
| 188105 | 188105 | 121771 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6016276.86465 | 2101451.8833 | 37.751100251186706 | -122.38654292343399 | (37.7511002511867, -122.386542923434) | |||
| 188073 | 188073 | 242130 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 20 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002618.467759999 | 2105770.42039 | 37.7621923445155 | -122.434083701124 | (37.7621923445155, -122.434083701124) | |||
| 188055 | 188055 | 136756 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3023 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999942.6898300005 | 2118971.84309 | 37.79828783727179 | -122.444286889232 | (37.7982878372718, -122.444286889232) | |||
| 187962 | 187962 | 241542 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004746.05114 | 2097239.88547 | 37.738889993882395 | -122.426117875136 | (37.7388899938824, -122.426117875136) | |||
| 187957 | 187957 | 180224 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3599 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993480.96313 | 2087505.0727 | 37.7115174312511 | -122.46436041830799 | (37.7115174312511, -122.464360418308) | |||
| 187949 | 187949 | 218698 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2290 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992021.61582 | 2099888.40112 | 37.745434745321205 | -122.470305480217 | (37.7454347453212, -122.470305480217) | |||
| 187925 | 187925 | 242258 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006281.32025 | 2110433.89565 | 37.7752043375461 | -122.42174652250401 | (37.7752043375461, -122.421746522504) | |||
| 187877 | 187877 | 242126 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 382 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003872.04416 | 2103358.1658099997 | 37.7556399326543 | -122.429576012143 | (37.7556399326543, -122.429576012143) | |||
| 187784 | 187784 | 198223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017491.0802 | 2094306.0971900001 | 37.7315465041574 | -122.38184702883301 | (37.7315465041574, -122.381847028833) | |||
| 187780 | 187780 | 198137 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 118 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6013432.85539 | 2095621.93817 | 37.734934597439704 | -122.395969375192 | (37.7349345974397, -122.395969375192) | |||
| 187738 | 187738 | 139962 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002568.0446 | 2112344.9816 | 37.780241605210904 | -122.434728253986 | (37.7802416052109, -122.434728253986) | |||
| 187695 | 187695 | 136785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1307 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004526.27681 | 2120824.48877 | 37.803635162995 | -122.428558424738 | (37.803635162995, -122.428558424738) | |||
| 187661 | 187661 | 242298 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 297 Addison St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6002506.63703 | 2097692.2502 | 37.740005256637204 | -122.433893045753 | (37.7400052566372, -122.433893045753) | |||
| 187625 | 187625 | 218526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 424 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992849.69775 | 2090512.21172 | 37.7197379029691 | -122.46676067557199 | (37.7197379029691, -122.466760675572) | |||
| 187608 | 187608 | 92252 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1558 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52702 | 5985620.6386 | 2104602.1565 | 37.7580052698857 | -122.492785843667 | (37.7580052698857, -122.492785843667) | |
| 187581 | 187581 | 180063 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000614.24594 | 2090358.9478799999 | 37.7197621306905 | -122.439910472497 | (37.7197621306905, -122.439910472497) | |||
| 187523 | 187523 | 241639 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6005424.1713 | 2107755.7253799997 | 37.7678023541299 | -122.424521053307 | (37.7678023541299, -122.424521053307) | |||
| 187498 | 187498 | 121767 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016282.98145 | 2101349.78333 | 37.75082024456479 | -122.386514652348 | (37.7508202445648, -122.386514652348) | |||
| 187493 | 187493 | 183973 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1679 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5987776.9086 | 2103868.5958 | 37.756116965025605 | -122.48527481394301 | (37.7561169650256, -122.485274813943) | |||
| 187401 | 187401 | 73399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 318 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 6 | 6010326.194680001 | 2093255.95612 | 37.7282647808735 | -122.406543575948 | (37.7282647808735, -122.406543575948) | ||
| 187383 | 187383 | 136825 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2295 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002698.96155 | 2117796.69453 | 37.7952180509353 | -122.43466529627399 | (37.7952180509353, -122.434665296274) | |||
| 187322 | 187322 | 180160 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000171.58523 | 2088857.19454 | 37.7156134474691 | -122.44133289151199 | (37.7156134474691, -122.441332891512) | |||
| 187297 | 187297 | 198039 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 157 12th St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6007591.24481 | 2109206.34028 | 37.771907543438395 | -122.417128184534 | (37.7719075434384, -122.417128184534) | |||
| 187296 | 187296 | 32212 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 6 | Permit Number 35533 | 6009893.25149 | 2099852.66085 | 37.746353682475096 | -122.408505421789 | (37.7463536824751, -122.408505421789) | |
| 187256 | 187256 | 241714 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 203 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009414.51061 | 2099152.92422 | 37.7444055368928 | -122.410111466171 | (37.7444055368928, -122.410111466171) | |||
| 187220 | 187220 | 29952 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 139 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 2 | 3x3 | 5995468.7175 | 2088041.2261 | 37.7131039615411 | -122.457529027577 | (37.7131039615411, -122.457529027577) | ||
| 187207 | 187207 | 103386 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1745 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5999466.5405 | 2110479.9214 | 37.774944060716294 | -122.44532360891199 | (37.7749440607163, -122.445323608912) | |||
| 187172 | 187172 | 241754 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1208 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004432.15189 | 2101847.3790700003 | 37.7515233642247 | -122.42753135490901 | (37.7515233642247, -122.427531354909) | |||
| 187158 | 187158 | 139653 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 30 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000762.7335 | 2112216.889 | 37.7797872386311 | -122.440964447674 | (37.7797872386311, -122.440964447674) | |||
| 187117 | 187117 | 241652 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 20 Dorland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005395.48702 | 2105771.82804 | 37.762353423906205 | -122.424479137696 | (37.7623534239062, -122.424479137696) | |||
| 187066 | 187066 | 245846 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301 Oak St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 6005500.1805 | 2110269.8913 | 37.7747099408336 | -122.424436996012 | (37.7747099408336, -122.424436996012) | |||
| 187042 | 187042 | 198217 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017560.86831 | 2094203.9369400002 | 37.7312698457244 | -122.381598653182 | (37.7312698457244, -122.381598653182) | |||
| 186964 | 186964 | 46161 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1596 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2011 12:00:00 AM | 3 | Permit Number 767143 | 6007704.3465599995 | 2109270.67282 | 37.772090547379 | -122.416741514729 | (37.772090547379, -122.416741514729) | ||
| 186935 | 186935 | 73355 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 235 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/1993 12:00:00 AM | 9 | 6000483.29937 | 2091960.66988 | 37.7241526398265 | -122.440477924021 | (37.7241526398265, -122.440477924021) | ||
| 186897 | 186897 | 244140 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 441 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004356.7646 | 2109602.6495 | 37.7728132224038 | -122.428344737687 | (37.7728132224038, -122.428344737687) | |||
| 186878 | 186878 | 241870 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 585 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008721.53321 | 2096078.4971200002 | 37.735924966869796 | -122.412290390405 | (37.7359249668698, -122.412290390405) | |||
| 186873 | 186873 | 218746 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 489 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997458.01622 | 2097576.19817 | 37.739398813214706 | -122.45134063896299 | (37.7393988132147, -122.451340638963) | |||
| 186868 | 186868 | 241618 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008660.008230001 | 2095682.9715599997 | 37.7348354867689 | -122.412475157919 | (37.7348354867689, -122.412475157919) | |||
| 186837 | 186837 | 241745 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 368 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004786.4958 | 2110036.6381099997 | 37.77402915654171 | -122.426889161616 | (37.7740291565417, -122.426889161616) | |||
| 186825 | 186825 | 117864 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 798 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983563.27661 | 2110414.76175 | 37.7738445083611 | -122.50033069971902 | (37.7738445083611, -122.500330699719) | |||
| 186811 | 186811 | 242223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4186 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001156.2183 | 2105843.64596 | 37.7623103076905 | -122.439146303275 | (37.7623103076905, -122.439146303275) | |||
| 186746 | 186746 | 187440 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4440 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002632.0177 | 2092977.5557 | 37.7270668968009 | -122.43312275567499 | (37.7270668968009, -122.433122755675) | |||
| 186718 | 186718 | 218503 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 52 Broad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996193.77453 | 2088089.90797 | 37.713279252598 | -122.455026516679 | (37.713279252598, -122.455026516679) | |||
| 186700 | 186700 | 54087 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2250 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 4 | Permit Number 769106 | 6003261.93256 | 2116473.57284 | 37.7916170422495 | -122.43262277134899 | (37.7916170422495, -122.432622771349) | ||
| 186652 | 186652 | 99626 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2389 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2012 12:00:00 AM | 4 | 6x10 | Permit Number 768863 | 6003304.80228 | 2116527.3114400003 | 37.7917670257707 | -122.432478282647 | (37.7917670257707, -122.432478282647) | |
| 186634 | 186634 | 30554 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011714.03756 | 2086311.65654 | 37.7092746884476 | -122.401257930228 | (37.7092746884476, -122.401257930228) | ||
| 186607 | 186607 | 84551 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 711 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5987529.79137 | 2111085.3149599996 | 37.775917683596504 | -122.486659304996 | (37.7759176835965, -122.486659304996) | ||
| 186606 | 186606 | 201870 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011866.0251 | 2112354.8261 | 37.7807921156549 | -122.402562765369 | (37.7807921156549, -122.402562765369) | |||
| 186542 | 186542 | 241546 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 190 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004420.9839 | 2097254.0968400002 | 37.7389106369086 | -122.427242819107 | (37.7389106369086, -122.427242819107) | |||
| 186540 | 186540 | 242227 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 87 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001071.19781 | 2105898.11446 | 37.7624550266104 | -122.43944426125799 | (37.7624550266104, -122.439444261258) | |||
| 186527 | 186527 | 92244 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1510 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52689 | 5986229.4871 | 2104937.9456 | 37.7589628384425 | -122.49070492202699 | (37.7589628384425, -122.490704922027) | |
| 186512 | 186512 | 198147 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 168 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6014075.52007 | 2112367.11854 | 37.7809489729515 | -122.394919852887 | (37.7809489729515, -122.394919852887) | |||
| 186506 | 186506 | 214844 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1351 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992069.2887 | 2106144.8192 | 37.7626159953463 | -122.47059623463998 | (37.7626159953463, -122.47059623464) | |||
| 186477 | 186477 | 34872 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 91 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/1997 12:00:00 AM | 5 | Permit Number 38487 | 5993933.45844 | 2114941.70605 | 37.786877517910796 | -122.464787651753 | (37.7868775179108, -122.464787651753) | ||
| 186457 | 186457 | 244156 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 459 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004320.0513 | 2109763.655 | 37.7732532267266 | -122.428483211475 | (37.7732532267266, -122.428483211475) | |||
| 186448 | 186448 | 180134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 Naples St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002039.611740001 | 2088911.58679 | 37.7158690348 | -122.43488004178002 | (37.7158690348, -122.43488004178) | |||
| 186376 | 186376 | 244144 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 423 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004441.5384 | 2109615.9134 | 37.772854438404295 | -122.42805244074499 | (37.7728544384043, -122.428052440745) | |||
| 186362 | 186362 | 180116 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Amazon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002056.65206 | 2088684.40818 | 37.7152462201094 | -122.434804906124 | (37.7152462201094, -122.434804906124) | |||
| 186356 | 186356 | 214959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993574.3517 | 2095241.11953 | 37.7327641241706 | -122.46459902103099 | (37.7327641241706, -122.464599021031) | |||
| 186335 | 186335 | 136807 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2509 Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001660.6114 | 2117127.81463 | 37.7933224788022 | -122.43821020433599 | (37.7933224788022, -122.438210204336) | |||
| 186303 | 186303 | 65735 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 381 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 9 | Permit Number 28671 | 6000320.2870000005 | 2086910.79586 | 37.710277542235396 | -122.440679381145 | (37.7102775422354, -122.440679381145) | |
| 186288 | 186288 | 136832 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2260 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003259.36729 | 2116503.58101 | 37.7916992915328 | -122.432633791615 | (37.7916992915328, -122.432633791615) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");