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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
1846 | 1846 | 251738 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | ||||
1801 | 1801 | 251699 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6005943.79297 | 2120373.7363400003 | 37.8024776288704 | -122.423620966152 | (37.8024776288704, -122.423620966152) |
1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
22409 | 22409 | 249318 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
13344 | 13344 | 187697 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.41284238591601 | (37.7500562758063, -122.412842385916) | ||||
4787 | 4787 | 180979 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 646 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:41:00 AM | 3 | Width 4ft | 6002832.2917599995 | 2089747.0840099999 | 37.7182081004084 | -122.432199805772 | (37.7182081004084, -122.432199805772) | |
4643 | 4643 | 180958 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 778 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 12:11:00 PM | 3 | Width 2ft | 6001688.47401 | 2089452.0208 | 37.71733300339179 | -122.43613238641001 | (37.7173330033918, -122.43613238641) | |
3931 | 3931 | 179081 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 72 Edinburgh St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 10:13:00 AM | 3 | Width 3ft | 6004328.31139 | 2093147.65709 | 37.7276300348981 | -122.42727080240499 | (37.7276300348981, -122.427270802405) | |
3942 | 3942 | 179080 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 72X Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 10:09:00 AM | 3 | Width 3ft | 6004338.45578 | 2093161.16244 | 37.7276676912897 | -122.42723669472099 | (37.7276676912897, -122.427236694721) | |
4350 | 4350 | 178825 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 927 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 09:33:00 AM | 3 | Width 3ft | 6004370.89542 | 2090731.88415 | 37.7209992632754 | -122.42695160693998 | (37.7209992632754, -122.42695160694) | |
4417 | 4417 | 178030 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 10:06:00 AM | 3 | Width 3ft | 6003911.3035 | 2091023.37584 | 37.7217736371229 | -122.42856104714899 | (37.7217736371229, -122.428561047149) | |
10035 | 10035 | 173805 | Permitted Site 1 | Private shrub :: Private Shrub 64 | 221 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999380.73268965 | 2095746.24622826 | 37.7344841059817 | -122.444561268208 | (37.7344841059817, -122.444561268208) | ||||
9954 | 9954 | 173752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) | |||
9956 | 9956 | 173750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.41664916584601 | (37.7573732040434, -122.416649165846) | ||||
9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
1809 | 1809 | 172747 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006022.78943 | 2120387.12776 | 37.802518857014704 | -122.423348551388 | (37.8025188570147, -122.423348551388) |
1812 | 1812 | 172746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006038.86692 | 2120389.38612 | 37.8025259652646 | -122.423293075825 | (37.8025259652646, -122.423293075825) |
4778 | 4778 | 161374 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 566 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:36:00 PM | 3 | Width 0ft | 6002430.61836 | 2090633.99378 | 37.720620574950296 | -122.43365156969101 | (37.7206205749503, -122.433651569691) | |
4356 | 4356 | 161318 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 530 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:04:00 AM | 3 | Width 0ft | 6002775.65928 | 2090671.8623400002 | 37.7207441256113 | -122.432461575944 | (37.7207441256113, -122.432461575944) | |
4749 | 4749 | 161284 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 567 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:30:00 PM | 3 | Width 0ft | 6002918.80865 | 2090311.02788 | 37.7197614706043 | -122.43194100068199 | (37.7197614706043, -122.431941000682) | |
4828 | 4828 | 161283 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 571 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:40:00 PM | 3 | Width 0ft | 6002905.32345 | 2090290.85572 | 37.719705317820896 | -122.431986174531 | (37.7197053178209, -122.431986174531) | |
4766 | 4766 | 161282 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 579 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:28:00 PM | 3 | Width 0ft | 6002876.7147 | 2090246.5176400002 | 37.7195819533337 | -122.432081900155 | (37.7195819533337, -122.432081900155) | |
4744 | 4744 | 161281 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 587 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:04:00 PM | 3 | Width 0ft | 6002852.8609 | 2090206.41919 | 37.719470499446395 | -122.432161491969 | (37.7194704994464, -122.432161491969) | |
4800 | 4800 | 161279 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 594 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:18:00 PM | 3 | Width 0ft | 6002806.05279 | 2090211.99508 | 37.7194831555901 | -122.43232368828998 | (37.7194831555901, -122.43232368829) | |
4742 | 4742 | 161277 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 582 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:23:00 PM | 3 | Width 0ft | 6002834.75222 | 2090259.2052900002 | 37.7196144116499 | -122.432227854755 | (37.7196144116499, -122.432227854755) | |
4748 | 4748 | 161275 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 574 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:26:00 PM | 3 | Width 0ft | 6002859.417719999 | 2090297.5513900002 | 37.7197211000357 | -122.432145332055 | (37.7197211000357, -122.432145332055) | |
3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
4825 | 4825 | 161272 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 562 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:33:00 PM | 3 | Width 0ft | 6002894.24566 | 2090355.62698 | 37.719882537321 | -122.43202908927499 | (37.719882537321, -122.432029089275) | |
4786 | 4786 | 161115 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 580 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:13:00 PM | 3 | Width 0ft | 6003070.44185 | 2090129.12968 | 37.719270613428705 | -122.431403880597 | (37.7192706134287, -122.431403880597) | |
4750 | 4750 | 160919 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 656 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:14:00 AM | 3 | Width 0ft | 6002115.87134 | 2090131.5374900002 | 37.719223077968294 | -122.43470363886001 | (37.7192230779683, -122.43470363886) | |
4754 | 4754 | 160918 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:50:00 AM | 3 | Width 0ft | 6002126.85051 | 2090151.3483900002 | 37.7192780975889 | -122.43466710393 | (37.7192780975889, -122.43466710393) | |
4770 | 4770 | 160917 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 646 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:31:00 AM | 3 | Width 0ft | 6002146.555269999 | 2090180.2898900001 | 37.719358683138 | -122.434601060409 | (37.719358683138, -122.434601060409) | |
4761 | 4761 | 160908 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:06:00 PM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | |
4732 | 4732 | 160902 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 687 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 03:13:00 PM | 3 | Width 0ft | 6002042.96964 | 2089934.48855 | 37.718677886450294 | -122.43494154733101 | (37.7186778864503, -122.434941547331) | |
4318 | 4318 | 160894 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 642 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:21:00 AM | 3 | Width 0ft | 6002380.66916 | 2090044.6321900003 | 37.7189994849067 | -122.43378212606702 | (37.7189994849067, -122.433782126067) | |
4402 | 4402 | 160893 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 634 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:15:00 AM | 3 | Width 0ft | 6002406.55833 | 2090085.42086 | 37.719112950580296 | -122.433695551007 | (37.7191129505803, -122.433695551007) | |
4376 | 4376 | 160888 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 679 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:26:00 AM | 3 | Width 0ft | 6002304.816330001 | 2089843.73714 | 37.7184435671833 | -122.43402996661999 | (37.7184435671833, -122.43402996662) | |
4426 | 4426 | 160887 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 687 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:35:00 AM | 3 | Width 0ft | 6002277.9096800005 | 2089801.2576099997 | 37.7183254007788 | -122.434119936579 | (37.7183254007788, -122.434119936579) | |
4815 | 4815 | 160876 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 623 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:58:00 AM | 3 | Width 0ft | 6002712.67368 | 2089986.17958 | 37.7188578210185 | -122.43263034363702 | (37.7188578210185, -122.432630343637) | |
4798 | 4798 | 160859 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 618 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:55:00 AM | 3 | Width 0ft | 6002917.16918 | 2089882.76457 | 37.7185854613346 | -122.43191610384 | (37.7185854613346, -122.43191610384) | |
4807 | 4807 | 160857 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 600 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:39:00 AM | 3 | Width 0ft | 6002958.77513 | 2089948.27932 | 37.718767708935296 | -122.431776964359 | (37.7187677089353, -122.431776964359) | |
4801 | 4801 | 160856 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 600 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:46:00 AM | 3 | Width 0ft | 6002966.83908 | 2089959.0451 | 37.718797726500796 | -122.431749858776 | (37.7187977265008, -122.431749858776) | |
4652 | 4652 | 160855 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 605 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:32:00 PM | 3 | Width 0ft | 6002988.68917 | 2089915.90653 | 37.7186805160719 | -122.43167125353399 | (37.7186805160719, -122.431671253534) | |
4666 | 4666 | 160854 | Undocumented 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 | 605 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:30:00 PM | 3 | Width 0ft | 6002981.40369 | 2089904.8646099998 | 37.71864978443121 | -122.43169564854799 | (37.7186497844312, -122.431695648548) | |
4728 | 4728 | 160846 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.8302099998 | 37.717770702526295 | -122.432363340291 | (37.7177707025263, -122.432363340291) | |
4718 | 4718 | 160845 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 03:09:00 PM | 3 | Width 0ft | 6002769.79165 | 2089568.5134700001 | 37.7177142412877 | -122.432403094831 | (37.7177142412877, -122.432403094831) | |
4637 | 4637 | 160693 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:34:00 PM | 3 | Width 0ft | 6003044.40323 | 2089957.59001 | 37.7187981275985 | -122.431481646786 | (37.7187981275985, -122.431481646786) | |
4796 | 4796 | 160687 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 PM | 3 | Width 0ft | 6002383.98515 | 2090374.0075 | 37.7199040644127 | -122.433794193158 | (37.7199040644127, -122.433794193158) | |
4686 | 4686 | 160611 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 04:11:00 PM | 3 | Width 0ft | 6002821.1864599995 | 2089320.8920099998 | 37.717037241564 | -122.432207771993 | (37.717037241564, -122.432207771993) | |
4644 | 4644 | 160608 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:37:00 PM | 3 | Width 0ft | 6002772.883169999 | 2089351.94517 | 37.717119767831505 | -122.43237694973499 | (37.7171197678315, -122.432376949735) | |
3455 | 3455 | 160606 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002538.27018 | 2089198.0058799998 | 37.716683778298 | -122.43317690119301 | (37.716683778298, -122.433176901193) | ||
4636 | 4636 | 160605 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 753 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:48:00 PM | 3 | Width 0ft | 6002503.48745 | 2089141.9591700002 | 37.7165279132188 | -122.43329312510201 | (37.7165279132188, -122.433293125102) | |
4649 | 4649 | 160603 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 771 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 12:20:00 PM | 3 | Width 0ft | 6002439.45935 | 2089043.6154099999 | 37.7162542504093 | -122.43350741373399 | (37.7162542504093, -122.433507413734) | |
4646 | 4646 | 160597 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 766 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:25:00 PM | 3 | Width 0ft | 6002414.55284 | 2089084.1537799998 | 37.716364146664205 | -122.433596398053 | (37.7163641466642, -122.433596398053) | |
4650 | 4650 | 160596 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 762 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:30:00 PM | 3 | Width 0ft | 6002428.15191 | 2089106.63112 | 37.71642663607071 | -122.43355099850599 | (37.7164266360707, -122.433550998506) | |
4656 | 4656 | 160582 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 725 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:12:00 PM | 3 | Width 0ft | 6002352.537690001 | 2089413.73171 | 37.7172655758154 | -122.433834295726 | (37.7172655758154, -122.433834295726) | |
4688 | 4688 | 160571 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 793 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:54:00 AM | 3 | Width 0ft | 6002167.83829 | 2089121.34733 | 37.716452270331295 | -122.43445182061899 | (37.7164522703313, -122.434451820619) | |
4633 | 4633 | 160570 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 795 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:41:00 AM | 3 | Width 0ft | 6002146.9194 | 2089087.66438 | 37.716358596934796 | -122.43452171951598 | (37.7163585969348, -122.434521719516) | |
4676 | 4676 | 160569 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 797 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:33:00 AM | 3 | Width 0ft | 6002135.10796 | 2089068.7183299998 | 37.7163059047739 | -122.434561191648 | (37.7163059047739, -122.434561191648) | |
4635 | 4635 | 160567 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 790 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:57:00 AM | 3 | Width 0ft | 6002104.08605 | 2089098.7371 | 37.716386568565 | -122.43467056358999 | (37.716386568565, -122.43467056359) | |
4654 | 4654 | 160563 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:34:00 PM | 3 | Width 0ft | 6002231.24921 | 2089300.0903 | 37.7169466582377 | -122.434245412715 | (37.7169466582377, -122.434245412715) | |
4653 | 4653 | 160561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 730 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:42:00 PM | 3 | Width 0ft | 6002306.04947 | 2089419.84324 | 37.7172797185636 | -122.43399542008001 | (37.7172797185636, -122.43399542008) | |
4648 | 4648 | 160560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 718 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:51:00 PM | 3 | Width 0ft | 6002343.44923 | 2089479.7194599998 | 37.7174462478135 | -122.43387042418301 | (37.7174462478135, -122.433870424183) | |
4665 | 4665 | 160559 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 710 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:15:00 PM | 3 | Width 0ft | 6002373.4779900005 | 2089525.5110400002 | 37.7175736853632 | -122.433769899784 | (37.7175736853632, -122.433769899784) | |
4655 | 4655 | 160555 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 500 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:28:00 PM | 3 | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.43412931651599 | (37.7179540086612, -122.434129316516) | |
4640 | 4640 | 160554 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 500 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:23:00 PM | 3 | Width 0ft | 6002263.49591 | 2089671.42563 | 37.717968092930995 | -122.43416048254299 | (37.717968092931, -122.434160482543) | |
4645 | 4645 | 160553 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 500 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:20:00 PM | 3 | Width 0ft | 6002250.4874599995 | 2089679.2270400003 | 37.7179887755522 | -122.434206004421 | (37.7179887755522, -122.434206004421) | |
4363 | 4363 | 160546 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 755 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:38:00 AM | 3 | Width 0ft | 6002026.63127 | 2089400.9055 | 37.7172118584185 | -122.434959882691 | (37.7172118584185, -122.434959882691) | |
4333 | 4333 | 160542 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 787 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:58:00 AM | 3 | Width 0ft | 6001926.33849 | 2089244.2387299999 | 37.716775991190794 | -122.435295346912 | (37.7167759911908, -122.435295346912) | |
4423 | 4423 | 160541 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 795 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 09:01:00 AM | 3 | Width 0ft | 6001897.94252 | 2089197.43685 | 37.7166458709939 | -122.435390151656 | (37.7166458709939, -122.435390151656) | |
4436 | 4436 | 160539 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 766 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:48:00 AM | 3 | Width 0ft | 6001957.37061 | 2089373.1576 | 37.717131736014 | -122.435197300138 | (37.717131736014, -122.435197300138) | |
4429 | 4429 | 160538 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 762 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:54:00 AM | 3 | Width 0ft | 6001968.73126 | 2089389.7304599998 | 37.7171778865305 | -122.435159216538 | (37.7171778865305, -122.435159216538) | |
4631 | 4631 | 160530 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 420X France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 04:06:00 PM | 3 | Width 0ft | 6002060.6240300005 | 2089797.75117 | 37.7183034384358 | -122.434870749998 | (37.7183034384358, -122.434870749998) | |
4675 | 4675 | 160521 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 786 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:59:00 AM | 3 | Width 0ft | 6001662.29271 | 2089410.30964 | 37.7172169863455 | -122.436219899452 | (37.7172169863455, -122.436219899452) | |
4678 | 4678 | 160520 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 782 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 12:02:00 PM | 3 | Width 0ft | 6001673.45326 | 2089428.5205599999 | 37.7172676235708 | -122.436182625252 | (37.7172676235708, -122.436182625252) | |
4672 | 4672 | 160512 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 718 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:07:00 PM | 3 | Width 0ft | 6001887.21385 | 2089766.7884 | 37.7182085743334 | -122.43546794121 | (37.7182085743334, -122.43546794121) | |
4681 | 4681 | 160510 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 706 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:18:00 PM | 3 | Width 0ft | 6001927.69711 | 2089831.3140900002 | 37.7183880466434 | -122.435332621096 | (37.7183880466434, -122.435332621096) | |
4720 | 4720 | 160434 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:17:00 PM | 3 | Width 0ft | 6002057.78511 | 2089843.09143 | 37.7184277715106 | -122.434883803643 | (37.7184277715106, -122.434883803643) | |
4722 | 4722 | 160433 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 401 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:12:00 PM | 3 | Width 0ft | 6002070.28716 | 2089835.8834 | 37.7184086896908 | -122.43484007413 | (37.7184086896908, -122.43484007413) | |
4803 | 4803 | 160423 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 525 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:43:00 PM | 3 | Width 0ft | 6002340.52441 | 2089668.33181 | 37.7179639695305 | -122.433894007997 | (37.7179639695305, -122.433894007997) | |
4632 | 4632 | 160422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 591 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:59:00 PM | 3 | Width 0ft | 6002364.11048 | 2089653.5699900002 | 37.7179247752893 | -122.43381142685 | (37.7179247752893, -122.43381142685) | |
4680 | 4680 | 160421 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 591 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 04:04:00 PM | 3 | Width 0ft | 6002387.355359999 | 2089638.81491 | 37.7178855801363 | -122.433730025613 | (37.7178855801363, -122.433730025613) | |
4827 | 4827 | 160418 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 645 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 04:39:00 PM | 3 | Width 0ft | 6002625.21582 | 2089488.7759200002 | 37.7174871004251 | -122.43289713470199 | (37.7174871004251, -122.432897134702) | |
4462 | 4462 | 160324 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 510X Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 02:10:00 PM | 3 | Width 0ft | 6001907.38785 | 2089113.4382599997 | 37.7164157659386 | -122.435351498769 | (37.7164157659386, -122.435351498769) | |
4490 | 4490 | 160323 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 510X Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 01:57:00 PM | 3 | Width 0ft | 6001921.46763 | 2089105.50941 | 37.7163947946735 | -122.43530226538999 | (37.7163947946735, -122.43530226539) | |
4687 | 4687 | 160322 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 510X Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:36:00 AM | 3 | Width 0ft | 6001932.580630001 | 2089099.8242400002 | 37.716379815556294 | -122.435263447059 | (37.7163798155563, -122.435263447059) | |
4505 | 4505 | 160320 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 550X Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 02:08:00 PM | 3 | Width 0ft | 6001986.11056 | 2089065.71241 | 37.716289191780795 | -122.435075983386 | (37.7162891917808, -122.435075983386) | |
4664 | 4664 | 160319 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 550X Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:39:00 AM | 3 | Width 0ft | 6002000.464380001 | 2089057.1552900001 | 37.7162665108705 | -122.435025758047 | (37.7162665108705, -122.435025758047) | |
4674 | 4674 | 148023 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 553X Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:52:00 AM | 3 | Width 3ft | 6001969.852469999 | 2089122.8198900002 | 37.716445073051894 | -122.435136261339 | (37.7164450730519, -122.435136261339) | |
4743 | 4743 | 148019 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 605 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:12:00 PM | 3 | Width 3ft | 6002175.19846 | 2088993.45658 | 37.7161015284444 | -122.43441724168301 | (37.7161015284444, -122.434417241683) | |
58276 | 58276 | 122823 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | ||
169377 | 169377 | 122822 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.40940941357799 | (37.8019045299018, -122.409409413578) | |||
82635 | 82635 | 122813 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 889 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009956.83094511 | 2104043.07852524 | 37.757863199609794 | -122.40858112241999 | (37.7578631996098, -122.40858112242) | ||||
85902 | 85902 | 122812 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 889 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009956.83094511 | 2104043.07852524 | 37.757863199609794 | -122.40858112241999 | (37.7578631996098, -122.40858112242) |
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");