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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46354 | 108426 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 270X HAYES ST | 11 | 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 | ||||
47310 | 255326 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
47490 | 102058 | Undocumented 4 | Tree(s) :: 17 | 455 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008302 | 2113092 | 37.7826165993638 | -122.414944688864 | (37.7826165993638, -122.414944688864) | 7 | 10 | 9 | 28852 | 36 | |||
48038 | 102978 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 4 | 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 | ||||
48309 | 255975 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 600 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004248 | 2110989 | 37.7766136461531 | -122.428819818687 | (37.7766136461531, -122.428819818687) | 7 | 9 | 11 | 28852 | 10 | ||||
48369 | 256770 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
49682 | 112303 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
50129 | 117233 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
50233 | 237038 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6005608.42983 | 2109742.33589 | 37.773267513529 | -122.424025015163 | (37.773267513529, -122.424025015163) | 7 | 9 | 11 | 28852 | 10 | |||
50546 | 112297 | Undocumented 4 | Ficus laurel :: 247 | 336 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006219 | 2111187 | 37.7772686655697 | -122.422015614022 | (37.7772686655697, -122.422015614022) | 7 | 9 | 11 | 28852 | 10 | ||||
50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
50788 | 113510 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008411 | 2113171 | 37.7828396386737 | -122.414573186563 | (37.7828396386737, -122.414573186563) | 7 | 10 | 9 | 28852 | 36 | ||||
50834 | 255976 | Undocumented 4 | Tree(s) :: 17 | 600 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004248 | 2110989 | 37.7766136461531 | -122.428819818687 | (37.7766136461531, -122.428819818687) | 7 | 9 | 11 | 28852 | 10 | ||||
51596 | 117230 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
52117 | 131429 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009867.09443 | 2114421.62691 | 37.7863552591459 | -122.40962398688 | (37.7863552591459, -122.40962398688) | 5 | 10 | 10 | 28852 | 36 | |||
52902 | 114681 | Undocumented 4 | Ficus Spp. :: 101 | 235 GEARY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6010571 | 2114715 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | 5 | 10 | 10 | 28852 | 6 | |||||
54202 | 107622 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 HAIGHT ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | 6005238.1 | 2109520.1 | 37.7726363924224 | -122.425290219951 | (37.7726363924224, -122.425290219951) | 7 | 9 | 11 | 28852 | 10 | ||||
54306 | 237027 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 8 | : | Tree | Private 2 | 5 | Width 6ft | 6005758.33223 | 2109504.65873 | 37.7726233714135 | -122.423489581302 | (37.7726233714135, -122.423489581302) | 7 | 9 | 11 | 28852 | 10 | |||
54663 | 110552 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
55154 | 220686 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004903.16789 | 2110400.70337 | 37.7750353872943 | -122.426511501216 | (37.7750353872943, -122.426511501216) | 7 | 9 | 11 | 28852 | 10 | |||
55305 | 102778 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 62X Leavenworth St | 3 | 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 | |||
55377 | 117237 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
55613 | 114746 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
55857 | 237026 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 7 | : | Tree | Private 2 | 3 | Width 6ft | 6005759.75569 | 2109493.68206 | 37.7725933124646 | -122.423483876889 | (37.7725933124646, -122.423483876889) | 7 | 9 | 11 | 28852 | 10 | |||
56227 | 116244 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
58098 | 112642 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 299X STOCKTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x12 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
58451 | 110547 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
59182 | 116252 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
59198 | 110445 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 440 TURK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007839 | 2113090 | 37.7825850801749 | -122.41654633286 | (37.7825850801749, -122.41654633286) | 7 | 10 | 9 | 28852 | 36 | ||||
59516 | 120135 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
59912 | 108412 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 8 | 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 | ||
60859 | 108417 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 270X HAYES ST | 2 | 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 | ||||
61287 | 101982 | Undocumented 4 | Tree(s) :: 17 | 205X Rose St | 1 | 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 | ||||
62107 | 112956 | Undocumented 4 | Tree(s) :: 17 | 601x TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776687 | 6007104 | 2112858 | 37.7819067016043 | -122.419072660933 | (37.7819067016043, -122.419072660933) | 7 | 9 | 9 | 28852 | 36 | |
63324 | 120151 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
63709 | 109830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||||
65097 | 110683 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
65197 | 255327 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1003x Turk St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6005211 | 2112640 | 37.7812013451486 | -122.425606050794 | (37.7812013451486, -122.425606050794) | 7 | 9 | 11 | 28852 | 41 | ||||
65558 | 102984 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 11 | 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 | ||||
67145 | 111046 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
67427 | 111045 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
68439 | 99103 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 201 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006380 | 2111267.6 | 37.7774990526419 | -122.421464387784 | (37.7774990526419, -122.421464387784) | 7 | 9 | 11 | 28852 | 10 | ||||
68872 | 100564 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
69531 | 116248 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
69595 | 102893 | Undocumented 4 | Tree(s) :: 17 | 115 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008968 | 2112966 | 37.7823080347026 | -122.412631696322 | (37.7823080347026, -122.412631696322) | 7 | 10 | 9 | 28852 | 36 | ||||
70643 | 244389 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 250 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005653.9696 | 2110171.6272 | 37.7744488147211 | -122.42389801886 | (37.7744488147211, -122.42389801886) | 7 | 9 | 11 | 28852 | 10 | |||
71805 | 113514 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 352 TURK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008306 | 2113136 | 37.7827376375446 | -122.414933965724 | (37.7827376375446, -122.414933965724) | 7 | 10 | 9 | 28852 | 36 | ||||
72043 | 257947 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
72407 | 118344 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 621x Gough St | 1 | Front Yard : Yard | Tree | Private 2 | 6005346 | 2111820 | 37.7789574535961 | -122.425080654997 | (37.7789574535961, -122.425080654997) | 7 | 9 | 11 | 28852 | 41 | |||||
72864 | 244352 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005613.5532 | 2110456.5225 | 37.7752287864343 | -122.424058091407 | (37.7752287864343, -122.424058091407) | 7 | 9 | 11 | 28852 | 10 | |||
73721 | 245834 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 451 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6005238.2394 | 2110581.29 | 37.7755501705578 | -122.425365268748 | (37.7755501705578, -122.425365268748) | 7 | 9 | 11 | 28852 | 10 | |||
74249 | 116261 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
74783 | 256773 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 16 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
75859 | 114743 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
76286 | 114685 | Undocumented 4 | Ficus Spp. :: 101 | 235 GEARY ST | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4x4 | 6010571 | 2114715 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | 5 | 10 | 10 | 28852 | 6 | ||||
76524 | 113556 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 528 LARKIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007633 | 2113168 | 37.7827876619604 | -122.417264535098 | (37.7827876619604, -122.417264535098) | 7 | 10 | 9 | 28852 | 36 | ||||
77091 | 95788 | Undocumented 4 | Tree(s) :: 17 | 96 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008711.8 | 2112556.7 | 37.7811698125515 | -122.41348908139 | (37.7811698125515, -122.41348908139) | 7 | 10 | 9 | 28852 | 36 | |||
77554 | 115072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 65 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006230 | 2110204 | 37.7745702053319 | -122.421907716929 | (37.7745702053319, -122.421907716929) | 7 | 9 | 11 | 28852 | 10 | ||||
77962 | 97291 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778496 | 6005288 | 2108881 | 37.7708843970709 | -122.425072128908 | (37.7708843970709, -122.425072128908) | 7 | 9 | 5 | 28852 | 10 | ||
78226 | 117245 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
79428 | 102985 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 12 | 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 | ||||
82752 | 257946 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
82815 | 108411 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 7 | 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 | ||
83740 | 116253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
84863 | 109157 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2016 12:00:00 AM | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
86925 | 114745 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
87708 | 107363 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 4 | 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 | |
90810 | 120868 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 101X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6005428 | 2109592 | 37.7728445391028 | -122.424638450672 | (37.7728445391028, -122.424638450672) | 7 | 9 | 11 | 28852 | 10 | |||
91161 | 79439 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 4 | 2x3 | Permit Number 49769 | 6004809.08231089 | 2110052.92705889 | 37.7740751590965 | -122.426812191246 | (37.7740751590965, -122.426812191246) | 7 | 9 | 11 | 28852 | 10 | |
91678 | 257943 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
92267 | 102980 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 6 | 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 | ||||
92392 | 116250 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
94295 | 112302 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
95006 | 110442 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 440 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007839 | 2113090 | 37.7825850801749 | -122.41654633286 | (37.7825850801749, -122.41654633286) | 7 | 10 | 9 | 28852 | 36 | ||||
95595 | 107364 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 5 | 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 | |
95826 | 239156 | Undocumented 4 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 101 Octavia St | 4 | : | Tree | Private 2 | 5 | Width 4ft | 6005612.49957 | 2109700.10187 | 37.7731517788755 | -122.42400793342 | (37.7731517788755, -122.42400793342) | 7 | 9 | 11 | 28852 | 10 | |||
96769 | 114687 | Undocumented 4 | Ficus Spp. :: 101 | 235 GEARY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010571 | 2114715 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | 5 | 10 | 10 | 28852 | 6 | ||||
96776 | 110544 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
97171 | 120147 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
99027 | 114744 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
100070 | 107362 | Undocumented 4 | Tree(s) :: 17 | 80X Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770024 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |||
101109 | 110690 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
101272 | 110684 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
102477 | 116246 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
102780 | 116254 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
103530 | 113554 | Undocumented 4 | Tristania conferta :: 61 | 400X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6007659.5152 | 2112834.4553 | 37.7818733205533 | -122.4171491612 | (37.7818733205533, -122.4171491612) | 7 | 9 | 9 | 28852 | 36 | |||
103816 | 116240 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
104645 | 120981 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 699X Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007023 | 2113270 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | 7 | 9 | 9 | 28852 | 36 | ||||
104831 | 108619 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150-198X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
104904 | 129975 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 264 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009238.58117 | 2113617.10883 | 37.7841110063469 | -122.411741623201 | (37.7841110063469, -122.411741623201) | 14 | 10 | 9 | 28852 | 36 | |||
104968 | 121219 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 417 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242 | 2110781 | 37.7760987380534 | -122.425366474989 | (37.7760987380534, -122.425366474989) | 7 | 9 | 11 | 28852 | 10 | ||||
105820 | 245836 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 451 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005295.8934 | 2110590.1959 | 37.7755778811358 | -122.425166463296 | (37.7755778811358, -122.425166463296) | 7 | 9 | 11 | 28852 | 10 | |||
106716 | 112957 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 601x TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007104 | 2112858 | 37.7819067016043 | -122.419072660933 | (37.7819067016043, -122.419072660933) | 7 | 9 | 9 | 28852 | 36 | |||
107007 | 256771 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 14 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
109217 | 120150 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
109505 | 108425 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 270X HAYES ST | 10 | 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 | ||||
110563 | 101984 | Undocumented 4 | Tree(s) :: 17 | 205X Rose St | 3 | 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 | ||||
111510 | 100488 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 104 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2109102 | 37.7714348393367 | -122.428536532108 | (37.7714348393367, -122.428536532108) | 7 | 9 | 11 | 28852 | 10 | ||||
111844 | 121077 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 698X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007134 | 2113285 | 37.7830808292164 | -122.418999169921 | (37.7830808292164, -122.418999169921) | 7 | 9 | 9 | 28852 | 36 | ||||
112244 | 130099 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009103.32764 | 2112603.74896 | 37.7813209739269 | -122.412137911252 | (37.7813209739269, -122.412137911252) | 7 | 10 | 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) );