Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
20493 | 20493 | 31189 | Permitted Site 1 | :: 54 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
24313 | 24313 | 184893 | Undocumented 2 | :: 54 | 1786 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981952.8719 | 2102926.7078 | 37.753189803786896 | -122.505346142178 | (37.7531898037869, -122.505346142178) | |||
24732 | 24732 | 141579 | Undocumented 2 | :: 54 | 500 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000650.2876 | 2110740.0178 | 37.7757257205697 | -122.44124745176501 | (37.7757257205697, -122.441247451765) | |||
25062 | 25062 | 247418 | Undocumented 2 | :: 54 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.43443692499599 | (37.7743916070028, -122.434436924996) | |||
25460 | 25460 | 181596 | Undocumented 2 | :: 54 | 1683 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984674.4393 | 2103735.9717 | 37.7555715918184 | -122.495994253801 | (37.7555715918184, -122.495994253801) | |||
26700 | 26700 | 183825 | Undocumented 2 | :: 54 | 2233 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987596.9637 | 2100067.0354 | 37.745668416958 | -122.48561813299 | (37.745668416958, -122.48561813299) | |||
27363 | 27363 | 141421 | Undocumented 2 | :: 54 | 550 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004561.2684 | 2111044.0972 | 37.7767826552211 | -122.42774005835501 | (37.7767826552211, -122.427740058355) | |||
28027 | 28027 | 140087 | Undocumented 2 | :: 54 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001853.1286 | 2112643.6389 | 37.781021029267706 | -122.43722286326 | (37.7810210292677, -122.43722286326) | |||
28319 | 28319 | 139084 | Undocumented 2 | :: 54 | 2512 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000122.7854 | 2113741.6890000002 | 37.7839374779531 | -122.443287851631 | (37.7839374779531, -122.443287851631) | |||
28907 | 28907 | 182325 | Undocumented 2 | :: 54 | 1500 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985611.7191 | 2104963.9168 | 37.758998042021105 | -122.492843336234 | (37.7589980420211, -122.492843336234) | |||
29815 | 29815 | 181758 | Undocumented 2 | :: 54 | 1230 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984924.8270000005 | 2106814.5562 | 37.764039188732205 | -122.495355380579 | (37.7640391887322, -122.495355380579) | |||
30528 | 30528 | 36517 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
31070 | 31070 | 138278 | Undocumented 2 | :: 54 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.784492318138106 | -122.437714255164 | (37.7844923181381, -122.437714255164) | |||
34038 | 34038 | 140392 | Undocumented 2 | :: 54 | 1460 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002728.4059 | 2113323.2276 | 37.782936725289204 | -122.434243446651 | (37.7829367252892, -122.434243446651) | |||
34444 | 34444 | 139926 | Undocumented 2 | :: 54 | 1001 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005215.378 | 2112666.1069 | 37.78127327564229 | -122.425592763682 | (37.7812732756423, -122.425592763682) | |||
34634 | 34634 | 183835 | Undocumented 2 | :: 54 | 2210 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986395.4815 | 2100173.9333 | 37.7458918514691 | -122.489780482903 | (37.7458918514691, -122.489780482903) | |||
34796 | 34796 | 138319 | Undocumented 2 | :: 54 | 1915 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001944.4165 | 2115111.5373 | 37.7878024384193 | -122.437083797069 | (37.7878024384193, -122.437083797069) | |||
38023 | 38023 | 183701 | Undocumented 2 | :: 54 | 1349 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984598.3295 | 2105986.1027 | 37.7617453659671 | -122.49642348771098 | (37.7617453659671, -122.496423487711) | |||
38433 | 38433 | 181714 | Undocumented 2 | :: 54 | 1215 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987051.5149 | 2106949.2334 | 37.764533265698 | -122.488009786224 | (37.764533265698, -122.488009786224) | |||
38904 | 38904 | 182360 | Undocumented 2 | :: 54 | 1507 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985877.3228 | 2104935.7779 | 37.7589363086434 | -122.491922694782 | (37.7589363086434, -122.491922694782) | |||
39107 | 39107 | 139604 | Undocumented 2 | :: 54 | 1173 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001838.238 | 2112425.6952 | 37.7804217645564 | -122.437258767268 | (37.7804217645564, -122.437258767268) | |||
39530 | 39530 | 184555 | Undocumented 2 | :: 54 | 3601 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983107.8094 | 2103539.071 | 37.754939075681705 | -122.50139749571501 | (37.7549390756817, -122.501397495715) | |||
39826 | 39826 | 183322 | Undocumented 2 | :: 54 | 3927 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983510.9139 | 2106953.643 | 37.764338193887504 | -122.50025589533001 | (37.7643381938875, -122.50025589533) | |||
40775 | 40775 | 138003 | Undocumented 2 | :: 54 | 1670 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004492.797 | 2114606.7181 | 37.7865608551259 | -122.428230885205 | (37.7865608551259, -122.428230885205) | |||
41266 | 41266 | 140561 | Undocumented 2 | :: 54 | 50 FRIENDSHIP CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003695.7169 | 2111697.8997 | 37.7785288350927 | -122.43078092716401 | (37.7785288350927, -122.430780927164) | |||
41978 | 41978 | 184524 | Undocumented 2 | :: 54 | 1984 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981181.0558 | 2101584.0989 | 37.7494579320564 | -122.50791555821199 | (37.7494579320564, -122.507915558212) | |||
42563 | 42563 | 139441 | Undocumented 2 | :: 54 | 501 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005361.8674 | 2111299.9206 | 37.7775303390293 | -122.424988750303 | (37.7775303390293, -122.424988750303) | |||
44907 | 44907 | 182397 | Undocumented 2 | :: 54 | 1522 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985924.4899 | 2104853.8684 | 37.7587141646 | -122.49175354130301 | (37.7587141646, -122.491753541303) | |||
46023 | 46023 | 183740 | Undocumented 2 | :: 54 | 2280 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986718.9493 | 2099755.7296 | 37.7447624573869 | -122.48863125822099 | (37.7447624573869, -122.488631258221) | |||
46079 | 46079 | 181712 | Undocumented 2 | :: 54 | 3401 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985144.052 | 2107009.2181 | 37.764586509150895 | -122.494611508714 | (37.7645865091509, -122.494611508714) | |||
46209 | 46209 | 183847 | Undocumented 2 | :: 54 | 2227 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987904.6422 | 2100116.537 | 37.7458222575023 | -122.484557870143 | (37.7458222575023, -122.484557870143) | |||
46565 | 46565 | 185847 | Undocumented 2 | :: 54 | 2011 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985684.8846 | 2101427.5121 | 37.749292323144495 | -122.492329887495 | (37.7492923231445, -122.492329887495) | |||
49452 | 49452 | 183775 | Undocumented 2 | :: 54 | 2283 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985743.8519 | 2099689.1584 | 37.744522721672794 | -122.49199801053699 | (37.7445227216728, -122.491998010537) | |||
49493 | 49493 | 141641 | Undocumented 2 | :: 54 | 529 MASONIC AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999097.1169 | 2110918.0537 | 37.776125964947205 | -122.44663304885401 | (37.7761259649472, -122.446633048854) | |||
49578 | 49578 | 139026 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000502.7639999995 | 2114090.3506 | 37.784916473139894 | -122.44199830353001 | (37.7849164731399, -122.44199830353) | |||
50662 | 50662 | 244093 | Undocumented 2 | :: 54 | 1850 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997702.1482 | 2108887.2246 | 37.7704700507783 | -122.451312096124 | (37.7704700507783, -122.451312096124) | |||
52163 | 52163 | 183819 | Undocumented 2 | :: 54 | 2201 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986040.0084 | 2100206.7922 | 37.7459613114508 | -122.49101206010599 | (37.7459613114508, -122.491012060106) | |||
53710 | 53710 | 183768 | Undocumented 2 | :: 54 | 2295 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987606.9921 | 2099698.5467 | 37.744657229257 | -122.48555641926501 | (37.744657229257, -122.485556419265) | |||
53720 | 53720 | 139988 | Undocumented 2 | :: 54 | 420 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005784.2761 | 2111750.2147 | 37.7787905883012 | -122.423559517841 | (37.7787905883012, -122.423559517841) | |||
53862 | 53862 | 182038 | Undocumented 2 | :: 54 | 1319 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987384.8091 | 2106266.2339 | 37.76267737440389 | -122.48680686823499 | (37.7626773744039, -122.486806868235) | |||
54235 | 54235 | 143063 | Undocumented 2 | :: 54 | 454 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010670.2258 | 2120340.5284 | 37.802652102828105 | -122.407262742811 | (37.8026521028281, -122.407262742811) | |||
54387 | 54387 | 246177 | Undocumented 2 | :: 54 | 1588 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998014.6979 | 2108233.0836 | 37.7686918380665 | -122.450183832466 | (37.7686918380665, -122.450183832466) | |||
54716 | 54716 | 248525 | Undocumented 2 | :: 54 | 216 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998893.6593 | 2107664.8248 | 37.7671818031991 | -122.44710268466999 | (37.7671818031991, -122.44710268467) | |||
55211 | 55211 | 181592 | Undocumented 2 | :: 54 | 1659 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984670.7327 | 2103886.5941 | 37.7559849420617 | -122.49601818364201 | (37.7559849420617, -122.496018183642) | |||
55863 | 55863 | 142256 | Undocumented 2 | :: 54 | 436 FELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005308.392999999 | 2110647.6947 | 37.7757364649691 | -122.42512731628099 | (37.7757364649691, -122.425127316281) | |||
55957 | 55957 | 183949 | Undocumented 2 | :: 54 | 2142 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989476.9277 | 2100753.7305 | 37.7476632594841 | -122.47916779409701 | (37.7476632594841, -122.479167794097) | |||
56509 | 56509 | 139696 | Undocumented 2 | :: 54 | 345 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000314.3725 | 2113207.1569999997 | 37.7824807138402 | -122.442586640867 | (37.7824807138402, -122.442586640867) | |||
56605 | 56605 | 183337 | Undocumented 2 | :: 54 | 4709 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981120.829 | 2106873.2612 | 37.7639769129553 | -122.50851641382499 | (37.7639769129553, -122.508516413825) | |||
56662 | 56662 | 183853 | Undocumented 2 | :: 54 | 2240 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987950.3032 | 2100034.1765 | 37.7455987763683 | -122.484393943258 | (37.7455987763683, -122.484393943258) | |||
57456 | 57456 | 200234 | Undocumented 2 | :: 54 | 2895 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6014768.3667 | 2089489.9029 | 37.718171466543104 | -122.390923576462 | (37.7181714665431, -122.390923576462) | |||
57505 | 57505 | 142224 | Undocumented 2 | :: 54 | 633 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004805.4597 | 2110871.2494 | 37.7763218676751 | -122.426883014235 | (37.7763218676751, -122.426883014235) | |||
57686 | 57686 | 137730 | Undocumented 2 | :: 54 | 618 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000121.5934 | 2111015.3224 | 37.7764515064845 | -122.443096107731 | (37.7764515064845, -122.443096107731) | |||
58859 | 58859 | 244341 | Undocumented 2 | :: 54 | 442 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003210.2759 | 2109856.6606 | 37.7734457335057 | -122.432328715157 | (37.7734457335057, -122.432328715157) | |||
58903 | 58903 | 142118 | Undocumented 2 | :: 54 | 29 HEMWAY TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998613.9988 | 2110907.9465 | 37.776070604872 | -122.448303549007 | (37.776070604872, -122.448303549007) | |||
59014 | 59014 | 139029 | Undocumented 2 | :: 54 | 1535 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000616.8967 | 2114052.0744 | 37.784817879809204 | -122.441600694473 | (37.7848178798092, -122.441600694473) | |||
61201 | 61201 | 183850 | Undocumented 2 | :: 54 | 2222 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986707.0006 | 2100119.7376 | 37.745761228597296 | -122.488699324618 | (37.7457612285973, -122.488699324618) | |||
61870 | 61870 | 183840 | Undocumented 2 | :: 54 | 2215 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986663.0466 | 2100148.329 | 37.745837167832896 | -122.488853410496 | (37.7458371678329, -122.488853410496) | |||
62756 | 62756 | 183745 | Undocumented 2 | :: 54 | 2267 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986363.4761 | 2099812.4858 | 37.7448975449574 | -122.489864573201 | (37.7448975449574, -122.489864573201) | |||
64617 | 64617 | 139991 | Undocumented 2 | :: 54 | 430 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005660.0116 | 2111735.9709 | 37.7787444634633 | -122.423988384849 | (37.7787444634633, -122.423988384849) | |||
66691 | 66691 | 142129 | Undocumented 2 | :: 54 | 10 HEMWAY TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.1761 | 2110837.1975 | 37.775878700373895 | -122.448156010928 | (37.7758787003739, -122.448156010928) | |||
67072 | 67072 | 183201 | Undocumented 2 | :: 54 | 3850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984019.7512 | 2098181.555 | 37.7402823237858 | -122.497848207912 | (37.7402823237858, -122.497848207912) | |||
68603 | 68603 | 142716 | DPW Maintained 3 | :: 54 | 1120 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008073.8404 | 2121121.2819 | 37.804650203273 | -122.416302902461 | (37.804650203273, -122.416302902461) | |||
68711 | 68711 | 182018 | Undocumented 2 | :: 54 | 1467 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988965.6747 | 2105331.3888 | 37.7602025812324 | -122.481270822304 | (37.7602025812324, -122.481270822304) | |||
68850 | 68850 | 200507 | Undocumented 2 | :: 54 | 1510 Carroll Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6014614.4494 | 2091644.4715 | 37.724078943993 | -122.39160616116199 | (37.724078943993, -122.391606161162) | |||
69253 | 69253 | 217580 | Undocumented 2 | :: 54 | 646 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5992252.7325 | 2088559.8349 | 37.714342679649 | -122.468682167409 | (37.714342679649, -122.468682167409) | |||
71705 | 71705 | 138962 | Undocumented 2 | :: 54 | 659 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004224.8748 | 2110974.4556 | 37.7765724019201 | -122.42889877832899 | (37.7765724019201, -122.428898778329) | |||
71962 | 71962 | 182036 | Undocumented 2 | :: 54 | 1314 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987424.9672 | 2106327.6806 | 37.7628484313073 | -122.486672489667 | (37.7628484313073, -122.486672489667) | |||
74019 | 74019 | 182270 | Undocumented 2 | :: 54 | 1468 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984979.6145 | 2105227.4255 | 37.759684579371 | -122.49504884998699 | (37.759684579371, -122.495048849987) | |||
74054 | 74054 | 185122 | Undocumented 2 | :: 54 | 2850 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985897.3509 | 2095993.4067 | 37.734384144878 | -122.49119531195299 | (37.734384144878, -122.491195311953) | |||
77581 | 77581 | 33407 | Permitted Site 1 | :: 54 | 100 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
78529 | 78529 | 43025 | Permitted Site 1 | :: 54 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051004 | -122.429193705112 | (37.774709297051, -122.429193705112) | ||
81650 | 81650 | 45785 | Permitted Site 1 | :: 54 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2001 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | |||
83415 | 83415 | 114615 | Undocumented 2 | :: 54 | 2400X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
84556 | 84556 | 115963 | Undocumented 2 | :: 54 | 847 43RD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
85364 | 85364 | 115892 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
86204 | 86204 | 33463 | Permitted Site 1 | :: 54 | 20 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | ||
88179 | 88179 | 105438 | Undocumented 2 | :: 54 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002483.0 | 2102334.0 | 37.75274907025911 | -122.43430654109899 | (37.7527490702591, -122.434306541099) | ||||
88816 | 88816 | 115002 | Undocumented 2 | :: 54 | 46 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993155.2 | 2098864.2 | 37.742688023212295 | -122.46631133896999 | (37.7426880232123, -122.46631133897) | |||||
89497 | 89497 | 30705 | Permitted Site 1 | :: 54 | 371 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34615 | 6005225.74804899 | 2110232.43831944 | 37.7745916029272 | -122.425383648395 | (37.7745916029272, -122.425383648395) | ||
91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
92236 | 92236 | 43021 | Permitted Site 1 | :: 54 | 537 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | |||
94877 | 94877 | 42090 | Permitted Site 1 | :: 54 | 25 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | ||
94995 | 94995 | 108989 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
95693 | 95693 | 117514 | Undocumented 2 | :: 54 | 1445 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002056.0 | 2099801.0 | 37.7457698069611 | -122.435601983861 | (37.7457698069611, -122.435601983861) | ||||
96984 | 96984 | 121265 | Undocumented 2 | :: 54 | 3053 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996367.0 | 2111408.0 | 37.777314902031705 | -122.45611263058399 | (37.7773149020317, -122.456112630584) | ||||
98945 | 98945 | 116341 | Undocumented 2 | :: 54 | 201X Bright St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
99142 | 99142 | 116319 | Undocumented 2 | :: 54 | 1451 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
99672 | 99672 | 121127 | Undocumented 2 | :: 54 | 201 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
100878 | 100878 | 108803 | Undocumented 2 | :: 54 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
102427 | 102427 | 184466 | Undocumented 2 | :: 54 | 2183 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982310.877 | 2100256.4702 | 37.745879137546204 | -122.503910352906 | (37.7458791375462, -122.503910352906) | |||
108795 | 108795 | 113997 | Undocumented 2 | :: 54 | 58 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
109430 | 109430 | 181696 | Undocumented 2 | :: 54 | 1375 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985223.881 | 2105845.6432 | 37.7613963299035 | -122.49424963408701 | (37.7613963299035, -122.494249634087) | |||
113500 | 113500 | 109261 | Permitted Site 1 | :: 54 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
114951 | 114951 | 33208 | Permitted Site 1 | :: 54 | 80 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) |
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");