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) | |||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 94608 | 94608 | 29418 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.38956611723101 | (37.7227927176508, -122.389566117231) | |||
| 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) | |||
| 96548 | 96548 | 40641 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.744370680135106 | -122.410814978675 | (37.7443706801351, -122.410814978675) | |||
| 97168 | 97168 | 106921 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | |||
| 97354 | 97354 | 39908 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 2 | 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) | |||
| 98252 | 98252 | 34646 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1596 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38325 | 5987803.91965419 | 2104439.10360026 | 37.7576849982837 | -122.48522326103 | (37.7576849982837, -122.48522326103) | |||
| 98352 | 98352 | 36491 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 99168 | 99168 | 51637 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 189 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47927 | 5996660.05636895 | 2089154.42395132 | 37.7162289049692 | -122.453491707846 | (37.7162289049692, -122.453491707846) | |||
| 99717 | 99717 | 37426 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 101381 | 101381 | 96988 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 102643 | 102643 | 99920 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 104586 | 104586 | 37042 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1660 Church St | 4 | 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) | |||
| 104792 | 104792 | 40038 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 6 | 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) | |||
| 104928 | 104928 | 42147 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 490 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42443 | 5990026.73861506 | 2112033.51240967 | 37.7786664170583 | -122.47809115215901 | (37.7786664170583, -122.478091152159) | |||
| 104972 | 104972 | 37427 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 105808 | 105808 | 36493 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 105863 | 105863 | 37423 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 106196 | 106196 | 96990 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 106597 | 106597 | 37524 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1150 Larkin St | 1 | 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) | ||
| 111017 | 111017 | 36488 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 113737 | 113737 | 36492 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 114706 | 114706 | 96989 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 115793 | 115793 | 37039 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1660 Church St | 1 | 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) | |||
| 116366 | 116366 | 40034 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 2 | 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) | |||
| 119355 | 119355 | 38628 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1998 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | |||
| 121150 | 121150 | 37040 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1660 Church St | 2 | 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) | |||
| 122949 | 122949 | 9987 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | |||
| 123315 | 123315 | 37041 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1660 Church St | 3 | 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) | |||
| 123613 | 123613 | 47385 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.74679548873271 | -122.43797558503701 | (37.7467954887327, -122.437975585037) | |||
| 123721 | 123721 | 246397 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264092996 | -122.445696997639 | (37.769264264093, -122.445696997639) | |||
| 123800 | 123800 | 116680 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 125859 | 125859 | 36489 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 128682 | 128682 | 37424 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 138766 | 138766 | 34527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | |||
| 141618 | 141618 | 37275 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3894 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39816 | 6002513.25180394 | 2102998.13185029 | 37.754574335137 | -122.434249400487 | (37.754574335137, -122.434249400487) | |||
| 142237 | 142237 | 102442 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6008344.0 | 2095883.0 | 37.735366982034996 | -122.413581854524 | (37.735366982035, -122.413581854524) | |||
| 142628 | 142628 | 37786 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 301 Hamilton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1998 12:00:00 AM | Permit Number 40119 | 6009341.93324933 | 2092913.86947002 | 37.7272703689284 | -122.409922083912 | (37.7272703689284, -122.409922083912) | |||
| 143045 | 143045 | 40642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.744366745773796 | -122.410880064189 | (37.7443667457738, -122.410880064189) | |||
| 144458 | 144458 | 36487 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 145797 | 145797 | 40300 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2155 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | |||
| 150358 | 150358 | 187339 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985079.353999999 | 2099690.9452 | 37.7444887635366 | -122.494295807794 | (37.7444887635366, -122.494295807794) | |||
| 151873 | 151873 | 140845 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | |||
| 157189 | 157189 | 246392 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1310 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999402.5635 | 2108427.4999 | 37.7693049801732 | -122.44539731131901 | (37.7693049801732, -122.445397311319) | |||
| 159169 | 159169 | 246396 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251004 | -122.445638557414 | (37.769273547251, -122.445638557414) | |||
| 162759 | 162759 | 40610 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1234 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 5 | Permit Number 41621 | 5983375.0645 | 2106732.8195 | 37.763723900700896 | -122.500709422357 | (37.7637239007009, -122.500709422357) | ||
| 164594 | 164594 | 248448 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | |||
| 166412 | 166412 | 141253 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | |||
| 171936 | 171936 | 246393 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.769295576121394 | -122.445463083857 | (37.7692955761214, -122.445463083857) | |||
| 171963 | 171963 | 247352 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 717 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003091.9924 | 2109593.0641 | 37.772715254913294 | -122.432719040926 | (37.7727152549133, -122.432719040926) | |||
| 178672 | 178672 | 246394 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999365.9212 | 2108422.0489 | 37.769287921296204 | -122.44552366275299 | (37.7692879212962, -122.445523662753) | |||
| 181134 | 181134 | 114652 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001448.056 | 2113923.3749 | 37.7845118231904 | -122.438715935573 | (37.7845118231904, -122.438715935573) | |||
| 183202 | 183202 | 126462 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1990 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.803877229006204 | -122.441595650935 | (37.8038772290062, -122.441595650935) | |||
| 188090 | 188090 | 114656 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001274.7016 | 2113900.9823 | 37.78444047533 | -122.439314075739 | (37.78444047533, -122.439314075739) | |||
| 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) |
| 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) |
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");