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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 11 | 122658 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 282 | 282 | 173829 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 516 | 516 | 188685 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1300 Evans Ave | 14 | : 4 | Tree 1 | DPW 2 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.857919999 | 2096944.2017700002 | 37.738810795988606 | -122.38074156686301 | (37.7388107959886, -122.380741566863) | ||
| 824 | 824 | 175557 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 80X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | Width 3ft | 5991341.18573 | 2088991.3817 | 37.71547490063521 | -122.471864234655 | (37.7154749006352, -122.471864234655) | ||
| 1045 | 1045 | 21995 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2013 12:00:00 AM | 3 | 3x3 | 6015907.79348 | 2103393.10685 | 37.75641000413321 | -122.38795466567801 | (37.7564100041332, -122.387954665678) | ||
| 1147 | 1147 | 14071 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007529.5869 | 2110959.6416 | 37.7767182228199 | -122.41746574362101 | (37.7767182228199, -122.417465743621) | |||
| 1326 | 1326 | 251502 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 14 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1532 | 1532 | 44561 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1593 | 1593 | 9458 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.780549510570204 | -122.424966344778 | (37.7805495105702, -122.424966344778) | ||
| 1846 | 1846 | 251738 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | ||||
| 2077 | 2077 | 19994 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY46 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 2295 | 2295 | 253005 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2340 | 2340 | 13486 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013525.0360199995 | 2116684.5106599997 | 37.7927729057886 | -122.39712708324801 | (37.7927729057886, -122.397127083248) | |||
| 2536 | 2536 | 141924 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004374.9759 | 2111902.445 | 37.7791289269844 | -122.428445694629 | (37.7791289269844, -122.428445694629) | |||
| 2647 | 2647 | 37826 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.42857143074801 | (37.7201841150858, -122.428571430748) |
| 3127 | 3127 | 253316 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3445 | 3445 | 16362 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1306X Montgomery St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011452.97865 | 2119928.00722 | 37.801563196957204 | -122.40452495315901 | (37.8015631969572, -122.404524953159) | |||
| 3573 | 3573 | 253496 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3628 | 3628 | 127357 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003276.2668 | 2116362.2656799997 | 37.791312234126295 | -122.432565221033 | (37.7913122341263, -122.432565221033) | ||
| 3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3934 | 3934 | 160071 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | ||
| 4281 | 4281 | 139414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:29:00 AM | 3 | Width 0ft | 6004053.5092 | 2114020.2427 | 37.7849256755107 | -122.42970886814301 | (37.7849256755107, -122.429708868143) | ||
| 4465 | 4465 | 253081 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4946 | 4946 | 203011 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 351 Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:43:00 AM | 3 | Width 3ft | 6017451.01363 | 2098542.06983 | 37.7431754271186 | -122.382280137828 | (37.7431754271186, -122.382280137828) | ||
| 5612 | 5612 | 35700 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 5963 | 5963 | 19716 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY13 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 6288 | 6288 | 19736 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY14 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 6640 | 6640 | 18296 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2000 Post St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002180.1869 | 2114026.4257 | 37.7848363976044 | -122.436190393322 | (37.7848363976044, -122.436190393322) | |||
| 6762 | 6762 | 98635 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002251.83785 | 2120250.68488 | 37.8019306734253 | -122.436388130233 | (37.8019306734253, -122.436388130233) | ||
| 6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7080 | 7080 | 20425 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 7407 | 7407 | 19591 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 7629 | 7629 | 109558 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006832.29827 | 2111978.39553 | 37.779476217093396 | -122.419950186976 | (37.7794762170934, -122.419950186976) | |||
| 7673 | 7673 | 13446 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6013993.440330001 | 2117154.58236 | 37.7940896769369 | -122.39553932028 | (37.7940896769369, -122.39553932028) | |||
| 8061 | 8061 | 19756 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY15 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 8607 | 8607 | 1751 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010656.7677 | 2121676.8945 | 37.8063206808441 | -122.40740358257901 | (37.8063206808441, -122.407403582579) | |||
| 8763 | 8763 | 20326 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 101X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 8926 | 8926 | 6195 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005185.2786 | 2113401.5799 | 37.7832910021365 | -122.425749257253 | (37.7832910021365, -122.425749257253) | |||
| 9055 | 9055 | 24107 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 9079 | 9079 | 6769 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1275 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046003 | 37.738846926957706 | -122.382978527185 | (37.7388469269577, -122.382978527185) | ||
| 9271 | 9271 | 24163 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 110X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6016346.0952597 | 2096044.1423308998 | 37.736255534298 | -122.38592660691401 | (37.736255534298, -122.385926606914) | |||
| 9639 | 9639 | 114121 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9844 | 9844 | 48218 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 9947 | 9947 | 11824 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | PUC 13 | 03/13/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9998 | 9998 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10126 | 10126 | 97736 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/2017 12:02:00 PM | 3 | 3x3 | Permit Number 50638 | 6005674.32361 | 2120686.81612 | 37.8033220514443 | -122.424575748272 | (37.8033220514443, -122.424575748272) |
| 10483 | 10483 | 35442 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 10554 | 10554 | 17590 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003668.70994 | 2090393.5126599998 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | |||
| 10593 | 10593 | 26295 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900X San Jose Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999779.73612 | 2092380.76964 | 37.7252660499833 | -122.44294018325701 | (37.7252660499833, -122.442940183257) | ||
| 10680 | 10680 | 48485 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 10838 | 10838 | 77663 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 4 | 3x3 | 6006674.085580001 | 2093407.54115 | 37.7284760037541 | -122.41917984297599 | (37.7284760037541, -122.419179842976) | |
| 11814 | 11814 | 27072 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4 | 6006876.56482 | 2093635.5932900002 | 37.729113586219604 | -122.41849602456699 | (37.7291135862196, -122.418496024567) | |||
| 12126 | 12126 | 27207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.2864400002 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | ||
| 12454 | 12454 | 1277 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992498.771269999 | 2087369.1133 | 37.7110874546035 | -122.46774522006099 | (37.7110874546035, -122.467745220061) | |||
| 12496 | 12496 | 24276 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 350X Winding Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.710003801206796 | -122.438925891137 | (37.7100038012068, -122.438925891137) | |||
| 12522 | 12522 | 44840 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 12529 | 12529 | 19830 | DPW Maintained 3 | Sequoiadendron giganteum :: Sierra Redwood 212 | 100 STAIRWAY25 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60X | ||||||||
| 12578 | 12578 | 45894 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 13261 | 13261 | 144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | ||
| 13426 | 13426 | 20293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
| 13641 | 13641 | 12134 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 8 | 3X3 | 6016411.870630001 | 2095295.2518900002 | 37.734202871273204 | -122.385647014298 | (37.7342028712732, -122.385647014298) | ||
| 13825 | 13825 | 21872 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.38910651286601 | (37.7655055845439, -122.389106512866) | ||
| 13930 | 13930 | 102957 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 303X 02nd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013754.15678 | 2113927.8289900003 | 37.7852164512266 | -122.396141026108 | (37.7852164512266, -122.396141026108) | |||
| 13958 | 13958 | 3709 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016611.7626 | 2099202.9223 | 37.7449436021699 | -122.38522811100201 | (37.7449436021699, -122.385228111002) | |||
| 14283 | 14283 | 11524 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018572.85172 | 2096797.82035 | 37.7384479645089 | -122.378280011831 | (37.7384479645089, -122.378280011831) | |||
| 14650 | 14650 | 13430 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6014204.722019999 | 2117228.6530400002 | 37.7943048073789 | -122.394813447799 | (37.7943048073789, -122.394813447799) | |||
| 14652 | 14652 | 51358 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014110.4538 | 2094404.7193099998 | 37.7316300385939 | -122.393541499766 | (37.7316300385939, -122.393541499766) |
| 14655 | 14655 | 36640 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 14695 | 14695 | 20043 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 14710 | 14710 | 103406 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011568.485 | 2113577.7367 | 37.784133326645396 | -122.403678177607 | (37.7841333266454, -122.403678177607) | |||
| 14818 | 14818 | 35190 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14943 | 14943 | 20364 | DPW Maintained 3 | Acacia decurrens :: Acacia: Silver Wattle 181 | 262X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14984 | 14984 | 46289 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 15037 | 15037 | 14946 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016823.8175 | 2097912.1941299997 | 37.741411254039 | -122.38440497592899 | (37.741411254039, -122.384404975929) | |||
| 15235 | 15235 | 13616 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 555 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6012665.47171 | 2115751.39842 | 37.7901629113271 | -122.40003567332899 | (37.7901629113271, -122.400035673329) | |||
| 15278 | 15278 | 20067 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY54 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 15338 | 15338 | 10922 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1351X Hudson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017030.05127 | 2095928.8894900002 | 37.735976899997 | -122.38355384403299 | (37.735976899997, -122.383553844033) | |||
| 15382 | 15382 | 20449 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 15411 | 15411 | 3504 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017814.43885 | 2098252.58182 | 37.7424006179895 | -122.3810033748 | (37.7424006179895, -122.3810033748) | |||
| 15445 | 15445 | 19918 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 15634 | 15634 | 6666 | DPW Maintained 3 | Celtis occidentalis :: Common Hackberry 292 | 1550 Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015925.87475 | 2098394.93873 | 37.7426870781414 | -122.38754344888001 | (37.7426870781414, -122.38754344888) | |||
| 15734 | 15734 | 6522 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017447.32839 | 2097190.1869 | 37.7394632253474 | -122.382198853519 | (37.7394632253474, -122.382198853519) | |||
| 15808 | 15808 | 49172 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3000 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46290 | 6015923.93892 | 2101255.91631 | 37.750542622948 | -122.387749716469 | (37.750542622948, -122.387749716469) | |
| 15962 | 15962 | 24181 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6016626.73985 | 2095296.12354 | 37.7342171515916 | -122.384904196776 | (37.7342171515916, -122.384904196776) | |||
| 15992 | 15992 | 4049 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012317.265430001 | 2100919.43782 | 37.749418277035296 | -122.400198322911 | (37.7494182770353, -122.400198322911) | |||
| 16046 | 16046 | 29655 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015616.5769 | 2096101.5164 | 37.7363726727082 | -122.388452878787 | (37.7363726727082, -122.388452878787) | ||
| 16230 | 16230 | 11782 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.0959 | 2091855.3897900002 | 37.7233358062868 | -122.472249472731 | (37.7233358062868, -122.472249472731) | ||
| 16375 | 16375 | 22415 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53653 | 6013701.5886 | 2091876.0685 | 37.7246641498069 | -122.39477801609101 | (37.7246641498069, -122.394778016091) | |
| 16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
| 16781 | 16781 | 19615 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 16795 | 16795 | 51115 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 17008 | 17008 | 29970 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.9439400001 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | ||
| 17045 | 17045 | 19792 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY19 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
| 17355 | 17355 | 18407 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6010549.786619999 | 2103464.28095 | 37.7563071414784 | -122.4064896391 | (37.7563071414784, -122.4064896391) | ||
| 17531 | 17531 | 95 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002436.73331 | 2107684.77563 | 37.7674383813948 | -122.434849158187 | (37.7674383813948, -122.434849158187) | |||
| 17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 18146 | 18146 | 47497 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 2550 Lyon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.391583701 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | ||
| 18152 | 18152 | 13559 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 444 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6013042.633150199 | 2116223.6547442 | 37.7914806373756 | -122.39876387205099 | (37.7914806373756, -122.398763872051) |
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");