Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90336 | 90336 | 33497 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37588 | 6007021.25591613 | 2099725.96970318 | 37.745844557740604 | -122.418427487036 | (37.7458445577406, -122.418427487036) | |||
| 81767 | 81767 | 39513 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40964 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | |||
| 122007 | 122007 | 39514 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40964 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | |||
| 150081 | 150081 | 59706 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1001 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19136 | 6015543.40178 | 2104492.11293 | 37.7594074463272 | -122.389291611327 | (37.7594074463272, -122.389291611327) | ||
| 115162 | 115162 | 112277 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||||
| 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) | ||
| 135179 | 135179 | 59708 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1010 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19138 | 6015489.89793 | 2104400.82935 | 37.7591538347945 | -122.389470280533 | (37.7591538347945, -122.389470280533) | ||
| 14243 | 14243 | 105849 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1025 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 19016 | 6015551.36754 | 2104359.7286799997 | 37.7590443891103 | -122.389254817379 | (37.7590443891103, -122.389254817379) | ||
| 16371 | 16371 | 59613 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1025 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 10 | 3x3 | Permit Number 19016 | 6015555.95429 | 2104293.41546 | 37.7588625614652 | -122.389234323603 | (37.7588625614652, -122.389234323603) | |
| 171296 | 171296 | 52472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1038@ 12th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | Permit Number 48583 | 5992323.330569999 | 2111390.84025 | 37.777034850900606 | -122.470099615521 | (37.7770348509006, -122.470099615521) | |
| 159167 | 159167 | 59612 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1049 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2014 12:00:00 AM | 13 | Permit Number 19014 | 6015555.050530001 | 2104225.77952 | 37.758676797525 | -122.38923272642 | (37.758676797525, -122.38923272642) | ||
| 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) | ||
| 178877 | 178877 | 59611 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1053 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 11 | Permit Number 19013 | 6015558.09296 | 2104209.88833 | 37.758633332376704 | -122.389221094589 | (37.7586333323767, -122.389221094589) | ||
| 166751 | 166751 | 59610 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 19 | Permit Number 19012 | 6015498.92125 | 2104246.5894 | 37.7587308251729 | -122.389428301996 | (37.7587308251729, -122.389428301996) | ||
| 73157 | 73157 | 59608 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1067 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 15 | Permit Number 19010 | 6015563.891919999 | 2104132.18346 | 37.7584202928751 | -122.389195613182 | (37.7584202928751, -122.389195613182) | ||
| 175248 | 175248 | 59607 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1069 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 17 | Permit Number 19009 | 6015565.5861599995 | 2104116.66963 | 37.7583777891326 | -122.38918867043999 | (37.7583777891326, -122.38918867044) | ||
| 180126 | 180126 | 58243 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1074 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 16 | Permit Number 19008 | 6015506.93589 | 2104104.58893 | 37.758341366580204 | -122.38939066713999 | (37.7583413665802, -122.38939066714) | ||
| 46897 | 46897 | 30588 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 109 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34558 | 6003337.11539 | 2108646.4783400004 | 37.770130061294104 | -122.431803534827 | (37.7701300612941, -122.431803534827) | ||
| 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) | |
| 109086 | 109086 | 33481 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37592 | 6007052.40604971 | 2099676.37615129 | 37.7457101385308 | -122.418316258344 | (37.7457101385308, -122.418316258344) | ||
| 168454 | 168454 | 96089 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1101 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767146 | 6012237.5036 | 2103271.25294 | 37.7558714019501 | -122.400639334242 | (37.7558714019501, -122.400639334242) | |
| 51744 | 51744 | 39563 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1102 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40984 | 6012176.35989 | 2103275.1391 | 37.7558786621771 | -122.400851063421 | (37.7558786621771, -122.400851063421) | |
| 55121 | 55121 | 59604 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1105 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 12 | Permit Number 19005 | 6015580.10762 | 2103879.44891 | 37.7577272366388 | -122.38912188497801 | (37.7577272366388, -122.389121884978) | ||
| 153581 | 153581 | 59603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1109 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 13 | Permit Number 19004 | 6015581.75911 | 2103854.91189 | 37.7576599547603 | -122.38911446017599 | (37.7576599547603, -122.389114460176) | ||
| 49489 | 49489 | 59601 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1113 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 15 | Permit Number 19002 | 6015581.41308 | 2103829.5931 | 37.757590415576 | -122.389113889098 | (37.757590415576, -122.389113889098) | ||
| 168458 | 168458 | 59599 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1117 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 14 | Permit Number 19000 | 6015586.46491 | 2103801.69873 | 37.7575141036211 | -122.38909447005699 | (37.7575141036211, -122.389094470057) | ||
| 42285 | 42285 | 33829 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 15 | Permit Number 37844 | 6015587.6013400005 | 2103776.1855900004 | 37.7574441129692 | -122.38908875844601 | (37.7574441129692, -122.389088758446) | ||
| 156880 | 156880 | 33828 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 7 | Permit Number 37844 | 6015588.22624 | 2103756.71192 | 37.757390677059 | -122.38908523761299 | (37.757390677059, -122.389085237613) | ||
| 157294 | 157294 | 59707 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1133 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19137 | 6015590.05369 | 2103684.27955 | 37.757191894493296 | -122.38907386028299 | (37.7571918944933, -122.389073860283) | ||
| 65030 | 65030 | 54536 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 5 | Permit Number 10331 | 6009931.29054 | 2095213.10874 | 37.7336166059206 | -122.408046748666 | (37.7336166059206, -122.408046748666) | ||
| 79135 | 79135 | 88593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51537 | 6004415.0 | 2101011.0 | 37.7492258917596 | -122.427531088347 | (37.7492258917596, -122.427531088347) | ||
| 86940 | 86940 | 88592 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51537 | 6004415.0 | 2101011.0 | 37.7492258917596 | -122.427531088347 | (37.7492258917596, -122.427531088347) | ||
| 74327 | 74327 | 38387 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 13 | Permit Number 40446 | 6014272.48503 | 2096672.22783 | 37.7378651543499 | -122.39313992457399 | (37.7378651543499, -122.393139924574) | ||
| 64321 | 64321 | 69193 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1151 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1994 12:00:00 AM | 8 | Permit Number 33239 | 6008629.33261 | 2117936.9394099996 | 37.79593801218729 | -122.41415513556299 | (37.7959380121873, -122.414155135563) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 79048 | 79048 | 103163 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 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) | |||||
| 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) | ||||
| 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) | |
| 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) | |
| 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) | ||||
| 112317 | 112317 | 85318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2007 12:00:00 AM | Permit Number 49596 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | |||
| 104554 | 104554 | 38282 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 13 | 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) | |||
| 111573 | 111573 | 38271 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 3 | 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) | |||
| 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) | ||
| 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) | ||
| 156910 | 156910 | 51645 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003273.8297 | 2112901.0989 | 37.7818086078686 | -122.43232634946399 | (37.7818086078686, -122.432326349464) | |||
| 158575 | 158575 | 51642 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.782268304126795 | -122.432423068554 | (37.7822683041268, -122.432423068554) | |||
| 159617 | 159617 | 51644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 47930 | 6003258.6697 | 2113006.0531 | 37.7820959261745 | -122.43238629430701 | (37.7820959261745, -122.432386294307) | ||
| 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) | ||
| 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) |
| 80190 | 80190 | 9860 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 80526 | 80526 | 9862 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 92762 | 92762 | 9859 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 167145 | 167145 | 58941 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1366 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 13 | Permit Number 18219 | 6011964.85898 | 2102013.4641 | 37.7524025792275 | -122.401493839477 | (37.7524025792275, -122.401493839477) | ||
| 85299 | 85299 | 64872 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778656 | 6003401.65761863 | 2105041.71161228 | 37.760235902821606 | -122.43132292695499 | (37.7602359028216, -122.431322926955) | |
| 164001 | 164001 | 56674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1371 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5984603.4838 | 2105851.1543 | 37.761375137437604 | -122.496395703433 | (37.7613751374376, -122.496395703433) | ||||
| 97080 | 97080 | 46078 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2001 12:00:00 AM | Permit Number 44459 | 6016168.14280668 | 2094664.01192279 | 37.7324561236274 | -122.38644566841499 | (37.7324561236274, -122.386445668415) | |||
| 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) | |
| 91914 | 91914 | 44218 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43664 | 6000710.69184788 | 2110000.79371699 | 37.7736994385051 | -122.440985455094 | (37.7736994385051, -122.440985455094) | ||||
| 115193 | 115193 | 44217 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43664 | 6000710.69184788 | 2110000.79371699 | 37.7736994385051 | -122.440985455094 | (37.7736994385051, -122.440985455094) | ||||
| 103752 | 103752 | 88795 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51707 | 6003948.0 | 2099953.0 | 37.7462944444026 | -122.429070556888 | (37.7462944444026, -122.429070556888) | ||
| 108957 | 108957 | 88796 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51707 | 6003948.0 | 2099953.0 | 37.7462944444026 | -122.429070556888 | (37.7462944444026, -122.429070556888) | ||
| 17564 | 17564 | 4458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1420 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1994 12:00:00 AM | 3 | 3X3 | 6004503.18681 | 2100562.9723099996 | 37.7480006990827 | -122.427194227854 | (37.7480006990827, -122.427194227854) | ||
| 83124 | 83124 | 46130 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44480 | 5998294.90485878 | 2107939.22220742 | 37.767901000510705 | -122.44919344916 | (37.7679010005107, -122.44919344916) | ||
| 2178 | 2178 | 18161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005286.1585 | 2114461.6714 | 37.7862074506483 | -122.425475720608 | (37.7862074506483, -122.425475720608) | |||
| 4082 | 4082 | 18163 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005210.3387 | 2114450.1336 | 37.7861714865556 | -122.425737215933 | (37.7861714865556, -122.425737215933) | |||
| 5713 | 5713 | 18162 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005249.8968 | 2114455.0784 | 37.7861872990315 | -122.425600707285 | (37.7861872990315, -122.425600707285) | |||
| 5899 | 5899 | 18165 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005168.5828 | 2114444.09 | 37.786152532687105 | -122.42588125009199 | (37.7861525326871, -122.425881250092) | |||
| 5968 | 5968 | 18166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005153.199 | 2114441.8923 | 37.786145628959204 | -122.42593431751101 | (37.7861456289592, -122.425934317511) | |||
| 6323 | 6323 | 18167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005136.7165 | 2114437.497 | 37.7861326290509 | -122.425991029638 | (37.7861326290509, -122.425991029638) | |||
| 8468 | 8468 | 18164 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005185.0654 | 2114447.3865 | 37.78616251551679 | -122.42582445934299 | (37.7861625155168, -122.425824459343) | |||
| 89276 | 89276 | 59505 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 148 JULIAN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/1981 12:00:00 AM | 12 | 4x4 | Permit Number 18882 | 6006386.5 | 2107005.0 | 37.7657953383606 | -122.421139154349 | (37.7657953383606, -122.421139154349) | |
| 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) | ||
| 90213 | 90213 | 100247 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 1 | 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) | |||
| 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) | |||
| 119786 | 119786 | 60800 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 150 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1983 12:00:00 AM | Permit Number 20475 | 6001683.44318293 | 2107946.37738027 | 37.768113877675 | -122.43747341695801 | (37.768113877675, -122.437473416958) | |||
| 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) | ||
| 100219 | 100219 | 39625 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1516 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41023 | 5997885.89044429 | 2105542.94174539 | 37.761298018687896 | -122.450435409974 | (37.7612980186879, -122.450435409974) | ||
| 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) | ||
| 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) | |
| 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) | |
| 93960 | 93960 | 32930 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 3 | 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) | |||
| 97451 | 97451 | 32933 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 6 | 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) | |||
| 106126 | 106126 | 32932 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 5 | 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) | |||
| 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) | |||
| 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) | ||
| 78629 | 78629 | 39631 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1578 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41026 | 5997930.04124721 | 2105225.66494664 | 37.7604293831671 | -122.450259840819 | (37.7604293831671, -122.450259840819) | ||
| 146864 | 146864 | 30369 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1632 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1974 12:00:00 AM | 14 | Permit Number 14152 | 6013068.70069 | 2104759.9070200003 | 37.7600052436607 | -122.39786918403999 | (37.7600052436607, -122.39786918404) | ||
| 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) | |
| 169158 | 169158 | 38901 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 164 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40715 | 5996940.8515 | 2113271.4959 | 37.7824644937943 | -122.45426213802 | (37.7824644937943, -122.45426213802) | |
| 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) | ||
| 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) |
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");