Street_Tree_List

Data source: data.sfgov.org

1,801 rows where qSiteInfo = 1 and qSpecies = 46 sorted by rowid descending

View and edit SQL

qSiteInfo

  • Sidewalk: Curb side : Cutout · 1,801
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189066 198682 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 149 Russ St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6010265.525359999 2111657.0003299997 37.778786566576294 -122.408050470058 (37.7787865665763, -122.408050470058)
189060 242523 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1746 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007971.8272400005 2108186.4031700003 37.7691284386503 -122.415739487404 (37.7691284386503, -122.415739487404)
188978 245223 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 321 Laguna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005094.6874 2109989.2967 37.7739165895729 -122.425819703011 (37.7739165895729, -122.425819703011)
188734 242567 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2121 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008134.5513 2106113.05528 37.7634446540583 -122.415029859359 (37.7634446540583, -122.415029859359)
188652 32989 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 666 Folsom St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013088.2865 2113616.3325900002 37.784324082736795 -122.398422883105 (37.7843240827368, -122.398422883105)
188638 137035 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 128 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6008088.76932 2112909.47489 37.782103445257896 -122.41566944999599 (37.7821034452579, -122.415669449996)
188607 242650 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2900 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6008804.74134 2103341.92852 37.75587341014379 -122.41251598264 (37.7558734101438, -122.41251598264)
188430 180567 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 79 Ney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003968.93484 2094040.3155900002 37.7300607449837 -122.428576774521 (37.7300607449837, -122.428576774521)
188178 198585 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 980 16th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013694.72301 2107142.03178 37.7665808787261 -122.395870983078 (37.7665808787261, -122.395870983078)
188123 215516 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 88 Keystone Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994119.69741 2093345.3808900001 37.7275903136211 -122.462576174158 (37.7275903136211, -122.462576174158)
187500 242738 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 115 Corbett Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6000793.83368 2105649.34692 37.7617561832258 -122.440385717444 (37.7617561832258, -122.440385717444)
187497 200580 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1330 Newcomb Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6016475.5774 2094870.1567 37.7330391696694 -122.38539714453199 (37.7330391696694, -122.385397144532)
187350 138413 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2445 PINE ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6002201.9014 2115017.8119 37.787559724860394 -122.436186239179 (37.7875597248604, -122.436186239179)
187299 137056 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 430 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6012005.941869999 2118434.64519 37.7974936729554 -122.402506368172 (37.7974936729554, -122.402506368172)
187253 242662 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 4079 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6002651.96363 2102375.3479299997 37.752872190804 -122.433725189963 (37.752872190804, -122.433725189963)
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)
187118 137037 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1034 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009816.75031 2116820.89237 37.792940242650296 -122.409967600744 (37.7929402426503, -122.409967600744)
186841 141787 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1461 Ellis St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6003867.7567 2113170.8508 37.7825829380566 -122.430290891107 (37.7825829380566, -122.430290891107)
186675 242610 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 385 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006081.68898 2097890.32077 37.7407513431967 -122.42154603481501 (37.7407513431967, -122.421546034815)
186669 242676 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 3937 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6003536.02331 2102417.7982 37.7530388738604 -122.430670977181 (37.7530388738604, -122.430670977181)
186667 242732 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 19 Danvers St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   5999814.65606 2105385.8314099996 37.7609768334339 -122.44375335744301 (37.7609768334339, -122.443753357443)
186580 198668 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 132 Russ St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6010340.42701 2111499.42905 37.778358106181294 -122.407780240888 (37.7783581061813, -122.407780240888)
186534 242588 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 660 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6002106.32831 2102091.3706400003 37.7520614807656 -122.435591781438 (37.7520614807656, -122.435591781438)
186318 137043 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1228 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6008992.0949 2117188.5729 37.793903550565794 -122.41284696823799 (37.7939035505658, -122.412846968238)
186309 113046 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 300x Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6010572.94796 2106882.2033599997 37.765693282929995 -122.40665039471001 (37.76569328293, -122.40665039471)
185991 242565 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2195 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008169.06246 2105538.8555900003 37.761869973535 -122.414869854678 (37.761869973535, -122.414869854678)
185960 137883 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1935 WEBSTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6003361.0711 2115379.2268 37.7886178684542 -122.432201565811 (37.7886178684542, -122.432201565811)
185954 198468 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 707 18th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6015390.71439 2105768.72163 37.7629042730221 -122.38990885831801 (37.7629042730221, -122.389908858318)
185874 136985 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Walnut St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5998649.64618 2115048.5568 37.787441680630295 -122.44847849798799 (37.7874416806303, -122.448478497988)
185665 215476 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 455 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993096.43343 2105917.73669 37.7620518272484 -122.467027231034 (37.7620518272484, -122.467027231034)
185598 242585 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 621 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002352.37411 2102063.87215 37.751999948254706 -122.434738953436 (37.7519999482547, -122.434738953436)
185553 53481 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2201 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1969 12:00:00 AM 8   Permit Number 6390 6002979.07126 2117470.0427 37.794337047177294 -122.433672716337 (37.7943370471773, -122.433672716337)
185344 101909 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1801 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2012 12:00:00 AM 1 3x3 Permit Number 56808 6000521.0 2114812.0 37.786898975000206 -122.44198702889099 (37.7868989750002, -122.441987028891)
185342 137012 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2920 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   5999646.08574 2117066.27924 37.793038738206796 -122.44517615236299 (37.7930387382068, -122.445176152363)
185322 201186 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 631 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6013494.3037 2113910.8362 37.785155331286 -122.397038852127 (37.785155331286, -122.397038852127)
185233 242516 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 3022 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6008363.70679 2100884.01351 37.749099768641 -122.413867368706 (37.749099768641, -122.413867368706)
184854 136970 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2414 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6000268.16935 2119589.8327200003 37.80000323650739 -122.44320504437201 (37.8000032365074, -122.443205044372)
184773 242432 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 340 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004922.334369999 2109891.99021 37.7736396682718 -122.42640897131201 (37.7736396682718, -122.426408971312)
184479 137013 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2920 Broadway 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   5999627.956569999 2117064.96637 37.79303409860729 -122.445238785654 (37.7930340986073, -122.445238785654)
184407 242407 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 3711 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6005550.66093 2104286.71463 37.7582844134195 -122.423836842808 (37.7582844134195, -122.423836842808)
184384 242528 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1942 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6008018.69066 2107110.7911900003 37.766177693769706 -122.415501227304 (37.7661776937697, -122.415501227304)
184125 242397 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1784 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6005589.03646 2107271.34136 37.7664816601377 -122.423916355479 (37.7664816601377, -122.423916355479)
183730 137017 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2700 Pacific Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6001093.24038 2116921.57925 37.79272392512 -122.440158546893 (37.79272392512, -122.440158546893)
183626 198441 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 500 Mariposa St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 6ft   6015454.54719 2106287.83835 37.7643331950564 -122.38972434082399 (37.7643331950564, -122.389724340824)
183548 136965 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2762 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   5999775.07561 2118126.74108 37.795957847619796 -122.44480610383002 (37.7959578476198, -122.44480610383)
183318 139519 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 712 CENTRAL AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5999641.3729 2110981.1417 37.776330262201704 -122.444754863472 (37.7763302622017, -122.444754863472)
182848 242546 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2470 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6008189.20727 2104080.2165599996 37.7578660173281 -122.41469695193001 (37.7578660173281, -122.41469695193)
182674 180529 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 403 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 2ft   6002841.07955 2090920.68428 37.7214310448921 -122.432253199447 (37.7214310448921, -122.432253199447)
182552 137023 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2201 Broadway 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6003036.9655 2117481.25366 37.7943711144001 -122.433473197238 (37.7943711144001, -122.433473197238)
182109 242508 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2752 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6008279.85784 2102398.6315099997 37.75325385950129 -122.41426446885599 (37.7532538595013, -122.414264468856)
181961 180570 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 39 University St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6007772.766419999 2093897.53246 37.7298832269189 -122.415416310622 (37.7298832269189, -122.415416310622)
181726 200749 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 5099 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6014757.0105 2094768.5741 37.7326650143875 -122.391331632933 (37.7326650143875, -122.391331632933)
181708 33124 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2380 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 12 6x6 Permit Number 37358 6001499.40758 2119065.9057400003 37.7986348002003 -122.438906933417 (37.7986348002003, -122.438906933417)
181701 242739 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 4097 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6001725.29855 2105828.01986 37.762299767634396 -122.437176952577 (37.7622997676344, -122.437176952577)
181379 242616 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 301 Highland Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006929.96078 2096538.12906 37.737086318962604 -122.418517164938 (37.7370863189626, -122.418517164938)
181262 242774 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 77 Colton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6006712.3277199995 2109620.2236099998 37.772994484746796 -122.420197807195 (37.7729944847468, -122.420197807195)
181077 198691 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1301 Newcomb Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6016677.93992 2094927.14945 37.7332068541071 -122.384701486 (37.7332068541071, -122.384701486)
181040 113047 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 300x Utah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6010575.33708 2106849.91364 37.7656047563669 -122.406639855538 (37.7656047563669, -122.406639855538)
181037 198594 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013331.88607 2107121.5339099998 37.766504403987796 -122.39712454356001 (37.7665044039878, -122.39712454356)
181007 198596 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1000 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013207.26395 2107117.3176700003 37.7664858887413 -122.397555296343 (37.7664858887413, -122.397555296343)
180919 115549 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 925x Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412)
180867 180533 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 401 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6002751.65611 2090978.09371 37.7215836076762 -122.43256640991699 (37.7215836076762, -122.432566409917)
180821 141892 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1315 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6004160.261 2112868.39 37.7817690197003 -122.429257377978 (37.7817690197003, -122.429257377978)
180765 88994 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 680 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/24/2008 12:00:00 AM 3 3x3 Permit Number 51742 6013026.737980001 2113549.67814 37.784137636178 -122.39863114183201 (37.784137636178, -122.398631141832)
180659 215475 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 455 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993086.32041 2105916.03813 37.76204657971879 -122.467062084267 (37.7620465797188, -122.467062084267)
180634 242617 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 300 Bennington St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007051.1369 2096685.57383 37.7374979908344 -122.41810865331699 (37.7374979908344, -122.418108653317)
180457 242609 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 530 Crescent Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007690.70376 2095682.97773 37.734781058900104 -122.41582638978501 (37.7347810589001, -122.415826389785)
180420 242634 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 3251 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6008492.70813 2099667.8353 37.7457676581463 -122.41333528481199 (37.7457676581463, -122.413335284812)
180271 242380 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1217 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6011151.17373 2102568.66425 37.75388160155921 -122.404346786677 (37.7538816015592, -122.404346786677)
180043 198467 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 707 18th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6015376.19959 2105766.90453 37.7628984786941 -122.389958933463 (37.7628984786941, -122.389958933463)
179887 98993 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1919 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/2012 12:00:00 AM 1 3x3 Permit Number 768862 6003810.0 2118645.0 37.7976102909597 -122.430881499482 (37.7976102909597, -122.430881499482)
179766 123693 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 9 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5995461.176580001 2113536.44974 37.7831070225625 -122.45940032745101 (37.7831070225625, -122.459400327451)
179556 242473 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2869 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6008372.54081 2101739.95978 37.751450501152505 -122.413897361091 (37.7514505011525, -122.413897361091)
179497 242503 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2618 Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6008245.42572 2102971.97718 37.754826202679205 -122.414424108384 (37.7548262026792, -122.414424108384)
178955 180555 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 201 Persia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6002345.73736 2091226.34505 37.72224222258421 -122.43398729649799 (37.7222422225842, -122.433987296498)
178810 242549 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2498 Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008194.176969999 2103947.9032 37.757502994275704 -122.41467040123699 (37.7575029942757, -122.414670401237)
178732 198681 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 149 Russ St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6010294.844330001 2111624.8311799997 37.778699879144796 -122.40794677462401 (37.7786998791448, -122.407946774624)
178706 242577 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1811 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008043.01248 2107858.0308 37.7682308064267 -122.41547001004999 (37.7682308064267, -122.41547001005)
178687 110079 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2751x Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   5990053.539580001 2111933.09723 37.7783922604051 -122.477991095219 (37.7783922604051, -122.477991095219)
178605 242749 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 77 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6001068.1061 2105939.1101900004 37.762567414863604 -122.43945789317499 (37.7625674148636, -122.439457893175)
178294 137036 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 128 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008091.14561 2112874.2674 37.7820069075434 -122.415658735479 (37.7820069075434, -122.415658735479)
178101 242420 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 287 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6005472.13068 2102064.63416 37.7521786642319 -122.42395042359101 (37.7521786642319, -122.423950423591)
178006 242444 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 209 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6004775.72746 2102364.1571 37.7529617434884 -122.426380018538 (37.7529617434884, -122.426380018538)
177758 180558 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 391 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6002652.4584800005 2091031.88145 37.7217256708875 -122.432913149844 (37.7217256708875, -122.432913149844)
177693 242439 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 229 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004390.15569 2099542.0601 37.7451911171707 -122.427512363901 (37.7451911171707, -122.427512363901)
177660 136991 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2423 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6000225.01908 2119533.2007299997 37.799845279595 -122.443350290299 (37.799845279595, -122.443350290299)
177606 180528 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 403 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6002884.7745199995 2090891.4425599999 37.7213532310447 -122.43210007098301 (37.7213532310447, -122.432100070983)
177354 242665 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1110 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003796.20784 2101754.26295 37.7512316988054 -122.42972388675899 (37.7512316988054, -122.429723886759)
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)
176966 141800 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1491 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6003793.7912 2113158.171 37.7825439326613 -122.430545874753 (37.7825439326613, -122.430545874753)
176942 51159 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1801 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/2004 12:00:00 AM 4   Permit Number 47564 6000498.9523 2114920.078 37.7871944727635 -122.44207106941002 (37.7871944727635, -122.44207106941)
176925 180548 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Persia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6002299.71139 2091209.35662 37.722192964028295 -122.434145183247 (37.7221929640283, -122.434145183247)
176924 138050 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1800 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6003471.3179 2114983.7695 37.78753829309029 -122.431791881618 (37.7875382930903, -122.431791881618)
176784 198471 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 704 18th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6015348.95336 2105815.2595900004 37.7630297401524 -122.390056547668 (37.7630297401524, -122.390056547668)
176776 105953 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 54 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/10/2014 12:00:00 AM 4   Permit Number 771133 5994277.8794 2115232.96253 37.7876970801078 -122.463617190077 (37.7876970801078, -122.463617190077)
176688 136995 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2311 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6003187.89855 2116665.35815 37.7921394368434 -122.43289263540301 (37.7921394368434, -122.432892635403)
176640 242645 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 3226 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008172.83241 2101552.12353 37.7509235272008 -122.41457468818899 (37.7509235272008, -122.414574688189)
176552 198683 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 145 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6009066.22564 2110952.30823 37.7767844274995 -122.412149517004 (37.7767844274995, -122.412149517004)
176276 183730 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2259 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5985737.4508 2099845.7715 37.7449523648453 -122.492031672537 (37.7449523648453, -122.492031672537)
176187 242545 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2460 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008186.74637 2104114.44399 37.75795985976529 -122.41470788497699 (37.7579598597653, -122.414707884977)

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