trees
2,180 rows where qSpecies_id = 57 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | |||
20777 | 41179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.92482 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
20975 | 68850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||
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 | |||
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 | |||
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 | ||||
21778 | 61936 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 145 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | Permit Number 21993 | 6005587.19063437 | 2100190.09001467 | 37.7470380920929 | -122.423419277525 | (37.7470380920929, -122.423419277525) | 2 | 7 | 5 | 28859 | 22 | |
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
23799 | 62094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 10 | Permit Number 22183 | 6013254.03052 | 2105108.1707 | 37.7609718188263 | -122.397252634924 | (37.7609718188263, -122.397252634924) | 10 | 3 | 8 | 28856 | 29 | |
23849 | 65924 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 86 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28940 | 5995916.1594989 | 2113912.59060771 | 37.784165954142 | -122.457853509092 | (37.784165954142, -122.457853509092) | 11 | 6 | 1 | 54 | 31 | ||
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 | |||
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 | |||
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 | |||
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 | |||
25770 | 61942 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 22000 | 6005289.72791626 | 2100225.80996813 | 37.7471193773829 | -122.424450419529 | (37.7471193773829, -122.424450419529) | 2 | 7 | 5 | 28859 | 22 | ||
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 | ||||
26356 | 65822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2231 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 5 | Permit Number 28812 | 6000656.13395 | 2119945.18642 | 37.8010010577013 | -122.44188806188 | (37.8010010577013, -122.44188806188) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
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 | |||
26783 | 41176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.19311 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
26907 | 57576 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29580 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
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 | |||
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 | ||||
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 | |||
28411 | 34516 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 23 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1997 12:00:00 AM | Permit Number 38227 | 6006103.90835028 | 2100218.50622556 | 37.7471452669413 | -122.421634526851 | (37.7471452669413, -122.421634526851) | 2 | 7 | 5 | 28859 | 22 | ||
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 | ||
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 | |||
29639 | 227387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3130 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009057.55058 | 2104524.62094 | 37.759135000287 | -122.41172524652 | (37.759135000287, -122.41172524652) | 2 | 4 | 7 | 28859 | 19 | |||
29889 | 226699 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 38 Ramona Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6005184.56747 | 2107580.17464 | 37.767306799804 | -122.42533732116 | (37.767306799804, -122.42533732116) | 8 | 4 | 5 | 28853 | 19 | |||
30040 | 25706 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 582 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | 14 | 2 | 9 | 28853 | 34 | |||
30250 | 59329 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602 | 2103242.41669988 | 37.7556191813831 | -122.411337245149 | (37.7556191813831, -122.411337245149) | 2 | 4 | 7 | 28859 | 19 | ||
30922 | 61857 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | 10 | 4 | 7 | 28859 | 19 | ||
30950 | 66558 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3726 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29744 | 6005466.23183665 | 2104329.54931664 | 37.7583972608009 | -122.424131882152 | (37.7583972608009, -122.424131882152) | 2 | 4 | 5 | 28859 | 19 | ||
31126 | 227328 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 61 Elk St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6000814.1059 | 2096414.98301 | 37.7364019870456 | -122.439653561378 | (37.7364019870456, -122.439653561378) | 2 | 7 | 5 | 63 | 7 | |||
31163 | 227298 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6002393.51458 | 2100323.84062 | 37.7472245688541 | -122.434472284662 | (37.7472245688541, -122.434472284662) | 2 | 4 | 5 | 63 | 22 | ||||
31252 | 14760 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 967 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004525.58671 | 2111875.68505 | 37.7790639723642 | -122.427922762836 | (37.7790639723642, -122.427922762836) | 7 | 9 | 11 | 29490 | 41 | |||
31453 | 226715 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1212 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010279.15472 | 2102062.11752 | 37.7524419686257 | -122.407326738847 | (37.7524419686257, -122.407326738847) | 2 | 4 | 7 | 28859 | 19 | |||
31607 | 118275 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5984440.01732 | 2110639.37608 | 37.7745126579414 | -122.497314542381 | (37.7745126579414, -122.497314542381) | 11 | 6 | 2 | 55 | 26 | |||
31714 | 67465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826 | (37.7202991536555, -122.41105982826) | 9 | 3 | 7 | 309 | 28 | ||
31924 | 15427 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2109 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006990.7827 | 2106030.41424 | 37.7631534012249 | -122.418979933746 | (37.7631534012249, -122.418979933746) | 8 | 4 | 7 | 28859 | 19 | |||
32214 | 61853 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.7541263174163 | -122.407320968841 | (37.7541263174163, -122.407320968841) | 10 | 4 | 7 | 28859 | 19 | ||
32432 | 34780 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1167 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.7497820686377 | -122.414823157313 | (37.7497820686377, -122.414823157313) | 2 | 4 | 7 | 28859 | 19 | ||
32604 | 207831 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999093.71355 | 2093470.19209 | 37.7282182139785 | -122.445389984154 | (37.7282182139785, -122.445389984154) | 9 | 7 | 4 | 28861 | 40 | |||
32640 | 245884 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 228 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001291.6986 | 2109584.6989 | 37.7725900209727 | -122.438945841577 | (37.7725900209727, -122.438945841577) | 15 | 5 | 11 | 29492 | 9 | |||
32673 | 226695 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005201.39938 | 2107761.16657 | 37.7678047112414 | -122.425291982748 | (37.7678047112414, -122.425291982748) | 8 | 4 | 5 | 28853 | 19 | |||
32837 | 13047 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 539 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009759.7837 | 2120522.8139 | 37.8031016175536 | -122.410426223368 | (37.8031016175536, -122.410426223368) | 3 | 1 | 10 | 308 | 23 | |||
32858 | 207927 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1630 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5991926.85515 | 2096424.2337 | 37.7359175438479 | -122.470380908151 | (37.7359175438479, -122.470380908151) | 1 | 8 | 4 | 59 | 40 | |||
32961 | 34389 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | 2 | 7 | 5 | 63 | 7 | ||
33284 | 226691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 35 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005210.09814 | 2107610.98194 | 37.7673928316461 | -122.425251206571 | (37.7673928316461, -122.425251206571) | 8 | 4 | 5 | 28853 | 19 | |||
33376 | 67278 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.73243 | 37.7233423191649 | -122.42508335531 | (37.7233423191649, -122.42508335531) | 9 | 7 | 6 | 28861 | 5 | |
33718 | 207381 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 532 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994077.18296 | 2107021.99625 | 37.7651403959464 | -122.463715374182 | (37.7651403959464, -122.463715374182) | 11 | 5 | 11 | 56 | 12 | |||
33910 | 50451 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.7689532065783 | -122.445784947419 | (37.7689532065783, -122.445784947419) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
34136 | 61855 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066 | (37.7540649402035, -122.40731493066) | 10 | 4 | 7 | 28859 | 19 | ||
34155 | 129654 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009752.81774 | 2121876.72341 | 37.8068187252662 | -122.410545992499 | (37.8068187252662, -122.410545992499) | 3 | 1 | 10 | 308 | 23 | |||
34579 | 248362 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1321 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999488.4156 | 2108245.651 | 37.7688105694799 | -122.44508727896 | (37.7688105694799, -122.44508727896) | 15 | 5 | 11 | 29492 | 9 | |||
34603 | 207928 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 240 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993706.55269 | 2094092.03353 | 37.7296166372822 | -122.464058586949 | (37.7296166372822, -122.464058586949) | 9 | 8 | 4 | 59 | 40 | |||
34718 | 62107 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 373 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49980 | 6006792.08421569 | 2101617.3134298 | 37.7510248549528 | -122.419354081346 | (37.7510248549528, -122.419354081346) | 2 | 4 | 7 | 28859 | 19 | ||
34804 | 141375 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 340 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000736.9149 | 2110161.46 | 37.7741420811546 | -122.440906273714 | (37.7741420811546, -122.440906273714) | 15 | 5 | 11 | 29492 | 10 | |||
35342 | 177087 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012854.22383 | 2086908.70499 | 37.7109776122888 | -122.397359080471 | (37.7109776122888, -122.397359080471) | 10 | 3 | 8 | 309 | 1 | |||
35565 | 143365 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1735 UNION ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 0ft | 6004681.3503 | 2118768.1568 | 37.7979977794826 | -122.427875172085 | (37.7979977794826, -122.427875172085) | 13 | 9 | 1 | 57 | 17 | |||
35577 | 68980 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.02762 | 37.8010556951124 | -122.442380229379 | (37.8010556951124, -122.442380229379) | 13 | 9 | 1 | 57 | 17 | |
35582 | 248430 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 43 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998799.4794 | 2108029.431 | 37.7681775381351 | -122.447454684573 | (37.7681775381351, -122.447454684573) | 15 | 5 | 11 | 29492 | 9 | |||
35710 | 227363 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 744 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009063.4142 | 2104741.50791 | 37.7597308515189 | -122.411720292166 | (37.7597308515189, -122.411720292166) | 2 | 4 | 7 | 28859 | 19 | |||
35753 | 227430 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 310 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001107.72695 | 2104564.11712 | 37.7587942750543 | -122.439222302274 | (37.7587942750543, -122.439222302274) | 2 | 4 | 5 | 28862 | 38 |
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) );