Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||
| 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) | |
| 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) | |
| 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) | ||
| 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) |
| 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) | |
| 86844 | 86844 | 53174 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 44@ DIAMOND Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49089 | 6001797.88022558 | 2096945.60904163 | 37.7379149076596 | -122.43629020957701 | (37.7379149076596, -122.436290209577) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 80858 | 80858 | 53166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 7 | 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) | ||
| 81932 | 81932 | 53168 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 4 | 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) | ||
| 87409 | 87409 | 53170 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 1 | 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) | ||
| 108069 | 108069 | 53167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 6 | 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) | ||
| 111983 | 111983 | 53171 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 5 | 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) | ||
| 115764 | 115764 | 53165 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 3 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 79045 | 79045 | 52268 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48433 | 6004938.09310689 | 2099915.7288881 | 37.7462481025481 | -122.42564427901002 | (37.7462481025481, -122.42564427901) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 100290 | 100290 | 39116 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 3x3 | Permit Number 40802 | 6009834.44503837 | 2101335.31973877 | 37.750421443407 | -122.408813353776 | (37.750421443407, -122.408813353776) | |
| 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) | ||
| 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) | ||
| 93679 | 93679 | 52264 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 323 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48429 | 6004810.64378821 | 2101860.96102729 | 37.7515820578763 | -122.426223449326 | (37.7515820578763, -122.426223449326) | ||
| 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) | |
| 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) | |
| 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) | ||
| 82631 | 82631 | 34995 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40965 | 6004109.16234729 | 2102931.20405913 | 37.7544810193688 | -122.42872554735001 | (37.7544810193688, -122.42872554735) | ||
| 106212 | 106212 | 34996 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40965 | 6004109.16234729 | 2102931.20405913 | 37.7544810193688 | -122.42872554735001 | (37.7544810193688, -122.42872554735) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 95312 | 95312 | 39197 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 982 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773799 | 6009935.22104907 | 2103489.58059063 | 37.756342208225604 | -122.408616813596 | (37.7563422082256, -122.408616813596) |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) |
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | |
| 49082 | 49082 | 81252 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 877 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 8 | 6011897.37583 | 2104298.81412 | 37.7586738828079 | -122.40188784325001 | (37.7586738828079, -122.40188784325) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 82555 | 82555 | 41201 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 97143 | 97143 | 41197 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 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) | ||
| 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) | |
| 107189 | 107189 | 39075 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2280X Alameda St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | ||
| 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) | |
| 90147 | 90147 | 41102 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 522 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41849 | 5998953.51396356 | 2108953.1338679 | 37.770722593254206 | -122.44698837628401 | (37.7707225932542, -122.446988376284) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 168730 | 168730 | 32810 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1763 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37169 | 5999413.3803 | 2110122.477 | 37.77395957486279 | -122.445481792777 | (37.7739595748628, -122.445481792777) |
| 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) |
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");