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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122586 | 122586 | 37995 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 122689 | 122689 | 117081 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1526 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5x5 | 6003241.0 | 2113609.0 | 37.7837504649041 | -122.432490502891 | (37.7837504649041, -122.432490502891) | ||||
| 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) | ||
| 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) | ||||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 126528 | 126528 | 111776 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 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) | ||
| 126936 | 126936 | 52650 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1187@ RIVOLI Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | Permit Number 48734 | 5997369.46824352 | 2105989.04982963 | 37.7624933485057 | -122.452253677885 | (37.7624933485057, -122.452253677885) | |||
| 127573 | 127573 | 50460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 127577 | 127577 | 97501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 127747 | 127747 | 92232 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49975 | 6015152.0 | 2105524.0 | 37.762219079001795 | -122.390717392856 | (37.7622190790018, -122.390717392856) | |||
| 128045 | 128045 | 103161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||||
| 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) | |
| 128515 | 128515 | 48660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1518 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51136 | 5993396.16596973 | 2105141.2714508 | 37.7599371524818 | -122.465934158818 | (37.7599371524818, -122.465934158818) | ||
| 129182 | 129182 | 62460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1985 12:00:00 AM | Permit Number 22628 | 5994209.59395504 | 2092281.24653849 | 37.724673635737 | -122.46218826108101 | (37.724673635737, -122.462188261081) | |||
| 129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
| 138407 | 138407 | 32931 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 139257 | 139257 | 75814 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 300X Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | Permit Number 769917 | 6011998.05472036 | 2119270.81717993 | 37.7997891592695 | -122.402592490972 | (37.7997891592695, -122.402592490972) | |||
| 139810 | 139810 | 45701 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 140108 | 140108 | 103137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993979.5 | 2106772.5 | 37.7644497152943 | -122.46403512031799 | (37.7644497152943, -122.464035120318) | ||||
| 140201 | 140201 | 111132 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 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) | ||
| 141126 | 141126 | 38270 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 141177 | 141177 | 45692 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 141768 | 141768 | 99766 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4300x 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 1192 Diamond ST | 6001940.4 | 2100620.7 | 37.748013943002704 | -122.436060356931 | (37.7480139430027, -122.436060356931) | |||
| 141853 | 141853 | 45694 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 141934 | 141934 | 58614 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1052 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1979 12:00:00 AM | 3x3 | Permit Number 17828 | 5998153.64010117 | 2106679.35024276 | 37.764433630662204 | -122.449591270882 | (37.7644336306622, -122.449591270882) | ||
| 142026 | 142026 | 37993 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 142174 | 142174 | 111129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 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) | ||
| 142550 | 142550 | 110258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 142581 | 142581 | 50461 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 143570 | 143570 | 52276 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 69 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48438 | 6004677.30249487 | 2101602.8265641 | 37.7508657429158 | -122.426666180441 | (37.7508657429158, -122.426666180441) | ||
| 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) | ||
| 143864 | 143864 | 32929 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 3x3 | Permit Number 40482 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | ||
| 143865 | 143865 | 53169 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 143920 | 143920 | 45696 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 144524 | 144524 | 84799 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49306 | 6003755.0 | 2096568.0 | 37.7369890856012 | -122.42949656641501 | (37.7369890856012, -122.429496566415) | |||
| 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) | ||
| 144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 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) | ||
| 144848 | 144848 | 50458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 145248 | 145248 | 61069 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2011 12:00:00 AM | 3x3 | Permit Number 54089 | 6000057.45151415 | 2105676.05314863 | 37.7617875559763 | -122.442934478534 | (37.7617875559763, -122.442934478534) | ||
| 145871 | 145871 | 103166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 146082 | 146082 | 58491 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1978 12:00:00 AM | 4x4 | Permit Number 17662 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||
| 53171 | 53171 | 85317 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | ||||
| 134532 | 134532 | 227811 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1068 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5998996.78199 | 2106266.6439900002 | 37.7633486415415 | -122.44664539098999 | (37.7633486415415, -122.44664539099) | |||
| 169641 | 169641 | 32813 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 0 | Permit Number 37172 | 6000168.11066279 | 2110698.62439724 | 37.7755845864888 | -122.44291244402201 | (37.7755845864888, -122.442912444022) | ||
| 26865 | 26865 | 200267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6014763.4294300005 | 2089103.4873400002 | 37.7171101711671 | -122.39091365107001 | (37.7171101711671, -122.39091365107) | |||
| 27768 | 27768 | 208072 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 48 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994750.66862 | 2100768.2505900003 | 37.7480079970652 | -122.460932676625 | (37.7480079970652, -122.460932676625) | |||
| 34733 | 34733 | 208139 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Santa Rita Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5993922.554140001 | 2100955.0265200003 | 37.7484731507208 | -122.463809795788 | (37.7484731507208, -122.463809795788) | |||
| 37878 | 37878 | 138694 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001275.2721 | 2114538.5353 | 37.786191064717606 | -122.43935781732701 | (37.7861910647176, -122.439357817327) | |||
| 39655 | 39655 | 142188 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000411.8524 | 2110252.886 | 37.774374595004204 | -122.442037282737 | (37.7743745950042, -122.442037282737) | |||
| 47828 | 47828 | 142201 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 LYON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000256.1251 | 2110062.625 | 37.7738433108292 | -122.44256230775801 | (37.7738433108292, -122.442562307758) | |||
| 52402 | 52402 | 208035 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1722 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993749.1972900005 | 2103750.68638 | 37.7561393252901 | -122.464612228482 | (37.7561393252901, -122.464612228482) | |||
| 57238 | 57238 | 138689 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001375.2358 | 2114552.1107 | 37.786234027507 | -122.439012943204 | (37.786234027507, -122.439012943204) | |||
| 60865 | 60865 | 121710 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6014421.90164 | 2103226.1823299997 | 37.7558692345973 | -122.39308176182199 | (37.7558692345973, -122.393081761822) | ||||
| 63843 | 63843 | 51639 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 1 | Permit Number 47930 | 6003279.6605 | 2112867.2804 | 37.7817160813577 | -122.432303761604 | (37.7817160813577, -122.432303761604) | ||
| 64416 | 64416 | 142192 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000600.1586 | 2110278.2975 | 37.7744550977244 | -122.44138772192301 | (37.7744550977244, -122.441387721923) | |||
| 66678 | 66678 | 115037 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | |||
| 70526 | 70526 | 200260 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 289 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009611.964380001 | 2110379.9903700002 | 37.775243583058 | -122.41022121854401 | (37.775243583058, -122.410221218544) | |||
| 71269 | 71269 | 142202 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 LYON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000252.2157 | 2110108.2355 | 37.7739683228777 | -122.442579106401 | (37.7739683228777, -122.442579106401) | |||
| 115839 | 115839 | 116265 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6001353.9473 | 2114257.7728 | 37.7854246399045 | -122.439065493069 | (37.7854246399045, -122.439065493069) | |||
| 135110 | 135110 | 208051 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992912.8595 | 2095175.00787 | 37.7325444413573 | -122.466881141568 | (37.7325444413573, -122.466881141568) | |||
| 136647 | 136647 | 191541 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6014398.75245 | 2103666.33403 | 37.7570765105783 | -122.393192617642 | (37.7570765105783, -122.393192617642) | |||
| 147258 | 147258 | 142187 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000375.364 | 2110249.6281 | 37.7743635702122 | -122.44216326866001 | (37.7743635702122, -122.44216326866) | |||
| 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) | ||
| 148810 | 148810 | 208060 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992248.76597 | 2101036.0508 | 37.748599027031496 | -122.46960356926 | (37.7485990270315, -122.46960356926) | |||
| 149992 | 149992 | 142184 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000278.9304 | 2110237.8997 | 37.7743258707295 | -122.44249600725401 | (37.7743258707295, -122.442496007254) | |||
| 163534 | 163534 | 227824 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008211.90866 | 2096957.8323099997 | 37.73831081878821 | -122.41411456174801 | (37.7383108187882, -122.414114561748) | |||
| 167660 | 167660 | 208024 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1652 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993734.6687900005 | 2104236.25735 | 37.7574717401585 | -122.464697731525 | (37.7574717401585, -122.464697731525) | |||
| 172167 | 172167 | 142185 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000306.2967 | 2110239.2028 | 37.774331008558995 | -122.442401436017 | (37.774331008559, -122.442401436017) | |||
| 176124 | 176124 | 227951 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009943.616780001 | 2103443.6327299997 | 37.7562165159053 | -122.408584536948 | (37.7562165159053, -122.408584536948) | |||
| 179606 | 179606 | 142190 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000475.0555 | 2110262.6596 | 37.774405032375604 | -122.441819353615 | (37.7744050323756, -122.441819353615) | |||
| 23897 | 23897 | 248466 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998292.5435 | 2107918.5956 | 37.7678442300261 | -122.449200130602 | (37.7678442300261, -122.449200130602) | |||
| 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) | |
| 34340 | 34340 | 200271 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014518.22002 | 2089293.0618599998 | 37.7176170965211 | -122.391774477626 | (37.7176170965211, -122.391774477626) | |||
| 39056 | 39056 | 200272 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014501.14248 | 2089299.14768 | 37.7176328589541 | -122.39183393271401 | (37.7176328589541, -122.391833932714) | |||
| 44146 | 44146 | 138695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001299.3374 | 2114542.2377 | 37.786202600035296 | -122.43927482337 | (37.7862026000353, -122.43927482337) | |||
| 44337 | 44337 | 103160 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||
| 49142 | 49142 | 200274 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014408.1626699995 | 2089360.68754 | 37.7177966731557 | -122.392159625791 | (37.7177966731557, -122.392159625791) | |||
| 49865 | 49865 | 51646 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 2 | Permit Number 47930 | 6003261.002 | 2112980.3977 | 37.7820256151298 | -122.43237639268801 | (37.7820256151298, -122.432376392688) | ||
| 50356 | 50356 | 200269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014632.09061 | 2089229.7896900002 | 37.7174496841459 | -122.39137645477501 | (37.7174496841459, -122.391376454775) | |||
| 51688 | 51688 | 200270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014621.84489 | 2089234.87823 | 37.717463087626705 | -122.39141222532 | (37.7174630876267, -122.39141222532) | |||
| 52181 | 52181 | 51643 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 47930 | 6003254.005 | 2113044.5364 | 37.7822013271565 | -122.432405181484 | (37.7822013271565, -122.432405181484) | ||
| 53038 | 53038 | 208160 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 366 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5997663.5494099995 | 2093590.68698 | 37.7284673190039 | -122.45034277641399 | (37.7284673190039, -122.450342776414) | |||
| 53265 | 53265 | 227885 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 280 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004498.87593 | 2103979.46258 | 37.7573813393853 | -122.427452488844 | (37.7573813393853, -122.427452488844) | |||
| 59133 | 59133 | 227950 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009943.9384 | 2103453.89323 | 37.756244706952295 | -122.408584148445 | (37.7562447069523, -122.408584148445) | |||
| 63521 | 63521 | 200266 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014773.14657 | 2089094.60205 | 37.7170863130726 | -122.39087944264999 | (37.7170863130726, -122.39087944265) | |||
| 68119 | 68119 | 208059 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992246.63721 | 2101046.2039400004 | 37.7486267819054 | -122.469611669441 | (37.7486267819054, -122.469611669441) | |||
| 69140 | 69140 | 191529 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6016082.02245 | 2107209.5732299997 | 37.7668988547309 | -122.387618372283 | (37.7668988547309, -122.387618372283) | |||
| 73104 | 73104 | 200264 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014856.837309999 | 2088987.16565 | 37.716795957049996 | -122.390582658263 | (37.71679595705, -122.390582658263) | |||
| 74796 | 74796 | 227707 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4969 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997582.13429 | 2105601.24546 | 37.761440716331 | -122.45149017463301 | (37.761440716331, -122.451490174633) |
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");