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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 15784 | 15784 | 121716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779222 | 6014431.75751 | 2103081.25316 | 37.7554718376765 | -122.39303753677 | (37.7554718376765, -122.39303753677) | |
| 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) | ||
| 90767 | 90767 | 87093 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3975 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50046 | 6003177.0 | 2104745.0 | 37.7594084694279 | -122.432078722509 | (37.7594084694279, -122.432078722509) | ||
| 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) |
| 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) | |||
| 78687 | 78687 | 108260 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 6003817.04493 | 2108084.5446900004 | 37.768614322037294 | -122.430103370918 | (37.7686143220373, -122.430103370918) | |||
| 83868 | 83868 | 52344 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 733 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2005 12:00:00 AM | Permit Number 48488 | 5998540.65318208 | 2108052.92753039 | 37.7682272594267 | -122.448351626603 | (37.7682272594267, -122.448351626603) | |||
| 129182 | 129182 | 62460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1985 12:00:00 AM | Permit Number 22628 | 5994209.59395504 | 2092281.24653849 | 37.724673635737 | -122.46218826108101 | (37.724673635737, -122.462188261081) | |||
| 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) | ||
| 127747 | 127747 | 92232 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49975 | 6015152.0 | 2105524.0 | 37.762219079001795 | -122.390717392856 | (37.7622190790018, -122.390717392856) | |||
| 135316 | 135316 | 60501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1988 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1982 12:00:00 AM | 15 | Permit Number 20100 | 6004700.44951 | 2117099.10485 | 37.793416068552396 | -122.427690103237 | (37.7934160685524, -122.427690103237) | ||
| 142405 | 142405 | 121587 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6012170.0 | 2103110.0 | 37.7554248716487 | -122.400861456416 | (37.7554248716487, -122.400861456416) | ||
| 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) | |
| 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) | ||
| 108694 | 108694 | 33645 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 491 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37738 | 6005082.6226 | 2110749.5878 | 37.7760034820831 | -122.425915567871 | (37.7760034820831, -122.425915567871) | ||
| 176805 | 176805 | 57127 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 468 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 10 | Permit Number 18848 | 6014045.26968 | 2104987.99567 | 37.7606858631895 | -122.39450764863399 | (37.7606858631895, -122.394507648634) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 121761 | 121761 | 33593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37700 | 6006820.21311038 | 2097865.60877622 | 37.7407251042318 | -122.418990739568 | (37.7407251042318, -122.418990739568) | |||
| 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) | ||
| 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) | ||
| 41045 | 41045 | 48885 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 3 | 3x3 | Permit Number 46091 | 6009414.4878 | 2110585.56643 | 37.7757969754933 | -122.410918860444 | (37.7757969754933, -122.410918860444) | |
| 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) | |||
| 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) | |
| 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) | ||
| 155340 | 155340 | 66278 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2566 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1990 12:00:00 AM | 18 | Permit Number 29386 | 6002437.3174 | 2116458.1230200003 | 37.7915278222894 | -122.43547482192699 | (37.7915278222894, -122.435474821927) | ||
| 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) | ||
| 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) | ||
| 165854 | 165854 | 58323 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2535 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1978 12:00:00 AM | 11 | Permit Number 17348 | 6004044.87416 | 2117496.37379 | 37.7944697628231 | -122.429986793678 | (37.7944697628231, -122.429986793678) | ||
| 159745 | 159745 | 69952 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 565 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 8 | 5997087.15611 | 2114145.30542 | 37.7848721322932 | -122.453819112066 | (37.7848721322932, -122.453819112066) | ||
| 3073 | 3073 | 227974 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200X 29th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005213.325 | 2099049.95145 | 37.7438864239343 | -122.424630982854 | (37.7438864239343, -122.424630982854) | |
| 3076 | 3076 | 227975 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200X 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 4 | Width 3ft | Permit Number 49086 | 6005200.1380900005 | 2099049.18147 | 37.7438835649874 | -122.424676525409 | (37.7438835649874, -122.424676525409) | |
| 3079 | 3079 | 227980 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 7 | Width 3ft | Permit Number 49086 | 6005100.30377 | 2099043.7406 | 37.7438629866828 | -122.425021342566 | (37.7438629866828, -122.425021342566) | |
| 3085 | 3085 | 227978 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005155.75456 | 2099046.13918 | 37.7438727047738 | -122.42482977709601 | (37.7438727047738, -122.424829777096) | |
| 3086 | 3086 | 227976 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005186.74242 | 2099048.41612 | 37.7438807069453 | -122.424722790133 | (37.7438807069453, -122.424722790133) | |
| 3092 | 3092 | 227977 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 4 | Width 3ft | Permit Number 49086 | 6005172.09288 | 2099047.67656 | 37.7438778488792 | -122.424773392283 | (37.7438778488792, -122.424773392283) | |
| 3098 | 3098 | 227979 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 6 | Width 3ft | Permit Number 49086 | 6005126.89466 | 2099045.69197 | 37.7438698467248 | -122.424929536192 | (37.7438698467248, -122.424929536192) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 130687 | 130687 | 38879 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40702 | 5996216.25426 | 2115095.08483 | 37.7874300029464 | -122.456900851289 | (37.7874300029464, -122.456900851289) | |
| 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) | |
| 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) | |||
| 3893 | 3893 | 227810 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 974 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1979 12:00:00 AM | 11 | Width 3ft | Permit Number 18080 | 5999262.93769 | 2106710.24786 | 37.7645818665711 | -122.44575675288401 | (37.7645818665711, -122.445756752884) | |
| 35374 | 35374 | 32812 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 421 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 5x5 | Permit Number 37171 | 6000142.4606 | 2110508.5779 | 37.7750613046635 | -122.442987522526 | (37.7750613046635, -122.442987522526) |
| 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) |
| 169641 | 169641 | 32813 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 0 | Permit Number 37172 | 6000168.11066279 | 2110698.62439724 | 37.7755845864888 | -122.44291244402201 | (37.7755845864888, -122.442912444022) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 50162 | 50162 | 32664 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 81868 | 81868 | 32668 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 85965 | 85965 | 32663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 101973 | 101973 | 32666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 116718 | 116718 | 32665 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 123994 | 123994 | 32669 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 124802 | 124802 | 32662 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 126870 | 126870 | 32667 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 140257 | 140257 | 32660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 143115 | 143115 | 32661 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 79221 | 79221 | 50462 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 82830 | 82830 | 50459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 94029 | 94029 | 50463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 127573 | 127573 | 50460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 142581 | 142581 | 50461 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 144848 | 144848 | 50458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 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) | |||
| 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) |
| 106871 | 106871 | 59867 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1981 12:00:00 AM | 10 | Permit Number 19326 | 5994285.52331 | 2115052.43823 | 37.7872018500152 | -122.463577637239 | (37.7872018500152, -122.463577637239) | ||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 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) | |
| 134959 | 134959 | 68463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 8 | Permit Number 32325 | 5991519.12103 | 2113131.34732 | 37.781767281646204 | -122.473008553548 | (37.7817672816462, -122.473008553548) | |
| 20543 | 20543 | 2353 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2413 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2013 12:00:00 AM | 3 | 4X4 | 6009731.35926 | 2103287.7886799998 | 37.7557767132463 | -122.409307601761 | (37.7557767132463, -122.409307601761) | ||
| 6589 | 6589 | 4667 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 12 | 3 | Permit Number 769286 | 6009690.8519 | 2119608.7257 | 37.80058789320879 | -122.410600176031 | (37.8005878932088, -122.410600176031) | |
| 7649 | 7649 | 4666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 60 | 3 | Permit Number 769286 | 6009738.4106 | 2119565.7843 | 37.8004726529456 | -122.41043256902 | (37.8004726529456, -122.41043256902) | |
| 19144 | 19144 | 2409 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2743 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1996 12:00:00 AM | 8 | 3X3 | 6009838.5674 | 2101356.55662 | 37.7504799860819 | -122.40880059638901 | (37.7504799860819, -122.408800596389) | ||
| 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) | |||
| 79834 | 79834 | 45691 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 5 | 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) | |||
| 96700 | 96700 | 45695 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 9 | 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) |
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");