trees
443 rows where qSpecies_id = 32
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81445 | 233420 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2475 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008882.84351 | 2104050.40662 | 37.75782311337 | -122.412295951823 | (37.75782311337, -122.412295951823) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||||
| 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 | |||
| 81818 | 96502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | ||
| 82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
| 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 | ||
| 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 | ||
| 83366 | 45466 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2211 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44247 | 6011994.00463493 | 2101339.69847182 | 37.7505541915496 | -122.401345703709 | (37.7505541915496, -122.401345703709) | 10 | 3 | 8 | 28856 | 1 | |||
| 83677 | 178356 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6009662.10656 | 2090649.30438 | 37.7210702863525 | -122.408655555513 | (37.7210702863525, -122.408655555513) | 9 | 3 | 7 | 309 | 28 | |||
| 84140 | 233377 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007431.42413 | 2096297.49525 | 37.7364538095851 | -122.416766332396 | (37.7364538095851, -122.416766332396) | 2 | 7 | 7 | 28859 | 2 | |||
| 84326 | 233436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000375.83482 | 2101284.56019 | 37.7497477337837 | -122.441518177039 | (37.7497477337837, -122.441518177039) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 86394 | 81256 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50448 | 6003133.58124947 | 2103094.76960314 | 37.7548748688717 | -122.432111038861 | (37.7548748688717, -122.432111038861) | 2 | 4 | 5 | 28862 | 22 | ||
| 86913 | 233475 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008784.35145 | 2104752.62578 | 37.7597457200079 | -122.412686221592 | (37.7597457200079, -122.412686221592) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 88213 | 96513 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
| 88990 | 91818 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2475 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008876.426107 | 2104060.19764 | 37.757849637178 | -122.41231883798 | (37.757849637178, -122.41231883798) | 2 | 4 | 7 | 28859 | 19 | ||
| 89268 | 233371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009946.29944 | 2104530.48554 | 37.7592009197153 | -122.408651928554 | (37.7592009197153, -122.408651928554) | 2 | 4 | 7 | 28859 | 19 | |||
| 89574 | 194545 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012495.5993 | 2107561.45835 | 37.7676657471131 | -122.400048025518 | (37.7676657471131, -122.400048025518) | 14 | 3 | 8 | 28856 | 20 | |||
| 91109 | 253371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | 10 | 3 | 8 | 28856 | 29 | |||
| 91272 | 91757 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008781.413784 | 2104958.401867 | 37.7603105692892 | -122.412710929059 | (37.7603105692892, -122.412710929059) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 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 | |||
| 93220 | 87932 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
| 93433 | 233446 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 180 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006684.57542 | 2102745.85147 | 37.7541175063307 | -122.419805927624 | (37.7541175063307, -122.419805927624) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 93667 | 233434 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 20 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006113.31148 | 2102315.53922 | 37.7529037696113 | -122.421750938181 | (37.7529037696113, -122.421750938181) | 2 | 4 | 5 | 28859 | 19 | |||
| 93946 | 91761 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008735.241541 | 2105700.534049 | 37.7623457027108 | -122.412923089625 | (37.7623457027108, -122.412923089625) | 8 | 4 | 7 | 28859 | 19 | ||
| 94761 | 87930 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 95271 | 233433 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007897.90504 | 2106755.67526 | 37.7651958382412 | -122.415893853325 | (37.7651958382412, -122.415893853325) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 96556 | 76323 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2111 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1994 12:00:00 AM | 3 | 3x3 | 6008755.93357293 | 2106237.29701545 | 37.7638206919277 | -122.412889475083 | (37.7638206919277, -122.412889475083) | 8 | 4 | 7 | 28859 | 19 | ||
| 96920 | 63999 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 595 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778275 | 6001356.36107438 | 2100834.50333121 | 37.7485677985315 | -122.438095249236 | (37.7485677985315, -122.438095249236) | 2 | 4 | 5 | 28862 | 22 | |
| 97002 | 35881 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011145.59946 | 2096623.30558 | 37.7375566221413 | -122.403947710744 | (37.7375566221413, -122.403947710744) | 10 | 3 | 8 | 58 | 1 | |
| 97136 | 233479 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2180 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008744.74823 | 2105468.88661 | 37.7617101855999 | -122.41287383096 | (37.7617101855999, -122.41287383096) | 2 | 4 | 7 | 28859 | 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 | ||
| 97777 | 35879 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 8 | Permit Number 39083 | 6011139.9615 | 2096662.77409 | 37.7376646792858 | -122.403969980625 | (37.7376646792858, -122.403969980625) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 98560 | 178360 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 114 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781343 | 6009991.86293 | 2095011.33058 | 37.7330659573247 | -122.40782310796 | (37.7330659573247, -122.40782310796) | 10 | 3 | 7 | 309 | 28 |
| 98646 | 233497 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000229.80091 | 2104520.72602 | 37.7586251368655 | -122.442255452052 | (37.7586251368655, -122.442255452052) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | |||
| 101767 | 233405 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 101913 | 26527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2011 12:00:00 AM | 3 | 3x3 | 6009007.86561 | 2102243.77418 | 37.7528695228702 | -122.411735918856 | (37.7528695228702, -122.411735918856) | 2 | 4 | 7 | 28859 | 19 | ||
| 102670 | 98213 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 103294 | 91752 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2660 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008895.550687 | 2102970.363593 | 37.7548582726151 | -122.412175673836 | (37.7548582726151, -122.412175673836) | 2 | 4 | 7 | 28859 | 19 | ||
| 104215 | 233392 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007791.82881 | 2106445.05823 | 37.7643369919914 | -122.416238745127 | (37.7643369919914, -122.416238745127) | 8 | 4 | 7 | 28859 | 19 | |||
| 104740 | 29645 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015832.5829 | 2095938.2561 | 37.7359363605469 | -122.387694661666 | (37.7359363605469, -122.387694661666) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |
| 106723 | 60332 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 4033 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | 3x3 | Permit Number 770595 | 6002797.86052916 | 2104715.61000638 | 37.7593062690744 | -122.433387871218 | (37.7593062690744, -122.433387871218) | 2 | 4 | 5 | 28862 | 3 | ||
| 107332 | 233378 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007432.33067 | 2096315.60507 | 37.7365035861596 | -122.416764480695 | (37.7365035861596, -122.416764480695) | 2 | 7 | 7 | 28859 | 2 | |||
| 107605 | 108437 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
| 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 | ||
| 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 | |||
| 108313 | 96526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2199X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008790.65012 | 2105435.76389 | 37.7616218146205 | -122.412712732534 | (37.7616218146205, -122.412712732534) | 8 | 4 | 7 | 28859 | 19 | ||
| 108771 | 94031 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2576 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2010 12:00:00 AM | 3x3 | Permit Number 53444 | 6008873.8 | 2103464.7 | 37.756214388248 | -122.412285831464 | (37.756214388248, -122.412285831464) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 112502 | 91739 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2814 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 4 | 3x3 | 6008944.07429 | 2102060.386342 | 37.7523624022397 | -122.411943563585 | (37.7523624022397, -122.411943563585) | 2 | 4 | 7 | 28859 | 19 | ||
| 112885 | 40291 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3698X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41436 | 6005153.62196948 | 2101950.32896523 | 37.7518468217067 | -122.42504374449 | (37.7518468217067, -122.42504374449) | 2 | 4 | 5 | 28859 | 19 |
| 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 | ||
| 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 | |||
| 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 | |||
| 113956 | 233451 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008950.63348 | 2101756.58641 | 37.751528603671 | -122.411899414636 | (37.751528603671, -122.411899414636) | 2 | 4 | 7 | 28859 | 19 | |||
| 114296 | 38316 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 114649 | 194547 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.7378863594562 | -122.381824001685 | (37.7378863594562, -122.381824001685) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 115599 | 96503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | |||
| 117702 | 233490 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 918 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001888.71802 | 2101354.60643 | 37.7500261396126 | -122.436291586193 | (37.7500261396126, -122.436291586193) | 2 | 4 | 5 | 28862 | 22 | |||
| 118450 | 199989 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | 10 | 3 | 8 | 58 | 1 | |||
| 118535 | 194531 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011908.13677 | 2101346.92633 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | 10 | 3 | 8 | 28856 | 1 | |||
| 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 | ||
| 119013 | 233396 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007784.70136 | 2106598.65312 | 37.7647583270588 | -122.416274276453 | (37.7647583270588, -122.416274276453) | 8 | 4 | 7 | 28859 | 19 | |||
| 119099 | 91809 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2727 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008956.545059 | 2102578.896484 | 37.7537868143213 | -122.411937075475 | (37.7537868143213, -122.411937075475) | 2 | 4 | 7 | 28859 | 19 | ||
| 119104 | 194546 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012481.42509 | 2107546.77644 | 37.7676246435913 | -122.40009602143 | (37.7676246435913, -122.40009602143) | 14 | 3 | 8 | 28856 | 20 | |||
| 119135 | 45703 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2002 12:00:00 AM | Permit Number 44377 | 6014535.62783282 | 2096937.66705225 | 37.7386086105091 | -122.392248663491 | (37.7386086105091, -122.392248663491) | 10 | 3 | 8 | 58 | 1 | ||
| 119202 | 91819 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6008857.839983 | 2104395.646442 | 37.7587696603701 | -122.412406827225 | (37.7587696603701, -122.412406827225) | 2 | 4 | 7 | 28859 | 19 | ||
| 119309 | 233476 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.53012 | 2104788.45028 | 37.7598440959392 | -122.412688136268 | (37.7598440959392, -122.412688136268) | 2 | 4 | 7 | 28859 | 19 | |||
| 119326 | 233469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008788.18662 | 2104615.29768 | 37.7593688636119 | -122.412663249315 | (37.7593688636119, -122.412663249315) | 2 | 4 | 7 | 28859 | 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 | ||
| 120089 | 51755 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 771839 | 6009683.01299313 | 2101640.06724055 | 37.7512497292061 | -122.409358522845 | (37.7512497292061, -122.409358522845) | 2 | 4 | 7 | 28859 | 19 | |||
| 120408 | 178359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003629.76511 | 2092456.58351 | 37.7256929707372 | -122.429636417784 | (37.7256929707372, -122.429636417784) | 9 | 7 | 6 | 28861 | 5 | |||
| 120951 | 35880 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 50 Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011141.46747 | 2096642.94504 | 37.7376103170696 | -122.403963378733 | (37.7376103170696, -122.403963378733) | 10 | 3 | 8 | 58 | 1 | |
| 121600 | 194541 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012465.16673 | 2107386.76068 | 37.7671843696864 | -122.40014101809 | (37.7671843696864, -122.40014101809) | 14 | 3 | 8 | 28856 | 20 | |||
| 121618 | 233399 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007778.39498 | 2106706.34258 | 37.7650536626339 | -122.416303716638 | (37.7650536626339, -122.416303716638) | 8 | 4 | 7 | 28859 | 19 | |||
| 123083 | 233500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4090 20th St | 10 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003098.24212 | 2104183.0577 | 37.7578610449587 | -122.432310971886 | (37.7578610449587, -122.432310971886) | 2 | 4 | 5 | 28862 | 3 | |||
| 123302 | 233425 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008802.53088 | 2105481.30644 | 37.7617475308496 | -122.412674861355 | (37.7617475308496, -122.412674861355) | 8 | 4 | 7 | 28859 | 19 | |||
| 123473 | 233367 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1113 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010291.70011 | 2102620.11112 | 37.753974797412 | -122.407322687398 | (37.753974797412, -122.407322687398) | 10 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 123792 | 233403 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3071 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009068.28085 | 2100690.59156 | 37.7486082190041 | -122.411417271913 | (37.7486082190041, -122.411417271913) | 2 | 4 | 7 | 28859 | 19 | |||
| 123820 | 233428 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2147 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.0081 | 2105817.64626 | 37.7626700032421 | -122.412762703536 | (37.7626700032421, -122.412762703536) | 8 | 4 | 7 | 28859 | 19 | |||
| 124043 | 93976 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3261 Harrison St | : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036 | 2099698 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | 2 | 7 | 7 | 28859 | 2 | ||||
| 124180 | 96506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
| 124229 | 38308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 124358 | 87931 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008038 | 2106791 | 37.7653007068824 | -122.415411798097 | (37.7653007068824, -122.415411798097) | 8 | 4 | 7 | 28859 | 19 | ||
| 125518 | 194542 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012450.21381 | 2107404.91238 | 37.7672333764343 | -122.400194013336 | (37.7672333764343, -122.400194013336) | 14 | 3 | 8 | 28856 | 20 |
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) );