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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 1060 | 1060 | 71174 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1432 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5988368.0802 | 2099689.3718 | 37.7446763519612 | -122.48292408536301 | (37.7446763519612, -122.482924085363) | ||
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 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) | |||
| 1815 | 1815 | 71427 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.802997311571104 | -122.409613538987 | (37.8029973115711, -122.409613538987) | |
| 2683 | 2683 | 71631 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2017 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.776162677429205 | -122.496198392825 | (37.7761626774292, -122.496198392825) | |
| 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) | ||
| 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) | ||
| 3489 | 3489 | 74967 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 8 | 3x3 | 6012084.12824 | 2119041.9172900002 | 37.799165460472295 | -122.40227854024401 | (37.7991654604723, -122.402278540244) | |
| 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) | |
| 4279 | 4279 | 78830 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | ||
| 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) | |
| 4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 4393 | 4393 | 71591 | Undocumented 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 187 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 11:19:00 AM | 3 | 5994642.6055 | 2086698.5979 | 37.709369932055004 | -122.460287110874 | (37.709369932055, -122.460287110874) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 4832 | 4832 | 70442 | Undocumented 2 | Tree(s) :: 17 | 2470 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | |
| 4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 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) | ||||
| 5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
| 5225 | 5225 | 73666 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 725 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1988 12:00:00 AM | 8 | 6007366.2246900005 | 2113649.85624 | 37.7840957097951 | -122.418221641431 | (37.7840957097951, -122.418221641431) | ||
| 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) | |||
| 5541 | 5541 | 81381 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.41688358241899 | (37.7863320683098, -122.416883582419) | ||
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) |
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");