trees
215 rows where qLegalStatus_id = 9 sorted by TreeID
This data as json, CSV (advanced)
These facets timed out: PlantType
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86075 | 100243 | Private 9 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard | Tree | Private 2 | 6008043 | 2100485 | 37.7479861507453 | -122.414948142067 | (37.7479861507453, -122.414948142067) | 2 | 7 | 7 | 28859 | 2 | ||||||
| 160937 | 102060 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 115 Kensington Way | 1 | Back Yard : Yard | Tree | Private 2 | 5994908.3 | 2098325.8 | 37.7413107073974 | -122.460210667073 | (37.7413107073974, -122.460210667073) | 1 | 8 | 4 | 59 | 40 | |||||
| 6900 | 102545 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015962.79104 | 2107111.95809 | 37.7666242197475 | -122.38802396564 | (37.7666242197475, -122.38802396564) | 14 | 3 | 9 | 310 | 20 | ||
| 4077 | 102546 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015961.34604 | 2107137.76144 | 37.7666949900978 | -122.388030764508 | (37.7666949900978, -122.388030764508) | 14 | 3 | 9 | 310 | 20 | ||
| 190102 | 104109 | Private 9 | Maytenus boaria :: Mayten 58 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | 6007700 | 2097518 | 37.7398201496863 | -122.415924151926 | (37.7398201496863, -122.415924151926) | 2 | 7 | 7 | 28859 | 2 | |||
| 122325 | 104309 | Private 9 | Myoporum laetum :: Myoporum 62 | 3747 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | ||||
| 97720 | 104310 | Private 9 | Brachychiton populneus :: Bottle Tree 348 | 3747 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | |||
| 165242 | 104317 | Private 9 | Pyrus calleryana :: Ornamental Pear 44 | 13011305 SANCHEZ ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003956 | 2100665 | 37.7482498839608 | -122.429093651106 | (37.7482498839608, -122.429093651106) | 2 | 4 | 5 | 63 | 22 | |||
| 108163 | 104358 | Private 9 | Maytenus boaria :: Mayten 58 | 745X GOLDEN GATE AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3 | 6005986 | 2112447 | 37.7807151749226 | -122.422911209833 | (37.7807151749226, -122.422911209833) | 7 | 9 | 11 | 28852 | 41 | ||||
| 176299 | 104400 | Private 9 | Maytenus boaria :: Mayten 58 | 755 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5999044 | 2107976 | 37.768044800389 | -122.446605071221 | (37.768044800389, -122.446605071221) | 15 | 5 | 11 | 29492 | 9 | ||||
| 57138 | 104401 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 727 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999017 | 2108166 | 37.768564950056 | -122.44671213341 | (37.768564950056, -122.44671213341) | 15 | 5 | 11 | 29492 | 9 | ||||
| 167961 | 104436 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 5992040 | 2096369 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | 1 | 8 | 4 | 59 | 40 | ||||
| 108854 | 104446 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 34779 | 104448 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 91676 | 104449 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 68698 | 104451 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
| 70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
| 193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
| 69100 | 104567 | Private 9 | Tree(s) :: 17 | 8 JOY ST | 2 | Front Yard : Yard | Tree | Private 2 | 40 | 6010448 | 2098932 | 37.7438568002142 | -122.406522292508 | (37.7438568002142, -122.406522292508) | 2 | 7 | 7 | 28859 | 2 | ||||
| 35396 | 104626 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6X5 | 6001285 | 2108936 | 37.7708084746611 | -122.438922516011 | (37.7708084746611, -122.438922516011) | 15 | 5 | 11 | 29492 | 9 | |||
| 165107 | 104627 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5X5 | 6001306 | 2108720 | 37.7702165872443 | -122.438834395611 | (37.7702165872443, -122.438834395611) | 15 | 5 | 11 | 29492 | 9 | |||
| 149976 | 104650 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 346 LAKE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.463222305141 | (37.7868637456835, -122.463222305141) | 11 | 6 | 1 | 54 | 11 | ||||
| 112528 | 104689 | Private 9 | Pinus radiata :: Monterey Pine 15 | 657 PALMETTO AVE | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 5991786 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | 9 | 8 | 4 | 64 | 24 | ||||
| 112431 | 104768 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.434524613527 | (37.7542282864134, -122.434524613527) | 2 | 4 | 5 | 28862 | 22 | |||
| 100633 | 104881 | Private 9 | Privet :: 212 | 101 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | missing? | 5990474.7 | 2090014.4 | 37.7182336817112 | -122.474933796522 | (37.7182336817112, -122.474933796522) | 1 | 8 | 4 | 64 | 14 | ||||
| 188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
| 33896 | 104968 | Private 9 | Pinus halepensis :: Allepo Pine 330 | 495 COLLINGWOOD ST | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Permit Number 770776 | 6002186.6 | 2103026 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | 2 | 4 | 5 | 28862 | 22 | |||
| 120017 | 105072 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 88X PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6007074 | 2099135 | 37.7442248567037 | -122.418203213837 | (37.7442248567037, -122.418203213837) | 2 | 7 | 7 | 28859 | 2 | |||
| 74288 | 105439 | Private 9 | Tree(s) :: 17 | 790 LAKEVIEW AVE | 1 | Front Yard : Yard | Tree | Private 2 | 5994224.8 | 2089960.8 | 37.7183031233486 | -122.461967505828 | (37.7183031233486, -122.461967505828) | 9 | 8 | 6 | 28861 | 24 | |||||
| 119017 | 105441 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 425 WAWONA ST | unknown : Yard | Tree | Private 2 | 5991587.6 | 2097036.5 | 37.7375790508831 | -122.471598439568 | (37.7375790508831, -122.471598439568) | 1 | 8 | 4 | 29491 | 40 | ||||||
| 110382 | 108170 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | 2 | 7 | 7 | 28859 | 2 | |
| 156160 | 108314 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2501X DIAMOND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002141 | 2097265 | 37.7388113707969 | -122.435126715418 | (37.7388113707969, -122.435126715418) | 2 | 7 | 5 | 63 | 7 | ||||
| 99316 | 108440 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | ||||
| 187934 | 108441 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773769 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | |||
| 23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
| 65512 | 108459 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | 11 | 6 | 2 | 54 | 11 | |||
| 53506 | 108816 | Private 9 | Pinus radiata :: Monterey Pine 15 | 348 Gold Mine Dr | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 6001084 | 2097744 | 37.740066514789 | -122.438815634293 | (37.740066514789, -122.438815634293) | 2 | 7 | 5 | 63 | 7 | ||||
| 193423 | 108885 | Private 9 | Cupaniopsis anacardioides :: Carrotwood 195 | 707 NOE ST | 5 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003152.4 | 2104071.5 | 37.7575578048507 | -122.432115704961 | (37.7575578048507, -122.432115704961) | 2 | 4 | 5 | 28862 | 3 | ||||
| 186484 | 109125 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
| 83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
| 20327 | 109501 | Private 9 | Ulmus americana :: American Elm 74 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard | Tree | Private 2 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.8021053817179 | -122.404424889694 | (37.8021053817179, -122.404424889694) | 3 | 1 | 10 | 308 | 23 | ||||
| 33729 | 109829 | Private 9 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||
| 108521 | 110587 | Private 9 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 151 EDGEWOOD AVE | 1 | Front Yard : Yard | Tree | Private 2 | 5996558 | 2106132 | 37.7628393335165 | -122.45507056335 | (37.7628393335165, -122.45507056335) | 15 | 5 | 11 | 29492 | 12 | |||||
| 91085 | 111308 | Private 9 | Pinus radiata :: Monterey Pine 15 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x90 | 6015099 | 2088640 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | 10 | 3 | 8 | 58 | 1 | ||||
| 180187 | 112262 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x15 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | 2 | 7 | 7 | 28859 | 2 | |||
| 102300 | 113801 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 806 SHOTWELL ST | 3 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 85850 | 114258 | Private 9 | Pinus radiata :: Monterey Pine 15 | 70x CHUMASERO DR | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | ||||
| 44862 | 114642 | Private 9 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163197 | -122.407019863158 | (37.745978163197, -122.407019863158) | 2 | 7 | 7 | 28859 | 2 | |||
| 165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
| 80106 | 114666 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.417426639907 | (37.7355258779344, -122.417426639907) | 2 | 7 | 7 | 28859 | 2 | |||
| 150142 | 114761 | Private 9 | Pinus radiata :: Monterey Pine 15 | 2155 10TH AVE | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5993160 | 2101036 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | 1 | 8 | 4 | 29491 | 40 | ||||
| 16285 | 114961 | Private 9 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 | |||
| 119423 | 114977 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 183 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 774982 | 5996484.3 | 2091092.2 | 37.7215395068839 | -122.454239087603 | (37.7215395068839, -122.454239087603) | 9 | 8 | 6 | 28861 | 24 | |||
| 109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
| 128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
| 273 | 117070 | Private 9 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard | Tree | Private 2 | 6010444 | 2098901 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | 2 | 7 | 7 | 28859 | 2 | |||||
| 137357 | 117353 | Private 9 | Pittosporum crassifolium :: Karo Tree 95 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.7710574836343 | -122.390397474374 | (37.7710574836343, -122.390397474374) | 14 | 3 | 9 | 310 | 20 | |||
| 141416 | 118356 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 RACCOON DR | 2 | Back Yard : Cutout | Tree | Private 2 | 48 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | ||||
| 181524 | 121089 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
| 107120 | 121090 | Private 9 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
| 172318 | 122641 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 176217 | 122642 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 106383 | 122643 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 136268 | 122644 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 168048 | 122898 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006160 | 2102149 | 37.7524491239798 | -122.421577653162 | (37.7524491239798, -122.421577653162) | 2 | 4 | 5 | 28859 | 19 | |||
| 1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
| 8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 18413 | 149679 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 3 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 3212 | 150016 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.18586 | 2105386.64383 | 37.7618609074738 | -122.389524298311 | (37.7618609074738, -122.389524298311) | 10 | 3 | 8 | 28856 | 29 | |
| 15916 | 150017 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.08881 | 2105409.25245 | 37.7619229804945 | -122.389526212978 | (37.7619229804945, -122.389526212978) | 10 | 3 | 8 | 28856 | 29 | |
| 14649 | 150018 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015492.47093 | 2105432.35195 | 37.7619863170408 | -122.389533421936 | (37.7619863170408, -122.389533421936) | 10 | 3 | 8 | 28856 | 29 | |
| 675 | 150019 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.62882 | 2105456.11878 | 37.7620514180509 | -122.389544911688 | (37.7620514180509, -122.389544911688) | 10 | 3 | 8 | 28856 | 29 | |
| 8842 | 150020 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.50926 | 2105477.62507 | 37.7621104630605 | -122.389546827243 | (37.7621104630605, -122.389546827243) | 10 | 3 | 8 | 28856 | 29 | |
| 142770 | 150735 | Private 9 | Cordyline australis :: Dracena Palm 64 | 783 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778950 | 6012760.80751 | 2103885.27159 | 37.7575865350131 | -122.398872659244 | (37.7575865350131, -122.398872659244) | 10 | 3 | 8 | 28856 | 29 | |
| 4984 | 154060 | Private 9 | Tree(s) :: 17 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014554.77098 | 2096926.88452 | 37.7385800668269 | -122.392181721216 | (37.7385800668269, -122.392181721216) | 10 | 3 | 8 | 58 | 1 | |
| 16385 | 154062 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014575.41577 | 2096839.56035 | 37.7383414389075 | -122.392104235638 | (37.7383414389075, -122.392104235638) | 10 | 3 | 8 | 58 | 1 | |
| 12863 | 154063 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1781 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014599.10763 | 2096821.84485 | 37.7382941111836 | -122.392021081628 | (37.7382941111836, -122.392021081628) | 10 | 3 | 8 | 58 | 1 |
| 4221 | 160246 | Private 9 | Potential Site :: Potential Site 48 | 962 Edinburgh St | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 02/20/2020 12:00:00 AM | 3 | 3x3 | Permit Number 779047 | 6001480.24176 | 2088600.7563 | 37.7149837880375 | -122.436791243222 | (37.7149837880375, -122.436791243222) | 9 | 7 | 6 | 28861 | 5 |
| 10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
| 144187 | 16882 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 41193 | 16883 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 69117 | 16884 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 184134 | 16885 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 133992 | 16886 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X4 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 68363 | 16887 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 47945 | 16888 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 13110 | 188782 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015982.12636 | 2106754.96915 | 37.7656450765832 | -122.387932174526 | (37.7656450765832, -122.387932174526) | 14 | 3 | 9 | 310 | 20 | |||
| 9799 | 188783 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015981.68348 | 2106781.73126 | 37.7657185350155 | -122.387935573977 | (37.7657185350155, -122.387935573977) | 14 | 3 | 9 | 310 | 20 | |||
| 2007 | 188784 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015979.83831 | 2106803.95395 | 37.7657794514949 | -122.387943506912 | (37.7657794514949, -122.387943506912) | 14 | 3 | 9 | 310 | 20 | |||
| 10795 | 188785 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015978.05896 | 2106829.43815 | 37.7658493270204 | -122.38795143981 | (37.7658493270204, -122.38795143981) | 14 | 3 | 9 | 310 | 20 | |||
| 17659 | 188786 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015977.25571 | 2106854.57611 | 37.7659183059205 | -122.387955972402 | (37.7659183059205, -122.387955972402) | 14 | 3 | 9 | 310 | 20 | |||
| 14181 | 188787 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015968.04519 | 2106982.6549 | 37.7662694722874 | -122.387996768362 | (37.7662694722874, -122.387996768362) | 14 | 3 | 9 | 310 | 20 | |||
| 9264 | 188788 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015967.32751 | 2107012.0323 | 37.7663500965054 | -122.388001300914 | (37.7663500965054, -122.388001300914) | 14 | 3 | 9 | 310 | 20 | |||
| 13982 | 189273 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015966.51086 | 2107036.5181 | 37.7664172839651 | -122.388005834417 | (37.7664172839651, -122.388005834417) | 14 | 3 | 9 | 310 | 20 | |||
| 18169 | 189274 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015965.43281 | 2107064.27168 | 37.7664934295578 | -122.388011500129 | (37.7664934295578, -122.388011500129) | 14 | 3 | 9 | 310 | 20 | |||
| 5864 | 189275 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015964.59668 | 2107087.77889 | 37.7665579289401 | -122.388016032733 | (37.7665579289401, -122.388016032733) | 14 | 3 | 9 | 310 | 20 | |||
| 18958 | 191526 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.7668795291963 | -122.387914043316 | (37.7668795291963, -122.387914043316) | 14 | 3 | 9 | 310 | 20 | |||
| 3180 | 191527 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.7668840087222 | -122.387813186138 | (37.7668840087222, -122.387813186138) | 14 | 3 | 9 | 310 | 20 |
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) );