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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123845 | 123845 | 29902 | DPW Maintained 3 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6001149.68281092 | 2114264.52722613 | 37.785431561169794 | -122.439772670022 | (37.7854315611698, -122.439772670022) | ||||||
| 123948 | 123948 | 29904 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||||
| 125111 | 125111 | 91686 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 377 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007415.631785 | 2107493.6887080004 | 37.767195125258105 | -122.417614236777 | (37.7671951252581, -122.417614236777) | |||
| 126115 | 126115 | 91596 | DPW Maintained 3 | Ligustrum ovalifolium :: California privet 284 | 644 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6007464.720587 | 2105907.4049810003 | 37.7628423226144 | -122.41733201971 | (37.7628423226144, -122.41733201971) | ||||
| 126348 | 126348 | 85447 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 126859 | 126859 | 91741 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2844 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) | |||
| 127072 | 127072 | 99201 | Permitted Site 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | FUF 1 | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | ||
| 127204 | 127204 | 91588 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400x South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007384.392817 | 2107339.273033 | 37.76676937816789 | -122.417711341871 | (37.7667693781679, -122.417711341871) | |||
| 128087 | 128087 | 91328 | DPW Maintained 3 | Tree(s) :: 17 | 5089 Mission St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/2007 12:00:00 AM | 3x3 | 6000514.1536 | 2089460.50315 | 37.7172895061936 | -122.44019206138701 | (37.7172895061936, -122.440192061387) | ||||
| 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) | |||||
| 138527 | 138527 | 91786 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 966 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2010 12:00:00 AM | 3 | 3x3 | 6011627.6734110005 | 2111323.517939 | 37.777947073022105 | -122.403314772772 | (37.7779470730221, -122.403314772772) | |||
| 138704 | 138704 | 91592 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 590 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | Permit Number 776895 | 6007446.6064019995 | 2106234.50211 | 37.7637394360724 | -122.41741785273899 | (37.7637394360724, -122.417417852739) | ||
| 139205 | 139205 | 90190 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1844 Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.5559400003 | 37.7766347733354 | -122.47885114584801 | (37.7766347733354, -122.478851145848) | |||
| 139358 | 139358 | 91644 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1343 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007729.450223001 | 2101838.0705560003 | 37.7516837533185 | -122.41612819935499 | (37.7516837533185, -122.416128199355) | |||
| 139726 | 139726 | 98721 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Brotherhood Way | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | ||||||
| 140015 | 140015 | 91683 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 395 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007421.389304 | 2107392.96146 | 37.7669188758381 | -122.41758718246 | (37.7669188758381, -122.41758718246) | |||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 141277 | 141277 | 91676 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 629 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007499.688693 | 2105999.37525 | 37.7630968189144 | -122.417217594449 | (37.7630968189144, -122.417217594449) | |||
| 142077 | 142077 | 91685 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 383 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007417.550958999 | 2107460.112945 | 37.767103042082795 | -122.417605218645 | (37.7671030420828, -122.417605218645) | ||
| 143353 | 143353 | 91621 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1358 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007694.688201 | 2101746.136705 | 37.75142936916011 | -122.416241900686 | (37.7514293691601, -122.416241900686) | |||
| 143372 | 143372 | 91610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | |||
| 143412 | 143412 | 91637 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1459 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007767.503009 | 2101164.985993 | 37.749837754657996 | -122.41594894787701 | (37.749837754658, -122.415948947877) | |||
| 143542 | 143542 | 85442 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 143914 | 143914 | 91643 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1367 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007737.2075620005 | 2101703.6259810003 | 37.751315035107496 | -122.416091852961 | (37.7513150351075, -122.416091852961) | |||
| 145229 | 145229 | 91740 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2840 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008952.188354 | 2101915.380795 | 37.7519647047313 | -122.411905257789 | (37.7519647047313, -122.411905257789) | |||
| 145294 | 145294 | 91738 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2900x Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008972.238365 | 2101556.992621 | 37.7509817758285 | -122.41181059976101 | (37.7509817758285, -122.411810599761) | |||
| 145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
| 12425 | 12425 | 19740 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 10764 | 10764 | 19741 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 6533 | 6533 | 19565 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
| 3026 | 3026 | 19742 | DPW Maintained 3 | Melaleuca spp :: Melaleuca spp 130 | 100 STAIRWAY15 | -9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1OST | ||||||||
| 8903 | 8903 | 19566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
| 6806 | 6806 | 19743 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY15 | -8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1OST | ||||||||
| 11615 | 11615 | 19744 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY15 | -7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1OST | ||||||||
| 9562 | 9562 | 19696 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY9 | -3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 6661 | 6661 | 19920 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY36 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 180863 | 180863 | 218285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | ||||
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
| 24 | 24 | 22346 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 5280 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2014 12:00:00 AM | 3 | 3x3 | 6014341.487000001 | 2093641.8617 | 37.7295482207565 | -122.39268941982701 | (37.7295482207565, -122.392689419827) | ||
| 25 | 25 | 23567 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.337230001 | 2120589.48411 | 37.803046726686894 | -122.42506362870199 | (37.8030467266869, -122.425063628702) | ||
| 32 | 32 | 10933 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1359 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016893.48466 | 2096461.5108299998 | 37.7374318223223 | -122.384063092353 | (37.7374318223223, -122.384063092353) | |||
| 47 | 47 | 17325 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 150 Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/31/2016 12:00:00 AM | 3 | 3x3 | 6006651.4447 | 2108878.4679400004 | 37.7709543699737 | -122.420355751511 | (37.7709543699737, -122.420355751511) | ||
| 72 | 72 | 25725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004286.7153 | 2111148.1106 | 37.777052715887706 | -122.428697236196 | (37.7770527158877, -122.428697236196) | |||
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 109 | 109 | 9895 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | |||
| 117 | 117 | 220007 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.4311599997 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | |
| 123 | 123 | 18916 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | |||
| 137 | 137 | 228561 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006199.77605 | 2105468.2728 | 37.7615653191939 | -122.42167583577299 | (37.7615653191939, -122.421675835773) | |||
| 140 | 140 | 6337 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1916 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001700.9234 | 2112915.307 | 37.7817583075946 | -122.437768878541 | (37.7817583075946, -122.437768878541) | |||
| 141 | 141 | 832 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.50693272862101 | (37.7605442750604, -122.506932728621) | ||
| 149 | 149 | 26071 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 247 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:41:00 PM | 3 | 3X3 | 5993990.1569314 | 2088190.8403771 | 37.7134297247264 | -122.46265023824101 | (37.7134297247264, -122.462650238241) | ||
| 150 | 150 | 11606 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.76045094714279 | -122.507135818078 | (37.7604509471428, -122.507135818078) | ||
| 152 | 152 | 24532 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.50709148147499 | (37.7607233666377, -122.507091481475) | ||
| 153 | 153 | 5972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.43311045884899 | (37.7813844410266, -122.433110458849) | ||
| 154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
| 158 | 158 | 21682 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:00:00 AM | 3 | 4x4 | 6003825.2217 | 2114604.0634 | 37.7865157709252 | -122.43054034167 | (37.7865157709252, -122.43054034167) | ||
| 163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
| 165 | 165 | 11582 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4000 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.760550193841404 | -122.505003612665 | (37.7605501938414, -122.505003612665) | ||
| 173 | 173 | 175044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 5991568.948890001 | 2087568.2224599998 | 37.7115804269636 | -122.470973377029 | (37.7115804269636, -122.470973377029) | |||
| 175 | 175 | 17881 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | |||
| 176 | 176 | 24515 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 07:40:00 AM | 3 | 3X3 | 5997710.2902 | 2109583.0289 | 37.772381016672895 | -122.45133412385 | (37.7723810166729, -122.45133412385) | ||
| 178 | 178 | 2985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2253 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6003588.0004 | 2115559.2302 | 37.789124975971106 | -122.431429279776 | (37.7891249759711, -122.431429279776) | |||
| 179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
| 181 | 181 | 9914 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.42577893234899 | (37.7911641319684, -122.425778932349) | |||
| 182 | 182 | 93463 | DPW Maintained 3 | Prunus x 'Amanogawa' :: Flowering Cherry 57 | 1739 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:05:00 PM | 3 | 3x3 | 5987772.1588 | 2098929.0107 | 37.7425539090053 | -122.48492886712098 | (37.7425539090053, -122.484928867121) | ||
| 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) | ||
| 185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
| 186 | 186 | 138359 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.43386429175101 | (37.7860784126894, -122.433864291751) | |||
| 187 | 187 | 251248 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001839.0 | 2095802.0 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | ||||
| 197 | 197 | 251245 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.73445361741221 | -122.433896153002 | (37.7344536174122, -122.433896153002) | ||||
| 198 | 198 | 103786 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | ||
| 207 | 207 | 138805 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | |||
| 212 | 212 | 138800 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2375 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6002511.9355 | 2115060.8724 | 37.7876955676952 | -122.435116665287 | (37.7876955676952, -122.435116665287) | |||
| 218 | 218 | 11423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | |||
| 227 | 227 | 13622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 562 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6012358.746590001 | 2115584.5782 | 37.789687756343604 | -122.401085198325 | (37.7896877563436, -122.401085198325) | |||
| 234 | 234 | 26932 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1570 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2000 12:00:00 AM | 3 | 3X3 | 6002097.1307 | 2111930.5841 | 37.7790770280177 | -122.43632769328998 | (37.7790770280177, -122.43632769329) | ||
| 237 | 237 | 2654 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1988 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 12 | 3X3 | 6004003.2237 | 2114978.8425 | 37.7875549020514 | -122.429951242636 | (37.7875549020514, -122.429951242636) | ||
| 243 | 243 | 2928 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1834 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005568.20527 | 2115901.70542 | 37.7901773571486 | -122.42460238530501 | (37.7901773571486, -122.424602385305) | |||
| 247 | 247 | 251250 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
| 250 | 250 | 24634 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 507 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2011 12:00:00 AM | 3 | 3x3 | 6001641.187000001 | 2110229.9881 | 37.774381702191896 | -122.437783152308 | (37.7743817021919, -122.437783152308) | ||
| 252 | 252 | 182864 | DPW Maintained 3 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | ||
| 255 | 255 | 19810 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 100 STAIRWAY24 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
| 278 | 278 | 9598 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003113.217999999 | 2112071.7207 | 37.7795222347306 | -122.43282272296999 | (37.7795222347306, -122.43282272297) | |||
| 286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
| 291 | 291 | 129605 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 4ft | 6005928.19437 | 2117729.67294 | 37.79521682154579 | -122.42348685993299 | (37.7952168215458, -122.423486859933) | |||
| 292 | 292 | 9421 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.42259863641199 | (37.7806825946662, -122.422598636412) | |
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 313 | 313 | 230412 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:29:00 AM | 1 | Width 6ft | 6004822.22232 | 2106544.83878 | 37.7644435373721 | -122.426516892666 | (37.7644435373721, -122.426516892666) | ||
| 317 | 317 | 7957 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.791212266380896 | -122.424102272302 | (37.7912122663809, -122.424102272302) | ||
| 319 | 319 | 3139 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3320 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998401.91704 | 2114901.9804700003 | 37.7870250535005 | -122.449325021743 | (37.7870250535005, -122.449325021743) | |||
| 335 | 335 | 244346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005627.7176 | 2110356.4274 | 37.77495474924589 | -122.42400197393101 | (37.7749547492459, -122.424001973931) | |||
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 341 | 341 | 14553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | |||
| 343 | 343 | 244298 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.42408895277501 | (37.7753793775331, -122.424088952775) | |||
| 345 | 345 | 13664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 648 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6011893.33766 | 2115132.41268 | 37.788420242855395 | -122.402663664993 | (37.7884202428554, -122.402663664993) |
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");