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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2203 | 2203 | 8461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1877 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002698.7987 | 2113699.0733 | 37.7839670221208 | -122.43437275514 | (37.7839670221208, -122.43437275514) | |||
| 2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
| 2285 | 2285 | 2664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2018 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003759.2529 | 2114943.4782 | 37.78744398103571 | -122.430792808025 | (37.7874439810357, -122.430792808025) | |||
| 2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
| 2303 | 2303 | 122440 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013669.1059 | 2114077.4124 | 37.785622440131 | -122.39644576664499 | (37.785622440131, -122.396445766645) | ||
| 2314 | 2314 | 138948 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 738 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51651 | 6004303.429 | 2110848.9359 | 37.7762322016228 | -122.428618087069 | (37.7762322016228, -122.428618087069) | |
| 2324 | 2324 | 195018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 778941 | 6013610.320719999 | 2113989.12597 | 37.7853767544813 | -122.39664295660499 | (37.7853767544813, -122.396642956605) | ||
| 2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
| 2456 | 2456 | 201598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020624.74965 | 2092745.3424200001 | 37.7274335141325 | -122.370905303063 | (37.7274335141325, -122.370905303063) | |
| 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) | |||
| 2539 | 2539 | 141221 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3749 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1994 12:00:00 AM | 15 | Width 0ft | Permit Number 33472 | 5996558.7733 | 2114582.8804 | 37.7860432889249 | -122.45567877478399 | (37.7860432889249, -122.455678774784) | |
| 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) | |||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2810 | 2810 | 23452 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2209 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005880.951090001 | 2118079.82441 | 37.796175582497504 | -122.423675237326 | (37.7961755824975, -122.423675237326) | |||
| 2877 | 2877 | 2888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1541 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6007004.32462 | 2116031.27674 | 37.7906141281881 | -122.41964270965201 | (37.7906141281881, -122.419642709652) | |||
| 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) | ||
| 2942 | 2942 | 95170 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1306 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | 6001329.6747 | 2112935.9507 | 37.781793873207 | -122.439054702012 | (37.781793873207, -122.439054702012) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 3415 | 3415 | 58712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 688 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1979 12:00:00 AM | 12 | 3x3 | Permit Number 17946 | 6004581.34636 | 2110890.2862299997 | 37.776361463754604 | -122.427659641397 | (37.7763614637546, -122.427659641397) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 3673 | 3673 | 3073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2880 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1998 12:00:00 AM | 3 | 3X3 | 6000583.9217 | 2115208.18648 | 37.7879903857924 | -122.44179777983999 | (37.7879903857924, -122.44179777984) | ||
| 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) | |||
| 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) | |||
| 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 | ||||||||||
| 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) | ||
| 4198 | 4198 | 25837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013209.63865 | 2119244.79078 | 37.7997852642353 | -122.39839810591299 | (37.7997852642353, -122.398398105913) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 4842 | 4842 | 53619 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2635 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1969 12:00:00 AM | 14 | 6x9 | Permit Number 6550 | 6001139.602580001 | 2117434.01333 | 37.794133574667 | -122.44003489281 | (37.794133574667, -122.44003489281) | |
| 4897 | 4897 | 27584 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1785 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2000 12:00:00 AM | 3 | 3X3 | 6001489.4944 | 2112142.9438 | 37.77962556986321 | -122.43844496845199 | (37.7796255698632, -122.438444968452) | ||
| 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) | |||
| 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) | ||||
| 5033 | 5033 | 69190 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1994 12:00:00 AM | 12 | 3x3 | Permit Number 33233 | 6002598.67193 | 2116757.13717 | 37.7923580008738 | -122.43493793203501 | (37.7923580008738, -122.434937932035) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 5274 | 5274 | 58105 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1977 12:00:00 AM | 5 | Permit Number 17081 | 6006591.68402 | 2113670.96002 | 37.7841100278879 | -122.42090277676701 | (37.7841100278879, -122.420902776767) | ||
| 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) | |||
| 5283 | 5283 | 2897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1635 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6006502.249530001 | 2115965.50958 | 37.7904052534492 | -122.42137519153098 | (37.7904052534492, -122.421375191531) | |||
| 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) | |||
| 5305 | 5305 | 3116 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3151 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999317.7381 | 2114962.1143 | 37.7872425080555 | -122.44616082493799 | (37.7872425080555, -122.446160824938) | |||
| 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) | |||
| 5319 | 5319 | 2956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2022 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004492.42277 | 2115751.35307 | 37.7897037139057 | -122.428313790248 | (37.7897037139057, -122.428313790248) | |||
| 5362 | 5362 | 3137 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3302 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X3 | 5998543.29371 | 2114921.59911 | 37.787087006913296 | -122.44883730591002 | (37.7870870069133, -122.44883730591) | |||
| 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) | ||
| 5376 | 5376 | 112253 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3401 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998472.27762 | 2115859.72352 | 37.789658787381796 | -122.449150614422 | (37.7896587873818, -122.449150614422) | |||
| 5391 | 5391 | 27795 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | |||
| 5394 | 5394 | 2865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6007816.79371 | 2116213.72438 | 37.7911608170581 | -122.41684453654699 | (37.7911608170581, -122.416844536547) | |||
| 5398 | 5398 | 98494 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2820 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999556.928169999 | 2118555.98315 | 37.79712398054429 | -122.44559181541099 | (37.7971239805443, -122.445591815411) | |||
| 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) | |||
| 5426 | 5426 | 2882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1499 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6007281.77747 | 2116069.5098599996 | 37.7907347317813 | -122.418685448789 | (37.7907347317813, -122.418685448789) | |||
| 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) | ||||
| 5448 | 5448 | 2975 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2186 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5.5x6 | 6003908.99091 | 2115672.8385 | 37.7894551026272 | -122.430326802143 | (37.7894551026272, -122.430326802143) | |||
| 5468 | 5468 | 3007 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2383 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 2X3 | 6003000.8179 | 2115475.95 | 37.788863013488296 | -122.433454901543 | (37.7888630134883, -122.433454901543) |
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");