Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 6092 | 6092 | 46303 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 9589 | 9589 | 9765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.778263187688296 | -122.440226567073 | (37.7782631876883, -122.440226567073) | ||
| 10288 | 10288 | 17565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.720429991522295 | -122.43015957951599 | (37.7204299915223, -122.430159579516) | |||
| 12237 | 12237 | 17610 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004083.7901099995 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | |||
| 15589 | 15589 | 30641 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 80x 13th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34584 | 6008099.08967 | 2108395.87431 | 37.7697107505788 | -122.41531412336201 | (37.7697107505788, -122.415314123362) | |
| 16705 | 16705 | 85783 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1265 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009394.3077 | 2109993.0802 | 37.7741690156078 | -122.41094681212299 | (37.7741690156078, -122.410946812123) | ||
| 17137 | 17137 | 608 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008346.158869999 | 2102213.06871 | 37.7527480699909 | -122.41402205928101 | (37.7527480699909, -122.414022059281) | |||
| 17976 | 17976 | 46914 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 3 | 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) | ||
| 19287 | 19287 | 7488 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008316.60225 | 2102810.93946 | 37.7543880278024 | -122.41416656683501 | (37.7543880278024, -122.414166566835) | |||
| 19718 | 19718 | 23643 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6006665.3047400005 | 2098482.5639400003 | 37.742410400808296 | -122.419570116381 | (37.7424104008083, -122.419570116381) | ||
| 62594 | 62594 | 30619 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.41516782897499 | (37.7703758225592, -122.415167828975) | |
| 66171 | 66171 | 31077 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.766563649504704 | -122.422496504935 | (37.7665636495047, -122.422496504935) | |
| 72202 | 72202 | 91162 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.347019999 | 2112584.78934 | 37.781157001421704 | -122.41902439967801 | (37.7811570014217, -122.419024399678) | |
| 81162 | 81162 | 89025 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2724 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774819 | 6000906.5 | 2116912.2 | 37.792687538981205 | -122.440804001611 | (37.7926875389812, -122.440804001611) | |
| 86647 | 86647 | 46504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 3 | 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) | |||
| 87124 | 87124 | 45652 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 3 | 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) | |||
| 88869 | 88869 | 32534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 3 | 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) | ||
| 92068 | 92068 | 22316 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
| 98911 | 98911 | 97270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3x3 | Permit Number 768129 | 5999976.0 | 2116041.4 | 37.7902435145098 | -122.443960962963 | (37.7902435145098, -122.443960962963) | ||
| 101361 | 101361 | 97834 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 102982 | 102982 | 44114 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 3 | 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) | |||
| 103257 | 103257 | 17810 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1900X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2012 12:00:00 AM | 4 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | ||
| 103920 | 103920 | 117152 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.72855094559029 | -122.389513905896 | (37.7285509455903, -122.389513905896) | |||
| 107376 | 107376 | 11877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 107595 | 107595 | 98272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | ||
| 108438 | 108438 | 35674 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 110800 | 110800 | 38063 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1805X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40255 | 6000940.99475203 | 2111717.60117276 | 37.77842647246 | -122.440311948792 | (37.77842647246, -122.440311948792) | |
| 112673 | 112673 | 103419 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015432.6 | 2105817.0 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | ||||
| 118411 | 118411 | 17613 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 119017 | 119017 | 36147 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | ||
| 120654 | 120654 | 102761 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.40821818771099 | (37.7785759102049, -122.408218187711) |
| 125021 | 125021 | 38383 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3815-3817 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769372 | 6003483.0 | 2105926.0 | 37.762668556023996 | -122.43110471906799 | (37.762668556024, -122.431104719068) | ||||
| 127319 | 127319 | 97269 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769192 | 5999973.8 | 2116027.1 | 37.79020412496 | -122.443967546887 | (37.79020412496, -122.443967546887) | |||
| 140480 | 140480 | 87306 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 3 | 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) | |||
| 150713 | 150713 | 32996 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.022469999 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | |
| 13792 | 13792 | 98860 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008529.07758 | 2110594.62185 | 37.7757721514991 | -122.41398236951099 | (37.7757721514991, -122.413982369511) | |||
| 14994 | 14994 | 98857 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008572.87311 | 2110548.2851 | 37.775647381359995 | -122.41382759079501 | (37.77564738136, -122.413827590795) | |||
| 16662 | 16662 | 105993 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6015232.0353 | 2104000.8036599997 | 37.758041149501096 | -122.39033415130501 | (37.7580411495011, -122.390334151305) | |||
| 24096 | 24096 | 242684 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 415 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002983.5288 | 2105821.24462 | 37.7623526073126 | -122.432824725778 | (37.7623526073126, -122.432824725778) | |||
| 24162 | 24162 | 215566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.735768007292705 | -122.463427186434 | (37.7357680072927, -122.463427186434) | |||
| 24594 | 24594 | 115551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.39019037219299 | (37.7585616474178, -122.390190372193) | ||
| 25498 | 25498 | 138314 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2400 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002354.5046 | 2115095.0933 | 37.7877805887944 | -122.435663794316 | (37.7877805887944, -122.435663794316) | |||
| 27071 | 27071 | 137049 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008515.90058 | 2116780.9457099997 | 37.7927575660663 | -122.414465794683 | (37.7927575660663, -122.414465794683) | |||
| 30655 | 30655 | 180517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004131.62894 | 2090104.3716099998 | 37.719262719168896 | -122.42773399285299 | (37.7192627191689, -122.427733992853) | |||
| 30762 | 30762 | 242600 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002217.824030001 | 2096159.0098299999 | 37.735778939431896 | -122.434782025597 | (37.7357789394319, -122.434782025597) | |||
| 32732 | 32732 | 242571 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008126.47482 | 2106341.38137 | 37.7640711307933 | -122.415073955818 | (37.7640711307933, -122.415073955818) | |||
| 33682 | 33682 | 136962 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001208.87225 | 2118332.01325 | 37.7966031903358 | -122.43985962844299 | (37.7966031903358, -122.439859628443) | |||
| 33979 | 33979 | 198465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 707 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6015348.3409 | 2105766.19544 | 37.7628949866348 | -122.39005523827801 | (37.7628949866348, -122.390055238278) | |||
| 34072 | 34072 | 137057 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011992.2179 | 2118432.8922200003 | 37.797488093548104 | -122.402553733674 | (37.7974880935481, -122.402553733674) | |||
| 34125 | 34125 | 137062 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 462 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011753.78546 | 2118398.85013 | 37.7973813080638 | -122.40337638132 | (37.7973813080638, -122.40337638132) | |||
| 34466 | 34466 | 242592 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4412 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000533.60664 | 2102299.6825200003 | 37.752544002129 | -122.44104541511999 | (37.752544002129, -122.44104541512) | |||
| 34703 | 34703 | 242647 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3000 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008809.14525 | 2102757.20392 | 37.754268135574705 | -122.41245942247299 | (37.7542681355747, -122.412459422473) | |||
| 36619 | 36619 | 215549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994024.47246 | 2096717.6403700002 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | |||
| 37220 | 37220 | 198494 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015476.06266 | 2104658.66701 | 37.759861034675104 | -122.389536136987 | (37.7598610346751, -122.389536136987) | |||
| 37702 | 37702 | 242417 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3652 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005352.57915 | 2101976.52488 | 37.7519299863868 | -122.424357585351 | (37.7519299863868, -122.424357585351) | |||
| 39339 | 39339 | 198561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014636.301940001 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | |||
| 39939 | 39939 | 201908 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.39464378978901 | (37.7284270698286, -122.394643789789) | |||
| 40052 | 40052 | 180530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 403 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6002817.9895 | 2090936.4052799998 | 37.721472902024004 | -122.432334137535 | (37.721472902024, -122.432334137535) | |||
| 40222 | 40222 | 121875 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 198 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5990257.12502 | 2114144.50591 | 37.784475988028 | -122.477448493001 | (37.784475988028, -122.477448493001) | |||
| 40331 | 40331 | 198670 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 194 Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010573.77225 | 2111256.57135 | 37.77770433593079 | -122.40695588722099 | (37.7777043359308, -122.406955887221) | |||
| 45108 | 45108 | 198475 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6015192.04095 | 2104775.13196 | 37.760165070275605 | -122.39052657564301 | (37.7601650702756, -122.390526575643) | |||
| 47795 | 47795 | 180536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010343.05054 | 2092296.39853 | 37.725630979562794 | -122.40641771941401 | (37.7256309795628, -122.406417719414) | |||
| 48110 | 48110 | 198677 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010377.80869 | 2111537.89689 | 37.778465822479795 | -122.407653636128 | (37.7784658224798, -122.407653636128) | |||
| 48689 | 48689 | 242679 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 381 Elizabeth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003962.28874 | 2102142.6447900003 | 37.752307507386796 | -122.429177250923 | (37.7523075073868, -122.429177250923) | |||
| 49733 | 49733 | 198455 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014981.91793 | 2106268.05786 | 37.7642526625648 | -122.39135766342699 | (37.7642526625648, -122.391357663427) | |||
| 53033 | 53033 | 198629 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015714.39108 | 2108739.8004900003 | 37.7710801545587 | -122.38899681088101 | (37.7710801545587, -122.388996810881) | ||||
| 55907 | 55907 | 137045 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.792555023435796 | -122.41299717838899 | (37.7925550234358, -122.412997178389) | |||
| 56640 | 56640 | 242492 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2507 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6008258.15624 | 2103821.5698 | 37.7571597059716 | -122.414440195483 | (37.7571597059716, -122.414440195483) | |||
| 56932 | 56932 | 215513 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993924.28661 | 2096292.23015 | 37.7356703813878 | -122.463465470563 | (37.7356703813878, -122.463465470563) | |||
| 58597 | 58597 | 198595 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1000 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013296.53525 | 2107120.49149 | 37.7664995737224 | -122.397246743447 | (37.7664995737224, -122.397246743447) | |||
| 58665 | 58665 | 242499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2618 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008244.84467 | 2103100.9830099996 | 37.7551803907701 | -122.414435245603 | (37.7551803907701, -122.414435245603) | |||
| 59191 | 59191 | 198504 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 785 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6011870.75445 | 2104712.89725 | 37.75980937761629 | -122.40200902239599 | (37.7598093776163, -122.402009022396) | |||
| 59830 | 59830 | 198583 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013760.46871 | 2107146.56354 | 37.766596979302705 | -122.39564389615299 | (37.7665969793027, -122.395643896153) | |||
| 61812 | 61812 | 198600 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013090.52825 | 2107110.01033 | 37.7664593236741 | -122.397958554166 | (37.7664593236741, -122.397958554166) | |||
| 63092 | 63092 | 242675 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3995 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003246.40491 | 2102411.67746 | 37.7530056556116 | -122.43167209619 | (37.7530056556116, -122.43167209619) | |||
| 63853 | 63853 | 198644 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6016180.118480001 | 2108766.38719 | 37.7711789603624 | -122.38738768448799 | (37.7711789603624, -122.387387684488) | ||||
| 64148 | 64148 | 180549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002285.837859999 | 2091218.55546 | 37.722217434571796 | -122.43419379793 | (37.7222174345718, -122.43419379793) | |||
| 64596 | 64596 | 142236 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 689 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004695.4808 | 2110855.1353 | 37.77627140325 | -122.427262313822 | (37.77627140325, -122.427262313822) | |||
| 64644 | 64644 | 137021 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003013.18529 | 2117480.30225 | 37.7943671528679 | -122.43355541147498 | (37.7943671528679, -122.433555411475) | |||
| 65813 | 65813 | 180520 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6003878.6160699995 | 2090266.0202 | 37.71969225516521 | -122.42862007955799 | (37.7196922551652, -122.428620079558) | |||
| 66715 | 66715 | 198435 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015582.58309 | 2106296.4914 | 37.7643640534737 | -122.389282101 | (37.7643640534737, -122.389282101) | |||
| 67203 | 67203 | 136960 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000577.855330001 | 2118280.57754 | 37.796426022096206 | -122.442039387228 | (37.7964260220962, -122.442039387228) | |||
| 68043 | 68043 | 137034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1756 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005175.40466 | 2117844.84093 | 37.7954905257115 | -122.426099835651 | (37.7954905257115, -122.426099835651) | |||
| 68583 | 68583 | 242378 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 39 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005393.3739 | 2103473.26085 | 37.756041979063795 | -122.424322955135 | (37.7560419790638, -122.424322955135) | |||
| 69043 | 69043 | 242514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2948 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008345.171569999 | 2101253.04618 | 37.7501120086795 | -122.413957566206 | (37.7501120086795, -122.413957566206) | |||
| 70239 | 70239 | 74649 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010746.42629 | 2106444.22464 | 37.76450039699821 | -122.406019510419 | (37.7645003969982, -122.406019510419) | ||
| 74354 | 74354 | 200792 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.735849808179296 | -122.389034132513 | (37.7358498081793, -122.389034132513) | |||
| 76771 | 76771 | 141891 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1335 EDDY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004124.0082 | 2112861.9655 | 37.7817493272221 | -122.42938233738998 | (37.7817493272221, -122.42938233739) | |||
| 94890 | 94890 | 108482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 102013 | 102013 | 101949 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 102037 | 102037 | 108135 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2055 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | ||||
| 106773 | 106773 | 141786 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1471 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003844.5104 | 2113167.1525 | 37.7825714667037 | -122.430371049321 | (37.7825714667037, -122.430371049321) | |||
| 117414 | 117414 | 72754 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 181 RUSS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1998 12:00:00 AM | 3 | 5x5 | 6010587.0 | 2111361.1 | 37.777992087388604 | -122.40691749681999 | (37.7779920873886, -122.40691749682) | ||
| 121798 | 121798 | 198688 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 165 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008649.71032 | 2110465.86433 | 37.775425388204496 | -122.413555960437 | (37.7754253882045, -122.413555960437) | |||
| 126904 | 126904 | 101710 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||
| 129205 | 129205 | 111106 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 199X Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002254.0 | 2096173.0 | 37.7358194070146 | -122.43465795136001 | (37.7358194070146, -122.43465795136) | |||
| 129975 | 129975 | 138586 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2702 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000914.7508 | 2114889.5525 | 37.78713434421321 | -122.440630309715 | (37.7871343442132, -122.440630309715) | |||
| 130420 | 130420 | 242655 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 502 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001805.86123 | 2102847.44693 | 37.7541204147416 | -122.436684955058 | (37.7541204147416, -122.436684955058) | |||
| 131414 | 131414 | 198575 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6014794.5907 | 2114154.82505 | 37.78589756536171 | -122.392557300594 | (37.7858975653617, -122.392557300594) |
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");