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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2941 | 2941 | 246063 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 657 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | Permit Number 41993 | 5998975.8774 | 2108455.663 | 37.769357942133205 | -122.446875218626 | (37.7693579421332, -122.446875218626) | ||
| 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) | |||
| 3160 | 3160 | 109437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x6 | 6003136.3777 | 2111029.1486 | 37.7766609049 | -122.432668109569 | (37.7766609049, -122.432668109569) | |||
| 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) | |||
| 3185 | 3185 | 3123 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3195 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 5999194.2227 | 2114949.0037 | 37.787199455340705 | -122.44658721654801 | (37.7871994553407, -122.446587216548) | |||
| 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) | |||
| 3277 | 3277 | 3186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3633 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5997046.4391 | 2114650.2263 | 37.7862561763922 | -122.45399645741999 | (37.7862561763922, -122.45399645742) | |||
| 3301 | 3301 | 3014 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3X3 | 6002569.4448 | 2115483.65814 | 37.7888596947603 | -122.43494794241501 | (37.7888596947603, -122.434947942415) | |||
| 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) | |||
| 3391 | 3391 | 2983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2226 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003696.67837 | 2115640.99047 | 37.7893556277051 | -122.431059105706 | (37.7893556277051, -122.431059105706) | |||
| 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) | |||
| 3428 | 3428 | 98728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006156.19882 | 2111456.14926 | 37.778004142027 | -122.42225199096 | (37.778004142027, -122.42225199096) | |||
| 3442 | 3442 | 2868 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1389 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007715.890269999 | 2116130.82655 | 37.790927523941704 | -122.417187783496 | (37.7909275239417, -122.417187783496) | |||
| 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) | |||
| 3452 | 3452 | 2818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6008957.0218 | 2116372.57941 | 37.79166106316271 | -122.412910605154 | (37.7916610631627, -122.412910605154) | |||
| 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) | |||
| 3454 | 3454 | 23347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1245 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 0 | 6006327.19373 | 2114871.36437 | 37.7873911306548 | -122.421903118752 | (37.7873911306548, -122.421903118752) | |||
| 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) | |||
| 3460 | 3460 | 249511 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1243 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006333.62129 | 2114827.84877 | 37.7872720100542 | -122.421877788428 | (37.7872720100542, -122.421877788428) | |||
| 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) | |||
| 3632 | 3632 | 122539 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3443 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779060 | 5998247.97366 | 2115501.74936 | 37.788663053514 | -122.44990087023001 | (37.788663053514, -122.44990087023) | ||
| 3638 | 3638 | 2840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1255 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008320.47773 | 2116218.27733 | 37.7912016363983 | -122.41510212258301 | (37.7912016363983, -122.415102122583) | |||
| 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) | |||
| 3722 | 3722 | 2900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1675 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6006330.22809 | 2115940.35545 | 37.7903264863286 | -122.4219685876 | (37.7903264863286, -122.4219685876) | |||
| 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) | |||
| 3836 | 3836 | 3098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3014 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999901.41366 | 2115112.8463 | 37.7876896938595 | -122.444152274206 | (37.7876896938595, -122.444152274206) | |||
| 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) | |||
| 3891 | 3891 | 2801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009324.7749 | 2116423.80567 | 37.791822353872796 | -122.411641798449 | (37.7918223538728, -122.411641798449) | |||
| 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) | |||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
| 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) | |||
| 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) | |||
| 4313 | 4313 | 2803 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1055 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009318.69522 | 2116357.3469700003 | 37.791639533399795 | -122.41165813642999 | (37.7916395333998, -122.41165813643) | |||
| 4339 | 4339 | 3082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2913 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000319.2838 | 2115099.7465 | 37.7876775552832 | -122.442705587482 | (37.7876775552832, -122.442705587482) | |||
| 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) | |||
| 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) | |||
| 4471 | 4471 | 100799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002438.67863 | 2116735.02721 | 37.7922882071812 | -122.435489929626 | (37.7922882071812, -122.435489929626) | |||
| 4495 | 4495 | 2802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009267.5769 | 2116351.4322900004 | 37.7916204254988 | -122.411834587904 | (37.7916204254988, -122.411834587904) | |||
| 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) | |||
| 4567 | 4567 | 109546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006868.4272 | 2111721.79621 | 37.778773692788 | -122.419806988803 | (37.778773692788, -122.419806988803) | |||
| 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) | |||
| 4621 | 4621 | 122573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2014 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003898.8446 | 2115409.2515 | 37.7887307847056 | -122.430343093484 | (37.7887307847056, -122.430343093484) | |||
| 4628 | 4628 | 3096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3003 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999955.8775 | 2115049.7006 | 37.787519419160795 | -122.443959301682 | (37.7875194191608, -122.443959301682) | |||
| 4639 | 4639 | 102681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001426.627069999 | 2115693.54787 | 37.7893710438761 | -122.43891697256399 | (37.7893710438761, -122.438916972564) | |||
| 4670 | 4670 | 9956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 12 | 4X4 | 6007076.052730001 | 2111529.8614 | 37.7782583803491 | -122.41907511154801 | (37.7782583803491, -122.419075111548) | |||
| 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) | |||
| 4715 | 4715 | 103364 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.79257023366971 | -122.412185363057 | (37.7925702336697, -122.412185363057) | ||
| 4730 | 4730 | 234655 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 437 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x12 | 6002991.56268 | 2105705.90685 | 37.762036373292 | -122.432788699846 | (37.762036373292, -122.432788699846) | |||
| 4737 | 4737 | 18665 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 68 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999650.82657 | 2119343.62461 | 37.799291994198796 | -122.445323565644 | (37.7992919941988, -122.445323565644) | |||
| 4784 | 4784 | 248429 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 735 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998546.7685 | 2108037.7588 | 37.7681859595657 | -122.448329381959 | (37.7681859595657, -122.448329381959) | |||
| 4818 | 4818 | 2858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6007920.97179 | 2116228.0555 | 37.7912060259903 | -122.416485098214 | (37.7912060259903, -122.416485098214) | |||
| 4826 | 4826 | 248398 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 726 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998582.351 | 2108084.2431 | 37.768315627898005 | -122.448209653817 | (37.768315627898, -122.448209653817) | |||
| 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) | |||
| 4955 | 4955 | 253734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4956 | 4956 | 253729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4965 | 4965 | 253732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4968 | 4968 | 253724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4982 | 4982 | 253733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4986 | 4986 | 253726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4993 | 4993 | 253727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5004 | 5004 | 253731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5021 | 5021 | 253725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5028 | 5028 | 253730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5029 | 5029 | 251680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5037 | 5037 | 253728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 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) | |||
| 5139 | 5139 | 235614 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5166 | 5166 | 235615 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5215 | 5215 | 3081 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000297.468780001 | 2115166.83236 | 37.787860511999995 | -122.442785882062 | (37.787860512, -122.442785882062) |
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");