trees
27,746 rows where qCaretaker_id = 1 sorted by Police Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
| 130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
| 240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
| 280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
| 282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
| 326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
| 395 | 246548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.7724235852138 | -122.423543772638 | (37.7724235852138, -122.423543772638) | 7 | 9 | 11 | 28852 | 10 | |||
| 436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 1043 | 99282 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1500 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 6003016.20305 | 2114040.83621 | 37.7849234280868 | -122.433299082538 | (37.7849234280868, -122.433299082538) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 1400 | 23567 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2975 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/27/1992 12:00:00 AM | 3 | 3X3 | 6005531.33723 | 2120589.48411 | 37.8030467266869 | -122.425063628702 | (37.8030467266869, -122.425063628702) | 13 | 9 | 1 | 28858 | 17 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 1699 | 5933 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
| 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 | |||
| 1888 | 29108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 765 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2018 12:59:00 PM | 3 | 3x3 | 6007194.65596 | 2113631.10211 | 37.7840345567841 | -122.418813878265 | (37.7840345567841, -122.418813878265) | 7 | 9 | 9 | 28858 | 36 | ||
| 1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
| 1924 | 96221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 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 | |||
| 2077 | 2574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1660 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 10:41:00 AM | 3 | 4x4 | 6005572.29299 | 2115192.6753 | 37.788230768278 | -122.424537786114 | (37.788230768278, -122.424537786114) | 13 | 9 | 1 | 28858 | 41 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 7 | 9 | 11 | 28852 | 10 | |||
| 2517 | 20187 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1225 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6002803.937717 | 2112440.9213574 | 37.7805184210702 | -122.433919051618 | (37.7805184210702, -122.433919051618) | 15 | 9 | 11 | 29490 | 41 | |||
| 2692 | 18211 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1575 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004651.3172937 | 2114317.5621297 | 37.7857758731644 | -122.427661834419 | (37.7857758731644, -122.427661834419) | 13 | 9 | 11 | 28858 | 13 | |||
| 2730 | 138025 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 49 | Width 0ft | 6004878.9655 | 2114979.8902 | 37.7876073348692 | -122.426921423586 | (37.7876073348692, -122.426921423586) | 13 | 9 | 11 | 28858 | 27 | |||
| 2734 | 9598 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003113.218 | 2112071.7207 | 37.7795222347306 | -122.43282272297 | (37.7795222347306, -122.43282272297) | 15 | 9 | 11 | 29490 | 41 | |||
| 2789 | 8033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005024.9178 | 2111594.5788 | 37.7783203593831 | -122.426175354969 | (37.7783203593831, -122.426175354969) | 7 | 9 | 11 | 28852 | 10 | |||
| 2931 | 6985 | DPW Maintained 1 | Tristania conferta :: 61 | 819 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6003479.628 | 2110333.4443 | 37.7747701331995 | -122.431431030712 | (37.7747701331995, -122.431431030712) | 15 | 9 | 11 | 29492 | 10 | ||
| 2985 | 138087 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | 13 | 9 | 11 | 28858 | 27 | |||
| 3024 | 103847 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1529 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006640.1 | 2116184.7 | 37.7910148670423 | -122.420913805894 | (37.7910148670423, -122.420913805894) | 13 | 9 | 10 | 28858 | 21 | ||
| 3148 | 24262 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | 7 | 9 | 11 | 29490 | 41 | ||
| 3179 | 8036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005091.683 | 2111605.7953 | 37.7783549305744 | -122.425945187873 | (37.7783549305744, -122.425945187873) | 7 | 9 | 11 | 28852 | 10 | |||
| 3486 | 12249 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.426235730542 | (37.7758762780635, -122.426235730542) | 7 | 9 | 11 | 28852 | 10 | |||
| 3616 | 7957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.7912122663809 | -122.424102272302 | (37.7912122663809, -122.424102272302) | 13 | 9 | 1 | 28858 | 27 | ||
| 3705 | 244981 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/31/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | 7 | 9 | 11 | 28852 | 10 |
| 3709 | 33773 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2640 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/23/1996 12:00:00 AM | 12 | Permit Number 37820 | 5999639.77056 | 2117940.89784 | 37.7954398489265 | -122.44526091526 | (37.7954398489265, -122.44526091526) | 13 | 9 | 1 | 57 | 17 | |
| 3780 | 14742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.7793130940377 | -122.427075791541 | (37.7793130940377, -122.427075791541) | 7 | 9 | 11 | 29490 | 41 | |||
| 3864 | 2928 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1834 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005568.20527 | 2115901.70542 | 37.7901773571486 | -122.424602385305 | (37.7901773571486, -122.424602385305) | 13 | 9 | 1 | 28858 | 27 | |||
| 3866 | 18880 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2315 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2014 12:00:00 AM | 3 | 3x3 | 6003622.42952 | 2115918.82336 | 37.7901142787066 | -122.431335838788 | (37.7901142787066, -122.431335838788) | 13 | 9 | 1 | 29490 | 27 | ||
| 3878 | 14819 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | 15 | 9 | 11 | 29490 | 41 | |||
| 3901 | 8039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005222.0085 | 2111622.3531 | 37.778407758667 | -122.425495521768 | (37.778407758667, -122.425495521768) | 7 | 9 | 11 | 28852 | 10 | |||
| 4117 | 17881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | 13 | 9 | 11 | 29490 | 27 | |||
| 4161 | 7768 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 325X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.422123721721 | (37.7788345313197, -122.422123721721) | 7 | 9 | 11 | 28852 | 10 | |||
| 4180 | 9858 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1333 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005469.60975 | 2114245.25494 | 37.7856235881709 | -122.42482562463 | (37.7856235881709, -122.42482562463) | 13 | 9 | 11 | 28858 | 13 | |||
| 4186 | 133880 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 4ft | Permit Number 782825 | 5999941.97757 | 2117109.13743 | 37.7931733001669 | -122.444155434443 | (37.7931733001669, -122.444155434443) | 13 | 9 | 1 | 57 | 27 | ||
| 4315 | 14730 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 880 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
| 4348 | 8013 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 440 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2014 12:00:00 AM | 3 | 3X3 | 6005616.7891 | 2111728.1123 | 37.7787204453524 | -122.424137349487 | (37.7787204453524, -122.424137349487) | 7 | 9 | 11 | 28852 | 41 | ||
| 4353 | 6174 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | ||
| 4440 | 27355 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1199 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006390.54447 | 2114591.44108 | 37.7866261028977 | -122.421664048525 | (37.7866261028977, -122.421664048525) | 13 | 9 | 1 | 28858 | 41 | |||
| 4681 | 6924 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 446 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6005254.8423 | 2110638.1989 | 37.775707366557 | -122.425311885836 | (37.775707366557, -122.425311885836) | 7 | 9 | 11 | 28852 | 10 | |||
| 4697 | 6221 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1215 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6004907.86299 | 2113226.00352 | 37.7827932325916 | -122.426696498216 | (37.7827932325916, -122.426696498216) | 7 | 9 | 11 | 28858 | 41 | |||
| 4723 | 259742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 259 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/11/2019 12:00:00 AM | 3 | 6005340.35583 | 2109906.90312 | 37.7737042366543 | -122.424964031136 | (37.7737042366543, -122.424964031136) | 7 | 9 | 11 | 28852 | 10 | ||
| 4739 | 138026 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 57 | Width 0ft | 6004881.8597 | 2114953.842 | 37.7875359766764 | -122.426909554358 | (37.7875359766764, -122.426909554358) | 13 | 9 | 11 | 28858 | 27 | |||
| 4785 | 16923 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 503 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6004556.4237 | 2110140.1804 | 37.7743004469023 | -122.427692399322 | (37.7743004469023, -122.427692399322) | 7 | 9 | 11 | 28852 | 10 | ||||
| 4794 | 23518 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005659.14507 | 2119690.7477 | 37.8005862454143 | -122.424557378741 | (37.8005862454143, -122.424557378741) | 13 | 9 | 1 | 57 | 17 | |||
| 4947 | 6953 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 609 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004373.4958 | 2110460.1271 | 37.7751685930556 | -122.428347988839 | (37.7751685930556, -122.428347988839) | 7 | 9 | 11 | 28852 | 10 | ||
| 5001 | 138027 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | 13 | 9 | 11 | 28858 | 27 | |||
| 5005 | 2976 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2187 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X2 | 6003939.8571 | 2115601.6948 | 37.7892615083399 | -122.430214930957 | (37.7892615083399, -122.430214930957) | 13 | 9 | 11 | 29490 | 27 | |||
| 5127 | 261795 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | ||||
| 5261 | 262386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6005187.2243 | 2109578.99326 | 37.7727952246844 | -122.425470396534 | (37.7727952246844, -122.425470396534) | 7 | 9 | 11 | 28852 | 10 | ||||
| 5298 | 16892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 311 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 6 | 3X3 | 6005385.8444 | 2110257.3545 | 37.7746690605587 | -122.424831616025 | (37.7746690605587, -122.424831616025) | 7 | 9 | 11 | 28852 | 10 | ||
| 5305 | 5766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 414 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003770.1384677 | 2108392.97573 | 37.769458541933 | -122.430287624255 | (37.769458541933, -122.430287624255) | 15 | 9 | 5 | 29492 | 10 | |||
| 5329 | 8038 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 12 | 3X3 | 6005189.4271 | 2111616.4778 | 37.7783897855843 | -122.425607814865 | (37.7783897855843, -122.425607814865) | 7 | 9 | 11 | 28852 | 10 | ||
| 5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
| 5520 | 66956 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2253 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1992 12:00:00 AM | 18 | 4x4 | Permit Number 30287 | 6003206.54821 | 2116495.06774 | 37.7916729207242 | -122.432815936723 | (37.7916729207242, -122.432815936723) | 13 | 9 | 1 | 29490 | 27 | |
| 5524 | 13219 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2233 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001693 | 2119338 | 37.7993929119919 | -122.438256546601 | (37.7993929119919, -122.438256546601) | 13 | 9 | 1 | 57 | 17 | ||
| 5863 | 18680 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 150X Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 15X15TR | 5999310.28796 | 2119651.54595 | 37.8001180187875 | -122.446524108406 | (37.8001180187875, -122.446524108406) | 13 | 9 | 1 | 57 | 17 | |||
| 5920 | 4544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Cleary Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 6138 | 244422 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.7731308974862 | -122.423735193743 | (37.7731308974862, -122.423735193743) | 7 | 9 | 11 | 28852 | 10 | |||
| 6287 | 6206 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1155 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005354.90901 | 2113296.39872 | 37.7830117847389 | -122.425154916389 | (37.7830117847389, -122.425154916389) | 7 | 9 | 11 | 28858 | 41 | |||
| 6297 | 19148 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 49 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3PL | 6003502.2481852 | 2108041.9364589 | 37.7684794961424 | -122.431189185107 | (37.7684794961424, -122.431189185107) | 7 | 9 | 5 | 28862 | 3 | |||
| 6348 | 260900 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Steiner St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
| 6365 | 8477 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1900 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | |||
| 6626 | 138028 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 49 | Width 0ft | 6004887.6482 | 2114917.9533 | 37.7874377625804 | -122.426886970359 | (37.7874377625804, -122.426886970359) | 13 | 9 | 11 | 28858 | 27 | |||
| 6666 | 23307 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.62329 | 2114014.00443 | 37.7850491782092 | -122.421096875635 | (37.7850491782092, -122.421096875635) | 13 | 9 | 9 | 28858 | 36 | ||
| 6723 | 9723 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 417X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005743.31768 | 2111673.49547 | 37.7785776240411 | -122.423695752999 | (37.7785776240411, -122.423695752999) | 7 | 9 | 11 | 28852 | 10 | |||
| 6765 | 133006 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2012 12:00:00 AM | 2 | Width 4ft | 6006263.75126 | 2111819.37774 | 37.7790075453106 | -122.421905736669 | (37.7790075453106, -122.421905736669) | 7 | 9 | 11 | 28852 | 10 | ||
| 6820 | 244317 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005516.527 | 2110492.6418 | 37.7753224827652 | -122.424396296997 | (37.7753224827652, -122.424396296997) | 7 | 9 | 11 | 28852 | 10 | |||
| 6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
| 6830 | 260679 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
| 6892 | 23572 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3015 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6005516.07344 | 2120742.37785 | 37.8034656713563 | -122.425127334879 | (37.8034656713563, -122.425127334879) | 13 | 9 | 1 | 28858 | 17 | |||
| 6941 | 7350 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.7904033576739 | -122.434214763813 | (37.7904033576739, -122.434214763813) | 13 | 9 | 1 | 29490 | 27 | |||
| 6947 | 23903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | 13 | 9 | 11 | 29490 | 13 | |||
| 6948 | 20199 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | 15 | 9 | 11 | 29490 | 41 | ||
| 6960 | 23276 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 819 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 4x4 | 6006534.60812 | 2113350.76252 | 37.7832276265901 | -122.421077496141 | (37.7832276265901, -122.421077496141) | 7 | 9 | 11 | 28858 | 41 | |||
| 6987 | 249466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | 7 | 9 | 11 | 28858 | 36 |
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) );