Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112275 | 112275 | 100071 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 96X Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Address is 4200-4204 17th St | 6001034.7 | 2105837.1 | 37.7622854187027 | -122.439566119284 | (37.7622854187027, -122.439566119284) | |||
| 114221 | 114221 | 100072 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 96X Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Address is 1200-1204 17th St | 6001034.7 | 2105837.1 | 37.7622854187027 | -122.439566119284 | (37.7622854187027, -122.439566119284) | |||
| 142899 | 142899 | 100073 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 930@ Lorraine Ct Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2012 12:00:00 AM | 3x3 | Permit Number 769060 | 5996162.0 | 2112255.0 | 37.7796287713947 | -122.45688306406099 | (37.7796287713947, -122.456883064061) | ||
| 81746 | 81746 | 100074 | Undocumented 2 | Tree(s) :: 17 | 701 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003070.0 | 2104166.0 | 37.7578126071811 | -122.43240742658399 | (37.7578126071811, -122.432407426584) | ||||||
| 144263 | 144263 | 100075 | Undocumented 2 | Tree(s) :: 17 | 707-709 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003067.0 | 2104139.0 | 37.757738301523105 | -122.43241587342699 | (37.7577383015231, -122.432415873427) | |||||
| 108919 | 108919 | 100076 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 262 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776532 | 5990584.51145 | 2113652.92092 | 37.783145223942 | -122.47627994024201 | (37.783145223942, -122.476279940242) | |
| 108144 | 108144 | 100077 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 260 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005310.0 | 2109942.0 | 37.7737988894613 | -122.42507153447501 | (37.7737988894613, -122.425071534475) | ||||
| 122707 | 122707 | 100078 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 266 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776410 | 5990586.53381 | 2113609.7978 | 37.7830269371305 | -122.47626979286501 | (37.7830269371305, -122.476269792865) | |
| 40075 | 40075 | 100079 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1451 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x6 | 5982451.9345 | 2105243.3429 | 37.759579983868605 | -122.503791871245 | (37.7595799838686, -122.503791871245) | |||
| 101662 | 101662 | 100080 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 701X POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774752 | 6007001.0 | 2113322.0 | 37.7831749319814 | -122.419461922492 | (37.7831749319814, -122.419461922492) | |
| 95559 | 95559 | 100087 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003216.8 | 2118972.8 | 37.798476716718895 | -122.432957560795 | (37.7984767167189, -122.432957560795) | |||||
| 162761 | 162761 | 100088 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6003201.40964 | 2118956.6592900003 | 37.7984315255609 | -122.43300966237301 | (37.7984315255609, -122.433009662373) | |||
| 65147 | 65147 | 100089 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.43305523462601 | (37.7984262977915, -122.433055234626) | |||
| 100352 | 100352 | 100090 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 11X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 102318 | 102318 | 100091 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 11X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 107864 | 107864 | 100092 | Undocumented 2 | Tree(s) :: 17 | 11X Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 93276 | 93276 | 100093 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 11X Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 17835 | 17835 | 100094 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 11X Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 107282 | 107282 | 100095 | Permitted Site 1 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | Private 3 | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507.0 | 2100613.7 | 37.747970090970504 | -122.43755853273001 | (37.7479700909705, -122.43755853273) | |
| 90647 | 90647 | 100096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 87167 | 87167 | 100097 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 91649 | 91649 | 100098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 126698 | 126698 | 100099 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 140481 | 140481 | 100100 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 110150 | 110150 | 100101 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 93311 | 93311 | 100102 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 495@ Beach Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 77838 | 77838 | 100103 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 461 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 141339 | 141339 | 100104 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 461 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 113022 | 113022 | 100105 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 461 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 109346 | 109346 | 100106 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 82122 | 82122 | 100107 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 102979 | 102979 | 100108 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 88125 | 88125 | 100109 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 89982 | 89982 | 100110 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 93784 | 93784 | 100111 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 100595 | 100595 | 100112 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 86389 | 86389 | 100113 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 81210 | 81210 | 100114 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 112445 | 112445 | 100115 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 113502 | 113502 | 100116 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 95264 | 95264 | 100117 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 139689 | 139689 | 100118 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 90019 | 90019 | 100119 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 118771 | 118771 | 100120 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 106068 | 106068 | 100123 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 126830 | 126830 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 431 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995635.0 | 2092781.0 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | |||||
| 37666 | 37666 | 100125 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6005967.88782 | 2116944.18436 | 37.793062307639204 | -122.423293649581 | (37.7930623076392, -122.423293649581) | ||||
| 35544 | 35544 | 100126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6005948.98718 | 2116940.10629 | 37.7930500435754 | -122.423358756926 | (37.7930500435754, -122.423358756926) | ||||
| 47709 | 47709 | 100127 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6005919.013280001 | 2116937.33835 | 37.793040751777895 | -122.423462271584 | (37.7930407517779, -122.423462271584) | ||||
| 33270 | 33270 | 100128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6005897.30712 | 2116933.8296 | 37.7930298924771 | -122.42353712664499 | (37.7930298924771, -122.423537126645) | ||||
| 15069 | 15069 | 100129 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011082.10119 | 2112775.22352 | 37.7819026320456 | -122.40530436681401 | (37.7819026320456, -122.405304366814) | |
| 16480 | 16480 | 100130 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011065.09249 | 2112790.5825400003 | 37.7819438533601 | -122.40536429132601 | (37.7819438533601, -122.405364291326) | |
| 16324 | 16324 | 100131 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011051.59118 | 2112804.91213 | 37.781982444176705 | -122.405412009362 | (37.7819824441767, -122.405412009362) | |
| 14515 | 14515 | 100132 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011001.43438 | 2112862.15185 | 37.782136806515496 | -122.405589562524 | (37.7821368065155, -122.405589562524) | |
| 14550 | 14550 | 100133 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010986.38868 | 2112879.38733 | 37.7821832897709 | -122.405642828459 | (37.7821832897709, -122.405642828459) | |
| 15641 | 15641 | 100134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010970.105930001 | 2112898.8843900003 | 37.782235913593 | -122.40570053346902 | (37.782235913593, -122.405700533469) | |
| 99637 | 99637 | 100135 | Undocumented 2 | Tree(s) :: 17 | 155 05th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 9 | Permit Number 769351 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||
| 15639 | 15639 | 100136 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 155 05th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010957.25903 | 2112913.8393900003 | 37.782276258096296 | -122.405746031954 | (37.7822762580963, -122.405746031954) | |
| 102364 | 102364 | 100137 | Undocumented 2 | Tree(s) :: 17 | 155 05th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | |||
| 80812 | 80812 | 100138 | Undocumented 2 | Tree(s) :: 17 | 155 05th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | |||
| 98786 | 98786 | 100139 | Property Tree 7 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||||
| 122054 | 122054 | 100145 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |||||
| 88634 | 88634 | 100146 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |||||
| 98916 | 98916 | 100147 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003272.0 | 2105332.0 | 37.761025616168396 | -122.431792078279 | (37.7610256161684, -122.431792078279) | |||
| 125346 | 125346 | 100148 | Property Tree 7 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004141.0 | 2102142.0 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | ||||||
| 115292 | 115292 | 100149 | Undocumented 2 | Tree(s) :: 17 | 3975 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6003144.0 | 2105325.0 | 37.760999139175794 | -122.43223427442499 | (37.7609991391758, -122.432234274425) | |||
| 19681 | 19681 | 100150 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4007 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002942.0 | 2105314.0 | 37.7609574805046 | -122.432932117926 | (37.7609574805046, -122.432932117926) | |||
| 122138 | 122138 | 100151 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 4047 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 5x5 | Permit Number 776452 | 6002690.0 | 2105300.0 | 37.760904743288705 | -122.433802674054 | (37.7609047432887, -122.433802674054) | ||
| 87700 | 87700 | 100152 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002933.4 | 2105264.1 | 37.760819979332105 | -122.432958296422 | (37.7608199793321, -122.432958296422) | |||
| 5207 | 5207 | 100153 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.46609982361299 | (37.7773444498569, -122.466099823613) | |||
| 122487 | 122487 | 100154 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 421 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995548.20979 | 2113421.38615 | 37.7827960924124 | -122.459090895565 | (37.7827960924124, -122.459090895565) | |
| 110393 | 110393 | 100155 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 421 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768665 | 5995547.63901 | 2113410.0857599997 | 37.782765031751296 | -122.459092051698 | (37.7827650317513, -122.459092051698) | |
| 66788 | 66788 | 100156 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 421 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995549.3318 | 2113386.41255 | 37.782700128760794 | -122.45908448070101 | (37.7827001287608, -122.459084480701) | |
| 110999 | 110999 | 100157 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 14 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | |||||
| 124830 | 124830 | 100158 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 14 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2012 12:00:00 AM | Permit Number 769008 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | |||
| 182844 | 182844 | 100160 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1699 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 28164 | 6005505.58523 | 2118187.22554 | 37.7964492830571 | -122.424981725648 | (37.7964492830571, -122.424981725648) | |||
| 174840 | 174840 | 100161 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1699 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 28164 | 6005519.03005 | 2118189.86695 | 37.7964572951359 | -122.42493539165599 | (37.7964572951359, -122.424935391656) | |||
| 73623 | 73623 | 100162 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1699 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 28164 | 6005532.34096 | 2118193.0872400003 | 37.7964668890905 | -122.424889562218 | (37.7964668890905, -122.424889562218) | |||
| 122540 | 122540 | 100163 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1814 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6004278.90656 | 2118759.95598 | 37.797952487273605 | -122.429267157958 | (37.7979524872736, -122.429267157958) | ||||
| 183764 | 183764 | 100164 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 839 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008231.9319 | 2115379.46118 | 37.7888934760005 | -122.41534908182 | (37.7888934760005, -122.41534908182) | |||
| 40732 | 40732 | 100165 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 839 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008234.89338 | 2115366.55149 | 37.7888581955857 | -122.415337921201 | (37.7888581955857, -122.415337921201) | |||
| 12440 | 12440 | 100166 | Property Tree 7 | Salix spp :: Willow 218 | 2340 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769026 | ||||||||||
| 122879 | 122879 | 100167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 710 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5986405.6 | 2114870.0 | 37.7862437457696 | -122.49082666767099 | (37.7862437457696, -122.490826667671) | |||||
| 141182 | 141182 | 100168 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 710 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5986405.6 | 2114870.0 | 37.7862437457696 | -122.49082666767099 | (37.7862437457696, -122.490826667671) | |||||
| 122667 | 122667 | 100169 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180X Manchester St | Back Yard : Yard 13 | Tree 1 | DPW 2 | Adjacent to rear of property - DPW parcel | 6008242.0 | 2099158.0 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | |||||
| 44206 | 44206 | 100170 | Permitted Site 1 | Tree(s) :: 17 | 2149 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769012 | 5997531.0 | 2110183.0 | 37.774018114579896 | -122.451997596236 | (37.7740181145799, -122.451997596236) | |
| 110792 | 110792 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 76 | 109 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996563.8 | 2106359.1 | 37.763463224843996 | -122.455066914463 | (37.763463224844, -122.455066914463) | |||||
| 113059 | 113059 | 100174 | Undocumented 2 | Tree(s) :: 17 | 50 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2012 12:00:00 AM | 18 | 3x3 | Permit Number 769094 | 6010932.2 | 2114627.3 | 37.7869796149513 | -122.405953468587 | (37.7869796149513, -122.405953468587) | |
| 113831 | 113831 | 100175 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1140 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2012 12:00:00 AM | 3x3 | Permit Number 768230 | 6001099.0 | 2109378.2 | 37.772012061027006 | -122.43959759817301 | (37.772012061027, -122.439597598173) | ||
| 65540 | 65540 | 100177 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 252 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768965 | 6000636.0 | 2106677.4 | 37.764569975148895 | -122.44100535545 | (37.7645699751489, -122.44100535545) | ||||
| 99782 | 99782 | 100178 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1270 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2012 12:00:00 AM | 3x3 | 6003851.0 | 2100874.0 | 37.748817804949496 | -122.42947164058 | (37.7488178049495, -122.42947164058) | |||
| 95039 | 95039 | 100179 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2012 12:00:00 AM | 3x3 | 6003851.0 | 2100874.0 | 37.748817804949496 | -122.42947164058 | (37.7488178049495, -122.42947164058) | |||
| 97490 | 97490 | 100180 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997991.0 | 2108152.0 | 37.768467847026294 | -122.450259955793 | (37.7684678470263, -122.450259955793) | ||||
| 13839 | 13839 | 100181 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Ritch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6013794.16577 | 2112184.81721 | 37.7804327665865 | -122.39588042503999 | (37.7804327665865, -122.39588042504) | ||||
| 15722 | 15722 | 100182 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966001 | (37.7803937971776, -122.39583053966) | ||||
| 127433 | 127433 | 100183 | Permitted Site 1 | Tree(s) :: 17 | 956 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003075.2 | 2102641.9 | 37.7536280862965 | -122.432280596021 | (37.7536280862965, -122.432280596021) | ||||
| 182317 | 182317 | 100184 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 480 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6006818.05082 | 2091764.69226 | 37.7239732025834 | -122.418565697766 | (37.7239732025834, -122.418565697766) | |||
| 115349 | 115349 | 100186 | DPW Maintained 3 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2445 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6008897.0 | 2104213.0 | 37.758270352242796 | -122.41225848424999 | (37.7582703522428, -122.41225848425) | |||
| 99942 | 99942 | 100187 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) |
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");