Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 582 | 582 | 27390 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | |||
| 2283 | 2283 | 7972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005640.29534 | 2116816.4309400003 | 37.7926930351995 | -122.424418048575 | (37.7926930351995, -122.424418048575) | |||
| 2689 | 2689 | 207839 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626X Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994826.85492 | 2091253.8672900002 | 37.721888220645 | -122.459980091334 | (37.721888220645, -122.459980091334) | |||
| 2886 | 2886 | 7974 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.935869999 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | |||
| 2916 | 2916 | 140305 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997929.2973 | 2109958.9845 | 37.7734258317863 | -122.450603670824 | (37.7734258317863, -122.450603670824) | |||
| 3706 | 3706 | 226704 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 18 | Width 4ft | Permit Number 38040 | 6007388.533559999 | 2107001.8580400003 | 37.7658431486538 | -122.41767310175399 | (37.7658431486538, -122.417673101754) | |
| 4584 | 4584 | 129646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 4 | Width 3ft | 6009824.55896 | 2121666.13191 | 37.8062445153435 | -122.41028283828899 | (37.8062445153435, -122.410282838289) | ||
| 4694 | 4694 | 7986 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | |||
| 5334 | 5334 | 17712 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1214 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6002329.348999999 | 2112708.9615 | 37.7812274480895 | -122.435580057373 | (37.7812274480895, -122.435580057373) | |||
| 6112 | 6112 | 17719 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6002302.3774 | 2112913.4677 | 37.78178743852221 | -122.43568800125799 | (37.7817874385222, -122.435688001258) | |||
| 6348 | 6348 | 7967 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1901 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005619.52925 | 2116640.16995 | 37.7922078941213 | -122.424477357045 | (37.7922078941213, -122.424477357045) | |||
| 6879 | 6879 | 6058 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1905 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001281.6188 | 2112455.0533 | 37.780470716869395 | -122.439186474434 | (37.7804707168694, -122.439186474434) | |||
| 7479 | 7479 | 7952 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1740 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005743.00192 | 2116111.2494799998 | 37.7907625828685 | -122.424012509171 | (37.7907625828685, -122.424012509171) | |||
| 7554 | 7554 | 12324 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.780351202823205 | -122.427115646852 | (37.7803512028232, -122.427115646852) | |||
| 8115 | 8115 | 12319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | |||
| 9709 | 9709 | 121554 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779292 | 6001441.0 | 2103840.0 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | ||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10235 | 10235 | 173926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
| 10409 | 10409 | 104687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | |||
| 10599 | 10599 | 25290 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000711.5604 | 2091742.5944599998 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | |||
| 12057 | 12057 | 77641 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006964.988919999 | 2093186.8525200002 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | |
| 14345 | 14345 | 25704 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | |||
| 16320 | 16320 | 12187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | |||
| 16421 | 16421 | 12185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.734276365571105 | -122.385906337047 | (37.7342763655711, -122.385906337047) | |||
| 16766 | 16766 | 12174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016429.1110000005 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | |||
| 17545 | 17545 | 17038 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001065.34359 | 2109713.09337 | 37.772929678688506 | -122.43973803201 | (37.7729296786885, -122.43973803201) | |||
| 18911 | 18911 | 12302 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.42758319096399 | (37.7790930089412, -122.427583190964) | |||
| 19050 | 19050 | 4227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3984 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 5 | 3X3 | 6004005.18822 | 2100441.9925599997 | 37.7476403416378 | -122.428907662964 | (37.7476403416378, -122.428907662964) | ||
| 22502 | 22502 | 1654 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 3X3 | 6006190.88992 | 2115436.6109700003 | 37.788935469840105 | -122.42241488063699 | (37.7889354698401, -122.422414880637) | ||
| 23288 | 23288 | 15312 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | ||
| 23372 | 23372 | 137917 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 408 AUSTIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005199.6845 | 2115305.406 | 37.7885192491697 | -122.425834977285 | (37.7885192491697, -122.425834977285) | |||
| 23553 | 23553 | 200578 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1423 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016466.7865 | 2094992.602 | 37.7333748936582 | -122.385436067152 | (37.7333748936582, -122.385436067152) | |||
| 24110 | 24110 | 227479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 245 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003729.9589599995 | 2109287.5082400003 | 37.771912433934105 | -122.430490439197 | (37.7719124339341, -122.430490439197) | |||
| 24229 | 24229 | 141575 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1478 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000744.6746 | 2110704.0393 | 37.7756323088735 | -122.44091836280899 | (37.7756323088735, -122.440918362809) | |||
| 24609 | 24609 | 227488 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003985.989080001 | 2109021.37679 | 37.771196202169705 | -122.429585829147 | (37.7711962021697, -122.429585829147) | |||
| 25107 | 25107 | 191446 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Tulare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6016252.95003 | 2100312.60959 | 37.747970718394704 | -122.386546192477 | (37.7479707183947, -122.386546192477) | ||||
| 25221 | 25221 | 129562 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000843.46741 | 2119560.3613299998 | 37.7999551030067 | -122.441212183615 | (37.7999551030067, -122.441212183615) | |||
| 25228 | 25228 | 123214 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 598 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993175.3131800005 | 2111469.83533 | 37.7773009664124 | -122.467158112666 | (37.7773009664124, -122.467158112666) | |||
| 25497 | 25497 | 227302 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1287 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6003266.52543 | 2100725.05977 | 37.7483757406618 | -122.43148211980301 | (37.7483757406618, -122.431482119803) | |||
| 25638 | 25638 | 139004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 155 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998267.7815 | 2110059.6372 | 37.7737215666049 | -122.44944006458599 | (37.7737215666049, -122.449440064586) | |||
| 25839 | 25839 | 36982 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 251 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39606 | 5993044.7391 | 2113780.4585 | 37.7836377719626 | -122.467777899893 | (37.7836377719626, -122.467777899893) | ||
| 26392 | 26392 | 207957 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995759.15859 | 2100245.2253900003 | 37.7466298786655 | -122.45740754733102 | (37.7466298786655, -122.457407547331) | |||
| 26441 | 26441 | 226744 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010266.86598 | 2102287.21405 | 37.753059346011895 | -122.40738510305599 | (37.7530593460119, -122.407385103056) | |||
| 26570 | 26570 | 226725 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2730 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010324.661 | 2102839.65935 | 37.754579472764895 | -122.407224175681 | (37.7545794727649, -122.407224175681) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 26782 | 26782 | 141376 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 340 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000731.9492 | 2110174.3711 | 37.7741772489645 | -122.440924377301 | (37.7741772489645, -122.440924377301) | |||
| 27711 | 27711 | 142321 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1542 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000429.2107 | 2110311.8766 | 37.7745375574505 | -122.441981472333 | (37.7745375574505, -122.441981472333) | |||
| 28241 | 28241 | 227326 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 279 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004157.53404 | 2096855.56287 | 37.737801450879104 | -122.42812531304199 | (37.7378014508791, -122.428125313042) | |||
| 28383 | 28383 | 49433 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 364@ KEARNY Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 8 | Permit Number 46371 | 6011642.68179 | 2116034.05853 | 37.7908819508039 | -122.403594362585 | (37.7908819508039, -122.403594362585) | ||
| 29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
| 30591 | 30591 | 207827 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5999363.8655900005 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | |||
| 30756 | 30756 | 124328 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 116 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5995929.77747 | 2113622.35703 | 37.783369832624004 | -122.45778538742901 | (37.783369832624, -122.457785387429) | |||
| 31106 | 31106 | 114466 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | |||
| 31136 | 31136 | 201239 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 832 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6012006.1458 | 2112576.455 | 37.7814084789041 | -122.4020936026 | (37.7814084789041, -122.4020936026) | |||
| 31254 | 31254 | 129563 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2270 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000463.82549 | 2119961.7151099998 | 37.8010354810636 | -122.442554716754 | (37.8010354810636, -122.442554716754) | |||
| 31932 | 31932 | 191468 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014292.29593 | 2112680.8823700002 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | |||
| 32071 | 32071 | 227389 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3014 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009181.84583 | 2104530.5514 | 37.759158255859106 | -122.411295791464 | (37.7591582558591, -122.411295791464) | |||
| 32805 | 32805 | 227501 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 49 Everson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003541.82296 | 2097107.65785 | 37.738458790548 | -122.430272104489 | (37.738458790548, -122.430272104489) | |||
| 33361 | 33361 | 246400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 612 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998516.7885 | 2108556.8079 | 37.7696094224276 | -122.448470464048 | (37.7696094224276, -122.448470464048) | |||
| 33884 | 33884 | 227436 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000934.92196 | 2104940.29183 | 37.759817324036796 | -122.439846911128 | (37.7598173240368, -122.439846911128) | |||
| 34201 | 34201 | 142176 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1480 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000776.2338 | 2110357.6285 | 37.774682949664204 | -122.44078433758999 | (37.7746829496642, -122.44078433759) | |||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
| 34920 | 34920 | 226714 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1208 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010278.22843 | 2102080.18456 | 37.7524915248726 | -122.407331215672 | (37.7524915248726, -122.407331215672) | |||
| 35313 | 35313 | 208011 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998765.6075 | 2093383.3893099998 | 37.727961138279205 | -122.446518012793 | (37.7279611382792, -122.446518012793) | |||
| 35392 | 35392 | 227233 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006377.06245 | 2104334.1505299998 | 37.7584612794952 | -122.420982147336 | (37.7584612794952, -122.420982147336) | |||
| 35764 | 35764 | 143380 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1897 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003965.1287 | 2118668.8078 | 37.7976844492982 | -122.430346412036 | (37.7976844492982, -122.430346412036) | |||
| 35972 | 35972 | 207841 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994779.70633 | 2090681.1537400002 | 37.72031297444521 | -122.460101600536 | (37.7203129744452, -122.460101600536) | |||
| 36010 | 36010 | 124006 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 317 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993993.05196 | 2113317.82829 | 37.782422226449 | -122.46446352346001 | (37.782422226449, -122.46446352346) | |||
| 36259 | 36259 | 208014 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.765869999 | 2093228.45695 | 37.7275465328469 | -122.44585295156901 | (37.7275465328469, -122.445852951569) | ||||
| 36298 | 36298 | 207910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 272 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992257.40464 | 2097504.13559 | 37.7389017884968 | -122.46931665586 | (37.7389017884968, -122.46931665586) | |||
| 36586 | 36586 | 207860 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 88 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992206.435269999 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | |||
| 37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
| 37569 | 37569 | 141819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004740.795 | 2112530.2338 | 37.7808733743326 | -122.42722490683998 | (37.7808733743326, -122.42722490684) | |||
| 37891 | 37891 | 227521 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1500 Cole St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 5998355.105169999 | 2105264.42447 | 37.7605601235622 | -122.448792539459 | (37.7605601235622, -122.448792539459) | |||
| 38218 | 38218 | 71535 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1995 12:00:00 AM | 6 | 6007520.46607 | 2118819.9604700003 | 37.7983002218264 | -122.41805466610201 | (37.7983002218264, -122.418054666102) | ||
| 38698 | 38698 | 207413 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 916 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5996523.58257 | 2098185.78837 | 37.741019048902004 | -122.45461550759701 | (37.741019048902, -122.454615507597) | |||
| 38750 | 38750 | 208004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.15319 | 2094958.3543599998 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | |||
| 38841 | 38841 | 227252 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6006140.42151 | 2096376.3293 | 37.7365975725045 | -122.42123547733499 | (37.7365975725045, -122.421235477335) | |||
| 39673 | 39673 | 227499 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3068 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002862.42767 | 2095876.1703 | 37.7350389026183 | -122.432533184459 | (37.7350389026183, -122.432533184459) | |||
| 39838 | 39838 | 227348 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 383 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006101.45441 | 2097927.38523 | 37.7408542283508 | -122.421480324955 | (37.7408542283508, -122.421480324955) | |||
| 40083 | 40083 | 227170 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1105 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998136.607340001 | 2106470.82303 | 37.7638600931786 | -122.449635154751 | (37.7638600931786, -122.449635154751) | |||
| 40319 | 40319 | 207930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.4181 | 2092708.16322 | 37.7259343298845 | -122.45689963632499 | (37.7259343298845, -122.456899636325) | |||
| 40353 | 40353 | 207983 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.44423726735799 | (37.7326518231051, -122.444237267358) | |||
| 40485 | 40485 | 177065 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002192.98275 | 2090253.20784 | 37.7195615351173 | -122.43444578884599 | (37.7195615351173, -122.434445788846) | |||
| 41100 | 41100 | 177100 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999723.90595 | 2091657.9425099997 | 37.7232781498534 | -122.443081294068 | (37.7232781498534, -122.443081294068) | |||
| 41149 | 41149 | 227215 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 775 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009110.12793 | 2104609.60949 | 37.759371308854604 | -122.411549412872 | (37.7593713088546, -122.411549412872) | |||
| 41223 | 41223 | 129612 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 711 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009194.012019999 | 2115430.46227 | 37.789087538016794 | -122.41202400940399 | (37.7890875380168, -122.412024009404) | |||
| 41490 | 41490 | 227279 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4530 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 4ft | 6000798.050340001 | 2101148.90098 | 37.749399291454 | -122.44004841589701 | (37.749399291454, -122.440048415897) | |||
| 41939 | 41939 | 207892 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2119 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990666.05125 | 2100929.33737 | 37.7482144184726 | -122.47506873135299 | (37.7482144184726, -122.475068731353) | |||
| 42435 | 42435 | 141709 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 449 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997090.1697 | 2111836.8374 | 37.7785338604663 | -122.453641938936 | (37.7785338604663, -122.453641938936) | |||
| 42439 | 42439 | 227449 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 791 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003106.45388 | 2103637.56402 | 37.7563637151333 | -122.432243615346 | (37.7563637151333, -122.432243615346) | |||
| 42545 | 42545 | 227299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002389.0649 | 2100323.63751 | 37.7472237585745 | -122.43448765677499 | (37.7472237585745, -122.434487656775) | ||||
| 42571 | 42571 | 226722 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1111 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010289.0097 | 2102653.41278 | 37.7540660857915 | -122.40733433900499 | (37.7540660857915, -122.407334339005) | |||
| 43200 | 43200 | 226750 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 188 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004784.115 | 2109030.2086099996 | 37.7712656109374 | -122.426825708165 | (37.7712656109374, -122.426825708165) | |||
| 43940 | 43940 | 227468 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 43 Uranus Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5999310.34636 | 2105508.81384 | 37.7612857352771 | -122.445506381621 | (37.7612857352771, -122.445506381621) | |||
| 44679 | 44679 | 101107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.48175694812299 | (37.7542321578078, -122.481756948123) | ||
| 44989 | 44989 | 72175 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 9 | 6000606.57902 | 2119937.60106 | 37.80097740645329 | -122.44205899784201 | (37.8009774064533, -122.442058997842) | ||
| 45077 | 45077 | 177085 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 466 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012392.66028 | 2086405.7608400001 | 37.7095709179289 | -122.39891908764099 | (37.7095709179289, -122.398919087641) |
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");