Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
| 44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
| 29762 | 29762 | 191469 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.39423389317699 | (37.7818525865622, -122.394233893177) | |||
| 56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
| 26130 | 26130 | 207916 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994697.354069999 | 2099701.1071099997 | 37.7450748213407 | -122.46103969864201 | (37.7450748213407, -122.461039698642) | |||
| 171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
| 185719 | 185719 | 207828 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999348.944080001 | 2093797.91328 | 37.729132626663706 | -122.444531189165 | (37.7291326266637, -122.444531189165) | |||
| 158347 | 158347 | 177126 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006914.161069999 | 2093507.1567900002 | 37.7287630439686 | -122.41835694803301 | (37.7287630439686, -122.418356948033) | |||
| 102161 | 102161 | 103603 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
| 35298 | 35298 | 207929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995760.63845 | 2092696.4312900002 | 37.7259028185378 | -122.45685654350599 | (37.7259028185378, -122.456856543506) | |||
| 1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
| 89620 | 89620 | 114798 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 14433 | 14433 | 17144 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.5240900002 | 37.728978186084 | -122.38036919809099 | (37.728978186084, -122.380369198091) | ||
| 136670 | 136670 | 227260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001350.1729 | 2100676.3582200003 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | |||
| 128542 | 128542 | 14788 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1077 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 6 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.42960364101299 | (37.7788514015092, -122.429603641013) | ||
| 98083 | 98083 | 10181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005777.346268901 | 2102574.3880576002 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | |||
| 156782 | 156782 | 191453 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6014408.51358 | 2116009.54729 | 37.790968756046794 | -122.39402291674 | (37.7909687560468, -122.39402291674) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 114668 | 114668 | 14799 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003745.74789 | 2111758.98852 | 37.778699404291395 | -122.43061221122801 | (37.7786994042914, -122.430612211228) | |||
| 164536 | 164536 | 129639 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | |||
| 172203 | 172203 | 227412 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1151 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003866.70638 | 2101546.0365299997 | 37.750663949580606 | -122.429465247149 | (37.7506639495806, -122.429465247149) | |||
| 173319 | 173319 | 227369 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1156 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008042.16484 | 2101172.50837 | 37.749873847504 | -122.41499968439699 | (37.749873847504, -122.414999684397) | |||
| 32273 | 32273 | 227514 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006464.67083 | 2109591.57876 | 37.7729018752621 | -122.42105245002399 | (37.7729018752621, -122.421052450024) | |||
| 161764 | 161764 | 129636 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1181 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007340.70028 | 2119141.2469900004 | 37.7991722746363 | -122.41869950788299 | (37.7991722746363, -122.418699507883) | |||
| 185976 | 185976 | 227167 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 119 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998089.83813 | 2106503.39659 | 37.76394685618 | -122.449799262145 | (37.76394685618, -122.449799262145) | |||
| 2249 | 2249 | 191500 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016876.9140800005 | 2094649.78681 | 37.732456273623704 | -122.38399426453998 | (37.7324562736237, -122.38399426454) | |||
| 51847 | 51847 | 191496 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6016644.61171 | 2094800.97865 | 37.732858570949205 | -122.38480792526899 | (37.7328585709492, -122.384807925269) | |||
| 58191 | 58191 | 207377 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5992030.8504800005 | 2107135.40247 | 37.7653336512411 | -122.47080133672199 | (37.7653336512411, -122.470801336722) | ||||
| 53838 | 53838 | 207378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5992032.39492 | 2107035.89745 | 37.7650605262515 | -122.470788746219 | (37.7650605262515, -122.470788746219) | |||
| 39732 | 39732 | 140575 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003289.1195 | 2111701.1038 | 37.7785145879996 | -122.43218773018499 | (37.7785145879996, -122.432187730185) | |||
| 138769 | 138769 | 7210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 72591 | 72591 | 177042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | |||
| 54907 | 54907 | 207912 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 125 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993750.78708 | 2099620.0090799998 | 37.744797631402996 | -122.46430684749501 | (37.744797631403, -122.464306847495) | |||
| 33447 | 33447 | 208010 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998766.05843 | 2093398.5760400002 | 37.728002863243205 | -122.446517546066 | (37.7280028632432, -122.446517546066) | |||
| 11530 | 11530 | 77642 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006942.1040900005 | 2093179.9332599998 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | |
| 7129 | 7129 | 20204 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002765.7195 | 2112737.651 | 37.7813309972121 | -122.434072484072 | (37.7813309972121, -122.434072484072) | |||
| 84373 | 84373 | 12120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) | |||
| 63493 | 63493 | 227262 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1334 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001352.76553 | 2099787.74958 | 37.745693456895204 | -122.43803271325001 | (37.7456934568952, -122.43803271325) | |||
| 39043 | 39043 | 191474 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6014326.7569699995 | 2112466.04784 | 37.781234576959896 | -122.39405762156 | (37.7812345769599, -122.39405762156) | |||
| 80877 | 80877 | 25291 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
| 78963 | 78963 | 12206 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 70640 | 70640 | 191448 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1375 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | |||
| 74148 | 74148 | 227250 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Park St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005794.59689 | 2096357.13637 | 37.7365253704536 | -122.422429779736 | (37.7365253704536, -122.422429779736) | |||
| 117602 | 117602 | 12166 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 173912 | 173912 | 227494 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 144 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003810.62137 | 2097507.3684900003 | 37.7395715262114 | -122.429371225707 | (37.7395715262114, -122.429371225707) | |||
| 46018 | 46018 | 207936 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.84945 | 2094603.0079700002 | 37.731195952027996 | -122.453491559201 | (37.731195952028, -122.453491559201) | |||
| 163117 | 163117 | 191445 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 19th St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013335.759880001 | 2105192.0474900003 | 37.761206675862205 | -122.396975847857 | (37.7612066758622, -122.396975847857) | |||
| 182800 | 182800 | 227173 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 146 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997978.59141 | 2106212.21025 | 37.763140966494 | -122.450163039697 | (37.763140966494, -122.450163039697) | |||
| 57403 | 57403 | 207920 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993561.46186 | 2095084.6811400002 | 37.73233383991511 | -122.46463222850599 | (37.7323338399151, -122.464632228506) | |||
| 165662 | 165662 | 141576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1480 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000723.6824 | 2110698.6413 | 37.7756162917204 | -122.440990592453 | (37.7756162917204, -122.440990592453) | |||
| 147949 | 147949 | 247848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 149 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6009193.51112 | 2098205.9216299998 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | ||||
| 59557 | 59557 | 142177 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1490 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000750.4323 | 2110355.4784 | 37.7746755766034 | -122.44087343567 | (37.7746755766034, -122.44087343567) | |||
| 126982 | 126982 | 115658 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000749.0 | 2110266.0 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | |||
| 262 | 262 | 141360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 46122 | 46122 | 191503 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 15 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6017915.59707 | 2093553.456 | 37.7295033317063 | -122.380327088241 | (37.7295033317063, -122.380327088241) | |||
| 180832 | 180832 | 129622 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1513 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007514.975880001 | 2116792.81742 | 37.792733882423 | -122.417929887875 | (37.792733882423, -122.417929887875) | |||
| 161810 | 161810 | 38641 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | 16 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931001 | (37.7308498822776, -122.39056651931) | |
| 86507 | 86507 | 105174 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 67542 | 67542 | 200695 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1603 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015131.4073 | 2095732.6408 | 37.735332917815704 | -122.39010456562599 | (37.7353329178157, -122.390104565626) | |||
| 108877 | 108877 | 107463 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | |||||
| 159356 | 159356 | 139818 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1672 EDDY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002454.8426 | 2112669.6973 | 37.7811267653815 | -122.43514310289801 | (37.7811267653815, -122.435143102898) | |||
| 82832 | 82832 | 6003 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 119444 | 119444 | 15325 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1X1 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 166825 | 166825 | 248057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 17 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010678.5248 | 2099352.93022 | 37.7450254773569 | -122.405754830944 | (37.7450254773569, -122.405754830944) | ||||
| 60893 | 60893 | 129592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.79392892673889 | -122.42362005315 | (37.7939289267389, -122.42362005315) | |||
| 151985 | 151985 | 129610 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005886.38297 | 2117589.46023 | 37.7948294727542 | -122.423621560411 | (37.7948294727542, -122.423621560411) | |||
| 176132 | 176132 | 138670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1718 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999600.9508 | 2114760.7686 | 37.786705834843204 | -122.44516649185199 | (37.7867058348432, -122.445166491852) | |||
| 49205 | 49205 | 129595 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005777.14779 | 2117244.21265 | 37.793875343329795 | -122.42397496697599 | (37.7938753433298, -122.423974966976) | |||
| 21469 | 21469 | 15341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1735 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006768.902000001 | 2108274.3401 | 37.769302196475294 | -122.419906586242 | (37.7693021964753, -122.419906586242) | |||
| 53485 | 53485 | 227366 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 176 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008045.71887 | 2101127.40788 | 37.749750211412604 | -122.41498420258002 | (37.7497502114126, -122.41498420258) | |||
| 157248 | 157248 | 227201 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 178 Highland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006058.903630001 | 2096605.43384 | 37.7372220464653 | -122.421533586412 | (37.7372220464653, -122.421533586412) | |||
| 187811 | 187811 | 101108 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.754334289199704 | -122.481765355128 | (37.7543342891997, -122.481765355128) | ||
| 6106 | 6106 | 7959 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005709.66614 | 2116337.52814 | 37.791382005314 | -122.424143948706 | (37.791382005314, -122.424143948706) | |||
| 170777 | 170777 | 200060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6014881.3338 | 2094088.2009 | 37.7308037462249 | -122.390854280531 | (37.7308037462249, -122.390854280531) | |||
| 60162 | 60162 | 244025 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997747.9602 | 2108846.3652 | 37.7703604843866 | -122.451150685898 | (37.7703604843866, -122.451150685898) | |||
| 115150 | 115150 | 96700 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997732.0 | 2108845.0 | 37.770355822096704 | -122.451205793491 | (37.7703558220967, -122.451205793491) | |||
| 134338 | 134338 | 129590 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | |||
| 28195 | 28195 | 191490 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008642.47534 | 2110374.13795 | 37.775173122971296 | -122.41357449906299 | (37.7751731229713, -122.413574499063) | |||
| 102300 | 102300 | 35728 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 180446 | 180446 | 227253 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006109.760840001 | 2096378.48743 | 37.7366017696511 | -122.421341637808 | (37.7366017696511, -122.421341637808) | |||
| 148786 | 148786 | 177071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | |||
| 79769 | 79769 | 113436 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 97683 | 97683 | 98677 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 167437 | 167437 | 226661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.99983 | 2108080.69145 | 37.7686555760307 | -122.42693488134199 | (37.7686555760307, -122.426934881342) | |||
| 24746 | 24746 | 207954 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 20 Sotelo Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994065.04944 | 2100893.3637099997 | 37.7483120506561 | -122.46331257952801 | (37.7483120506561, -122.463312579528) | |||
| 168921 | 168921 | 250110 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006127.47241 | 2115428.56912 | 37.7889098112749 | -122.422633725286 | (37.7889098112749, -122.422633725286) | |||
| 64260 | 64260 | 226666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004707.88321 | 2109244.5049400004 | 37.771849706222504 | -122.42710466345899 | (37.7718497062225, -122.427104663459) | |||
| 163801 | 163801 | 244961 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 202 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005161.4093 | 2109786.5938 | 37.7733637868695 | -122.425574471379 | (37.7733637868695, -122.425574471379) | |||
| 186971 | 186971 | 72130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | ||
| 2918 | 2918 | 140306 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997911.1716 | 2109955.9635 | 37.773416499401705 | -122.450666152059 | (37.7734164994017, -122.450666152059) | |||
| 32769 | 32769 | 226755 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004144.01902 | 2098653.98264 | 37.7427387360976 | -122.428300179912 | (37.7427387360976, -122.428300179912) | |||
| 7677 | 7677 | 11437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005576.77796 | 2117294.0070599997 | 37.7940007519905 | -122.42467181025499 | (37.7940007519905, -122.424671810255) | |||
| 60928 | 60928 | 207951 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993609.19049 | 2101330.01407 | 37.7494847081672 | -122.4649206222 | (37.7494847081672, -122.4649206222) | |||
| 145902 | 145902 | 15426 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006897.56767 | 2106023.27679 | 37.7631285540423 | -122.419301827609 | (37.7631285540423, -122.419301827609) | |||
| 104609 | 104609 | 121041 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | ||||
| 173003 | 173003 | 129607 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005934.12087 | 2117690.49416 | 37.7951095809901 | -122.42346356661001 | (37.7951095809901, -122.42346356661) | |||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
| 49898 | 49898 | 129598 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005541.322269999 | 2117252.79941 | 37.7938856036766 | -122.42479155769101 | (37.7938856036766, -122.424791557691) | |||
| 89649 | 89649 | 27488 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
| 159007 | 159007 | 248522 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998868.9787 | 2107725.2392 | 37.7673462757129 | -122.44719239933501 | (37.7673462757129, -122.447192399335) |
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");