Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||||
| 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) | ||
| 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) | ||
| 86962 | 86962 | 114103 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 5 ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 89696 | 89696 | 111418 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 5 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 89930 | 89930 | 114515 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5997459.0 | 2105253.0 | 37.7604774702611 | -122.451890918585 | (37.7604774702611, -122.451890918585) | ||||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 92740 | 92740 | 35414 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 93415 | 93415 | 32851 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 752 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 6 | Permit Number 38103 | 6001544.36482173 | 2102066.64624639 | 37.7519616591584 | -122.437533360465 | (37.7519616591584, -122.437533360465) | |
| 93582 | 93582 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 415 Belvedere St | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998488.0 | 2106798.0 | 37.7647785355325 | -122.44844336243601 | (37.7647785355325, -122.448443362436) | ||||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 95842 | 95842 | 68127 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31877 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||
| 96178 | 96178 | 97500 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 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) | |||
| 96758 | 96758 | 114514 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5997459.0 | 2105253.0 | 37.7604774702611 | -122.451890918585 | (37.7604774702611, -122.451890918585) | ||||
| 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) | |||
| 97101 | 97101 | 58441 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 930 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17590 | 5999238.33920715 | 2106913.89639282 | 37.765139629896204 | -122.445856479597 | (37.7651396298962, -122.445856479597) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||||
| 98450 | 98450 | 39211 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3320 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40855 | 6006915.83116682 | 2102071.77265415 | 37.7522796651602 | -122.41895838053999 | (37.7522796651602, -122.41895838054) | ||||
| 98548 | 98548 | 43240 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 702 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43028 | 6002763.80049912 | 2109247.75150774 | 37.771748493450204 | -122.43382960559299 | (37.7717484934502, -122.433829605593) | ||
| 99373 | 99373 | 45698 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 7 | 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) | |||
| 99593 | 99593 | 45699 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 4 | 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) | |||
| 99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 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) | ||
| 100463 | 100463 | 45697 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 6 | 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) | |||
| 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) | ||
| 102146 | 102146 | 97502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 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) | |||
| 103750 | 103750 | 114102 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 103771 | 103771 | 111426 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 11 | Median : Yard 3 | Tree 1 | Private 1 | 6 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 103874 | 103874 | 37997 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 8 | 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) | |||
| 103965 | 103965 | 45702 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 3 | 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) | |||
| 104554 | 104554 | 38282 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 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) | |||
| 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) | |||||
| 105013 | 105013 | 38283 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 1 | 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) | |||
| 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) | |||
| 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) | ||
| 106233 | 106233 | 58432 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 826 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17579 | 5999154.89175324 | 2107511.77145677 | 37.7667764794344 | -122.44618811299601 | (37.7667764794344, -122.446188112996) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 108837 | 108837 | 37996 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 7 | 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) | |||
| 108928 | 108928 | 37989 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 10 | 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) | |||
| 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) | ||
| 109347 | 109347 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 839 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 109586 | 109586 | 92904 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 3 | 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) | ||||
| 109644 | 109644 | 37048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
| 111067 | 111067 | 97499 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 111573 | 111573 | 38271 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 3 | 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) | |||
| 111642 | 111642 | 37994 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 5 | 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) | |||
| 111867 | 111867 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
| 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) | ||
| 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) |
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");