trees
2,180 rows where qSpecies_id = 57 sorted by Longitude
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
| 14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
| 102592 | 17145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
| 193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
| 135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
| 76187 | 191503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6017915.59707 | 2093553.456 | 37.7295033317063 | -122.380327088241 | (37.7295033317063, -122.380327088241) | 10 | 3 | 8 | 58 | 1 | |||
| 76196 | 17144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.52409 | 37.728978186084 | -122.380369198091 | (37.728978186084, -122.380369198091) | 10 | 3 | 8 | 58 | 1 | ||
| 18778 | 1705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017900.5576644 | 2093604.0676713 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | 10 | 3 | 8 | 58 | 1 | |||
| 133841 | 191504 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6017862.18303 | 2093613.8535 | 37.7296662241092 | -122.38051594408 | (37.7296662241092, -122.38051594408) | 10 | 3 | 8 | 58 | 1 | |||
| 177429 | 1702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | 10 | 3 | 8 | 58 | 1 | |||
| 163286 | 1687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.380817071263 | (37.729651522897, -122.380817071263) | 10 | 3 | 8 | 58 | 1 | ||
| 70646 | 1696 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017739.6025757 | 2093657.002741 | 37.7297779384797 | -122.380942720777 | (37.7297779384797, -122.380942720777) | 10 | 3 | 8 | 58 | 1 | |||
| 159405 | 1691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017695.7876646 | 2093605.1145142 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | 10 | 3 | 8 | 58 | 1 | |||
| 125806 | 6715 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 179786 | 6751 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.538 | 37.7381731451641 | -122.381854690145 | (37.7381731451641, -122.381854690145) | 10 | 3 | 8 | 58 | 1 | |||
| 193927 | 6754 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
| 121804 | 191449 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1224 Fairfax Ave | 4 | : | Tree | Private 2 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | 10 | 3 | 8 | 58 | 1 | |||
| 5567 | 6767 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017316.52552 | 2096883.88974 | 37.7386149694956 | -122.382629809543 | (37.7386149694956, -122.382629809543) | 10 | 3 | 8 | 58 | 1 | ||
| 127774 | 6762 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782839 | (37.7386467866108, -122.38268782839) | 10 | 3 | 8 | 58 | 1 | ||
| 22254 | 199896 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1231 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017188.7375 | 2093143.079 | 37.728336384515 | -122.382811392019 | (37.728336384515, -122.382811392019) | 10 | 3 | 8 | 58 | 1 | |||
| 184435 | 191450 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Fairfax Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017131.85969 | 2097105.51243 | 37.7392132974473 | -122.383283724566 | (37.7392132974473, -122.383283724566) | 10 | 3 | 8 | 58 | 1 | |||
| 143348 | 191501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 27 | 6016915.88272 | 2095866.14342 | 37.7357983009387 | -122.383944206463 | (37.7357983009387, -122.383944206463) | 10 | 3 | 8 | 58 | 1 | ||||
| 55059 | 191500 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1196 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6016876.91408 | 2094649.78681 | 37.7324562736237 | -122.38399426454 | (37.7324562736237, -122.38399426454) | 10 | 3 | 8 | 58 | 1 | |||
| 56819 | 12120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1325X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016848.2078526 | 2094661.9057693 | 37.7324879628386 | -122.38409435335 | (37.7324879628386, -122.38409435335) | 10 | 3 | 8 | 58 | 1 | |||
| 119471 | 12118 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1325X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016848.2078526 | 2094661.9057693 | 37.7324879628386 | -122.38409435335 | (37.7324879628386, -122.38409435335) | 10 | 3 | 8 | 58 | 1 | |||
| 110667 | 191499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1196 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016833.73477 | 2094673.48546 | 37.7325189581847 | -122.38414519684 | (37.7325189581847, -122.38414519684) | 10 | 3 | 8 | 58 | 1 | |||
| 36498 | 191448 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | 10 | 3 | 8 | 58 | 1 | |||
| 10089 | 83062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016802.22624 | 2097268.63088 | 37.7396429656544 | -122.384434818109 | (37.7396429656544, -122.384434818109) | 10 | 3 | 8 | 58 | 1 | |||
| 20725 | 12209 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
| 24245 | 12204 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
| 33830 | 12207 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
| 39963 | 12206 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
| 190969 | 12205 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
| 14969 | 191498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.7327671503753 | -122.384640862701 | (37.7327671503753, -122.384640862701) | 10 | 3 | 8 | 58 | 1 | |||
| 99533 | 191497 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6016662.8976 | 2094787.97273 | 37.7328238706214 | -122.384743799985 | (37.7328238706214, -122.384743799985) | 10 | 3 | 8 | 58 | 1 | |||
| 37387 | 191496 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6016644.61171 | 2094800.97865 | 37.7328585709492 | -122.384807925269 | (37.7328585709492, -122.384807925269) | 10 | 3 | 8 | 58 | 1 | |||
| 120292 | 191495 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6016624.88641 | 2094815.22838 | 37.7328966068827 | -122.384877113693 | (37.7328966068827, -122.384877113693) | 10 | 3 | 8 | 58 | 1 | |||
| 160135 | 191494 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6016613.84098 | 2094824.19976 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | 10 | 3 | 8 | 58 | 1 | |||
| 186770 | 200629 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1433 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016516.3925 | 2094928.5537 | 37.7332017742072 | -122.385260102357 | (37.7332017742072, -122.385260102357) | 10 | 3 | 8 | 58 | 1 | |||
| 136197 | 200625 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1431 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016504.462 | 2094945.5077 | 37.7332476664901 | -122.385302530701 | (37.7332476664901, -122.385302530701) | 10 | 3 | 8 | 58 | 1 | |||
| 39135 | 12169 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.385349476433 | (37.7333003856228, -122.385349476433) | 10 | 3 | 8 | 58 | 1 | ||
| 59284 | 191502 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 29 | Median : Yard | Tree | DPW 1 | 7 | 6016510.31046 | 2096089.32701 | 37.7363886887837 | -122.385361989469 | (37.7363886887837, -122.385361989469) | 10 | 3 | 8 | 58 | 1 | ||||
| 122469 | 40057 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | 10 | 3 | 8 | 58 | 1 | ||
| 101779 | 200578 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1423 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016466.7865 | 2094992.602 | 37.7333748936582 | -122.385436067152 | (37.7333748936582, -122.385436067152) | 10 | 3 | 8 | 58 | 1 | |||
| 178739 | 40056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672355 | -122.385451738871 | (37.727949672355, -122.385451738871) | 10 | 3 | 8 | 58 | 1 | |
| 110546 | 200621 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1421 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016453.6001 | 2095015.2073 | 37.7334362337312 | -122.38548323144 | (37.7334362337312, -122.38548323144) | 10 | 3 | 8 | 58 | 1 | |||
| 43613 | 200620 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1417 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016438.5299 | 2095044.7197 | 37.7335164350719 | -122.385537389897 | (37.7335164350719, -122.385537389897) | 10 | 3 | 8 | 58 | 1 | |||
| 188349 | 12174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016429.111 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | 10 | 3 | 8 | 58 | 1 | |||
| 183264 | 12175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.7336119107928 | -122.385607138859 | (37.7336119107928, -122.385607138859) | 10 | 3 | 8 | 58 | 1 | |||
| 81093 | 12173 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.7336733897742 | -122.385645619675 | (37.7336733897742, -122.385645619675) | 10 | 3 | 8 | 58 | 1 | ||
| 155800 | 12179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973633 | -122.385668291381 | (37.733710973633, -122.385668291381) | 10 | 3 | 8 | 58 | 1 | |||
| 156338 | 200608 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1403 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016392.0635 | 2095142.048 | 37.7337811080514 | -122.385704820187 | (37.7337811080514, -122.385704820187) | 10 | 3 | 8 | 58 | 1 | |||
| 184036 | 12181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.7338307263114 | -122.385729969415 | (37.7338307263114, -122.385729969415) | 10 | 3 | 8 | 58 | 1 | |||
| 58806 | 200576 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1447 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016355.016 | 2095246.9114 | 37.7340669918878 | -122.385840212342 | (37.7340669918878, -122.385840212342) | 10 | 3 | 8 | 58 | 1 | |||
| 21555 | 200575 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016348.7367 | 2095270.7725 | 37.7341321622018 | -122.385863584669 | (37.7341321622018, -122.385863584669) | 10 | 3 | 8 | 58 | 1 | |||
| 23984 | 12171 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
| 26949 | 12165 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 94033 | 12170 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
| 119266 | 12172 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 132147 | 12176 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 149858 | 12178 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1409X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 151018 | 12177 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 155782 | 12166 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1439X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 161788 | 12180 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1403X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
| 163827 | 12185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.7342763655711 | -122.385906337047 | (37.7342763655711, -122.385906337047) | 10 | 3 | 8 | 58 | 1 | |||
| 119189 | 12183 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016331.0601118 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | 10 | 3 | 8 | 58 | 1 | |||
| 78929 | 12184 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016331.1548 | 2095344.2396 | 37.7343329151573 | -122.385929490724 | (37.7343329151573, -122.385929490724) | 10 | 3 | 8 | 58 | 1 | |||
| 71642 | 12182 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016313.573 | 2095416.4509 | 37.7345302198999 | -122.38599530928 | (37.7345302198999, -122.38599530928) | 10 | 3 | 8 | 58 | 1 | |||
| 166982 | 12187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | 10 | 3 | 8 | 58 | 1 | |||
| 129797 | 12186 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138 | (37.7346703842439, -122.38607488138) | 10 | 3 | 8 | 58 | 1 | |||
| 86723 | 12188 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1457 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016282.8047 | 2095488.6622 | 37.7347267947864 | -122.386106718848 | (37.7347267947864, -122.386106718848) | 10 | 3 | 8 | 58 | 1 | |||
| 193836 | 12192 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016272.6778818 | 2095480.4561364 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | 10 | 3 | 8 | 58 | 1 | |||
| 71501 | 200524 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016218.7564 | 2095580.3392 | 37.7349749763778 | -122.386334547429 | (37.7349749763778, -122.386334547429) | 10 | 3 | 8 | 58 | 1 | |||
| 49849 | 12198 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1485 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016165.7013657 | 2095622.0691082 | 37.7350866214264 | -122.386520887893 | (37.7350866214264, -122.386520887893) | 10 | 3 | 8 | 58 | 1 | |||
| 69188 | 191446 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Tulare St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6016252.95003 | 2100312.60959 | 37.7479707183947 | -122.386546192477 | (37.7479707183947, -122.386546192477) | 3 | 8 | 58 | 1 | |||||
| 79516 | 12201 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1485 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 6016149.0568 | 2095651.2946 | 37.7351659473192 | -122.386580471876 | (37.7351659473192, -122.386580471876) | 10 | 3 | 8 | 58 | 1 | |||
| 40197 | 12213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | 10 | 3 | 8 | 58 | 1 | |||
| 189400 | 12214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1505 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015992.7036 | 2095777.5074 | 37.735503845269 | -122.38712984693 | (37.735503845269, -122.38712984693) | 10 | 3 | 8 | 58 | 1 | |||
| 123193 | 191505 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1499 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015798.08452 | 2096291.08713 | 37.7369032520929 | -122.387838548819 | (37.7369032520929, -122.387838548819) | 10 | 3 | 8 | 58 | 1 | |||
| 12497 | 11955 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | 10 | 3 | 8 | 58 | 1 | |||
| 75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
| 69664 | 200695 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1603 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015131.4073 | 2095732.6408 | 37.7353329178157 | -122.390104565626 | (37.7353329178157, -122.390104565626) | 10 | 3 | 8 | 58 | 1 | |||
| 19574 | 261987 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1599x Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014919 | 2092067 | 37.7252560234082 | -122.390582878929 | (37.7252560234082, -122.390582878929) | 10 | 3 | 8 | 58 | 1 | ||||
| 192329 | 200062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014902.219 | 2094116.2312 | 37.7308818705774 | -122.390784034613 | (37.7308818705774, -122.390784034613) | 10 | 3 | 8 | 58 | 1 | |||
| 106586 | 200061 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014890.6772 | 2094101.3916 | 37.7308404836446 | -122.390822900138 | (37.7308404836446, -122.390822900138) | 10 | 3 | 8 | 58 | 1 | |||
| 179739 | 200060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6014881.3338 | 2094088.2009 | 37.7308037462249 | -122.390854280531 | (37.7308037462249, -122.390854280531) | 10 | 3 | 8 | 58 | 1 | |||
| 189764 | 200059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6014873.6392 | 2094076.1095 | 37.7307701187384 | -122.390880037484 | (37.7307701187384, -122.390880037484) | 10 | 3 | 8 | 58 | 1 | |||
| 34022 | 200058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6014865.9446 | 2094065.6668 | 37.7307410182438 | -122.390905909596 | (37.7307410182438, -122.390905909596) | 10 | 3 | 8 | 58 | 1 | |||
| 141228 | 191435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1310 Indiana St | 1 | : Yard | Tree | Private 2 | 1 | 6014946.60084 | 2102566.45751 | 37.7540869042097 | -122.391221052827 | (37.7540869042097, -122.391221052827) | 10 | 3 | 8 | 28856 | 29 | ||||
| 37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
| 68654 | 89034 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 68814 | 89032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 85101 | 89033 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 163617 | 89035 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 171918 | 89036 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 139092 | 60030 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 19 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19518 | 6014680.95467774 | 2112862.0838824 | 37.7823416816232 | -122.392859978153 | (37.7823416816232, -122.392859978153) | 6 | 2 | 9 | 28856 | 6 | ||
| 181602 | 60022 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 64 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | 6 | 2 | 9 | 28856 | 6 | ||
| 9894 | 60029 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.393315638611 | (37.7818164104522, -122.393315638611) | 6 | 2 | 9 | 28856 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );