trees
27,746 rows where qCaretaker_id = 1 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1424 | 264758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
1449 | 13614 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 555 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6012641.55561 | 2115729.4469 | 37.7901013041673 | -122.400116879409 | (37.7901013041673, -122.400116879409) | 12 | 2 | 9 | 28855 | 6 | |||
1453 | 23301 | DPW Maintained 1 | Eucalyptus melliodora :: Yellow Box 188 | 950X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.420966256023 | (37.7844601942992, -122.420966256023) | 7 | 9 | 9 | 28858 | 36 | |||
1468 | 261333 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
1476 | 20456 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
1492 | 20444 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
1494 | 21556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1409 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005783.75363 | 2114822.50195 | 37.7872263038018 | -122.423779835692 | (37.7872263038018, -122.423779835692) | 13 | 9 | 1 | 28858 | 41 | |||
1495 | 251251 | DPW Maintained 1 | Prunus amygdalus :: Almond 80 | 321X Corbett Ave | 2 | Front Yard : Yard | Tree | DPW 1 | 10x10 | 5999565 | 2105069 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | 15 | 5 | 5 | 28862 | 3 | ||||
1504 | 19794 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
1517 | 19783 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
1522 | 187744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Dukes Ct | 2 | Median : Yard | Tree | DPW 1 | 3 | 6016140.58365 | 2096258.22676 | 37.7368319916033 | -122.386652075929 | (37.7368319916033, -122.386652075929) | 10 | 3 | 8 | 58 | 1 | ||||
1524 | 28207 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
1526 | 262088 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1531 | 20287 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1534 | 28217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
1542 | 261489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
1544 | 245421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443998 | -122.409836678395 | (37.752691443998, -122.409836678395) | 2 | 4 | 7 | 28859 | 19 | |||
1553 | 221523 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005797.77147 | 2101666.82906 | 37.751104762181 | -122.422796037611 | (37.751104762181, -122.422796037611) | 2 | 4 | 5 | 28859 | 19 | |||
1567 | 240680 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005798.46813 | 2101640.54094 | 37.7510326203604 | -122.422791760451 | (37.7510326203604, -122.422791760451) | 2 | 4 | 5 | 28859 | 19 | ||
1568 | 172155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 649 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 6011250.4218 | 2091802.92791 | 37.7243267296922 | -122.403246295306 | (37.7243267296922, -122.403246295306) | 10 | 3 | 7 | 309 | 28 | |||
1570 | 172003 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6009403.11273 | 2093936.36515 | 37.7300813538655 | -122.409782729785 | (37.7300813538655, -122.409782729785) | 9 | 3 | 7 | 309 | 28 | ||
1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
1578 | 10783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
1581 | 19590 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 100 STAIRWAY4 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
1595 | 19920 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY36 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1612 | 11759 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
1620 | 16991 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | 15 | 5 | 11 | 29492 | 9 | |||
1623 | 20078 | DPW Maintained 1 | Fraxinus velutina 'Glabra' :: Arizona Ash 198 | 100 STAIRWAY56 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5X5 | |||||||||||||
1646 | 19899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
1654 | 19584 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
1672 | 9818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005621.8341 | 2113520.56064 | 37.783642353453 | -122.424247412091 | (37.783642353453, -122.424247412091) | 7 | 9 | 11 | 28858 | 41 | |||
1681 | 132077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012714.412 | 2120058.13658 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | 3 | 1 | 10 | 28860 | 6 | |||
1682 | 3092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2980 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000114.43818 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | 13 | 6 | 1 | 29490 | 27 | |||
1695 | 19761 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 100 STAIRWAY15 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
1696 | 12442 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004358.0388014 | 2115316.8218262 | 37.788502995764 | -122.428747755973 | (37.788502995764, -122.428747755973) | 13 | 9 | 11 | 29490 | 27 | |||
1707 | 262090 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1722 | 19403 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 400X Sloat Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | 20 | 5990261.3597061 | 2096050.1007314 | 37.7347938328013 | -122.47611180944 | (37.7347938328013, -122.47611180944) | 1 | 8 | 3 | 64 | 35 | |||
1723 | 19755 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1728 | 262141 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 2 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
1736 | 255231 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1752 | 865 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
1774 | 19805 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 100 STAIRWAY22 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20 | |||||||||||||
1785 | 19984 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
1786 | 19661 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 60 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
1792 | 195241 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400x Evans Ave | 17 | Median : Yard | Tree | DPW 1 | 5 | 6016370.1217 | 2098002.92096 | 37.7416352733631 | -122.385980035973 | (37.7416352733631, -122.385980035973) | 10 | 3 | 8 | 58 | 1 | ||||
1793 | 260413 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1510 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015825 | 2096697 | 37.7380192974637 | -122.387773802776 | (37.7380192974637, -122.387773802776) | 10 | 3 | 8 | 58 | 1 | ||||
1837 | 19878 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
1845 | 20002 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
1862 | 23733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X Webster St | 8 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6003923.026 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | 7 | 9 | 11 | 29490 | 41 | |||
1871 | 261422 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1110x Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
1873 | 20545 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1303X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
1879 | 261844 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 178 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004711 | 2102652 | 37.7537484337804 | -122.426624353927 | (37.7537484337804, -122.426624353927) | 2 | 4 | 5 | 28862 | 22 | ||||
1880 | 261557 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
1886 | 20313 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1890 | 261847 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 933 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004439 | 2103461 | 37.7559543766283 | -122.427622625941 | (37.7559543766283, -122.427622625941) | 2 | 4 | 5 | 28862 | 22 | ||||
1898 | 1593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 699 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995612.08469 | 2111572.44274 | 37.7777230574603 | -122.458736017911 | (37.7777230574603, -122.458736017911) | 11 | 6 | 2 | 54 | 11 | |||
1899 | 211289 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 100x Idora Ave | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 5995366.53481 | 2099407.60632 | 37.7443074262592 | -122.458704561274 | (37.7443074262592, -122.458704561274) | 1 | 8 | 4 | 59 | 40 | |||
1906 | 208208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 17 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5992145.29638 | 2096590.12464 | 37.7363856661623 | -122.469637749802 | (37.7363856661623, -122.469637749802) | 1 | 8 | 4 | 59 | 40 | |||
1908 | 119794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
1923 | 20027 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
1929 | 19668 | DPW Maintained 1 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 100 STAIRWAY5 | 67 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
1935 | 19720 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
1947 | 240678 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005819.90053 | 2101295.53343 | 37.7500865182761 | -122.422693129992 | (37.7500865182761, -122.422693129992) | 2 | 4 | 5 | 28859 | 19 | ||
1957 | 5266 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6001289.7409 | 2112772.8314 | 37.781343716873 | -122.439181159104 | (37.781343716873, -122.439181159104) | 15 | 5 | 11 | 29490 | 41 | |||
1959 | 19904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY34 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | |||||||||||||
1965 | 195920 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 15 Baldwin Ct | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 784616 | 6017944.92051 | 2093525.02511 | 37.7294268839465 | -122.380223738131 | (37.7294268839465, -122.380223738131) | 10 | 3 | 8 | 58 | 1 | ||
1970 | 260506 | DPW Maintained 1 | Tree(s) :: 17 | 289 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | ||||
1977 | 132113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.397977001937 | (37.7996825238869, -122.397977001937) | 3 | 1 | 10 | 28860 | 6 | |||
1982 | 20405 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
1994 | 10838 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X4 | 6017982.97201 | 2094620.05501 | 37.7324357213845 | -122.380168255061 | (37.7324357213845, -122.380168255061) | 10 | 3 | 8 | 58 | 1 | |||
2026 | 19643 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
2030 | 112443 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
2038 | 8035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005070.3181 | 2111601.5224 | 37.7783419907871 | -122.426018792814 | (37.7783419907871, -122.426018792814) | 7 | 9 | 11 | 28852 | 10 | |||
2047 | 20346 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
2053 | 9801 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1010 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005681.92309 | 2113158.17696 | 37.7826507298416 | -122.424013748222 | (37.7826507298416, -122.424013748222) | 7 | 9 | 11 | 28858 | 41 | |||
2056 | 5946 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.430845511676 | (37.7815635260957, -122.430845511676) | 15 | 9 | 11 | 29490 | 41 | |||
2092 | 262061 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
2093 | 221427 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.423275433821 | (37.7561368116793, -122.423275433821) | 2 | 4 | 5 | 28859 | 19 | ||
2096 | 3697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016390.48971 | 2099364.75407 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | 10 | 3 | 8 | 58 | 1 | |||
2097 | 12450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
2117 | 111271 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 42 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
2131 | 140415 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6003782.7679 | 2112770.1424 | 37.7814778785376 | -122.430556314217 | (37.7814778785376, -122.430556314217) | 15 | 9 | 11 | 29490 | 41 | |||
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
2160 | 29663 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2200X Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991214.62649 | 2094785.74836 | 37.7313774711782 | -122.472723912001 | (37.7313774711782, -122.472723912001) | 1 | 8 | 4 | 64 | 40 | |||
2169 | 19944 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
2188 | 260529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1814 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5982887.98375 | 2102765.67441 | 37.7528026329038 | -122.502100475367 | (37.7528026329038, -122.502100475367) | 1 | 8 | 3 | 56 | 35 | ||||
2191 | 258156 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
2194 | 261477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 6 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
2207 | 26390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1615X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6007069.43005 | 2109322.62762 | 37.7721974718223 | -122.418941432593 | (37.7721974718223, -122.418941432593) | 8 | 2 | 9 | 28853 | 19 | |||
2208 | 8032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | |||
2214 | 20033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
2217 | 20079 | DPW Maintained 1 | Fraxinus velutina 'Glabra' :: Arizona Ash 198 | 100 STAIRWAY56 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | |||||||||||||
2223 | 241387 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6004298.90777 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | 2 | 7 | 5 | 63 | 7 | |||
2235 | 16944 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
2237 | 2013 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 500X Bosworth St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6002577.18847 | 2095292.92439 | 37.7334212632741 | -122.433477690263 | (37.7334212632741, -122.433477690263) | 9 | 7 | 5 | 63 | 40 | |||
2258 | 264781 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 |
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) );