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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150855 | 150855 | 62185 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 197 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1985 12:00:00 AM | 76 | Permit Number 22303 | 6000217.71423 | 2092424.5085200001 | 37.7254111079318 | -122.441429277242 | (37.7254111079318, -122.441429277242) | |
| 60978 | 60978 | 78261 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 50 | 6009735.35322 | 2092462.5528099998 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | ||
| 8499 | 8499 | 41209 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.44286834991101 | (37.7996299225355, -122.442868349911) | |
| 182797 | 182797 | 65606 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 142 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 47 | Permit Number 28510 | 6004334.881680001 | 2093748.3562099999 | 37.729279792610505 | -122.427290860879 | (37.7292797926105, -122.427290860879) | |
| 69427 | 69427 | 64508 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 841 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 36 | Permit Number 25389 | 6000432.9415 | 2111897.9264 | 37.7788926598871 | -122.442082438032 | (37.7788926598871, -122.442082438032) | |
| 79926 | 79926 | 112059 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 770 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 36 | 5x6 | 5991981.6527 | 2110175.44232 | 37.7736779395689 | -122.471193003562 | (37.7736779395689, -122.471193003562) | ||
| 86556 | 86556 | 61933 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | 36 | Permit Number 21990 | 6005702.47179 | 2100196.42976905 | 37.747062005493206 | -122.42302109514699 | (37.7470620054932, -122.423021095147) | |
| 145905 | 145905 | 63844 | Permitted Site 1 | Tree(s) :: 17 | 455 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/04/2012 12:00:00 AM | 36 | 3x6 | Permit Number 769147 | 6008789.26934359 | 2096671.5310686 | 37.7375571100932 | -122.412098096915 | (37.7375571100932, -122.412098096915) |
| 48548 | 48548 | 65198 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.4873099998 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | |
| 50789 | 50789 | 30773 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 548 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 34 | Permit Number 34652 | 6014000.72465 | 2112264.48181 | 37.7806629966488 | -122.395171417543 | (37.7806629966488, -122.395171417543) | |
| 30752 | 30752 | 72905 | Undocumented 2 | Quercus robur :: English Oak 358 | 130 Alpha St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 30 | 6010919.95523 | 2088121.9 | 37.7142009182997 | -122.404129735303 | (37.7142009182997, -122.404129735303) | ||
| 77013 | 77013 | 56360 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | |
| 89835 | 89835 | 33484 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.42106821147301 | (37.741769825751, -122.421068211473) |
| 119167 | 119167 | 67755 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 4726 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 30 | 4x18 | Permit Number 31695 | 5988692.74366 | 2109899.16641 | 37.77272857598221 | -122.482549464072 | (37.7727285759822, -122.482549464072) |
| 186613 | 186613 | 52520 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.7166900001 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | |
| 42360 | 42360 | 72161 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 362 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 29 | 6002558.54368 | 2091345.46237 | 37.7225813668208 | -122.433260183829 | (37.7225813668208, -122.433260183829) | ||
| 48510 | 48510 | 65202 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 415 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 29 | Permit Number 27188 | 6004121.8153800005 | 2090701.65991 | 37.7209021868562 | -122.42781045049999 | (37.7209021868562, -122.4278104505) | |
| 67931 | 67931 | 32978 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.2818299998 | 37.759262335300996 | -122.39339915324601 | (37.759262335301, -122.393399153246) | |
| 10987 | 10987 | 35857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.43458140929899 | (37.7261135989609, -122.434581409299) |
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 46276 | 46276 | 68880 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 28 | Permit Number 32851 | 6000180.507069999 | 2120770.20455 | 37.8032392229736 | -122.44359322865299 | (37.8032392229736, -122.443593228653) | |
| 92362 | 92362 | 30977 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 28 | 6x12 | Permit Number 34765 | 6004845.62321415 | 2117119.69586074 | 37.793480817021205 | -122.427189258656 | (37.7934808170212, -122.427189258656) |
| 117249 | 117249 | 65001 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 658 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/1989 12:00:00 AM | 28 | 5x5 | Permit Number 26040 | 6005876.15093075 | 2099541.24102227 | 37.7452728053486 | -122.422373981362 | (37.7452728053486, -122.422373981362) |
| 139910 | 139910 | 48952 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | |
| 152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
| 164599 | 164599 | 68540 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 562 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 28 | Permit Number 32423 | 5982889.49723 | 2111962.75458 | 37.7780552740204 | -122.50277598400801 | (37.7780552740204, -122.502775984008) | |
| 169514 | 169514 | 63586 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2442 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 27 | 3x3 | Permit Number 24214 | 6006281.75486 | 2119232.0932 | 37.7993620378872 | -122.422370285063 | (37.7993620378872, -122.422370285063) |
| 182383 | 182383 | 73713 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1265 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 27 | 6012277.51673 | 2102506.0830599996 | 37.7537726442006 | -122.400447210275 | (37.7537726442006, -122.400447210275) | ||
| 44875 | 44875 | 32939 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 26 | Permit Number 37259 | 6013402.96511 | 2105197.8174 | 37.76122625950521 | -122.39674381646999 | (37.7612262595052, -122.39674381647) | |
| 61285 | 61285 | 40196 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 562 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 26 | Permit Number 41380 | 5983509.69459 | 2111981.18634 | 37.778142310971106 | -122.500631896768 | (37.7781423109711, -122.500631896768) | |
| 141186 | 141186 | 61435 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.44387490382499 | (37.7589393153031, -122.443874903825) | |
| 141633 | 141633 | 41881 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 760 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 26 | 6x9 | Permit Number 42257 | 6001968.48686842 | 2108291.49196596 | 37.7690776786131 | -122.436512186736 | (37.7690776786131, -122.436512186736) |
| 143073 | 143073 | 41882 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 760 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 26 | 6x12 | Permit Number 42257 | 6001968.48686842 | 2108291.49196596 | 37.7690776786131 | -122.436512186736 | (37.7690776786131, -122.436512186736) |
| 187061 | 187061 | 65596 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 660 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | 26 | Permit Number 28498 | 6002534.62585 | 2089782.9928599999 | 37.718289816404706 | -122.433231273322 | (37.7182898164047, -122.433231273322) | |
| 187480 | 187480 | 71692 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 364 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 26 | 6x7 | 6006147.03421 | 2111101.3621799997 | 37.777029465781496 | -122.422258481339 | (37.7770294657815, -122.422258481339) | |
| 6684 | 6684 | 38517 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2150 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/1998 12:00:00 AM | 25 | 6x6 | Permit Number 40504 | 5997521.1508 | 2110251.9474 | 37.77420686213429 | -122.45203664156999 | (37.7742068621343, -122.45203664157) |
| 26478 | 26478 | 63265 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | |
| 37807 | 37807 | 32670 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 25 | Permit Number 37094 | 6011135.7894 | 2112024.86418 | 37.7798453222359 | -122.405065778479 | (37.7798453222359, -122.405065778479) | |
| 50200 | 50200 | 72162 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 342 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 25 | 6002176.04158 | 2091749.35017 | 37.723668645372705 | -122.43461127221201 | (37.7236686453727, -122.434611272212) | ||
| 65312 | 65312 | 69299 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1632 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | 25 | Permit Number 33374 | 5999947.982999999 | 2110939.1774 | 37.7762325313103 | -122.44369120188499 | (37.7762325313103, -122.443691201885) | |
| 75317 | 75317 | 34709 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 25 | Permit Number 38365 | 5981632.43118 | 2110780.81019 | 37.7747360459971 | -122.50703684968501 | (37.7747360459971, -122.507036849685) | |
| 75562 | 75562 | 62235 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 201 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 25 | Permit Number 33624 | 6001134.77871 | 2093315.77185 | 37.727910515444 | -122.438322898409 | (37.727910515444, -122.438322898409) | |
| 96064 | 96064 | 111890 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 176X PERALTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 25 | 3x3 | 6009847.0 | 2100071.0 | 37.7469506034955 | -122.408680755084 | (37.7469506034955, -122.408680755084) | ||
| 151527 | 151527 | 31480 | Permitted Site 1 | Melaleuca styphelliodes :: Paperbark Tree 239 | 449 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | 25 | Permit Number 35046 | 6001532.47021 | 2103206.30931 | 37.7550902238546 | -122.43765610507 | (37.7550902238546, -122.43765610507) | |
| 155435 | 155435 | 68456 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 107 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 25 | Permit Number 32318 | 5991466.74972 | 2114692.7979200003 | 37.7860515606903 | -122.47330365010401 | (37.7860515606903, -122.473303650104) | |
| 160527 | 160527 | 67252 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 874 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 25 | Permit Number 30716 | 5983584.68504 | 2109860.80212 | 37.77232475148129 | -122.500215683916 | (37.7723247514813, -122.500215683916) | |
| 183653 | 183653 | 30522 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 25 | Permit Number 34528 | 6008488.127169999 | 2112769.36057 | 37.781741165964704 | -122.414277931689 | (37.7817411659647, -122.414277931689) | |
| 7158 | 7158 | 30976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34765 | 6004885.74764 | 2117123.17132 | 37.7934926287434 | -122.427050672647 | (37.7934926287434, -122.427050672647) |
| 7558 | 7558 | 30975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x9 | Permit Number 34765 | 6004860.3383 | 2117120.17233 | 37.7934829574257 | -122.42713837725799 | (37.7934829574257, -122.427138377258) |
| 11023 | 11023 | 60053 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1406 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/1982 12:00:00 AM | 24 | 3x3 | Permit Number 19552 | 5988377.0869 | 2105705.2719 | 37.7611949257495 | -122.483333852456 | (37.7611949257495, -122.483333852456) |
| 20152 | 20152 | 30589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34559 | 6003171.8807 | 2110158.6701 | 37.7742727998886 | -122.43248310501801 | (37.7742727998886, -122.432483105018) |
| 63823 | 63823 | 37604 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | |
| 65760 | 65760 | 32217 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 525 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 24 | Permit Number 35538 | 6009485.22492 | 2100263.16237 | 37.747457969910705 | -122.409945309239 | (37.7474579699107, -122.409945309239) | |
| 72482 | 72482 | 116841 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | |||
| 85566 | 85566 | 63398 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2015 12:00:00 AM | 24 | 3x3 | Permit Number 770790 | 6001413.63019954 | 2104052.61523798 | 37.757407217509495 | -122.43812770874399 | (37.7574072175095, -122.438127708744) |
| 88350 | 88350 | 62378 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1985 12:00:00 AM | 24 | Permit Number 22527 | 5986003.033530001 | 2111613.32749 | 37.7772783336166 | -122.491979564694 | (37.7772783336166, -122.491979564694) | |
| 95139 | 95139 | 64130 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | 24 | Permit Number 24901 | 6002310.61439363 | 2098891.53580323 | 37.743287089709604 | -122.434656544552 | (37.7432870897096, -122.434656544552) | |
| 117709 | 117709 | 61473 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1984 12:00:00 AM | 24 | Permit Number 21416 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |
| 128320 | 128320 | 121150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |||
| 128505 | 128505 | 30974 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x9 | Permit Number 34765 | 6004845.62321415 | 2117119.69586074 | 37.793480817021205 | -122.427189258656 | (37.7934808170212, -122.427189258656) |
| 137151 | 137151 | 116378 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 3x3 | 6013444.81067 | 2105199.38309 | 37.761232887497 | -122.3965991992 | (37.761232887497, -122.3965991992) | ||
| 155548 | 155548 | 62205 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 220 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 24 | Permit Number 22327 | 6001113.38576 | 2093381.7245900002 | 37.728090389747294 | -122.438401577384 | (37.7280903897473, -122.438401577384) | |
| 163647 | 163647 | 42734 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2155 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 24 | Permit Number 42735 | 6011889.3836199995 | 2087568.31883 | 37.7127350143717 | -122.40074012757401 | (37.7127350143717, -122.400740127574) | |
| 169924 | 169924 | 42606 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1450 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 24 | Permit Number 42674 | 6006095.7199099995 | 2118663.62857 | 37.797790682161605 | -122.42297360696301 | (37.7977906821616, -122.422973606963) | |
| 175726 | 175726 | 117338 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 364 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6x7 | 6006121.81566 | 2111101.2962700003 | 37.7770278622883 | -122.42234571558201 | (37.7770278622883, -122.422345715582) | ||
| 184503 | 184503 | 40226 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 24 | Permit Number 41410 | 6014364.45427 | 2112502.79122 | 37.7813375610326 | -122.39392977934799 | (37.7813375610326, -122.393929779348) | |
| 10867 | 10867 | 65524 | Permitted Site 1 | Melaleuca styphelliodes :: Paperbark Tree 239 | 725 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 23 | Permit Number 28411 | 6001341.71732 | 2089325.7959099999 | 37.7169667113151 | -122.437321926889 | (37.7169667113151, -122.437321926889) | |
| 33086 | 33086 | 59887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.776255342115604 | -122.447612291383 | (37.7762553421156, -122.447612291383) | |
| 42362 | 42362 | 61510 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.40046534240601 | (37.754033879279, -122.400465342406) | |
| 60218 | 60218 | 40039 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1190 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 23 | Permit Number 41276 | 6017077.86387 | 2093649.33383 | 37.729720334504 | -122.38322991452499 | (37.729720334504, -122.383229914525) | |
| 66114 | 66114 | 83328 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1653-1655 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 23 | 6008329.52279 | 2118179.08917 | 37.7965860510686 | -122.415209687771 | (37.7965860510686, -122.415209687771) | ||
| 75995 | 75995 | 30523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 23 | Permit Number 34528 | 6008465.79864 | 2112766.79262 | 37.7817328607212 | -122.414354996407 | (37.7817328607212, -122.414354996407) | |
| 135052 | 135052 | 49693 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 23 | 5x5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) |
| 147193 | 147193 | 61777 | Permitted Site 1 | Yucca spp :: Yucca 402 | 1301 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 23 | Permit Number 21798 | 6011737.11139 | 2102291.80032 | 37.7531541192741 | -122.402301000816 | (37.7531541192741, -122.402301000816) | |
| 158122 | 158122 | 65732 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 254 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 23 | Permit Number 28666 | 6000124.55623 | 2087429.0552700001 | 37.711689418507206 | -122.44139302826099 | (37.7116894185072, -122.441393028261) | |
| 182733 | 182733 | 65966 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2644 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 23 | Permit Number 28988 | 5989285.4992 | 2097339.4197 | 37.7382773344848 | -122.47957996154301 | (37.7382773344848, -122.479579961543) | |
| 183523 | 183523 | 64195 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 23 | Permit Number 33550 | 6013105.12493 | 2110665.08581 | 37.7762215741936 | -122.398157505788 | (37.7762215741936, -122.398157505788) | |
| 12651 | 12651 | 73720 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 157 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 3x3 | 6001432.84153 | 2093102.8758 | 37.7273429002463 | -122.437277252154 | (37.7273429002463, -122.437277252154) | |
| 12818 | 12818 | 72149 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 157 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 3x3 | 6001449.82558 | 2093091.8640599998 | 37.727313630005895 | -122.437217750315 | (37.7273136300059, -122.437217750315) | |
| 36064 | 36064 | 73981 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1020 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1988 12:00:00 AM | 22 | 6007232.56543 | 2114727.7662400003 | 37.7870478630276 | -122.418760525075 | (37.7870478630276, -122.418760525075) | ||
| 40284 | 40284 | 72154 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 251 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 6000880.62926 | 2093500.16908 | 37.7284023690599 | -122.439214708412 | (37.7284023690599, -122.439214708412) | ||
| 55065 | 55065 | 61207 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 22 | Permit Number 21075 | 6011185.0130199995 | 2095858.2151099998 | 37.735458047859204 | -122.40375761923401 | (37.7354580478592, -122.403757619234) | |
| 56584 | 56584 | 30647 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 40 Isis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 22 | Permit Number 34587 | 6008282.2586 | 2108516.1513099996 | 37.770051295947496 | -122.414689058564 | (37.7700512959475, -122.414689058564) | |
| 59605 | 59605 | 30514 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 22 | Permit Number 42913 | 6008785.20324 | 2113547.07327 | 37.783893261596 | -122.41330519888201 | (37.783893261596, -122.413305198882) | |
| 66318 | 66318 | 65718 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.44056528958099 | (37.7124240746766, -122.440565289581) | |
| 75866 | 75866 | 61315 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1407 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | 22 | Permit Number 21218 | 6011759.20106 | 2101763.54314 | 37.7517048734844 | -122.40218747308599 | (37.7517048734844, -122.402187473086) | |
| 95818 | 95818 | 60967 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 721 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | 22 | Permit Number 20772 | 5994690.06322675 | 2091210.94869199 | 37.721762508120705 | -122.46044983368999 | (37.7217625081207, -122.46044983369) | |
| 102344 | 102344 | 115732 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 ORD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 22 | 3x3 | 6000874.0 | 2105811.0 | 37.7622046070719 | -122.44012004716801 | (37.7622046070719, -122.440120047168) | ||
| 103136 | 103136 | 64806 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1375 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2012 12:00:00 AM | 22 | 5x5 | Permit Number 768180 | 6003293.30156995 | 2100236.74825313 | 37.747036468941005 | -122.43135467591999 | (37.747036468941, -122.43135467592) |
| 120872 | 120872 | 62780 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 22 | Permit Number 23135 | 5999908.40819 | 2091902.69493 | 37.7239607020173 | -122.44246107033301 | (37.7239607020173, -122.442461070333) | |
| 126670 | 126670 | 60830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.42644917929199 | (37.7520575177016, -122.426449179292) | |
| 132276 | 132276 | 72151 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 209 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 6001102.51971 | 2093339.22374 | 37.7279730740759 | -122.438436097863 | (37.7279730740759, -122.438436097863) | ||
| 155288 | 155288 | 83818 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1653-1655 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 22 | 6008323.3908 | 2118208.09875 | 37.7966653595727 | -122.415232960457 | (37.7966653595727, -122.415232960457) | ||
| 175057 | 175057 | 61317 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1415 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | 22 | Permit Number 21220 | 6011760.1009 | 2101696.6127299997 | 37.7515211473979 | -122.402179656165 | (37.7515211473979, -122.402179656165) | |
| 186352 | 186352 | 47483 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 22 | Permit Number 45378 | 6002071.5211 | 2114540.3904 | 37.786241439117205 | -122.436603142325 | (37.7862414391172, -122.436603142325) | |
| 2166 | 2166 | 43082 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 205 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 21 | Permit Number 46999 | 6009001.971030001 | 2113315.3872700003 | 37.783269275104104 | -122.412538876675 | (37.7832692751041, -122.412538876675) | |
| 25869 | 25869 | 37614 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 438 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 21 | Permit Number 40038 | 5990631.22382 | 2112392.71042 | 37.7796877441109 | -122.47602626679199 | (37.7796877441109, -122.476026266792) | |
| 36359 | 36359 | 65523 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.2505700001 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | |
| 37457 | 37457 | 67246 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 21 | Permit Number 30710 | 5983966.26401 | 2111769.24931 | 37.777587186025 | -122.499036819383 | (37.777587186025, -122.499036819383) | |
| 43708 | 43708 | 64171 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 610 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | 21 | Permit Number 24952 | 5991942.3425 | 2111250.75611 | 37.7766281856646 | -122.47140734968201 | (37.7766281856646, -122.471407349682) |
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");