trees
2,180 rows where qSpecies_id = 57 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
21077 | 62018 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1985 12:00:00 AM | 7 | Permit Number 22090 | 5999587.6363 | 2114469.4142 | 37.7859050916356 | -122.445191601832 | (37.7859050916356, -122.445191601832) | 15 | 6 | 1 | 29490 | 31 | ||
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 | |||
21457 | 73647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.7993439875935 | -122.404021813977 | (37.7993439875935, -122.404021813977) | 3 | 1 | 10 | 308 | 23 | |
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 | |||
22007 | 59094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 627 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 11 | Permit Number 18395 | 5994067.68279 | 2111215.68706 | 37.7766546137994 | -122.464052687917 | (37.7766546137994, -122.464052687917) | 11 | 6 | 2 | 54 | 11 | ||
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 | |||
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 | ||
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 | ||||
25015 | 54931 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1466 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x3 | Permit Number 51416 | 6003271.64345897 | 2099695.83318704 | 37.7455500147976 | -122.43139096057 | (37.7455500147976, -122.43139096057) | 2 | 7 | 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 | |||
25375 | 12330 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004740.4097 | 2112512.03764 | 37.7808233903837 | -122.427224943262 | (37.7808233903837, -122.427224943262) | 7 | 9 | 11 | 29490 | 41 | ||
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 | |||
26786 | 59149 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 218 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1980 12:00:00 AM | 7 | Permit Number 18458 | 5987761.12595 | 2114471.82373 | 37.7852295614332 | -122.486107720545 | (37.7852295614332, -122.486107720545) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
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 | |||
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 | ||||
27870 | 191476 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014442.93612 | 2112579.76279 | 37.7815532688034 | -122.393663657352 | (37.7815532688034, -122.393663657352) | 6 | 2 | 9 | 28856 | 6 | |||
28045 | 7974 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005597.93587 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | 13 | 9 | 1 | 28858 | 27 | |||
28062 | 207909 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 222 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992450.69932 | 2097715.88503 | 37.7394943670795 | -122.468663741761 | (37.7394943670795, -122.468663741761) | 1 | 8 | 4 | 59 | 40 | |||
28121 | 113967 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658 | 2107333 | 37.7669917162652 | -122.402929122897 | (37.7669917162652, -122.402929122897) | 8 | 2 | 8 | 28853 | 20 | ||||
28511 | 207965 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998007.7209 | 2095786.05635 | 37.7345149737803 | -122.449311069653 | (37.7345149737803, -122.449311069653) | 9 | 7 | 4 | 59 | 40 | |||
28627 | 102624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 305 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010336.6771 | 2120942.4897 | 37.8042862667019 | -122.408459480806 | (37.8042862667019, -122.408459480806) | 3 | 1 | 10 | 308 | 23 | |||
28641 | 129576 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2434 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000800.62837 | 2116707.95572 | 37.7921207075545 | -122.441155660304 | (37.7921207075545, -122.441155660304) | 13 | 6 | 1 | 29490 | 27 | |||
28646 | 42768 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | 7 | 9 | 11 | 29492 | 10 | ||
28752 | 227223 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007877.46921 | 2104880.99853 | 37.7600472608797 | -122.415831778521 | (37.7600472608797, -122.415831778521) | 2 | 4 | 7 | 28859 | 19 | |||
28954 | 226671 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1340 Bryant St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 2ft | 6009364.61324 | 2107966.78389 | 37.7686036122904 | -122.410906387739 | (37.7686036122904, -122.410906387739) | 8 | 4 | 7 | 28853 | 19 | |||
29008 | 191456 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6014463.08258 | 2115949.76346 | 37.7908076361998 | -122.393829922227 | (37.7908076361998, -122.393829922227) | 12 | 2 | 9 | 28855 | 6 | |||
29112 | 227409 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 323 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6003061.44291 | 2100931.79055 | 37.7489317492066 | -122.432206051568 | (37.7489317492066, -122.432206051568) | 2 | 4 | 5 | 28862 | 22 | |||
29208 | 142175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1470 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000827.8368 | 2110365.1539 | 37.7747065511696 | -122.440606372757 | (37.7747065511696, -122.440606372757) | 15 | 5 | 11 | 29492 | 10 |
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) );