trees
443 rows where qSpecies_id = 32 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
922 | 91748 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
10598 | 91743 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2708 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008911.299202 | 2102677.621362 | 37.7540553520509 | -122.412100523216 | (37.7540553520509, -122.412100523216) | 2 | 4 | 7 | 28859 | 19 | ||
12121 | 11883 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017703.73127 | 2096843.30561 | 37.7385249167977 | -122.381288201801 | (37.7385249167977, -122.381288201801) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
21910 | 96514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2525 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008931.78407 | 2103601.217 | 37.7565924865992 | -122.412094949605 | (37.7565924865992, -122.412094949605) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
26149 | 29650 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 9 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015718.9286 | 2096019.8862 | 37.7361542039988 | -122.388093308135 | (37.7361542039988, -122.388093308135) | 10 | 3 | 8 | 58 | 1 | ||
26635 | 26526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 3x3 | 6009007 | 2102243 | 37.7528673485866 | -122.411738857609 | (37.7528673485866, -122.411738857609) | 2 | 4 | 7 | 28859 | 19 | ||
30388 | 91747 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
30722 | 91760 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 1 | 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 | ||
31941 | 91751 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2660 Harrison St | 1 | 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 | ||
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 | ||
34806 | 91741 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2844 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
36781 | 29649 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 8 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015738.3943 | 2096009.2115 | 37.7361259719003 | -122.388025261983 | (37.7361259719003, -122.388025261983) | 10 | 3 | 8 | 58 | 1 | ||
41209 | 91753 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2500X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/07/2007 12:00:00 AM | 5 | 3x3 | 6008845.834759 | 2103888.876448 | 37.7573775113883 | -122.412412526543 | (37.7573775113883, -122.412412526543) | 2 | 4 | 7 | 28859 | 19 | |
42115 | 91833 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1817X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2012 12:00:00 AM | 3 | 3x3 | 6008674.032707 | 2108297.585738 | 37.7694731696871 | -122.413318454137 | (37.7694731696871, -122.413318454137) | 8 | 4 | 7 | 28853 | 19 | ||
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 | ||
47331 | 29648 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 7 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015756.6041 | 2095993.5134 | 37.7360838769453 | -122.38796120765 | (37.7360838769453, -122.38796120765) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
55923 | 91746 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
63347 | 91750 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008893.124476 | 2103015.18846 | 37.7549812154524 | -122.412187232232 | (37.7549812154524, -122.412187232232) | 2 | 4 | 7 | 28859 | 19 | ||
65099 | 28133 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/2018 12:00:00 AM | 3 | 6x9 | Permit Number 778832 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | 2 | 7 | 7 | 28859 | 2 | |
76805 | 91758 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008737.740026 | 2105649.554962 | 37.7622058660826 | -122.412910843759 | (37.7622058660826, -122.412910843759) | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
131306 | 3871 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
132838 | 26467 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 300X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2016 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
136895 | 29646 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015803.0705 | 2095958.3496 | 37.7359898984178 | -122.387798100273 | (37.7359898984178, -122.387798100273) | 10 | 3 | 8 | 58 | 1 | ||
138652 | 91754 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008875.46007 | 2103341.542813 | 37.7558763196163 | -122.412271386078 | (37.7558763196163, -122.412271386078) | 2 | 4 | 7 | 28859 | 19 | ||
143745 | 91737 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | 2 | 4 | 7 | 28859 | 19 | |||
146681 | 91749 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
149857 | 91824 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2151 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008766 | 2105886 | 37.7628566761401 | -122.412829820139 | (37.7628566761401, -122.412829820139) | 8 | 4 | 7 | 28859 | 19 | ||
150663 | 91759 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2100X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008715.935636 | 2106109.169361 | 37.7634666376506 | -122.413018756224 | (37.7634666376506, -122.413018756224) | 8 | 4 | 7 | 28859 | 19 | ||
153544 | 29647 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1500X La Salle Ave | 6 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015782.349 | 2095974.6757 | 37.7360335786804 | -122.387870882274 | (37.7360335786804, -122.387870882274) | 10 | 3 | 8 | 58 | 1 | ||
159163 | 3872 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1540X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.7360927223499 | -122.3877073081 | (37.7360927223499, -122.3877073081) | 10 | 3 | 8 | 58 | 1 | |||
166080 | 91817 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008914.192408 | 2103366.044871 | 37.7559457700652 | -122.41213916812 | (37.7559457700652, -122.41213916812) | 2 | 4 | 7 | 28859 | 19 | ||
169761 | 91816 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2595 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008914.192408 | 2103366.044871 | 37.7559457700652 | -122.41213916812 | (37.7559457700652, -122.41213916812) | 2 | 4 | 7 | 28859 | 19 | ||
170559 | 91755 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008875.46007 | 2103341.542813 | 37.7558763196163 | -122.412271386078 | (37.7558763196163, -122.412271386078) | 2 | 4 | 7 | 28859 | 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 | ||
174718 | 91812 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2685 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | 2 | 4 | 7 | 28859 | 19 | ||
179917 | 91756 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2450 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | ||
190640 | 91738 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2900x Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008972.238365 | 2101556.992621 | 37.7509817758285 | -122.411810599761 | (37.7509817758285, -122.411810599761) | 2 | 4 | 7 | 28859 | 19 | |||
191679 | 91740 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2840 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008952.188354 | 2101915.380795 | 37.7519647047313 | -122.411905257789 | (37.7519647047313, -122.411905257789) | 2 | 4 | 7 | 28859 | 19 | |||
57 | 230549 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 39 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787877 | 6005359.28388 | 2095944.60166 | 37.7353680760624 | -122.423905517743 | (37.7353680760624, -122.423905517743) | 2 | 7 | 7 | 28859 | 2 | |
613 | 161126 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001694.7774 | 2090903.55181 | 37.721318940793 | -122.436214417168 | (37.721318940793, -122.436214417168) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
3069 | 233426 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008801.72689 | 2105503.58115 | 37.7618086469759 | -122.412679216788 | (37.7618086469759, -122.412679216788) | 8 | 4 | 7 | 28859 | 19 | |||
3388 | 261119 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2067 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6011786.16554 | 2094038.32843 | 37.730494584078 | -122.401551330673 | (37.730494584078, -122.401551330673) | 10 | 3 | 8 | 58 | 1 | ||
3506 | 161128 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001711.00806 | 2090931.14538 | 37.7213956286903 | -122.436160286079 | (37.7213956286903, -122.436160286079) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
4192 | 264915 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 1461 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784397 | 6015819.34366 | 2093828.22518 | 37.7301419060949 | -122.387593270969 | (37.7301419060949, -122.387593270969) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
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 | |||
6112 | 233465 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2460 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008820.36078 | 2104131.22912 | 37.7580415272211 | -122.41251775699 | (37.7580415272211, -122.41251775699) | 2 | 4 | 7 | 28859 | 19 | |||
6345 | 175597 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6001092.21629 | 2090034.68248 | 37.7188989677059 | -122.438235084102 | (37.7188989677059, -122.438235084102) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
7122 | 194543 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012559.7859 | 2107618.88108 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | 14 | 3 | 8 | 28856 | 20 | |||
8498 | 233506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008710.79759 | 2107246.55273 | 37.7665893413473 | -122.413116956406 | (37.7665893413473, -122.413116956406) | 8 | 4 | 7 | 28853 | 19 | |||
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 | ||
8831 | 233416 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008962 | 2103248 | 37.7556243278629 | -122.411965491523 | (37.7556243278629, -122.411965491523) | 2 | 4 | 7 | 28859 | 19 | |||
9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
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 | ||
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
10307 | 233401 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008031.26632 | 2103842.02923 | 37.7572031342345 | -122.415226318935 | (37.7572031342345, -122.415226318935) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
10399 | 161129 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001722.11588 | 2090948.37155 | 37.7214435589648 | -122.436123121581 | (37.7214435589648, -122.436123121581) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
10685 | 233450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009002.96054 | 2100768.18815 | 37.7488176180461 | -122.411648631477 | (37.7488176180461, -122.411648631477) | 2 | 4 | 7 | 28859 | 19 | |||
10817 | 233461 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6008869.1508 | 2103187.08693 | 37.7554518646255 | -122.41228228931 | (37.7554518646255, -122.41228228931) | 2 | 4 | 7 | 28859 | 19 | |||
10926 | 39982 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 41240 | 6013913.21051 | 2094747.21056 | 37.7325594879289 | -122.394247383904 | (37.7325594879289, -122.394247383904) | 10 | 3 | 8 | 58 | 1 |
10960 | 166315 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 | |
11175 | 233468 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008789.90434 | 2104591.00964 | 37.7593022705969 | -122.412655591576 | (37.7593022705969, -122.412655591576) | 2 | 4 | 7 | 28859 | 19 | |||
11621 | 171168 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 61 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004706.69577 | 2093156.0367 | 37.7276744353238 | -122.425963318556 | (37.7276744353238, -122.425963318556) | 9 | 7 | 6 | 28861 | 5 | |||
11691 | 233464 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2905 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008837.85782 | 2103822.74046 | 37.7571954693154 | -122.412435439344 | (37.7571954693154, -122.412435439344) | 2 | 4 | 7 | 28859 | 19 | |||
12003 | 166317 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008865.69274 | 2103234.56357 | 37.755582030708 | -122.412297603862 | (37.755582030708, -122.412297603862) | 2 | 4 | 7 | 28859 | 19 | |
12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||||||||||||
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 | |||
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 | |||
13489 | 160999 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 265 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6004550.61216 | 2090876.91947 | 37.7214076589281 | -122.426340700176 | (37.7214076589281, -122.426340700176) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |
14913 | 233381 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 399x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008152.13666 | 2096545.8865 | 37.7371763483116 | -122.414292086129 | (37.7371763483116, -122.414292086129) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
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) );