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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
3000 | 3000 | 2847 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1271 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008300.20428 | 2116215.33736 | 37.791192424647 | -122.415172060143 | (37.791192424647, -122.415172060143) | |||
3055 | 3055 | 27261 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1430 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006341.72123 | 2115482.85367 | 37.789070948203296 | -122.421896309963 | (37.7890709482033, -122.421896309963) | |||
3063 | 3063 | 13736 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6010795.99203 | 2114077.5984099996 | 37.785462646015894 | -122.40638597245399 | (37.7854626460159, -122.406385972454) | ||
3066 | 3066 | 13737 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 780155 | 6010751.43772 | 2114034.04518 | 37.7853405666668 | -122.40653704776001 | (37.7853405666668, -122.40653704776) | ||
3078 | 3078 | 13812 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 950 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6009942.8788 | 2113250.7921 | 37.783144672032705 | -122.409279136989 | (37.7831446720327, -122.409279136989) | |||
3110 | 3110 | 3090 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2970 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000158.190669999 | 2115149.23104 | 37.7878042423257 | -122.443266492369 | (37.7878042423257, -122.443266492369) | |||
3144 | 3144 | 18663 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 55 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999555.8589699995 | 2119313.6235700003 | 37.7992041978826 | -122.445650026744 | (37.7992041978826, -122.445650026744) | |||
3159 | 3159 | 12353 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1280 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6004687.1313 | 2113235.4124 | 37.782806585155896 | -122.427460807731 | (37.7828065851559, -122.427460807731) | |||
3161 | 3161 | 13804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6010106.2877 | 2113414.5576 | 37.7836034869676 | -122.408725362824 | (37.7836034869676, -122.408725362824) | |||
3216 | 3216 | 23266 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006650.95952 | 2113278.63532 | 37.7830361411562 | -122.42066984425301 | (37.7830361411562, -122.420669844253) | |||
3323 | 3323 | 23495 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2526 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005841.8244199995 | 2119085.6949400003 | 37.7989352394136 | -122.423882184811 | (37.7989352394136, -122.423882184811) | |||
3376 | 3376 | 21619 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005002.8394 | 2114768.031 | 37.7870326258746 | -122.42647775301799 | (37.7870326258746, -122.426477753018) | |||
3404 | 3404 | 9412 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006178.48219 | 2112500.02959 | 37.780871640264 | -122.422249088827 | (37.780871640264, -122.422249088827) | |||
3416 | 3416 | 12354 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1280 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004685.0495 | 2113260.3937 | 37.782875059860295 | -122.42746979013701 | (37.7828750598603, -122.427469790137) | |||
3421 | 3421 | 13448 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2016 10:29:00 AM | 3 | 4x4 | 6013957.13139 | 2117096.02637 | 37.793926876278206 | -122.39566084929301 | (37.7939268762782, -122.395660849293) | ||
3443 | 3443 | 23525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2750 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005736.3490699995 | 2119811.18986 | 37.800921308526895 | -122.424298792155 | (37.8009213085269, -122.424298792155) | |||
3453 | 3453 | 13461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6013807.91636 | 2116979.13322 | 37.793597613798205 | -122.39616895543199 | (37.7935976137982, -122.396168955432) | |||
3459 | 3459 | 13447 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6013978.34397 | 2117135.9015599997 | 37.7940375441385 | -122.395590246219 | (37.7940375441385, -122.395590246219) | |||
3480 | 3480 | 23466 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2307 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005840.38038 | 2118370.08378 | 37.796970271119 | -122.42383626993 | (37.796970271119, -122.42383626993) | |||
3493 | 3493 | 7763 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006324.76209 | 2111593.68437 | 37.77839128667021 | -122.42167864077601 | (37.7783912866702, -122.421678640776) | |||
3498 | 3498 | 200857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 0ft | Permit Number 780155 | 6008905.5117 | 2112149.5313 | 37.7800626991558 | -122.412790138104 | (37.7800626991558, -122.412790138104) | ||
3500 | 3500 | 13943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.780196698058894 | -122.412628072717 | (37.7801966980589, -122.412628072717) | |||
3507 | 3507 | 200856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | Permit Number 780155 | 6008896.2254 | 2112159.7462 | 37.7800902256084 | -122.412822986117 | (37.7800902256084, -122.412822986117) | ||
3515 | 3515 | 13941 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6008943.5856 | 2112207.5707 | 37.780224198497294 | -122.412662526962 | (37.7802241984973, -122.412662526962) | ||
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) | |||
3536 | 3536 | 14030 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1240 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008102.1797 | 2111505.9419 | 37.77825043397171 | -122.415523656395 | (37.7782504339717, -122.415523656395) | |||
3578 | 3578 | 13841 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 974 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6009799.5639 | 2113118.5178 | 37.7827734478984 | -122.409765610889 | (37.7827734478984, -122.409765610889) | |||
3618 | 3618 | 14013 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1182 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008415.9416 | 2111801.0151 | 37.7790782658429 | -122.414459119878 | (37.7790782658429, -122.414459119878) | |||
3658 | 3658 | 23286 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 850 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2002 12:00:00 AM | 7 | 3X3 | 6006617.18991 | 2113501.82735 | 37.7836470686106 | -122.420802523923 | (37.7836470686106, -122.420802523923) | ||
3705 | 3705 | 13973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008926.8051 | 2112282.1341 | 37.780427990023206 | -122.41272585143899 | (37.7804279900232, -122.412725851439) | |||
3727 | 3727 | 23506 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005800.086 | 2119369.4177599996 | 37.799711913718795 | -122.424046801229 | (37.7997119137188, -122.424046801229) | |||
3730 | 3730 | 9439 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 770 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005833.93052 | 2112448.8947400004 | 37.7807117956403 | -122.423437426899 | (37.7807117956403, -122.423437426899) | |||
3766 | 3766 | 9437 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 770 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005883.7495099995 | 2112458.00456 | 37.780739620683605 | -122.423265726534 | (37.7807396206836, -122.423265726534) | |||
3783 | 3783 | 3103 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3054 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999732.37649 | 2115089.7661599996 | 37.7876166770259 | -122.444735448586 | (37.7876166770259, -122.444735448586) | |||
3789 | 3789 | 13832 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009846.7625 | 2113163.5212 | 37.7828996614361 | -122.409605500316 | (37.7828996614361, -122.409605500316) | |||
3797 | 3797 | 2973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6004006.64752 | 2115684.29812 | 37.789492098924605 | -122.429989738932 | (37.7894920989246, -122.429989738932) | |||
3828 | 3828 | 3019 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2490 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6002471.3865 | 2115470.57138 | 37.7888181937655 | -122.43528627363999 | (37.7888181937655, -122.43528627364) | |||
3876 | 3876 | 5847 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 923 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005978.31191 | 2113111.7315700003 | 37.7825399312178 | -122.422985066108 | (37.7825399312178, -122.422985066108) | |||
3932 | 3932 | 23329 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1142 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6006483.66325 | 2114491.30782 | 37.7863564120544 | -122.421334766086 | (37.7863564120544, -122.421334766086) | |||
4086 | 4086 | 29091 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 281 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009517.223019999 | 2113949.77701 | 37.785040060898794 | -122.41080112117399 | (37.7850400608988, -122.410801121174) | ||
4169 | 4169 | 7764 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006327.38051 | 2111579.10359 | 37.7783513990351 | -122.421668546781 | (37.7783513990351, -122.421668546781) | |||
4194 | 4194 | 8322 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 11:52:00 AM | 3 | 3X5 | 6006304.17798 | 2114200.07423 | 37.78554663550629 | -122.42193504467 | (37.7855466355063, -122.42193504467) | ||
4232 | 4232 | 8321 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 11:49:00 AM | 3 | 3x5 | 6006287.59901 | 2114197.2943700003 | 37.785538067679795 | -122.421992205597 | (37.7855380676798, -122.421992205597) | ||
4285 | 4285 | 23337 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006452.31464 | 2114712.52728 | 37.786962058707 | -122.421458940889 | (37.786962058707, -122.421458940889) | |||
4300 | 4300 | 13485 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6013562.43984 | 2116739.21834 | 37.7929252023844 | -122.397001501025 | (37.7929252023844, -122.397001501025) | |||
4322 | 4322 | 13947 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1108 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2015 07:47:00 AM | 3 | 4x4 | 6009077.5271 | 2112426.8721 | 37.7808338645075 | -122.412214663991 | (37.7808338645075, -122.412214663991) | ||
4424 | 4424 | 13776 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6010212.9518 | 2113517.1193 | 37.7838910706745 | -122.408363580756 | (37.7838910706745, -122.408363580756) | |||
4430 | 4430 | 2438 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004494.59897 | 2111127.76601 | 37.7770086176929 | -122.427976651513 | (37.7770086176929, -122.427976651513) | |||
4459 | 4459 | 18679 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999224.539609999 | 2119615.47309 | 37.800014074245 | -122.446818232573 | (37.800014074245, -122.446818232573) | |||
4461 | 4461 | 3010 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2408 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 12:00:00 AM | 30 | 3X3 | 6002770.31768 | 2115511.22109 | 37.788946778816296 | -122.434254922131 | (37.7889467788163, -122.434254922131) | ||
4522 | 4522 | 2439 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004490.54499 | 2111149.79647 | 37.7770688785722 | -122.42799224575501 | (37.7770688785722, -122.427992245755) | |||
4574 | 4574 | 133622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 45 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2014 02:11:00 PM | 2 | Width 3ft | 5999573.26075 | 2119295.26208 | 37.799154775636296 | -122.44558848973499 | (37.7991547756363, -122.445588489735) | ||
4586 | 4586 | 134695 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1675 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 3ft | 6006457.67356 | 2115958.8638400002 | 37.7903844925874 | -122.4215289495 | (37.7903844925874, -122.4215289495) | |||
4609 | 4609 | 14021 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1212 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008197.125 | 2111596.9919 | 37.778505771849204 | -122.415201651543 | (37.7785057718492, -122.415201651543) | |||
4620 | 4620 | 253639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4405 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5993893.0 | 2114132.0 | 37.784651953064206 | -122.46486880251801 | (37.7846519530642, -122.464868802518) | |||
4642 | 4642 | 195899 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Carpenter Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 5 | Width 3ft | 6016597.78422 | 2095457.48988 | 37.734658629697705 | -122.385015545451 | (37.7346586296977, -122.385015545451) | ||
4661 | 4661 | 195900 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Carpenter Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 3 | Width 3ft | 6016599.85083 | 2095497.56859 | 37.734768792130296 | -122.385011191836 | (37.7347687921303, -122.385011191836) | ||
4679 | 4679 | 13767 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010614.78099 | 2113901.0025400002 | 37.7849676168973 | -122.407000460322 | (37.7849676168973, -122.407000460322) | |||
4685 | 4685 | 13602 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6012430.86322 | 2115656.01555 | 37.78988792923771 | -122.400840701441 | (37.7898879292377, -122.400840701441) | |||
4772 | 4772 | 13621 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 562 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2001 12:00:00 AM | 12 | 4x4 | 6012346.38681 | 2115564.2725 | 37.7896313121803 | -122.401126534783 | (37.7896313121803, -122.401126534783) | ||
4912 | 4912 | 2851 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008052.73879 | 2116180.4668400004 | 37.791082768494704 | -122.416025815338 | (37.7910827684947, -122.416025815338) | |||
4977 | 4977 | 9927 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2010 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/2013 12:00:00 AM | 2 | 3x3 | 6005187.26248 | 2116638.45302 | 37.792178759685896 | -122.42597288644899 | (37.7921787596859, -122.425972886449) | ||
5075 | 5075 | 2884 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007112.23244 | 2116045.7287 | 37.7906598875046 | -122.419270379518 | (37.7906598875046, -122.419270379518) | |||
5132 | 5132 | 22967 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 545 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 13 | 3x3 | 6006209.68052 | 2106410.0153 | 37.764151681274 | -122.421708472183 | (37.764151681274, -122.421708472183) | ||
5212 | 5212 | 291 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.299980001 | 2093633.8541299999 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | ||
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) | |||
5237 | 5237 | 290 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2017 12:00:00 AM | 25 | 2X2 | 5990524.87284 | 2093730.4583599998 | 37.728439958917704 | -122.47503148863001 | (37.7284399589177, -122.47503148863) | ||
5275 | 5275 | 2881 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1492 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007231.00292 | 2116132.4326400002 | 37.7909046433826 | -122.418865591085 | (37.7909046433826, -122.418865591085) | |||
5278 | 5278 | 13706 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011195.3769 | 2114465.1390299997 | 37.7865490747326 | -122.405031508918 | (37.7865490747326, -122.405031508918) | |||
5285 | 5285 | 9413 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006155.502069999 | 2112496.08819 | 37.7808595218961 | -122.42232830831001 | (37.7808595218961, -122.42232830831) | |||
5287 | 5287 | 2823 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6008783.893069999 | 2116347.56178 | 37.7915826512753 | -122.41350786111401 | (37.7915826512753, -122.413507861114) | |||
5290 | 5290 | 3042 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2659 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X2 | 6001671.4248 | 2115295.2706 | 37.788291401826896 | -122.438041461404 | (37.7882914018269, -122.438041461404) | |||
5313 | 5313 | 13978 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008898.3811 | 2112273.9061 | 37.7804038025089 | -122.412823601853 | (37.7804038025089, -122.412823601853) | |||
5317 | 5317 | 13907 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1066X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6009309.59321 | 2112668.0666400003 | 37.7815091462639 | -122.411428875842 | (37.7815091462639, -122.411428875842) | |||
5364 | 5364 | 23306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/21/2014 12:00:00 AM | 3 | 3x3 | 6006548.97728 | 2113995.14899 | 37.7849977639855 | -122.421073553515 | (37.7849977639855, -122.421073553515) | ||
5396 | 5396 | 13974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008915.5851 | 2112288.8661 | 37.7804458447439 | -122.412765142889 | (37.7804458447439, -122.412765142889) | |||
5397 | 5397 | 9415 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006130.33695 | 2112493.66264 | 37.7808514423711 | -122.422415194499 | (37.7808514423711, -122.422415194499) | |||
5402 | 5402 | 13597 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 540 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1993 12:00:00 AM | 35 | 4x4 | 6012489.6818699995 | 2115699.01218 | 37.7900092684568 | -122.40064021469 | (37.7900092684568, -122.40064021469) | ||
5409 | 5409 | 14070 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007554.9056 | 2110979.1175 | 37.776773123528294 | -122.417379539054 | (37.7767731235283, -122.417379539054) | |||
5412 | 5412 | 13908 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1066 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6009285.42637 | 2112649.60807 | 37.781457107908004 | -122.41151117730699 | (37.781457107908, -122.411511177307) | |||
5420 | 5420 | 13483 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6013580.849640001 | 2116761.03172 | 37.7929861215694 | -122.396939331812 | (37.7929861215694, -122.396939331812) | |||
5425 | 5425 | 23521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005630.35639 | 2119875.62237 | 37.8010922381722 | -122.424670158212 | (37.8010922381722, -122.424670158212) | |||
5427 | 5427 | 13811 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 950 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6009945.3672 | 2113281.8965 | 37.7832302167434 | -122.40927272378201 | (37.7832302167434, -122.409272723782) | |||
5428 | 5428 | 24310 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 6006900.22287 | 2121405.53505 | 37.80536462583971 | -122.420384516339 | (37.8053646258397, -122.420384516339) |
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");