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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88033 | 88033 | 38209 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 830 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40332 | 6010874.68113014 | 2090828.02861629 | 37.7216288654759 | -122.40447659257 | (37.7216288654759, -122.40447659257) | ||
| 88108 | 88108 | 38079 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000639.41901 | 2113899.22301 | 37.7843994724246 | -122.441511802515 | (37.7843994724246, -122.441511802515) | ||
| 88116 | 88116 | 38642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40567 | 6015859.80735798 | 2093156.47365065 | 37.7282996512663 | -122.38740653837 | (37.7282996512663, -122.38740653837) | ||
| 88362 | 88362 | 38629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 88607 | 88607 | 34930 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1790 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/1997 12:00:00 AM | Permit Number 38522 | 5991259.7839455 | 2103214.98783119 | 37.754524610644495 | -122.473182309921 | (37.7545246106445, -122.473182309921) | ||
| 89193 | 89193 | 38076 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000627.17901 | 2113992.97301 | 37.7846561884399 | -122.441560878475 | (37.7846561884399, -122.441560878475) | ||
| 89241 | 89241 | 68517 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | ||
| 89321 | 89321 | 38593 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 89732 | 89732 | 43105 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444671995 | -122.41142742605801 | (37.786049444672, -122.411427426058) | ||
| 89734 | 89734 | 39707 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41092 | 5997200.32170515 | 2095026.51323817 | 37.732383233800604 | -122.452047720375 | (37.7323832338006, -122.452047720375) | ||
| 89766 | 89766 | 121619 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1465 Rhode Island St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012073.0 | 2101555.0 | 37.7511497699027 | -122.40108765644301 | (37.7511497699027, -122.401087656443) | |||||
| 89805 | 89805 | 39982 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 6 Flora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41240 | 6013914.89161205 | 2094774.31102494 | 37.732633993705896 | -122.394243468583 | (37.7326339937059, -122.394243468583) | ||
| 90662 | 90662 | 37286 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | ||
| 90711 | 90711 | 68249 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | ||
| 90972 | 90972 | 36820 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91047 | 91047 | 36823 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91302 | 91302 | 38347 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1567 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | Permit Number 40414 | 5981854.03597748 | 2104432.31461127 | 37.757317957298 | -122.5057995404 | (37.757317957298, -122.5057995404) | ||
| 91475 | 91475 | 68599 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.47317142953301 | (37.7517787113613, -122.473171429533) | ||
| 91631 | 91631 | 36510 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 406 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39387 | 6007487.22983868 | 2096928.20854387 | 37.738188748168895 | -122.416618053798 | (37.7381887481689, -122.416618053798) | ||
| 91758 | 91758 | 37590 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2805 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.43938295663601 | (37.7613286337784, -122.439382956636) | ||
| 91768 | 91768 | 38596 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 91922 | 91922 | 38511 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 64 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1998 12:00:00 AM | Permit Number 40500 | 6008516.43042503 | 2087785.37039582 | 37.7131422875132 | -122.412413505045 | (37.7131422875132, -122.412413505045) | |||
| 92413 | 92413 | 40035 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 92685 | 92685 | 37106 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | ||
| 93267 | 93267 | 36908 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.43684307811701 | (37.7560694803843, -122.436843078117) | ||
| 93272 | 93272 | 39174 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 7461 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.41719646500401 | (37.7612079095392, -122.417196465004) | ||
| 93515 | 93515 | 37707 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.761607056161296 | -122.417234652367 | (37.7616070561613, -122.417234652367) | ||
| 93658 | 93658 | 39907 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | |||
| 93706 | 93706 | 38199 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 455 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40326 | 6010407.74547618 | 2092510.58020697 | 37.726222696711105 | -122.40620915650801 | (37.7262226967111, -122.406209156508) | ||
| 94380 | 94380 | 43999 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 158 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43556 | 6009020.46100461 | 2099081.71622052 | 37.744187920912296 | -122.411468983209 | (37.7441879209123, -122.411468983209) | |||
| 94422 | 94422 | 43997 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2000 12:00:00 AM | Permit Number 43554 | 6008915.83516029 | 2099075.89728061 | 37.7441660743482 | -122.41183034682699 | (37.7441660743482, -122.411830346827) | |||
| 94504 | 94504 | 38072 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000643.06501 | 2113866.93101 | 37.7843110146233 | -122.441496870623 | (37.7843110146233, -122.441496870623) | ||
| 94510 | 94510 | 38612 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1602 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.731758871639705 | -122.39017891990801 | (37.7317588716397, -122.390178919908) | ||
| 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) | |||
| 94624 | 94624 | 31013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | ||
| 94806 | 94806 | 40036 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1190 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.729682546865604 | -122.383179660981 | (37.7296825468656, -122.383179660981) | |||
| 94841 | 94841 | 39905 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | |||
| 95851 | 95851 | 42120 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 630 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 42417 | 5997254.13334531 | 2095296.10071131 | 37.73312653869829 | -122.45188112372699 | (37.7331265386983, -122.451881123727) | ||
| 95853 | 95853 | 43745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 253 Summit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | ||
| 96015 | 96015 | 34569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665002 | (37.7401467112036, -122.41215832665) | ||
| 96432 | 96432 | 38194 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40322 | 6011294.88736359 | 2091487.49408108 | 37.7234630966145 | -122.40307040641301 | (37.7234630966145, -122.403070406413) | ||
| 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) | |||
| 96701 | 96701 | 34355 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.740180967537604 | -122.425706834494 | (37.7401809675376, -122.425706834494) | ||
| 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) | |||
| 97177 | 97177 | 42163 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4630 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42458 | 5989047.18920071 | 2109907.45432155 | 37.7727719459225 | -122.48132401917401 | (37.7727719459225, -122.481324019174) | ||
| 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) | |||
| 97472 | 97472 | 38619 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 2 | 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) | ||
| 97619 | 97619 | 39676 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 2 | 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) | ||
| 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) | |||
| 98255 | 98255 | 37716 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 943 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 40086 | 6007607.04837726 | 2104169.37424002 | 37.7580780981898 | -122.41671662254299 | (37.7580780981898, -122.416716622543) | ||
| 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) | |||
| 98524 | 98524 | 37701 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 700 South Van Ness Ave | 3 | 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) | ||
| 98637 | 98637 | 36720 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 3 | 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) | ||
| 98980 | 98980 | 37870 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 135 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241843998 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | ||
| 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) | |||
| 99552 | 99552 | 37437 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39912 | 6010454.2114909 | 2099614.59600709 | 37.745731407921 | -122.406548905427 | (37.745731407921, -122.406548905427) | ||
| 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) | |||
| 99917 | 99917 | 37455 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | ||
| 99963 | 99963 | 36111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1290 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39208 | 5992413.02593495 | 2106678.51938145 | 37.7641012654702 | -122.469446232974 | (37.7641012654702, -122.469446232974) | ||
| 100059 | 100059 | 38179 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 36 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40312 | 6011464.3100447 | 2091682.81198966 | 37.724008859229706 | -122.402498467389 | (37.7240088592297, -122.402498467389) | ||
| 100160 | 100160 | 38302 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2000 Folsom St | 14 | 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) | ||
| 100178 | 100178 | 37225 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1471 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39789 | 5985552.67131947 | 2105212.4791892 | 37.759677072307 | -122.49306585859301 | (37.759677072307, -122.493065858593) | ||
| 100202 | 100202 | 39689 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 56 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41074 | 6013706.29242939 | 2094956.2180602 | 37.7331218759444 | -122.39497738849501 | (37.7331218759444, -122.394977388495) | ||
| 101228 | 101228 | 68054 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1881 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31791 | 5993737.20481548 | 2102706.11474697 | 37.7532705090115 | -122.46457785688 | (37.7532705090115, -122.46457785688) | ||
| 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) | ||||
| 101426 | 101426 | 34110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 1 | 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) | ||
| 102122 | 102122 | 38812 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 343 11th Ave | 1 | 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) | ||
| 102170 | 102170 | 37134 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1496 La Playa St | 2 | 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) | ||
| 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) | |||||
| 102953 | 102953 | 39065 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 238 Capp St | 1 | 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) | ||
| 103319 | 103319 | 32293 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 160 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41561 | 5996702.09015079 | 2089306.2071389998 | 37.716648075661794 | -122.453357371649 | (37.7166480756618, -122.453357371649) | ||
| 103409 | 103409 | 34672 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3112 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | Permit Number 38340 | 6003381.034936099 | 2119134.6254032 | 37.7989303613953 | -122.43240082161199 | (37.7989303613953, -122.432400821612) | ||
| 103548 | 103548 | 38571 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1360 Oakdale Ave | 7 | 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) | ||
| 103755 | 103755 | 38078 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000636.81501 | 2113914.58701 | 37.784441509658706 | -122.441521914323 | (37.7844415096587, -122.441521914323) | ||
| 104323 | 104323 | 38084 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2501 Sutter St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.784959103725704 | -122.441572302214 | (37.7849591037257, -122.441572302214) | ||
| 104525 | 104525 | 35745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.41499553105301 | (37.728572072766, -122.414995531053) | ||
| 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) | |||
| 105030 | 105030 | 37454 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | ||
| 105358 | 105358 | 40066 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 4 | 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) | ||
| 105548 | 105548 | 40069 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1410 Thomas Ave | 2 | 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) | ||
| 105659 | 105659 | 43106 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 405 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444671995 | -122.41142742605801 | (37.786049444672, -122.411427426058) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||
| 106343 | 106343 | 36826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 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) |
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");