Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1735 | 1735 | 251679 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 5 Dwight St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011495.0 | 2091622.0 | 37.7238435952898 | -122.40238810251101 | (37.7238435952898, -122.402388102511) | |||||
| 17972 | 17972 | 38597 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 18457 | 18457 | 38570 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 19240 | 19240 | 34364 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1862 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38120 | 6004563.40220029 | 2097868.81083057 | 37.7406065549579 | -122.426794167737 | (37.7406065549579, -122.426794167737) | ||
| 20473 | 20473 | 68412 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | ||
| 20616 | 20616 | 34363 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1846 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38119 | 6004556.0268692 | 2098000.12862747 | 37.74096670671079 | -122.426829018524 | (37.7409667067108, -122.426829018524) | ||
| 27177 | 27177 | 38615 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 28923 | 28923 | 37560 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 39999 | 6000466.36495931 | 2104620.54811441 | 37.758912703603 | -122.44144447135 | (37.758912703603, -122.44144447135) | ||
| 41814 | 41814 | 38626 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 53182 | 53182 | 43998 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43555 | 6008950.71046834 | 2099077.83692872 | 37.7441733566649 | -122.41170989221901 | (37.7441733566649, -122.411709892219) | |||
| 53243 | 53243 | 38303 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2000 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 77316 | 77316 | 34414 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 205 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38161 | 6004190.49432582 | 2097526.98545022 | 37.7396468892769 | -122.42805918676399 | (37.7396468892769, -122.428059186764) | ||
| 77587 | 77587 | 37044 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1660 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.744311845504704 | -122.42681873299499 | (37.7443118455047, -122.426818732995) | |||
| 77812 | 77812 | 42555 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | ||
| 77834 | 77834 | 35960 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 555 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39118 | 6006291.48461818 | 2096239.28811556 | 37.7362298031477 | -122.420703460764 | (37.7362298031477, -122.420703460764) | ||
| 78000 | 78000 | 31125 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 78126 | 78126 | 31110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | |||
| 78181 | 78181 | 68180 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 75 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | Permit Number 31952 | 5996329.36645327 | 2111693.70801186 | 37.7780972208044 | -122.45626347950899 | (37.7780972208044, -122.456263479509) | ||
| 78301 | 78301 | 40037 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 78418 | 78418 | 35961 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 555 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39118 | 6006291.48461818 | 2096239.28811556 | 37.7362298031477 | -122.420703460764 | (37.7362298031477, -122.420703460764) | ||
| 78508 | 78508 | 68560 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.778688985847104 | -122.506043321809 | (37.7786889858471, -122.506043321809) | ||
| 79109 | 79109 | 36453 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 79551 | 79551 | 38320 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1810 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40378 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |||
| 79608 | 79608 | 34400 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 156 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38147 | 6002471.83146577 | 2097061.86671715 | 37.738272394243005 | -122.43396834021401 | (37.738272394243, -122.433968340214) | ||
| 81084 | 81084 | 37525 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1150 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 52992 | 6007323.510607299 | 2115257.61387493 | 37.788507814826204 | -122.41848345910499 | (37.7885078148262, -122.418483459105) | ||
| 81242 | 81242 | 39675 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 81383 | 81383 | 38081 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000619.36701 | 2114044.5350099998 | 37.784797319330295 | -122.441591606798 | (37.7847973193303, -122.441591606798) | ||
| 81385 | 81385 | 34111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 81802 | 81802 | 37587 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2805 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.43938295663601 | (37.7613286337784, -122.439382956636) | ||
| 81905 | 81905 | 39910 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | |||
| 82515 | 82515 | 38172 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 433 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40308 | 6010665.04465284 | 2092691.20819375 | 37.7267330524509 | -122.40533239712099 | (37.7267330524509, -122.405332397121) | ||
| 83070 | 83070 | 39173 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 7461 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.41719646500401 | (37.7612079095392, -122.417196465004) | ||
| 83148 | 83148 | 37782 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 289 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | ||
| 83443 | 83443 | 121194 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 255x Red Rock Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 83541 | 83541 | 37043 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1660 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.744311845504704 | -122.42681873299499 | (37.7443118455047, -122.426818732995) | |||
| 83758 | 83758 | 37543 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 704 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | ||
| 83764 | 83764 | 31111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | |||
| 84138 | 84138 | 34388 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38136 | 6003730.56187145 | 2096520.40051304 | 37.736857004551794 | -122.429577666227 | (37.7368570045518, -122.429577666227) | ||
| 84291 | 84291 | 40058 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 84649 | 84649 | 36717 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1999 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 84680 | 84680 | 36336 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 84947 | 84947 | 34404 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38152 | 6002491.04646095 | 2096956.56807226 | 37.7379843589135 | -122.433894379886 | (37.7379843589135, -122.433894379886) | ||
| 84960 | 84960 | 42029 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | ||
| 85335 | 85335 | 37602 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 510 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40029 | 5992230.72627236 | 2111952.11164714 | 37.778570595599604 | -122.47046084649999 | (37.7785705955996, -122.4704608465) | ||
| 85709 | 85709 | 37195 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1742 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39762 | 5986908.61171996 | 2103401.39400305 | 37.7547835348007 | -122.488243305818 | (37.7547835348007, -122.488243305818) | ||
| 85736 | 85736 | 38813 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 343 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | ||
| 85900 | 85900 | 39064 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 238 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 40776 | 6007140.57976269 | 2105924.49860202 | 37.7628710155664 | -122.418454324135 | (37.7628710155664, -122.418454324135) | ||
| 85934 | 85934 | 39693 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1475 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41078 | 6015709.80747314 | 2094943.53448428 | 37.733198254093104 | -122.388049755187 | (37.7331982540931, -122.388049755187) | ||
| 86006 | 86006 | 38036 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 111 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40238 | 5993036.05890767 | 2098279.23820641 | 37.7410749908436 | -122.466680779864 | (37.7410749908436, -122.466680779864) | ||
| 86438 | 86438 | 40067 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 86480 | 86480 | 42256 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1451 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42500 | 6014382.14951701 | 2101979.25998884 | 37.7524432441755 | -122.39313199333999 | (37.7524432441755, -122.39313199334) | |||
| 86504 | 86504 | 37588 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2805 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.43938295663601 | (37.7613286337784, -122.439382956636) | ||
| 86541 | 86541 | 38315 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2000 Folsom St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 86678 | 86678 | 40051 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1439 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41287 | 6015928.43712332 | 2093739.41771764 | 37.729904100557 | -122.38720992526301 | (37.729904100557, -122.387209925263) | ||
| 87203 | 87203 | 38622 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 87399 | 87399 | 69146 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2479 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33181 | 5983616.53937475 | 2098288.7238606005 | 37.7405529339472 | -122.499250248288 | (37.7405529339472, -122.499250248288) | ||
| 87412 | 87412 | 37133 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1496 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095356996 | -122.50896520854799 | (37.758434095357, -122.508965208548) | ||
| 87435 | 87435 | 31145 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | |
| 87447 | 87447 | 37589 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2805 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.43938295663601 | (37.7613286337784, -122.439382956636) | ||
| 87560 | 87560 | 43694 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 750 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43338 | 5993218.66242977 | 2110366.15850001 | 37.77427306876729 | -122.46692789928001 | (37.7742730687673, -122.46692789928) | ||
| 88033 | 88033 | 38209 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 830 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40332 | 6010874.68113014 | 2090828.02861629 | 37.7216288654759 | -122.40447659257 | (37.7216288654759, -122.40447659257) | ||
| 88108 | 88108 | 38079 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000639.41901 | 2113899.22301 | 37.7843994724246 | -122.441511802515 | (37.7843994724246, -122.441511802515) | ||
| 88116 | 88116 | 38642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40567 | 6015859.80735798 | 2093156.47365065 | 37.7282996512663 | -122.38740653837 | (37.7282996512663, -122.38740653837) | ||
| 88362 | 88362 | 38629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 88607 | 88607 | 34930 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1790 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/1997 12:00:00 AM | Permit Number 38522 | 5991259.7839455 | 2103214.98783119 | 37.754524610644495 | -122.473182309921 | (37.7545246106445, -122.473182309921) | ||
| 89193 | 89193 | 38076 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000627.17901 | 2113992.97301 | 37.7846561884399 | -122.441560878475 | (37.7846561884399, -122.441560878475) | ||
| 89241 | 89241 | 68517 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | ||
| 89321 | 89321 | 38593 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 89732 | 89732 | 43105 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444671995 | -122.41142742605801 | (37.786049444672, -122.411427426058) | ||
| 89734 | 89734 | 39707 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41092 | 5997200.32170515 | 2095026.51323817 | 37.732383233800604 | -122.452047720375 | (37.7323832338006, -122.452047720375) | ||
| 89766 | 89766 | 121619 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1465 Rhode Island St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012073.0 | 2101555.0 | 37.7511497699027 | -122.40108765644301 | (37.7511497699027, -122.401087656443) | |||||
| 89805 | 89805 | 39982 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 6 Flora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41240 | 6013914.89161205 | 2094774.31102494 | 37.732633993705896 | -122.394243468583 | (37.7326339937059, -122.394243468583) | ||
| 90662 | 90662 | 37286 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | ||
| 90711 | 90711 | 68249 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | ||
| 90972 | 90972 | 36820 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91047 | 91047 | 36823 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91302 | 91302 | 38347 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1567 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | Permit Number 40414 | 5981854.03597748 | 2104432.31461127 | 37.757317957298 | -122.5057995404 | (37.757317957298, -122.5057995404) | ||
| 91475 | 91475 | 68599 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.47317142953301 | (37.7517787113613, -122.473171429533) | ||
| 91631 | 91631 | 36510 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 406 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39387 | 6007487.22983868 | 2096928.20854387 | 37.738188748168895 | -122.416618053798 | (37.7381887481689, -122.416618053798) | ||
| 91758 | 91758 | 37590 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2805 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.43938295663601 | (37.7613286337784, -122.439382956636) | ||
| 91768 | 91768 | 38596 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 91922 | 91922 | 38511 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 64 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1998 12:00:00 AM | Permit Number 40500 | 6008516.43042503 | 2087785.37039582 | 37.7131422875132 | -122.412413505045 | (37.7131422875132, -122.412413505045) | |||
| 92413 | 92413 | 40035 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 92685 | 92685 | 37106 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | ||
| 93267 | 93267 | 36908 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.43684307811701 | (37.7560694803843, -122.436843078117) | ||
| 93272 | 93272 | 39174 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 7461 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.41719646500401 | (37.7612079095392, -122.417196465004) | ||
| 93515 | 93515 | 37707 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.761607056161296 | -122.417234652367 | (37.7616070561613, -122.417234652367) | ||
| 93658 | 93658 | 39907 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | |||
| 93706 | 93706 | 38199 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 455 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40326 | 6010407.74547618 | 2092510.58020697 | 37.726222696711105 | -122.40620915650801 | (37.7262226967111, -122.406209156508) | ||
| 94380 | 94380 | 43999 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 158 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43556 | 6009020.46100461 | 2099081.71622052 | 37.744187920912296 | -122.411468983209 | (37.7441879209123, -122.411468983209) | |||
| 94422 | 94422 | 43997 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43554 | 6008915.83516029 | 2099075.89728061 | 37.7441660743482 | -122.41183034682699 | (37.7441660743482, -122.411830346827) | |||
| 94504 | 94504 | 38072 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000643.06501 | 2113866.93101 | 37.7843110146233 | -122.441496870623 | (37.7843110146233, -122.441496870623) | ||
| 94510 | 94510 | 38612 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 94624 | 94624 | 31013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | ||
| 94806 | 94806 | 40036 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 94841 | 94841 | 39905 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | |||
| 95851 | 95851 | 42120 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 630 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 42417 | 5997254.13334531 | 2095296.10071131 | 37.73312653869829 | -122.45188112372699 | (37.7331265386983, -122.451881123727) | ||
| 95853 | 95853 | 43745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 253 Summit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | ||
| 96015 | 96015 | 34569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665002 | (37.7401467112036, -122.41215832665) | ||
| 96432 | 96432 | 38194 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40322 | 6011294.88736359 | 2091487.49408108 | 37.7234630966145 | -122.40307040641301 | (37.7234630966145, -122.403070406413) |
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");