trees
2,180 rows where qSpecies_id = 57 sorted by Supervisor Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
475 | 102627 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001422 | 2115424 | 37.7886306717674 | -122.438913657053 | (37.7886306717674, -122.438913657053) | 13 | 6 | 1 | 29490 | 27 | |||
2536 | 73723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | 13 | 9 | 1 | 57 | 17 | |||
4055 | 138702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2521 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001130.8799 | 2114520.0235 | 37.7861320179479 | -122.439856047477 | (37.7861320179479, -122.439856047477) | 15 | 6 | 1 | 29490 | 27 | |||
4457 | 27392 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.8016469274247 | -122.419461214785 | (37.8016469274247, -122.419461214785) | 5 | 1 | 1 | 28858 | 32 | |||
6285 | 72175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000606.57902 | 2119937.60106 | 37.8009774064533 | -122.442058997842 | (37.8009774064533, -122.442058997842) | 13 | 9 | 1 | 57 | 17 | |||
10259 | 66383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 6 | Permit Number 29509 | 5997500.2628 | 2113257.2822 | 37.782457530461 | -122.452325802952 | (37.782457530461, -122.452325802952) | 15 | 6 | 1 | 54 | 31 | |
12299 | 70030 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 66 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5998160.61879 | 2114184.40287 | 37.7850409692213 | -122.450108115392 | (37.7850409692213, -122.450108115392) | 15 | 6 | 1 | 54 | 31 | |||
12642 | 129578 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2434 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000794.17611 | 2116746.49388 | 37.7922261557494 | -122.441180751388 | (37.7922261557494, -122.441180751388) | 13 | 6 | 1 | 29490 | 27 | |||
12880 | 71814 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5995915.83222 | 2114038.69637 | 37.7845121880339 | -122.457863769922 | (37.7845121880339, -122.457863769922) | 11 | 6 | 1 | 54 | 31 | |||
15687 | 129561 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3299 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000845.88514 | 2119539.08728 | 37.7998968278242 | -122.441202290165 | (37.7998968278242, -122.441202290165) | 13 | 9 | 1 | 57 | 17 | |||
16833 | 23387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006004.32963 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | 13 | 9 | 1 | 28858 | 41 | |||
17812 | 129601 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005516.81947 | 2117765.82234 | 37.7952928511338 | -122.424912856464 | (37.7952928511338, -122.424912856464) | 13 | 9 | 1 | 28858 | 27 | |||
19205 | 27390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
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 | ||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
34652 | 108151 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
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 | |
36405 | 98645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.7992008856766 | -122.434457791187 | (37.7992008856766, -122.434457791187) | 13 | 9 | 1 | 57 | 17 | ||
36625 | 2170 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2299X FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005396 | 2117789 | 37.7953496659997 | -122.425332561837 | (37.7953496659997, -122.425332561837) | 13 | 9 | 1 | 28858 | 27 | |||
37048 | 129586 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1915 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004232.4663 | 2118008.34749 | 37.795886133905 | -122.429374228549 | (37.795886133905, -122.429374228549) | 13 | 9 | 1 | 28858 | 27 | |||
38172 | 34688 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) | 13 | 9 | 1 | 57 | 17 |
39094 | 17357 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2200 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005533.42048 | 2117633.73572 | 37.7949311123398 | -122.42484601254 | (37.7949311123398, -122.42484601254) | 13 | 9 | 1 | 28858 | 27 | |||
39406 | 129582 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003450.16372 | 2117252.10795 | 37.7937653733223 | -122.432027112554 | (37.7937653733223, -122.432027112554) | 13 | 9 | 1 | 29490 | 27 | |||
40600 | 17748 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005989.12058 | 2115543.08105 | 37.7892164261498 | -122.423120547185 | (37.7892164261498, -122.423120547185) | 13 | 9 | 1 | 28858 | 41 | |||
40616 | 141229 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998120.3361 | 2114458.595 | 37.7857915234083 | -122.450267251614 | (37.7857915234083, -122.450267251614) | 15 | 6 | 1 | 54 | 31 | |||
41197 | 129600 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005520.4 | 2117740.68195 | 37.7952240242221 | -122.424898677743 | (37.7952240242221, -122.424898677743) | 13 | 9 | 1 | 28858 | 27 | |||
42013 | 122135 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.474541227661 | (37.78686657212, -122.474541227661) | 11 | 6 | 1 | 54 | 33 | ||||
43511 | 98646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.7991951444108 | -122.434518715761 | (37.7991951444108, -122.434518715761) | 13 | 9 | 1 | 57 | 17 | ||
43651 | 65893 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 116 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | 9 | Permit Number 28900 | 5995931.63622 | 2113606.82428 | 37.7833272906212 | -122.457777832601 | (37.7833272906212, -122.457777832601) | 11 | 6 | 1 | 54 | 31 | |
44461 | 51606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2321 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 47903 | 6001273.37015 | 2116460.68929 | 37.7914686945789 | -122.439502237855 | (37.7914686945789, -122.439502237855) | 13 | 6 | 1 | 29490 | 27 | |||
45053 | 98657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002607.56666 | 2119218.59599 | 37.7991170337862 | -122.435083283187 | (37.7991170337862, -122.435083283187) | 13 | 9 | 1 | 57 | 17 | ||
45391 | 65826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2267 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 10 | Permit Number 28816 | 6000491.01592 | 2119920.15776 | 37.8009229255132 | -122.442457641208 | (37.8009229255132, -122.442457641208) | 13 | 9 | 1 | 57 | 17 | |
47447 | 129639 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | 5 | 1 | 1 | 28858 | 32 | |||
48203 | 33325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.17959 | 37.8023080334521 | -122.428193340463 | (37.8023080334521, -122.428193340463) | 13 | 9 | 1 | 57 | 17 | |
48220 | 129574 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2033 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001410.38478 | 2115467.41411 | 37.788749214855 | -122.438956956408 | (37.788749214855, -122.438956956408) | 13 | 6 | 1 | 29490 | 27 | |||
48534 | 114558 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.425814460096 | (37.7936541667538, -122.425814460096) | 13 | 9 | 1 | 28858 | 27 | ||
49525 | 138669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1716 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999601.6075 | 2114746.9787 | 37.7866680088585 | -122.44516322805 | (37.7866680088585, -122.44516322805) | 15 | 6 | 1 | 29490 | 31 | |||
49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
50748 | 50368 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2784 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 4 | Permit Number 47035 | 6000204.6547 | 2114445.9464 | 37.7858758547183 | -122.443055209056 | (37.7858758547183, -122.443055209056) | 13 | 6 | 1 | 29490 | 27 | ||
51102 | 62019 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1617 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 7 | Permit Number 29660 | 5999580.2026 | 2114540.2826 | 37.7860992534846 | -122.445222417327 | (37.7860992534846, -122.445222417327) | 15 | 6 | 1 | 29490 | 31 | |
52203 | 7963 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1840 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005718.27737 | 2116441.98594 | 37.7916693064652 | -122.424121585933 | (37.7916693064652, -122.424121585933) | 13 | 9 | 1 | 28858 | 27 | |||
53238 | 141038 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997552.7181 | 2113122.5903 | 37.7820907068665 | -122.452134610087 | (37.7820907068665, -122.452134610087) | 15 | 6 | 1 | 54 | 31 | |||
53669 | 250111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006107.64961 | 2115425.94774 | 37.7889014952475 | -122.422702123212 | (37.7889014952475, -122.422702123212) | 13 | 9 | 1 | 28858 | 41 | |||
54055 | 7986 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | 13 | 9 | 1 | 28858 | 27 | |||
56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
58686 | 98656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.7991261619004 | -122.435006269744 | (37.7991261619004, -122.435006269744) | 13 | 9 | 1 | 57 | 17 | ||
58687 | 66501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1625 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 7 | Permit Number 29664 | 5999574.2556 | 2114579.9293 | 37.7862077735321 | -122.44524584382 | (37.7862077735321, -122.44524584382) | 15 | 6 | 1 | 29490 | 31 | |
59499 | 114431 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2787 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000638 | 2114779 | 37.7868150321065 | -122.441579867848 | (37.7868150321065, -122.441579867848) | 13 | 6 | 1 | 29490 | 27 | ||||
59716 | 129606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005930.11566 | 2117709.23046 | 37.7951608000883 | -122.423478757933 | (37.7951608000883, -122.423478757933) | 13 | 9 | 1 | 28858 | 27 | |||
59907 | 129631 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2615 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006581.14621 | 2120178.38554 | 37.8019772007523 | -122.421401522778 | (37.8019772007523, -122.421401522778) | 5 | 9 | 1 | 28858 | 32 | |||
61185 | 110060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2661 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000157.93618 | 2118825.46591 | 37.7978982024034 | -122.443531554039 | (37.7978982024034, -122.443531554039) | 13 | 9 | 1 | 57 | 17 | ||||
61795 | 88217 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51182 | 6002528.21368 | 2117927.18 | 37.7955666353375 | -122.435265448048 | (37.7955666353375, -122.435265448048) | 13 | 9 | 1 | 57 | 17 | |
62054 | 9946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.419357387093 | (37.8003111812757, -122.419357387093) | 5 | 1 | 1 | 28858 | 32 | |||
62320 | 129640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1201 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007123.06001 | 2119804.16548 | 37.8009802258023 | -122.419499676077 | (37.8009802258023, -122.419499676077) | 5 | 1 | 1 | 28858 | 32 | |||
66431 | 129575 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2031 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001413.81367 | 2115442.77183 | 37.7886817486042 | -122.438943326283 | (37.7886817486042, -122.438943326283) | 13 | 6 | 1 | 29490 | 27 | |||
66842 | 38432 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1998 12:00:00 AM | Permit Number 40460 | 5995813.83516301 | 2115862.46033815 | 37.7895138928462 | -122.45834869498 | (37.7895138928462, -122.45834869498) | 11 | 6 | 1 | 54 | 31 | |||
68304 | 129610 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005886.38297 | 2117589.46023 | 37.7948294727542 | -122.423621560411 | (37.7948294727542, -122.423621560411) | 13 | 9 | 1 | 28858 | 27 | |||
71245 | 129580 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2845 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5999458.55424 | 2117691.50013 | 37.7947447233346 | -122.445870006289 | (37.7947447233346, -122.445870006289) | 13 | 9 | 1 | 57 | 27 | |||
71357 | 129579 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2434 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000792.48835 | 2116759.01776 | 37.7922604469152 | -122.441187490011 | (37.7922604469152, -122.441187490011) | 13 | 6 | 1 | 29490 | 27 | |||
73436 | 27488 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2113 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.423437499889 | (37.7949042735724, -122.423437499889) | 13 | 9 | 1 | 28858 | 27 | |||
74313 | 129629 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2705 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006528.35996 | 2120536.34413 | 37.8029570876493 | -122.421609626792 | (37.8029570876493, -122.421609626792) | 5 | 9 | 1 | 28858 | 32 | |||
74409 | 122131 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991115.12021 | 2115013.7594 | 37.7869124644121 | -122.47454361357 | (37.7869124644121, -122.47454361357) | 11 | 6 | 1 | 54 | 33 | ||||
78093 | 7993 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | |||
80334 | 129603 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1617 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005654.34929 | 2118205.1509 | 37.7965069035375 | -122.424468245119 | (37.7965069035375, -122.424468245119) | 13 | 9 | 1 | 28858 | 27 | |||
82521 | 138590 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1753 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999519.5719 | 2114956.939 | 37.78723982221 | -122.445462153372 | (37.78723982221, -122.445462153372) | 15 | 6 | 1 | 29490 | 31 | |||
83091 | 34203 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1911 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | 9 | Permit Number 38022 | 6004270.98382 | 2118013.74533 | 37.7959031355868 | -122.429241335742 | (37.7959031355868, -122.429241335742) | 13 | 9 | 1 | 28858 | 27 | ||
83738 | 85306 | - 12 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005989.138522 | 2115548.501173 | 37.7892313094718 | -122.423120870526 | (37.7892313094718, -122.423120870526) | 13 | 9 | 1 | 28858 | 41 | |||
84734 | 250118 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005957.66488 | 2115404.7946 | 37.7888349508074 | -122.423219546349 | (37.7888349508074, -122.423219546349) | 13 | 9 | 1 | 28858 | 41 | |||
85407 | 250110 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006127.47241 | 2115428.56912 | 37.7889098112749 | -122.422633725286 | (37.7889098112749, -122.422633725286) | 13 | 9 | 1 | 28858 | 41 | |||
86634 | 7959 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1800 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005709.66614 | 2116337.52814 | 37.791382005314 | -122.424143948706 | (37.791382005314, -122.424143948706) | 13 | 9 | 1 | 28858 | 27 | |||
87621 | 250120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005918.65484 | 2115399.35562 | 37.7888178151318 | -122.423354129013 | (37.7888178151318, -122.423354129013) | 13 | 9 | 1 | 28858 | 41 | |||
87677 | 27389 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007143.32837 | 2120019.72314 | 37.8015732342833 | -122.419444839906 | (37.8015732342833, -122.419444839906) | 5 | 1 | 1 | 28858 | 32 | |||
90155 | 11435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005584.47186 | 2117242.36199 | 37.7938593821703 | -122.424641513005 | (37.7938593821703, -122.424641513005) | 13 | 9 | 1 | 28858 | 27 | |||
90277 | 129602 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1699 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005553.17918 | 2118195.8648 | 37.7964756925582 | -122.424817655109 | (37.7964756925582, -122.424817655109) | 13 | 9 | 1 | 28858 | 27 | |||
90876 | 7970 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1930 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005659.59563 | 2116718.6943 | 37.7924257647952 | -122.424344314057 | (37.7924257647952, -122.424344314057) | 13 | 9 | 1 | 28858 | 27 |
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) );