443 rows where qSpecies_id = 32 sorted by Supervisor Districts

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);