trees
2,180 rows where qSpecies_id = 57
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||||
24545 | 70470 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
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 | |||
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 | ||||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||
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 | |||
29374 | 109992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 9 | 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 | |||
29391 | 227360 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 790 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009074.13968 | 2104572.98929 | 37.7592687393775 | -122.411671290823 | (37.7592687393775, -122.411671290823) | 2 | 4 | 7 | 28859 | 19 | |||
29595 | 20276 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
29772 | 207828 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5999348.94408 | 2093797.91328 | 37.7291326266637 | -122.444531189165 | (37.7291326266637, -122.444531189165) | 9 | 7 | 4 | 28861 | 40 | |||
29873 | 138704 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2521 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001167.2865 | 2114524.96 | 37.786147644599 | -122.439730444644 | (37.786147644599, -122.439730444644) | 15 | 6 | 1 | 29490 | 27 | |||
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 | |||
30045 | 207903 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991490.36095 | 2097069.60585 | 37.7376643249521 | -122.471937050068 | (37.7376643249521, -122.471937050068) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
30344 | 247848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 149 Chapman St | 3 | Side Yard : Yard | Tree | Private 2 | 37 | 6009193.51112 | 2098205.92163 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | 10 | 7 | 7 | 28859 | 2 | ||||
30465 | 143380 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1897 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003965.1287 | 2118668.8078 | 37.7976844492982 | -122.430346412036 | (37.7976844492982, -122.430346412036) | 13 | 9 | 1 | 57 | 17 | |||
30495 | 129591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6005908.12306 | 2117266.84801 | 37.7939448878875 | -122.423523389509 | (37.7939448878875, -122.423523389509) | 13 | 9 | 1 | 28858 | 27 | |||
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 | ||
30959 | 129658 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009773.35506 | 2121727.83726 | 37.8064110724651 | -122.410464398813 | (37.8064110724651, -122.410464398813) | 3 | 1 | 10 | 308 | 23 | |||
31107 | 111019 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 90x DOWNEY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
31281 | 177081 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012270.95689 | 2087199.03401 | 37.711742306726 | -122.39939537131 | (37.711742306726, -122.39939537131) | 10 | 3 | 8 | 309 | 1 | |||
31380 | 227459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Corbin Pl | 7 | Side Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000082.87905 | 2105698.79506 | 37.761851449312 | -122.442848168232 | (37.761851449312, -122.442848168232) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
31614 | 129649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009816.83805 | 2121725.36163 | 37.8064067125673 | -122.410313742595 | (37.8064067125673, -122.410313742595) | 3 | 1 | 10 | 308 | 23 | |||
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 |
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) );