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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 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) | |||
| 1354 | 1354 | 14491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 320 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999051.991 | 2111710.9656 | 37.77830051932229 | -122.446846219186 | (37.7783005193223, -122.446846219186) | |||
| 1760 | 1760 | 14433 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113100.4237 | 37.7821033381799 | -122.447689314061 | (37.7821033381799, -122.447689314061) | |||
| 2388 | 2388 | 12913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | |||
| 2882 | 2882 | 91783 | Permitted Site 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1098 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 50 | 3x3 | Permit Number 780455 | 6010858.01421 | 2110604.57271 | 37.775930000492295 | -122.405926650895 | (37.7759300004923, -122.405926650895) | |
| 3078 | 3078 | 13812 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 950 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6009942.8788 | 2113250.7921 | 37.783144672032705 | -122.409279136989 | (37.7831446720327, -122.409279136989) | |||
| 3161 | 3161 | 13804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6010106.2877 | 2113414.5576 | 37.7836034869676 | -122.408725362824 | (37.7836034869676, -122.408725362824) | |||
| 3407 | 3407 | 11127 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2124 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007196.70195 | 2119630.59252 | 37.8005077858571 | -122.419232523471 | (37.8005077858571, -122.419232523471) | |||
| 3453 | 3453 | 13461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6013807.91636 | 2116979.13322 | 37.793597613798205 | -122.39616895543199 | (37.7935976137982, -122.396168955432) | |||
| 4874 | 4874 | 14465 | Permitted Site 1 | Tristania conferta :: 79 | 161 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 50 | 3X3 | 5998884.4079 | 2112430.1793 | 37.7802657190757 | -122.447477731101 | (37.7802657190757, -122.447477731101) | ||
| 5115 | 5115 | 14434 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998899.8061 | 2113051.3525 | 37.781972179426205 | -122.447469186406 | (37.7819721794262, -122.447469186406) | |||
| 5180 | 5180 | 17545 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6003118.2023599995 | 2090743.3942599997 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | |||
| 5427 | 5427 | 13811 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 950 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6009945.3672 | 2113281.8965 | 37.7832302167434 | -122.40927272378201 | (37.7832302167434, -122.409272723782) | |||
| 5566 | 5566 | 13772 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6010514.83109 | 2113811.67367 | 37.784716747429705 | -122.407339957096 | (37.7847167474297, -122.407339957096) | |||
| 5682 | 5682 | 13731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 790 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6010961.918819999 | 2114232.87696 | 37.7858982848269 | -122.405822853842 | (37.7858982848269, -122.405822853842) | |||
| 5836 | 5836 | 13473 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6013706.15882 | 2116857.71478 | 37.793258564891296 | -122.39651253244699 | (37.7932585648913, -122.396512532447) | |||
| 6047 | 6047 | 2853 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6008034.06257 | 2116243.44683 | 37.7912546460273 | -122.41609489677 | (37.7912546460273, -122.41609489677) | |||
| 6061 | 6061 | 14540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 712 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999232.8618 | 2110380.1211 | 37.7746566927117 | -122.44612477022 | (37.7746566927117, -122.44612477022) | |||
| 6073 | 6073 | 14456 | Permitted Site 1 | Tristania conferta :: 79 | 135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 50 | 3X3 | 5998867.4868 | 2112526.9679 | 37.7805305084906 | -122.447543237813 | (37.7805305084906, -122.447543237813) | ||
| 6159 | 6159 | 14633 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6006339.54974 | 2112172.36964 | 37.7799810497133 | -122.42166859715401 | (37.7799810497133, -122.421668597154) | |||
| 6231 | 6231 | 8155 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1060 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6002678.2452 | 2111319.127 | 37.7774311210584 | -122.43427365855801 | (37.7774311210584, -122.434273658558) | |||
| 6658 | 6658 | 8058 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 620 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/1990 12:00:00 AM | 50 | 3X3 | 6004694.498 | 2111602.1691 | 37.778322519175404 | -122.427318940841 | (37.7783225191754, -122.427318940841) | ||
| 6728 | 6728 | 2800 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6009359.64856 | 2116429.6762900003 | 37.7918404293366 | -122.411521550081 | (37.7918404293366, -122.411521550081) | |||
| 6783 | 6783 | 14432 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998887.9614 | 2113022.2482 | 37.781891589698894 | -122.44750806785801 | (37.7818915896989, -122.447508067858) | |||
| 7003 | 7003 | 14431 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998857.8418 | 2113111.93 | 37.7821361113043 | -122.44761872504499 | (37.7821361113043, -122.447618725045) | |||
| 7514 | 7514 | 14490 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998985.0486 | 2111710.2278 | 37.7782946690144 | -122.44707774367399 | (37.7782946690144, -122.447077743674) | |||
| 7555 | 7555 | 107448 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1111x Chestnut St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 50 | 6006408.68895 | 2120404.8626200003 | 37.80258932431129 | -122.42201440535801 | (37.8025893243113, -122.422014405358) | ||||
| 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) | |||
| 7776 | 7776 | 13732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 790 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6010940.093830001 | 2114213.64573 | 37.785844259855 | -122.40589700746 | (37.785844259855, -122.40589700746) | |||
| 7865 | 7865 | 4751 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007679.06678 | 2121391.72732 | 37.8053705712658 | -122.41768823913601 | (37.8053705712658, -122.417688239136) | |||
| 7935 | 7935 | 14631 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6006386.244469999 | 2112179.55054 | 37.7800033996804 | -122.42150756902299 | (37.7800033996804, -122.421507569023) | |||
| 7983 | 7983 | 8157 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1082 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002625.6202 | 2111311.5222 | 37.7774072530977 | -122.434455161682 | (37.7774072530977, -122.434455161682) | |||
| 8088 | 8088 | 12909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007780.304959999 | 2112111.9572400004 | 37.779896309296 | -122.41668008474 | (37.779896309296, -122.41668008474) | |||
| 8315 | 8315 | 12912 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007764.05578 | 2112272.8599900003 | 37.7803371956541 | -122.41674770026 | (37.7803371956541, -122.41674770026) | |||
| 8540 | 8540 | 11128 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2124 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007192.56875 | 2119648.8163799997 | 37.8005575912102 | -122.419248119507 | (37.8005575912102, -122.419248119507) | |||
| 8807 | 8807 | 2824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6008730.99842 | 2116340.95502 | 37.7915615405744 | -122.413690409105 | (37.7915615405744, -122.413690409105) | |||
| 8895 | 8895 | 13001 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 358 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6010595.8219 | 2120678.6024 | 37.8035762063453 | -122.40754406865801 | (37.8035762063453, -122.407544068658) | |||
| 8933 | 8933 | 11077 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1814 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007344.39796 | 2118579.88238 | 37.797631116330294 | -122.418646882241 | (37.7976311163303, -122.418646882241) | |||
| 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) | |||
| 10684 | 10684 | 1109 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2362 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5999292.86989 | 2089155.09159 | 37.716381308429206 | -122.44439151548201 | (37.7163813084292, -122.444391515482) | |||
| 10722 | 10722 | 17551 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003191.74591 | 2090695.7695400002 | 37.720833355450104 | -122.43102499890699 | (37.7208333554501, -122.431024998907) | |||
| 10729 | 10729 | 17592 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.42943389227699 | (37.7200700675728, -122.429433892277) | |||
| 10917 | 10917 | 17498 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.43487036238501 | (37.72266164479, -122.434870362385) | |||
| 11249 | 11249 | 17536 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.72114791043521 | -122.431654537837 | (37.7211479104352, -122.431654537837) | |||
| 11325 | 11325 | 17624 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | |||
| 11403 | 11403 | 1077 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2125 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6000118.830569999 | 2089820.5947599998 | 37.7182557213131 | -122.44158433025 | (37.7182557213131, -122.44158433025) | |||
| 11442 | 11442 | 17221 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1875X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6001098.52222 | 2091140.53503 | 37.7219357480204 | -122.438292468038 | (37.7219357480204, -122.438292468038) | |||
| 11596 | 11596 | 17497 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.43491976573401 | (37.7226823390961, -122.434919765734) | |||
| 11697 | 11697 | 834 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5981553.6693 | 2105499.8181 | 37.760231333592294 | -122.50691749005101 | (37.7602313335923, -122.506917490051) | |||
| 11705 | 11705 | 975 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1599 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X5 | 6001957.29298 | 2093112.49768 | 37.727399119572794 | -122.43546491497 | (37.7273991195728, -122.43546491497) | |||
| 12027 | 12027 | 17535 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003034.530590001 | 2090798.32089 | 37.721106028988295 | -122.431575761713 | (37.7211060289883, -122.431575761713) | |||
| 12167 | 12167 | 17220 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 1875X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6001085.65168 | 2091116.1737099998 | 37.7218681252969 | -122.438335213721 | (37.7218681252969, -122.438335213721) | |||
| 12701 | 12701 | 17544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 537 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003083.60804 | 2090766.94886 | 37.7210226699524 | -122.431403876997 | (37.7210226699524, -122.431403876997) | |||
| 12833 | 12833 | 17553 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.720753626054204 | -122.430852753549 | (37.7207536260542, -122.430852753549) | |||
| 13029 | 13029 | 17562 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 645 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003332.52001 | 2090606.8773 | 37.72059725284729 | -122.43053204633001 | (37.7205972528473, -122.43053204633) | |||
| 13153 | 13153 | 17626 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004454.014359999 | 2089904.4684 | 37.718732059816205 | -122.42660540034099 | (37.7187320598162, -122.426605400341) | |||
| 13280 | 13280 | 10220 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | |||
| 13699 | 13699 | 13685 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6011605.93559 | 2114739.03384 | 37.787324067301995 | -122.403630347164 | (37.787324067302, -122.403630347164) | |||
| 13717 | 13717 | 13537 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6013088.261530001 | 2116152.33019 | 37.7912873390898 | -122.398600990256 | (37.7912873390898, -122.398600990256) | |||
| 14021 | 14021 | 13968 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1145 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6008706.3204 | 2111956.376 | 37.779521158387205 | -122.41346556880501 | (37.7795211583872, -122.413465568805) | |||
| 14357 | 14357 | 13683 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6011565.29431 | 2114703.6148099997 | 37.7872245447143 | -122.403768465047 | (37.7872245447143, -122.403768465047) | |||
| 16003 | 16003 | 13510 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6013308.02356 | 2116362.92667 | 37.7918778285438 | -122.39785539292299 | (37.7918778285438, -122.397855392923) | |||
| 16912 | 16912 | 10519 | Permitted Site 1 | Tristania conferta :: 79 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.76935837855329 | -122.45256673963301 | (37.7693583785533, -122.452566739633) | |||
| 16984 | 16984 | 10523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.769207770213704 | -122.452685140494 | (37.7692077702137, -122.452685140494) | |||
| 16993 | 16993 | 5362 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.4691 | 2106941.40414 | 37.765531294370106 | -122.42661345466999 | (37.7655312943701, -122.42661345467) | |||
| 17237 | 17237 | 26912 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5997598.31865 | 2089637.50605 | 37.7176090763688 | -122.450283439137 | (37.7176090763688, -122.450283439137) | |||
| 17327 | 17327 | 5361 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004801.1830400005 | 2106961.82172 | 37.7655872834524 | -122.42661935690901 | (37.7655872834524, -122.426619356909) | |||
| 17340 | 17340 | 24355 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 131 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 50 | 2X2 | 6005829.728569999 | 2108452.61754 | 37.76973874826871 | -122.423167819151 | (37.7697387482687, -122.423167819151) | ||
| 17375 | 17375 | 24541 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6007668.223019999 | 2097198.66884 | 37.7389415501992 | -122.416011415406 | (37.7389415501992, -122.416011415406) | |||
| 17382 | 17382 | 10079 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | |||
| 17431 | 17431 | 5364 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004803.911280001 | 2106914.7530400003 | 37.765458198358495 | -122.42660656853701 | (37.7654581983585, -122.426606568537) | |||
| 17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
| 17546 | 17546 | 25011 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 500X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004936.76982 | 2105288.28685 | 37.7609998192165 | -122.426031247048 | (37.7609998192165, -122.426031247048) | |||
| 17585 | 17585 | 5497 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 750 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004967.58 | 2103908.86443 | 37.7572139917372 | -122.425826498419 | (37.7572139917372, -122.425826498419) | |||
| 17769 | 17769 | 14349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2278X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6003068.0497 | 2106704.5045 | 37.7647826186219 | -122.432595493714 | (37.7647826186219, -122.432595493714) | |||
| 17907 | 17907 | 13992 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1159X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6008630.343100499 | 2111901.9984248 | 37.7793675842244 | -122.413724560263 | (37.7793675842244, -122.413724560263) | |||
| 18120 | 18120 | 25009 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004942.008669999 | 2105066.11314 | 37.7603900788595 | -122.425997312043 | (37.7603900788595, -122.425997312043) | |||
| 18163 | 18163 | 24539 | Landmark tree 9 | Celtis occidentalis :: Common Hackberry 292 | 500X Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6007622.1254900005 | 2097206.54003 | 37.738960570878795 | -122.41617135711999 | (37.7389605708788, -122.41617135712) | |||
| 18217 | 18217 | 10091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.759755882347704 | -122.42374079792299 | (37.7597558823477, -122.423740797923) | ||
| 18248 | 18248 | 5692 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1546 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005220.41395 | 2099376.74782 | 37.7447841325786 | -122.42462971298401 | (37.7447841325786, -122.424629712984) | |||
| 18672 | 18672 | 5363 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.21847 | 2106929.2313599996 | 37.7654978566596 | -122.426613454658 | (37.7654978566596, -122.426613454658) | |||
| 18738 | 18738 | 17618 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6004182.578886599 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | |||
| 18859 | 18859 | 10484 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1668 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998167.2674 | 2108607.159 | 37.7697276834376 | -122.449683068712 | (37.7697276834376, -122.449683068712) | |||
| 19260 | 19260 | 10391 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1365 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1994 12:00:00 AM | 50 | 3X3 | 5999672.3842 | 2108766.3656 | 37.770250819058795 | -122.44448837538401 | (37.7702508190588, -122.444488375384) | ||
| 19376 | 19376 | 10521 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997344.2343 | 2108442.9441 | 37.769229670497 | -122.452518048778 | (37.769229670497, -122.452518048778) | |||
| 19765 | 19765 | 16171 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 427 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999238.94733 | 2094646.5725200002 | 37.731456569253396 | -122.444972438847 | (37.7314565692534, -122.444972438847) | |||
| 19971 | 19971 | 4446 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1355 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6004542.014880001 | 2100967.34778 | 37.749113216203 | -122.427088759848 | (37.749113216203, -122.427088759848) | |||
| 20070 | 20070 | 4445 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1351 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004542.9935 | 2100988.75138 | 37.749172040866206 | -122.427086900064 | (37.7491720408662, -122.427086900064) | |||
| 20525 | 20525 | 14339 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2264 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6003136.1842 | 2106767.6291 | 37.7649598071295 | -122.432364343132 | (37.7649598071295, -122.432364343132) | |||
| 20768 | 20768 | 5741 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1750 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 5X5 | 6005288.046019999 | 2098210.73493 | 37.741586345728706 | -122.424312938514 | (37.7415863457287, -122.424312938514) | |||
| 21055 | 21055 | 5523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 865 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005084.41522 | 2103351.40166 | 37.755689931362795 | -122.425382766602 | (37.7556899313628, -122.425382766602) | |||
| 21304 | 21304 | 5736 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1735 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005366.76903 | 2098271.84228 | 37.74175857761 | -122.424045085308 | (37.74175857761, -122.424045085308) | |||
| 21322 | 21322 | 5360 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004798.07492 | 2106976.61217 | 37.765627718772 | -122.42663116052499 | (37.765627718772, -122.426631160525) | |||
| 21350 | 21350 | 5101 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2629 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6002336.13825 | 2096372.73058 | 37.7363724838986 | -122.43438824303101 | (37.7363724838986, -122.434388243031) | |||
| 21449 | 21449 | 24540 | Landmark tree 9 | Celtis occidentalis :: Common Hackberry 292 | 500X Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6007652.968230001 | 2097201.05938 | 37.7389472564055 | -122.416064328819 | (37.7389472564055, -122.416064328819) | |||
| 21506 | 21506 | 25050 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 900X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005068.237380001 | 2102929.64641 | 37.7545309759388 | -122.425408702171 | (37.7545309759388, -122.425408702171) | |||
| 21526 | 21526 | 16916 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 484 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004686.86681 | 2110208.72077 | 37.7744960198036 | -122.42724605576599 | (37.7744960198036, -122.427246055766) | |||
| 21614 | 21614 | 5746 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1765 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 50 | 3x3 | 6005379.08907 | 2098105.72339 | 37.74130314832521 | -122.42399067635401 | (37.7413031483252, -122.423990676354) | ||
| 21782 | 21782 | 10227 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005821.31625 | 2100751.5734599996 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) |
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");