trees
443 rows where qSpecies_id = 32 sorted by Latitude descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
52158 | 194535 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 360 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014325.43113 | 2111634.88834 | 37.7789523278141 | -122.394004006676 | (37.7789523278141, -122.394004006676) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
55733 | 39080 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
167745 | 39073 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2280X Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
81814 | 194532 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010402.10466 | 2107886.85819 | 37.7684422757183 | -122.407312137446 | (37.7684422757183, -122.407312137446) | 8 | 4 | 8 | 28853 | 19 | |||
19586 | 194533 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010348.85424 | 2107885.73513 | 37.7684362115906 | -122.40749624758 | (37.7684362115906, -122.40749624758) | 8 | 4 | 8 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 |
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) );