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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95218 | 95218 | 33847 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 98836 | 98836 | 33838 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 115034 | 115034 | 33841 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 124510 | 124510 | 33843 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 124554 | 124554 | 33846 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 5 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 141275 | 141275 | 33842 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 56286 | 56286 | 121708 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6014420.072369999 | 2103257.32043 | 37.7559546315195 | -122.393090266722 | (37.7559546315195, -122.393090266722) | ||||
| 164766 | 164766 | 200273 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014418.93045 | 2089354.50359 | 37.7177802911084 | -122.392121973844 | (37.7177802911084, -122.392121973844) | |||
| 183264 | 183264 | 121707 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6014418.633880001 | 2103271.30813 | 37.755992958831705 | -122.393096220215 | (37.7559929588317, -122.393096220215) | ||||
| 164690 | 164690 | 121706 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6014418.475869999 | 2103299.96349 | 37.7560716315206 | -122.39309877161199 | (37.7560716315206, -122.393098771612) | ||||
| 158352 | 158352 | 191549 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6014417.54899 | 2103314.9204700002 | 37.756112648686795 | -122.393103023604 | (37.7561126486868, -122.393103023604) | ||||
| 156641 | 156641 | 191548 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014408.452930001 | 2103463.35948 | 37.7565197250148 | -122.393144867255 | (37.7565197250148, -122.393144867255) | |||
| 49142 | 49142 | 200274 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014408.1626699995 | 2089360.68754 | 37.7177966731557 | -122.392159625791 | (37.7177966731557, -122.392159625791) | |||
| 132012 | 132012 | 191547 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014407.91394 | 2103482.91236 | 37.7565733830779 | -122.393148099399 | (37.7565733830779, -122.393148099399) | |||
| 58641 | 58641 | 191545 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014404.98086 | 2103545.7850599997 | 37.7567458550525 | -122.393162642344 | (37.7567458550525, -122.393162642344) | |||
| 166981 | 166981 | 191546 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014404.175 | 2103529.05124 | 37.756699862813605 | -122.39316425845101 | (37.7566998628136, -122.393164258451) | |||
| 76689 | 76689 | 191544 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014401.68997 | 2103590.98438 | 37.756869779843505 | -122.39317718618 | (37.7568697798435, -122.39317718618) | |||
| 32924 | 32924 | 191543 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014401.59884 | 2103605.63066 | 37.7569099903147 | -122.39317852616199 | (37.7569099903147, -122.393178526162) | |||
| 136647 | 136647 | 191541 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6014398.75245 | 2103666.33403 | 37.7570765105783 | -122.393192617642 | (37.7570765105783, -122.393192617642) | |||
| 36433 | 36433 | 191542 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014397.81138 | 2103651.61856 | 37.7570360527848 | -122.39319484257601 | (37.7570360527848, -122.393194842576) | |||
| 151644 | 151644 | 191540 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014391.69569 | 2103766.93922 | 37.757352358735 | -122.39322406245701 | (37.757352358735, -122.393224062457) | |||
| 149973 | 149973 | 191539 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014391.64166 | 2103776.7357 | 37.757379254757296 | -122.393224934809 | (37.7573792547573, -122.393224934809) | |||
| 62645 | 62645 | 191538 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014391.38122 | 2103788.79696 | 37.757412357910496 | -122.393226679488 | (37.7574123579105, -122.393226679488) | |||
| 64973 | 64973 | 72745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 630 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 8 | 6014368.47068 | 2104204.35874 | 37.758552128085796 | -122.39333499383001 | (37.7585521280858, -122.39333499383) | ||
| 30462 | 30462 | 58671 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 5 | Permit Number 17896 | 6014367.3263 | 2104224.98671 | 37.7586087044554 | -122.39334039516199 | (37.7586087044554, -122.393340395162) | |
| 149158 | 149158 | 191116 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6014365.71293 | 2103847.64812 | 37.7575725244821 | -122.39331956955 | (37.7575725244821, -122.39331956955) | |||
| 160723 | 160723 | 72759 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 7 | 6014364.38031 | 2104253.03754 | 37.7586855622993 | -122.393352546787 | (37.7586855622993, -122.393352546787) | ||
| 64112 | 64112 | 191115 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014343.6764 | 2103848.6809400003 | 37.757574136063 | -122.39339585366001 | (37.757574136063, -122.39339585366) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 119042 | 119042 | 92906 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 5 | 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) | ||||
| 120300 | 120300 | 92902 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 1 | 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) | ||||
| 24243 | 24243 | 191114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6014324.849769999 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | |||
| 157390 | 157390 | 191113 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014310.15926 | 2103847.10708 | 37.7575679523209 | -122.393511660254 | (37.7575679523209, -122.393511660254) | |||
| 74327 | 74327 | 38387 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 13 | Permit Number 40446 | 6014272.48503 | 2096672.22783 | 37.7378651543499 | -122.39313992457399 | (37.7378651543499, -122.393139924574) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 141126 | 141126 | 38270 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Texas 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) | |||
| 25396 | 25396 | 38266 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660X Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 10 | Permit Number 40367 | 6014098.11933 | 2104009.06988 | 37.7580008832593 | -122.394256324976 | (37.7580008832593, -122.394256324976) | ||
| 55096 | 55096 | 38272 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660X Mississippi St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 10 | Permit Number 40367 | 6014098.08793 | 2103987.31346 | 37.7579411430904 | -122.39425491036002 | (37.7579411430904, -122.39425491036) | ||
| 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) | ||||
| 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) | ||
| 123314 | 123314 | 117135 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 142845 | 142845 | 117134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 1144 | 1144 | 38281 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6014095.62624 | 2104027.41968 | 37.7580511292617 | -122.39426623192101 | (37.7580511292617, -122.394266231921) | ||
| 133382 | 133382 | 54592 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 329 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 13 | 7x6 | Permit Number 10415 | 6014074.3359 | 2105511.64681 | 37.7621253108683 | -122.394443787777 | (37.7621253108683, -122.394443787777) | |
| 41137 | 41137 | 191119 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014052.7163 | 2105909.00339 | 37.7632151632714 | -122.39454638782301 | (37.7632151632714, -122.394546387823) | |||
| 22993 | 22993 | 67532 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31070 | 6014045.342569999 | 2106049.86131 | 37.7636015183281 | -122.39458175543899 | (37.7636015183281, -122.394581755439) | |
| 176805 | 176805 | 57127 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 468 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 10 | Permit Number 18848 | 6014045.26968 | 2104987.99567 | 37.7606858631895 | -122.39450764863399 | (37.7606858631895, -122.394507648634) | ||
| 180779 | 180779 | 191121 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Mississippi St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014043.01019 | 2106106.8395700003 | 37.7637578384722 | -122.394593812648 | (37.7637578384722, -122.394593812648) | |||
| 67667 | 67667 | 191120 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014042.89853 | 2106078.3763099997 | 37.7636796783924 | -122.394592205568 | (37.7636796783924, -122.394592205568) | |||
| 178986 | 178986 | 191122 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 240 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6013995.5302099995 | 2105883.52142 | 37.7631420160238 | -122.394742392343 | (37.7631420160238, -122.394742392343) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 122586 | 122586 | 37995 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 6 | 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) | |||
| 142026 | 142026 | 37993 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 4 | 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) | |||
| 31816 | 31816 | 37984 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 528 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40206 | 6013786.428309999 | 2104612.00312 | 37.759639076609396 | -122.39537653041401 | (37.7596390766094, -122.395376530414) | |
| 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) | ||
| 146864 | 146864 | 30369 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1632 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1974 12:00:00 AM | 14 | Permit Number 14152 | 6013068.70069 | 2104759.9070200003 | 37.7600052436607 | -122.39786918403999 | (37.7600052436607, -122.39786918404) | ||
| 14627 | 14627 | 115035 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012851.17431 | 2112502.5973400003 | 37.781252811600794 | -122.39916500906601 | (37.7812528116008, -122.399165009066) | |||
| 167127 | 167127 | 115036 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012815.58198 | 2112468.56489 | 37.7811573827547 | -122.399285752038 | (37.7811573827547, -122.399285752038) | |||
| 150577 | 150577 | 191133 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 827 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012775.54197 | 2103646.6748599997 | 37.7569322215662 | -122.398804956499 | (37.7569322215662, -122.398804956499) | |||
| 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) | ||||
| 66678 | 66678 | 115037 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | |||
| 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) | |
| 93960 | 93960 | 32930 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 97451 | 97451 | 32933 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 106126 | 106126 | 32932 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 138407 | 138407 | 32931 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 143864 | 143864 | 32929 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 3x3 | Permit Number 40482 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | ||
| 43843 | 43843 | 55312 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1972 12:00:00 AM | 6 | Permit Number 11241 | 6012672.97117 | 2112433.28595 | 37.7810525658564 | -122.399776639786 | (37.7810525658564, -122.399776639786) | ||
| 77861 | 77861 | 45693 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 79834 | 79834 | 45691 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 96700 | 96700 | 45695 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 139810 | 139810 | 45701 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 2 | 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) | |||
| 141177 | 141177 | 45692 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 12 | 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) | |||
| 141853 | 141853 | 45694 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 10 | 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) | |||
| 143920 | 143920 | 45696 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 8 | 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) | |||
| 55261 | 55261 | 191511 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012652.226419999 | 2112454.21838 | 37.7811088850041 | -122.399849876973 | (37.7811088850041, -122.399849876973) | |||
| 59345 | 59345 | 191512 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012624.81518 | 2112484.97223 | 37.7811917997912 | -122.39994686706001 | (37.7811917997912, -122.39994686706) | |||
| 71250 | 71250 | 129745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012618.68817 | 2119711.1441 | 37.8010328208639 | -122.400475802435 | (37.8010328208639, -122.400475802435) | |||
| 55431 | 55431 | 129734 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 John Maher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012615.27565 | 2119730.0838 | 37.801084634405896 | -122.400488942433 | (37.8010846344059, -122.400488942433) | |||
| 50714 | 50714 | 191551 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6012610.52961 | 2106659.27433 | 37.7651949586997 | -122.399587143652 | (37.7651949586997, -122.399587143652) | |||
| 27635 | 27635 | 129744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012609.98453 | 2119710.6419 | 37.801030956563395 | -122.400505885653 | (37.8010309565634, -122.400505885653) | |||
| 70203 | 70203 | 129735 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 John Maher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012606.41703 | 2119728.02865 | 37.8010784974329 | -122.400519452825 | (37.8010784974329, -122.400519452825) | |||
| 39738 | 39738 | 191552 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012603.95366 | 2106732.49596 | 37.76539564241521 | -122.399615029827 | (37.7653956424152, -122.399615029827) |
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");