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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36 | 36 | 13434 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014136.36792 | 2117295.16476 | 37.7944836321678 | -122.39505462349199 | (37.7944836321678, -122.395054623492) | |||
| 55 | 55 | 2909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6006037.49643 | 2115968.63965 | 37.7903876339283 | -122.422983431149 | (37.7903876339283, -122.422983431149) | |||
| 56 | 56 | 27602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X4 | 6003218.3377 | 2111393.5053 | 37.7776659856505 | -122.432410615738 | (37.7776659856505, -122.432410615738) | |||
| 79 | 79 | 251205 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4X4 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||||
| 183 | 183 | 15429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2015 12:00:00 AM | 15 | 4X4 | 6006871.98757 | 2105962.63928 | 37.762960616913205 | -122.41938599878401 | (37.7629606169132, -122.419385998784) | ||
| 273 | 273 | 20166 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | |||
| 309 | 309 | 20164 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | ||
| 325 | 325 | 21670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6004121.8146 | 2114641.2436 | 37.786634655728605 | -122.429516856277 | (37.7866346557286, -122.429516856277) | |||
| 337 | 337 | 14819 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | |||
| 342 | 342 | 21738 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.43394207733601 | (37.7859289122324, -122.433942077336) | |||
| 352 | 352 | 14742 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.779313094037704 | -122.427075791541 | (37.7793130940377, -122.427075791541) | |||
| 397 | 397 | 13004 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | ||
| 414 | 414 | 17191 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1804X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6004806.1465 | 2115088.0891 | 37.7879003042654 | -122.427181073064 | (37.7879003042654, -122.427181073064) | |||
| 425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 428 | 428 | 14314 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6003589.1349 | 2107204.4091 | 37.766184772649495 | -122.430828874247 | (37.7661847726495, -122.430828874247) | |||
| 431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 510 | 510 | 7848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006120.7355 | 2113033.04101 | 37.7823319018231 | -122.422486748168 | (37.7823319018231, -122.422486748168) | |||
| 521 | 521 | 5204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 777 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/21/2016 12:00:00 AM | 3 | 4X4 | 6001528.9942 | 2111019.6475 | 37.7765435284866 | -122.438227828795 | (37.7765435284866, -122.438227828795) | |
| 570 | 570 | 22578 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006396.3025 | 2112828.5224900004 | 37.7817858856438 | -122.421518877095 | (37.7817858856438, -122.421518877095) | |||
| 598 | 598 | 22577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006373.00538 | 2112825.1930299997 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | |||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 686 | 686 | 23735 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.778090453740504 | -122.430059798517 | (37.7780904537405, -122.430059798517) | ||
| 700 | 700 | 6319 | DPW Maintained 3 | Tristania conferta :: 79 | 1860 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001987.058999999 | 2112951.3489 | 37.781873535447396 | -122.436781566115 | (37.7818735354474, -122.436781566115) | |||
| 779 | 779 | 14058 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6007799.3288 | 2111218.6717 | 37.7774446311696 | -122.416550977219 | (37.7774446311696, -122.416550977219) | |||
| 848 | 848 | 2190 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.44062346036199 | (37.7801623757286, -122.440623460362) | |||
| 877 | 877 | 6322 | DPW Maintained 3 | Tristania conferta :: 79 | 1864 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001909.5604 | 2112942.2115 | 37.7818440417219 | -122.43704902046998 | (37.7818440417219, -122.43704902047) | |||
| 884 | 884 | 20233 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1724 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002600.0088 | 2114219.702 | 37.785390928556396 | -122.43475177403499 | (37.7853909285564, -122.434751774035) | |||
| 894 | 894 | 15433 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | |||
| 897 | 897 | 22581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006522.42636 | 2112846.04587 | 37.7818411112169 | -122.42108379139799 | (37.7818411112169, -122.421083791398) | |||
| 931 | 931 | 13827 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 964 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6009845.6649 | 2113195.3529 | 37.7829870022194 | -122.409611544992 | (37.7829870022194, -122.409611544992) | |||
| 941 | 941 | 18512 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010135.39241 | 2115955.1821 | 37.790581064620106 | -122.408803973339 | (37.7905810646201, -122.408803973339) | |||
| 982 | 982 | 18283 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002545.1088 | 2114076.0503 | 37.7849933804768 | -122.434931434249 | (37.7849933804768, -122.434931434249) | ||
| 992 | 992 | 7205 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 926 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | 3 | 4X4 | 6003464.8493 | 2111545.8007 | 37.778098126187295 | -122.431568724094 | (37.7780981261873, -122.431568724094) | ||
| 1004 | 1004 | 14128 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1621 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 09:15:00 AM | 3 | 4X4 | 6006600.23891 | 2109952.2807299998 | 37.7738999176888 | -122.42060911302201 | (37.7738999176888, -122.420609113022) | ||
| 1014 | 1014 | 14130 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1629 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 09:35:00 AM | 3 | 4X4 | 6006499.222 | 2109855.3433 | 37.7736280571205 | -122.420951663899 | (37.7736280571205, -122.420951663899) | ||
| 1028 | 1028 | 13480 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6013615.86639 | 2116768.91037 | 37.7930097035807 | -122.396818723722 | (37.7930097035807, -122.396818723722) | |||
| 1033 | 1033 | 14582 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1157 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999380.4238 | 2108868.5189 | 37.7705146429615 | -122.445505607921 | (37.7705146429615, -122.445505607921) | |||
| 1072 | 1072 | 7266 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | |||
| 1120 | 1120 | 7264 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1730 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003073.6496 | 2114318.6841 | 37.78568958693 | -122.43312019509199 | (37.78568958693, -122.433120195092) | |||
| 1151 | 1151 | 13977 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008909.6011 | 2112263.4341 | 37.780375678658295 | -122.412784045926 | (37.7803756786583, -122.412784045926) | |||
| 1179 | 1179 | 40176 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3591 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | 7 | 4X4 | Permit Number 41367 | 5997123.1138 | 2115994.68514 | 37.7899520976567 | -122.453828309438 | (37.7899520976567, -122.453828309438) | |
| 1214 | 1214 | 14441 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 57 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5998815.3699 | 2112874.8656 | 37.781482766726896 | -122.447748586483 | (37.7814827667269, -122.447748586483) | |||
| 1236 | 1236 | 9417 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 700X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 6 | 4X4 | 6006077.70084 | 2112484.44584 | 37.7808231658948 | -122.422596633642 | (37.7808231658948, -122.422596633642) | ||
| 1267 | 1267 | 18523 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1751X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6009567.6842 | 2119779.6829 | 37.801050393337604 | -122.41103847024901 | (37.8010503933376, -122.411038470249) | |||
| 1300 | 1300 | 14826 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1269 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6003119.6747 | 2111677.9775 | 37.7784414803533 | -122.432772251133 | (37.7784414803533, -122.432772251133) | |||
| 1330 | 1330 | 2943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1946 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 4X4 | 6005029.19291 | 2115824.37334 | 37.7899345671834 | -122.426461819067 | (37.7899345671834, -122.426461819067) | |||
| 1346 | 1346 | 21675 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004079.3213 | 2114634.9946 | 37.7866150915141 | -122.42966342693899 | (37.7866150915141, -122.429663426939) | |||
| 1363 | 1363 | 21606 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | |||
| 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) | |
| 1445 | 1445 | 22600 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005887.44223 | 2112751.69518 | 37.78154623162111 | -122.42327383483999 | (37.7815462316211, -122.42327383484) | |||
| 1504 | 1504 | 21609 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1531 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005037.9058 | 2114711.086 | 37.7868782513618 | -122.42635237507 | (37.7868782513618, -122.42635237507) | ||
| 1644 | 1644 | 14813 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.778579430545896 | -122.431524477475 | (37.7785794305459, -122.431524477475) | |||
| 1724 | 1724 | 14824 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003110.3265 | 2111720.6082 | 37.7785580034409 | -122.43280763628599 | (37.7785580034409, -122.432807636286) | |||
| 1756 | 1756 | 13756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
| 1821 | 1821 | 21741 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2045 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002908.4575 | 2114420.548 | 37.7859599074732 | -122.433698994827 | (37.7859599074732, -122.433698994827) | |||
| 1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
| 1899 | 1899 | 25838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013225.308119999 | 2119220.74162 | 37.7997201038678 | -122.39834219506099 | (37.7997201038678, -122.398342195061) | ||
| 1922 | 1922 | 14822 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003155.2525 | 2111726.3545 | 37.778576329265 | -122.432652630798 | (37.778576329265, -122.432652630798) | |||
| 1971 | 1971 | 21669 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6004141.1865 | 2114642.4934 | 37.7866391841692 | -122.42944992335698 | (37.7866391841692, -122.429449923357) | |||
| 2008 | 2008 | 6077 | DPW Maintained 3 | Tristania conferta :: 79 | 1966 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2007 12:00:00 AM | 18 | 4X4 | 6001073.8278 | 2112479.7581 | 37.7805267238289 | -122.43990709148198 | (37.7805267238289, -122.439907091482) | ||
| 2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
| 2038 | 2038 | 23713 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003942.7402 | 2111225.1787 | 37.7772448524761 | -122.429892651683 | (37.7772448524761, -122.429892651683) | |||
| 2078 | 2078 | 12419 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1691 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6004453.7544 | 2114557.5752 | 37.786423711867705 | -122.42836245915599 | (37.7864237118677, -122.428362459156) | ||
| 2090 | 2090 | 25842 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013279.137069999 | 2119139.97441 | 37.799501334781795 | -122.398150256355 | (37.7995013347818, -122.398150256355) | ||
| 2091 | 2091 | 12295 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 845 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004849.7362 | 2111749.3214 | 37.778735341492705 | -122.426792396306 | (37.7787353414927, -122.426792396306) | |||
| 2158 | 2158 | 251202 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2159 | 2159 | 251203 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2162 | 2162 | 251204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2178 | 2178 | 18161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005286.1585 | 2114461.6714 | 37.7862074506483 | -122.425475720608 | (37.7862074506483, -122.425475720608) | |||
| 2190 | 2190 | 2188 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1045 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000871.5361 | 2112304.371 | 37.7800336381937 | -122.44059432911101 | (37.7800336381937, -122.440594329111) | |||
| 2194 | 2194 | 23455 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005973.83981 | 2118127.35599 | 37.796311335142995 | -122.423357203778 | (37.796311335143, -122.423357203778) | |||
| 2242 | 2242 | 23928 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003464.0168 | 2114669.7894 | 37.7866757692841 | -122.431794715065 | (37.7866757692841, -122.431794715065) | |||
| 2251 | 2251 | 13985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
| 2254 | 2254 | 13986 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
| 2258 | 2258 | 7812 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006212.78826 | 2112695.72596 | 37.7814109097272 | -122.422144314234 | (37.7814109097272, -122.422144314234) | |||
| 2375 | 2375 | 14825 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003082.6395 | 2111715.9066 | 37.7785435236875 | -122.432903080133 | (37.7785435236875, -122.432903080133) | |||
| 2425 | 2425 | 7814 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2015 12:00:00 AM | 4 | 4X4 | 6006210.87703 | 2112746.5205200003 | 37.7815502713788 | -122.422154535912 | (37.7815502713788, -122.422154535912) | ||
| 2578 | 2578 | 21604 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005122.6686 | 2114733.0427 | 37.7869433299583 | -122.426060678785 | (37.7869433299583, -122.426060678785) | |||
| 2681 | 2681 | 10334 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002067.0 | 2109164.0 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | |||
| 2694 | 2694 | 6083 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1981 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4X4 | 6000965.1944 | 2112415.458 | 37.780343987670996 | -122.44027829238199 | (37.780343987671, -122.440278292382) | |||
| 2698 | 2698 | 21631 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004720.5557 | 2114675.0873 | 37.7867614641574 | -122.427447768121 | (37.7867614641574, -122.427447768121) | ||
| 2793 | 2793 | 7815 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006205.55902 | 2112775.31728 | 37.781629040289005 | -122.422174980189 | (37.781629040289, -122.422174980189) | |||
| 2827 | 2827 | 18276 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1950 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002797.4872 | 2114109.7892 | 37.78510034529771 | -122.434060698947 | (37.7851003452977, -122.434060698947) | |||
| 2927 | 2927 | 13682 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6011577.51187 | 2114828.29204 | 37.787567561449706 | -122.403734970715 | (37.7875675614497, -122.403734970715) | |||
| 2928 | 2928 | 18294 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2005 12:00:00 AM | 3 | 4X4 | 6002231.627 | 2114034.293 | 37.7848609216487 | -122.436012990755 | (37.7848609216487, -122.436012990755) | ||
| 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) | ||
| 3089 | 3089 | 2184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1030 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6000920.2689 | 2112277.9741 | 37.779963933965995 | -122.440423847121 | (37.779963933966, -122.440423847121) | |||
| 3107 | 3107 | 18939 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.78936213699829 | -122.438275289198 | (37.7893621369983, -122.438275289198) | |||
| 3114 | 3114 | 25811 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012315.257619999 | 2120560.3270799997 | 37.8033475454092 | -122.401585526252 | (37.8033475454092, -122.401585526252) | ||
| 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) | |||
| 3196 | 3196 | 9420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6005985.41292 | 2112474.4888400002 | 37.780790619431706 | -122.422915195091 | (37.7807906194317, -122.422915195091) | |||
| 3202 | 3202 | 14513 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999073.0679 | 2111076.7771 | 37.776560404910796 | -122.4467276636 | (37.7765604049108, -122.4467276636) | |||
| 3220 | 3220 | 5325 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2880X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001005.78593 | 2115601.06101 | 37.7890931461666 | -122.44036639549 | (37.7890931461666, -122.44036639549) | |||
| 3312 | 3312 | 19273 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1355 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001744.1568 | 2113114.3836 | 37.7823073795972 | -122.437633572993 | (37.7823073795972, -122.437633572993) |
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");