Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by Latitude

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location
6092 46303 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
7478 46291 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
10371 46304 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
11759 46302 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
12993 19985 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 100 STAIRWAY46 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 40            
13945 46285 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
16163 26637 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 400X Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/1998 12:00:00 AM 6 3X3            
22840 251107 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1700X Quesada Ave 1 Median : Yard 3 Tree 1 DPW 2                    
148678 180562 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 4101 Alemany Blvd 1 : 4 Tree 1 Private 1     12 Width 3ft   5991620.890430001 2086817.0358099998 37.70952085356139 -122.470739173794 (37.7095208535614, -122.470739173794)
85950 1325 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 4051X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   5991764.76245 2086963.37686 37.709930989883496 -122.47025258193399 (37.7099309898835, -122.470252581934)
78358 1208 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3141 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   5995992.87885 2086942.4061599998 37.7101169521706 -122.455637985173 (37.7101169521706, -122.455637985173)
97919 11876 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1501X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     12 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
107376 11877 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1501X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
139746 11878 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1501X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
98502 40800 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 167 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/1999 12:00:00 AM     Permit Number 41749 5995317.58858632 2087395.72139247 37.711322874409596 -122.458004690935 (37.7113228744096, -122.458004690935)
11281 1166 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 25 3X3   5997012.91474 2087625.1618700002 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836)
150445 180561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1134 Naples St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   6001348.51244 2087850.78247 37.712917038962495 -122.437192888562 (37.7129170389625, -122.437192888562)
165192 180560 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1134 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   6001363.50733 2087875.35573 37.7129853640648 -122.437142819708 (37.7129853640648, -122.437142819708)
44061 180541 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 762 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002189.480330001 2089236.03979 37.716768418898795 -122.43438521053301 (37.7167684188988, -122.434385210533)
137877 180559 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 192 Dublin St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 5ft   6004156.4754099995 2089333.3612 37.717147098249605 -122.427593206665 (37.7171470982496, -122.427593206665)
12432 17625 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1132 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   6004425.094930001 2089870.4961599999 37.7186371444562 -122.426702945308 (37.7186371444562, -122.426702945308)
13153 17626 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1135 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6004454.014359999 2089904.4684 37.718732059816205 -122.42660540034099 (37.7187320598162, -122.426605400341)
11929 17621 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1100 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3X3   6004336.281690001 2089926.3148400001 37.7187853887157 -122.42701391015899 (37.7187853887157, -122.427013910159)
13231 17623 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1101 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6004371.84322 2089954.8563599999 37.718865768324 -122.426893019707 (37.718865768324, -122.426893019707)
96603 17627 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1135 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/27/2005 12:00:00 AM 3 3X3   6004380.712681401 2089954.6929998002 37.718865821274 -122.42686234984801 (37.718865821274, -122.426862349848)
104545 51892 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1135 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2005 12:00:00 AM     Permit Number 48104 6004381.23162594 2089955.54800101 37.7188681982632 -122.42686061692 (37.7188681982632, -122.42686061692)
124040 17622 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1100 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004279.363726401 2089959.3319014 37.7188728276872 -122.427213003456 (37.7188728276872, -122.427213003456)
11325 17624 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1101 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6004341.89656 2089971.87372 37.7189108009657 -122.426997744874 (37.7189108009657, -122.426997744874)
11164 17617 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1042 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3x3   6004228.49613 2089992.79688 37.7189618383998 -122.427391215355 (37.7189618383998, -122.427391215355)
12487 17616 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1030 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6004194.38835 2090014.0443400003 37.719018250172 -122.42751062553499 (37.719018250172, -122.427510625535)
54259 180512 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1027 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004254.69534 2090025.2040000001 37.71905230300529 -122.427302962162 (37.7190523030053, -122.427302962162)
10375 17615 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1018 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3x3   6004156.70512 2090037.9094200002 37.7190816469907 -122.427642581247 (37.7190816469907, -122.427642581247)
65179 180513 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1027 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004235.638830001 2090036.93621 37.719083439333204 -122.427369668478 (37.7190834393332, -122.427369668478)
168800 180514 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1027 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 Width 4ft   6004210.581680001 2090053.8218900003 37.7191283865346 -122.427457483699 (37.7191283865346, -122.427457483699)
12681 17608 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1000X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/26/1999 12:00:00 AM 40 6x9   6004130.9636 2090056.2016 37.7191304172171 -122.427732862395 (37.7191304172171, -122.427732862395)
11239 17609 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1000X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004106.27078 2090068.65464 37.7191632136975 -122.42781910286999 (37.7191632136975, -122.42781910287)
149925 180515 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1023 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6004177.13289 2090077.86698 37.7191925171931 -122.427574815527 (37.7191925171931, -122.427574815527)
18738 17618 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1049X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6004182.578886599 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461)
96728 17620 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1049X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6004182.578886599 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461)
117397 17619 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1049X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6004182.578886599 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461)
12237 17610 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1000X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004083.7901099995 2090083.69021 37.7192032263241 -122.427897880781 (37.7192032263241, -122.427897880781)
177135 180539 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2063 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6000471.84431 2090162.7563 37.7192153258175 -122.440388640236 (37.7192153258175, -122.440388640236)
173144 180516 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1023 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6004155.91588 2090090.6053799998 37.7192262939354 -122.427649061763 (37.7192262939354, -122.427649061763)
30655 180517 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1023 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6004131.62894 2090104.3716099998 37.719262719168896 -122.42773399285299 (37.7192627191689, -122.427733992853)
38828 180542 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 990 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6004004.09033 2090139.32192 37.7193514696869 -122.42817733523 (37.7193514696869, -122.42817733523)
84787 17611 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1001X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     50 3X3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
118411 17613 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1001X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
142590 17612 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1001X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
13109 17606 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 945X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6004029.89293 2090169.1541 37.7194348422149 -122.428090270065 (37.7194348422149, -122.428090270065)
49109 17607 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 948X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3x3   6003925.750010201 2090181.5613292998 37.719463016991504 -122.42845113758601 (37.7194630169915, -122.428451137586)
10792 17605 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 937 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6003999.6997 2090190.6100400002 37.7194920472054 -122.428196165219 (37.7194920472054, -122.428196165219)
10537 17602 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 912 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6003897.46129 2090203.63126 37.7195220153206 -122.428550493605 (37.7195220153206, -122.428550493605)
12044 17598 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 900 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6003858.866640001 2090228.3157 37.719587609170006 -122.42868565992399 (37.71958760917, -122.428685659924)
160059 180518 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 919 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6003927.65212 2090238.59404 37.7196197239493 -122.42844862563 (37.7196197239493, -122.42844862563)
174369 180519 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 919 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6003897.75198 2090254.30542 37.719661171900796 -122.42855309895701 (37.7196611719008, -122.428553098957)
65813 180520 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 919 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6003878.6160699995 2090266.0202 37.71969225516521 -122.42862007955799 (37.7196922551652, -122.428620079558)
11611 17597 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 844 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6003772.37846 2090279.5258799999 37.71972332585371 -122.428988267402 (37.7197233258537, -122.428988267402)
89129 17601 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 901X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3x3   6003845.6513541 2090290.9535450002 37.719758851010496 -122.42873580329399 (37.7197588510105, -122.428735803294)
109093 17600 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 901X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3x3   6003845.6513541 2090290.9535450002 37.719758851010496 -122.42873580329399 (37.7197588510105, -122.428735803294)
144473 17599 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 901X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6003845.6513541 2090290.9535450002 37.719758851010496 -122.42873580329399 (37.7197588510105, -122.428735803294)
12598 17596 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 822 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 3X3   6003747.6295300005 2090297.4937 37.719771260609996 -122.429075096066 (37.71977126061, -122.429075096066)
10968 17595 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 818 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3x3   6003715.34966 2090318.2223099999 37.719826349498895 -122.42918815340401 (37.7198263494989, -122.429188153404)
12693 17579 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6003783.82433 2090321.42028 37.7198390065544 -122.428951688396 (37.7198390065544, -122.428951688396)
12769 17578 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     18 3x3   6003799.63122 2090323.6743700001 37.7198460905006 -122.428897210135 (37.7198460905006, -122.428897210135)
11600 17581 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6003766.7866400005 2090331.9281799998 37.7198668945342 -122.429011330508 (37.7198668945342, -122.429011330508)
10957 17580 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 4 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     18 3x3   6003780.63082 2090335.5596900003 37.719877649504205 -122.428963734788 (37.7198776495042, -122.428963734788)
12076 17583 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6003749.1517199995 2090342.6567099998 37.7198953544779 -122.429073052804 (37.7198953544779, -122.429073052804)
11152 17582 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 6 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     18 3x3   6003762.13068 2090345.22062 37.7199031291015 -122.42902837176202 (37.7199031291015, -122.429028371762)
12133 17594 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 808 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3x3   6003660.5889 2090352.7029799998 37.719917925661 -122.42937989966002 (37.719917925661, -122.42937989966)
12305 17584 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 8 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     18 3x3   6003740.32149 2090358.06458 37.7199371612464 -122.42910467385201 (37.7199371612464, -122.429104673852)
78526 97030 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 278 Howth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5997252.0 2090493.0 37.7199382378616 -122.451542171872 (37.7199382378616, -122.451542171872)
147164 215518 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 278 Howth St 1 : 4 Tree 1 Private 1     10 Width 3ft   5997249.4841 2090499.4445099998 37.719955788905295 -122.451551333026 (37.7199557889053, -122.451551333026)
11538 17585 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6003724.8526 2090366.56287 37.71995962001 -122.429158750084 (37.71995962001, -122.429158750084)
11095 17586 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6003709.25966 2090367.0753099998 37.7199601443381 -122.42921268601499 (37.7199601443381, -122.429212686015)
12852 17587 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 11 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     35 3X3   6003703.481380001 2090378.19842 37.7199903588363 -122.42923345225901 (37.7199903588363, -122.429233452259)
12573 17588 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6003687.80932 2090380.0219599998 37.7199944786431 -122.429287755146 (37.7199944786431, -122.429287755146)
10554 17590 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6003668.70994 2090393.5126599998 37.720030439842 -122.429354736658 (37.720030439842, -122.429354736658)
11319 17589 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 13 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     18 3x3   6003683.23846 2090394.91559 37.720035114503006 -122.42930461652 (37.720035114503, -122.42930461652)
11996 17591 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 15 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     30 3x3   6003659.63671 2090407.2266799998 37.7200675818369 -122.42938707716299 (37.7200675818369, -122.429387077163)
10729 17592 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6003646.11767 2090408.41073 37.7200700675728 -122.42943389227699 (37.7200700675728, -122.429433892277)
175570 180543 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 790 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/1997 12:00:00 AM 15 Width 3ft   6003544.6260400005 2090426.4873900001 37.720113955375794 -122.42978600294799 (37.7201139553758, -122.429786002948)
126009 17576 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 752X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3x3   6003542.00606 2090427.72603 37.72011720804429 -122.429795147634 (37.7201172080443, -122.429795147634)
135438 180544 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 790 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 3ft   6003493.29821 2090458.5118900002 37.72019898087729 -122.429965709077 (37.7201989808773, -122.429965709077)
78604 17574 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 752X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/1997 12:00:00 AM 16 3x3   6003494.26805 2090459.52433 37.7202018157394 -122.429962428847 (37.7202018157394, -122.429962428847)
161969 180521 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 703 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003571.912830001 2090460.5542799998 37.7202090407058 -122.429694110218 (37.7202090407058, -122.429694110218)
12028 17573 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 750 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   6003469.3677199995 2090473.15538 37.720237833385404 -122.430049472832 (37.7202378333854, -122.430049472832)
74127 180522 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 703 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6003548.0155 2090475.44462 37.7202485730803 -122.42977777681699 (37.7202485730803, -122.429777776817)
81956 17571 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 749X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6003526.33065 2090483.75414 37.7202701612065 -122.429853326536 (37.7202701612065, -122.429853326536)
12659 17567 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 700X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 2x2   6003448.03192 2090486.73855 37.7202739213865 -122.430124192087 (37.7202739213865, -122.430124192087)
147593 180523 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 703 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6003530.180369999 2090485.1231200001 37.720274138132 -122.42984011692499 (37.720274138132, -122.429840116925)
187214 180524 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 703 Persia Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6003506.1468400005 2090499.6144299998 37.72031256704079 -122.429924226024 (37.7203125670408, -122.429924226024)
11718 17568 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 700X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6003419.6169300005 2090505.6702299998 37.720324294201 -122.430223763218 (37.720324294201, -122.430223763218)
153735 180525 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 701 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6003487.94744 2090511.7245099999 37.72034478796721 -122.429987998761 (37.7203447879672, -122.429987998761)
96131 17570 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 749X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6003493.5133628 2090512.2555079 37.720346561187796 -122.42996879704799 (37.7203465611878, -122.429968797048)
103275 17572 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 749X Persia Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6003493.5133628 2090512.2555079 37.720346561187796 -122.42996879704799 (37.7203465611878, -122.429968797048)
36663 180526 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 701 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6003462.66428 2090526.46403 37.7203838275255 -122.43007644527701 (37.7203838275255, -122.430076445277)
10288 17565 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 701X Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 4.5x4.5   6003438.97081 2090543.76547 37.720429991522295 -122.43015957951599 (37.7204299915223, -122.430159579516)
105421 17564 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 701X Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4.5x8   6003386.5742173 2090579.4616613 37.7205250375642 -122.430343243034 (37.7205250375642, -122.430343243034)
116866 17563 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 701X Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4.5x4.5   6003386.5742173 2090579.4616613 37.7205250375642 -122.430343243034 (37.7205250375642, -122.430343243034)
12788 17558 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 632 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6003270.54295 2090597.85658 37.7205689727677 -122.430745637999 (37.7205689727677, -122.430745637999)

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 1292.834ms · Data source: data.sfgov.org