Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
517 | 517 | 248948 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 01:15:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
519 | 519 | 6766 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:39:00 PM | 3 | 3x3 | 6017299.75412 | 2096896.40625 | 37.7386484107882 | -122.38268866835199 | (37.7386484107882, -122.382688668352) | ||
520 | 520 | 4707 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 968 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 09:15:00 PM | 3 | 5x5 | 6008654.9315 | 2120594.2013 | 37.8032356306012 | -122.414254658567 | (37.8032356306012, -122.414254658567) | ||
521 | 521 | 5204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 777 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/21/2016 12:00:00 AM | 3 | 4X4 | 6001528.9942 | 2111019.6475 | 37.7765435284866 | -122.438227828795 | (37.7765435284866, -122.438227828795) | |
522 | 522 | 6768 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1275 Fairfax Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:41:00 PM | 3 | 3x3 | 6017334.44654 | 2096871.02128 | 37.738580625297 | -122.382566951429 | (37.738580625297, -122.382566951429) | ||
525 | 525 | 248950 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 01:18:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
526 | 526 | 18856 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004191.661859999 | 2115995.22985 | 37.790356315029996 | -122.429371791378 | (37.79035631503, -122.429371791378) | |||
527 | 527 | 248946 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 01:12:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
528 | 528 | 248942 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
532 | 532 | 6761 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1275 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:35:00 PM | 3 | 3x3 | 6017199.30801 | 2096970.01555 | 37.738844977413 | -122.383041088382 | (37.738844977413, -122.383041088382) | ||
535 | 535 | 13638 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 576 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6012273.72895 | 2115490.3220900004 | 37.7894242082171 | -122.40137272597799 | (37.7894242082171, -122.401372725978) | |||
546 | 546 | 12251 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | ||
551 | 551 | 1664 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000454.8566 | 2109968.1462 | 37.7735952220186 | -122.441868082855 | (37.7735952220186, -122.441868082855) | |||
555 | 555 | 242524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1902 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008008.060219999 | 2107332.79337 | 37.7667866624906 | -122.415553715331 | (37.7667866624906, -122.415553715331) | ||
556 | 556 | 20399 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
562 | 562 | 15241 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 49662 | 6008042.0 | 2110573.0 | 37.7756854149614 | -122.415665767345 | (37.7756854149614, -122.415665767345) | ||
576 | 576 | 240412 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 1 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.059769999 | 2103920.2632400002 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | ||
582 | 582 | 27390 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | |||
584 | 584 | 14069 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007575.3554 | 2111000.5411 | 37.7768330981624 | -122.417310315452 | (37.7768330981624, -122.417310315452) | |||
586 | 586 | 237035 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/12/2017 02:27:00 PM | 3 | Width 4ft | 6005709.86547 | 2109855.10938 | 37.7735828886787 | -122.423682154918 | (37.7735828886787, -122.423682154918) | ||
590 | 590 | 98625 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002285.2374 | 2120040.8430000003 | 37.8013564005351 | -122.43625752618999 | (37.8013564005351, -122.43625752619) | ||
596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
600 | 600 | 229041 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1398 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1990 12:00:00 AM | 10 | Width 3ft | 6004493.077930001 | 2100786.6559900003 | 37.7486143110022 | -122.427245115077 | (37.7486143110022, -122.427245115077) | ||
605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
614 | 614 | 2880 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1477 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007321.86349 | 2116079.14078 | 37.7907634327304 | -122.41854743611 | (37.7907634327304, -122.41854743611) | |||
616 | 616 | 8142 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.777707304798206 | -122.432059137251 | (37.7777073047982, -122.432059137251) | |||
618 | 618 | 20377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
622 | 622 | 237036 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:42:00 PM | 3 | Width 4ft | 6005705.053180001 | 2109878.39065 | 37.7736465417793 | -122.423700457022 | (37.7736465417793, -122.423700457022) | ||
625 | 625 | 242532 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2140 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 3ft | 6008084.96302 | 2105937.52751 | 37.7629599086871 | -122.41518894402 | (37.7629599086871, -122.41518894402) | ||
626 | 626 | 251342 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
629 | 629 | 251338 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
639 | 639 | 20004 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
643 | 643 | 239154 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 6 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:47:00 PM | 3 | Width 4ft | 6005701.84613 | 2109911.12293 | 37.773736235682 | -122.42371387848999 | (37.773736235682, -122.42371387849) | ||
647 | 647 | 13705 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011215.546569999 | 2114485.16599 | 37.786605191509295 | -122.404963137048 | (37.7866051915093, -122.404963137048) | |||
652 | 652 | 237023 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | ||
656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
657 | 657 | 5214 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 835 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/09/2001 12:00:00 AM | 3 | 3X3 | 6001489.0793 | 2111327.2763 | 37.7773859294292 | -122.438387950593 | (37.7773859294292, -122.438387950593) | |
661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
674 | 674 | 251361 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | ||||
679 | 679 | 187631 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | |
686 | 686 | 23735 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.778090453740504 | -122.430059798517 | (37.7780904537405, -122.430059798517) | ||
690 | 690 | 230152 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6004291.387 | 2105480.80272 | 37.761491925527395 | -122.42827706645299 | (37.7614919255274, -122.428277066453) | |||
691 | 691 | 230156 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6004288.891419999 | 2105591.3935700003 | 37.7617954404249 | -122.42829357981 | (37.7617954404249, -122.42829357981) | |||
696 | 696 | 5946 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.43084551167601 | (37.7815635260957, -122.430845511676) | |||
698 | 698 | 230154 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6004288.78705 | 2105528.40005 | 37.7616224693351 | -122.42828945101999 | (37.7616224693351, -122.42828945102) | |||
699 | 699 | 230157 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6004285.8388 | 2105617.0111 | 37.7618656073228 | -122.428305963472 | (37.7618656073228, -122.428305963472) | |||
700 | 700 | 6319 | DPW Maintained 3 | Tristania conferta :: 79 | 1860 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001987.058999999 | 2112951.3489 | 37.781873535447396 | -122.436781566115 | (37.7818735354474, -122.436781566115) | |||
704 | 704 | 2199 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000885.4114 | 2112518.5919999997 | 37.7806226245627 | -122.440561697516 | (37.7806226245627, -122.440561697516) | |||
709 | 709 | 251360 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
710 | 710 | 1291 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2017 01:08:00 PM | 3 | 3x3 | 5992151.4222 | 2087298.4709 | 37.7108734249293 | -122.468940594456 | (37.7108734249293, -122.468940594456) | ||
715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
716 | 716 | 236224 | DPW Maintained 3 | Platanus racemosa :: California Sycamore 81 | 740 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 7 | Width 3ft | 6006211.6156 | 2105275.09716 | 37.7610355717565 | -122.421621166906 | (37.7610355717565, -122.421621166906) | ||
722 | 722 | 230151 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 3ft | 6004293.8189199995 | 2105454.00937 | 37.761418494979296 | -122.42826674581998 | (37.7614184949793, -122.42826674582) | |||
723 | 723 | 230153 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6004293.15538 | 2105508.69845 | 37.7615686206128 | -122.428272938555 | (37.7615686206128, -122.428272938555) | |||
725 | 725 | 230155 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6004284.84721 | 2105568.89365 | 37.7617334321738 | -122.42830596346201 | (37.7617334321738, -122.428305963462) | |||
727 | 727 | 221435 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 1 | Width 3ft | 6005438.10251 | 2108158.21074 | 37.768908269319795 | -122.424501499347 | (37.7689082693198, -122.424501499347) | ||
731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
732 | 732 | 25708 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 586 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6012145.80041 | 2110254.86265 | 37.77504171494321 | -122.40144725460199 | (37.7750417149432, -122.401447254602) | |||
733 | 733 | 221433 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 1 | Width 3ft | 6005435.4614 | 2108218.9893400003 | 37.7690750036386 | -122.42451495861201 | (37.7690750036386, -122.424514958612) | ||
735 | 735 | 24812 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2425 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002709.02465 | 2116620.06864 | 37.7919879109555 | -122.434546304291 | (37.7919879109555, -122.434546304291) | ||
737 | 737 | 221436 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.768836694985396 | -122.424492330751 | (37.7688366949854, -122.424492330751) | ||
738 | 738 | 20446 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
740 | 740 | 26411 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996554.84409 | 2116119.62648 | 37.7902625562289 | -122.45580349675699 | (37.7902625562289, -122.455803496757) | |||
745 | 745 | 221429 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:39:00 AM | 1 | Width 3ft | 6005428.96653 | 2108339.30361 | 37.76940499098671 | -122.424545983407 | (37.7694049909867, -122.424545983407) | ||
746 | 746 | 251371 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
747 | 747 | 251378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
748 | 748 | 195045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 312 06th St | 1 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.40556550564501 | (37.7783317443601, -122.405565505645) | |||
749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
750 | 750 | 251368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6010822.0 | 2111616.0 | 37.7787051302825 | -122.40612250689199 | (37.7787051302825, -122.406122506892) | |||
753 | 753 | 48 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6003376.13457 | 2107738.85817 | 37.767640169485105 | -122.43160376032499 | (37.7676401694851, -122.431603760325) | |||
754 | 754 | 221432 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.769168602384205 | -122.42452243915301 | (37.7691686023842, -122.424522439153) | ||
757 | 757 | 251377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
759 | 759 | 221434 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 1 | Width 3ft | 6005437.11129 | 2108190.56795 | 37.7689970584876 | -122.42450722982001 | (37.7689970584876, -122.42450722982) | ||
760 | 760 | 38424 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1451 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/24/2005 12:00:00 AM | 12 | 3x3 | Permit Number 48015 | 6007280.7970900005 | 2117415.82487 | 37.79443132398921 | -122.418784361633 | (37.7944313239892, -122.418784361633) |
762 | 762 | 7350 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.790403357673895 | -122.434214763813 | (37.7904033576739, -122.434214763813) | |||
763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
764 | 764 | 251379 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
766 | 766 | 221431 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 1 | Width 3ft | 6005433.2519 | 2108280.1340799998 | 37.769242767658 | -122.424526951068 | (37.769242767658, -122.424526951068) | ||
770 | 770 | 231129 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 821 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6003305.97559 | 2107686.68734 | 37.7674929441754 | -122.431842705671 | (37.7674929441754, -122.431842705671) | |||
772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
773 | 773 | 221437 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.3361400003 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | ||
778 | 778 | 100816 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 261 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6010798.79921 | 2111766.85068 | 37.779118033309395 | -122.406213398837 | (37.7791180333094, -122.406213398837) | |||
779 | 779 | 14058 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6007799.3288 | 2111218.6717 | 37.7774446311696 | -122.416550977219 | (37.7774446311696, -122.416550977219) | |||
781 | 781 | 251370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 390 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
785 | 785 | 251376 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
786 | 786 | 251369 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
787 | 787 | 221428 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.769467407522896 | -122.424551705821 | (37.7694674075229, -122.424551705821) | ||
789 | 789 | 175382 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991305.518069999 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | |||
790 | 790 | 216490 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 800x Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 3ft | 6001788.93125 | 2095501.57158 | 37.7339494063362 | -122.436217839104 | (37.7339494063362, -122.436217839104) | |||
791 | 791 | 191798 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 3 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.987380001 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | |
792 | 792 | 199372 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2 Newhall St | 2 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.37845506126499 | (37.7395514542225, -122.378455061265) | |
794 | 794 | 212187 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | ||||
796 | 796 | 212189 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002068.0773599995 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | ||||
797 | 797 | 212191 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002043.865019999 | 2095478.6742 | 37.7339010165159 | -122.435334819059 | (37.7339010165159, -122.435334819059) | ||||
798 | 798 | 175378 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 5991360.88178 | 2088922.0136900002 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) |
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");