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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 96470 | 96470 | 76165 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 49 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1996 12:00:00 AM | 6 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | ||
| 96490 | 96490 | 114990 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 222 02ND ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013206.0 | 2114380.0 | 37.786427493175296 | -122.39806922534099 | (37.7864274931753, -122.398069225341) | ||||
| 96495 | 96495 | 107714 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1798X 31st Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | |
| 96506 | 96506 | 100063 | Undocumented 2 | Tree(s) :: 17 | 430X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459.0 | 2112320.0 | 37.780673759287204 | -122.40396841919399 | (37.7806737592872, -122.403968419194) | ||
| 96517 | 96517 | 111911 | Undocumented 2 | Tree(s) :: 17 | 203 14TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991427.0 | 2114042.0 | 37.784262348424896 | -122.473393687159 | (37.7842623484249, -122.473393687159) | ||||
| 96522 | 96522 | 108113 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 786 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x7 | 5998636.0 | 2107697.0 | 37.76725542331079 | -122.447996203185 | (37.7672554233108, -122.447996203185) | ||||
| 96524 | 96524 | 99660 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
| 96532 | 96532 | 102141 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | |
| 96553 | 96553 | 80519 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 96554 | 96554 | 100728 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 96561 | 96561 | 112293 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 501x 27TH AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3xe | 5987510.0 | 2112219.0 | 37.7790293092803 | -122.486811036923 | (37.7790293092803, -122.486811036923) | ||||
| 96564 | 96564 | 101725 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 96572 | 96572 | 106939 | Undocumented 2 | Tree(s) :: 17 | 1607 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2014 12:00:00 AM | 3 | Permit Number 773600 | 5997889.0 | 2108175.0 | 37.768525161365105 | -122.45061442154498 | (37.7685251613651, -122.450614421545) | ||
| 96578 | 96578 | 95515 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | |||
| 96581 | 96581 | 99127 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 10 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96587 | 96587 | 114401 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1X HIGUERA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 96601 | 96601 | 121329 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2401x Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001103.0 | 2113984.0 | 37.784658648156295 | -122.439914057191 | (37.7846586481563, -122.439914057191) | ||||
| 96604 | 96604 | 115832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 30x30 | Permit Number 777501 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | ||
| 96610 | 96610 | 116253 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
| 96615 | 96615 | 117264 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1280 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007807.0 | 2115863.0 | 37.7901972632139 | -122.416853563641 | (37.7901972632139, -122.416853563641) | ||||
| 96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 96634 | 96634 | 113321 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 222 HERMANN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004169.0 | 2108774.0 | 37.7705273263251 | -122.42893514768801 | (37.7705273263251, -122.428935147688) | |||
| 96637 | 96637 | 118362 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 55 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993600.0 | 2115147.0 | 37.78742196799121 | -122.46595625439501 | (37.7874219679912, -122.465956254395) | ||||
| 96638 | 96638 | 99562 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 96661 | 96661 | 110424 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011494.0 | 2097294.0 | 37.739417665451604 | -122.402790273501 | (37.7394176654516, -122.402790273501) | ||||
| 96669 | 96669 | 112123 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 771 WALLER ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 3x3 | 6002060.0 | 2108730.0 | 37.770286913106204 | -122.43622703445601 | (37.7702869131062, -122.436227034456) | ||||
| 96677 | 96677 | 111660 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 96725 | 96725 | 109157 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2016 12:00:00 AM | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | |||
| 96726 | 96726 | 102140 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 199X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6006713.0 | 2098441.9 | 37.742301433197206 | -122.419402316019 | (37.7423014331972, -122.419402316019) | |||
| 96727 | 96727 | 96840 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009512.0 | 2097540.0 | 37.739982262694 | -122.409660545137 | (37.739982262694, -122.409660545137) | |||
| 96731 | 96731 | 187967 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1551 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015595.88641 | 2096776.8147900002 | 37.73822575820571 | -122.38857153857 | (37.7382257582057, -122.38857153857) | |||
| 96732 | 96732 | 189953 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.39301317951201 | (37.7910231956157, -122.393013179512) | |||
| 96733 | 96733 | 210444 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001708.30772 | 2095786.38189 | 37.7347268486656 | -122.436516957196 | (37.7347268486656, -122.436516957196) | |||
| 96734 | 96734 | 194443 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1900 23rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6012732.21441 | 2102858.09004 | 37.7547645253758 | -122.398899455441 | (37.7547645253758, -122.398899455441) | ||||
| 96735 | 96735 | 113809 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 06/15/2016 07:36:00 AM | 3 | 5x5 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
| 96737 | 96737 | 102349 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401X Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842.0 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | |
| 96747 | 96747 | 110879 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 800 INDIANA ST | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 96758 | 96758 | 114514 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5997459.0 | 2105253.0 | 37.7604774702611 | -122.451890918585 | (37.7604774702611, -122.451890918585) | ||||
| 96764 | 96764 | 103431 | Undocumented 2 | Podocarpus henkelii :: Long-Leafed Yellow-Wood 314 | 50X Bluxome St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | ||||
| 96777 | 96777 | 117245 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 GROVE ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||||
| 96784 | 96784 | 106352 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 100 PUTNAM ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009115.8 | 2096842.2 | 37.7380440457606 | -122.410981172443 | (37.7380440457606, -122.410981172443) | |||
| 96786 | 96786 | 98508 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1194 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995108.2 | 2091844.9 | 37.7235272322276 | -122.45905033357201 | (37.7235272322276, -122.459050333572) | ||||
| 96789 | 96789 | 131396 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2225 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002378.707909999 | 2118099.4851900004 | 37.796031249393295 | -122.435795097465 | (37.7960312493933, -122.435795097465) | |||
| 96790 | 96790 | 143451 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501 KEARNY ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6011460.6008 | 2116606.6227 | 37.7924439028882 | -122.404264674229 | (37.7924439028882, -122.404264674229) | |||
| 96791 | 96791 | 223449 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 133 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997855.21004 | 2106781.676 | 37.7646975140134 | -122.45063083107 | (37.7646975140134, -122.45063083107) | |||
| 96792 | 96792 | 129029 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 537 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012209.598259999 | 2117116.91261 | 37.793886861838104 | -122.40170898968701 | (37.7938868618381, -122.401708989687) | |||
| 96793 | 96793 | 224018 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003591.19163 | 2095672.05268 | 37.734519741983 | -122.42999903253299 | (37.734519741983, -122.429999032533) | ||||
| 96794 | 96794 | 137038 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1034 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009796.46818 | 2116817.7113799998 | 37.792930371678096 | -122.41003755358801 | (37.7929303716781, -122.410037553588) | |||
| 96795 | 96795 | 219249 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 493 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5998807.9038 | 2094951.17494 | 37.732268325221206 | -122.446484538256 | (37.7322683252212, -122.446484538256) | |||
| 96802 | 96802 | 95494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.2940599998 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | |||
| 96816 | 96816 | 120943 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 485 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012395.0 | 2105853.0 | 37.762969092752705 | -122.400275979648 | (37.7629690927527, -122.400275979648) | ||||
| 96820 | 96820 | 103428 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50X Bluxome St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | ||||
| 96834 | 96834 | 112165 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 838X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011020.0 | 2113508.0 | 37.7839111917985 | -122.405570835545 | (37.7839111917985, -122.405570835545) | ||||
| 96844 | 96844 | 114629 | Undocumented 2 | :: 54 | 2400X Post St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 96848 | 96848 | 105578 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | ||||
| 96865 | 96865 | 101319 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2-4 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x5 | 6003417.0 | 2108348.0 | 37.7693150407363 | -122.43150590351101 | (37.7693150407363, -122.431505903511) | |||
| 96875 | 96875 | 113665 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1435 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013045.0 | 2106578.0 | 37.7649960058226 | -122.39807870262501 | (37.7649960058226, -122.398078702625) | ||||
| 96878 | 96878 | 114284 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 96884 | 96884 | 116798 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 BROADWAY | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003325.0 | 2117599.0 | 37.7947107530845 | -122.432484978634 | (37.7947107530845, -122.432484978634) | ||||
| 96893 | 96893 | 105172 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 96902 | 96902 | 98541 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002873.0 | 2105350.0 | 37.76105241392221 | -122.433173330823 | (37.7610524139222, -122.433173330823) | ||||
| 96908 | 96908 | 113825 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/10/2015 12:00:00 AM | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
| 96918 | 96918 | 104702 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2590 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003190.5 | 2117454.0 | 37.7943049924865 | -122.43294000213498 | (37.7943049924865, -122.432940002135) | ||||
| 96924 | 96924 | 107250 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 185 Channel St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015121.46625 | 2109958.82043 | 37.7743944293137 | -122.391132995212 | (37.7743944293137, -122.391132995212) | ||||
| 96932 | 96932 | 104334 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1X Beaver St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002844.0 | 2106791.0 | 37.765007405875295 | -122.43337660406901 | (37.7650074058753, -122.433376604069) | ||||
| 96937 | 96937 | 114046 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 303 CORBETT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 10 | 3x3 | Permit Number 777153 | 5999687.0 | 2105217.0 | 37.7605059822191 | -122.44418273029699 | (37.7605059822191, -122.444182730297) | |
| 96944 | 96944 | 116147 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 96951 | 96951 | 100299 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3725 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003062.0 | 2121090.0 | 37.8042812134182 | -122.43364461008001 | (37.8042812134182, -122.43364461008) | |||
| 96961 | 96961 | 97902 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 375X Precita Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
| 96965 | 96965 | 112126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | ||||
| 96969 | 96969 | 109399 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 96974 | 96974 | 112589 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009004.0 | 2110266.0 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | |||||
| 96975 | 96975 | 111311 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
| 96984 | 96984 | 121265 | Undocumented 2 | :: 54 | 3053 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996367.0 | 2111408.0 | 37.777314902031705 | -122.45611263058399 | (37.7773149020317, -122.456112630584) | ||||
| 96989 | 96989 | 95473 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986560.12785 | 2112162.57896 | 37.778818969517495 | -122.490092832211 | (37.7788189695175, -122.490092832211) | ||
| 96995 | 96995 | 111360 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 101x SERRANO DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | 3x3 | 5989748.0 | 2090663.0 | 37.719972434945795 | -122.477493041793 | (37.7199724349458, -122.477493041793) | |||
| 96999 | 96999 | 115142 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
| 97011 | 97011 | 116987 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300x BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6001353.0 | 2109892.0 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | ||||
| 97032 | 97032 | 107363 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168001 | (37.776492606048, -122.41850920168) | |
| 97054 | 97054 | 108861 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015726.4 | 2115025.3 | 37.788339395372795 | -122.38939428020299 | (37.7883393953728, -122.389394280203) | ||||
| 97066 | 97066 | 99466 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
| 97072 | 97072 | 109666 | Undocumented 2 | Tree(s) :: 17 | 2X NIDO AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999244.0 | 2112088.0 | 37.779346725836795 | -122.446209119816 | (37.7793467258368, -122.446209119816) | |||||
| 97076 | 97076 | 116721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1766 25TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5988485.0 | 2103297.0 | 37.7545887414361 | -122.48278413706899 | (37.7545887414361, -122.482784137069) | |||
| 97079 | 97079 | 111873 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010207.0 | 2106863.0 | 37.765620073815604 | -122.407914780785 | (37.7656200738156, -122.407914780785) | ||||
| 97089 | 97089 | 102584 | Undocumented 2 | Tree(s) :: 17 | 22 Gennessee St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | |||||
| 97099 | 97099 | 105690 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X DUBOCE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x10 | 6002306.0 | 2108287.0 | 37.7690845180814 | -122.435344429196 | (37.7690845180814, -122.435344429196) | |||
| 97108 | 97108 | 107627 | Undocumented 2 | Tree(s) :: 17 | 1314 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008979.2 | 2117442.8 | 37.7946008720632 | -122.412909568907 | (37.7946008720632, -122.412909568907) | ||||
| 97109 | 97109 | 113832 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 998X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007963.0 | 2102149.0 | 37.75255062425121 | -122.415342560511 | (37.7525506242512, -122.415342560511) | |||
| 97127 | 97127 | 116618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 345 CHURCH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004348.0 | 2106967.0 | 37.7655758708781 | -122.428187185753 | (37.7655758708781, -122.428187185753) | ||||
| 97134 | 97134 | 122681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
| 97137 | 97137 | 99159 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 43 | Median : Cutout 11 | Tree 1 | Private 1 | 18 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 97154 | 97154 | 103275 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2800X Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | ||||
| 97166 | 97166 | 108352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501x RIVERA ST | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 97168 | 97168 | 106921 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | |||
| 97173 | 97173 | 120543 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2195 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5990654.0 | 2100514.0 | 37.747073311796704 | -122.47508008858802 | (37.7470733117967, -122.475080088588) | |||
| 97211 | 97211 | 113211 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 97218 | 97218 | 122540 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 188 Winfield St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 3x3 | 6006859.0 | 2098426.0 | 37.742265997424504 | -122.418896364118 | (37.7422659974245, -122.418896364118) | |||
| 97226 | 97226 | 99914 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 85 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768764 | 6005244.6 | 2107384.2 | 37.7667720917659 | -122.42511573115299 | (37.7667720917659, -122.425115731153) | |
| 97233 | 97233 | 102718 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1689 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008052.0 | 2108400.0 | 37.7697194320745 | -122.415477297726 | (37.7697194320745, -122.415477297726) |
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");