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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
| 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) | |||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 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) | |||
| 10917 | 10917 | 17498 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.43487036238501 | (37.72266164479, -122.434870362385) | |||
| 10999 | 10999 | 17515 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002425.76888 | 2091174.41595 | 37.7221041784351 | -122.433706937351 | (37.7221041784351, -122.433706937351) | |||
| 11525 | 11525 | 17537 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/1999 12:00:00 AM | 3 | 3x3 | 6002961.1307 | 2090844.1069599998 | 37.72122758676971 | -122.431832751099 | (37.7212275867697, -122.431832751099) | ||
| 11682 | 11682 | 17519 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6002513.47081 | 2091072.78557 | 37.721830100172504 | -122.433396514735 | (37.7218301001725, -122.433396514735) | |||
| 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) | |||
| 12693 | 12693 | 17579 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003783.82433 | 2090321.42028 | 37.7198390065544 | -122.428951688396 | (37.7198390065544, -122.428951688396) | |||
| 13491 | 13491 | 85780 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.41169762032699 | (37.7735740897245, -122.411697620327) | ||
| 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) | |||
| 15203 | 15203 | 91033 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.777476921213605 | -122.40675930128401 | (37.7774769212136, -122.406759301284) | ||
| 15259 | 15259 | 85857 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008243.2994 | 2108951.1128 | 37.771243409160206 | -122.414854606958 | (37.7712434091602, -122.414854606958) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 16758 | 16758 | 85768 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008662.6876 | 2109384.932 | 37.772458131185104 | -122.41343460643999 | (37.7724581311851, -122.41343460644) | ||
| 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) | |||
| 17755 | 17755 | 7599 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6008391.53469 | 2100462.67214 | 37.747944422200796 | -122.413741340393 | (37.7479444222008, -122.413741340393) | |||
| 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) | ||
| 21400 | 21400 | 14591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/09/2011 12:00:00 AM | 3 | 3x3 | 5999412.7083 | 2108624.4902 | 37.7698464448905 | -122.445376387082 | (37.7698464448905, -122.445376387082) | ||
| 22097 | 22097 | 7610 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3201X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008468.12704 | 2100135.3338200003 | 37.74704992500789 | -122.413453339725 | (37.7470499250079, -122.413453339725) | |||
| 22223 | 22223 | 7630 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008486.33548 | 2099778.1775 | 37.7460702755308 | -122.41336512251499 | (37.7460702755308, -122.413365122515) | |||
| 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) | |||
| 46120 | 46120 | 200598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.732956277793896 | -122.385302911931 | (37.7329562777939, -122.385302911931) | |||
| 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) | |||
| 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) | |
| 62806 | 62806 | 244235 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | |||
| 62865 | 62865 | 244423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |||
| 79662 | 79662 | 17920 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2397X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002488.019783099 | 2115056.9941341 | 37.787683560918495 | -122.435199131446 | (37.7876835609185, -122.435199131446) | |||
| 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) | |
| 81956 | 81956 | 17571 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 749X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003526.33065 | 2090483.75414 | 37.7202701612065 | -122.429853326536 | (37.7202701612065, -122.429853326536) | |||
| 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) | |||
| 86746 | 86746 | 14840 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1315X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.43366409969101 | (37.7783201948721, -122.433664099691) | ||
| 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) | |||
| 88748 | 88748 | 13323 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 435X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002777.3722738 | 2090962.3160143998 | 37.72154174394979 | -122.432476389775 | (37.7215417439498, -122.432476389775) | |||
| 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) | ||
| 89115 | 89115 | 16420 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016497.0965599995 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | |||
| 89129 | 89129 | 17601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 901X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x3 | 6003845.6513541 | 2090290.9535450002 | 37.719758851010496 | -122.42873580329399 | (37.7197588510105, -122.428735803294) | |||
| 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) | |||
| 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) |
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");