trees
39,840 rows where qLegalStatus_id = 7 sorted by PermitNotes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4189 | 192124 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 25 | Width 4ft | 6011038.85416 | 2113311.43716 | 37.783372530757 | -122.405491758548 | (37.783372530757, -122.405491758548) | 12 | 2 | 9 | 28853 | 34 | |||
4230 | 25991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1821 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | 3 | 3X3 | 6013865.62853 | 2096292.13024 | 37.7367988747247 | -122.394520028611 | (37.7367988747247, -122.394520028611) | 10 | 3 | 8 | 58 | 1 | ||
4333 | 260669 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
4350 | 261755 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
4429 | 97836 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
4488 | 260665 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
4489 | 97354 | Permitted Site 7 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
4925 | 99065 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 560 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006138.71978 | 2106309.15909 | 37.7638707521361 | -122.421946740307 | (37.7638707521361, -122.421946740307) | 8 | 4 | 5 | 28859 | 19 | |||
5074 | 22216 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4250X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6015384.98643 | 2097123.18461 | 37.7391651289337 | -122.389324913037 | (37.7391651289337, -122.389324913037) | 10 | 3 | 8 | 58 | 1 | ||
5181 | 4830 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 44 | 5x5 | 6006270.256805 | 2097668.3997492 | 37.740152628556 | -122.420878285554 | (37.740152628556, -122.420878285554) | 2 | 7 | 7 | 28859 | 2 | |||
5290 | 89193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
5291 | 95249 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.4815747855 | (37.778566675209, -122.4815747855) | 11 | 6 | 2 | 55 | 26 | ||||
5323 | 104579 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 201X Channel St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6011985.48737 | 2113104.04931 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | 6 | 2 | 9 | 28853 | 34 | ||||
5345 | 4905 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 94 Ardath Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017502.5740617 | 2095232.3549831 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | 10 | 3 | 8 | 58 | 1 | |||
5351 | 108330 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 86 11TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
5358 | 1402 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 62 Ardath Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1996 12:00:00 AM | 12 | 3X4 | 6017428.9119183 | 2095344.9938609 | 37.7343956759938 | -122.382134203041 | (37.7343956759938, -122.382134203041) | 10 | 3 | 8 | 58 | 1 | ||
5364 | 245472 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | 10 | 4 | 7 | 28859 | 19 | |||
5513 | 124042 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 835 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 7ft | 5992827.42703 | 2114798.67685 | 37.786420969756 | -122.468603820853 | (37.786420969756, -122.468603820853) | 11 | 6 | 2 | 54 | 11 | |||
5594 | 106035 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
5635 | 907 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1206 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x6 | 6003162.80838 | 2094269.92054 | 37.7306455348647 | -122.431380036745 | (37.7306455348647, -122.431380036745) | 9 | 7 | 5 | 28861 | 25 | |||
5638 | 89169 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
5642 | 13071 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
5660 | 24445 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2251X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6015765.11922 | 2105348.0588 | 37.7617699797552 | -122.388584545263 | (37.7617699797552, -122.388584545263) | 10 | 3 | 8 | 28856 | 29 | ||
5725 | 260663 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
5822 | 16933 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 530 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3X3 | 6004214.00427 | 2110149.16937 | 37.7743057532085 | -122.428877532014 | (37.7743057532085, -122.428877532014) | 7 | 9 | 11 | 28852 | 10 | |||
5900 | 14792 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 1077 McAllister St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1997 12:00:00 AM | 6 | 4X4 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
5910 | 24288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
5929 | 56671 | Permitted Site 7 | Tree(s) :: 17 | 4019 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003016.37543683 | 2102387.64310455 | 37.7529266215546 | -122.432465865209 | (37.7529266215546, -122.432465865209) | 2 | 4 | 5 | 28862 | 22 | |||||
5931 | 7196 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 949 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003418.39077 | 2111568.89089 | 37.7781588927529 | -122.431731089816 | (37.7781588927529, -122.431731089816) | 15 | 9 | 11 | 29492 | 41 | |||
5996 | 260670 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
6026 | 128070 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009396.36006 | 2121851.96105 | 37.8067307436876 | -122.41177783889 | (37.8067307436876, -122.41177783889) | 3 | 1 | 10 | 308 | 23 | |||
6261 | 128069 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009374.1078 | 2121849.01591 | 37.8067214087259 | -122.411854639205 | (37.8067214087259, -122.411854639205) | 3 | 1 | 10 | 308 | 23 | |||
6276 | 11636 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
6355 | 100391 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6002817 | 2092256 | 37.7250961583897 | -122.432431760897 | (37.7250961583897, -122.432431760897) | 9 | 7 | 6 | 28861 | 5 | ||||
6363 | 12160 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X La Salle Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016105.23501 | 2095780.81201 | 37.7355191499757 | -122.386741010111 | (37.7355191499757, -122.386741010111) | 10 | 3 | 8 | 58 | 1 | |||
6368 | 142137 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997680.98 | 2113001.7737 | 37.7817663225775 | -122.451682166477 | (37.7817663225775, -122.451682166477) | 15 | 6 | 2 | 54 | 16 | |||
6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
6688 | 119707 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 47 Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||||
6693 | 25675 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
6833 | 109426 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Locust St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | 11 | 6 | 1 | 54 | 31 | ||||
7104 | 9470 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
7255 | 14729 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 880 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
7295 | 100582 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
7377 | 14771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
7390 | 27682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.5288809 | 2097124.3937126 | 37.738948976933 | -122.402963228074 | (37.738948976933, -122.402963228074) | 10 | 3 | 8 | 58 | 1 | ||
7405 | 27583 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1781 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001531.97079 | 2112100.50741 | 37.7795114663002 | -122.438294983579 | (37.7795114663002, -122.438294983579) | 15 | 5 | 11 | 29490 | 41 | ||
7488 | 21658 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | 13 | 9 | 11 | 29490 | 13 | |||
7523 | 254506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | 6004702.10653 | 2115410.06007 | 37.7887784716518 | -122.427563979846 | (37.7887784716518, -122.427563979846) | 13 | 9 | 11 | 28858 | 27 | |
7530 | 27369 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
7539 | 100598 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
7552 | 97352 | Permitted Site 7 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
7581 | 9343 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6000760.2622834 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | 2 | 7 | 5 | 63 | 7 | |||
7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
7630 | 24158 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 110X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016346.0952597 | 2096044.1423309 | 37.736255534298 | -122.385926606914 | (37.736255534298, -122.385926606914) | 10 | 3 | 8 | 58 | 1 | |||
7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
7684 | 245413 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | 10 | 4 | 7 | 28859 | 19 | |||
7822 | 26018 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
7892 | 9616 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1050X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002926.42189 | 2111948.31281 | 37.7791727913684 | -122.433460108411 | (37.7791727913684, -122.433460108411) | 15 | 9 | 11 | 29490 | 41 | |||
7907 | 91707 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
7927 | 17200 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006498.35844 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | 7 | 9 | 11 | 28858 | 41 | |||
8003 | 21791 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4X4 | 6008347.28278 | 2121527.17705 | 37.8057800612465 | -122.415385378175 | (37.8057800612465, -122.415385378175) | 5 | 1 | 10 | 308 | 23 | |||
8045 | 260674 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
8130 | 261244 | Permitted Site 7 | :: 45 | 1166 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 3 | 3x3 | 6009198.71093 | 2102367.64119 | 37.75322033811 | -122.41108468628 | (37.75322033811, -122.41108468628) | 2 | 4 | 7 | 28859 | 19 | ||
8157 | 8138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 919 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003262.67464 | 2111347.69223 | 37.7775427083406 | -122.432253966617 | (37.7775427083406, -122.432253966617) | 15 | 9 | 11 | 29492 | 10 | |||
8181 | 192121 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 27 | Width 4ft | 6010922.27002 | 2113199.63335 | 37.783059024392 | -122.405887217429 | (37.783059024392, -122.405887217429) | 12 | 2 | 9 | 28853 | 34 | |||
8241 | 56665 | Permitted Site 7 | Tree(s) :: 17 | 4549 Callan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8260 | 56735 | Permitted Site 7 | Tree(s) :: 17 | 4601 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015154.58866017 | 2096112.48595754 | 37.7363771809952 | -122.390050945039 | (37.7363771809952, -122.390050945039) | 10 | 3 | 8 | 58 | 1 | |||||
8261 | 25749 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
8352 | 84946 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
8379 | 114770 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
8382 | 2324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2298X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1996 12:00:00 AM | 6 | 3X3 | 6009641.4422065 | 2103972.2905262 | 37.7576511632266 | -122.409666876922 | (37.7576511632266, -122.409666876922) | 2 | 4 | 7 | 28859 | 19 | ||
8495 | 1737 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
8550 | 260661 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
8552 | 94478 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 102 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997316 | 2110188 | 37.7740195259569 | -122.452741674918 | (37.7740195259569, -122.452741674918) | 15 | 5 | 11 | 29492 | 16 | |||||
8584 | 21731 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1963 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1997 12:00:00 AM | 3 | 3X3 | 6003249.5114044 | 2114468.5359796 | 37.7861110165037 | -122.432522471352 | (37.7861110165037, -122.432522471352) | 13 | 9 | 11 | 29490 | 13 | ||
8631 | 128082 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009683.35171 | 2121893.27188 | 37.8068602685411 | -122.41078756392 | (37.8068602685411, -122.41078756392) | 3 | 1 | 10 | 308 | 23 | |||
8663 | 258698 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
8752 | 7916 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1225 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005951.06937 | 2114267.1292 | 37.7857108313539 | -122.423161466763 | (37.7857108313539, -122.423161466763) | 13 | 9 | 1 | 28858 | 41 | |||
8799 | 28348 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3136 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008810.2764485 | 2100618.7635013 | 37.748396520659 | -122.412304375108 | (37.748396520659, -122.412304375108) | 2 | 4 | 7 | 28859 | 19 | ||
8873 | 86678 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1099X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.7712762686377 | -122.408451379419 | (37.7712762686377, -122.408451379419) | 8 | 2 | 9 | 28853 | 34 | ||
8874 | 15149 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
8914 | 7995 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2250 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1992 12:00:00 AM | 12 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | ||
8983 | 258699 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
8986 | 8479 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | |||
9026 | 23835 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1302X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1990 12:00:00 AM | 20 | 3X3 | 6003750.8656173 | 2113176.0104319 | 37.7825904834742 | -122.43069565207 | (37.7825904834742, -122.43069565207) | 7 | 9 | 11 | 29490 | 41 | ||
9108 | 116642 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | 6 | 2 | 9 | 28856 | 6 | |||
9119 | 18646 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 55 Reuel Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017250.7089795 | 2096167.8793556 | 37.7366453120483 | -122.382807560554 | (37.7366453120483, -122.382807560554) | 10 | 3 | 8 | 58 | 1 | |||
9221 | 28049 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
9258 | 109525 | Permitted Site 7 | Tree(s) :: 17 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991168.8 | 2098442.9 | 37.7414164276204 | -122.473148952772 | (37.7414164276204, -122.473148952772) | 1 | 8 | 4 | 29491 | 40 | |||||
9326 | 27814 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
9356 | 260660 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
9364 | 27216 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004188.32264 | 2093464.07452 | 37.7284909288141 | -122.427777281084 | (37.7284909288141, -122.427777281084) | 9 | 7 | 6 | 28861 | 5 | |||
9384 | 111852 | Permitted Site 7 | Tree(s) :: 17 | 187 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000958.85547421 | 2106373.84069392 | 37.7637548596233 | -122.439866921627 | (37.7637548596233, -122.439866921627) | 15 | 5 | 5 | 28862 | 3 | |||||
9581 | 28011 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | 4 | 2 | 10 | 28860 | 6 | ||
9595 | 25849 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415 | 37.8022785256437 | -122.400100244504 | (37.8022785256437, -122.400100244504) | 3 | 1 | 10 | 28860 | 6 | ||
9624 | 6769 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1275 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046 | 37.7388469269577 | -122.382978527185 | (37.7388469269577, -122.382978527185) | 10 | 3 | 8 | 58 | 1 | ||
9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );