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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1513 | 1513 | 251580 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||
| 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 | ||||||||
| 9611 | 9611 | 138137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1790 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004447.4756 | 2114919.1759 | 37.7874162214119 | -122.42840996490801 | (37.7874162214119, -122.428409964908) | ||||
| 9703 | 9703 | 173646 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 380 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003542.0 | 2106028.0 | 37.7629519666094 | -122.43090793911999 | (37.7629519666094, -122.43090793912) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 78186 | 78186 | 106660 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x12 | 5993905.48812 | 2112097.55644 | 37.7790666413385 | -122.464677814993 | (37.7790666413385, -122.464677814993) | ||||
| 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) | ||||
| 78566 | 78566 | 41676 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
| 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) | ||
| 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) | ||
| 79048 | 79048 | 103163 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 79085 | 79085 | 37465 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 236 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39936 | 6010201.25104789 | 2099964.34261176 | 37.746677580306894 | -122.407448262702 | (37.7466775803069, -122.407448262702) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 80078 | 80078 | 38278 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Texas St | 6 | 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) | |||
| 80521 | 80521 | 42064 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3125 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/2001 12:00:00 AM | Permit Number 42374 | 6008884.76165611 | 2100531.31488982 | 37.7481605856471 | -122.412040626823 | (37.7481605856471, -122.412040626823) | ||
| 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) | ||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 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) | |||
| 81858 | 81858 | 62560 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22760 | 6002239.76573177 | 2109514.87514883 | 37.7724521979542 | -122.435661387293 | (37.7724521979542, -122.435661387293) | ||
| 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) | ||
| 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) | ||
| 82405 | 82405 | 92905 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 83467 | 83467 | 35415 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 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) | |||
| 84150 | 84150 | 107412 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1227 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997428.0 | 2105607.0 | 37.761447689258 | -122.452023673629 | (37.761447689258, -122.452023673629) | |||||
| 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) | ||
| 85236 | 85236 | 98351 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002759.0 | 2109307.0 | 37.7719109027838 | -122.43385044639999 | (37.7719109027838, -122.4338504464) | ||||
| 85482 | 85482 | 99765 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4300x 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 1192 Diamond St is true address | 6001940.4 | 2100620.7 | 37.748013943002704 | -122.436060356931 | (37.7480139430027, -122.436060356931) | |||
| 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) | |
| 85929 | 85929 | 32216 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 519 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | Permit Number 35537 | 6009462.41872105 | 2100262.21191199 | 37.747454081953 | -122.410024104812 | (37.747454081953, -122.410024104812) | ||
| 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) | ||
| 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) | ||
| 86218 | 86218 | 32079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3815 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35452 | 6004163.50427612 | 2105375.78416509 | 37.7611963327896 | -122.428711873399 | (37.7611963327896, -122.428711873399) | ||
| 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) | ||
| 86889 | 86889 | 111133 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 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) | ||
| 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) | ||
| 87632 | 87632 | 104648 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 833 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5997625.0 | 2107698.0 | 37.767200326764005 | -122.451493160886 | (37.767200326764, -122.451493160886) | ||||
| 87759 | 87759 | 37998 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 87792 | 87792 | 116765 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 598X EUREKA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001504.0 | 2102368.0 | 37.7527868092986 | -122.43769452795601 | (37.7527868092986, -122.437694527956) | ||||
| 88085 | 88085 | 35688 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38992 | 5994858.93773428 | 2095456.23739151 | 37.7334287567384 | -122.460173495672 | (37.7334287567384, -122.460173495672) | |||
| 88170 | 88170 | 121721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 89018 | 89018 | 38269 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Texas St | 2 | 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) | |||
| 89042 | 89042 | 34912 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 218 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 38515 | 6004873.60731086 | 2104005.13217632 | 37.7574730093691 | -122.426158345984 | (37.7574730093691, -122.426158345984) | ||
| 89073 | 89073 | 122499 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 396 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x5 | 6003831.0 | 2109101.0 | 37.7714060511358 | -122.43012762344401 | (37.7714060511358, -122.430127623444) | ||||
| 89390 | 89390 | 98349 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002759.0 | 2109307.0 | 37.7719109027838 | -122.43385044639999 | (37.7719109027838, -122.4338504464) | ||||
| 89778 | 89778 | 108937 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001019.9 | 2101294.0 | 37.749810325724 | -122.439291655065 | (37.749810325724, -122.439291655065) | ||||
| 89931 | 89931 | 32122 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 63 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35484 | 6003895.54546298 | 2106786.63464469 | 37.7650550206105 | -122.429739259442 | (37.7650550206105, -122.429739259442) | ||
| 89942 | 89942 | 92903 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 90996 | 90996 | 46310 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3812 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2002 12:00:00 AM | Permit Number 44565 | 6004204.87913613 | 2104845.75610024 | 37.759743343448704 | -122.42853099404199 | (37.7597433434487, -122.428530994042) | |||
| 91189 | 91189 | 37009 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1160 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 39623 | 6009190.78707009 | 2102400.91082818 | 37.753311244715704 | -122.41111443855101 | (37.7533112447157, -122.411114438551) | ||
| 91830 | 91830 | 41677 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4 Mars St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | ||
| 91835 | 91835 | 99325 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150@23rd Ave Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x6 | 5989403.0 | 2097682.0 | 37.73922479603689 | -122.479198759749 | (37.7392247960369, -122.479198759749) | ||||
| 91914 | 91914 | 44218 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43664 | 6000710.69184788 | 2110000.79371699 | 37.7736994385051 | -122.440985455094 | (37.7736994385051, -122.440985455094) |
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");