Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1178 | 1178 | 251465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) | ||||
| 9736 | 9736 | 173668 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014587.0 | 2096103.0 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | ||||
| 10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 10167 | 10167 | 110034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008245.7 | 2102789.4 | 37.754324902547204 | -122.414410241803 | (37.7543249025472, -122.414410241803) | |||||
| 10371 | 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 | |||||||||
| 17037 | 17037 | 54753 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4140-4142 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | Permit Number 10601 | 6002268.53854801 | 2101815.27696084 | 37.7513126050411 | -122.435011090977 | (37.7513126050411, -122.435011090977) | |||
| 19273 | 19273 | 48943 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901001 | (37.7524811515419, -122.40536498901) | ||
| 19559 | 19559 | 106645 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.75741007891521 | -122.437366369677 | (37.7574100789152, -122.437366369677) | |||
| 20397 | 20397 | 117536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 601 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002803.0 | 2108833.0 | 37.7706119122875 | -122.433664364997 | (37.7706119122875, -122.433664364997) | ||||
| 22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 51546 | 51546 | 49734 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 52918 | 52918 | 41547 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | |||
| 66017 | 66017 | 52720 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 710@ 20th ST Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2006 12:00:00 AM | Permit Number 48773 | 6002386.64959974 | 2104032.25895211 | 37.757406613771 | -122.43476116987699 | (37.757406613771, -122.434761169877) | |||
| 78368 | 78368 | 55226 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1973 12:00:00 AM | 3x3 | Permit Number 51714 | 6015214.86332087 | 2104389.48828919 | 37.7591074416555 | -122.390420697382 | (37.7591074416555, -122.390420697382) | ||
| 79538 | 79538 | 52664 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1328C. CHAVEZ Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50454 | 6003228.63897895 | 2100503.21297012 | 37.747764453898604 | -122.431597294154 | (37.7477644538986, -122.431597294154) | ||
| 80552 | 80552 | 46874 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.793556898770795 | -122.416132380604 | (37.7935568987708, -122.416132380604) | ||
| 81725 | 81725 | 87967 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51002 | 6000425.8 | 2112036.7 | 37.779273289788605 | -122.442117107328 | (37.7792732897886, -122.442117107328) | ||
| 82543 | 82543 | 107991 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 83623 | 83623 | 33935 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1932 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1997 12:00:00 AM | Permit Number 43529 | 6003424.24641356 | 2115332.27843331 | 37.7884925418667 | -122.43197963503201 | (37.7884925418667, -122.431979635032) | |||
| 83953 | 83953 | 50808 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 499 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2006 12:00:00 AM | Permit Number 47332 | 6008981.38895406 | 2105919.05287132 | 37.762959519157704 | -122.412087198232 | (37.7629595191577, -122.412087198232) | ||
| 84600 | 84600 | 114012 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 952 CAPP ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6007364.0 | 2101732.0 | 37.7513719527851 | -122.417384460989 | (37.7513719527851, -122.417384460989) | ||||
| 84660 | 84660 | 64129 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 662 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52075 | 6002246.83688253 | 2098888.05007266 | 37.7432738978208 | -122.43487682109199 | (37.7432738978208, -122.434876821092) | ||
| 85923 | 85923 | 53738 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 660-662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1972 12:00:00 AM | 4x4 | Permit Number 9418 | 6002127.0 | 2102089.0 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | ||
| 87420 | 87420 | 51550 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1247 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2005 12:00:00 AM | Permit Number 47849 | 5999742.39026173 | 2108428.18336747 | 37.7693262500826 | -122.444221920277 | (37.7693262500826, -122.444221920277) | |||
| 87640 | 87640 | 54877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 317 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1972 12:00:00 AM | 4x3 | Permit Number 10739 | 6005042.77490786 | 2109859.41873684 | 37.7735570424684 | -122.425990029724 | (37.7735570424684, -122.425990029724) | ||
| 88397 | 88397 | 48676 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | ||
| 88823 | 88823 | 45650 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 89302 | 89302 | 31777 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.74110093693479 | -122.47907928432699 | (37.7411009369348, -122.479079284327) | ||
| 91822 | 91822 | 44116 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 92481 | 92481 | 119675 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 92819 | 92819 | 120895 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005798.0 | 2107491.0 | 37.7670965853784 | -122.42320920294901 | (37.7670965853784, -122.423209202949) | ||||
| 92898 | 92898 | 47527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 93203 | 93203 | 50430 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 53REVISED Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2004 12:00:00 AM | Permit Number 47083 | 5998656.22086914 | 2105364.79387751 | 37.76085292760639 | -122.447758347691 | (37.7608529276064, -122.447758347691) | ||
| 94082 | 94082 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 2620 Buchanan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6003626.0 | 2117322.0 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | ||||
| 96105 | 96105 | 92521 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005.0 | 2109688.0 | 37.773309499001996 | -122.412271934387 | (37.773309499002, -122.412271934387) | ||
| 97154 | 97154 | 103275 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2800X Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | ||||
| 97275 | 97275 | 34988 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47856 | 6004110.40789501 | 2102908.72400582 | 37.754419364925205 | -122.428719637491 | (37.7544193649252, -122.428719637491) | |||
| 97310 | 97310 | 108480 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 97468 | 97468 | 52332 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.45929215094101 | (37.7353714395789, -122.459292150941) | ||||
| 98502 | 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) | |||
| 100335 | 100335 | 87288 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
| 101334 | 101334 | 86696 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 248 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2007 12:00:00 AM | Permit Number 49695 | 6006131.0 | 2101708.4 | 37.7512377023769 | -122.42164664917601 | (37.7512377023769, -122.421646649176) | |||
| 101498 | 101498 | 36930 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45859 | 6001519.66406839 | 2103540.62826183 | 37.756007454894096 | -122.437724334797 | (37.7560074548941, -122.437724334797) | ||
| 101965 | 101965 | 117577 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701x CALIFORNIA ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6010911.0 | 2116555.0 | 37.79227143324471 | -122.406162679671 | (37.7922714332447, -122.406162679671) | ||||
| 102960 | 102960 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 101X Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | |||||
| 103236 | 103236 | 99187 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 198X Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000112.3 | 2105690.3 | 37.761829801242 | -122.442745803115 | (37.761829801242, -122.442745803115) | ||||
| 103372 | 103372 | 81863 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.729301806319704 | -122.459920577502 | (37.7293018063197, -122.459920577502) | ||
| 103389 | 103389 | 119708 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 104223 | 104223 | 46210 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3720 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 44526 | 6003610.24375185 | 2103058.68100506 | 37.7548027913083 | -122.43046003253201 | (37.7548027913083, -122.430460032532) | |||
| 104545 | 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) | |||
| 107430 | 107430 | 40378 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 211 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | Permit Number 41491 | 6005458.18007856 | 2102476.17721451 | 37.7533078785176 | -122.424027930453 | (37.7533078785176, -122.424027930453) | |||
| 108144 | 108144 | 100077 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 260 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005310.0 | 2109942.0 | 37.7737988894613 | -122.42507153447501 | (37.7737988894613, -122.425071534475) | ||||
| 108477 | 108477 | 45798 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.44386708589701 | (37.7469614974882, -122.443867085897) | |||
| 109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 110663 | 110663 | 43563 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 511 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | ||
| 111376 | 111376 | 43394 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 625 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43137 | 6002354.2327444 | 2102058.9743147 | 37.751986605483395 | -122.434732175811 | (37.7519866054834, -122.434732175811) | ||
| 111950 | 111950 | 114306 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997219.0 | 2107398.0 | 37.7663533458689 | -122.45287579158399 | (37.7663533458689, -122.452875791584) | ||||
| 112256 | 112256 | 63592 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 294 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1987 12:00:00 AM | 3x3 | Permit Number 24223 | 6005148.0 | 2109920.0 | 37.773729330252706 | -122.425630352746 | (37.7737293302527, -122.425630352746) | ||
| 113040 | 113040 | 115484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1924 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012266.0 | 2104770.0 | 37.7599882208521 | -122.400646065117 | (37.7599882208521, -122.400646065117) | ||||
| 113509 | 113509 | 108869 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2360 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008129.0 | 2104684.1 | 37.759520760062706 | -122.41494791534299 | (37.7595207600627, -122.414947915343) | ||||
| 113790 | 113790 | 44268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 113792 | 113792 | 97832 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 114560 | 114560 | 50047 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46778 | 6002356.09000511 | 2104575.82706483 | 37.7588973859125 | -122.434905729534 | (37.7588973859125, -122.434905729534) | |||
| 115214 | 115214 | 48645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | ||
| 115403 | 115403 | 108134 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2055 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | ||||
| 117959 | 117959 | 52081 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.763738089155105 | -122.448274099423 | (37.7637380891551, -122.448274099423) | |||
| 118280 | 118280 | 107830 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999377.0 | 2107392.0 | 37.7664602988917 | -122.44541126750099 | (37.7664602988917, -122.445411267501) | |||||
| 118660 | 118660 | 82639 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.41622669003401 | (37.7626615773847, -122.416226690034) | ||
| 118928 | 118928 | 32532 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 120457 | 120457 | 35492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | ||
| 120690 | 120690 | 110630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991857.0 | 2101850.0 | 37.7508112705894 | -122.47101756601101 | (37.7508112705894, -122.471017566011) | |||||
| 121291 | 121291 | 47711 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.73697948454021 | -122.435360375218 | (37.7369794845402, -122.435360375218) | ||
| 121453 | 121453 | 40844 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41772 | 6003136.41051744 | 2107916.36050667 | 37.7681139569619 | -122.432445614329 | (37.7681139569619, -122.432445614329) | ||||
| 121897 | 121897 | 43393 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | ||
| 122930 | 122930 | 119817 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 124335 | 124335 | 55859 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 206 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2011 12:00:00 AM | 3x3 | Permit Number 56866 | 6005405.07087572 | 2102495.68659096 | 37.753358448125795 | -122.42421298063101 | (37.7533584481258, -122.424212980631) | ||
| 124491 | 124491 | 50045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | |
| 124709 | 124709 | 46505 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 125241 | 125241 | 112386 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2200 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999398.0 | 2116386.0 | 37.7911567075357 | -122.445985588475 | (37.7911567075357, -122.445985588475) | ||||
| 126618 | 126618 | 110786 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 410 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012080.0 | 2118442.0 | 37.7975180016372 | -122.402250623365 | (37.7975180016372, -122.402250623365) | ||||
| 127445 | 127445 | 66565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702438996 | -122.426754065425 | (37.725220702439, -122.426754065425) | ||
| 127974 | 127974 | 109434 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 7 DANVERS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999816.1 | 2105451.8 | 37.7611580492101 | -122.443753102957 | (37.7611580492101, -122.443753102957) | ||||
| 128211 | 128211 | 41906 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.43245531412902 | (37.7682150777502, -122.432455314129) | ||
| 128433 | 128433 | 97271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3x3 | Permit Number 768129 | 5999886.0 | 2116055.0 | 37.790275722262 | -122.444273332996 | (37.790275722262, -122.444273332996) | ||
| 139941 | 139941 | 43412 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 854 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51843 | 6003073.74768147 | 2103234.41761238 | 37.7552549166143 | -122.43232793300301 | (37.7552549166143, -122.432327933003) | ||
| 139998 | 139998 | 38953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.41364913267701 | (37.747044527767, -122.413649132677) | |||
| 140165 | 140165 | 63730 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | |
| 141055 | 141055 | 57535 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1976 12:00:00 AM | 3x3 | Permit Number 16394 | 6007841.081538401 | 2104745.28982278 | 37.7596725902927 | -122.41594801607 | (37.7596725902927, -122.41594801607) | ||
| 142355 | 142355 | 52726 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 169 ROOSEVELT Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | Permit Number 48781 | 6001418.20285712 | 2107376.9010813 | 37.76653515331179 | -122.438350049909 | (37.7665351533118, -122.438350049909) | |||
| 142478 | 142478 | 109070 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3027 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006619.6 | 2106627.5 | 37.7647719501604 | -122.420306113631 | (37.7647719501604, -122.420306113631) | ||||
| 143300 | 143300 | 49790 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2862 & YORK 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46574 | 6010228.54978873 | 2101669.78710325 | 37.7513618837191 | -122.40747408248001 | (37.7513618837191, -122.40747408248) | |||
| 144361 | 144361 | 43363 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.751161655763894 | -122.435122856595 | (37.7511616557639, -122.435122856595) | ||
| 144802 | 144802 | 46912 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 145818 | 145818 | 87304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 146012 | 146012 | 119781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 146217 | 146217 | 103270 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 350 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004879.0 | 2109882.0 | 37.773609787873895 | -122.426558160091 | (37.7736097878739, -122.426558160091) |
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");