trees
8,298 rows where qLegalStatus_id = 4 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113350 | 116238 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 114926 | 116249 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 115122 | 108413 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
| 116801 | 94562 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 251X OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005545 | 2110135 | 37.774342092867 | -122.424272360307 | (37.774342092867, -122.424272360307) | 7 | 9 | 11 | 28852 | 10 | |||
| 119065 | 107361 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |
| 119361 | 120152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
| 119462 | 237040 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6005610.09761 | 2109720.52403 | 37.7732077175873 | -122.424017694677 | (37.7732077175873, -122.424017694677) | 7 | 9 | 11 | 28852 | 10 | |||
| 119635 | 120148 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
| 120038 | 116245 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 120178 | 116251 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 120635 | 120140 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
| 120641 | 100077 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005310 | 2109942 | 37.7737988894613 | -122.425071534475 | (37.7737988894613, -122.425071534475) | 7 | 9 | 11 | 28852 | 10 | ||||
| 121430 | 102977 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
| 121519 | 121218 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 441 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005284 | 2110767 | 37.7760626702732 | -122.425220189207 | (37.7760626702732, -122.425220189207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 122396 | 120867 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 119 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005509 | 2109557 | 37.7727530117987 | -122.424355772152 | (37.7727530117987, -122.424355772152) | 7 | 9 | 11 | 28852 | 10 | |||
| 122790 | 257949 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 123482 | 112954 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 245 HYDE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776672 | 6008003 | 2113318 | 37.7832203349453 | -122.415995113119 | (37.7832203349453, -122.415995113119) | 7 | 10 | 9 | 28852 | 36 | |
| 123771 | 116260 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 124909 | 103134 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 345X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005937 | 2110878 | 37.7764043178826 | -122.422969176765 | (37.7764043178826, -122.422969176765) | 7 | 9 | 11 | 28852 | 10 | |||
| 125533 | 111048 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
| 125688 | 117419 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 452 OAK ST | 1 | Front Yard : Yard | Tree | Private 2 | 6004802 | 2110240 | 37.774588415373 | -122.426850015779 | (37.774588415373, -122.426850015779) | 7 | 9 | 11 | 28852 | 10 | |||||
| 125851 | 253693 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
| 125930 | 110546 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 126720 | 117231 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
| 127260 | 110444 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 440 TURK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007839 | 2113090 | 37.7825850801749 | -122.41654633286 | (37.7825850801749, -122.41654633286) | 7 | 10 | 9 | 28852 | 36 | ||||
| 127461 | 120149 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
| 128072 | 110686 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
| 128624 | 117343 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 372 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6006019 | 2111114 | 37.7770569433878 | -122.422702290381 | (37.7770569433878, -122.422702290381) | 7 | 9 | 11 | 28852 | 10 | ||||
| 128744 | 257950 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 129277 | 103959 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 460X Lily St | 1 | unknown : Pot | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
| 129533 | 120143 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
| 131101 | 107360 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |
| 131685 | 102979 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
| 133301 | 113479 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2X LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008711 | 2112556 | 37.7811678455995 | -122.413491799481 | (37.7811678455995, -122.413491799481) | 7 | 10 | 9 | 28852 | 36 | ||||
| 133335 | 99718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 430 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005787 | 2111054 | 37.7768791059226 | -122.423500585068 | (37.7768791059226, -122.423500585068) | 7 | 9 | 11 | 28852 | 10 | |||
| 134114 | 108620 | Undocumented 4 | Tree(s) :: 17 | 150-198X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
| 134283 | 110047 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290 Eddy St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009037.88726419 | 2113590.00375699 | 37.7840253217877 | -122.412434037929 | (37.7840253217877, -122.412434037929) | 14 | 10 | 9 | 28852 | 36 | |||||
| 134711 | 112416 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 469x IVY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
| 134922 | 106798 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009957 | 2113442 | 37.783670474647 | -122.409243780474 | (37.783670474647, -122.409243780474) | 14 | 10 | 9 | 28852 | 36 | ||||
| 135346 | 108414 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
| 135359 | 120138 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
| 135861 | 109155 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2016 12:00:00 AM | 6 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
| 136152 | 255328 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
| 136415 | 237037 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 129 Octavia St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6005605.52362 | 2109755.39176 | 37.7733031977155 | -122.424035996776 | (37.7733031977155, -122.424035996776) | 7 | 9 | 11 | 28852 | 10 | |||
| 136511 | 110551 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 136737 | 237034 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 150 Octavia St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6005711.67822 | 2109842.25548 | 37.7735476972984 | -122.423674970241 | (37.7735476972984, -122.423674970241) | 7 | 9 | 11 | 28852 | 10 | |||
| 137729 | 107740 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
| 138897 | 110545 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 138990 | 110337 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 501x IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6004921 | 2111009 | 37.7767066293551 | -122.426493138757 | (37.7767066293551, -122.426493138757) | 7 | 9 | 11 | 28852 | 10 | ||||
| 139135 | 120869 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 67 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6005820 | 2109601 | 37.772891381842 | -122.423283115457 | (37.772891381842, -122.423283115457) | 7 | 9 | 11 | 28852 | 10 | |||
| 139995 | 102895 | Undocumented 4 | Tree(s) :: 17 | 40X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009201.8 | 2112650.6 | 37.7814551404658 | -122.411800555351 | (37.7814551404658, -122.411800555351) | 14 | 10 | 9 | 28852 | 36 | ||||
| 140003 | 30525 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.413624143987 | (37.7811193385199, -122.413624143987) | 7 | 10 | 9 | 28852 | 36 | |
| 140351 | 110689 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
| 140534 | 107736 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
| 141050 | 117229 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
| 142301 | 114953 | Undocumented 4 | Ficus Spp. :: 101 | 601x OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005348 | 2111368 | 37.7777164851071 | -122.42504156742 | (37.7777164851071, -122.42504156742) | 7 | 9 | 11 | 28852 | 10 | ||||
| 142679 | 116983 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 ROSE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004435 | 2109631 | 37.7728954926097 | -122.42807613315 | (37.7728954926097, -122.42807613315) | 7 | 9 | 11 | 28852 | 10 | ||||
| 143278 | 110685 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
| 145499 | 239158 | Undocumented 4 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 101 Octavia St | 6 | : | Tree | Private 2 | 4 | Width 4ft | 6005617.18186 | 2109670.50026 | 37.7730707643493 | -122.423989631326 | (37.7730707643493, -122.423989631326) | 7 | 9 | 11 | 28852 | 10 | |||
| 146174 | 108618 | Undocumented 4 | :: 45 | 150-198X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
| 148384 | 116242 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 150109 | 116239 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 152077 | 114739 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | ||||
| 152433 | 256772 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 15 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
| 153310 | 101986 | Undocumented 4 | Tree(s) :: 17 | 205X Rose St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005538.6 | 2109749.6 | 37.7732835163003 | -122.424267082997 | (37.7732835163003, -122.424267082997) | 7 | 9 | 11 | 28852 | 10 | ||||
| 154465 | 114736 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 435 LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2x2 | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
| 156073 | 113512 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 352 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008306 | 2113136 | 37.7827376375446 | -122.414933965724 | (37.7827376375446, -122.414933965724) | 7 | 10 | 9 | 28852 | 36 | ||||
| 157416 | 108424 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 270X HAYES ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006095.6 | 2111028.7 | 37.7768270516853 | -122.422431244298 | (37.7768270516853, -122.422431244298) | 7 | 9 | 11 | 28852 | 10 | ||||
| 158012 | 107739 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
| 159583 | 110441 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 440 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007839 | 2113090 | 37.7825850801749 | -122.41654633286 | (37.7825850801749, -122.41654633286) | 7 | 10 | 9 | 28852 | 36 | |||
| 159847 | 100565 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
| 160264 | 110443 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 440 TURK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007839 | 2113090 | 37.7825850801749 | -122.41654633286 | (37.7825850801749, -122.41654633286) | 7 | 10 | 9 | 28852 | 36 | ||||
| 160460 | 257944 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 160617 | 110687 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
| 160891 | 116695 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 535 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6004831 | 2110695 | 37.7758393739821 | -122.426782108664 | (37.7758393739821, -122.426782108664) | 7 | 9 | 11 | 28852 | 10 | ||||
| 161173 | 117238 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
| 161319 | 257953 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 162910 | 112641 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 299X STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6x6 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
| 164117 | 109153 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 124 LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x2 | 6005951.6 | 2110200.9 | 37.7745459888588 | -122.422870538078 | (37.7745459888588, -122.422870538078) | 7 | 9 | 11 | 28852 | 10 | |||
| 165035 | 103135 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 345X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005937 | 2110878 | 37.7764043178826 | -122.422969176765 | (37.7764043178826, -122.422969176765) | 7 | 9 | 11 | 28852 | 10 | |||
| 165374 | 109158 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
| 165711 | 122685 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006053 | 2111262 | 37.7774652336961 | -122.422595193091 | (37.7774652336961, -122.422595193091) | 7 | 9 | 11 | 28852 | 10 | ||||
| 166388 | 114740 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
| 167945 | 118288 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 240 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2.5 | 6006177 | 2111293 | 37.7775573470216 | -122.422168438332 | (37.7775573470216, -122.422168438332) | 7 | 9 | 11 | 28852 | 10 | ||||
| 168207 | 102777 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 62X Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008664.5 | 2112552.3 | 37.7811550752382 | -122.413652405154 | (37.7811550752382, -122.413652405154) | 7 | 10 | 9 | 28852 | 36 | |||
| 168941 | 120136 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
| 169317 | 110548 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 169343 | 109156 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2015 01:49:00 PM | 3 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
| 170422 | 113480 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2X LEAVENWORTH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008711 | 2112556 | 37.7811678455995 | -122.413491799481 | (37.7811678455995, -122.413491799481) | 7 | 10 | 9 | 28852 | 36 | ||||
| 170457 | 116247 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 170574 | 114952 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005348 | 2111368 | 37.7777164851071 | -122.42504156742 | (37.7777164851071, -122.42504156742) | 7 | 9 | 11 | 28852 | 10 | ||||
| 170909 | 237039 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6005609.24206 | 2109730.37641 | 37.7732347215415 | -122.424021354908 | (37.7732347215415, -122.424021354908) | 7 | 9 | 11 | 28852 | 10 | |||
| 171091 | 110543 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 171284 | 112358 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 TAYLOR ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009361 | 2114091 | 37.7854190646881 | -122.411351585686 | (37.7854190646881, -122.411351585686) | 14 | 10 | 9 | 28852 | 36 | ||||
| 172116 | 102982 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
| 172169 | 117345 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 395 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006014 | 2111158 | 37.7771774746178 | -122.422722714586 | (37.7771774746178, -122.422722714586) | 7 | 9 | 11 | 28852 | 10 | ||||
| 172681 | 116256 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 174676 | 100563 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 284 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009946.4 | 2114395 | 37.7862865916342 | -122.409347728871 | (37.7862865916342, -122.409347728871) | 5 | 10 | 10 | 28852 | 36 | |||
| 175542 | 111047 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
| 176539 | 102981 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 |
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) );