trees
443 rows where qSpecies_id = 32 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13031 | 261121 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 80 Vesta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | ||||||||||||
18435 | 261120 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2901 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | ||||||||||||
1405 | 96265 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
2751 | 32002 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 5x5 | Permit Number 35399 | 6000302.11365106 | 2118206.59769697 | 37.7962071755692 | -122.442988194102 | (37.7962071755692, -122.442988194102) | 13 | 9 | 1 | 57 | 17 | ||
4937 | 132212 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2654 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000265.26964 | 2118199.18789 | 37.7961847294893 | -122.443115149071 | (37.7961847294893, -122.443115149071) | 13 | 9 | 1 | 57 | 17 | |||
14763 | 97267 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2050X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769192 | 5999912.27224 | 2116008.29642 | 37.7901489853223 | -122.444179075813 | (37.7901489853223, -122.444179075813) | 13 | 6 | 1 | 29490 | 27 | |
14931 | 132217 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999261.04653 | 2118404.81755 | 37.7966920235835 | -122.446604753326 | (37.7966920235835, -122.446604753326) | 13 | 9 | 1 | 57 | 17 | |||
18592 | 111041 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004870.73043 | 2118877.40927 | 37.7983084704282 | -122.427227648441 | (37.7983084704282, -122.427227648441) | 13 | 9 | 1 | 57 | 17 | |||
23719 | 132215 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999237.1134 | 2118402.93591 | 37.7966854900001 | -122.446687431602 | (37.7966854900001, -122.446687431602) | 13 | 9 | 1 | 57 | 17 | |||
37811 | 111042 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004867.45543 | 2118890.27835 | 37.7983436204214 | -122.42723989811 | (37.7983436204214, -122.42723989811) | 13 | 9 | 1 | 57 | 17 | |||
39346 | 50453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2645 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | Permit Number 47099 | 5999591.19502 | 2117968.49826 | 37.7955128594886 | -122.445430979754 | (37.7955128594886, -122.445430979754) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
61436 | 54918 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2836 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 9 | Permit Number 10785 | 5999351.3134 | 2118417.61273 | 37.7967323114142 | -122.446293331595 | (37.7967323114142, -122.446293331595) | 13 | 9 | 1 | 57 | 17 | ||
69752 | 132213 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000167.6867 | 2118186.05064 | 37.7961430935947 | -122.443451860639 | (37.7961430935947, -122.443451860639) | 13 | 9 | 1 | 57 | 17 | |||
81784 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 32 | 2614 Sacramento St | Front Yard : | Tree | Private 2 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291 | 2115777 | 37.7896493226209 | -122.435932319436 | (37.7896493226209, -122.435932319436) | 13 | 6 | 1 | 29490 | 27 | ||||
82188 | 32003 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2648 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 7 | Permit Number 35399 | 6000296.93169 | 2118203.44965 | 37.7961982364164 | -122.4430058985 | (37.7961982364164, -122.4430058985) | 13 | 9 | 1 | 57 | 17 | ||
82766 | 62895 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1986 12:00:00 AM | 7 | Permit Number 23269 | 6000188.22889 | 2118188.91865 | 37.7961521398507 | -122.443380986865 | (37.7961521398507, -122.443380986865) | 13 | 9 | 1 | 57 | 17 | ||
91576 | 96266 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
95260 | 96264 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
96009 | 132214 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000146.66842 | 2118183.0353 | 37.7961336156155 | -122.443524371168 | (37.7961336156155, -122.443524371168) | 13 | 9 | 1 | 57 | 17 | |||
101848 | 132211 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004866.10803 | 2118906.26122 | 37.7983874290946 | -122.427245699623 | (37.7983874290946, -122.427245699623) | 13 | 9 | 1 | 57 | 17 | |||
113333 | 32004 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2648 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 4 | Permit Number 35399 | 6000314.48806 | 2118206.69354 | 37.7962081442408 | -122.44294538314 | (37.7962081442408, -122.44294538314) | 13 | 9 | 1 | 57 | 17 | ||
131234 | 132216 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999249.48209 | 2118404.06668 | 37.7966893013211 | -122.446644714701 | (37.7966893013211, -122.446644714701) | 13 | 9 | 1 | 57 | 17 | |||
163748 | 132218 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999271.44145 | 2118406.78235 | 37.796698012158 | -122.446568926118 | (37.796698012158, -122.446568926118) | 13 | 9 | 1 | 57 | 17 | |||
103041 | 249943 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011269.12703 | 2120027.36915 | 37.8018257441226 | -122.405168167193 | (37.8018257441226, -122.405168167193) | 3 | 1 | 10 | 308 | 23 | |||
177361 | 249944 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 6 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011269.54801 | 2120028.9121 | 37.8018300042211 | -122.40516681911 | (37.8018300042211, -122.40516681911) | 3 | 1 | 10 | 308 | 23 | |||
178051 | 63992 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 880 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 10 | Permit Number 24739 | 6008138.72645 | 2120344.34262 | 37.802520572028 | -122.416023302632 | (37.802520572028, -122.416023302632) | 5 | 1 | 10 | 308 | 32 | |
192710 | 249942 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011270.23997 | 2120024.6306 | 37.801818286952 | -122.405164122933 | (37.801818286952, -122.405164122933) | 3 | 1 | 10 | 308 | 23 | |||
5052 | 139847 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 829 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005684.1962 | 2112380.729 | 37.7805161769301 | -122.423950581978 | (37.7805161769301, -122.423950581978) | 7 | 9 | 11 | 28852 | 41 | |||
7104 | 9470 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
10382 | 70244 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 322 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6005809.1541 | 2110870.1551 | 37.7763755628652 | -122.423410874448 | (37.7763755628652, -122.423410874448) | 7 | 9 | 11 | 28852 | 10 | |||
13057 | 73861 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 322 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6005837.5808 | 2110875.7018 | 37.7763923971267 | -122.423312932793 | (37.7763923971267, -122.423312932793) | 7 | 9 | 11 | 28852 | 10 | |||
17446 | 9465 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
24832 | 9460 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/17/1998 12:00:00 AM | 6 | 3X3 | 6005350.8775 | 2112393.4845 | 37.7805323769118 | -122.425104597895 | (37.7805323769118, -122.425104597895) | 7 | 9 | 11 | 28852 | 41 | ||
26805 | 139841 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 855 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005489.2243 | 2112352.6717 | 37.7804281291994 | -122.424623086227 | (37.7804281291994, -122.424623086227) | 7 | 9 | 11 | 28852 | 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 | ||
36402 | 16950 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 630 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003955.1515 | 2110112.5344 | 37.7741905079368 | -122.429770337641 | (37.7741905079368, -122.429770337641) | 7 | 9 | 11 | 29492 | 10 | |||
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 | ||
40789 | 9455 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005466.2284 | 2112408.648 | 37.7805805276453 | -122.424706623116 | (37.7805805276453, -122.424706623116) | 7 | 9 | 11 | 28852 | 41 | ||
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 | ||
49344 | 139946 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005060.605 | 2112352.3265 | 37.7804029654412 | -122.426105857766 | (37.7804029654412, -122.426105857766) | 7 | 9 | 11 | 28852 | 41 | |||
51716 | 9452 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.7806057683483 | -122.424527345883 | (37.7806057683483, -122.424527345883) | 7 | 9 | 11 | 28852 | 41 | ||
53615 | 233359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 93 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6004257.74689 | 2109007.55308 | 37.7711736292001 | -122.428644822623 | (37.7711736292001, -122.428644822623) | 7 | 9 | 11 | 29492 | 10 | |||
54476 | 49993 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300@ GOUGH Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005892.354 | 2110883.3284 | 37.776416429024 | -122.423123998881 | (37.776416429024, -122.423123998881) | 7 | 9 | 11 | 28852 | 10 | ||
67414 | 139945 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005081.184 | 2112356.1174 | 37.7804145374079 | -122.426034935273 | (37.7804145374079, -122.426034935273) | 7 | 9 | 11 | 28852 | 41 | |||
72362 | 139831 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 925 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005175.7373 | 2112309.654 | 37.7802923037704 | -122.42570452289 | (37.7802923037704, -122.42570452289) | 7 | 9 | 11 | 28852 | 41 | |||
73865 | 233504 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 303 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004169.36699 | 2109042.82598 | 37.7712654778421 | -122.428953047263 | (37.7712654778421, -122.428953047263) | 7 | 9 | 11 | 29492 | 10 | |||
82697 | 49986 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300@ GOUGH Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005905.5273 | 2110882.6351 | 37.7764152687747 | -122.42307837937 | (37.7764152687747, -122.42307837937) | 7 | 9 | 11 | 28852 | 10 | ||
85920 | 139838 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 875 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005379.6259 | 2112337.1416 | 37.7803792970953 | -122.425001133553 | (37.7803792970953, -122.425001133553) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
92938 | 139937 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800 GOLDEN GATE AVE | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005368.7488 | 2112395.1092 | 37.7805378474705 | -122.425042888178 | (37.7805378474705, -122.425042888178) | 7 | 9 | 11 | 28852 | 41 | |||
99887 | 9457 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | 7 | 9 | 11 | 28852 | 41 | |||
106410 | 57835 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1977 12:00:00 AM | 30 | 3x10 | Permit Number 16776 | 5996589.21937103 | 2105630.13222731 | 37.7614631235225 | -122.4549263227 | (37.7614631235225, -122.4549263227) | 15 | 5 | 11 | 29492 | 12 | |
107705 | 9458 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.7805495105702 | -122.424966344778 | (37.7805495105702, -122.424966344778) | 7 | 9 | 11 | 28852 | 41 | ||
107832 | 9453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.424574106032 | (37.7806020298362, -122.424574106032) | 7 | 9 | 11 | 28852 | 41 | ||
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 | |||
113569 | 9450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 6 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.7806176146029 | -122.424439561439 | (37.7806176146029, -122.424439561439) | 7 | 9 | 11 | 28852 | 41 | |||
114657 | 9454 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | 7 | 9 | 11 | 28852 | 41 | ||
123609 | 139845 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 833 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005645.4131 | 2112373.0828 | 37.7804929927223 | -122.424084207294 | (37.7804929927223, -122.424084207294) | 7 | 9 | 11 | 28852 | 41 | |||
130406 | 233503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004006.37155 | 2109072.69928 | 37.7713382752792 | -122.429518986121 | (37.7713382752792, -122.429518986121) | 7 | 9 | 11 | 29492 | 10 | |||
134854 | 9492 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 875 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X | 6005394.0418 | 2112324.36064 | 37.7803450180147 | -122.424950352589 | (37.7803450180147, -122.424950352589) | 7 | 9 | 11 | 28852 | 41 | ||
151176 | 9500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 915 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005267.772 | 2112322.2041 | 37.7803319634813 | -122.425387025394 | (37.7803319634813, -122.425387025394) | 7 | 9 | 11 | 28852 | 41 | ||
156550 | 9488 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 855 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005478.3549 | 2112356.31338 | 37.7804375144956 | -122.424660947747 | (37.7804375144956, -122.424660947747) | 7 | 9 | 11 | 28852 | 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 | |||
170214 | 57728 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52544 | 6004003.00672697 | 2109073.0127901 | 37.7713389455863 | -122.429530647558 | (37.7713389455863, -122.429530647558) | 7 | 9 | 11 | 29492 | 10 | ||
172455 | 9471 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
177686 | 9503 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 925 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005161.80896 | 2112312.16407 | 37.7802984087399 | -122.425752886207 | (37.7802984087399, -122.425752886207) | 7 | 9 | 11 | 28852 | 41 | ||
180969 | 139955 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004851.0238 | 2112323.6242 | 37.7803123083991 | -122.426828852854 | (37.7803123083991, -122.426828852854) | 7 | 9 | 11 | 28852 | 41 | |||
182151 | 233505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 303 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004187.87714 | 2109045.00996 | 37.7712725222301 | -122.428889175598 | (37.7712725222301, -122.428889175598) | 7 | 9 | 11 | 29492 | 10 | |||
192662 | 9763 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 827X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005605.94462 | 2112369.06058 | 37.7804797202246 | -122.424220461395 | (37.7804797202246, -122.424220461395) | 7 | 9 | 11 | 28852 | 41 | ||
69127 | 120436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988981.18981 | 2113759.01569 | 37.7833434210971 | -122.481834493116 | (37.7833434210971, -122.481834493116) | 11 | 6 | 2 | 55 | 26 | |||
73390 | 14514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 507 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999077.3967 | 2111056.5759 | 37.7765051848822 | -122.446711235239 | (37.7765051848822, -122.446711235239) | 15 | 5 | 2 | 29492 | 16 | |||
126321 | 118491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981413.14873 | 2112317.48344 | 37.7789423808296 | -122.507909444403 | (37.7789423808296, -122.507909444403) | 11 | 6 | 2 | 55 | 26 | ||||
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 | ||
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 | |||
2889 | 211318 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 355 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997726.4515 | 2093787.92348 | 37.7290124835257 | -122.450139532341 | (37.7290124835257, -122.450139532341) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
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 | |||
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 | ||
13269 | 211313 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.24128 | 2099598.30232 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | 1 | 8 | 4 | 29491 | 40 | |||
16610 | 211317 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993928.12229 | 2102221.55917 | 37.7519510476114 | -122.463882461023 | (37.7519510476114, -122.463882461023) | 1 | 8 | 4 | 29491 | 12 | |||
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 | ||
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 | |||
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 | ||
58134 | 38018 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
98544 | 211316 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993952.85587 | 2102199.15235 | 37.7518909495221 | -122.463795303226 | (37.7518909495221, -122.463795303226) | 1 | 8 | 4 | 29491 | 40 | |||
126685 | 211312 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.468262856351 | (37.7446340456409, -122.468262856351) | 1 | 8 | 4 | 29491 | 40 | |||
141605 | 38019 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
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 | |
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 | |
1087 | 233496 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000227.44313 | 2104506.90628 | 37.7585870568739 | -122.442262614226 | (37.7585870568739, -122.442262614226) | 2 | 4 | 5 | 28862 | 3 | |||
10542 | 233492 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001776.45872 | 2103391.52743 | 37.7556126580189 | -122.436825582043 | (37.7556126580189, -122.436825582043) | 2 | 4 | 5 | 28862 | 22 | |||
16103 | 247814 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 532 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003126.49354 | 2098351.09832 | 37.7418494576778 | -122.431796869036 | (37.7418494576778, -122.431796869036) | 2 | 7 | 5 | 63 | 22 | |||
16867 | 233369 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3698 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005236.6856 | 2101975.24545 | 37.7519199283811 | -122.424758271091 | (37.7519199283811, -122.424758271091) | 2 | 4 | 5 | 28859 | 19 | |||
19222 | 22826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 84 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:48:00 PM | 3 | 3x3 | 5999343.3761 | 2099052.93009 | 37.743561341476 | -122.444928046502 | (37.743561341476, -122.444928046502) | 2 | 7 | 5 | 63 | 7 | ||
28716 | 233494 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003128.49899 | 2103230.63077 | 37.7552476232057 | -122.432138316435 | (37.7552476232057, -122.432138316435) | 2 | 4 | 5 | 28862 | 22 | |||
32774 | 233361 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 28 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | 6005734.12152 | 2106385.89097 | 37.7640586131313 | -122.423351580335 | (37.7640586131313, -122.423351580335) | 8 | 4 | 5 | 28859 | 19 | ||
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 |
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) );