trees
443 rows where qSpecies_id = 32 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125810 | 194528 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 21 | : Yard | Tree | Private 2 | 3 | 6014977.55524 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | 10 | 3 | 8 | 28856 | 29 | ||||
130450 | 194526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 15 | : Yard | Tree | Private 2 | 5 | 6014989.61274 | 2102184.78595 | 37.7530413020381 | -122.391045631074 | (37.7530413020381, -122.391045631074) | 10 | 3 | 8 | 28856 | 29 | ||||
144108 | 194527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 16 | : Yard | Tree | Private 2 | 3 | 6014969.95823 | 2102191.83984 | 37.7530595798584 | -122.391114093749 | (37.7530595798584, -122.391114093749) | 10 | 3 | 8 | 28856 | 29 | ||||
181825 | 194529 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 23 | : Yard | Tree | Private 2 | 2 | 6014967.18541 | 2102296.35434 | 37.753346400626 | -122.391130987502 | (37.753346400626, -122.391130987502) | 10 | 3 | 8 | 28856 | 29 | ||||
91109 | 253371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | 10 | 3 | 8 | 28856 | 29 | |||
148734 | 253372 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | 10 | 3 | 8 | 28856 | 29 | |||
157819 | 150468 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012105.23351 | 2104143.6419 | 37.7582594122512 | -122.401158068605 | (37.7582594122512, -122.401158068605) | 10 | 3 | 8 | 28856 | 29 | |
190411 | 150469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012042.59416 | 2104165.28662 | 37.7583153491828 | -122.401376225239 | (37.7583153491828, -122.401376225239) | 10 | 3 | 8 | 28856 | 29 | |
42619 | 233498 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 101 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000562.67168 | 2104881.27171 | 37.7596340727711 | -122.441130104275 | (37.7596340727711, -122.441130104275) | 2 | 4 | 5 | 28862 | 3 | |||
178420 | 55550 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 101 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50802 | 6000558.4706929 | 2104874.62393167 | 37.759615580312 | -122.441144156399 | (37.759615580312, -122.441144156399) | 2 | 4 | 5 | 28862 | 3 | ||
87307 | 141826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1020 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004640.8141 | 2112287.0177 | 37.7801999083923 | -122.427553457164 | (37.7801999083923, -122.427553457164) | 7 | 9 | 11 | 29490 | 41 | |||
27892 | 9514 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1024 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004658.34921 | 2112287.36137 | 37.7802018438259 | -122.427492819652 | (37.7802018438259, -122.427492819652) | 7 | 9 | 11 | 29490 | 41 | ||
159942 | 141827 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1040 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004564.2329 | 2112276.6178 | 37.7801670209735 | -122.427817645466 | (37.7801670209735, -122.427817645466) | 7 | 9 | 11 | 29490 | 41 | |||
37896 | 9519 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1042 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6004584.56967 | 2112292.20585 | 37.780210972327 | -122.427748402246 | (37.780210972327, -122.427748402246) | 7 | 9 | 11 | 29490 | 41 | ||
118450 | 199989 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | 10 | 3 | 8 | 58 | 1 | |||
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
74150 | 199995 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1094 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6017857.178 | 2092387.3649 | 37.7262982485858 | -122.380448036499 | (37.7262982485858, -122.380448036499) | 10 | 3 | 8 | 58 | 1 | |||
123473 | 233367 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1113 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010291.70011 | 2102620.11112 | 37.753974797412 | -122.407322687398 | (37.753974797412, -122.407322687398) | 10 | 4 | 7 | 28859 | 19 | |||
98560 | 178360 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 114 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781343 | 6009991.86293 | 2095011.33058 | 37.7330659573247 | -122.40782310796 | (37.7330659573247, -122.40782310796) | 10 | 3 | 7 | 309 | 28 |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
46316 | 9558 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1195X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | ||
129486 | 233438 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 125 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007605.04677 | 2098050.53292 | 37.7412770284006 | -122.416290169252 | (37.7412770284006, -122.416290169252) | 2 | 7 | 7 | 28859 | 2 | |||
188244 | 199695 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1350 Underwood Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6015882.1777 | 2092801.0091 | 37.7273248550401 | -122.387304416847 | (37.7273248550401, -122.387304416847) | 10 | 3 | 8 | 58 | 1 | |||
30724 | 200624 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1382 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6016324.8756 | 2094912.2277 | 37.7331463494491 | -122.385921096754 | (37.7331463494491, -122.385921096754) | 10 | 3 | 8 | 58 | 1 | |||
110100 | 12389 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1450 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
4192 | 264915 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 1461 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784397 | 6015819.34366 | 2093828.22518 | 37.7301419060949 | -122.387593270969 | (37.7301419060949, -122.387593270969) | 10 | 3 | 8 | 58 | 1 | |
153206 | 53194 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1465@ KEITH Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2006 12:00:00 AM | 2 | 3x3 | Permit Number 49131 | 6015294.6422 | 2093162.1043 | 37.7282837944132 | -122.389360748448 | (37.7282837944132, -122.389360748448) | 10 | 3 | 8 | 58 | 1 | |
67618 | 233375 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1489 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003970.51891 | 2099621.7541 | 37.7453861945158 | -122.428969076773 | (37.7453861945158, -122.428969076773) | 2 | 7 | 5 | 63 | 22 | |||
51549 | 123985 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 15 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993608.31847 | 2115347.64983 | 37.7879733773019 | -122.465942059673 | (37.7879733773019, -122.465942059673) | 11 | 6 | 1 | 54 | 11 | |||
127261 | 194536 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 150 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014975.61342 | 2110964.15152 | 37.7771467490639 | -122.391707837847 | (37.7771467490639, -122.391707837847) | 6 | 2 | 9 | 28856 | 20 | |||
26149 | 29650 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 9 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015718.9286 | 2096019.8862 | 37.7361542039988 | -122.388093308135 | (37.7361542039988, -122.388093308135) | 10 | 3 | 8 | 58 | 1 | ||
36781 | 29649 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 8 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015738.3943 | 2096009.2115 | 37.7361259719003 | -122.388025261983 | (37.7361259719003, -122.388025261983) | 10 | 3 | 8 | 58 | 1 | ||
47331 | 29648 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 7 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015756.6041 | 2095993.5134 | 37.7360838769453 | -122.38796120765 | (37.7360838769453, -122.38796120765) | 10 | 3 | 8 | 58 | 1 | ||
104740 | 29645 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015832.5829 | 2095938.2561 | 37.7359363605469 | -122.387694661666 | (37.7359363605469, -122.387694661666) | 10 | 3 | 8 | 58 | 1 | ||
136895 | 29646 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015803.0705 | 2095958.3496 | 37.7359898984178 | -122.387798100273 | (37.7359898984178, -122.387798100273) | 10 | 3 | 8 | 58 | 1 | ||
153544 | 29647 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 6 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015782.349 | 2095974.6757 | 37.7360335786804 | -122.387870882274 | (37.7360335786804, -122.387870882274) | 10 | 3 | 8 | 58 | 1 | ||
184152 | 63700 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53921 | 5993398.86039614 | 2105062.95124939 | 37.7597222610505 | -122.465919149256 | (37.7597222610505, -122.465919149256) | 1 | 8 | 4 | 56 | 12 | |
149706 | 89031 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53922 | 5993414.1 | 2105027.2 | 37.7596249765547 | -122.465863845757 | (37.7596249765547, -122.465863845757) | 1 | 8 | 4 | 56 | 12 | |
15538 | 233362 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006411.92043 | 2106982.43417 | 37.7657348109283 | -122.421049627935 | (37.7657348109283, -122.421049627935) | 8 | 4 | 7 | 28853 | 19 | |||
131306 | 3871 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
159163 | 3872 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
189302 | 256060 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1560 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014829 | 2093598 | 37.7294548494407 | -122.391000959828 | (37.7294548494407, -122.391000959828) | 10 | 3 | 8 | 58 | 1 | ||||
6458 | 211310 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993991.2178 | 2104316.50873 | 37.7577068768914 | -122.46381631408 | (37.7577068768914, -122.46381631408) | 1 | 5 | 4 | 56 | 12 | |||
144954 | 233390 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1717 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008668.46209 | 2108152.59543 | 37.7690747473364 | -122.413327467893 | (37.7690747473364, -122.413327467893) | 8 | 4 | 7 | 28853 | 19 | |||
42962 | 91834 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1717X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008671 | 2108256 | 37.7693588146768 | -122.413326002916 | (37.7693588146768, -122.413326002916) | 8 | 4 | 7 | 28853 | 19 | ||
118721 | 91767 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1750 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008620.908553 | 2108156.423024 | 37.7690825870348 | -122.413492224037 | (37.7690825870348, -122.413492224037) | 8 | 4 | 7 | 28853 | 19 | ||
152413 | 233363 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1750 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008602.87705 | 2108217.80859 | 37.7692501250135 | -122.413558936315 | (37.7692501250135, -122.413558936315) | 8 | 4 | 7 | 28853 | 19 | |||
12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
119135 | 45703 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2002 12:00:00 AM | Permit Number 44377 | 6014535.62783282 | 2096937.66705225 | 37.7386086105091 | -122.392248663491 | (37.7386086105091, -122.392248663491) | 10 | 3 | 8 | 58 | 1 | ||
93433 | 233446 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 180 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006684.57542 | 2102745.85147 | 37.7541175063307 | -122.419805927624 | (37.7541175063307, -122.419805927624) | 2 | 4 | 7 | 28859 | 19 | |||
132142 | 100385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1800 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2012 12:00:00 AM | 3x3 | Permit Number 769433 | 5990171 | 2106556 | 37.7636350362567 | -122.477191710239 | (37.7636350362567, -122.477191710239) | 1 | 8 | 3 | 56 | 35 | ||
35068 | 233485 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008609.33505 | 2107860.39921 | 37.7682691247363 | -122.413511317219 | (37.7682691247363, -122.413511317219) | 8 | 4 | 7 | 28853 | 19 | |||
51086 | 91763 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008630.425108 | 2107902.838951 | 37.7683868385711 | -122.41344137031 | (37.7683868385711, -122.41344137031) | 8 | 4 | 7 | 28853 | 19 | ||
78766 | 233383 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008607.04739 | 2107902.88148 | 37.7683856427104 | -122.413522234974 | (37.7683856427104, -122.413522234974) | 8 | 4 | 7 | 28853 | 19 | |||
134828 | 233384 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008606.4822 | 2107885.73241 | 37.7683385236202 | -122.413522976899 | (37.7683385236202, -122.413522976899) | 8 | 4 | 7 | 28853 | 19 | |||
67852 | 233388 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008673.84119 | 2107870.27122 | 37.7682998527796 | -122.413288894184 | (37.7682998527796, -122.413288894184) | 8 | 4 | 7 | 28853 | 19 | |||
69990 | 233487 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008673.30569 | 2107876.17641 | 37.768316036993 | -122.41329116408 | (37.768316036993, -122.41329116408) | 8 | 4 | 7 | 28853 | 19 | |||
101577 | 233486 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008669.96247 | 2107902.14816 | 37.7683871616767 | -122.413304564874 | (37.7683871616767, -122.413304564874) | 8 | 4 | 7 | 28853 | 19 | |||
129117 | 233389 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008670.89575 | 2107897.67859 | 37.7683749416751 | -122.413301020619 | (37.7683749416751, -122.413301020619) | 8 | 4 | 7 | 28853 | 19 | |||
148679 | 233387 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008673.96808 | 2107833.61209 | 37.768199202458 | -122.41328586256 | (37.768199202458, -122.41328586256) | 8 | 4 | 7 | 28853 | 19 | |||
162724 | 233488 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008674.82028 | 2107841.97486 | 37.768222212525 | -122.413283506332 | (37.768222212525, -122.413283506332) | 8 | 4 | 7 | 28853 | 19 | |||
33947 | 91831 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008669.779404 | 2108251.243793 | 37.7693456867114 | -122.41332988852 | (37.7693456867114, -122.41332988852) | 8 | 4 | 7 | 28853 | 19 | ||
42115 | 91833 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2012 12:00:00 AM | 3 | 3x3 | 6008674.032707 | 2108297.585738 | 37.7694731696871 | -122.413318454137 | (37.7694731696871, -122.413318454137) | 8 | 4 | 7 | 28853 | 19 | ||
97210 | 91832 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2012 12:00:00 AM | 3 | 3x3 | 6008669.779404 | 2108251.243793 | 37.7693456867114 | -122.41332988852 | (37.7693456867114, -122.41332988852) | 8 | 4 | 7 | 28853 | 19 | ||
93471 | 233385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008614.2246 | 2107803.41147 | 37.768112924207 | -122.413490373789 | (37.768112924207, -122.413490373789) | 8 | 4 | 7 | 28853 | 19 | |||
107980 | 233484 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008611.01854 | 2107834.46107 | 37.7681979991668 | -122.413503659485 | (37.7681979991668, -122.413503659485) | 8 | 4 | 7 | 28853 | 19 | |||
173642 | 91764 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008632.668655 | 2107855.226552 | 37.7682562319719 | -122.413430242408 | (37.7682562319719, -122.413430242408) | 8 | 4 | 7 | 28853 | 19 | ||
17779 | 233482 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008616.65718 | 2107731.28246 | 37.7679150113072 | -122.413476857889 | (37.7679150113072, -122.413476857889) | 8 | 4 | 7 | 28853 | 19 | |||
28365 | 233483 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008612.51284 | 2107745.14575 | 37.7679528439771 | -122.413492173322 | (37.7679528439771, -122.413492173322) | 8 | 4 | 7 | 28853 | 19 | |||
113488 | 233386 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008614.93876 | 2107785.11216 | 37.7680627186577 | -122.413486609222 | (37.7680627186577, -122.413486609222) | 8 | 4 | 7 | 28853 | 19 | |||
119545 | 91765 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008637.233081 | 2107758.360569 | 37.767990516791 | -122.413407603159 | (37.767990516791, -122.413407603159) | 8 | 4 | 7 | 28853 | 19 | ||
134732 | 91766 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008637.233081 | 2107758.360569 | 37.767990516791 | -122.413407603159 | (37.767990516791, -122.413407603159) | 8 | 4 | 7 | 28853 | 19 | ||
7122 | 194543 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012559.7859 | 2107618.88108 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | 14 | 3 | 8 | 28856 | 20 | |||
21926 | 194544 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012545.36949 | 2107606.50724 | 37.7677922160651 | -122.399879039311 | (37.7677922160651, -122.399879039311) | 14 | 3 | 8 | 28856 | 20 | |||
89574 | 194545 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012495.5993 | 2107561.45835 | 37.7676657471131 | -122.400048025518 | (37.7676657471131, -122.400048025518) | 14 | 3 | 8 | 28856 | 20 | |||
119104 | 194546 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012481.42509 | 2107546.77644 | 37.7676246435913 | -122.40009602143 | (37.7676246435913, -122.40009602143) | 14 | 3 | 8 | 28856 | 20 | |||
144188 | 233489 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1850 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008682.13256 | 2107685.30091 | 37.7677924328048 | -122.413247133243 | (37.7677924328048, -122.413247133243) | 8 | 4 | 7 | 28853 | 19 | |||
157112 | 256075 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 1919 Jennings St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015778 | 2093027 | 37.7279396111572 | -122.387680322808 | (37.7279396111572, -122.387680322808) | 10 | 3 | 8 | 58 | 1 | |||||
82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
158444 | 233481 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008647.40135 | 2107231.86549 | 37.7665454544288 | -122.413335194872 | (37.7665454544288, -122.413335194872) | 8 | 4 | 7 | 28853 | 19 | |||
8498 | 233506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008710.79759 | 2107246.55273 | 37.7665893413473 | -122.413116956406 | (37.7665893413473, -122.413116956406) | 8 | 4 | 7 | 28853 | 19 | |||
65548 | 233507 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008711.02427 | 2107230.56462 | 37.7665454544263 | -122.413115041722 | (37.7665454544263, -122.413115041722) | 8 | 4 | 7 | 28853 | 19 | |||
128475 | 233508 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008712.28974 | 2107211.2482 | 37.7664924870523 | -122.413109298673 | (37.7664924870523, -122.413109298673) | 8 | 4 | 7 | 28853 | 19 | |||
2706 | 211314 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993864.84081 | 2102208.58731 | 37.7519117832189 | -122.464100354143 | (37.7519117832189, -122.464100354143) | 1 | 8 | 4 | 29491 | 12 | |||
25550 | 211315 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993849.45223 | 2102159.58974 | 37.7517763614982 | -122.464150012924 | (37.7517763614982, -122.464150012924) | 1 | 8 | 4 | 29491 | 12 | |||
55832 | 233480 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1962 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008658.08091 | 2107023.31074 | 37.7659734109827 | -122.413283506344 | (37.7659734109827, -122.413283506344) | 8 | 4 | 7 | 28853 | 19 | |||
165119 | 178355 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2 Moneta Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997930.01019 | 2088108.42362 | 37.7134295446025 | -122.449026847907 | (37.7134295446025, -122.449026847907) | 9 | 7 | 6 | 28861 | 25 | |||
4051 | 260659 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
8550 | 260661 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
9356 | 260660 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
17511 | 260658 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
18441 | 260662 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
93667 | 233434 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 20 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006113.31148 | 2102315.53922 | 37.7529037696113 | -122.421750938181 | (37.7529037696113, -122.421750938181) | 2 | 4 | 5 | 28859 | 19 | |||
30327 | 34199 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 38018 | 5994287.68885518 | 2098749.96127524 | 37.7424396309737 | -122.462387263533 | (37.7424396309737, -122.462387263533) | 1 | 8 | 4 | 59 | 40 | ||
79956 | 233364 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006470.82119 | 2104891.78129 | 37.7599976884594 | -122.420697473213 | (37.7599976884594, -122.420697473213) | 2 | 4 | 7 | 28859 | 19 | |||
150163 | 233365 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006473.17565 | 2104847.55108 | 37.7598763753088 | -122.420686190322 | (37.7598763753088, -122.420686190322) | 2 | 4 | 7 | 28859 | 19 | |||
107605 | 108437 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
177707 | 108436 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 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) );