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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134826 | 134826 | 133419 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3535 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1920 | Width 3ft | 5997881.22616 | 2115448.76842 | 37.788496590783794 | -122.451165933971 | (37.7884965907838, -122.451165933971) | |||
5220 | 5220 | 3005 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003025.35785 | 2115546.48182 | 37.7890580681313 | -122.43337503892599 | (37.7890580681313, -122.433375038926) | |||
6597 | 6597 | 2938 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6005165.9769 | 2115843.65422 | 37.7899952390391 | -122.425989931308 | (37.7899952390391, -122.425989931308) | |||
7035 | 7035 | 2945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1976 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4x4 | 6004916.90852 | 2115812.13334 | 37.78989461118729 | -122.426849441272 | (37.7898946111873, -122.426849441272) | |||
8809 | 8809 | 3076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000369.0268 | 2115111.6254 | 37.7877130071917 | -122.442534340035 | (37.7877130071917, -122.442534340035) | |||
81413 | 81413 | 12903 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
117853 | 117853 | 3012 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2440 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002689.255201099 | 2115491.3069188 | 37.7888874982911 | -122.434533962619 | (37.7888874982911, -122.434533962619) | |||
118883 | 118883 | 3331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5330 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 5991002.22066 | 2114113.47051 | 37.784433979884795 | -122.474868477503 | (37.7844339798848, -122.474868477503) | |||
138556 | 138556 | 12905 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
8464 | 8464 | 3003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2356 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 95 | 3X3 | 6003075.2981900005 | 2115553.9711 | 37.7890814648974 | -122.43320278729601 | (37.7890814648974, -122.433202787296) | |||
145251 | 145251 | 3057 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 95 | 3X3 | 6001337.5504485 | 2115252.7303216998 | 37.7881556043161 | -122.43919355883301 | (37.7881556043161, -122.439193558833) | |||
6844 | 6844 | 2941 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1938 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6005079.693519999 | 2115832.49574 | 37.7899597239052 | -122.426287669836 | (37.7899597239052, -122.426287669836) | |||
7409 | 7409 | 2866 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6007767.81348 | 2116206.02953 | 37.791136933759496 | -122.41701346161999 | (37.7911369337595, -122.41701346162) | |||
19679 | 19679 | 3246 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3934 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995332.1300099995 | 2114476.7036099997 | 37.785681286495794 | -122.45991490670299 | (37.7856812864958, -122.459914906703) | |||
77343 | 77343 | 3327 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5300 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5991115.03763 | 2114114.39354 | 37.7844430513541 | -122.474478240984 | (37.7844430513541, -122.474478240984) | |||
93334 | 93334 | 25562 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Industrial St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | |||
95208 | 95208 | 3393 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6241 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988252.22536 | 2113941.19107 | 37.7838012036794 | -122.484369756511 | (37.7838012036794, -122.484369756511) | |||
97802 | 97802 | 3315 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5010 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5992011.64144 | 2114143.58423 | 37.7845751079649 | -122.471378457169 | (37.7845751079649, -122.471378457169) | |||
102833 | 102833 | 12523 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 215X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5995436.52596 | 2114791.55387 | 37.7865517838688 | -122.45957654090401 | (37.7865517838688, -122.459576540904) | |||
107070 | 107070 | 200 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5604X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4x4 | 5990186.04567 | 2114081.13509 | 37.784297864805104 | -122.477689766774 | (37.7842978648051, -122.477689766774) | |||
112795 | 112795 | 23197 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 470X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6006890.72942 | 2112234.67565 | 37.780183192022704 | -122.41976623797301 | (37.7801831920227, -122.419766237973) | |||
117989 | 117989 | 175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5400X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | |||
126525 | 126525 | 3410 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6528 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5987293.52978 | 2113992.8320400002 | 37.7838871248275 | -122.48769023634199 | (37.7838871248275, -122.487690236342) | |||
143328 | 143328 | 3408 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6517 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X3 | 5987328.28355 | 2113919.47268 | 37.7836877279639 | -122.48756461184999 | (37.7836877279639, -122.48756461185) | |||
144868 | 144868 | 3336 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5414 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990748.9880099995 | 2114101.91513 | 37.7843875739705 | -122.475743722006 | (37.7843875739705, -122.475743722006) | |||
97100 | 97100 | 1478 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 255 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3PL | 5995470.91664 | 2114596.3439599997 | 37.7860177674927 | -122.45944341566099 | (37.7860177674927, -122.459443415661) | |||
141614 | 141614 | 710 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 5 | 5986716.67704 | 2113957.13547 | 37.783755449840996 | -122.489683280356 | (37.783755449841, -122.489683280356) | |||
550 | 550 | 3006 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2380 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002989.49365 | 2115542.57517 | 37.7890453067372 | -122.433498845012 | (37.7890453067372, -122.433498845012) | |||
1330 | 1330 | 2943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1946 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 4X4 | 6005029.19291 | 2115824.37334 | 37.7899345671834 | -122.426461819067 | (37.7899345671834, -122.426461819067) | |||
5587 | 5587 | 2883 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6007114.009819999 | 2116114.94594 | 37.7908500410346 | -122.419269142052 | (37.7908500410346, -122.419269142052) | |||
6422 | 6422 | 2980 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2202 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6003749.924 | 2115648.7026400003 | 37.789379820361795 | -122.430875432649 | (37.7893798203618, -122.430875432649) | |||
6497 | 6497 | 3140 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3326 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5998383.474359999 | 2114899.94192 | 37.787018401233 | -122.449388682067 | (37.787018401233, -122.449388682067) | |||
6551 | 6551 | 3088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2963 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6000170.7975 | 2115085.6403 | 37.78763035756629 | -122.44321830622299 | (37.7876303575663, -122.443218306223) | |||
7690 | 7690 | 2931 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1834 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6005504.99786 | 2115891.9333200003 | 37.790146955562896 | -122.424820382781 | (37.7901469555629, -122.424820382781) | |||
78433 | 78433 | 3333 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5343 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5x5 | 5990966.33416 | 2114052.40229 | 37.7842642238474 | -122.474988171866 | (37.7842642238474, -122.474988171866) | |||
78445 | 78445 | 3400 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6409 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 5987669.913269999 | 2113931.4906 | 37.78374064449 | -122.48638360034501 | (37.78374064449, -122.486383600345) | |||
81785 | 81785 | 3421 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6743 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 5986605.45058 | 2113893.32578 | 37.7835737522145 | -122.490063381826 | (37.7835737522145, -122.490063381826) | |||
82167 | 82167 | 3409 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6525 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 2X3 | 5987276.92866 | 2113919.53394 | 37.7836849008923 | -122.487742282465 | (37.7836849008923, -122.487742282465) | |||
85390 | 85390 | 705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
90952 | 90952 | 3244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3922 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 5995381.65055 | 2114482.86405 | 37.7857010492639 | -122.45974402736401 | (37.7857010492639, -122.459744027364) | |||
104117 | 104117 | 3371 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5946 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5989086.17579 | 2114041.98015 | 37.784126466602004 | -122.481492017597 | (37.784126466602, -122.481492017597) | |||
114880 | 114880 | 3263 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4210 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5994488.18564 | 2114359.7112 | 37.785311484691896 | -122.462826200124 | (37.7853114846919, -122.462826200124) | |||
126299 | 126299 | 704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
128019 | 128019 | 714 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5x33 | 5986452.35935 | 2113947.57202 | 37.7837137557398 | -122.490597003715 | (37.7837137557398, -122.490597003715) | |||
128508 | 128508 | 3428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6941 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5986006.25381 | 2113811.6066799997 | 37.783314366378995 | -122.492130323992 | (37.783314366379, -122.492130323992) | |||
8360 | 8360 | 27403 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2390 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007083.01072 | 2120446.73083 | 37.802742291788995 | -122.419683881525 | (37.802742291789, -122.419683881525) | |||
12538 | 12538 | 230 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.537280001 | 2095454.9094099998 | 37.7331751359068 | -122.475141200505 | (37.7331751359068, -122.475141200505) | |||
13169 | 13169 | 226 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | |||
17362 | 17362 | 10390 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1365 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1994 12:00:00 AM | 70 | 3X3 | 5999656.0315 | 2108763.943 | 37.7702432341333 | -122.44454476495501 | (37.7702432341333, -122.444544764955) | ||
18797 | 18797 | 10394 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1365 Haight St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1994 12:00:00 AM | 70 | 3X3 | 5999742.0349 | 2108767.5769 | 37.7702581189154 | -122.444247541828 | (37.7702581189154, -122.444247541828) | ||
96599 | 96599 | 27395 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007121.016846401 | 2120187.7710471 | 37.802033394640105 | -122.41953397743299 | (37.8020333946401, -122.419533977433) | |||
99056 | 99056 | 12906 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
101028 | 101028 | 27397 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007121.016846401 | 2120187.7710471 | 37.802033394640105 | -122.41953397743299 | (37.8020333946401, -122.419533977433) | |||
104705 | 104705 | 17174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2999X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.29755 | 2095287.65599 | 37.732715886567995 | -122.475129823758 | (37.732715886568, -122.475129823758) | |||
113410 | 113410 | 12908 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
115965 | 115965 | 27401 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2380 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007085.742235401 | 2120448.8444634997 | 37.8027482491583 | -122.41967457912901 | (37.8027482491583, -122.419674579129) | |||
140256 | 140256 | 27396 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007121.016846401 | 2120187.7710471 | 37.802033394640105 | -122.41953397743299 | (37.8020333946401, -122.419533977433) | |||
142998 | 142998 | 12907 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
144678 | 144678 | 27398 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007121.016846401 | 2120187.7710471 | 37.802033394640105 | -122.41953397743299 | (37.8020333946401, -122.419533977433) | |||
33 | 33 | 2889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006951.47041 | 2116025.01423 | 37.79059395549061 | -122.419825138035 | (37.7905939554906, -122.419825138035) | |||
178 | 178 | 2985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2253 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6003588.0004 | 2115559.2302 | 37.789124975971106 | -122.431429279776 | (37.7891249759711, -122.431429279776) | |||
1478 | 1478 | 2891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6006907.6574099995 | 2116020.89539 | 37.7905801778777 | -122.419976436385 | (37.7905801778777, -122.419976436385) | |||
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) | |||
3521 | 3521 | 2864 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1365 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6007820.57137 | 2116146.85538 | 37.790977423709606 | -122.416826726397 | (37.7909774237096, -122.416826726397) | |||
4361 | 4361 | 2887 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1530 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6007023.220480001 | 2116101.4928900003 | 37.7908079887437 | -122.41958231479401 | (37.7908079887437, -122.419582314794) | |||
5599 | 5599 | 3028 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6002144.8336 | 2115361.2222 | 37.7884993990958 | -122.436408269694 | (37.7884993990958, -122.436408269694) | |||
5736 | 5736 | 3046 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2685 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6001527.3503 | 2115274.272 | 37.7882255506013 | -122.438538429256 | (37.7882255506013, -122.438538429256) | |||
5808 | 5808 | 2855 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1324 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6007986.03051 | 2116236.3535 | 37.791232468744894 | -122.416260584268 | (37.7912324687449, -122.416260584268) | |||
5828 | 5828 | 3030 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2560 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3x3 | 6002142.00853 | 2115425.59943 | 37.7886760019326 | -122.43642265337601 | (37.7886760019326, -122.436422653376) | |||
6279 | 6279 | 2846 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1270 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6008288.14408 | 2116278.11526 | 37.791364119607294 | -122.415218234034 | (37.7913641196073, -122.415218234034) | |||
6464 | 6464 | 2886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1520 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6007072.466130001 | 2116107.2924 | 37.7908266865378 | -122.41941233843399 | (37.7908266865378, -122.419412338434) | |||
6935 | 6935 | 2838 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1244 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6008385.47069 | 2116291.59925 | 37.7914066125886 | -122.414882439771 | (37.7914066125886, -122.414882439771) | |||
7039 | 7039 | 2871 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6007554.23283 | 2116108.24519 | 37.7908564253197 | -122.417745511562 | (37.7908564253197, -122.417745511562) | |||
7278 | 7278 | 2972 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2159 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6004034.5013 | 2115615.2154 | 37.789303992655896 | -122.42988843821999 | (37.7893039926559, -122.42988843822) | |||
8065 | 8065 | 3159 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3415 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 2X2 | 5998096.1389 | 2114777.8959999997 | 37.7866668549307 | -122.450373992446 | (37.7866668549307, -122.450373992446) | |||
8089 | 8089 | 2845 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1260 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6008337.45102 | 2116285.31765 | 37.7913866665183 | -122.415048142581 | (37.7913866665183, -122.415048142581) | |||
8429 | 8429 | 3026 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2541 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6002182.5572 | 2115361.7585 | 37.788503015075605 | -122.436277790493 | (37.7885030150756, -122.436277790493) | |||
8556 | 8556 | 2856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1332 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6007939.55781 | 2116229.22799 | 37.791210290562 | -122.416420874032 | (37.791210290562, -122.416420874032) | |||
9525 | 9525 | 177 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990912.96055 | 2114105.91561 | 37.7844080632129 | -122.47517673183799 | (37.7844080632129, -122.475176731838) | |||
9574 | 9574 | 176 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990964.24262 | 2114110.49658 | 37.784423613403504 | -122.474999649931 | (37.7844236134035, -122.474999649931) | |||
78173 | 78173 | 3248 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4005 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5995165.41768 | 2114387.78937 | 37.7854275627426 | -122.460485234507 | (37.7854275627426, -122.460485234507) | |||
79140 | 79140 | 3300 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4801 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5992645.2644 | 2114112.09088 | 37.7845252689982 | -122.46918406246901 | (37.7845252689982, -122.469184062469) | |||
79155 | 79155 | 3183 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3628X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5996985.44701 | 2114698.4139900003 | 37.7863849896381 | -122.45421095485202 | (37.7863849896381, -122.454210954852) | |||
80971 | 80971 | 3413 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6625 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 2X2 | 5987004.51958 | 2113910.41235 | 37.7836439628806 | -122.48868403128401 | (37.7836439628806, -122.488684031284) | |||
83554 | 83554 | 3347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5609 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 2X2 | 5990159.71728 | 2113998.62042 | 37.7840697746569 | -122.477774818942 | (37.7840697746569, -122.477774818942) | |||
83800 | 83800 | 3206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3775 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 5996352.5717 | 2114530.71811 | 37.785888229802296 | -122.45638839923599 | (37.7858882298023, -122.456388399236) | |||
83833 | 83833 | 2936 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6005218.9601300005 | 2115764.01846 | 37.789779573452705 | -122.425800942983 | (37.7897795734527, -122.425800942983) | |||
85761 | 85761 | 3297 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4739 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5992859.41537 | 2114118.1904 | 37.7845543885909 | -122.46844362338699 | (37.7845543885909, -122.468443623387) | |||
92749 | 92749 | 425 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5800X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5989566.99548 | 2114057.22504 | 37.7841962699423 | -122.479829688766 | (37.7841962699423, -122.479829688766) | |||
93126 | 93126 | 3108 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3101 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 5999466.93817 | 2114963.78778 | 37.787255622321794 | -122.445644746855 | (37.7872556223218, -122.445644746855) | |||
98216 | 98216 | 3322 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5231X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 2x2 | 5991426.97193 | 2114073.36029 | 37.784348453468205 | -122.473396072395 | (37.7843484534682, -122.473396072395) | |||
100002 | 100002 | 3340 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5502 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 6x6 | 5990496.712590001 | 2114092.16365 | 37.784346170085705 | -122.47661578560101 | (37.7843461700857, -122.476615785601) | |||
102515 | 102515 | 3341 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5502 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 6x6 | 5990447.446280001 | 2114089.7485700003 | 37.784336681324 | -122.476786051534 | (37.784336681324, -122.476786051534) | |||
105967 | 105967 | 2894 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1599 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006720.0533 | 2116001.64312 | 37.79051674464179 | -122.42062416964599 | (37.7905167446418, -122.420624169646) | |||
109945 | 109945 | 3407 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6509 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5987381.40448 | 2113921.43328 | 37.7836962092086 | -122.487380980037 | (37.7836962092086, -122.487380980037) | |||
110416 | 110416 | 3368 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5921 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5989182.27948 | 2113988.9331400003 | 37.7839864018625 | -122.481155651528 | (37.7839864018625, -122.481155651528) | |||
110691 | 110691 | 3317 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5026 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3x3 | 5991959.38732 | 2114142.23783 | 37.7845683882136 | -122.471559138911 | (37.7845683882136, -122.471559138911) | |||
115677 | 115677 | 2805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 65 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
116612 | 116612 | 2890 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1550 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006878.02866 | 2116107.92821 | 37.7908174791384 | -122.42008512947201 | (37.7908174791384, -122.420085129472) |
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");