Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189066 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");