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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1664 | 1664 | 26404 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996581.1026099995 | 2115987.02812 | 37.7898999837554 | -122.455703055979 | (37.7898999837554, -122.455703055979) | |||
1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
1671 | 1671 | 13627 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 570 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6012289.31562 | 2115520.12346 | 37.789506905374395 | -122.401320892642 | (37.7895069053744, -122.401320892642) | |||
1692 | 1692 | 2957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2045 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004590.8896 | 2115694.3359 | 37.7895527302687 | -122.427969040021 | (37.7895527302687, -122.427969040021) | |||
1732 | 1732 | 134349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1733 | 1733 | 200858 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
1738 | 1738 | 13966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
1740 | 1740 | 200859 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
1743 | 1743 | 200855 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008978.4093 | 2112218.7143 | 37.7802567505844 | -122.412542843301 | (37.7802567505844, -122.412542843301) | |||
1753 | 1753 | 134350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1754 | 1754 | 245399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6005818.4513 | 2098127.8856 | 37.7413887962973 | -122.42247308874201 | (37.7413887962973, -122.422473088742) | |||
1755 | 1755 | 13965 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
1756 | 1756 | 13756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1761 | 1761 | 200862 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008817.7245 | 2112082.7382 | 37.7798743734467 | -122.41308911055201 | (37.7798743734467, -122.413089110552) | |||
1762 | 1762 | 200860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008794.0112 | 2112059.0249 | 37.779807931141 | -122.413169468366 | (37.779807931141, -122.413169468366) | |||
1763 | 1763 | 200861 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6008800.2278 | 2112051.2202 | 37.7797868502892 | -122.41314741030199 | (37.7797868502892, -122.413147410302) | |||
1774 | 1774 | 3070 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2860 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000658.3248 | 2115217.6526099998 | 37.788020616507104 | -122.44154103868799 | (37.7880206165071, -122.441541038688) | |||
1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
1901 | 1901 | 23857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003664.511 | 2113605.5032 | 37.7837648703142 | -122.431025065183 | (37.7837648703142, -122.431025065183) | |||
1925 | 1925 | 2958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004523.0139999995 | 2115687.6045 | 37.7895304073237 | -122.428203402517 | (37.7895304073237, -122.428203402517) | |||
1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
1964 | 1964 | 238618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 14 | Width 4ft | 6001078.53558 | 2101746.02342 | 37.751054810249 | -122.439121284114 | (37.751054810249, -122.439121284114) | |||
1974 | 1974 | 238616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.43874669133301 | (37.7510729252903, -122.438746691333) | |||
1975 | 1975 | 238619 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001066.93276 | 2101745.60422 | 37.7510529990026 | -122.43916137771099 | (37.7510529990026, -122.439161377711) | |||
1989 | 1989 | 133618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999272.2292 | 2119684.41545 | 37.8002060956892 | -122.446658172159 | (37.8002060956892, -122.446658172159) | |||
2024 | 2024 | 139198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | Width 0ft | 6001803.3539 | 2113704.6103 | 37.783931357581395 | -122.437471057097 | (37.7839313575814, -122.437471057097) | |||
2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
2041 | 2041 | 13773 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 6010487.82969 | 2113786.8175 | 37.7846469870112 | -122.407431620471 | (37.7846469870112, -122.407431620471) | |||
2048 | 2048 | 143400 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | 6008592.8234 | 2111992.2193 | 37.779613202213994 | -122.41386074083401 | (37.779613202214, -122.413860740834) | |||
2051 | 2051 | 3179 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3560 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X2 | 5997388.758280001 | 2114760.01365 | 37.7865772450958 | -122.45282005522101 | (37.7865772450958, -122.452820055221) | |||
2064 | 2064 | 23285 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 850 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006625.13758 | 2113482.84587 | 37.783595398064996 | -122.42077367996401 | (37.783595398065, -122.420773679964) | |||
2070 | 2070 | 109552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006854.31545 | 2111807.2543900004 | 37.7790075453087 | -122.419861872643 | (37.7790075453087, -122.419861872643) | |||
2087 | 2087 | 252878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | |||
2088 | 2088 | 3013 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002627.84431 | 2115492.11411 | 37.7888862283618 | -122.43474649336599 | (37.7888862283618, -122.434746493366) | |||
2089 | 2089 | 195741 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 4ft | 6014483.0 | 2111149.0 | 37.7776269440566 | -122.39342489592899 | (37.7776269440566, -122.393424895929) | |||
2096 | 2096 | 200850 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6007584.0 | 2110630.0 | 37.77581616716321 | -122.417254147161 | (37.7758161671632, -122.417254147161) | |||
2101 | 2101 | 143399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008612.8747 | 2111976.4646 | 37.779571069624 | -122.413790259796 | (37.779571069624, -122.413790259796) | |||
2104 | 2104 | 140318 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1170 MARKET ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6008545.5594 | 2111947.8198 | 37.779488637316206 | -122.414021106074 | (37.7794886373162, -122.414021106074) | |||
2112 | 2112 | 13981 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008866.9651 | 2112266.4261 | 37.7803815007944 | -122.412931755866 | (37.7803815007944, -122.412931755866) | |||
2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
2131 | 2131 | 2996 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6003308.145280001 | 2115585.18188 | 37.7891803678189 | -122.43239939681801 | (37.7891803678189, -122.432399396818) | |||
2167 | 2167 | 3158 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3410 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998012.98689 | 2114846.6357400003 | 37.7868508368504 | -122.45066663485201 | (37.7868508368504, -122.450666634852) | |||
2203 | 2203 | 8461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1877 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002698.7987 | 2113699.0733 | 37.7839670221208 | -122.43437275514 | (37.7839670221208, -122.43437275514) | |||
2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
2251 | 2251 | 13985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
2254 | 2254 | 13986 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
2285 | 2285 | 2664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2018 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003759.2529 | 2114943.4782 | 37.78744398103571 | -122.430792808025 | (37.7874439810357, -122.430792808025) | |||
2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
2303 | 2303 | 122440 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013669.1059 | 2114077.4124 | 37.785622440131 | -122.39644576664499 | (37.785622440131, -122.396445766645) | ||
2305 | 2305 | 201174 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 778941 | 6013723.602999999 | 2114126.7683 | 37.785760992593296 | -122.396260681537 | (37.7857609925933, -122.396260681537) | ||
2306 | 2306 | 195019 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013637.791730001 | 2113971.74755 | 37.785330566207705 | -122.396546695873 | (37.7853305662077, -122.396546695873) | |||
2307 | 2307 | 122432 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778941 | 6013714.3488 | 2114207.9998 | 37.7859835205848 | -122.396298394128 | (37.7859835205848, -122.396298394128) | ||
2309 | 2309 | 122433 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013698.925 | 2114193.6044 | 37.785943135879 | -122.396350747311 | (37.785943135879, -122.396350747311) | ||
2313 | 2313 | 201193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 611 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 778941 | 6013579.6483 | 2113996.1808 | 37.7853944182999 | -122.39674956946399 | (37.7853944182999, -122.396749569464) | ||
2315 | 2315 | 195022 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013709.75083 | 2113894.09551 | 37.785121356022394 | -122.39629229296001 | (37.7851213560224, -122.39629229296) | |||
2319 | 2319 | 201172 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013687.6143 | 2114096.9491 | 37.785677113353294 | -122.396383102325 | (37.7856771133533, -122.396383102325) | ||
2323 | 2323 | 201173 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013705.0945 | 2114111.3445 | 37.7857176125048 | -122.39632363473801 | (37.7857176125048, -122.396323634738) | ||
2324 | 2324 | 195018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 778941 | 6013610.320719999 | 2113989.12597 | 37.7853767544813 | -122.39664295660499 | (37.7853767544813, -122.396642956605) | ||
2330 | 2330 | 6147 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 939 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6006318.99495 | 2113507.73043 | 37.7836464651567 | -122.42183458592 | (37.7836464651567, -122.42183458592) | |||
2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
2332 | 2332 | 122438 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 778941 | 6013622.8347 | 2114119.5705 | 37.785735621476 | -122.396608809095 | (37.785735621476, -122.396608809095) | ||
2334 | 2334 | 122437 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013638.2584 | 2114134.9942 | 37.7857788297664 | -122.396556528653 | (37.7857788297664, -122.396556528653) | ||
2335 | 2335 | 195021 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6013679.6407 | 2113928.34961 | 37.7852137343684 | -122.396398867136 | (37.7852137343684, -122.396398867136) | |||
2336 | 2336 | 195020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013662.142659999 | 2113947.50545 | 37.785265358143896 | -122.39646074858601 | (37.7852653581439, -122.396460748586) | |||
2337 | 2337 | 122436 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | Permit Number 778941 | 6013651.6256 | 2114147.3332 | 37.7858134537143 | -122.39651114681001 | (37.7858134537143, -122.39651114681) | ||
2340 | 2340 | 13486 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013525.0360199995 | 2116684.5106599997 | 37.7927729057886 | -122.39712708324801 | (37.7927729057886, -122.397127083248) | |||
2342 | 2342 | 3126 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998843.08615 | 2114964.7899700003 | 37.787222737075 | -122.447803205161 | (37.787222737075, -122.447803205161) | |||
2343 | 2343 | 195028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013774.91802 | 2113824.49769 | 37.7849338824287 | -122.396061954106 | (37.7849338824287, -122.396061954106) | |||
2344 | 2344 | 122435 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 778941 | 6013667.0494 | 2114164.8134 | 37.785862308640105 | -122.396459010111 | (37.7858623086401, -122.396459010111) | ||
2347 | 2347 | 195023 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013717.57682 | 2113887.99977 | 37.785105053996396 | -122.396264789902 | (37.7851050539964, -122.396264789902) | |||
2350 | 2350 | 122434 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013681.4448 | 2114180.2371 | 37.7859054596404 | -122.39641028715201 | (37.7859054596404, -122.396410287152) | ||
2351 | 2351 | 201241 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 778941 | 6013597.1285 | 2114096.9491 | 37.78567207766061 | -122.396696159476 | (37.7856720776606, -122.396696159476) | ||
2352 | 2352 | 195026 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013748.5801800005 | 2113848.78027 | 37.7849990913834 | -122.39615477762301 | (37.7849990913834, -122.396154777623) | |||
2355 | 2355 | 195025 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013739.901380001 | 2113861.81988 | 37.7850344122501 | -122.396185717917 | (37.7850344122501, -122.396185717917) | |||
2358 | 2358 | 195024 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013723.336209999 | 2113877.98804 | 37.785077884566604 | -122.39624416214 | (37.7850778845666, -122.39624416214) | |||
2359 | 2359 | 195027 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013762.26581 | 2113837.6181400004 | 37.784969204212295 | -122.396106646824 | (37.7849692042123, -122.396106646824) | |||
2360 | 2360 | 122439 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Permit Number 778941 | 6013610.4957 | 2114107.2315 | 37.7857010547146 | -122.39665063354099 | (37.7857010547146, -122.396650633541) | ||
2363 | 2363 | 3048 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2698 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001512.20185 | 2115337.69882 | 37.788398842590496 | -122.438595386662 | (37.7883988425905, -122.438595386662) | |||
2388 | 2388 | 12913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | |||
2468 | 2468 | 2848 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1275 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008247.47804 | 2116208.39434 | 37.7911703975462 | -122.415354000191 | (37.7911703975462, -122.415354000191) | |||
2556 | 2556 | 10689 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1230 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001934.2005 | 2110513.7359 | 37.775177459697396 | -122.436789881705 | (37.7751774596974, -122.436789881705) | |||
2635 | 2635 | 13840 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 974 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6009780.9039 | 2113133.8849 | 37.78281459658329 | -122.40983125198 | (37.7828145965833, -122.40983125198) | |||
2655 | 2655 | 5870 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010X Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005526.7803 | 2113108.4242 | 37.782505360766294 | -122.42454693631599 | (37.7825053607663, -122.424546936316) | |||
2686 | 2686 | 234760 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 252 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004468.902369999 | 2109137.1444099997 | 37.77154140335671 | -122.427923663451 | (37.7715414033567, -122.427923663451) | |||
2690 | 2690 | 126183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003793.92894 | 2120715.46368 | 37.803294337014606 | -122.431084963893 | (37.8032943370146, -122.431084963893) | |||
2730 | 2730 | 7762 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006322.26322 | 2111614.07343 | 37.7784471291735 | -122.421688733864 | (37.7784471291735, -122.421688733864) | |||
2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
2810 | 2810 | 23452 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2209 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005880.951090001 | 2118079.82441 | 37.796175582497504 | -122.423675237326 | (37.7961755824975, -122.423675237326) | |||
2877 | 2877 | 2888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1541 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6007004.32462 | 2116031.27674 | 37.7906141281881 | -122.41964270965201 | (37.7906141281881, -122.419642709652) | |||
2892 | 2892 | 99717 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001694.9164 | 2113468.8804 | 37.7832779377979 | -122.437829320807 | (37.7832779377979, -122.437829320807) | |||
2927 | 2927 | 13682 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6011577.51187 | 2114828.29204 | 37.787567561449706 | -122.403734970715 | (37.7875675614497, -122.403734970715) | |||
2933 | 2933 | 98726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006198.51355 | 2111464.4034 | 37.7780291926159 | -122.422106195562 | (37.7780291926159, -122.422106195562) |
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");