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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78478 | 78478 | 117133 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
111867 | 111867 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
123314 | 123314 | 117135 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
142779 | 142779 | 112056 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
142845 | 142845 | 117134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
28751 | 28751 | 72246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002360.66039 | 2091027.7988900002 | 37.721697906115104 | -122.433921526363 | (37.7216979061151, -122.433921526363) | ||
128281 | 128281 | 69079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33087 | 5992094.79631072 | 2106892.73003089 | 37.764671035074 | -122.470562489037 | (37.764671035074, -122.470562489037) | |
85929 | 85929 | 32216 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 519 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | Permit Number 35537 | 6009462.41872105 | 2100262.21191199 | 37.747454081953 | -122.410024104812 | (37.747454081953, -122.410024104812) | ||
79389 | 79389 | 98269 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscape plot | Permit Number 768491 | 6009963.0 | 2103401.0 | 37.7561005415225 | -122.40851449565001 | (37.7561005415225, -122.40851449565) | |
125728 | 125728 | 108999 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 699X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 773694 | 6011413.0 | 2108471.0 | 37.7701027222045 | -122.403856631371 | (37.7701027222045, -122.403856631371) | |
84243 | 84243 | 109102 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
97430 | 97430 | 109101 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
115034 | 115034 | 33841 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
12206 | 12206 | 65603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 131 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 15 | 3x3 | Permit Number 28506 | 6004245.84033 | 2093781.6134799998 | 37.7293660735617 | -122.427601053271 | (37.7293660735617, -122.427601053271) |
30462 | 30462 | 58671 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 5 | Permit Number 17896 | 6014367.3263 | 2104224.98671 | 37.7586087044554 | -122.39334039516199 | (37.7586087044554, -122.393340395162) | |
64973 | 64973 | 72745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 630 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 8 | 6014368.47068 | 2104204.35874 | 37.758552128085796 | -122.39333499383001 | (37.7585521280858, -122.39333499383) | ||
160723 | 160723 | 72759 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 7 | 6014364.38031 | 2104253.03754 | 37.7586855622993 | -122.393352546787 | (37.7586855622993, -122.393352546787) | ||
81858 | 81858 | 62560 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22760 | 6002239.76573177 | 2109514.87514883 | 37.7724521979542 | -122.435661387293 | (37.7724521979542, -122.435661387293) | ||
182016 | 182016 | 79734 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 278 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 9 | 6011401.4545599995 | 2111396.60649 | 37.7781351201838 | -122.404102493055 | (37.7781351201838, -122.404102493055) | ||
116540 | 116540 | 60660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | 17 | Permit Number 20294 | 6004379.78679579 | 2097028.45773942 | 37.738288753282106 | -122.42736919019501 | (37.7382887532821, -122.427369190195) | |
80521 | 80521 | 42064 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3125 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/2001 12:00:00 AM | Permit Number 42374 | 6008884.76165611 | 2100531.31488982 | 37.7481605856471 | -122.412040626823 | (37.7481605856471, -122.412040626823) | ||
123544 | 123544 | 95666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 800 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
85927 | 85927 | 92060 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 18 Worth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767461 | 6000842.0 | 2103210.0 | 37.7550610743794 | -122.44004420959999 | (37.7550610743794, -122.4400442096) | |
111821 | 111821 | 92059 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 18 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767461 | 6000842.0 | 2103210.0 | 37.7550610743794 | -122.44004420959999 | (37.7550610743794, -122.4400442096) | |
83467 | 83467 | 35415 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
92740 | 92740 | 35414 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
144573 | 144573 | 35413 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
124167 | 124167 | 44786 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2818 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43882. Basin expansion 5'9" x 8'7" | 6009323.53333837 | 2103374.60250597 | 37.7559922269102 | -122.410724131124 | (37.7559922269102, -122.410724131124) | ||
168505 | 168505 | 46656 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 6 | Permit Number 44787 | 5989986.8778099995 | 2113120.4528799998 | 37.781648539642404 | -122.47830854187 | (37.7816485396424, -122.47830854187) | |
77005 | 77005 | 69406 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 791 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 8 | Permit Number 33510 | 6002424.30927 | 2087088.10255 | 37.7108839820803 | -122.43342011837 | (37.7108839820803, -122.43342011837) | |
175774 | 175774 | 31530 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35085 | 6011132.9028199995 | 2101918.55735 | 37.7520955300081 | -122.404364216429 | (37.7520955300081, -122.404364216429) | |
95842 | 95842 | 68127 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31877 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||
135757 | 135757 | 68140 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2520 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 3 | Permit Number 31894 | 6000504.5856 | 2114139.1025 | 37.785050437079796 | -122.441995501898 | (37.7850504370798, -122.441995501898) | |
118676 | 118676 | 36673 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1647 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39478 | 6006478.405230001 | 2107274.55540736 | 37.76654065447671 | -122.420840412073 | (37.7665406544767, -122.420840412073) | ||
123247 | 123247 | 36687 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39487 | 6005806.4873735 | 2107131.86319182 | 37.76611096005 | -122.423154315796 | (37.76611096005, -122.423154315796) | ||
109644 | 109644 | 37048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
142269 | 142269 | 37049 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
403 | 403 | 65940 | Planning Code 138.1 required 4 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.78332336932171 | -122.41797588370702 | (37.7833233693217, -122.417975883707) | |
75081 | 75081 | 31663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 154 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35171 | 6007340.50387 | 2096742.6904 | 37.7376711031279 | -122.41711221886699 | (37.7376711031279, -122.417112218867) | |
91189 | 91189 | 37009 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1160 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 39623 | 6009190.78707009 | 2102400.91082818 | 37.753311244715704 | -122.41111443855101 | (37.7533112447157, -122.411114438551) | ||
18632 | 18632 | 37326 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39837 | 6002947.90722614 | 2103845.15191447 | 37.756924711117 | -122.432806753551 | (37.756924711117, -122.432806753551) | ||
42659 | 42659 | 31690 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 720 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35194 | 5997967.7593 | 2107982.3411 | 37.7680006769011 | -122.45032811149599 | (37.7680006769011, -122.450328111496) | |
168492 | 168492 | 31705 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 456 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35207 | 5997530.3227 | 2107475.8595 | 37.766584963572996 | -122.45180460716401 | (37.766584963573, -122.451804607164) | |
79085 | 79085 | 37465 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 236 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39936 | 6010201.25104789 | 2099964.34261176 | 37.746677580306894 | -122.407448262702 | (37.7466775803069, -122.407448262702) | ||
44079 | 44079 | 41678 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
78566 | 78566 | 41676 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
91830 | 91830 | 41677 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
143118 | 143118 | 41675 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
143577 | 143577 | 41674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
31143 | 31143 | 41824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1540 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42210 | 6001764.9422 | 2111535.9598 | 37.7779746089121 | -122.43744859967501 | (37.7779746089121, -122.437448599675) | |
69538 | 69538 | 37593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 643 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40021 | 5992524.5893 | 2111069.01654 | 37.776162842853296 | -122.469379974251 | (37.7761628428533, -122.469379974251) | |
52320 | 52320 | 38502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2440 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42685 | 6006711.92416 | 2119615.77365 | 37.8004397836378 | -122.420909000977 | (37.8004397836378, -122.420909000977) | |
50522 | 50522 | 31991 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 215 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35392 | 5994587.26751 | 2113998.16217 | 37.784324475145795 | -122.462457175798 | (37.7843244751458, -122.462457175798) | |
124836 | 124836 | 37755 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1182 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40102 | 6008642.9285748005 | 2101663.94572247 | 37.7512569652384 | -122.41295695053101 | (37.7512569652384, -122.412956950531) | ||
31816 | 31816 | 37984 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40206 | 6013786.428309999 | 2104612.00312 | 37.759639076609396 | -122.39537653041401 | (37.7596390766094, -122.395376530414) | |
122400 | 122400 | 38006 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40217 | 5992035.60667724 | 2098055.00516972 | 37.740401516958705 | -122.47012362496099 | (37.7404015169587, -122.470123624961) | ||
150961 | 150961 | 38065 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2613 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 40257 | 5999511.4939 | 2113596.9939 | 37.7835053059124 | -122.445392280392 | (37.7835053059124, -122.445392280392) | |
95218 | 95218 | 33847 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
98836 | 98836 | 33838 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
124510 | 124510 | 33843 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
124554 | 124554 | 33846 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
141275 | 141275 | 33842 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
98548 | 98548 | 43240 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 702 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43028 | 6002763.80049912 | 2109247.75150774 | 37.771748493450204 | -122.43382960559299 | (37.7717484934502, -122.433829605593) | ||
93415 | 93415 | 32851 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 752 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 6 | Permit Number 38103 | 6001544.36482173 | 2102066.64624639 | 37.7519616591584 | -122.437533360465 | (37.7519616591584, -122.437533360465) | |
31555 | 31555 | 67316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 746 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 6 | Permit Number 30797 | 5992906.05892 | 2110364.3272599997 | 37.7742499931706 | -122.468009109205 | (37.7742499931706, -122.468009109205) | |
23901 | 23901 | 55472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 2 | Permit Number 24549 | 6001757.1677 | 2110793.9605 | 37.7759368233505 | -122.437422347525 | (37.7759368233505, -122.437422347525) | |
3502 | 3502 | 35369 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 628 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2005 12:00:00 AM | 8 | 5x9 | Permit Number 780712 | 6010944.29074 | 2105222.09895 | 37.76115577964 | -122.40524908009199 | (37.76115577964, -122.405249080092) |
147342 | 147342 | 76428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1998 12:00:00 AM | 1 | 6015359.03097 | 2115547.59056 | 37.7897531109548 | -122.390701840925 | (37.7897531109548, -122.390701840925) | ||
171446 | 171446 | 45471 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44250 | 5987593.6437099995 | 2110560.6661900003 | 37.7744808674341 | -122.48639989849501 | (37.7744808674341, -122.486399898495) | |
166387 | 166387 | 67337 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 639 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | 9 | Permit Number 30821 | 5993452.94224 | 2111127.09035 | 37.776375902741 | -122.46617279824899 | (37.776375902741, -122.466172798249) | |
31533 | 31533 | 43679 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 540 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 6 | Permit Number 43322 | 5994712.920030001 | 2111843.24303 | 37.7784148808037 | -122.461866155284 | (37.7784148808037, -122.461866155284) | |
62476 | 62476 | 43761 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 364 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43396 | 5990612.6596 | 2112954.63099 | 37.781229546008895 | -122.476131541236 | (37.7812295460089, -122.476131541236) | |
180131 | 180131 | 43801 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 525 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43431 | 5988746.62136 | 2111728.0872299997 | 37.777753417998206 | -122.48249713450899 | (37.7777534179982, -122.482497134509) | |
86218 | 86218 | 32079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3815 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35452 | 6004163.50427612 | 2105375.78416509 | 37.7611963327896 | -122.428711873399 | (37.7611963327896, -122.428711873399) | ||
89931 | 89931 | 32122 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 63 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35484 | 6003895.54546298 | 2106786.63464469 | 37.7650550206105 | -122.429739259442 | (37.7650550206105, -122.429739259442) | ||
89042 | 89042 | 34912 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 218 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 38515 | 6004873.60731086 | 2104005.13217632 | 37.7574730093691 | -122.426158345984 | (37.7574730093691, -122.426158345984) | ||
9566 | 9566 | 95785 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | ||||||
64269 | 64269 | 32204 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1639 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 15 | Permit Number 35527 | 6009324.38057 | 2099913.56366 | 37.7464890331489 | -122.41047681846202 | (37.7464890331489, -122.410476818462) | |
164190 | 164190 | 32221 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 615 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 11 | Permit Number 35542 | 6009696.62224 | 2100374.01527 | 37.7477741931343 | -122.409222129314 | (37.7477741931343, -122.409222129314) | |
53770 | 53770 | 38503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2442 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40494 | 6006707.70986 | 2119633.57608 | 37.8004884270583 | -122.420924848825 | (37.8004884270583, -122.420924848825) | |
100610 | 100610 | 96125 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767775 | 6008080.0 | 2096981.0 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | |
100691 | 100691 | 96126 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Ellsworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767775 | 6008080.0 | 2096981.0 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | |
144610 | 144610 | 70136 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 400 Gates St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768270 | 6008220.64737322 | 2096959.77893551 | 37.738316654626395 | -122.41408448515101 | (37.7383166546264, -122.414084485151) | ||
179852 | 179852 | 71574 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 970 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1995 12:00:00 AM | 10 | 6015483.05138 | 2104523.27151 | 37.759489655143 | -122.389502510438 | (37.759489655143, -122.389502510438) | ||
185713 | 185713 | 70681 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 366 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 9 | 6010590.1917 | 2106606.8545 | 37.7649382022496 | -122.406571346991 | (37.7649382022496, -122.406571346991) | ||
22993 | 22993 | 67532 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31070 | 6014045.342569999 | 2106049.86131 | 37.7636015183281 | -122.39458175543899 | (37.7636015183281, -122.394581755439) | |
134959 | 134959 | 68463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 8 | Permit Number 32325 | 5991519.12103 | 2113131.34732 | 37.781767281646204 | -122.473008553548 | (37.7817672816462, -122.473008553548) | |
63400 | 63400 | 67610 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1095 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 9 | Permit Number 31188 | 6015569.94295 | 2104025.3864 | 37.7581273863874 | -122.389167228807 | (37.7581273863874, -122.389167228807) | |
153154 | 153154 | 32482 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 89 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 7 | 3x3 | Permit Number 36990 | 6000124.50964 | 2105955.15278 | 37.762557717473896 | -122.442722593195 | (37.7625577174739, -122.442722593195) |
50162 | 50162 | 32664 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
81868 | 81868 | 32668 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
85965 | 85965 | 32663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
101973 | 101973 | 32666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
116718 | 116718 | 32665 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
123994 | 123994 | 32669 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
124802 | 124802 | 32662 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
126870 | 126870 | 32667 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
140257 | 140257 | 32660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
143115 | 143115 | 32661 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
97436 | 97436 | 62351 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22494 | 6005350.50245062 | 2099593.00770081 | 37.7453852789219 | -122.424195268575 | (37.7453852789219, -122.424195268575) |
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");