Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105699 | 105699 | 35548 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38924 | 6005398.06539258 | 2103564.19233402 | 37.75629192060661 | -122.42431319750798 | (37.7562919206066, -122.424313197508) | ||
| 105796 | 105796 | 37420 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39898 | 6002152.44125634 | 2099703.71933952 | 37.745508174362605 | -122.435261547297 | (37.7455081743626, -122.435261547297) | ||
| 105922 | 105922 | 38617 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1619 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40558 | 6014993.23240611 | 2094434.43177017 | 37.7317606344589 | -122.390491609305 | (37.7317606344589, -122.390491609305) | ||
| 106179 | 106179 | 35941 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39104 | 6007226.10455525 | 2097703.31078326 | 37.740302317745396 | -122.417575817322 | (37.7403023177454, -122.417575817322) | ||
| 106275 | 106275 | 38553 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40521 | 6014535.26572589 | 2096873.10267881 | 37.7384313099375 | -122.39224540118299 | (37.7384313099375, -122.392245401183) | ||
| 106324 | 106324 | 35402 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 531 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38857 | 6003188.18562105 | 2098310.25744294 | 37.7417408149917 | -122.431580643052 | (37.7417408149917, -122.431580643052) | ||
| 106385 | 106385 | 43109 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.78613994087421 | -122.411445668311 | (37.7861399408742, -122.411445668311) | ||
| 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) | ||
| 106615 | 106615 | 41829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42215 | 5991820.03879919 | 2105845.80564429 | 37.761780567414206 | -122.47143650330601 | (37.7617805674142, -122.471436503306) | ||
| 106664 | 106664 | 43498 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43178 | 6008355.55350511 | 2095881.30836855 | 37.735362985931204 | -122.41354179002501 | (37.7353629859312, -122.413541790025) | ||
| 106711 | 106711 | 67467 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 30982 | 6003350.50488606 | 2101289.69360575 | 37.7499308522406 | -122.431232018452 | (37.7499308522406, -122.431232018452) | ||
| 106808 | 106808 | 37706 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | ||
| 109752 | 109752 | 34401 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38148 | 6002541.2507672 | 2096900.64630627 | 37.73783365951871 | -122.43371680334101 | (37.7378336595187, -122.433716803341) | ||
| 109958 | 109958 | 31826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.41063668938601 | (37.7719174714901, -122.410636689386) | ||
| 110097 | 110097 | 45413 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 845 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.46322780413401 | (37.7226703098261, -122.463227804134) | ||
| 110376 | 110376 | 34429 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38173 | 6002089.34387418 | 2096139.54747106 | 37.7357182050796 | -122.435224839434 | (37.7357182050796, -122.435224839434) | ||
| 110387 | 110387 | 36827 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2600 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | ||
| 110576 | 110576 | 35422 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 527 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38873 | 6002518.46166442 | 2099137.02773671 | 37.743972950658105 | -122.43395540759899 | (37.7439729506581, -122.433955407599) | ||
| 111361 | 111361 | 37869 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 135 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241843998 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | ||
| 112060 | 112060 | 39909 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | ||
| 112383 | 112383 | 43743 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 240 Summit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.717159230973394 | -122.45422216598699 | (37.7171592309734, -122.454222165987) | ||
| 112576 | 112576 | 38598 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | ||
| 112782 | 112782 | 42013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.46555017500799 | (37.7274161576674, -122.465550175008) | ||
| 113139 | 113139 | 36830 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.38985519407301 | (37.7224666226612, -122.389855194073) | ||
| 113208 | 113208 | 36907 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.753396682452205 | -122.440506941015 | (37.7533966824522, -122.440506941015) | ||
| 113398 | 113398 | 40068 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1410 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | ||
| 113493 | 113493 | 38037 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40239 | 5992979.27513605 | 2098217.94646306 | 37.7409034220219 | -122.466872661258 | (37.7409034220219, -122.466872661258) | ||
| 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) | |||
| 113802 | 113802 | 38601 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1534 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40552 | 6015446.13574073 | 2094163.07491578 | 37.7310406573671 | -122.388906878559 | (37.7310406573671, -122.388906878559) | ||
| 113886 | 113886 | 37066 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 326 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 39668 | 6003784.55345185 | 2099265.25748104 | 37.7443968092105 | -122.42958669484501 | (37.7443968092105, -122.429586694845) | ||
| 114090 | 114090 | 43251 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 270 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43039 | 6009534.75313896 | 2093131.57732831 | 37.727878953409 | -122.409270860276 | (37.727878953409, -122.409270860276) | ||
| 114625 | 114625 | 36568 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 327 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/1998 12:00:00 AM | Permit Number 39430 | 6006720.99763739 | 2096073.95090972 | 37.735800022233704 | -122.419206729617 | (37.7358000222337, -122.419206729617) | ||
| 114806 | 114806 | 34398 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | |
| 115358 | 115358 | 42554 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 519 Darien Way | 1 | 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) | ||
| 115662 | 115662 | 38618 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1648 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40559 | 6014913.01600852 | 2094558.97753063 | 37.732098161618296 | -122.39077763667801 | (37.7320981616183, -122.390777636678) | ||
| 115724 | 115724 | 38211 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 201 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40334 | 6011139.75939059 | 2091047.44760609 | 37.7222461553598 | -122.40357571280501 | (37.7222461553598, -122.403575712805) | ||
| 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) | |||
| 115914 | 115914 | 31829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 116470 | 116470 | 42740 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 188 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42736 | 6012851.94955825 | 2087048.25997051 | 37.7113606761586 | -122.397376721388 | (37.7113606761586, -122.397376721388) | ||
| 116635 | 116635 | 40060 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 1 | 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) | ||
| 117014 | 117014 | 34346 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 255 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38104 | 6004828.12803067 | 2098393.70147146 | 37.7420627492496 | -122.42591620110201 | (37.7420627492496, -122.425916201102) | ||
| 117250 | 117250 | 38565 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.38633126201401 | (37.7323913709995, -122.386331262014) | ||
| 118562 | 118562 | 37458 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.798940901 | 2099791.60340169 | 37.7462091274065 | -122.40707457123301 | (37.7462091274065, -122.407074571233) | ||
| 118568 | 118568 | 31184 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | ||
| 118661 | 118661 | 39134 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.753695817901104 | -122.417576944272 | (37.7536958179011, -122.417576944272) | ||
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 119143 | 119143 | 43695 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | ||
| 119507 | 119507 | 40555 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 215 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41596 | 5992664.70806244 | 2095313.38893204 | 37.7329100758329 | -122.46774911404499 | (37.7329100758329, -122.467749114045) | ||
| 120616 | 120616 | 33344 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.46400139922599 | (37.730182659203, -122.464001399226) | ||
| 120722 | 120722 | 39138 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.749435846729895 | -122.416989987658 | (37.7494358467299, -122.416989987658) | ||
| 121072 | 121072 | 35510 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3478 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38912 | 6005194.49677521 | 2103146.93967049 | 37.7551347452856 | -122.424987522768 | (37.7551347452856, -122.424987522768) | ||
| 121632 | 121632 | 37063 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1468 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39664 | 6003912.84552522 | 2099719.17052238 | 37.7456504127787 | -122.429175446828 | (37.7456504127787, -122.429175446828) | ||
| 121669 | 121669 | 37314 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | ||
| 121863 | 121863 | 68548 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.778332244778106 | -122.504940366327 | (37.7783322447781, -122.504940366327) | ||
| 121889 | 121889 | 40299 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | ||
| 122597 | 122597 | 37845 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.744607042805704 | -122.40707146066002 | (37.7446070428057, -122.40707146066) | ||
| 122834 | 122834 | 37542 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 704 Post St | 1 | 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) | ||
| 123356 | 123356 | 35927 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 22 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39097 | 6005564.10753047 | 2097077.73566378 | 37.738490969573 | -122.423277889221 | (37.738490969573, -122.423277889221) | ||
| 123371 | 123371 | 38167 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 315 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40305 | 6010555.26362325 | 2092792.3936381 | 37.7270047480515 | -122.405719032848 | (37.7270047480515, -122.405719032848) | ||
| 123547 | 123547 | 38121 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1332 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40285 | 5986502.93855263 | 2106173.76895003 | 37.762372038386104 | -122.48985010087699 | (37.7623720383861, -122.489850100877) | ||
| 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) | |||
| 123908 | 123908 | 34353 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.741850868129795 | -122.42569426656799 | (37.7418508681298, -122.425694266568) | ||
| 124128 | 124128 | 47691 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2858 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45490 | 6001036.99468682 | 2116264.16139907 | 37.79091562463479 | -122.440305990836 | (37.7909156246348, -122.440305990836) | ||
| 124926 | 124926 | 34402 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 160 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38149 | 6002458.41825324 | 2097080.12272084 | 37.7383217597979 | -122.434016021054 | (37.7383217597979, -122.434016021054) | ||
| 124999 | 124999 | 31124 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 1 | 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) | ||
| 125291 | 125291 | 34482 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 840 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38209 | 6008945.03028541 | 2119415.9766961997 | 37.8000168102383 | -122.413167394928 | (37.8000168102383, -122.413167394928) | ||
| 125836 | 125836 | 35741 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 231 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39015 | 6007788.68777846 | 2092857.60054619 | 37.7270286926321 | -122.415287680245 | (37.7270286926321, -122.415287680245) | ||
| 125932 | 125932 | 40463 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 378 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41548 | 6007684.60346868 | 2097335.44684482 | 37.7393180333935 | -122.415964462581 | (37.7393180333935, -122.415964462581) | ||
| 126147 | 126147 | 37477 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39948 | 5991509.07030691 | 2105439.09012647 | 37.760645840230104 | -122.472482356472 | (37.7606458402301, -122.472482356472) | ||
| 126372 | 126372 | 35942 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 21 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39105 | 6007225.31509594 | 2097693.4445482 | 37.7402751828319 | -122.41757784787201 | (37.7402751828319, -122.417577847872) | ||
| 126383 | 126383 | 40050 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1439 Revere Ave | 1 | 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) | ||
| 126783 | 126783 | 34650 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38329 | 5987786.63645622 | 2103431.59810771 | 37.754917654251706 | -122.485209109036 | (37.7549176542517, -122.485209109036) | ||
| 126984 | 126984 | 68883 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | ||
| 127128 | 127128 | 38613 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 127227 | 127227 | 36076 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2091 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39189 | 6008123.15826597 | 2106262.62233667 | 37.7638546903501 | -122.41507985169399 | (37.7638546903501, -122.415079851694) | ||
| 128003 | 128003 | 35970 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 190 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39128 | 6006126.55379065 | 2096333.04753419 | 37.7364779485792 | -122.421280351482 | (37.7364779485792, -122.421280351482) | ||
| 128040 | 128040 | 41842 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42231 | 5992090.13126179 | 2105515.92983571 | 37.7608904365533 | -122.470478344247 | (37.7608904365533, -122.470478344247) | ||
| 128191 | 128191 | 38193 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Girard St | 1 | 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) | ||
| 128395 | 128395 | 42023 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 110 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42346 | 5993552.23919225 | 2093678.6131862 | 37.7284725917152 | -122.464562053467 | (37.7284725917152, -122.464562053467) | ||
| 129175 | 129175 | 31126 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34843 | 5998070.7770048 | 2093598.16198917 | 37.7285111411981 | -122.448935514449 | (37.7285111411981, -122.448935514449) | ||
| 133985 | 133985 | 38606 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1558 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 40554 | 6015323.31475554 | 2094254.15832382 | 37.731283945571704 | -122.389337853373 | (37.7312839455717, -122.389337853373) | |
| 139285 | 139285 | 36718 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 139314 | 139314 | 39490 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4054 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40948 | 6002823.01095214 | 2101848.4791437 | 37.7514352381886 | -122.433096036215 | (37.7514352381886, -122.433096036215) | ||
| 139615 | 139615 | 37105 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 1 | 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) | ||
| 139653 | 139653 | 38180 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 42 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40313 | 6011447.25206772 | 2091677.58315317 | 37.723993549606796 | -122.402557066965 | (37.7239935496068, -122.402557066965) | ||
| 139667 | 139667 | 36471 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 140156 | 140156 | 38195 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 730 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | ||
| 140374 | 140374 | 68496 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | ||
| 140714 | 140714 | 34803 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | ||
| 140843 | 140843 | 40049 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1435 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41286 | 6015948.92421606 | 2093724.14562026 | 37.729863300942704 | -122.38713803351999 | (37.7298633009427, -122.38713803352) | ||
| 140866 | 140866 | 35549 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 50 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.42445588668501 | (37.7558983622011, -122.424455886685) | ||
| 141212 | 141212 | 38197 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 731 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40324 | 6011355.00492598 | 2091469.0696772 | 37.723415864008295 | -122.402861294571 | (37.7234158640083, -122.402861294571) | ||
| 141369 | 141369 | 36078 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2134 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39191 | 6008086.14600314 | 2105996.63644369 | 37.76312227463529 | -122.415189036821 | (37.7631222746353, -122.415189036821) | ||
| 142164 | 142164 | 35494 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3763 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38905 | 6005241.37948762 | 2104264.99377415 | 37.758207308358 | -122.42490492912201 | (37.758207308358, -122.424904929122) | ||
| 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) | |||
| 142292 | 142292 | 37749 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1271 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1999 12:00:00 AM | Permit Number 40096 | 6009537.93489258 | 2101780.18844977 | 37.7516263413346 | -122.40987011119101 | (37.7516263413346, -122.409870111191) | ||
| 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) | |||
| 143552 | 143552 | 38035 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 111 Wawona St | 1 | 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) | ||
| 144295 | 144295 | 64645 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856003 | 37.7288421898975 | -122.46009728755301 | (37.7288421898975, -122.460097287553) | ||
| 145421 | 145421 | 34528 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) |
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");