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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1107 | 1107 | 52527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.3638799998 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) |
| 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) | |||||
| 1813 | 1813 | 246390 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.44528708087499 | (37.7694174354079, -122.445287080875) | |||
| 10030 | 10030 | 55092 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.777924340701105 | -122.474992253786 | (37.7779243407011, -122.474992253786) | ||
| 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) | ||
| 28298 | 28298 | 44816 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2745 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986280.5132 | 2105006.9468 | 37.759155277278104 | -122.490533528729 | (37.7591552772781, -122.490533528729) | |
| 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) | ||
| 29286 | 29286 | 191035 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.77708958274221 | -122.409412667772 | (37.7770895827422, -122.409412667772) | |||
| 30022 | 30022 | 183465 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2530 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988020.0365 | 2098057.0209999997 | 37.7401740893942 | -122.484007860756 | (37.7401740893942, -122.484007860756) | |||
| 30105 | 30105 | 37213 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1443 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39778 | 5985860.9109 | 2105407.8744 | 37.7602315957486 | -122.49201421242701 | (37.7602315957486, -122.492014212427) | |
| 30228 | 30228 | 37124 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4200 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | |
| 34390 | 34390 | 34657 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38334 | 5988005.8211 | 2105120.9797 | 37.759569004405606 | -122.48457502698 | (37.7595690044056, -122.48457502698) | |
| 34609 | 34609 | 182248 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1454 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985596.8527 | 2105324.6327 | 37.7599875985541 | -122.492921320569 | (37.7599875985541, -122.492921320569) | |||
| 35235 | 35235 | 34660 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38334 | 5987955.9197 | 2105118.4846 | 37.759559247409 | -122.484747425675 | (37.759559247409, -122.484747425675) | |
| 35901 | 35901 | 184740 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.762442323054294 | -122.49609061999399 | (37.7624423230543, -122.496090619994) | |||
| 36479 | 36479 | 34629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38311 | 5988774.7652 | 2103307.0873 | 37.7546332934455 | -122.481782802584 | (37.7546332934455, -122.481782802584) | |
| 37152 | 37152 | 207426 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 404 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000774.5178 | 2095253.0810900002 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | ||||
| 37512 | 37512 | 38123 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1200 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 5 | Permit Number 40287 | 5985851.366 | 2107007.0192 | 37.7646218448258 | -122.49216497230199 | (37.7646218448258, -122.492164972302) | |
| 37832 | 37832 | 34658 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5987988.7714 | 2105120.9797 | 37.75956801150279 | -122.484633992596 | (37.7595680115028, -122.484633992596) | |
| 39055 | 39055 | 246391 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1302 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999418.9163 | 2108430.2253 | 37.7693133969257 | -122.445340943975 | (37.7693133969257, -122.445340943975) | |||
| 39416 | 39416 | 141601 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | |||
| 41620 | 41620 | 126461 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1990 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000743.635919999 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | |||
| 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) | ||
| 43712 | 43712 | 37130 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4234 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 4 | Permit Number 39713 | 5981688.5295 | 2104905.7911 | 37.758608246146004 | -122.506407027964 | (37.758608246146, -122.506407027964) | |
| 44447 | 44447 | 34630 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38311 | 5988776.9552 | 2103320.2277 | 37.754669500818295 | -122.481776191509 | (37.7546695008183, -122.481776191509) | |
| 49139 | 49139 | 114654 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001378.1104 | 2113915.8269 | 37.7844871189173 | -122.438957381866 | (37.7844871189173, -122.438957381866) | |||
| 50624 | 50624 | 141254 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | |||
| 52169 | 52169 | 82920 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 1 | 5982872.9956 | 2103302.6049 | 37.754276013066104 | -122.502192036803 | (37.7542760130661, -122.502192036803) | ||
| 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) | ||
| 55361 | 55361 | 37123 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4200 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | |
| 59206 | 59206 | 34656 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5988021.6232 | 2105120.5638 | 37.7595687826789 | -122.484520345625 | (37.7595687826789, -122.484520345625) | |
| 60665 | 60665 | 183413 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2350 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985629.7915 | 2097026.6067 | 37.737205400625 | -122.492196390733 | (37.737205400625, -122.492196390733) | |||
| 64770 | 64770 | 69317 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2122 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 6 | Permit Number 33397 | 5987643.2305 | 2104427.6901 | 37.7576442978234 | -122.485778145282 | (37.7576442978234, -122.485778145282) | |
| 66505 | 66505 | 36188 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 35 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 7 | Permit Number 39256 | 5996804.8059 | 2114366.2904 | 37.785462706430394 | -122.454811918638 | (37.7854627064304, -122.454811918638) | |
| 67051 | 67051 | 207425 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991937.91081 | 2090925.4069599998 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | |||
| 68022 | 68022 | 184739 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | |||
| 69521 | 69521 | 73455 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 9 | 6009841.50181 | 2111066.87201 | 37.777142462880995 | -122.409475680552 | (37.777142462881, -122.409475680552) | ||
| 71417 | 71417 | 246395 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999349.2656 | 2108419.0206 | 37.769278655482296 | -122.445581055639 | (37.7692786554823, -122.445581055639) | |||
| 71486 | 71486 | 38854 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1466 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 3 | Permit Number 40681 | 5989630.3392 | 2105375.4166 | 37.7603620895733 | -122.478975308071 | (37.7603620895733, -122.478975308071) | |
| 76050 | 76050 | 37069 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1474 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 4 | Permit Number 39671 | 5983120.2149 | 2105112.095 | 37.7592588855971 | -122.501470953069 | (37.7592588855971, -122.501470953069) | |
| 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) | ||
| 85238 | 85238 | 23668 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 315 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | |||
| 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) | ||
| 85440 | 85440 | 14603 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1265 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 5999439.61797 | 2108531.9802599996 | 37.7695939720606 | -122.44527665521002 | (37.7695939720606, -122.44527665521) | |||
| 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) | ||
| 86280 | 86280 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712.0 | 2113143.0 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | |
| 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) | ||
| 87099 | 87099 | 9986 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | ||
| 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) | ||
| 87387 | 87387 | 90956 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.438709999 | 2110931.20899 | 37.775120893377796 | -122.50869800264299 | (37.7751208933778, -122.508698002643) | ||
| 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) |
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");