Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 987 | 987 | 14059 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2017 03:10:00 PM | 3 | 4x4 | 6007777.9052 | 2111198.2219 | 37.7773872760423 | -122.416623639707 | (37.7773872760423, -122.416623639707) | ||
| 1007 | 1007 | 14064 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 08:26:00 AM | 3 | 4x4 | 6007685.3945 | 2111107.6588 | 37.7771334080887 | -122.41693724725599 | (37.7771334080887, -122.416937247256) | ||
| 1008 | 1008 | 14063 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 08:13:00 AM | 3 | 4x4 | 6007701.949 | 2111122.2657 | 37.7771744463261 | -122.416881015003 | (37.7771744463261, -122.416881015003) | ||
| 1315 | 1315 | 231172 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2968 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009727.404 | 2100624.8141099997 | 37.7484645559129 | -122.409133381503 | (37.7484645559129, -122.409133381503) | ||
| 1406 | 1406 | 14313 | Planning Code 138.1 required 4 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2190X Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 3 | 4X4 | Permit Number 779911 | 6003603.86 | 2107219.9092 | 37.7662281664546 | -122.43077904924299 | (37.7662281664546, -122.430779049243) | |
| 1432 | 1432 | 14312 | Planning Code 138.1 required 4 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2190X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 3 | 4X4 | Permit Number 779911 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | |
| 2182 | 2182 | 50728 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3101 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Permit Number 780126 | 5999807.59177 | 2116040.97714 | 37.790232745492894 | -122.444543610603 | (37.7902327454929, -122.444543610603) | ||
| 2264 | 2264 | 14060 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/07/2017 12:00:00 AM | 3 | 4x4 | 6007755.5079 | 2111176.7984 | 37.777327192558104 | -122.41669960143999 | (37.7773271925581, -122.41669960144) | ||
| 2570 | 2570 | 114302 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 435 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780276 | 6014032.20399 | 2111804.00666 | 37.7794003871666 | -122.395030252748 | (37.7794003871666, -122.395030252748) | ||
| 5197 | 5197 | 26974 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 680 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2014 10:25:00 AM | 4 | 3x6 | 6006189.7137 | 2105638.0249799998 | 37.762030851450895 | -122.421722694966 | (37.7620308514509, -122.421722694966) | ||
| 5206 | 5206 | 173938 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 680 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x6 | 6006196.3038013 | 2105654.3539825003 | 37.7620760586794 | -122.421701062175 | (37.7620760586794, -122.421701062175) | ||||
| 10090 | 10090 | 28350 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2014 12:00:00 AM | 3 | 3x3 | 6008724.451452901 | 2100618.392641 | 37.7483906859464 | -122.412601130889 | (37.7483906859464, -122.412601130889) | ||
| 21234 | 21234 | 22945 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 446 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006123.08894 | 2106987.22573 | 37.765731681447605 | -122.42204897584801 | (37.7657316814476, -122.422048975848) | |||
| 32275 | 32275 | 234820 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3400 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006896.083380001 | 2100607.87267 | 37.748259016761395 | -122.418922854526 | (37.7482590167614, -122.418922854526) | |||
| 43140 | 43140 | 234819 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3400 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006915.71417 | 2100607.47009 | 37.748259016735204 | -122.41885494311701 | (37.7482590167352, -122.418854943117) | |||
| 45605 | 45605 | 119614 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2X Sutter St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012582.0 | 2115890.0 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) | ||||
| 54660 | 54660 | 99056 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 524 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006116.39403 | 2106513.2636700002 | 37.764429916035105 | -122.422038458941 | (37.7644299160351, -122.422038458941) | |||
| 55621 | 55621 | 123067 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 604 12th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5992249.446930001 | 2111276.49592 | 37.7767166209192 | -122.470346870506 | (37.7767166209192, -122.470346870506) | |||
| 65802 | 65802 | 99065 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 560 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | |||
| 72732 | 72732 | 123653 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 340 Cornwall St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994489.044480001 | 2114234.6741299997 | 37.7849682162377 | -122.46281415458999 | (37.7849682162377, -122.46281415459) | |||
| 72796 | 72796 | 120364 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 6102 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5988623.48291 | 2114024.14495 | 37.7840505824045 | -122.483091441937 | (37.7840505824045, -122.483091441937) | |||
| 77669 | 77669 | 82541 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 657 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52586 | 6004618.75767182 | 2111536.15402672 | 37.7781369742486 | -122.427576250385 | (37.7781369742486, -122.427576250385) | ||
| 78794 | 78794 | 99079 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 521 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006248.76253 | 2106537.76034 | 37.764504642822104 | -122.421582372033 | (37.7645046428221, -122.421582372033) | |||
| 78797 | 78797 | 13655 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 607 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2016 10:49:00 AM | 3 | 4X4 | 6012064.2714323 | 2115177.7586998 | 37.7885542943226 | -122.402075446971 | (37.7885542943226, -122.402075446971) | ||
| 78962 | 78962 | 99060 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 544 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006121.99737 | 2106412.1378900004 | 37.764152564526896 | -122.42201189412901 | (37.7641525645269, -122.422011894129) | |||
| 79627 | 79627 | 99078 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 523 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006225.8049 | 2106517.90539 | 37.764448831279005 | -122.42166036603001 | (37.764448831279, -122.42166036603) | |||
| 79678 | 79678 | 99063 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 560 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | |||
| 81624 | 81624 | 60113 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 520 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1982 12:00:00 AM | 3 | 3x3 | 6006114.68734 | 2106544.06971 | 37.764514405892704 | -122.42204655054199 | (37.7645144058927, -122.422046550542) | ||
| 82406 | 82406 | 38892 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 84 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773793 | 5995918.72229 | 2113930.22791 | 37.7842145286919 | -122.45784591952801 | (37.7842145286919, -122.457845919528) | |
| 83055 | 83055 | 93969 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 53400 | 6006959.5 | 2100632.2 | 37.7483293848143 | -122.41870528613501 | (37.7483293848143, -122.418705286135) | ||
| 83984 | 83984 | 99076 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 557 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.42150465405199 | (37.764010124676, -122.421504654052) | |||
| 84940 | 84940 | 99096 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 623 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006260.38456 | 2105910.51651 | 37.7627830341769 | -122.42149762452601 | (37.7627830341769, -122.421497624526) | |||
| 84952 | 84952 | 109146 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 6100 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771557 | 5988645.31389 | 2114024.0417 | 37.7840515692549 | -122.483015907997 | (37.7840515692549, -122.483015907997) |
| 85856 | 85856 | 99095 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 657 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006266.8169599995 | 2105777.70576 | 37.7624187297216 | -122.421465944573 | (37.7624187297216, -122.421465944573) | |||
| 86177 | 86177 | 22953 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 460 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x6 | 6006126.2342864005 | 2106915.2740853 | 37.7655342966506 | -122.422032984881 | (37.7655342966506, -122.422032984881) | |||
| 86888 | 86888 | 99064 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 560 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | |||
| 88821 | 88821 | 116973 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 121 SPEAR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777976 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | |
| 90380 | 90380 | 99550 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 200X Henry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/19/2016 04:45:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | |
| 91496 | 91496 | 59944 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 541 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 3 | 3x3 | 6006230.19236 | 2106438.71887 | 37.7642316511634 | -122.421639566353 | (37.7642316511634, -122.421639566353) | ||
| 91639 | 91639 | 99066 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 580 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x6 | 6006132.5426199995 | 2106221.8088700003 | 37.763630560635704 | -122.421961899774 | (37.7636305606357, -122.421961899774) | |||
| 92186 | 92186 | 99059 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 540 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006092.37899 | 2106431.2635 | 37.7642034084393 | -122.422115694531 | (37.7642034084393, -122.422115694531) | |||
| 94161 | 94161 | 54408 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1274 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53914 | 5993646.90937418 | 2106826.38813309 | 37.7645785044123 | -122.465189364979 | (37.7645785044123, -122.465189364979) | |
| 94720 | 94720 | 99075 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 559 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.42150465405199 | (37.764010124676, -122.421504654052) | |||
| 96066 | 96066 | 60112 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 475 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1982 12:00:00 AM | 3 | 3x3 | 6006207.18224 | 2106854.01331 | 37.7653706541631 | -122.421748651963 | (37.7653706541631, -122.421748651963) | ||
| 96631 | 96631 | 22991 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 663 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 5 | 3x3 | 6006244.58019 | 2105713.9704299998 | 37.7622424736555 | -122.421538326696 | (37.7622424736555, -122.421538326696) | ||
| 99022 | 99022 | 70940 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 624 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52586 | 6004809.96249369 | 2111265.27573463 | 37.777404022080795 | -122.426895506614 | (37.7774040220808, -122.426895506614) | ||
| 100739 | 100739 | 14097 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1455 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/2016 12:00:00 AM | 3 | 4X4 | Permit Number 778907 | 6007200.0 | 2110540.0 | 37.7755474375327 | -122.41857612030898 | (37.7755474375327, -122.418576120309) | |
| 102912 | 102912 | 119613 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2X Sutter St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6012582.0 | 2115890.0 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) | |||
| 103672 | 103672 | 113311 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1001x Alemany Blvd | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/09/2015 12:00:00 AM | 20 | Permit Number 776808 | 6003491.75626 | 2094313.44879 | 37.7307836910976 | -122.430245918511 | (37.7307836910976, -122.430245918511) | ||
| 105870 | 105870 | 99067 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 580 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006132.5426199995 | 2106221.8088700003 | 37.763630560635704 | -122.421961899774 | (37.7636305606357, -122.421961899774) | |||
| 107431 | 107431 | 92082 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 67 Ord St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2009 12:00:00 AM | 3x3 | Permit Number 52195 | 6000865.0 | 2106002.3 | 37.7627293574281 | -122.44016489331601 | (37.7627293574281, -122.440164893316) | |||
| 108017 | 108017 | 16724 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1075 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2015 10:17:00 AM | 3 | 4X4 | 6006252.84558 | 2113856.0640000002 | 37.7845991729485 | -122.42208819225701 | (37.7845991729485, -122.422088192257) | ||
| 108020 | 108020 | 99070 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 581 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006252.269090001 | 2106239.1087 | 37.7636848134857 | -122.421549031471 | (37.7636848134857, -122.421549031471) | |||
| 109531 | 109531 | 13953 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1117 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2016 07:38:00 AM | 3 | 4X4 | 6008897.3784125 | 2112157.6718266 | 37.780084594590896 | -122.412818850612 | (37.7800845945909, -122.412818850612) | ||
| 110070 | 110070 | 99093 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 677 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006238.0 | 2105632.0 | 37.762017031056 | -122.421555263176 | (37.762017031056, -122.421555263176) | |||
| 112310 | 112310 | 95267 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2245 Jones St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 113518 | 113518 | 99044 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 461 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006204.27673 | 2106906.45383 | 37.7655144795923 | -122.421762426609 | (37.7655144795923, -122.421762426609) | |||
| 114632 | 114632 | 22957 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 460 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006126.23429 | 2106915.27409 | 37.7655342966637 | -122.422032984869 | (37.7655342966637, -122.422032984869) | |||
| 114636 | 114636 | 99045 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 455 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006201.547730001 | 2106955.70931 | 37.7656495696033 | -122.421775364545 | (37.7656495696033, -122.421775364545) | |||
| 114738 | 114738 | 72735 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3000 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/22/1997 12:00:00 AM | 3x3 | 6009584.26051123 | 2100606.98217244 | 37.748407573185204 | -122.40962711264099 | (37.7484075731852, -122.409627112641) | |||
| 115362 | 115362 | 88804 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 55 Page St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51708 | 6006333.0 | 2111428.0 | 37.7779368220791 | -122.421638371919 | (37.7779368220791, -122.421638371919) | ||
| 115686 | 115686 | 117956 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 851X HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6012435.0 | 2111995.0 | 37.7798358648386 | -122.40056910858499 | (37.7798358648386, -122.400569108585) | |||
| 116048 | 116048 | 99061 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 548 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 6006124.333980001 | 2106369.96474 | 37.764036898784596 | -122.422000816338 | (37.7640368987846, -122.422000816338) | |||
| 116254 | 116254 | 99068 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 580 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006132.5426199995 | 2106221.8088700003 | 37.763630560635704 | -122.421961899774 | (37.7636305606357, -122.421961899774) | |||
| 116409 | 116409 | 99094 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 677 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6006238.0 | 2105632.0 | 37.762017031056 | -122.421555263176 | (37.762017031056, -122.421555263176) | |||
| 117691 | 117691 | 99072 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 567 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006238.6651099995 | 2106285.8034900003 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | |||
| 119350 | 119350 | 99058 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 540 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006092.37899 | 2106431.2635 | 37.7642034084393 | -122.422115694531 | (37.7642034084393, -122.422115694531) | |||
| 119946 | 119946 | 9847 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1295X Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2009 12:00:00 AM | 3 | 3X3 | 6005487.54968 | 2114101.28131 | 37.785229285528104 | -122.424753311633 | (37.7852292855281, -122.424753311633) | ||
| 120787 | 120787 | 99055 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 502 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006083.07455 | 2106599.19361 | 37.7646639800831 | -122.422159807273 | (37.7646639800831, -122.422159807273) | |||
| 121885 | 121885 | 66767 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 623 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/1991 12:00:00 AM | 3 | 3x3 | 6006260.38456 | 2105910.51651 | 37.7627830341769 | -122.42149762452601 | (37.7627830341769, -122.421497624526) | ||
| 122016 | 122016 | 234821 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3400 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006874.27762 | 2100608.63035 | 37.7482598692981 | -122.41899831211799 | (37.7482598692981, -122.418998312118) | |||
| 122298 | 122298 | 91018 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 95 McCoppin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006069.437314 | 2109106.791352 | 37.771548477703 | -122.422385159744 | (37.771548477703, -122.422385159744) | |||
| 122300 | 122300 | 99043 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 475 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006207.18224 | 2106854.01331 | 37.7653706541631 | -122.421748651963 | (37.7653706541631, -122.421748651963) | |||
| 123384 | 123384 | 3295 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 4721 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5992917.64909 | 2114121.4523400003 | 37.784566708473 | -122.468242393585 | (37.784566708473, -122.468242393585) | ||
| 124453 | 124453 | 99080 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 515 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775410 | 6006223.31377 | 2106562.86626 | 37.7645721427534 | -122.42167217581199 | (37.7645721427534, -122.421672175812) | ||
| 124808 | 124808 | 99062 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 548 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006124.333980001 | 2106369.96474 | 37.764036898784596 | -122.422000816338 | (37.7640368987846, -122.422000816338) | |||
| 125367 | 125367 | 13882 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1027 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:40:00 AM | 3 | 4X4 | 6009489.4233125 | 2112722.2987067 | 37.7816681394186 | -122.410810578934 | (37.7816681394186, -122.410810578934) | ||
| 125468 | 125468 | 22958 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 474 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1994 12:00:00 AM | 3 | 3x3 | 6006107.21525 | 2106877.7655599997 | 37.7654302344215 | -122.42209610264601 | (37.7654302344215, -122.422096102646) | ||
| 128621 | 128621 | 99071 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 567 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006238.6651099995 | 2106285.8034900003 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | |||
| 129914 | 129914 | 135631 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3450 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5998366.80455 | 2115231.89384 | 37.787928900046204 | -122.449470282934 | (37.7879289000462, -122.449470282934) | |||
| 138001 | 138001 | 105853 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3440 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2014 12:00:00 AM | 2 | 3x3 | Permit Number 771130 | 5998386.8139 | 2115235.64255 | 37.7879403376223 | -122.449401324733 | (37.7879403376223, -122.449401324733) | |
| 138624 | 138624 | 99048 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 435 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006194.69309 | 2107079.4249400003 | 37.765988876911294 | -122.42180786173901 | (37.7659888769113, -122.421807861739) | |||
| 139790 | 139790 | 93036 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3081 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2010 12:00:00 AM | Permit Number 53145 | 6007764.8 | 2103179.8 | 37.7553698250409 | -122.416100967215 | (37.7553698250409, -122.416100967215) | |||
| 143184 | 143184 | 99077 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 529 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006227.20287 | 2106492.6748 | 37.764379632857 | -122.42165373868099 | (37.764379632857, -122.421653738681) | |||
| 143254 | 143254 | 84694 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 623 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006260.38456 | 2105910.51651 | 37.7627830341769 | -122.42149762452601 | (37.7627830341769, -122.421497624526) | |||
| 144357 | 144357 | 22974 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 601X Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1994 12:00:00 AM | 3 | 3x3 | 6006253.057469999 | 2106023.17246 | 37.76309194781 | -122.421530967732 | (37.76309194781, -122.421530967732) | ||
| 145046 | 145046 | 99074 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 561 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006267.52628 | 2106357.27284 | 37.764010124676 | -122.42150465405199 | (37.764010124676, -122.421504654052) | |||
| 145451 | 145451 | 99073 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 567 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006238.6651099995 | 2106285.8034900003 | 37.7638122593075 | -122.421599400126 | (37.7638122593075, -122.421599400126) | |||
| 145634 | 145634 | 99057 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 538 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006091.16213 | 2106453.2296700003 | 37.7642636537255 | -122.42212146395599 | (37.7642636537255, -122.422121463956) | |||
| 152075 | 152075 | 120830 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 5751 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989723.4779900005 | 2114007.40969 | 37.7840685806486 | -122.479284675494 | (37.7840685806486, -122.479284675494) | |||
| 152102 | 152102 | 3218 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 3838 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1994 12:00:00 AM | 2 | 3X3 | 5995981.806530001 | 2114566.54912 | 37.785965320402 | -122.457673729525 | (37.785965320402, -122.457673729525) | ||
| 153775 | 153775 | 120829 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 5751 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989740.28285 | 2114007.0542200003 | 37.7840685806306 | -122.47922651139099 | (37.7840685806306, -122.479226511391) | |||
| 157921 | 157921 | 103558 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 4201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2013 12:00:00 AM | 11 | 3x3 | Permit Number 769959 | 5994475.898440001 | 2114293.94067 | 37.7851301889308 | -122.46286393654499 | (37.7851301889308, -122.462863936545) | |
| 157940 | 157940 | 124285 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 4201 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994493.43638 | 2114295.92728 | 37.7851366537527 | -122.46280340537201 | (37.7851366537527, -122.462803405372) | |||
| 175225 | 175225 | 103560 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 300X Cornwall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769959 | 5994548.41195 | 2114239.3182200002 | 37.784984386814706 | -122.462609100644 | (37.7849843868147, -122.462609100644) |
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");