Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 146083 | 146083 | 17143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 15890 | 15890 | 17142 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.7049599998 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | ||
| 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) | |||
| 18155 | 18155 | 1705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017900.557664401 | 2093604.0676713001 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | |||
| 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) | ||
| 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) | |||
| 141287 | 141287 | 1702 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | |||
| 16400 | 16400 | 1687 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.38081707126301 | (37.729651522897, -122.380817071263) | ||
| 85072 | 85072 | 1696 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017739.602575701 | 2093657.002741 | 37.72977793847971 | -122.380942720777 | (37.7297779384797, -122.380942720777) | |||
| 123069 | 123069 | 1691 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017695.7876646 | 2093605.1145141998 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | |||
| 104152 | 104152 | 6715 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 15662 | 15662 | 6752 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017539.76894 | 2096719.1679599998 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | |||
| 23320 | 23320 | 6751 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.5380000002 | 37.738173145164104 | -122.38185469014499 | (37.7381731451641, -122.381854690145) | |||
| 9486 | 9486 | 6754 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 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) | |||
| 15398 | 15398 | 6762 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782838999 | (37.7386467866108, -122.38268782839) | ||
| 78861 | 78861 | 6767 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017284.4858800005 | 2096909.9197200001 | 37.738684672549205 | -122.38274239930401 | (37.7386846725492, -122.382742399304) | ||
| 67270 | 67270 | 199896 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1231 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017188.7375 | 2093143.0790000001 | 37.728336384514996 | -122.38281139201901 | (37.728336384515, -122.382811392019) | |||
| 167236 | 167236 | 191450 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Fairfax Ave | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017131.85969 | 2097105.51243 | 37.73921329744729 | -122.383283724566 | (37.7392132974473, -122.383283724566) | |||
| 154902 | 154902 | 191501 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016915.88272 | 2095866.14342 | 37.735798300938704 | -122.383944206463 | (37.7357983009387, -122.383944206463) | ||||
| 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) | |||
| 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) | |||
| 105819 | 105819 | 12118 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) | |||
| 2255 | 2255 | 191499 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016833.73477 | 2094673.4854599999 | 37.732518958184706 | -122.38414519683998 | (37.7325189581847, -122.38414519684) | |||
| 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) | |||
| 133643 | 133643 | 83062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2006 12:00:00 AM | 6 | 6016802.22624 | 2097268.63088 | 37.7396429656544 | -122.384434818109 | (37.7396429656544, -122.384434818109) | ||
| 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) | |||
| 124800 | 124800 | 12209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 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) | |||
| 129260 | 129260 | 12204 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 145506 | 145506 | 12205 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 2246 | 2246 | 191498 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.732767150375295 | -122.38464086270099 | (37.7327671503753, -122.384640862701) | |||
| 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) | |||
| 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) | |||
| 51985 | 51985 | 191495 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6016624.88641 | 2094815.22838 | 37.732896606882704 | -122.38487711369301 | (37.7328966068827, -122.384877113693) | |||
| 2259 | 2259 | 191494 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6016613.84098 | 2094824.1997599998 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | |||
| 43627 | 43627 | 200629 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1433 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016516.3925 | 2094928.5537 | 37.7332017742072 | -122.38526010235701 | (37.7332017742072, -122.385260102357) | |||
| 53966 | 53966 | 191502 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016510.31046 | 2096089.32701 | 37.736388688783705 | -122.38536198946899 | (37.7363886887837, -122.385361989469) | ||||
| 42829 | 42829 | 200625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1431 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016504.462 | 2094945.5077 | 37.7332476664901 | -122.38530253070101 | (37.7332476664901, -122.385302530701) | |||
| 14202 | 14202 | 12169 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.38534947643299 | (37.7333003856228, -122.385349476433) | ||
| 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) | |||
| 179892 | 179892 | 200621 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1421 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016453.6001 | 2095015.2073 | 37.733436233731204 | -122.38548323143999 | (37.7334362337312, -122.38548323144) | |||
| 61504 | 61504 | 200620 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1417 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016438.5299 | 2095044.7197 | 37.7335164350719 | -122.38553738989701 | (37.7335164350719, -122.385537389897) | |||
| 106910 | 106910 | 40057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | ||
| 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) | |||
| 39400 | 39400 | 40056 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672354995 | -122.385451738871 | (37.727949672355, -122.385451738871) | |
| 16816 | 16816 | 12175 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.733611910792796 | -122.385607138859 | (37.7336119107928, -122.385607138859) | |||
| 15744 | 15744 | 12173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.733673389774204 | -122.385645619675 | (37.7336733897742, -122.385645619675) | ||
| 16102 | 16102 | 12179 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973632995 | -122.385668291381 | (37.733710973633, -122.385668291381) | |||
| 186910 | 186910 | 200608 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1403 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016392.0635 | 2095142.0480000002 | 37.7337811080514 | -122.385704820187 | (37.7337811080514, -122.385704820187) | |||
| 16755 | 16755 | 12181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.733830726311396 | -122.385729969415 | (37.7338307263114, -122.385729969415) | |||
| 133974 | 133974 | 200576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1447 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6016355.016 | 2095246.9114 | 37.7340669918878 | -122.38584021234199 | (37.7340669918878, -122.385840212342) | |||
| 172075 | 172075 | 200575 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016348.7367 | 2095270.7725 | 37.734132162201796 | -122.385863584669 | (37.7341321622018, -122.385863584669) | |||
| 93142 | 93142 | 12170 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | ||
| 107076 | 107076 | 12176 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 109337 | 109337 | 12172 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 110828 | 110828 | 12178 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1409X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 112287 | 112287 | 12177 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 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) | |||
| 121121 | 121121 | 12180 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1403X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 124246 | 124246 | 12171 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | ||
| 129338 | 129338 | 12165 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 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) | |||
| 14865 | 14865 | 12184 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016331.1548 | 2095344.2396 | 37.734332915157296 | -122.385929490724 | (37.7343329151573, -122.385929490724) | |||
| 107274 | 107274 | 12183 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016331.060111799 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | |||
| 14416 | 14416 | 12182 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016313.573 | 2095416.4509 | 37.734530219899895 | -122.38599530928002 | (37.7345302198999, -122.38599530928) | |||
| 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) | |||
| 15422 | 15422 | 12186 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138001 | (37.7346703842439, -122.38607488138) | |||
| 14762 | 14762 | 12188 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1457 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016282.8047 | 2095488.6622 | 37.734726794786404 | -122.386106718848 | (37.7347267947864, -122.386106718848) | |||
| 146117 | 146117 | 12192 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016272.6778818 | 2095480.4561363999 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | |||
| 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) | ||||
| 135248 | 135248 | 200524 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6016218.7564 | 2095580.3392 | 37.7349749763778 | -122.386334547429 | (37.7349749763778, -122.386334547429) | |||
| 82904 | 82904 | 12198 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016165.701365701 | 2095622.0691082 | 37.7350866214264 | -122.38652088789301 | (37.7350866214264, -122.386520887893) | |||
| 23120 | 23120 | 12201 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6016149.0568 | 2095651.2946 | 37.7351659473192 | -122.38658047187599 | (37.7351659473192, -122.386580471876) | |||
| 14180 | 14180 | 12213 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | |||
| 16425 | 16425 | 12214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1505 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015992.7036 | 2095777.5074 | 37.735503845269 | -122.38712984693001 | (37.735503845269, -122.38712984693) | |||
| 45171 | 45171 | 191505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015798.08452 | 2096291.0871299999 | 37.7369032520929 | -122.387838548819 | (37.7369032520929, -122.387838548819) | |||
| 47442 | 47442 | 11955 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | |||
| 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) | |||
| 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) | |
| 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) | |
| 70114 | 70114 | 38632 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 17 | 6x60 | Permit Number 767658 | 6014957.1802 | 2094111.5595 | 37.730872092312204 | -122.390593696874 | (37.7308720923122, -122.390593696874) |
| 165387 | 165387 | 191435 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1310 Indiana St | 1 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014946.60084 | 2102566.4575099996 | 37.75408690420971 | -122.39122105282699 | (37.7540869042097, -122.391221052827) | ||||
| 127629 | 127629 | 60032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004008999 | (37.7817828574395, -122.39203004009) | ||
| 176366 | 176366 | 200062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014902.219 | 2094116.2312 | 37.7308818705774 | -122.390784034613 | (37.7308818705774, -122.390784034613) | |||
| 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) | |||
| 84994 | 84994 | 89034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 88400 | 88400 | 89032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 97203 | 97203 | 89033 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 120775 | 120775 | 89035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 143097 | 143097 | 89036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 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) | |||
| 173295 | 173295 | 200059 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6014873.6392 | 2094076.1095 | 37.7307701187384 | -122.390880037484 | (37.7307701187384, -122.390880037484) | |||
| 165150 | 165150 | 200058 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6014865.9446 | 2094065.6668 | 37.7307410182438 | -122.390905909596 | (37.7307410182438, -122.390905909596) | |||
| 112751 | 112751 | 60030 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 19 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19518 | 6014680.95467774 | 2112862.0838824 | 37.7823416816232 | -122.392859978153 | (37.7823416816232, -122.392859978153) | ||
| 141136 | 141136 | 60022 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 64 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | ||
| 68009 | 68009 | 60029 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 21 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.39331563861099 | (37.7818164104522, -122.393315638611) | |
| 185619 | 185619 | 191460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6014521.60501 | 2115886.5907099997 | 37.7906374305211 | -122.393623012505 | (37.7906374305211, -122.393623012505) |
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");