trees
2,180 rows where qSpecies_id = 57 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16144 | 227418 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6001168.68328 | 2104120.67938 | 37.7575801713913 | -122.438979708367 | (37.7575801713913, -122.438979708367) | 2 | 4 | 5 | 28862 | 3 | |||
| 16415 | 104004 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.468521397227 | (37.7475310970527, -122.468521397227) | 1 | 8 | 4 | 29491 | 40 | |||||
| 16518 | 26521 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 7.5x7 | 6009000.88013 | 2101922.62199 | 37.7519873190611 | -122.411737385595 | (37.7519873190611, -122.411737385595) | 2 | 4 | 7 | 28859 | 19 | |||
| 16666 | 227467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 43 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999304.11308 | 2105493.67356 | 37.7612438079824 | -122.445526851088 | (37.7612438079824, -122.445526851088) | 15 | 5 | 5 | 28862 | 3 | |||
| 16833 | 23387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006004.32963 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | 13 | 9 | 1 | 28858 | 41 | |||
| 17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
| 17473 | 201860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010161.8818 | 2110817.0652 | 37.7764744978974 | -122.408349755778 | (37.7764744978974, -122.408349755778) | 8 | 2 | 9 | 28853 | 34 | |||
| 17665 | 227296 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4217 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002414.71515 | 2100605.94142 | 37.7480003546327 | -122.43441914105 | (37.7480003546327, -122.43441914105) | 2 | 4 | 5 | 63 | 22 | |||
| 17812 | 129601 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005516.81947 | 2117765.82234 | 37.7952928511338 | -122.424912856464 | (37.7952928511338, -122.424912856464) | 13 | 9 | 1 | 28858 | 27 | |||
| 18458 | 191458 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6014482.2077 | 2115927.08829 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | 12 | 2 | 9 | 28855 | 6 | |||
| 18649 | 73588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007504.43189 | 2118817.2788 | 37.7982919561693 | -122.418109959117 | (37.7982919561693, -122.418109959117) | 5 | 1 | 10 | 28858 | 32 | |||
| 18654 | 227381 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006906.73127 | 2101480.47267 | 37.7506555778088 | -122.418947915021 | (37.7506555778088, -122.418947915021) | 2 | 4 | 7 | 28859 | 19 | |||
| 18765 | 227461 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999855.35997 | 2105564.48757 | 37.7614697005791 | -122.443625415403 | (37.7614697005791, -122.443625415403) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 18794 | 177112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.7228528478523 | -122.445587543638 | (37.7228528478523, -122.445587543638) | 9 | 7 | 6 | 28861 | 25 | |||
| 19061 | 129655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009755.16442 | 2121852.22782 | 37.8067515980625 | -122.410536140452 | (37.8067515980625, -122.410536140452) | 3 | 1 | 10 | 308 | 23 | |||
| 19205 | 27390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | 5 | 1 | 1 | 28858 | 32 | |||
| 19216 | 227376 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006793.51754 | 2101495.5657 | 37.7506906441663 | -122.419340488895 | (37.7506906441663, -122.419340488895) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||||
| 19703 | 129607 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005934.12087 | 2117690.49416 | 37.7951095809901 | -122.42346356661 | (37.7951095809901, -122.42346356661) | 13 | 9 | 1 | 28858 | 27 | |||
| 19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 | ||||
| 19846 | 207404 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2692 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991464.58809 | 2097102.41328 | 37.7377529144574 | -122.472028548874 | (37.7377529144574, -122.472028548874) | 1 | 8 | 4 | 29491 | 40 | |||
| 19856 | 17713 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1230 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002323.545 | 2112760.8562 | 37.7813696081859 | -122.435603850031 | (37.7813696081859, -122.435603850031) | 15 | 5 | 11 | 29490 | 41 | |||
| 20106 | 226744 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010266.86598 | 2102287.21405 | 37.7530593460119 | -122.407385103056 | (37.7530593460119, -122.407385103056) | 2 | 4 | 7 | 28859 | 19 | |||
| 20261 | 141039 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 82 Cook St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997548.9955 | 2113146.6183 | 37.7821564681962 | -122.452149222748 | (37.7821564681962, -122.452149222748) | 15 | 6 | 1 | 54 | 31 | |||
| 20436 | 227185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 979 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999188.84742 | 2106648.55947 | 37.764408255174 | -122.446008572935 | (37.764408255174, -122.446008572935) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 20752 | 129567 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 245 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997570.75273 | 2115509.34341 | 37.7886451327138 | -122.452244490911 | (37.7886451327138, -122.452244490911) | 11 | 6 | 1 | 54 | 31 | |||
| 20799 | 108149 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
| 20889 | 207886 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1332 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995209.49892 | 2106504.03769 | 37.7637833981207 | -122.459761474239 | (37.7637833981207, -122.459761474239) | 15 | 5 | 11 | 56 | 12 | |||
| 20961 | 227167 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 119 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998089.83813 | 2106503.39659 | 37.76394685618 | -122.449799262145 | (37.76394685618, -122.449799262145) | 15 | 5 | 11 | 29492 | 9 | |||
| 21095 | 207966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998008.19389 | 2095778.93089 | 37.7344954360226 | -122.449308921174 | (37.7344954360226, -122.449308921174) | 9 | 7 | 4 | 59 | 40 | |||
| 21193 | 227395 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2080 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008020.65806 | 2106222.15244 | 37.7637378087638 | -122.415431504654 | (37.7637378087638, -122.415431504654) | 8 | 4 | 7 | 28859 | 19 | |||
| 21215 | 208004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998446.15319 | 2094958.35436 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | 9 | 7 | 4 | 59 | 40 | |||
| 21314 | 227469 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5999314.37264 | 2105521.32112 | 37.7613203070113 | -122.445493355853 | (37.7613203070113, -122.445493355853) | 15 | 5 | 5 | 28862 | 3 | |||
| 21324 | 173925 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997414 | 2094357 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | 9 | 7 | 4 | 28861 | 40 | ||||
| 21372 | 207376 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200 14th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 7ft | 5991774.71222 | 2107128.83955 | 37.7653008152139 | -122.471686772321 | (37.7653008152139, -122.471686772321) | 11 | 8 | 11 | 56 | 12 | |||
| 21412 | 207412 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 916 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5996538.53232 | 2098198.85248 | 37.7410557771982 | -122.454564760665 | (37.7410557771982, -122.454564760665) | 9 | 7 | 4 | 59 | 40 | |||
| 21415 | 227187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999316.38206 | 2105982.07335 | 37.7625855326061 | -122.445519538714 | (37.7625855326061, -122.445519538714) | 15 | 5 | 5 | 29492 | 9 | |||
| 21508 | 12295 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 845 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004849.7362 | 2111749.3214 | 37.7787353414927 | -122.426792396306 | (37.7787353414927, -122.426792396306) | 7 | 9 | 11 | 28852 | 41 | |||
| 21518 | 246237 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 96 Delmar St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999342.452 | 2107821.6903 | 37.7676381481281 | -122.445561664053 | (37.7676381481281, -122.445561664053) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 21563 | 227191 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1132 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997742.39239 | 2106527.65668 | 37.7639935831522 | -122.45100271692 | (37.7639935831522, -122.45100271692) | 15 | 5 | 11 | 29492 | 9 | |||
| 21673 | 129611 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005874.36357 | 2117588.54131 | 37.7948262711743 | -122.423663083898 | (37.7948262711743, -122.423663083898) | 13 | 9 | 1 | 28858 | 27 | |||
| 21748 | 207991 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 378 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999591.13062 | 2094983.54982 | 37.7324019240113 | -122.443779078947 | (37.7324019240113, -122.443779078947) | 9 | 7 | 4 | 63 | 40 | ||||
| 21791 | 141984 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004054.425 | 2111804.9181 | 37.7788429977364 | -122.429547653761 | (37.7788429977364, -122.429547653761) | 7 | 9 | 11 | 29490 | 41 | |||
| 21862 | 191445 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1451 19th St | 3 | : | Tree | Private 2 | 4 | Width 4ft | 6013335.75988 | 2105192.04749 | 37.7612066758622 | -122.396975847857 | (37.7612066758622, -122.396975847857) | 10 | 3 | 8 | 28856 | 29 | |||
| 22005 | 227490 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1893 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004623.20474 | 2097581.86585 | 37.7398220503353 | -122.426566965987 | (37.7398220503353, -122.426566965987) | 2 | 7 | 5 | 63 | 7 | |||
| 22129 | 227473 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 17 Uranus Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999351.60308 | 2105616.98762 | 37.7615851087781 | -122.445371470721 | (37.7615851087781, -122.445371470721) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 22285 | 123213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 598 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5993174.18486 | 2111497.33118 | 37.7773763974687 | -122.4671640155 | (37.7773763974687, -122.4671640155) | 11 | 6 | 2 | 54 | 11 | |||
| 22447 | 227487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003972.26213 | 2109022.08762 | 37.7711973766861 | -122.429633361902 | (37.7711973766861, -122.429633361902) | 7 | 9 | 11 | 29492 | 10 | |||
| 22622 | 227470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 25 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999337.97936 | 2105569.85435 | 37.7614549148289 | -122.445415200262 | (37.7614549148289, -122.445415200262) | 15 | 5 | 5 | 28862 | 3 | |||
| 22633 | 141822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004770.3402 | 2112320.581 | 37.7802993903032 | -122.427107758126 | (37.7802993903032, -122.427107758126) | 7 | 9 | 11 | 29490 | 41 | |||
| 22668 | 251576 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490X Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998892 | 2109203 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | 15 | 5 | 11 | 29492 | 9 | ||||
| 22693 | 33770 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||||
| 22866 | 207815 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 225 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5997426.46465 | 2094243.22962 | 37.7302454747445 | -122.451209426987 | (37.7302454747445, -122.451209426987) | 9 | 7 | 4 | 28861 | 40 | |||
| 23340 | 226753 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004702.0529 | 2110024.96112 | 37.7739923194146 | -122.427180432244 | (37.7739923194146, -122.427180432244) | 7 | 9 | 11 | 28852 | 10 | |||
| 23570 | 122138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.474534863989 | (37.7868169072323, -122.474534863989) | 11 | 6 | 1 | 54 | 33 | ||||
| 23720 | 107959 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
| 23747 | 115658 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1499X HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000749 | 2110266 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | 15 | 5 | 11 | 29492 | 10 | |||
| 24120 | 103523 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
| 24153 | 227203 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 178 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006001.94812 | 2096608.93321 | 37.7372284433232 | -122.421730756484 | (37.7372284433232, -122.421730756484) | 2 | 7 | 7 | 28859 | 2 | |||
| 24180 | 227162 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 229 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6004860.09497 | 2100155.21835 | 37.7469012778702 | -122.425931032014 | (37.7469012778702, -122.425931032014) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 24257 | 106128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6012212.28641 | 2101900.78254 | 37.7521069828692 | -122.400630274471 | (37.7521069828692, -122.400630274471) | 10 | 3 | 8 | 28856 | 29 | ||||
| 24610 | 227345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 14 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009170.90718 | 2097296.00281 | 37.7392931797439 | -122.410822679729 | (37.7392931797439, -122.410822679729) | 10 | 7 | 7 | 28859 | 2 | |||
| 24736 | 191441 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012095.50182 | 2101892.00289 | 37.7520763618475 | -122.401033518791 | (37.7520763618475, -122.401033518791) | 10 | 3 | 8 | 28856 | 29 | |||
| 24777 | 121592 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002342 | 2100313 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | 2 | 4 | 5 | 63 | 22 | ||||
| 25305 | 207401 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 142 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991370.52538 | 2104294.44691 | 37.7574949327505 | -122.472878048496 | (37.7574949327505, -122.472878048496) | 1 | 8 | 4 | 56 | 12 | |||
| 25460 | 227484 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 233 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003739.20839 | 2109215.47693 | 37.7717151775349 | -122.43045330438 | (37.7717151775349, -122.43045330438) | 15 | 9 | 11 | 29492 | 10 | |||
| 25584 | 217666 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 82 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5992983.5282 | 2097902.1841 | 37.7400366636409 | -122.466835007041 | (37.7400366636409, -122.466835007041) | 1 | 8 | 4 | 59 | 40 | |||
| 25621 | 250098 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006037.70809 | 2115548.99376 | 37.7892354027317 | -122.422952860496 | (37.7892354027317, -122.422952860496) | 13 | 9 | 1 | 28858 | 41 | |||
| 25707 | 207372 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992112.24246 | 2106307.60409 | 37.7630654432505 | -122.4704595305 | (37.7630654432505, -122.4704595305) | 1 | 8 | 11 | 56 | 12 | |||
| 25788 | 40954 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | 10 | 3 | 8 | 309 | 1 | ||||
| 26118 | 129592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.7939289267389 | -122.42362005315 | (37.7939289267389, -122.42362005315) | 13 | 9 | 1 | 28858 | 27 | |||
| 26208 | 191473 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6014315.40863 | 2112455.42682 | 37.7812047833188 | -122.394096137746 | (37.7812047833188, -122.394096137746) | 6 | 2 | 9 | 28856 | 6 | |||
| 26216 | 207934 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.458712195626 | (37.7465285358768, -122.458712195626) | 1 | 5 | 4 | 59 | 40 | |||
| 26348 | 207878 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1541 12th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5992430.64291 | 2104640.28912 | 37.7585058400038 | -122.469236940844 | (37.7585058400038, -122.469236940844) | 1 | 8 | 4 | 56 | 12 | |||
| 26426 | 129584 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003287.46949 | 2116304.94268 | 37.7911554750944 | -122.432522363823 | (37.7911554750944, -122.432522363823) | 13 | 9 | 1 | 29490 | 27 | |||
| 26547 | 10229 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1417 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005889.94053 | 2100616.07213 | 37.7482248245223 | -122.422402655257 | (37.7482248245223, -122.422402655257) | 2 | 4 | 5 | 28859 | 19 | |||
| 26550 | 122134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991116.74625 | 2115003.65081 | 37.7868848032576 | -122.4745372499 | (37.7868848032576, -122.4745372499) | 11 | 6 | 1 | 54 | 33 | ||||
| 26617 | 227172 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 146 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998001.55588 | 2106218.85614 | 37.7631605285516 | -122.450084092719 | (37.7631605285516, -122.450084092719) | 15 | 5 | 11 | 29492 | 9 | |||
| 26701 | 227234 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3591 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006397.4791 | 2104334.61507 | 37.7584637058621 | -122.420911570306 | (37.7584637058621, -122.420911570306) | 2 | 4 | 7 | 28859 | 19 | |||
| 26738 | 246399 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 612 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998518.6054 | 2108535.307 | 37.7695504903102 | -122.448462630846 | (37.7695504903102, -122.448462630846) | 15 | 5 | 11 | 29492 | 9 | |||
| 26803 | 10196 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6005751.90575 | 2101904.66457 | 37.7517552157318 | -122.422971548421 | (37.7517552157318, -122.422971548421) | 2 | 4 | 5 | 28859 | 19 | |||
| 26834 | 122133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5991114.06572 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | 11 | 6 | 1 | 54 | 33 | ||||
| 26934 | 13003 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010581.7377 | 2120629.8347 | 37.8034415139042 | -122.40758936746 | (37.8034415139042, -122.40758936746) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 26978 | 226736 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3652 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6005358.92953 | 2102566.09607 | 37.7535491707736 | -122.424377554773 | (37.7535491707736, -122.424377554773) | 2 | 4 | 5 | 28859 | 19 | |||
| 27080 | 226746 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010705.09671 | 2100401.8324 | 37.7479070202997 | -122.405736817526 | (37.7479070202997, -122.405736817526) | 2 | 7 | 7 | 28859 | 2 | |||
| 27129 | 227227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3181 22nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007147.96039 | 2103204.37763 | 37.7554026078658 | -122.418235932549 | (37.7554026078658, -122.418235932549) | 2 | 4 | 7 | 28859 | 19 | |||
| 27217 | 191492 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008677.6339 | 2110340.84375 | 37.7750836791036 | -122.413450522147 | (37.7750836791036, -122.413450522147) | 8 | 2 | 9 | 28853 | 34 | |||
| 27297 | 207876 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1541 12th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5992430.48818 | 2104676.5294 | 37.7586053373771 | -122.469240113663 | (37.7586053373771, -122.469240113663) | 1 | 8 | 4 | 56 | 12 | |||
| 27302 | 227378 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006846.58605 | 2101476.05301 | 37.7506400554955 | -122.419155589162 | (37.7506400554955, -122.419155589162) | 2 | 4 | 7 | 28859 | 19 | |||
| 27383 | 109993 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 27441 | 12328 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952524 | -122.427164094387 | (37.780578952524, -122.427164094387) | 7 | 9 | 11 | 29490 | 41 | |||
| 27752 | 227423 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4611 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000635.58472 | 2104641.67508 | 37.7589803519927 | -122.44086074744 | (37.7589803519927, -122.44086074744) | 2 | 4 | 5 | 28862 | 38 | |||
| 27818 | 98647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | 13 | 9 | 1 | 57 | 17 | ||
| 27836 | 99747 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002274 | 2100636 | 37.7480748999105 | -122.434907877013 | (37.7480748999105, -122.434907877013) | 2 | 4 | 5 | 28862 | 22 |
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) );