Data source: data.sfgov.org
This data as json, CSV (advanced)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 189004 | 189004 | 201909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.39459380727101 | (37.728396715017, -122.394593807271) | |||
| 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) | |||
| 188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | |||
| 188770 | 188770 | 215509 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 265 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994040.687530001 | 2096338.7929099998 | 37.7358049370452 | -122.46306640808201 | (37.7358049370452, -122.463066408082) | |||
| 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) | |||
| 188022 | 188022 | 198621 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015788.5708800005 | 2108619.95844 | 37.7707552061109 | -122.388731850804 | (37.7707552061109, -122.388731850804) | ||||
| 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) | |||
| 187415 | 187415 | 244374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.42401292788901 | (37.7735554657504, -122.424012927889) | |||
| 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) | |||
| 186972 | 186972 | 244255 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005643.2766 | 2110040.2561 | 37.7740874977816 | -122.423925664351 | (37.7740874977816, -122.423925664351) | |||
| 186900 | 186900 | 198660 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013952.391369999 | 2107385.9793599998 | 37.767265036187204 | -122.39499683484101 | (37.7672650361872, -122.394996834841) | |||
| 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) | |||
| 186702 | 186702 | 198650 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6016310.0808 | 2108775.16968 | 37.771210272057296 | -122.38693874834499 | (37.7712102720573, -122.386938748345) | ||||
| 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) | |||
| 186460 | 186460 | 198536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1782 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014278.07437 | 2096434.6477400002 | 37.7372131188949 | -122.393103980488 | (37.7372131188949, -122.393103980488) | |||
| 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) | |||
| 186182 | 186182 | 180540 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998917.8755 | 2091146.4939599999 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | |||
| 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) | |||
| 185967 | 185967 | 198527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014634.66691 | 2096168.3212099997 | 37.736501643630795 | -122.39185244975599 | (37.7365016436308, -122.391852449756) | |||
| 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) | |||
| 185782 | 185782 | 215556 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994083.61734 | 2096486.4471099998 | 37.736212831753896 | -122.46292869311701 | (37.7362128317539, -122.462928693117) | |||
| 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) | ||
| 185473 | 185473 | 242779 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.77169326466979 | -122.420703668659 | (37.7716932646698, -122.420703668659) | |||
| 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) | |||
| 184959 | 184959 | 215546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993989.2635699995 | 2097198.82691 | 37.738163414500605 | -122.463306588246 | (37.7381634145006, -122.463306588246) | |||
| 184934 | 184934 | 198580 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6014742.64135 | 2114209.62608 | 37.7860451513037 | -122.392740867522 | (37.7860451513037, -122.392740867522) | |||
| 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) | |||
| 184354 | 184354 | 242780 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 9ft | 6006179.77173 | 2109125.10938 | 37.7716049979898 | -122.422004807797 | (37.7716049979898, -122.422004807797) | |||
| 184309 | 184309 | 244362 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005532.1079 | 2110378.8544 | 37.7750109299929 | -122.42433430414499 | (37.7750109299929, -122.424334304145) | |||
| 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) | |||
| 183809 | 183809 | 198628 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015696.32506 | 2108739.9117 | 37.7710794584904 | -122.389059310163 | (37.7710794584904, -122.389059310163) | ||||
| 183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
| 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) | |||
| 183718 | 183718 | 246549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6005737.248 | 2109452.9268900002 | 37.77248013816789 | -122.423558835368 | (37.7724801381679, -122.423558835368) | |||
| 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) | |||
| 183346 | 183346 | 198622 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015766.21634 | 2108621.9300599997 | 37.7707593807704 | -122.388809313913 | (37.7707593807704, -122.388809313913) | ||||
| 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) | |||
| 182744 | 182744 | 242401 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004422.12829 | 2096026.22682 | 37.7355392485419 | -122.427151426394 | (37.7355392485419, -122.427151426394) | ||||
| 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) | |||
| 182574 | 182574 | 198654 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6014045.1024400005 | 2107292.39517 | 37.7670132295924 | -122.39466960392201 | (37.7670132295924, -122.394669603922) | |||
| 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) | |||
| 182189 | 182189 | 244315 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.42442816055599 | (37.7754801903482, -122.424428160556) | |||
| 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) | |||
| 181781 | 181781 | 198545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014347.46676 | 2096307.9182900002 | 37.736869000500995 | -122.392855193808 | (37.736869000501, -122.392855193808) | |||
| 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) | |||
| 181672 | 181672 | 198508 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 998 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6011865.97365 | 2103785.48158 | 37.757262632470606 | -122.401960360989 | (37.7572626324706, -122.401960360989) | |||
| 181522 | 181522 | 215506 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 255 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994105.35353 | 2096421.48762 | 37.7360357210632 | -122.46284883151199 | (37.7360357210632, -122.462848831512) | |||
| 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) | |||
| 181312 | 181312 | 246539 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | |||
| 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) | |||
| 181242 | 181242 | 215560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994063.02887 | 2096405.4928599999 | 37.7359893655189 | -122.462994003686 | (37.7359893655189, -122.462994003686) | |||
| 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) | |||
| 180569 | 180569 | 198489 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6015206.91645 | 2104475.31213 | 37.759342654666206 | -122.390454178415 | (37.7593426546662, -122.390454178415) | |||
| 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) | |||
| 180262 | 180262 | 215482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994118.54253 | 2097814.9092900003 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) |
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");