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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
106640 | 106640 | 98271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
79389 | 79389 | 98269 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscape plot | Permit Number 768491 | 6009963.0 | 2103401.0 | 37.7561005415225 | -122.40851449565001 | (37.7561005415225, -122.40851449565) | |
125626 | 125626 | 49691 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2003 12:00:00 AM | tx5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |
113240 | 113240 | 67948 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | ex3 | Permit Number 31662 | 5988736.13806 | 2111981.42447 | 37.778448401356705 | -122.48255196765498 | (37.7784484013567, -122.482551967655) |
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) | |
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) | |
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) | |
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) | |
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) | ||
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
56938 | 56938 | 33335 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) |
146950 | 146950 | 65205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 431 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 11 | 9x9 | Permit Number 32152 | 6003393.98479 | 2091066.8587599997 | 37.7218637419945 | -122.430352383372 | (37.7218637419945, -122.430352383372) |
90171 | 90171 | 59898 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 956 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | 9x6 | Permit Number 19365. I marked for a basin expansion. 9'x 6'. SB | 6009927.21867861 | 2103634.73860088 | 37.756740331390205 | -122.40865472852501 | (37.7567403313902, -122.408654728525) | |
111386 | 111386 | 59894 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 912 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | 9x6 | Permit Number 775027 | 6009913.676206 | 2103880.39060941 | 37.75741407817 | -122.408718893172 | (37.75741407817, -122.408718893172) | |
30077 | 30077 | 47685 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 375 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 9 | 9x5 | Permit Number 45480 | 6013248.64993 | 2105253.57777 | 37.7613707751535 | -122.39728144108 | (37.7613707751535, -122.39728144108) |
75570 | 75570 | 61659 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 135 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 12 | 9x5 | Permit Number 21652 | 5992705.06832 | 2114574.24219 | 37.7857976650048 | -122.469010807999 | (37.7857976650048, -122.469010807999) |
120470 | 120470 | 68107 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 81 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1993 12:00:00 AM | 8 | 9x5 | Permit Number 31853 | 6008264.62082385 | 2099552.98532003 | 37.7454394970584 | -122.41411585648001 | (37.7454394970584, -122.41411585648) |
188480 | 188480 | 65600 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 18 | 9x4.5 | Permit Number 28502 | 6003805.36917 | 2093762.79554 | 37.7292894792277 | -122.429122461528 | (37.7292894792277, -122.429122461528) |
10939 | 10939 | 75321 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 9x4 | 5988672.5581 | 2099700.4669999997 | 37.7447245283024 | -122.481872085268 | (37.7447245283024, -122.481872085268) | |
66619 | 66619 | 35389 | Permitted Site 1 | Albizia julibrissin :: Mimosa Silk Tree 126 | 779 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 13 | 9x3 | Permit Number 38843 | 6011312.83562 | 2104732.123 | 37.7598310126183 | -122.403939953189 | (37.7598310126183, -122.403939953189) |
138432 | 138432 | 61405 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 295 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1984 12:00:00 AM | 20 | 9x15 | Permit Number 21329 | 6003584.02726273 | 2106584.03653725 | 37.7644810901638 | -122.430802264254 | (37.7644810901638, -122.430802264254) |
76963 | 76963 | 65206 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 459 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 21 | 9x12 | Permit Number 27192 | 6003301.10322 | 2090923.4573 | 37.7214647316905 | -122.43066322322201 | (37.7214647316905, -122.430663223222) |
140283 | 140283 | 51681 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 9x12 | Permit Number 47961 | 6001415.38816785 | 2088105.22450821 | 37.7136194817396 | -122.43697994924999 | (37.7136194817396, -122.43697994925) |
166455 | 166455 | 46858 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 358 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 13 | 9x12 | Permit Number 44927 | 6003840.59678 | 2091356.7817900002 | 37.7226850946194 | -122.4288292187 | (37.7226850946194, -122.4288292187) |
48983 | 48983 | 66073 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 654 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 14 | 8x8 | Permit Number 29116 | 6014375.99765 | 2104093.9898900003 | 37.7582494972364 | -122.39330123865801 | (37.7582494972364, -122.393301238658) |
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");