Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188652 | 188652 | 32989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.3325900002 | 37.784324082736795 | -122.398422883105 | (37.7843240827368, -122.398422883105) | |
| 185553 | 185553 | 53481 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 8 | Permit Number 6390 | 6002979.07126 | 2117470.0427 | 37.794337047177294 | -122.433672716337 | (37.7943370471773, -122.433672716337) | ||
| 181708 | 181708 | 33124 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 12 | 6x6 | Permit Number 37358 | 6001499.40758 | 2119065.9057400003 | 37.7986348002003 | -122.438906933417 | (37.7986348002003, -122.438906933417) |
| 180765 | 180765 | 88994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 680 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51742 | 6013026.737980001 | 2113549.67814 | 37.784137636178 | -122.39863114183201 | (37.784137636178, -122.398631141832) | |
| 179887 | 179887 | 98993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1919 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768862 | 6003810.0 | 2118645.0 | 37.7976102909597 | -122.430881499482 | (37.7976102909597, -122.430881499482) | |
| 176942 | 176942 | 51159 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 4 | Permit Number 47564 | 6000498.9523 | 2114920.078 | 37.7871944727635 | -122.44207106941002 | (37.7871944727635, -122.44207106941) | ||
| 176776 | 176776 | 105953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | ||
| 175570 | 175570 | 180543 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 790 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 15 | Width 3ft | 6003544.6260400005 | 2090426.4873900001 | 37.720113955375794 | -122.42978600294799 | (37.7201139553758, -122.429786002948) | ||
| 175396 | 175396 | 55984 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1260 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1974 12:00:00 AM | 8 | Permit Number 12058 | 6008765.405 | 2116672.96891 | 37.7924751016038 | -122.41359485523998 | (37.7924751016038, -122.41359485524) | ||
| 174653 | 174653 | 64959 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 12 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1989 12:00:00 AM | 11 | Permit Number 25993 | 6001806.8392 | 2121193.6655099997 | 37.804494553342096 | -122.437995616222 | (37.8044945533421, -122.437995616222) | ||
| 174601 | 174601 | 31036 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.737554295604895 | -122.41810281760901 | (37.7375542956049, -122.418102817609) | ||
| 173944 | 173944 | 102277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 316 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 1 | 3x3 | Permit Number 776676 | 5998600.56179 | 2115376.04421 | 37.7883380681833 | -122.448671915192 | (37.7883380681833, -122.448671915192) | |
| 172702 | 172702 | 36148 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 7 | Permit Number 39234 | 6010838.36126 | 2106450.88886 | 37.764523836941294 | -122.40570200024099 | (37.7645238369413, -122.405702000241) | |
| 172287 | 172287 | 56515 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17376 | 6008990.48315 | 2116704.87455 | 37.7925753427324 | -122.412818332001 | (37.7925753427324, -122.412818332001) | ||
| 172012 | 172012 | 49872 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49768 | 6003420.3009 | 2115360.353 | 37.7885694038243 | -122.431995291423 | (37.7885694038243, -122.431995291423) | |
| 168860 | 168860 | 97843 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6015209.9181699995 | 2104379.39414 | 37.7590794509666 | -122.39043709491399 | (37.7590794509666, -122.390437094914) | ||||
| 167125 | 167125 | 97272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768129 | 5999961.63318 | 2116061.04996 | 37.790296648615495 | -122.444012083414 | (37.7902966486155, -122.444012083414) | |
| 166749 | 166749 | 81876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1209 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52375 | 6013966.08986 | 2105691.70822 | 37.762613702073004 | -122.394830783137 | (37.762613702073, -122.394830783137) | |
| 166094 | 166094 | 32995 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.2659299998 | 37.7844388182424 | -122.39828029921499 | (37.7844388182424, -122.398280299215) | |
| 165554 | 165554 | 30358 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 657 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 14 | Permit Number 14187 | 6013035.79545 | 2104016.54587 | 37.7579623041386 | -122.39793084155399 | (37.7579623041386, -122.397930841554) | ||
| 164022 | 164022 | 97842 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6015209.65715 | 2104398.1625200002 | 37.7591309704315 | -122.390439309039 | (37.7591309704315, -122.390439309039) | ||||
| 162741 | 162741 | 33151 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.741869787152204 | -122.487350256926 | (37.7418697871522, -122.487350256926) | |
| 162592 | 162592 | 48353 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2085 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 45762 | 6001879.23455 | 2119763.86307 | 37.8005728104329 | -122.437642626012 | (37.8005728104329, -122.437642626012) | |||
| 160318 | 160318 | 66277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2750 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | 6 | Permit No. 49271 | 5999752.728130001 | 2118820.1000599996 | 37.797860351718704 | -122.444933297631 | (37.7978603517187, -122.444933297631) | ||
| 160202 | 160202 | 88993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 680 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51742 | 6013040.85329 | 2113568.29514 | 37.784189540547295 | -122.398583614443 | (37.7841895405473, -122.398583614443) | |
| 160114 | 160114 | 55641 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 450 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/1973 12:00:00 AM | 12 | Permit Number 11624 | 6011869.72365 | 2118415.97295 | 37.7974347979269 | -122.40297640786001 | (37.7974347979269, -122.40297640786) | ||
| 160075 | 160075 | 31075 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 7 | Permit Number 34816 | 6005979.98097 | 2107292.47987 | 37.76656176455071 | -122.422565649286 | (37.7665617645507, -122.422565649286) | |
| 159494 | 159494 | 53398 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1972 12:00:00 AM | 9 | Permit Number 9833 | 6008515.21769 | 2116802.84208 | 37.7928176497632 | -122.414469707612 | (37.7928176497632, -122.414469707612) | ||
| 159272 | 159272 | 69124 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.42567920498301 | (37.7760283687547, -122.425679204983) | |
| 159168 | 159168 | 36885 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2914 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39542 | 6000200.3438800005 | 2116470.40485 | 37.79143424424 | -122.443215577236 | (37.79143424424, -122.443215577236) | |
| 156401 | 156401 | 43942 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3885 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 11 | Permit Number 43530 | 5995636.78457 | 2115791.89347 | 37.789309959494204 | -122.45895615544701 | (37.7893099594942, -122.458956155447) | ||
| 156334 | 156334 | 30288 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1365 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 14 | Permit Number 132 | 6008888.5982099995 | 2117621.05322 | 37.795085225551 | -122.413235675009 | (37.795085225551, -122.413235675009) | ||
| 153324 | 153324 | 67600 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 555 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31170 | 6013571.5238 | 2104494.52261 | 37.7593045458768 | -122.39611154992599 | (37.7593045458768, -122.396111549926) | |
| 151264 | 151264 | 44079 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 172 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2000 12:00:00 AM | 4 | Permit Number 43600 | 6010499.79752 | 2111352.59578 | 37.777963856872795 | -122.40721856300699 | (37.7779638568728, -122.407218563007) | ||
| 151074 | 151074 | 61321 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1493 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | 2 | Permit Number 21224 | 6011782.729590001 | 2101393.64443 | 37.750690525464 | -122.40208010571999 | (37.750690525464, -122.40208010572) | |
| 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) | |
| 149794 | 149794 | 103417 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6015408.53922 | 2105754.52257 | 37.7628662739736 | -122.38984621603201 | (37.7628662739736, -122.389846216032) | |||
| 149318 | 149318 | 36939 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.78649992768511 | -122.461372345087 | (37.7864999276851, -122.461372345087) | |
| 148743 | 148743 | 62667 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 438 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50321 | 5998175.4126699995 | 2114969.52536 | 37.7871975551779 | -122.45011354281 | (37.7871975551779, -122.45011354281) | |
| 147738 | 147738 | 33318 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.0081599997 | 37.7974394114518 | -122.42705551819401 | (37.7974394114518, -122.427055518194) | |
| 146841 | 146841 | 83229 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | |
| 146705 | 146705 | 91339 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 829 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52060 | 6012087.196 | 2112565.923 | 37.7813840839391 | -122.401812466037 | (37.7813840839391, -122.401812466037) | |
| 146461 | 146461 | 31614 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2146 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35135 | 6001571.0697 | 2119772.3198 | 37.800578504065896 | -122.43870960598998 | (37.8005785040659, -122.43870960599) | ||
| 146136 | 146136 | 37289 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) | |||
| 145979 | 145979 | 100624 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 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) | |||
| 145764 | 145764 | 2632 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1884 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004471.16425 | 2115036.06465 | 37.7877385090069 | -122.42833634117399 | (37.7877385090069, -122.428336341174) | |||
| 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) | ||
| 144741 | 144741 | 46506 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 4 | 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) | |||
| 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) | ||
| 144247 | 144247 | 113083 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | ||||
| 143650 | 143650 | 97837 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | ||||
| 143524 | 143524 | 88555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 609 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51500 | 5990920.3 | 2111212.9 | 37.7764650666065 | -122.47494009298401 | (37.7764650666065, -122.474940092984) | |||
| 143378 | 143378 | 23638 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 VIRGINIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 12 | 4x4 | Permit Number 776560 | 6006594.0 | 2098480.0 | 37.7423993441016 | -122.41981648533199 | (37.7423993441016, -122.419816485332) | |
| 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) | |||
| 142917 | 142917 | 35675 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 2 | 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) | |
| 142590 | 142590 | 17612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 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) | |||
| 142180 | 142180 | 102452 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 546 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 16394 | 6007849.0 | 2104746.0 | 37.7596749854601 | -122.41592068026199 | (37.7596749854601, -122.415920680262) | |||
| 142125 | 142125 | 37290 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 12 | 3x3 | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) |
| 141852 | 141852 | 97849 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 141515 | 141515 | 68693 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 600 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 12 | 3x3 | Permit Number 32603 | 5993650.82821 | 2113525.7859099996 | 37.7829734883164 | -122.46566257132 | (37.7829734883164, -122.46566257132) |
| 141057 | 141057 | 17493 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6001898.43212 | 2091454.2052 | 37.722842480127 | -122.435549814469 | (37.722842480127, -122.435549814469) | |||
| 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) | ||
| 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) | |||
| 140198 | 140198 | 97835 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 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) | |
| 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) | |||
| 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) | ||
| 139746 | 139746 | 11878 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 139417 | 139417 | 23644 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 197 Virginia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 8 | 3X3 | 6006643.75963 | 2098486.4882900002 | 37.7424199625796 | -122.41964489142 | (37.7424199625796, -122.41964489142) | ||
| 139312 | 139312 | 97844 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 138839 | 138839 | 35676 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 1 | 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) | |
| 136282 | 136282 | 242614 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Virginia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 8 | Width 3ft | 6006648.68245 | 2098490.72536 | 37.7424318739254 | -122.419628170307 | (37.7424318739254, -122.419628170307) | ||
| 135957 | 135957 | 51918 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.924319999 | 2091688.24542 | 37.72335998726889 | -122.443166369055 | (37.7233599872689, -122.443166369055) | |
| 134625 | 134625 | 54984 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 609 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 5 | Permit Number 10862 | 5990934.1509 | 2111213.50842 | 37.7764675398398 | -122.474892223692 | (37.7764675398398, -122.474892223692) | ||
| 133033 | 133033 | 34578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3300 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2012 12:00:00 AM | 3 | Permit Number 769651 | 5998982.19825 | 2115648.46298 | 37.789107873481 | -122.44737113578998 | (37.789107873481, -122.44737113579) | ||
| 132643 | 132643 | 45690 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1932 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2001 12:00:00 AM | 7 | Permit Number 44375 | 5999944.86656 | 2121277.56514 | 37.8046188567315 | -122.44444515193999 | (37.8046188567315, -122.44444515194) | ||
| 132509 | 132509 | 46780 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.43357175935301 | (37.7283552769641, -122.433571759353) | |
| 132309 | 132309 | 89024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2724 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51769 | 6000900.18903 | 2116892.91159 | 37.7926342186313 | -122.440824453501 | (37.7926342186313, -122.440824453501) | |
| 130427 | 130427 | 34703 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 591 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50359 | 5981606.7893900005 | 2111740.24587 | 37.777368864087 | -122.50719674082501 | (37.777368864087, -122.507196740825) | |
| 129283 | 129283 | 52300 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 264 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53169 | 6001736.20846819 | 2104306.03679934 | 37.758121392277005 | -122.437030249981 | (37.758121392277, -122.437030249981) | |
| 128748 | 128748 | 32533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 127611 | 127611 | 33762 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1800X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37814 | 6003491.84820405 | 2114902.28438826 | 37.7873157193536 | -122.431715030855 | (37.7873157193536, -122.431715030855) | |
| 127526 | 127526 | 14869 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1399 McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | ||
| 127512 | 127512 | 93041 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4076 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001828.0 | 2105877.0 | 37.762440092603505 | -122.43682525386002 | (37.7624400926035, -122.43682525386) | |||
| 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) | ||
| 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) | |||
| 126297 | 126297 | 39478 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2856 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 777203 | 5999897.32915775 | 2117456.37972289 | 37.7941241886563 | -122.44433488583 | (37.7941241886563, -122.44433488583) | |||
| 125787 | 125787 | 45653 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 4 | 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) | |||
| 125148 | 125148 | 44267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 2 | 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |
| 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) | ||
| 124318 | 124318 | 107994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 124040 | 124040 | 17622 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004279.363726401 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | |||
| 123733 | 123733 | 68197 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 417 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 7 | Permit Number 31977 | 5998129.56207 | 2114980.61061 | 37.787225368503606 | -122.450272974611 | (37.7872253685036, -122.450272974611) |
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");