Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78616 | 78616 | 106550 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 81 MINERVA ST | Median : Cutout 11 | Tree 1 | DPW 2 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | ||||||
| 91320 | 91320 | 107140 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 250X Roosevelt Way | Median : Cutout 11 | Tree 1 | Private 1 | 08/01/2014 12:00:00 AM | 5x5 | Permit Number 773751 | 6000794.71275 | 2107196.95489 | 37.766005582708395 | -122.440493678393 | (37.7660055827084, -122.440493678393) | |||
| 112663 | 112663 | 114044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 549X ARLINGTON ST | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 6003400.0 | 2095634.0 | 37.734404428182295 | -122.430657330781 | (37.7344044281823, -122.430657330781) | |||||
| 116506 | 116506 | 116066 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 40 MALTA DR | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 5999623.0 | 2096071.0 | 37.7353896244756 | -122.44374699604401 | (37.7353896244756, -122.443746996044) | |||||
| 128796 | 128796 | 109911 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1062X Carolina St | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476001 | (37.7552131559276, -122.39986897476) | |||||
| 142086 | 142086 | 110077 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4099x ALEMANY BLVD | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5991599.0 | 2086829.0 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | |||||
| 787 | 787 | 221428 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.769467407522896 | -122.424551705821 | (37.7694674075229, -122.424551705821) | ||
| 1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1347 | 1347 | 251504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 620x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5992030.0 | 2103590.0 | 37.7555988620986 | -122.470546036282 | (37.7555988620986, -122.470546036282) | ||||
| 1379 | 1379 | 25668 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014174.0749699995 | 2117868.41683 | 37.796059744425996 | -122.394964320767 | (37.796059744426, -122.394964320767) | ||
| 2168 | 2168 | 118346 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 3 | ||||||||
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 2677 | 2677 | 23213 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006690.71989 | 2112642.67217 | 37.7812921821228 | -122.42048713258998 | (37.7812921821228, -122.42048713259) | ||
| 3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
| 3615 | 3615 | 23181 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 520X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006739.72815 | 2112299.86395 | 37.7803536757274 | -122.420293249536 | (37.7803536757274, -122.420293249536) | ||
| 3829 | 3829 | 4634 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 8 | 3 | 6010031.5482 | 2119295.5915 | 37.799747198685004 | -122.40939911161502 | (37.799747198685, -122.409399111615) | ||
| 4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
| 4067 | 4067 | 25799 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | ||
| 4373 | 4373 | 221456 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:59:00 AM | 2 | Width 3ft | 6005491.36744 | 2107155.48275 | 37.7661580255906 | -122.424245934501 | (37.7661580255906, -122.424245934501) | ||
| 4379 | 4379 | 221468 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:37:00 AM | 2 | Width 3ft | 6005525.86145 | 2106563.70328 | 37.764535087455 | -122.42408453767099 | (37.764535087455, -122.424084537671) | ||
| 4411 | 4411 | 221455 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:55:00 PM | 1 | Width 3ft | 6005458.8795300005 | 2107745.71785 | 37.7677768358576 | -122.424400289657 | (37.7677768358576, -122.424400289657) | ||
| 4507 | 4507 | 221494 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:53:00 PM | 2 | Width 3ft | 6005589.49697 | 2105398.2938599996 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | ||
| 5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
| 5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
| 5104 | 5104 | 253785 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5138 | 5138 | 152412 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) | |||
| 5263 | 5263 | 8574 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6001134.4053 | 2113480.9790000003 | 37.783279269060294 | -122.43976932905301 | (37.7832792690603, -122.439769329053) | |||
| 5271 | 5271 | 8390 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.784923768316396 | -122.428202546761 | (37.7849237683164, -122.428202546761) | |||
| 5380 | 5380 | 23543 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2800X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 9 | 6005659.04127 | 2120027.6333 | 37.8015112413055 | -122.424581715282 | (37.8015112413055, -122.424581715282) | |||
| 5624 | 5624 | 23856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003669.3238 | 2113580.0643 | 37.7836952941839 | -122.4310065985 | (37.7836952941839, -122.4310065985) | |||
| 5634 | 5634 | 23786 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 8X8 | 6003813.7072 | 2112544.6294 | 37.780860428691895 | -122.43043318397301 | (37.7808604286919, -122.430433183973) | |||
| 5785 | 5785 | 25798 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.39960734420201 | (37.801354716114, -122.399607344202) | ||
| 5830 | 5830 | 4674 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/05/1991 12:00:00 AM | 15 | 3x4 | 6009400.8826 | 2119872.8379 | 37.8012968187356 | -122.411622263241 | (37.8012968187356, -122.411622263241) | ||
| 5913 | 5913 | 23706 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 8X8 | 6003994.1877 | 2111257.6303 | 37.7773368699173 | -122.42971699343799 | (37.7773368699173, -122.429716993438) | |||
| 5919 | 5919 | 28639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300 Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003713.3264 | 2113228.0439 | 37.7827312275464 | -122.43082923608401 | (37.7827312275464, -122.430829236084) | |||
| 6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
| 6197 | 6197 | 23919 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6x6 | 6003523.3584 | 2114587.3577 | 37.7864527963196 | -122.431583520291 | (37.7864527963196, -122.431583520291) | |||
| 6248 | 6248 | 23822 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6003768.3296 | 2112880.8363 | 37.7817809984294 | -122.430614164895 | (37.7817809984294, -122.430614164895) | |||
| 6368 | 6368 | 8674 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5998029.5545 | 2113103.6387 | 37.7820659737765 | -122.45048361361201 | (37.7820659737765, -122.450483613612) | |||
| 6382 | 6382 | 8738 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3300X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x10 | 5996893.3032 | 2112947.7955 | 37.7815729712314 | -122.45440324333 | (37.7815729712314, -122.45440324333) | |||
| 6534 | 6534 | 23551 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005612.78895 | 2120375.11437 | 37.802462723129395 | -122.424766503478 | (37.8024627231294, -122.424766503478) | ||||
| 6873 | 6873 | 23463 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2300 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 9 | 6005896.8378 | 2118341.60488 | 37.7968952622641 | -122.423638887645 | (37.7968952622641, -122.423638887645) | |||
| 7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
| 7299 | 7299 | 23726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 6 | 6003954.9966 | 2111561.7912 | 37.778169801288904 | -122.42987426911101 | (37.7781698012889, -122.429874269111) | |||
| 7340 | 7340 | 25782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | ||
| 7591 | 7591 | 14429 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113128.5127 | 37.7821804632664 | -122.44769133675501 | (37.7821804632664, -122.447691336755) | |||
| 7649 | 7649 | 4666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 60 | 3 | Permit Number 769286 | 6009738.4106 | 2119565.7843 | 37.8004726529456 | -122.41043256902 | (37.8004726529456, -122.41043256902) | |
| 7655 | 7655 | 4730 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 3x3 | 6007911.57425 | 2121225.41132 | 37.8049269905411 | -122.41687182377 | (37.8049269905411, -122.41687182377) | |||
| 7662 | 7662 | 88451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.805209901088396 | -122.425294529632 | (37.8052099010884, -122.425294529632) | ||
| 7904 | 7904 | 23169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.777486833097896 | -122.419726396954 | (37.7774868330979, -122.419726396954) | |||
| 7940 | 7940 | 29678 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006081.198059999 | 2117033.1392200002 | 37.793312949587396 | -122.42290791419599 | (37.7933129495874, -122.422907914196) | ||||
| 8049 | 8049 | 23281 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6006558.1517199995 | 2113495.8441 | 37.7836273122865 | -122.42100634895901 | (37.7836273122865, -122.421006348959) | |||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 8259 | 8259 | 23442 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2100X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005990.50725 | 2117651.28863 | 37.795005114851 | -122.42326567258301 | (37.795005114851, -122.423265672583) | |||
| 8796 | 8796 | 8530 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.783676377346794 | -122.438063730933 | (37.7836763773468, -122.438063730933) | |||
| 8860 | 8860 | 29672 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006314.6376 | 2115355.15166 | 37.788718782705395 | -122.421980940669 | (37.7887187827054, -122.421980940669) | ||||
| 9024 | 9024 | 17192 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6004636.98078 | 2116874.21207 | 37.792794979656 | -122.42789367737801 | (37.792794979656, -122.427893677378) | |||
| 9327 | 9327 | 122854 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9748 | 9748 | 173655 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | ||||||||||
| 9751 | 9751 | 173659 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 200 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | 5993693.06683 | 2104628.21116 | 37.7585455452803 | -122.46487007071998 | (37.7585455452803, -122.46487007072) | |||||
| 9880 | 9880 | 3771 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1100X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012538.0 | 2102781.0 | 37.75454202913279 | -122.39956569430599 | (37.7545420291328, -122.399565694306) | |||
| 9884 | 9884 | 173718 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 906 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 3x3 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 9890 | 9890 | 3755 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1050 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012450.5971046 | 2103074.0676917997 | 37.7553418567665 | -122.39988853682199 | (37.7553418567665, -122.399888536822) | |||
| 9896 | 9896 | 3746 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 935X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012507.0 | 2103301.0 | 37.755968107630295 | -122.399709410552 | (37.7559681076303, -122.399709410552) | |||
| 9897 | 9897 | 3762 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1068 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012456.0 | 2103003.0 | 37.7551470216138 | -122.39986486171499 | (37.7551470216138, -122.399864861715) | |||
| 9901 | 9901 | 3761 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 1074 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012458.0 | 2102979.0 | 37.755081234351394 | -122.39985625989401 | (37.7550812343514, -122.399856259894) | |||
| 9904 | 9904 | 61559 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1096 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.75477878641421 | -122.399837764002 | (37.7547787864142, -122.399837764002) | ||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9908 | 9908 | 3768 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1098 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 9909 | 9909 | 173722 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 928 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6012423.0 | 2103596.0 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | |||
| 10102 | 10102 | 121489 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2 Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 10105 | 10105 | 121488 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 750 Parnassus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5994725.7235199995 | 2106063.1570900003 | 37.762545022051796 | -122.461402729778 | (37.7625450220518, -122.461402729778) | ||||
| 10227 | 10227 | 173914 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10585 | 10585 | 27651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2700 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982420.6256 | 2096461.5972 | 37.73546591249 | -122.503249937577 | (37.73546591249, -122.503249937577) | ||
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 10607 | 10607 | 27653 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2900X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5981776.6997 | 2096484.8387 | 37.7354918543068 | -122.505477915571 | (37.7354918543068, -122.505477915571) | ||
| 10721 | 10721 | 2286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989102.32398 | 2088689.12288 | 37.714515172905294 | -122.4795805509 | (37.7145151729053, -122.4795805509) | |
| 10890 | 10890 | 24263 | DPW Maintained 3 | Prunus laurocerasus :: English laurel 227 | 300X Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 6001575.13411 | 2086503.1415799998 | 37.7092295937538 | -122.43631322390199 | (37.7092295937538, -122.436313223902) | |||
| 11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
| 11166 | 11166 | 112236 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2400X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/2015 08:45:00 AM | 3 | 5999186.55259 | 2088995.9330400003 | 37.7159382286299 | -122.444747565144 | (37.7159382286299, -122.444747565144) | |||
| 11264 | 11264 | 117179 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.43772698870701 | (37.7094181465037, -122.437726988707) | |||
| 11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
| 11630 | 11630 | 1793 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012296.32723 | 2088174.84774 | 37.7144231111167 | -122.399376144697 | (37.7144231111167, -122.399376144697) | |||
| 11897 | 11897 | 27649 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2500 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982997.5613 | 2096369.9984 | 37.7352483041994 | -122.501248513045 | (37.7352483041994, -122.501248513045) | ||
| 12292 | 12292 | 1840 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011305.78262 | 2087356.70002 | 37.7121213835762 | -122.40274237725401 | (37.7121213835762, -122.402742377254) | |||
| 12298 | 12298 | 27647 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2300 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 5983545.7870000005 | 2096052.8205 | 37.7344095981993 | -122.499329695326 | (37.7344095981993, -122.499329695326) | |||
| 12362 | 12362 | 15901 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | ||
| 12438 | 12438 | 112308 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/06/2015 02:04:00 PM | 3 | 3x3 | 5998782.969959999 | 2088720.9540000001 | 37.715160159502396 | -122.44612276258002 | (37.7151601595024, -122.44612276258) | ||
| 12834 | 12834 | 112320 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/05/2015 03:02:00 PM | 3 | 3x3 | 5998366.80541 | 2088493.52458 | 37.7145119155785 | -122.447544839824 | (37.7145119155785, -122.447544839824) | ||
| 13421 | 13421 | 6561 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350X Evans Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6016932.91962 | 2097582.94738 | 37.740513241395604 | -122.384004813584 | (37.7405132413956, -122.384004813584) | |||
| 13462 | 13462 | 15276 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1563X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.7778199995 | 2109715.95764 | 37.7732881790271 | -122.41831089463699 | (37.7732881790271, -122.418310894637) | ||
| 13947 | 13947 | 29642 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1500X La Salle Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015978.2614 | 2095831.5089 | 37.735651322730796 | -122.387183545032 | (37.7356513227308, -122.387183545032) | ||
| 14379 | 14379 | 48480 | Permitted Site 1 | Tree(s) :: 17 | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 14667 | 14667 | 3750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012463.2126 | 2103693.82662 | 37.7570442824941 | -122.39988842642401 | (37.7570442824941, -122.399888426424) | |||
| 14815 | 14815 | 29657 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 299X Cashmere St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3x3 | 6016930.3488300005 | 2095863.99444 | 37.735793199983796 | -122.38389404137699 | (37.7357931999838, -122.383894041377) |
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");