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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 35900 | 35900 | 177084 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 199 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012033.75638 | 2087275.42031 | 37.71193882479629 | -122.400220567635 | (37.7119388247963, -122.400220567635) | |||
| 160832 | 160832 | 177043 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 87 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000241.05575 | 2089872.3479 | 37.7184047866172 | -122.441165561868 | (37.7184047866172, -122.441165561868) | |||
| 149576 | 149576 | 177053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998955.229780001 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | |||
| 58525 | 58525 | 207855 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993274.09777 | 2090428.4072099999 | 37.719532280163 | -122.46528760316099 | (37.719532280163, -122.465287603161) | |||
| 156713 | 156713 | 177062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.720141550179896 | -122.44546243984199 | (37.7201415501799, -122.445462439842) | |||
| 103677 | 103677 | 25292 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
| 149329 | 149329 | 207836 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995005.14377 | 2091917.0493299998 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | |||
| 10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
| 153989 | 153989 | 207834 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | |||
| 99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 50894 | 50894 | 177115 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6005069.55264 | 2093328.8991099999 | 37.7281695777432 | -122.424721208244 | (37.7281695777432, -122.424721208244) | |||
| 36312 | 36312 | 177137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 567 Bowdoin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008885.05575 | 2093363.35639 | 37.728478948128 | -122.41153325655199 | (37.728478948128, -122.411533256552) | |||
| 181157 | 181157 | 208009 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998765.79191 | 2093418.2153900003 | 37.72805677307979 | -122.446519879783 | (37.7280567730798, -122.446519879783) | |||
| 123443 | 123443 | 191504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6017862.18303 | 2093613.8535 | 37.7296662241092 | -122.38051594408 | (37.7296662241092, -122.38051594408) | |||
| 179911 | 179911 | 38634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 16 | Permit Number 767658 | 6014976.9663 | 2094092.323 | 37.7308203704303 | -122.390523948894 | (37.7308203704303, -122.390523948894) | |
| 26258 | 26258 | 200061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6014890.6772 | 2094101.3916 | 37.7308404836446 | -122.39082290013799 | (37.7308404836446, -122.390822900138) | |||
| 60586 | 60586 | 207937 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.96274 | 2094591.1270299999 | 37.7311633363083 | -122.45349031003201 | (37.7311633363083, -122.453490310032) | |||
| 125454 | 125454 | 12207 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 70355 | 70355 | 191497 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016662.8976 | 2094787.97273 | 37.7328238706214 | -122.384743799985 | (37.7328238706214, -122.384743799985) | |||
| 76604 | 76604 | 207995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999470.3608 | 2094946.2688099998 | 37.7322926698604 | -122.44419392902799 | (37.7322926698604, -122.444193929028) | |||
| 159816 | 159816 | 208005 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998445.88865 | 2094954.90573 | 37.7322578849907 | -122.447736370247 | (37.7322578849907, -122.447736370247) | |||
| 175820 | 175820 | 207921 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993566.43334 | 2095078.40606 | 37.7323168967005 | -122.46461458559999 | (37.7323168967005, -122.4646145856) | |||
| 88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | 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) | ||||
| 62116 | 62116 | 227254 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6006076.68891 | 2096382.83584 | 37.736611844768895 | -122.42145629056999 | (37.7366118447689, -122.42145629057) | |||
| 86964 | 86964 | 113437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 127620 | 127620 | 102189 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 118133 | 118133 | 73874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 185550 | 185550 | 227343 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008417.48534 | 2096717.53633 | 37.737662563174 | -122.41338678718901 | (37.737662563174, -122.413386787189) | |||
| 132468 | 132468 | 191449 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1224 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | |||
| 166208 | 166208 | 207899 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991539.23475 | 2097072.6474799998 | 37.737675504425795 | -122.47176829317101 | (37.7376755044258, -122.471768293171) | |||
| 131957 | 131957 | 227491 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1893 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004617.88514 | 2097640.41879 | 37.7399825226668 | -122.42658952729099 | (37.7399825226668, -122.426589527291) | |||
| 161457 | 161457 | 207908 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992548.53449 | 2097821.47012 | 37.739789928349 | -122.46833315276301 | (37.739789928349, -122.468333152763) | |||
| 169925 | 169925 | 226756 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6004170.543190001 | 2098656.13064 | 37.7427461348209 | -122.42820861993799 | (37.7427461348209, -122.428208619938) | |||
| 24497 | 24497 | 227291 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 65 Zircon Pl | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.43449077742399 | (37.7428156470274, -122.434490777424) | |||
| 62185 | 62185 | 227290 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 685 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | ||||
| 130319 | 130319 | 227276 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 91 Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001604.247 | 2099100.29306 | 37.743820161875796 | -122.437113918188 | (37.7438201618758, -122.437113918188) | |||
| 175359 | 175359 | 207915 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994699.757 | 2099675.96416 | 37.7450059233763 | -122.461029567757 | (37.7450059233763, -122.461029567757) | |||
| 183703 | 183703 | 227267 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001720.54184 | 2099972.41794 | 37.7462214209976 | -122.436774216378 | (37.7462214209976, -122.436774216378) | |||
| 105778 | 105778 | 105876 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 131196 | 131196 | 207959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.658340001 | 2100247.6965 | 37.7466360605992 | -122.45744403462 | (37.7466360605992, -122.45744403462) | |||
| 24921 | 24921 | 185624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.74612969593421 | -122.49450180509399 | (37.7461296959342, -122.494501805094) | |||
| 24079 | 24079 | 207947 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992701.4282599995 | 2100499.03593 | 37.74715067337829 | -122.467999226394 | (37.7471506733783, -122.467999226394) | |||
| 157800 | 157800 | 227365 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 176 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008045.892659999 | 2101114.02966 | 37.7497134875938 | -122.41498265482599 | (37.7497134875938, -122.414982654826) | |||
| 82923 | 82923 | 92842 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2009 12:00:00 AM | 3x3 | 6006883.0 | 2101475.0 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | |||
| 70070 | 70070 | 227378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006846.58605 | 2101476.05301 | 37.7506400554955 | -122.419155589162 | (37.7506400554955, -122.419155589162) | |||
| 108302 | 108302 | 107956 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 181849 | 181849 | 227282 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4412 23rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6000544.37543 | 2102304.8503 | 37.7525588049644 | -122.441008545612 | (37.7525588049644, -122.441008545612) | |||
| 177377 | 177377 | 226688 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6011388.93256 | 2102376.14008 | 37.7533662558597 | -122.40351101253599 | (37.7533662558597, -122.403511012536) | |||
| 100122 | 100122 | 26530 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2701x Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008955.0644 | 2102702.28881 | 37.7541255388196 | -122.41195091510001 | (37.7541255388196, -122.4119509151) | |||
| 40802 | 40802 | 182830 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1811 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985639.2314 | 2102838.2271 | 37.7531630922797 | -122.49259163632401 | (37.7531630922797, -122.492591636324) | |||
| 32180 | 32180 | 227228 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3181 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007128.07099 | 2103203.65441 | 37.7553995025029 | -122.418304665024 | (37.7553995025029, -122.418304665024) | |||
| 168157 | 168157 | 101109 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | Permit Number 14067 | 5988776.9552 | 2103216.747 | 37.754385370533704 | -122.48176861229099 | (37.7543853705337, -122.481768612291) | ||
| 187155 | 187155 | 227443 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002302.88704 | 2104151.22566 | 37.7577285118836 | -122.43505936211099 | (37.7577285118836, -122.435059362111) | |||
| 96040 | 96040 | 37259 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 68444 | 68444 | 184122 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3340 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983807.3681 | 2104294.0393 | 37.7570530669968 | -122.49903404016001 | (37.7570530669968, -122.49903404016) | |||
| 159520 | 159520 | 227235 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006415.25299 | 2104336.0172200003 | 37.7584685576864 | -122.42085019969801 | (37.7584685576864, -122.420850199698) | |||
| 124552 | 124552 | 33770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 37739 | 37739 | 227447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 240 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004034.0348 | 2104541.75459 | 37.7588989579324 | -122.429100184426 | (37.7588989579324, -122.429100184426) | |||
| 168368 | 168368 | 227422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4611 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000625.69214 | 2104640.24326 | 37.758975857154496 | -122.440894857831 | (37.7589758571545, -122.440894857831) | |||
| 176368 | 176368 | 227427 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4681 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000761.80994 | 2104640.69389 | 37.7589848459033 | -122.44042413199101 | (37.7589848459033, -122.440424131991) | |||
| 184221 | 184221 | 227217 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 775 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009108.8338 | 2104653.1063200003 | 37.7594906686717 | -122.411556961793 | (37.7594906686717, -122.411556961793) | |||
| 155356 | 155356 | 101145 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 6013204.93498 | 2104939.92488 | 37.7605071193183 | -122.397410636789 | (37.7605071193183, -122.397410636789) | |||
| 46988 | 46988 | 116060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | ||
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 137087 | 137087 | 227164 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997856.90065 | 2106470.54587 | 37.7638433262424 | -122.45060255097 | (37.7638433262424, -122.45060255097) | |||
| 144344 | 144344 | 99682 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 83821 | 83821 | 114799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 48599 | 48599 | 227168 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 119 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998108.05626 | 2106506.70041 | 37.76395696996121 | -122.44973648946001 | (37.7639569699612, -122.44973648946) | |||
| 181081 | 181081 | 227190 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1132 Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997735.89415 | 2106562.64297 | 37.764089274613205 | -122.45102771536502 | (37.7640892746132, -122.451027715365) | |||
| 93915 | 93915 | 34045 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 151650 | 151650 | 226670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.09497 | 2106908.52586 | 37.765669970714704 | -122.412552451952 | (37.7656699707147, -122.412552451952) | |||
| 169484 | 169484 | 113963 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.9758099997 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | ||
| 169910 | 169910 | 227184 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 833 Ashbury St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999116.932080001 | 2107411.40192 | 37.766498722059204 | -122.446312187656 | (37.7664987220592, -122.446312187656) | |||
| 121210 | 121210 | 111020 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 32604 | 32604 | 248523 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 Downey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998865.9504 | 2107750.6769 | 37.7674159481781 | -122.447204704709 | (37.7674159481781, -122.447204704709) | |||
| 111912 | 111912 | 246237 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 96 Delmar St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999342.4520000005 | 2107821.6903 | 37.7676381481281 | -122.445561664053 | (37.7676381481281, -122.445561664053) | |||
| 97647 | 97647 | 27658 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 40980 | 40980 | 245071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 8 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000404.0401 | 2108984.869 | 37.770892494718 | -122.44197327427901 | (37.770892494718, -122.441973274279) | |||
| 107186 | 107186 | 103604 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 4 | 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) | ||
| 183840 | 183840 | 226751 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 188 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004780.64342 | 2109066.90336 | 37.7713661695481 | -122.42684033024099 | (37.7713661695481, -122.426840330241) | |||
| 4191 | 4191 | 244054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997907.6831 | 2109139.8095 | 37.771175350707296 | -122.450619366393 | (37.7711753507073, -122.450619366393) | |||
| 46570 | 46570 | 226667 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6004704.0947199995 | 2109267.38309 | 37.7719123098365 | -122.42711939795 | (37.7719123098365, -122.42711939795) | |||
| 155465 | 155465 | 227515 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6006475.3834 | 2109601.81722 | 37.7729305914948 | -122.42101612099701 | (37.7729305914948, -122.421016120997) | |||
| 53214 | 53214 | 227510 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 37 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6006532.91743 | 2109718.55388 | 37.773254365438596 | -122.420825392799 | (37.7732543654386, -122.420825392799) | |||
| 145904 | 145904 | 17040 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.772983491104604 | -122.439151661694 | (37.7729834911046, -122.439151661694) | |||
| 2920 | 2920 | 140307 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997894.6936 | 2109955.1396 | 37.7734132939715 | -122.45072309212 | (37.7734132939715, -122.45072309212) | |||
| 305 | 305 | 191509 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 905 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 97712 | 97712 | 93119 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6000421.0 | 2110261.0 | 37.774397395284 | -122.44200622209299 | (37.774397395284, -122.442006222093) | |||
| 96430 | 96430 | 115659 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000749.0 | 2110266.0 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | |||
| 259 | 259 | 141361 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 188541 | 188541 | 191491 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008660.87674 | 2110356.51617 | 37.7751257709745 | -122.41350959771299 | (37.7751257709745, -122.413509597713) | |||
| 148184 | 148184 | 123769 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993062.81388 | 2110680.4895599997 | 37.7751271410654 | -122.46748986588499 | (37.7751271410654, -122.467489865885) | |||
| 148880 | 148880 | 123766 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 773 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993235.861169999 | 2110685.0962099996 | 37.7751497787963 | -122.466891596882 | (37.7751497787963, -122.466891596882) | |||
| 3002 | 3002 | 141577 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1470 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000705.688999999 | 2110697.4418 | 37.7756119733478 | -122.44105274978997 | (37.7756119733478, -122.44105274979) | |||
| 35118 | 35118 | 249626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997629.20154 | 2111320.8976 | 37.7771481106256 | -122.45174000362199 | (37.7771481106256, -122.451740003622) | |||
| 5775 | 5775 | 14804 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1140 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1994 12:00:00 AM | 3 | 4X4 | 6003547.1646 | 2111783.654 | 37.7787558775283 | -122.431300948764 | (37.7787558775283, -122.431300948764) | ||
| 110687 | 110687 | 12310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004809.18722 | 2111991.6762900003 | 37.7793984956931 | -122.426949936516 | (37.7793984956931, -122.426949936516) | ||
| 114565 | 114565 | 92634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 40077 | 40077 | 191470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014270.7643099995 | 2112702.62209 | 37.7818810438134 | -122.39426789834499 | (37.7818810438134, -122.394267898345) |
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");