Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104879 | 104879 | 94466 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 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) |
| 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) | ||
| 10029 | 10029 | 94465 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 5x6 | Permit Number 779215 | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||
| 2858 | 2858 | 110567 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779053 | 6009356.33336 | 2110648.62955 | 37.77596687089571 | -122.411124487731 | (37.7759668708957, -122.411124487731) | ||
| 85299 | 85299 | 64872 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778656 | 6003401.65761863 | 2105041.71161228 | 37.760235902821606 | -122.43132292695499 | (37.7602359028216, -122.431322926955) | |
| 54783 | 54783 | 115038 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 HARRISON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777510 | 6012725.0 | 2112521.0 | 37.7812963087062 | -122.399602805279 | (37.7812963087062, -122.399602805279) | |
| 78472 | 78472 | 50627 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 220 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775476 | 6006133.43237108 | 2101871.95389636 | 37.7516869209791 | -122.42164985302 | (37.7516869209791, -122.42164985302) | |
| 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) |
| 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) | |
| 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) | |||
| 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) |
| 139257 | 139257 | 75814 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 300X Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | Permit Number 769917 | 6011998.05472036 | 2119270.81717993 | 37.7997891592695 | -122.402592490972 | (37.7997891592695, -122.402592490972) | |||
| 121451 | 121451 | 104586 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1402-1404 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769723 | 6007895.0 | 2107427.3 | 37.767039799886795 | -122.415951466126 | (37.7670397998868, -122.415951466126) | |||
| 84595 | 84595 | 102523 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 3X3 | Permit Number 769544 | 5992300.8 | 2100554.8 | 37.7472806432819 | -122.46938861272601 | (37.7472806432819, -122.469388612726) | ||
| 1597 | 1597 | 4669 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2014 12:00:00 AM | 8 | 3 | Permit Number 769286 | 6009537.0943 | 2119751.1708 | 37.8009703907309 | -122.411142309711 | (37.8009703907309, -122.411142309711) | |
| 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) | |
| 106403 | 106403 | 102105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2104 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 769122 | 6002645.0 | 2099438.0 | 37.7448065304391 | -122.43353937189501 | (37.7448065304391, -122.433539371895) | |||
| 90213 | 90213 | 100247 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
| 129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
| 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) | |
| 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) | |||
| 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) | |
| 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 | ||||||
| 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) | |
| 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) | |
| 168454 | 168454 | 96089 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1101 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767146 | 6012237.5036 | 2103271.25294 | 37.7558714019501 | -122.400639334242 | (37.7558714019501, -122.400639334242) | |
| 29061 | 29061 | 95316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870@Divisadero Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000971.60034 | 2116251.73043 | 37.7908777689321 | -122.44053135994899 | (37.7908777689321, -122.440531359949) | |
| 40292 | 40292 | 95320 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000942.23432 | 2116247.30101 | 37.790863934682 | -122.440632646973 | (37.790863934682, -122.440632646973) | |
| 43341 | 43341 | 95321 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000921.95955 | 2116245.56207 | 37.7908580054302 | -122.44070267179899 | (37.7908580054302, -122.440702671799) | |
| 92283 | 92283 | 95319 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 106400 | 106400 | 95318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 145248 | 145248 | 61069 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2011 12:00:00 AM | 3x3 | Permit Number 54089 | 6000057.45151415 | 2105676.05314863 | 37.7617875559763 | -122.442934478534 | (37.7617875559763, -122.442934478534) | ||
| 104470 | 104470 | 94209 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 465 Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013657.9 | 2104935.9 | 37.760521277448504 | -122.395843745126 | (37.7605212774485, -122.395843745126) | ||
| 106035 | 106035 | 94207 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 465 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013657.9 | 2104935.9 | 37.760521277448504 | -122.395843745126 | (37.7605212774485, -122.395843745126) | ||
| 106315 | 106315 | 94208 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 465 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013657.9 | 2104935.9 | 37.760521277448504 | -122.395843745126 | (37.7605212774485, -122.395843745126) | ||
| 103752 | 103752 | 88795 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51707 | 6003948.0 | 2099953.0 | 37.7462944444026 | -122.429070556888 | (37.7462944444026, -122.429070556888) | ||
| 108957 | 108957 | 88796 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51707 | 6003948.0 | 2099953.0 | 37.7462944444026 | -122.429070556888 | (37.7462944444026, -122.429070556888) | ||
| 79135 | 79135 | 88593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51537 | 6004415.0 | 2101011.0 | 37.7492258917596 | -122.427531088347 | (37.7492258917596, -122.427531088347) | ||
| 86940 | 86940 | 88592 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51537 | 6004415.0 | 2101011.0 | 37.7492258917596 | -122.427531088347 | (37.7492258917596, -122.427531088347) | ||
| 110021 | 110021 | 88360 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4969 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51338 | 5997573.8 | 2105584.6 | 37.761394534839894 | -122.451517798676 | (37.7613945348399, -122.451517798676) | |||
| 128515 | 128515 | 48660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1518 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51136 | 5993396.16596973 | 2105141.2714508 | 37.7599371524818 | -122.465934158818 | (37.7599371524818, -122.465934158818) | ||
| 94541 | 94541 | 33990 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50801 | 6001127.244268401 | 2105008.45413058 | 37.760015426682 | -122.43918664961201 | (37.760015426682, -122.439186649612) | ||
| 86153 | 86153 | 87312 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3125 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2008 12:00:00 AM | 3x3 | Permit Number 50319 | 6008903.7 | 2100376.9 | 37.747737659219496 | -122.41196422789899 | (37.7477376592195, -122.411964227899) | ||
| 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) | ||
| 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) | |||
| 112317 | 112317 | 85318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2007 12:00:00 AM | Permit Number 49596 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 94901 | 94901 | 53018 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 210@ SOLA AVE Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 48998 | 5994944.05105454 | 2100605.63053534 | 37.747572608877 | -122.460252192206 | (37.747572608877, -122.460252192206) | |||
| 92315 | 92315 | 52824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 301FERNWOOD Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48849 | 5994767.16572707 | 2095140.66542727 | 37.732556994280706 | -122.46046791665701 | (37.7325569942807, -122.460467916657) | ||||
| 126936 | 126936 | 52650 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1187@ RIVOLI Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | Permit Number 48734 | 5997369.46824352 | 2105989.04982963 | 37.7624933485057 | -122.452253677885 | (37.7624933485057, -122.452253677885) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 52181 | 52181 | 51643 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 47930 | 6003254.005 | 2113044.5364 | 37.7822013271565 | -122.432405181484 | (37.7822013271565, -122.432405181484) | ||
| 63843 | 63843 | 51639 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 1 | Permit Number 47930 | 6003279.6605 | 2112867.2804 | 37.7817160813577 | -122.432303761604 | (37.7817160813577, -122.432303761604) | ||
| 156910 | 156910 | 51645 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003273.8297 | 2112901.0989 | 37.7818086078686 | -122.43232634946399 | (37.7818086078686, -122.432326349464) | |||
| 158575 | 158575 | 51642 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.782268304126795 | -122.432423068554 | (37.7822683041268, -122.432423068554) | |||
| 159617 | 159617 | 51644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 47930 | 6003258.6697 | 2113006.0531 | 37.7820959261745 | -122.43238629430701 | (37.7820959261745, -122.432386294307) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 83053 | 83053 | 50193 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4981 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2003 12:00:00 AM | Permit Number 46899 | 5997529.52751085 | 2105596.18065646 | 37.761423797033 | -122.45167175336901 | (37.761423797033, -122.451671753369) | |||
| 174514 | 174514 | 49395 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483BRODERICK Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 6 | Permit Number 46348 | 6000704.8967 | 2114113.6763 | 37.7849920360606 | -122.44130066560699 | (37.7849920360606, -122.441300665607) | ||
| 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) | |
| 103098 | 103098 | 39262 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2641 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2002 12:00:00 AM | Permit Number 45224 | 6010322.84721614 | 2104547.72177646 | 37.7592693288078 | -122.407350854298 | (37.7592693288078, -122.407350854298) | |||
| 168505 | 168505 | 46656 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 6 | Permit Number 44787 | 5989986.8778099995 | 2113120.4528799998 | 37.781648539642404 | -122.47830854187 | (37.7816485396424, -122.47830854187) | |
| 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) | |||
| 97453 | 97453 | 46531 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 881PERMIT) Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.44779578842699 | (37.765484436098, -122.447795788427) |
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");