Street_Tree_List

Data source: data.sfgov.org

157 rows where qSpecies = 84

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
457 142162 Undocumented 2 Prunus spp :: Cherry 84 490X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
2581 107490 DPW Maintained 3 Prunus spp :: Cherry 84 1306x Montgomery St 19 Median : Cutout 11 Tree 1 DPW 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
5325 40088 Permitted Site 1 Prunus spp :: Cherry 84   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/09/1999 12:00:00 AM     Permit Number 41311          
6573 19697 DPW Maintained 3 Prunus spp :: Cherry 84 100 STAIRWAY9 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 15ST            
9515 19958 DPW Maintained 3 Prunus spp :: Cherry 84 100 STAIRWAY40 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 15ST            
9562 19696 DPW Maintained 3 Prunus spp :: Cherry 84 100 STAIRWAY9 -3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
10800 19957 DPW Maintained 3 Prunus spp :: Cherry 84 100 STAIRWAY40 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 15ST            
12896 19960 DPW Maintained 3 Prunus spp :: Cherry 84 100 STAIRWAY41 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
14815 29657 DPW Maintained 3 Prunus spp :: Cherry 84 299X Cashmere St 1 Median : Cutout 11 Tree 1 DPW 2   04/07/2006 12:00:00 AM 3 3x3   6016930.3488300005 2095863.99444 37.735793199983796 -122.38389404137699 (37.7357931999838, -122.383894041377)
16368 19956 DPW Maintained 3 Prunus spp :: Cherry 84 100 STAIRWAY40 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
17606 6944 DPW Maintained 3 Prunus spp :: Cherry 84 561 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/09/2006 12:00:00 AM 3 3X3   6004740.44786 2110511.39404 37.7753301167361 -122.42708227125601 (37.7753301167361, -122.427082271256)
17845 21084 DPW Maintained 3 Prunus spp :: Cherry 84 2192X Sunset Blvd 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
19474 51214 Permitted Site 1 Prunus spp :: Cherry 84 111 Mission St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2004 12:00:00 AM     Permit Number 47578 6014394.74626942 2116530.73461445 37.7923990500381 -122.39410705418699 (37.7923990500381, -122.394107054187)
21424 4161 DPW Maintained 3 Prunus spp :: Cherry 84 3747 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/26/2001 12:00:00 AM 3 3X3   6005530.36537 2100484.52073 37.747843324004606 -122.423636704969 (37.7478433240046, -122.423636704969)
24959 212860 Undocumented 2 Prunus spp :: Cherry 84 129 Merced Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5994548.15716 2099444.62817 37.7443620078908 -122.461537000359 (37.7443620078908, -122.461537000359)
25209 196534 Undocumented 2 Prunus spp :: Cherry 84 2221 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011830.1521 2101342.3848900003 37.750552424667504 -122.401912510764 (37.7505524246675, -122.401912510764)
25681 196512 Undocumented 2 Prunus spp :: Cherry 84 625 King St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6011914.18479 2108425.06588 37.770004584260704 -122.402119799109 (37.7700045842607, -122.402119799109)
27679 234916 Undocumented 2 Prunus spp :: Cherry 84 1 Albion St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6005792.88209 2107221.84485 37.766357260514 -122.423207770616 (37.766357260514, -122.423207770616)
29648 196372 Undocumented 2 Prunus spp :: Cherry 84 1700 Armstrong Ave 7 Side Yard : Yard 17 Tree 1 Private 1     1     6013890.9677099995 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931)
31357 237945 Undocumented 2 Prunus spp :: Cherry 84 99 Aztec St 2 Side Yard : Yard 17 Tree 1 Private 1     14     6007968.29609 2099608.22097 37.7455745134701 -122.415144412305 (37.7455745134701, -122.415144412305)
36648 136020 Undocumented 2 Prunus spp :: Cherry 84 1477 Green St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   6006004.56438 2118595.56069 37.7975986409201 -122.423284189634 (37.7975986409201, -122.423284189634)
36913 237948 Undocumented 2 Prunus spp :: Cherry 84 3387 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6007155.62665 2101453.9635099997 37.7505968017181 -122.418085332981 (37.7505968017181, -122.418085332981)
37252 234917 Undocumented 2 Prunus spp :: Cherry 84 1341 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6011175.62775 2102086.9904099996 37.7525603976539 -122.40422831989599 (37.7525603976539, -122.404228319896)
38547 196063 Undocumented 2 Prunus spp :: Cherry 84 1751 22nd St 9 Side Yard : Yard 17 Tree 1 Private 1     3 Width 5ft   6012868.1198 2103766.18767 37.757265535503 -122.39849317144501 (37.757265535503, -122.398493171445)
40011 88560 Permitted Site 1 Prunus spp :: Cherry 84 2901 Pierce St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501.0 2118350.0 37.7966692015857 -122.43885009322901 (37.7966692015857, -122.438850093229)
41124 247987 Undocumented 2 Prunus spp :: Cherry 84 124 Mullen Ave 1 Front Yard : Yard 7 Tree 1 Private 1     11     6009857.2555 2099808.73815 37.7462310644209 -122.408626794296 (37.7462310644209, -122.408626794296)
42127 234920 Undocumented 2 Prunus spp :: Cherry 84 501 York St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6009827.75137 2105874.2614 37.7628839834388 -122.409156748587 (37.7628839834388, -122.409156748587)
43070 234922 Undocumented 2 Prunus spp :: Cherry 84 818 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010155.119 2104325.0374 37.758648498551004 -122.40791523902399 (37.758648498551, -122.407915239024)
44716 179166 Undocumented 2 Prunus spp :: Cherry 84 137 University St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007974.04708 2093261.8498099998 37.7281490902886 -122.414675489606 (37.7281490902886, -122.414675489606)
47512 196066 Undocumented 2 Prunus spp :: Cherry 84 602 Arthur Ave 29 Front Yard : Yard 7 Tree 1 Private 1     3     6015729.65904 2099863.28866 37.7467079937826 -122.38832437158999 (37.7467079937826, -122.38832437159)
47974 43350 Permitted Site 1 Prunus spp :: Cherry 84 651 Cambridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2000 12:00:00 AM 8   Permit Number 43102 6007249.157459999 2091540.3167400002 37.7233813767346 -122.417059535679 (37.7233813767346, -122.417059535679)
50088 1497 DPW Maintained 3 Prunus spp :: Cherry 84 325 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5995534.5488977 2114067.6155393003 37.7845696798314 -122.45918496626999 (37.7845696798314, -122.45918496627)
51063 120699 Undocumented 2 Prunus spp :: Cherry 84 82 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5988985.45615 2114833.30825 37.786293373056104 -122.48189845318501 (37.7862933730561, -122.481898453185)
53397 237946 Undocumented 2 Prunus spp :: Cherry 84 923 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6008002.82503 2102600.12508 37.7537915497511 -122.41523676997299 (37.7537915497511, -122.415236769973)
55882 196536 Undocumented 2 Prunus spp :: Cherry 84 1422 Rhode Island St 1 : 4 Tree 1 Private 1     10 Width 3ft   6011983.19537 2101729.68858 37.751624416549795 -122.40141048760401 (37.7516244165498, -122.401410487604)
60657 213701 Undocumented 2 Prunus spp :: Cherry 84 700 Junipero Serra Blvd 130 : 4 Tree 1 Private 1     8 Width 0ft   5991210.94255 2091714.66662 37.722944834118294 -122.47251283382201 (37.7229448341183, -122.472512833822)
61578 238534 Undocumented 2 Prunus spp :: Cherry 84 671 Church St 39 Front Yard : Yard 7 Tree 1 Private 1     12 Width 3ft   6004315.939809999 2105094.00544 37.7604312615151 -122.428164581928 (37.7604312615151, -122.428164581928)
63837 234919 Undocumented 2 Prunus spp :: Cherry 84 200 Saint Marys Ave 5 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6003932.02563 2095971.19882 37.735360426449105 -122.428841975603 (37.7353604264491, -122.428841975603)
63982 247592 Undocumented 2 Prunus spp :: Cherry 84 800 Tompkins Ave 13 Front Yard : Yard 7 Tree 1 Private 1     20     6008994.80779 2096446.35961 37.736950368458096 -122.41137154767799 (37.7369503684581, -122.411371547678)
66954 234918 Undocumented 2 Prunus spp :: Cherry 84 1319 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6011166.831619999 2102201.8831 37.75287537621829 -122.404266824377 (37.7528753762183, -122.404266824377)
68550 234921 Undocumented 2 Prunus spp :: Cherry 84 1062 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006317.5902 2103335.47216 37.7557157877704 -122.421116917936 (37.7557157877704, -122.421116917936)
69797 179164 Undocumented 2 Prunus spp :: Cherry 84 906 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6001361.98728 2088931.83355 37.7158861309088 -122.43722367146002 (37.7158861309088, -122.43722367146)
70326 237949 Undocumented 2 Prunus spp :: Cherry 84 3145 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6008037.75868 2102668.77987 37.753982023462704 -122.41512082037599 (37.7539820234627, -122.415120820376)
74766 237971 Undocumented 2 Prunus spp :: Cherry 84 3178 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008600.41483 2100617.45628 37.748381152776396 -122.413029982045 (37.7483811527764, -122.413029982045)
75325 196511 Undocumented 2 Prunus spp :: Cherry 84 625 King St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   6011918.6881 2108412.1194599997 37.7699692876805 -122.402103311835 (37.7699692876805, -122.402103311835)
76569 136021 Undocumented 2 Prunus spp :: Cherry 84 1010 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6007482.49892 2120248.47345 37.802220422406705 -122.418287380977 (37.8022204224067, -122.418287380977)
77820 16688 DPW Maintained 3 Prunus spp :: Cherry 84 600X Noriega St 1 Median : Cutout 11 Tree 1 DPW 2     3 2   5992180.8132004 2103552.59538 37.7555048781502 -122.47002175838301 (37.7555048781502, -122.470021758383)
77997 53523 Permitted Site 1 Prunus spp :: Cherry 84 221 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/28/2015 12:00:00 AM 4 3x3 Permit Number 775251 5994812.01878897 2088373.36040249 37.7139781801866 -122.45982282724701 (37.7139781801866, -122.459822827247)
78119 105781 Permitted Site 1 Prunus spp :: Cherry 84 1631 MCALLISTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/03/2014 12:00:00 AM     Permit Number 772613 6001347.6 2111440.1 37.7776876665107 -122.43888545994 (37.7776876665107, -122.43888545994)
78765 122579 Undocumented 2 Prunus spp :: Cherry 84 2500X Lyon St 1 Median : Cutout 11 Tree 1 Private 1     30 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
81568 40117 Permitted Site 1 Prunus spp :: Cherry 84 51 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/29/2001 12:00:00 AM     Permit Number 41332 6004835.9770779 2101026.68937802 37.7492927732201 -122.42607645855 (37.7492927732201, -122.42607645855)
82397 45454 Permitted Site 1 Prunus spp :: Cherry 84 219 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2001 12:00:00 AM     Permit Number 44239 5994709.07342911 2090056.25354598 37.7185930847656 -122.460300500781 (37.7185930847656, -122.460300500781)
82823 104765 Undocumented 2 Prunus spp :: Cherry 84 47 VICKSBURG ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 4x4   6004132.1 2102787.4 37.754087465401604 -122.428635972714 (37.7540874654016, -122.428635972714)
85877 103517 Permitted Site 1 Prunus spp :: Cherry 84 55X MacOndray Ln 1 Unaccepted Street : Yard 14 Tree 1 Private 1         Permit Number 770452 6008432.0 2119159.0 37.7992824016355 -122.41492448290899 (37.7992824016355, -122.414924482909)
86674 107457 Undocumented 2 Prunus spp :: Cherry 84 2682 16TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5991487.4 2097177.7 37.737960952695396 -122.47195516350901 (37.7379609526954, -122.471955163509)
86739 86757 Permitted Site 1 Prunus spp :: Cherry 84 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
88192 50440 Permitted Site 1 Prunus spp :: Cherry 84 1539 Funston Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320978998 (37.7593865436509, -122.47037320979)
90214 50019 Permitted Site 1 Prunus spp :: Cherry 84 1363 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM     Permit Number 46753 6009308.17778689 2101227.80950502 37.750096752782504 -122.410625639874 (37.7500967527825, -122.410625639874)
90536 19034 Permitted Site 1 Prunus spp :: Cherry 84 3192 Sacramento St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     12 2X2   5999529.89099 2115397.3219999997 37.7884495878023 -122.445458129536 (37.7884495878023, -122.445458129536)
91181 51065 Permitted Site 1 Prunus spp :: Cherry 84 10 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
91261 105378 Undocumented 2 Prunus spp :: Cherry 84 298X SAN FERNANDO WAY 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 2x2   5991951.0 2094979.0 37.7319506911602 -122.47019222238899 (37.7319506911602, -122.470192222389)
92134 56560 Permitted Site 1 Prunus spp :: Cherry 84 298X SAN FERNANDO WAY 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 2x2   5992129.0 2095185.0 37.7325266047982 -122.46959183484199 (37.7325266047982, -122.469591834842)
92324 96987 Permitted Site 1 Prunus spp :: Cherry 84 2201 North Point St   Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
93929 49741 Permitted Site 1 Prunus spp :: Cherry 84 646@ 18th Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46540 6010086.91434322 2105281.03537103 37.761269634638296 -122.408218548113 (37.7612696346383, -122.408218548113)
94149 58408 Permitted Site 1 Prunus spp :: Cherry 84 755 Buena Vista Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/1979 12:00:00 AM 5   Permit Number 17543 5999798.5 2108081.7 37.7683780948237 -122.44400294123699 (37.7683780948237, -122.444002941237)
94724 84725 Permitted Site 1 Prunus spp :: Cherry 84 20 Cherry St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2007 12:00:00 AM     Permit No. 49296 5996092.0 2115960.0 37.7897976912986 -122.457393340224 (37.7897976912986, -122.457393340224)
95257 93959 Permitted Site 1 Prunus spp :: Cherry 84 419 Elizabeth St   Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 53399 6003681.0 2102149.0 37.752309029626495 -122.430150445418 (37.7523090296265, -122.430150445418)
96787 19030 DPW Maintained 3 Prunus spp :: Cherry 84 3176 SACRAMENTO ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
97214 17372 Permitted Site 1 Prunus spp :: Cherry 84 1050X Masonic Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/24/2012 12:00:00 AM 6 3X3 Permit Number 769300 5999379.151930001 2109268.47217 37.771612740675394 -122.44553877169399 (37.7716127406754, -122.445538771694)
98177 19029 DPW Maintained 3 Prunus spp :: Cherry 84 3176 SACRAMENTO ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
98329 40636 Permitted Site 1 Prunus spp :: Cherry 84 142 Russ St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/10/1999 12:00:00 AM     Permit Number 41636 6010372.94752615 2111469.26002805 37.7782770896065 -122.40766561205099 (37.7782770896065, -122.407665612051)
98763 249657 Undocumented 2 Prunus spp :: Cherry 84 2401 Lyon St 9 Front Yard : Yard 7 Tree 1 Private 1     5 Width 10ft   5999220.856459999 2117228.0712599996 37.7934586955217 -122.44665911012301 (37.7934586955217, -122.446659110123)
100159 52194 Permitted Site 1 Prunus spp :: Cherry 84 415 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.42751119704201 (37.7737647507648, -122.427511197042)
100275 96676 Property Tree 7 Prunus spp :: Cherry 84 1701 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
102022 20856 DPW Maintained 3 Prunus spp :: Cherry 84 1892X Sunset Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
104294 43986 Permitted Site 1 Prunus spp :: Cherry 84 2200 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2000 12:00:00 AM     Permit Number 43550 6005547.87197183 2117529.65351428 37.7946461451301 -122.42478860010799 (37.7946461451301, -122.424788600108)
104487 53181 Permitted Site 1 Prunus spp :: Cherry 84 2784 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/07/2006 12:00:00 AM   3x3 Permit Number 49099 6010077.71172244 2102830.43618978 37.7545403242811 -122.408077545352 (37.7545403242811, -122.408077545352)
105516 51062 Permitted Site 1 Prunus spp :: Cherry 84 10 South Van Ness Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
106210 56999 Permitted Site 1 Prunus spp :: Cherry 84 4206 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/1974 12:00:00 AM     Permit Number 14257 6001838.61131344 2101787.92307498 37.7512130767933 -122.43649586805401 (37.7512130767933, -122.436495868054)
107994 39201 Permitted Site 1 Prunus spp :: Cherry 84 36 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/1998 12:00:00 AM   3x3 Permit Number 40852 5996541.64157093 2114326.11365116 37.7853372927938 -122.455719478601 (37.7853372927938, -122.455719478601)
111429 82056 Permitted Site 1 Prunus spp :: Cherry 84 447 Bright St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2011 12:00:00 AM   3x3 Permit Number 767285 5993745.17939928 2090171.13367763 37.718853024691896 -122.463640596127 (37.7188530246919, -122.463640596127)
111577 51061 Permitted Site 1 Prunus spp :: Cherry 84 10 South Van Ness Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
111598 102286 Undocumented 2 Prunus spp :: Cherry 84 122 Hoffman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/2014 12:00:00 AM 26 4x4 Permit Number 772865 6000574.8 2102350.7 37.7526864299915 -122.44090662134501 (37.7526864299915, -122.440906621345)
111732 50308 Permitted Site 1 Prunus spp :: Cherry 84 701 (REVISED) Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/30/2003 12:00:00 AM     Permit Number 47019 5994734.51143453 2090549.74162157 37.719949548569396 -122.46024830726499 (37.7199495485694, -122.460248307265)
112476 19031 Permitted Site 1 Prunus spp :: Cherry 84 3190 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 2X2   5999568.0947900005 2115476.97835 37.7886704841429 -122.445331680485 (37.7886704841429, -122.445331680485)
113713 19022 Permitted Site 1 Prunus spp :: Cherry 84 3170 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
115861 96677 Permitted Site 1 Prunus spp :: Cherry 84 1701 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 767971 5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
115880 51064 Permitted Site 1 Prunus spp :: Cherry 84 10 South Van Ness Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
116225 49367 Permitted Site 1 Prunus spp :: Cherry 84 1328@ 4th & 5t Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2005 12:00:00 AM     Permit Number 47977 5994585.78557071 2112147.74022661 37.7792436288989 -122.46232804837099 (37.7792436288989, -122.462328048371)
116443 213700 Undocumented 2 Prunus spp :: Cherry 84 1316 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993037.4807 2106453.44522 37.76351933917171 -122.46727007765499 (37.7635193391717, -122.467270077655)
117786 109243 Permitted Site 1 Prunus spp :: Cherry 84 755 Buena Vista Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4     5999798.5 2108081.7 37.7683780948237 -122.44400294123699 (37.7683780948237, -122.444002941237)
119284 116071 DPW Maintained 3 Prunus spp :: Cherry 84 4150X CLEMENT ST 1 Front Yard : Yard 7 Tree 1 DPW 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
119551 20857 DPW Maintained 3 Prunus spp :: Cherry 84 1892X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
121392 11193 DPW Maintained 3 Prunus spp :: Cherry 84 162 Idora Ave 1 Median : Cutout 11 Tree 1 DPW 2     18 8   5995521.0890831 2099407.054304 37.7443147925186 -122.458170108957 (37.7443147925186, -122.458170108957)
123844 19023 DPW Maintained 3 Prunus spp :: Cherry 84 3170 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
124426 41411 Permitted Site 1 Prunus spp :: Cherry 84 531 Leland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/17/2000 12:00:00 AM     Permit Number 42023 6007932.96070428 2088253.06472002 37.7143937182098 -122.414463253601 (37.7143937182098, -122.414463253601)
125784 42766 Permitted Site 1 Prunus spp :: Cherry 84 415 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.42751119704201 (37.7737647507648, -122.427511197042)
131317 117739 Undocumented 2 Prunus spp :: Cherry 84 475 39th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5983746.16527 2112679.78018 37.7800743257794 -122.49986552243 (37.7800743257794, -122.49986552243)
132716 212861 Undocumented 2 Prunus spp :: Cherry 84 175 Garcia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5994619.09353 2099469.67136 37.7444348530002 -122.461293534079 (37.7444348530002, -122.461293534079)
135994 234923 Undocumented 2 Prunus spp :: Cherry 84 24 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009961.80336 2099942.52208 37.7466042605945 -122.40827471331998 (37.7466042605945, -122.40827471332)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 68.543ms · Data source: data.sfgov.org