Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 403 | 403 | 65940 | Planning Code 138.1 required 4 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.78332336932171 | -122.41797588370702 | (37.7833233693217, -122.417975883707) | |
| 1144 | 1144 | 38281 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6014095.62624 | 2104027.41968 | 37.7580511292617 | -122.39426623192101 | (37.7580511292617, -122.394266231921) | ||
| 1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
| 5701 | 5701 | 35451 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 6310 | 6310 | 35452 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 7488 | 7488 | 35443 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 7802 | 7802 | 35460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 8146 | 8146 | 35450 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 8325 | 8325 | 23708 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6003978.3577 | 2111349.4443 | 37.77758807209621 | -122.429778304865 | (37.7775880720962, -122.429778304865) | ||||
| 8339 | 8339 | 37971 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40201 | ||||||||
| 8797 | 8797 | 35455 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 9539 | 9539 | 35456 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 9554 | 9554 | 35448 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 9594 | 9594 | 35445 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 9948 | 9948 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 Higuera Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 10262 | 10262 | 35446 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 10483 | 10483 | 35442 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 10753 | 10753 | 35454 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 11139 | 11139 | 35047 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 11629 | 11629 | 35449 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 12085 | 12085 | 35458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 12173 | 12173 | 37972 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40202 | ||||||||
| 14341 | 14341 | 35444 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 14595 | 14595 | 35457 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 14838 | 14838 | 35048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 15544 | 15544 | 37973 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 630 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40203 | ||||||||
| 15638 | 15638 | 121717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.9321099995 | 2103065.57675 | 37.755428803314295 | -122.39303583615101 | (37.7554288033143, -122.393035836151) | ||
| 16105 | 16105 | 35453 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 16221 | 16221 | 35459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 16736 | 16736 | 121715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.39304689240299 | (37.7555585790683, -122.393046892403) | ||
| 17025 | 17025 | 35447 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 18406 | 18406 | 51586 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5REVISED Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2005 12:00:00 AM | Permit Number 47879 | 6001458.32672553 | 2108232.67146529 | 37.7688871692043 | -122.43827258221 | (37.7688871692043, -122.43827258221) | |||
| 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) | ||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 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) | |
| 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) | |
| 24480 | 24480 | 33644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 491 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 15 | Permit Number 37738 | 6005071.3427 | 2110746.7678 | 37.7759951015754 | -122.425954387251 | (37.7759951015754, -122.425954387251) | |
| 25396 | 25396 | 38266 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660X Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 10 | Permit Number 40367 | 6014098.11933 | 2104009.06988 | 37.7580008832593 | -122.394256324976 | (37.7580008832593, -122.394256324976) | ||
| 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) | ||
| 29235 | 29235 | 33862 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 281 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | 7 | Permit Number 37859 | 6011395.19215 | 2111355.67015 | 37.778022368579 | -122.404121275373 | (37.778022368579, -122.404121275373) | ||
| 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) | |
| 31015 | 31015 | 59108 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 616 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18411 | 5993182.92211 | 2111277.08736 | 37.7767721716598 | -122.46711777381901 | (37.7767721716598, -122.467117773819) | ||
| 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) | |
| 31533 | 31533 | 43679 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 540 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 6 | Permit Number 43322 | 5994712.920030001 | 2111843.24303 | 37.7784148808037 | -122.461866155284 | (37.7784148808037, -122.461866155284) | |
| 31555 | 31555 | 67316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 746 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 6 | Permit Number 30797 | 5992906.05892 | 2110364.3272599997 | 37.7742499931706 | -122.468009109205 | (37.7742499931706, -122.468009109205) | |
| 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) | |
| 37214 | 37214 | 191135 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6015829.2920699995 | 2099737.9733599997 | 37.7463694242077 | -122.387971104383 | (37.7463694242077, -122.387971104383) | ||||
| 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) | ||
| 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) | |
| 43843 | 43843 | 55312 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1972 12:00:00 AM | 6 | Permit Number 11241 | 6012672.97117 | 2112433.28595 | 37.7810525658564 | -122.399776639786 | (37.7810525658564, -122.399776639786) | ||
| 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) | ||
| 45438 | 45438 | 58034 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 49 Gilbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1982 12:00:00 AM | 17 | Permit Number 19534 | 6011578.8271699995 | 2109918.45412 | 37.7740863633284 | -122.403384878125 | (37.7740863633284, -122.403384878125) | ||
| 45851 | 45851 | 56146 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 5 | Permit Number 12252 | 6012396.0474 | 2103982.5654599997 | 37.7578333512523 | -122.400140988433 | (37.7578333512523, -122.400140988433) | ||
| 46423 | 46423 | 45764 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3954 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44411 | 5995797.28433 | 2115532.1043599998 | 37.788605873462 | -122.45838203677799 | (37.788605873462, -122.458382036778) | ||
| 46626 | 46626 | 59336 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 775 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31976 | 5982585.1174 | 2110516.14744 | 37.774065420371706 | -122.50372176444999 | (37.7740654203717, -122.50372176445) | ||
| 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) | ||
| 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) | ||
| 49087 | 49087 | 87032 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 11 | Permit Number 49975 | 6015139.67842 | 2105542.64874 | 37.762269600786 | -122.390761312191 | (37.762269600786, -122.390761312191) | ||
| 49482 | 49482 | 191518 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.96067 | 2102295.09834 | 37.7533649068725 | -122.38976221485201 | (37.7533649068725, -122.389762214852) | ||||
| 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) | ||
| 49617 | 49617 | 65056 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3033 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1989 12:00:00 AM | 8 | Permit Number 27010 | 6003374.31765 | 2118807.7930799997 | 37.7980325835968 | -122.43240070983299 | (37.7980325835968, -122.432400709833) | ||
| 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) | ||
| 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) | ||
| 50522 | 50522 | 31991 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 215 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35392 | 5994587.26751 | 2113998.16217 | 37.784324475145795 | -122.462457175798 | (37.7843244751458, -122.462457175798) | |
| 50885 | 50885 | 65749 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2800 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1990 12:00:00 AM | 14 | Permit Number 28712 | 6002107.84727 | 2117793.0389799997 | 37.79517443830839 | -122.436710379777 | (37.7951744383084, -122.436710379777) | ||
| 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) | |
| 52320 | 52320 | 38502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2440 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42685 | 6006711.92416 | 2119615.77365 | 37.8004397836378 | -122.420909000977 | (37.8004397836378, -122.420909000977) | |
| 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) | ||||
| 53770 | 53770 | 38503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2442 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40494 | 6006707.70986 | 2119633.57608 | 37.8004884270583 | -122.420924848825 | (37.8004884270583, -122.420924848825) | |
| 54438 | 54438 | 51491 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | 15 | Permit Number 47802 | 6012000.2882 | 2106461.09609 | 37.764616771064404 | -122.401683904009 | (37.7646167710644, -122.401683904009) | ||
| 54747 | 54747 | 121720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6014432.547780001 | 2103023.07571 | 37.755312138768204 | -122.39303073340099 | (37.7553121387682, -122.393030733401) | ||||
| 55096 | 55096 | 38272 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660X Mississippi St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 10 | Permit Number 40367 | 6014098.08793 | 2103987.31346 | 37.7579411430904 | -122.39425491036002 | (37.7579411430904, -122.39425491036) | ||
| 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) | ||
| 56286 | 56286 | 121708 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6014420.072369999 | 2103257.32043 | 37.7559546315195 | -122.393090266722 | (37.7559546315195, -122.393090266722) | ||||
| 58680 | 58680 | 46532 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 881PERMIT) Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2002 12:00:00 AM | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.44779578842699 | (37.765484436098, -122.447795788427) | |||
| 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) | ||||
| 60910 | 60910 | 97503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | Permit Number 768347 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||
| 62476 | 62476 | 43761 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 364 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43396 | 5990612.6596 | 2112954.63099 | 37.781229546008895 | -122.476131541236 | (37.7812295460089, -122.476131541236) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 65171 | 65171 | 45763 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3954 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44411 | 5995817.4754 | 2115534.8475099998 | 37.7886145656939 | -122.45831237779 | (37.7886145656939, -122.45831237779) | ||
| 66100 | 66100 | 59119 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 534 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 16 | Permit Number 18423 | 5992850.01468 | 2111803.3179099998 | 37.778197836504 | -122.468307682232 | (37.778197836504, -122.468307682232) | ||
| 69538 | 69538 | 37593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 643 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40021 | 5992524.5893 | 2111069.01654 | 37.776162842853296 | -122.469379974251 | (37.7761628428533, -122.469379974251) | |
| 69558 | 69558 | 208157 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6000676.4727 | 2094919.4754400002 | 37.7322878369069 | -122.440022214175 | (37.7322878369069, -122.440022214175) | ||||
| 69648 | 69648 | 191550 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014425.29285 | 2102980.5331200003 | 37.7551949229254 | -122.39305284682301 | (37.7551949229254, -122.393052846823) | ||||
| 72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 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) | ||
| 74264 | 74264 | 121711 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6014421.639169999 | 2103213.20868 | 37.7558335971581 | -122.393081761812 | (37.7558335971581, -122.393081761812) | ||||
| 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) | ||
| 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) | |
| 76739 | 76739 | 33646 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 491 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 9 | Permit Number 37738 | 6005091.8882 | 2110750.3935 | 37.776006217968 | -122.425883573067 | (37.776006217968, -122.425883573067) | ||
| 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) | |
| 77861 | 77861 | 45693 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 11 | 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) | |||
| 78079 | 78079 | 107066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1758 12th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/24/2014 12:00:00 AM | Permit Number 773344 | 5992506.32742 | 2103625.79831 | 37.7557246862805 | -122.468901366602 | (37.7557246862805, -122.468901366602) | |||
| 78241 | 78241 | 38273 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 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) | |||
| 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) |
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");