Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qCaretaker
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21462 | 21462 | 25153 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004788.48534 | 2107965.7019599997 | 37.768342979778204 | -122.426734771418 | (37.7683429797782, -122.426734771418) | |||
| 21463 | 21463 | 4204 | DPW Maintained 3 | Gleditsia triacanthos :: Honey Locust 67 | 3912 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004409.0470900005 | 2100465.8043299997 | 37.7477285741092 | -122.427512837863 | (37.7477285741092, -122.427512837863) | |||
| 21464 | 21464 | 23593 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 220X Vasquez Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994492.71955 | 2099073.95458 | 37.743341039961706 | -122.461701819996 | (37.7433410399617, -122.461701819996) | |||
| 21465 | 21465 | 612 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3114 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6008205.07322 | 2102132.16672 | 37.7525180063146 | -122.41450423619601 | (37.7525180063146, -122.414504236196) | |||
| 21466 | 21466 | 10087 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005642.33302 | 2105078.4944700003 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | |||
| 21467 | 21467 | 1367 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999068.70954 | 2100015.2299099998 | 37.7461879050483 | -122.445946969396 | (37.7461879050483, -122.445946969396) | ||
| 21468 | 21468 | 5532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005017.6668300005 | 2103067.07529 | 37.7549054662318 | -122.42559336895599 | (37.7549054662318, -122.425593368956) | |||
| 21469 | 21469 | 15341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1735 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006768.902000001 | 2108274.3401 | 37.769302196475294 | -122.419906586242 | (37.7693021964753, -122.419906586242) | |||
| 21470 | 21470 | 1931 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 133 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000960.5535699995 | 2097531.18385 | 37.7394751476663 | -122.43922721078998 | (37.7394751476663, -122.43922721079) | |||
| 21471 | 21471 | 14146 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1670 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006264.94537 | 2109760.19882 | 37.7733536047148 | -122.421755304359 | (37.7733536047148, -122.421755304359) | |||
| 21472 | 21472 | 15304 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006931.2074 | 2109169.6745 | 37.7717697147956 | -122.41940870477801 | (37.7717697147956, -122.419408704778) | |||
| 21473 | 21473 | 7499 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2701 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008322.359759999 | 2102659.08935 | 37.7539714051695 | -122.414135913444 | (37.7539714051695, -122.414135913444) | |||
| 21474 | 21474 | 19114 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003435.2271 | 2108296.15906 | 37.7691737312185 | -122.43143915559999 | (37.7691737312185, -122.4314391556) | |||
| 21475 | 21475 | 15446 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2250 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2015 12:00:00 AM | 3 | 4X4 | 6006851.2872 | 2105336.6758 | 37.7612407013263 | -122.41941318446199 | (37.7612407013263, -122.419413184462) | ||
| 21476 | 21476 | 16622 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002888.88219 | 2107504.60291 | 37.766969331884 | -122.433272362446 | (37.766969331884, -122.433272362446) | |||
| 21477 | 21477 | 5128 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2768 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 25 | 3X3 | 6002485.1275 | 2095918.0660700002 | 37.735132535525395 | -122.433840637756 | (37.7351325355254, -122.433840637756) | ||
| 21478 | 21478 | 10278 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 215X Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/1996 12:00:00 AM | 6 | 6X6 | 6005000.61509 | 2109505.63565 | 37.7725832571536 | -122.42611067607099 | (37.7725832571536, -122.426110676071) | ||
| 21479 | 21479 | 17301 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 42 Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006920.3896 | 2109467.92122 | 37.7725880199615 | -122.41946728700701 | (37.7725880199615, -122.419467287007) | |||
| 21480 | 21480 | 24990 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 300 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004865.2254 | 2106541.92962 | 37.7644379804469 | -122.426367949619 | (37.7644379804469, -122.426367949619) | |||
| 21481 | 21481 | 29283 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998220.11441 | 2100025.88533 | 37.7461686694535 | -122.44888205975599 | (37.7461686694535, -122.448882059756) | ||
| 21482 | 21482 | 680 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1092X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005078.24263 | 2101996.40983 | 37.751969090723705 | -122.425307695709 | (37.7519690907237, -122.425307695709) | |||
| 21483 | 21483 | 7016 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1055 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002352.4572 | 2110178.4231 | 37.77428053605671 | -122.43531904958999 | (37.7742805360567, -122.43531904959) | |||
| 21484 | 21484 | 30010 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005675.35784 | 2098723.21181 | 37.7430153540666 | -122.423010159912 | (37.7430153540666, -122.423010159912) | ||
| 21485 | 21485 | 17133 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2021 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997314.265 | 2109127.7618 | 37.7711082865548 | -122.452671141791 | (37.7711082865548, -122.452671141791) | |||
| 21486 | 21486 | 5165 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 297 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001758.693 | 2109374.3022 | 37.7720388831078 | -122.43731539429399 | (37.7720388831078, -122.437315394294) | |||
| 21487 | 21487 | 2309 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2213 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009668.22468 | 2104416.43849 | 37.7588721941234 | -122.409605599315 | (37.7588721941234, -122.409605599315) | |||
| 21488 | 21488 | 17104 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1759 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2011 12:00:00 AM | 3 | 3X3 | 5998594.0891 | 2109307.42 | 37.7716748313468 | -122.44825714339899 | (37.7716748313468, -122.448257143399) | ||
| 21489 | 21489 | 29601 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.090009999 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | ||
| 21490 | 21490 | 24016 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 385 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5991946.624 | 2096702.2763 | 37.7366821216583 | -122.470332802031 | (37.7366821216583, -122.470332802031) | |||
| 21491 | 21491 | 26033 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 4 | 3X3 | 5996445.70952 | 2088085.7556900003 | 37.7132823012984 | -122.45415544772699 | (37.7132823012984, -122.454155447727) | ||
| 21492 | 21492 | 2418 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2819 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/1990 12:00:00 AM | 12 | 3X3 | 6009865.51519 | 2100921.34162 | 37.749286491278205 | -122.40867670936501 | (37.7492864912782, -122.408676709365) | ||
| 21493 | 21493 | 16612 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 901X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6002770.07151 | 2107656.90563 | 37.7673807771327 | -122.43369419573901 | (37.7673807771327, -122.433694195739) | |||
| 21494 | 21494 | 23120 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1497 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1995 12:00:00 AM | 20 | 3x3 | 6006516.07082 | 2100897.42388 | 37.7490326531337 | -122.42025747722 | (37.7490326531337, -122.42025747722) | ||
| 21495 | 21495 | 7558 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2914 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3x3 | 6008334.08225 | 2101415.12982 | 37.7505564311505 | -122.414007378743 | (37.7505564311505, -122.414007378743) | ||
| 21496 | 21496 | 22902 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 245 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 20 | 6006120.48056 | 2108082.42198 | 37.7687386832705 | -122.42213581113998 | (37.7687386832705, -122.42213581114) | |||
| 21497 | 21497 | 9366 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 264 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001152.801969999 | 2098197.5633099996 | 37.7413158071797 | -122.438610236294 | (37.7413158071797, -122.438610236294) | |||
| 21498 | 21498 | 2053 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1992 12:00:00 AM | 12 | 3X3 | 6002061.47801 | 2095391.2920799998 | 37.7336620855229 | -122.43526767748001 | (37.7336620855229, -122.43526767748) | ||
| 21499 | 21499 | 24820 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/22/2008 12:00:00 AM | 12 | 3x3 | 6007910.58435 | 2094958.48618 | 37.732804121515606 | -122.415014921609 | (37.7328041215156, -122.415014921609) | ||
| 21500 | 21500 | 19120 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 14 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6003444.21523 | 2108222.90974 | 37.768973115855495 | -122.431402836492 | (37.7689731158555, -122.431402836492) | |||
| 21501 | 21501 | 639 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007596.74853 | 2102059.47083 | 37.7522842059666 | -122.416602782609 | (37.7522842059666, -122.416602782609) | ||
| 21502 | 21502 | 22811 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 32 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999040.27831 | 2099578.26939 | 37.7449864935489 | -122.44601385736401 | (37.7449864935489, -122.446013857364) | |||
| 21503 | 21503 | 25093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005193.32199 | 2100633.40551 | 37.7482330964805 | -122.424812776293 | (37.7482330964805, -122.424812776293) | |||
| 21504 | 21504 | 5727 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1677X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005353.56233 | 2098539.50836 | 37.742492782318 | -122.424109780756 | (37.742492782318, -122.424109780756) | |||
| 21505 | 21505 | 10026 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 2x3 | 6005455.03663 | 2107324.1386599997 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | |||
| 21506 | 21506 | 25050 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 900X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005068.237380001 | 2102929.64641 | 37.7545309759388 | -122.425408702171 | (37.7545309759388, -122.425408702171) | |||
| 21507 | 21507 | 16606 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778401 | 6002876.94909 | 2107649.30437 | 37.7673659698008 | -122.43332397813101 | (37.7673659698008, -122.433323978131) | |
| 21508 | 21508 | 16954 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 660 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003830.0479 | 2110098.0565 | 37.7741436701635 | -122.430202060124 | (37.7741436701635, -122.430202060124) | |||
| 21509 | 21509 | 18378 | DPW Maintained 3 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 732 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/31/2012 12:00:00 AM | 3 | 3x3 | 6010381.26044 | 2104876.29383 | 37.760174782967404 | -122.407171993386 | (37.7601747829674, -122.407171993386) | ||
| 21510 | 21510 | 4053 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2934 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2016 12:00:00 AM | 1 | 3X3 | 6009951.6651099995 | 2100626.39211 | 37.74848144967 | -122.40835799863999 | (37.74848144967, -122.40835799864) | ||
| 21511 | 21511 | 28778 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1563 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2004 12:00:00 AM | 3 | 3X3 | 6005312.45481 | 2099224.4525200003 | 37.7443711621101 | -122.4243006232 | (37.7443711621101, -122.4243006232) | ||
| 21512 | 21512 | 25120 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | |||
| 21513 | 21513 | 604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.752563705358604 | -122.413779413197 | (37.7525637053586, -122.413779413197) | |||
| 21514 | 21514 | 4562 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 121X Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006491.79356 | 2098575.28631 | 37.7426552205681 | -122.42017664614299 | (37.7426552205681, -122.420176646143) | |||
| 21515 | 21515 | 18601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 509 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992650.5887 | 2088494.9319999998 | 37.7141874476643 | -122.467302314998 | (37.7141874476643, -122.467302314998) | |||
| 21516 | 21516 | 5129 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2775 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1983 12:00:00 AM | 10 | 3X3 | 6002512.34992 | 2095942.64763 | 37.735201575592704 | -122.433748276472 | (37.7352015755927, -122.433748276472) | ||
| 21517 | 21517 | 15533 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6007088.4849 | 2102162.4711 | 37.7525384229961 | -122.418367745483 | (37.7525384229961, -122.418367745483) | |||
| 21518 | 21518 | 23039 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 974 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1999 12:00:00 AM | 3 | 3X3 | 6006288.09528 | 2103940.95103 | 37.7573766296546 | -122.42126191472299 | (37.7573766296546, -122.421261914723) | ||
| 21519 | 21519 | 22986 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 647 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/1999 12:00:00 AM | 10 | 3x3 | 6006244.96206 | 2105792.52209 | 37.76245817961 | -122.42154258504401 | (37.76245817961, -122.421542585044) | ||
| 21520 | 21520 | 128 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1037 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001838.59138 | 2107604.25584 | 37.767183315676796 | -122.436912281202 | (37.7671833156768, -122.436912281202) | |||
| 21521 | 21521 | 28133 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6x9 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | |||
| 21522 | 21522 | 23957 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 5993225.3509 | 2098187.1604 | 37.7408330906162 | -122.46601959301 | (37.7408330906162, -122.46601959301) | |||
| 21523 | 21523 | 25203 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 185 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2001 12:00:00 AM | 3 | 3X3 | 6006444.66284 | 2110710.83424 | 37.775973953973896 | -122.421201152016 | (37.7759739539739, -122.421201152016) | ||
| 21524 | 21524 | 29079 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2261 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009682.37784 | 2104210.24464 | 37.7583068254181 | -122.40954209818199 | (37.7583068254181, -122.409542098182) | ||
| 21525 | 21525 | 18782 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 330 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000362.81841 | 2106970.76574 | 37.765359921353 | -122.44197127256001 | (37.765359921353, -122.44197127256) | |||
| 21526 | 21526 | 16916 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 484 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004686.86681 | 2110208.72077 | 37.7744960198036 | -122.42724605576599 | (37.7744960198036, -122.427246055766) | |||
| 21527 | 21527 | 23973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5993007.7128 | 2097807.2351 | 37.7397773533681 | -122.46674448708201 | (37.7397773533681, -122.466744487082) | |||
| 21528 | 21528 | 3888 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 22 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2013 12:00:00 AM | 3 | 3X3 | 6002160.53515 | 2108091.02303 | 37.7685381515323 | -122.435833558766 | (37.7685381515323, -122.435833558766) | ||
| 21529 | 21529 | 16649 | DPW Maintained 3 | Tilia americana :: Basswood Linden 323 | 184 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 5x5 | 6002850.067559999 | 2107218.6483 | 37.766181968246705 | -122.433386179746 | (37.7661819682467, -122.433386179746) | |||
| 21530 | 21530 | 15340 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1735 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2014 12:00:00 AM | 3 | 3x3 | 6006767.427999999 | 2108247.8081 | 37.7692292628506 | -122.41990980174499 | (37.7692292628506, -122.419909801745) | ||
| 21531 | 21531 | 29579 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 500X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991348.44459 | 2093803.51532 | 37.7286882509598 | -122.472189710993 | (37.7286882509598, -122.472189710993) | ||
| 21532 | 21532 | 4874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000875.46201 | 2097999.81649 | 37.7407570602008 | -122.439555005583 | (37.7407570602008, -122.439555005583) | |||
| 21533 | 21533 | 5767 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 449 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6003822.198969999 | 2108336.65808 | 37.7693068560416 | -122.430103531057 | (37.7693068560416, -122.430103531057) | |||
| 21534 | 21534 | 27687 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 450 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2000 12:00:00 AM | 6 | 3X3 | 6005508.13612 | 2106310.03189 | 37.7638375651828 | -122.424127803166 | (37.7638375651828, -122.424127803166) | ||
| 21535 | 21535 | 15301 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006957.7934 | 2109234.853 | 37.7719501768124 | -122.41932136637399 | (37.7719501768124, -122.419321366374) | |||
| 21536 | 21536 | 10341 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 926 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X4 | 6001658.9788 | 2109094.1055 | 37.771263863632704 | -122.437640242684 | (37.7712638636327, -122.437640242684) | ||
| 21537 | 21537 | 16070 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 251 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000403.76361 | 2094624.4309200002 | 37.731462184634 | -122.440943870862 | (37.731462184634, -122.440943870862) | |||
| 21538 | 21538 | 10477 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | |||
| 21539 | 21539 | 15350 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1911 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006807.5662 | 2107207.7202 | 37.7663756883733 | -122.419697157786 | (37.7663756883733, -122.419697157786) | |||
| 21540 | 21540 | 15481 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2601 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1994 12:00:00 AM | 12 | 3X3 | 6007032.3726 | 2103121.6868 | 37.7551690508786 | -122.418629807521 | (37.7551690508786, -122.418629807521) | ||
| 21541 | 21541 | 15552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2846 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6007045.846 | 2101751.2294 | 37.751406846694 | -122.418486040429 | (37.751406846694, -122.418486040429) | |||
| 21542 | 21542 | 7565 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2933 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6008395.085519999 | 2101323.9209 | 37.7503094179601 | -122.413789973034 | (37.7503094179601, -122.413789973034) | |||
| 21543 | 21543 | 126 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1034 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001930.03147 | 2107660.22402 | 37.7673421872283 | -122.43660001049801 | (37.7673421872283, -122.436600010498) | |||
| 21544 | 21544 | 18755 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 242 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1X1 | 6000867.0609 | 2107233.15183 | 37.766109089885894 | -122.440246037444 | (37.7661090898859, -122.440246037444) | |||
| 21545 | 21545 | 24295 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 312 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006623.0889099995 | 2097950.6145599997 | 37.7409474089032 | -122.419678351595 | (37.7409474089032, -122.419678351595) | |||
| 21546 | 21546 | 17107 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1781 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998487.0633 | 2109292.2527 | 37.7716270666505 | -122.44862625802799 | (37.7716270666505, -122.448626258028) | |||
| 21547 | 21547 | 26339 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2604 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 5997493.235780001 | 2089077.93045 | 37.7160665969585 | -122.45060634073 | (37.7160665969585, -122.45060634073) | ||
| 21548 | 21548 | 31364 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2295 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779235 | 5991014.76631 | 2099859.25307 | 37.745296448467 | -122.47378484391001 | (37.745296448467, -122.47378484391) | |
| 21549 | 21549 | 24559 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 430 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007368.686290001 | 2097246.0195 | 37.739054719089 | -122.417050431848 | (37.739054719089, -122.417050431848) | |||
| 21550 | 21550 | 27620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1149 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010601.0802 | 2102491.1542599997 | 37.7536380210979 | -122.40624368710199 | (37.7536380210979, -122.406243687102) | |||
| 21551 | 21551 | 30008 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005682.80795 | 2098743.3766799998 | 37.743071142629795 | -122.422985832334 | (37.7430711426298, -122.422985832334) | ||
| 21552 | 21552 | 27689 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 450 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6005509.70427 | 2106279.3421 | 37.763753386831 | -122.42412019670799 | (37.763753386831, -122.424120196708) | |||
| 21553 | 21553 | 29606 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991168.88017 | 2091040.07708 | 37.721090143382796 | -122.472609073864 | (37.7210901433828, -122.472609073864) | ||
| 21554 | 21554 | 10197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2004 12:00:00 AM | 3 | 2X2 | 6005817.7414 | 2101914.20762 | 37.7517851334751 | -122.42274455772301 | (37.7517851334751, -122.422744557723) | ||
| 21555 | 21555 | 14260 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2079 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004243.283 | 2107709.9898 | 37.7676100163363 | -122.428602345299 | (37.7676100163363, -122.428602345299) | |||
| 21556 | 21556 | 24377 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 27 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6006508.81485 | 2108487.4785700003 | 37.7698727679559 | -122.420821350349 | (37.7698727679559, -122.420821350349) | |||
| 21557 | 21557 | 7710 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 47 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006505.57437 | 2110325.13763 | 37.774918357632 | -122.420963052012 | (37.774918357632, -122.420963052012) | |||
| 21558 | 21558 | 29276 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5998710.28271 | 2100173.65077 | 37.7466024169627 | -122.44719775908399 | (37.7466024169627, -122.447197759084) | ||
| 21559 | 21559 | 19144 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003508.29583 | 2108036.92775 | 37.768466086156394 | -122.431167909289 | (37.7684660861564, -122.431167909289) | |||
| 21560 | 21560 | 14203 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005336.7919 | 2108761.7249 | 37.7705596524469 | -122.424894869154 | (37.7705596524469, -122.424894869154) | |||
| 21561 | 21561 | 5596 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1101-1103 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1994 12:00:00 AM | 8 | 3X3 | 6005167.29973 | 2101906.50174 | 37.7517272549302 | -122.424993326899 | (37.7517272549302, -122.424993326899) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");