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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
595 | 261954 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
624 | 20956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984893.4728491 | 2101578.9445242 | 37.749661815397 | -122.495077729215 | (37.749661815397, -122.495077729215) | 1 | 8 | 3 | 29491 | 35 | |||
632 | 23885 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003231.6817 | 2113926.646 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | 13 | 9 | 11 | 29490 | 13 | |||
657 | 20296 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
668 | 19865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
679 | 258141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 1x3 | 5998583.51543 | 2115521.94134 | 37.7887376884438 | -122.448741405189 | (37.7887376884438, -122.448741405189) | 13 | 6 | 1 | 54 | 31 | ||
682 | 16784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1961 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999039.4234543 | 2112720.6314145 | 37.781072082708 | -122.446962370058 | (37.781072082708, -122.446962370058) | 15 | 5 | 1 | 54 | 16 | |||
689 | 119914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | 100x100 | ||||||||||||||
690 | 19651 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
695 | 20360 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
707 | 27746 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1399 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | |||
710 | 256206 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
720 | 19950 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
750 | 11540 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018782.49291 | 2097080.98118 | 37.7392370206652 | -122.37757481115 | (37.7392370206652, -122.37757481115) | 10 | 3 | 8 | 58 | 1 | |||
760 | 112380 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3250 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6007972 | 2100641 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | 2 | 4 | 7 | 28859 | 19 | |||
766 | 17084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.7720659980909 | -122.445177292475 | (37.7720659980909, -122.445177292475) | 15 | 5 | 11 | 29492 | 9 | |||
768 | 20385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
776 | 113502 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x MANSELL ST | 8 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | |||
788 | 200933 | DPW Maintained 1 | Tristania conferta :: 61 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | 10 | 3 | 8 | 58 | 1 | |||
795 | 19570 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
798 | 19725 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
808 | 19837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY25 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
815 | 20416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
819 | 20315 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
822 | 112248 | DPW Maintained 1 | Acer spp :: Maple 88 | 1799X TAYLOR ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 15 | 6008739 | 2118839 | 37.7984210068607 | -122.413839504702 | (37.7984210068607, -122.413839504702) | 5 | 1 | 10 | 308 | 21 | ||||
825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
831 | 245412 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | 2 | 4 | 7 | 28859 | 19 | |||
833 | 106379 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
844 | 254210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
848 | 116677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
857 | 189910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.7422441899167 | -122.386410241063 | (37.7422441899167, -122.386410241063) | 10 | 3 | 8 | 58 | 1 | |||
859 | 10756 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1120X Hudson Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
874 | 19715 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
875 | 19954 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
876 | 5429 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 465 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6004961.54975 | 2105631.51156 | 37.7619436334085 | -122.42596997713 | (37.7619436334085, -122.42596997713) | 8 | 4 | 5 | 28859 | 19 | |||
878 | 126969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 5999145.58694 | 2118075.75757 | 37.795781916869 | -122.44698057642 | (37.795781916869, -122.44698057642) | 11 | 1 | 57 | 30 | ||||
898 | 262453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2005 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003839 | 2115372 | 37.7886251115209 | -122.43054748798 | (37.7886251115209, -122.43054748798) | 13 | 9 | 1 | 29490 | 27 | ||||
900 | 19637 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
906 | 25069 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640771 | -122.425185628926 | (37.752118640771, -122.425185628926) | 2 | 4 | 5 | 28862 | 22 | |||
929 | 257972 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5982601.27724 | 2100898.28737 | 37.7476584613609 | -122.502953711343 | (37.7476584613609, -122.502953711343) | 1 | 8 | 3 | 29491 | 35 | ||||
932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
946 | 133881 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | Permit Number 782825 | 5999916.99907 | 2117104.86853 | 37.7931601538699 | -122.444241554422 | (37.7931601538699, -122.444241554422) | 13 | 9 | 1 | 57 | 27 | ||
951 | 258181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 332 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009802.23856 | 2094053.68877 | 37.7304258589231 | -122.408411167734 | (37.7304258589231, -122.408411167734) | 10 | 3 | 7 | 309 | 28 | ||
954 | 20324 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
973 | 176338 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | 10 | 7 | 8 | 309 | 28 | |||
975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
978 | 8142 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.7777073047982 | -122.432059137251 | (37.7777073047982, -122.432059137251) | 15 | 9 | 11 | 29492 | 41 | |||
981 | 221424 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005689.53453 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | 2 | 4 | 5 | 28859 | 19 | ||
1012 | 24992 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004882.50848 | 2106257.62148 | 37.7636583150142 | -122.426287928865 | (37.7636583150142, -122.426287928865) | 8 | 4 | 5 | 28859 | 3 | |||
1020 | 256741 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1494 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 5987774.09162 | 2105131.6228 | 37.7595847299836 | -122.485377233769 | (37.7595847299836, -122.485377233769) | 1 | 8 | 3 | 56 | 35 | ||
1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
1062 | 20065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
1071 | 240683 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005765.02468 | 2102281.28975 | 37.7527900818195 | -122.422952946818 | (37.7527900818195, -122.422952946818) | 2 | 4 | 5 | 28859 | 19 | ||
1082 | 261856 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 937x Meade Ave | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
1083 | 94032 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1500 Oakdale Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015583.39088 | 2095096.21149 | 37.733610469696 | -122.388497468614 | (37.733610469696, -122.388497468614) | 10 | 3 | 8 | 58 | 1 | ||||
1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1107 | 258138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | |||
1108 | 627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.7524574855488 | -122.415658642859 | (37.7524574855488, -122.415658642859) | 2 | 4 | 7 | 28859 | 19 | |||
1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
1144 | 20400 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
1150 | 97170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 289 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | |||
1171 | 19952 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY39 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
1176 | 119263 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Lakeshore Dr | 1 | Median : Yard | Tree | DPW 1 | 10x30 | ||||||||||||||
1179 | 251578 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1000X Columbus Ave | 6 | Median : Cutout | Tree | DPW 1 | |||||||||||||||
1189 | 261265 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
1192 | 262086 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1200 | 216506 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 900x Bosworth St | 13 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001233.37936 | 2095653.14321 | 37.7343340068125 | -122.438149402085 | (37.7343340068125, -122.438149402085) | 9 | 7 | 5 | 63 | 40 | |||
1201 | 2190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.440623460362 | (37.7801623757286, -122.440623460362) | 15 | 5 | 1 | 29490 | 41 | |||
1202 | 254563 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 98x High St | 1 | unknown : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
1211 | 261654 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1150 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000820 | 2086851 | 37.7101418008042 | -122.43894799201 | (37.7101418008042, -122.43894799201) | 9 | 7 | 6 | 28861 | 5 | ||||
1215 | 253279 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | ROW IS 10' tree is street tree | |||||||||||||
1216 | 20357 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
1232 | 264776 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
1249 | 107933 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
1272 | 113499 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 200x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 19 | 3x3 | 6011193.56936 | 2090563.53064 | 37.7209204242214 | -122.403355677147 | (37.7209204242214, -122.403355677147) | 10 | 7 | 7 | 309 | 28 | |||
1295 | 19941 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
1302 | 14133 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1642X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006458.8907635 | 2109942.5653128 | 37.773865274364 | -122.421097370447 | (37.773865274364, -122.421097370447) | 7 | 2 | 11 | 28852 | 10 | |||
1311 | 23384 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1451X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | 13 | 9 | 1 | 28858 | 41 | |||
1313 | 1946 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 12 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.7338931798791 | -122.381526972425 | (37.7338931798791, -122.381526972425) | 10 | 3 | 8 | 58 | 1 | |||
1315 | 13622 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 562 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6012358.74659 | 2115584.5782 | 37.7896877563436 | -122.401085198325 | (37.7896877563436, -122.401085198325) | 4 | 2 | 10 | 28854 | 6 | |||
1343 | 23590 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3251X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
1348 | 261327 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
1350 | 19628 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
1360 | 238060 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2x Montezuma St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | 2 | 7 | 7 | 28859 | 2 | |||
1363 | 19612 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
1374 | 262313 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 1503x Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013266 | 2096325 | 37.7368557748906 | -122.396595525315 | (37.7368557748906, -122.396595525315) | 10 | 3 | 8 | 58 | 1 | ||||
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
1378 | 95407 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Cranleigh Dr | 9 | Median : Yard | Tree | DPW 1 | 80 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | ||||
1383 | 260901 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
1393 | 255136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
1398 | 20032 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3ST | |||||||||||||
1404 | 19975 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY45 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
1412 | 259415 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
1420 | 19991 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY46 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 |
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) );