Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1244 | 1244 | 251333 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1245 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007705.967209999 | 2102462.31706 | 37.7533964721949 | -122.41625361541901 | (37.7533964721949, -122.416253615419) | |
| 1254 | 1254 | 156622 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1245 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007708.675369999 | 2102405.4758099997 | 37.75324055131961 | -122.416240224501 | (37.7532405513196, -122.416240224501) | |
| 1256 | 1256 | 242003 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 920 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007974.01021 | 2102435.99237 | 37.7533392591026 | -122.415324800104 | (37.7533392591026, -122.415324800104) | |
| 1260 | 1260 | 166073 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 920X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731.0 | 2102403.0 | 37.753235008598104 | -122.416162845847 | (37.7532350085981, -122.416162845847) | |
| 1269 | 1269 | 251332 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 920X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731.0 | 2102403.0 | 37.753235008598104 | -122.416162845847 | (37.7532350085981, -122.416162845847) | |
| 1349 | 1349 | 20251 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1880 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002540.9652 | 2114632.1752 | 37.786520122821 | -122.43498555674299 | (37.786520122821, -122.434985556743) | |||
| 1350 | 1350 | 19971 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 100 STAIRWAY44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 7120 | 7120 | 20249 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 1880 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2000 12:00:00 AM | 10 | 3X3 | 6002546.9119 | 2114591.5393 | 37.786408884633495 | -122.43496207541 | (37.7864088846335, -122.43496207541) | ||
| 9886 | 9886 | 173724 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1101 Connecticut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9892 | 9892 | 173723 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1799x 25th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9899 | 9899 | 173720 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1799x 25th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 11691 | 11691 | 20077 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 100 STAIRWAY55 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 14644 | 14644 | 19820 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 100 STAIRWAY25 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10ST | ||||||||
| 15793 | 15793 | 19714 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 100 STAIRWAY13 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 16951 | 16951 | 30683 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 425 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2014 12:00:00 AM | 3 | Permit Number 772924 | 6004598.67244 | 2110025.49511 | 37.773987938825 | -122.42753808091999 | (37.773987938825, -122.42753808092) | |
| 17050 | 17050 | 19973 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 100 STAIRWAY44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 36 | ||||||||
| 17548 | 17548 | 5505 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 785 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6X8 | 6005062.26258 | 2103781.17825 | 37.756868745618 | -122.425489962193 | (37.756868745618, -122.425489962193) | |||
| 19104 | 19104 | 40879 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 38 Washburn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | Permit Number 41789 | 6008346.99191908 | 2110451.53839796 | 37.775369049965 | -122.41460212413901 | (37.775369049965, -122.414602124139) | |||
| 19604 | 19604 | 55409 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 872 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/1987 12:00:00 AM | Permit Number 11349 | 6003719.33886967 | 2103195.40450941 | 37.755184381069604 | -122.43009250455098 | (37.7551843810696, -122.430092504551) | ||
| 20383 | 20383 | 40812 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 240 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.46211448137501 | (37.732473059968, -122.462114481375) | |||
| 20447 | 20447 | 4362 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 951 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001187.63557 | 2096055.6313599998 | 37.735436544167705 | -122.438336378342 | (37.7354365441677, -122.438336378342) | |||
| 20890 | 20890 | 29613 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900X Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.63654 | 2090933.6499400001 | 37.7207977908582 | -122.47260907386499 | (37.7207977908582, -122.472609073865) | ||
| 21158 | 21158 | 29596 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991179.03639 | 2091124.89815 | 37.7213236289735 | -122.47258014806299 | (37.7213236289735, -122.472580148063) | ||
| 21171 | 21171 | 30684 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 425 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2014 12:00:00 AM | 3 | Permit Number 772924 | 6004595.56145 | 2110044.99198 | 37.7740412965118 | -122.427550231668 | (37.7740412965118, -122.427550231668) | |
| 21722 | 21722 | 29610 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900X Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991173.75038 | 2091017.4965400002 | 37.7210284247022 | -122.47259059367501 | (37.7210284247022, -122.472590593675) | ||
| 23527 | 23527 | 136378 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1 Nob Hill Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009539.87257 | 2116302.4428 | 37.7915011843851 | -122.410888982239 | (37.7915011843851, -122.410888982239) | |||
| 23532 | 23532 | 214160 | Undocumented 2 | Schinus molle :: California Pepper 138 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5999436.944209999 | 2094022.0937400002 | 37.729753194848705 | -122.44424306977 | (37.7297531948487, -122.44424306977) | |||
| 23913 | 23913 | 239636 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3691 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003794.28038 | 2103601.33494 | 37.7563032141343 | -122.429862287926 | (37.7563032141343, -122.429862287926) | |||
| 23972 | 23972 | 239643 | Undocumented 2 | Schinus molle :: California Pepper 138 | 37 Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003364.63638 | 2105630.60252 | 37.761850757720794 | -122.431493007021 | (37.7618507577208, -122.431493007021) | |||
| 24228 | 24228 | 197487 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1301 Minnesota St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6015378.84744 | 2102468.94598 | 37.75384313667529 | -122.389719416144 | (37.7538431366753, -122.389719416144) | ||||
| 24316 | 24316 | 239651 | Undocumented 2 | Schinus molle :: California Pepper 138 | 767 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002456.2179 | 2103744.6121099996 | 37.7566207539655 | -122.434500008976 | (37.7566207539655, -122.434500008976) | |||
| 24932 | 24932 | 239603 | Undocumented 2 | Schinus molle :: California Pepper 138 | 890 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002439.95737 | 2103017.51215 | 37.7546233884599 | -122.434504257392 | (37.7546233884599, -122.434504257392) | |||
| 25336 | 25336 | 197493 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 950x Kansas St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6011595.701219999 | 2103803.27065 | 37.7572963894245 | -122.402896325021 | (37.7572963894245, -122.402896325021) | ||||
| 25553 | 25553 | 197502 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1799 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6013459.5308300005 | 2101928.68892 | 37.752253090306 | -122.396319040597 | (37.752253090306, -122.396319040597) | |||
| 26132 | 26132 | 136381 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1023 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6008695.6423 | 2118278.0740799997 | 37.7968784080765 | -122.413949834731 | (37.7968784080765, -122.413949834731) | |||
| 27313 | 27313 | 247224 | Undocumented 2 | Schinus molle :: California Pepper 138 | 135 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6001887.60725 | 2108459.11842 | 37.7695333431173 | -122.436803945272 | (37.7695333431173, -122.436803945272) | |||
| 27500 | 27500 | 239639 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3615 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004229.581119999 | 2103632.14382 | 37.7564124493922 | -122.428359063024 | (37.7564124493922, -122.428359063024) | |||
| 28255 | 28255 | 239573 | Undocumented 2 | Schinus molle :: California Pepper 138 | 282 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6004076.80225 | 2099571.54345 | 37.745254343115796 | -122.428597987734 | (37.7452543431158, -122.428597987734) | |||
| 28865 | 28865 | 70594 | Undocumented 2 | Schinus molle :: California Pepper 138 | 342 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 16 | 6004127.796159999 | 2091299.57805 | 37.722544276969295 | -122.42783235888201 | (37.7225442769693, -122.427832358882) | ||
| 29879 | 29879 | 97159 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.6057400005 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | ||
| 30395 | 30395 | 214169 | Undocumented 2 | Schinus molle :: California Pepper 138 | 266 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000318.857009999 | 2094968.44865 | 37.7324019411004 | -122.441262082491 | (37.7324019411004, -122.441262082491) | |||
| 30420 | 30420 | 49747 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1266 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46546 | 6011753.83246 | 2088984.50512 | 37.716616016203496 | -122.401308097113 | (37.7166160162035, -122.401308097113) | |
| 31896 | 31896 | 214157 | Undocumented 2 | Schinus molle :: California Pepper 138 | 100 Vista Verde Ct | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 10ft | 5999199.91271 | 2096059.32177 | 37.7353334179866 | -122.445208921854 | (37.7353334179866, -122.445208921854) | |||
| 32631 | 32631 | 197500 | Undocumented 2 | Schinus molle :: California Pepper 138 | 651 Missouri St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013593.70141 | 2104032.4139 | 37.7580369298728 | -122.39600246484301 | (37.7580369298728, -122.396002464843) | ||||
| 33029 | 33029 | 217740 | Undocumented 2 | Schinus molle :: California Pepper 138 | 689 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5996243.38999 | 2107249.5260400004 | 37.7658897191639 | -122.456239488074 | (37.7658897191639, -122.456239488074) | |||
| 33328 | 33328 | 136373 | Undocumented 2 | Schinus molle :: California Pepper 138 | 2858 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999883.3367800005 | 2117451.31751 | 37.7941094908262 | -122.444382936819 | (37.7941094908262, -122.444382936819) | |||
| 33439 | 33439 | 217735 | Undocumented 2 | Schinus molle :: California Pepper 138 | 723 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5996116.65034 | 2107229.99676 | 37.7658288206775 | -122.456676438985 | (37.7658288206775, -122.456676438985) | |||
| 33746 | 33746 | 239587 | Undocumented 2 | Schinus molle :: California Pepper 138 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.41750500495701 | (37.7430230396951, -122.417505004957) | |||
| 34197 | 34197 | 239631 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3946 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003468.88792 | 2102461.3534 | 37.75315466247989 | -122.43090625244899 | (37.7531546624799, -122.430906252449) | |||
| 35897 | 35897 | 239632 | Undocumented 2 | Schinus molle :: California Pepper 138 | 87 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004121.656359999 | 2102563.78903 | 37.7534728911634 | -122.428656150459 | (37.7534728911634, -122.428656150459) | |||
| 36509 | 36509 | 239608 | Undocumented 2 | Schinus molle :: California Pepper 138 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007254.62958 | 2098290.95874 | 37.7419174734269 | -122.417518826646 | (37.7419174734269, -122.417518826646) | |||
| 36825 | 36825 | 245452 | Undocumented 2 | Schinus molle :: California Pepper 138 | 2700 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008618.5823 | 2106848.9813 | 37.765492525027206 | -122.413407794567 | (37.7654925250272, -122.413407794567) | |||
| 37123 | 37123 | 239607 | Undocumented 2 | Schinus molle :: California Pepper 138 | 189 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007238.5342 | 2097885.55109 | 37.7408034085529 | -122.417545753258 | (37.7408034085529, -122.417545753258) | |||
| 37513 | 37513 | 214166 | Undocumented 2 | Schinus molle :: California Pepper 138 | 25 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5996590.09341 | 2093838.6494 | 37.729086671304 | -122.45407164889099 | (37.729086671304, -122.454071648891) | |||
| 38382 | 38382 | 239566 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6006878.39898 | 2100850.62787 | 37.748924571708 | -122.41900122234101 | (37.748924571708, -122.419001222341) | |||
| 39151 | 39151 | 239593 | Undocumented 2 | Schinus molle :: California Pepper 138 | 636 Douglass St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6001191.36102 | 2102681.5885900003 | 37.753630066583206 | -122.438798157734 | (37.7536300665832, -122.438798157734) | |||
| 39212 | 39212 | 239650 | Undocumented 2 | Schinus molle :: California Pepper 138 | 771 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002455.69585 | 2103719.3604200003 | 37.7565513892455 | -122.43450000896601 | (37.7565513892455, -122.434500008966) | |||
| 39717 | 39717 | 138851 | Undocumented 2 | Schinus molle :: California Pepper 138 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004934.5518 | 2110939.3444 | 37.7765161381936 | -122.426441298216 | (37.7765161381936, -122.426441298216) | |||
| 40727 | 40727 | 239577 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3961 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004128.58692 | 2100700.88045 | 37.7483581715004 | -122.428499407621 | (37.7483581715004, -122.428499407621) | |||
| 40901 | 40901 | 197495 | Undocumented 2 | Schinus molle :: California Pepper 138 | 651 Missouri St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013600.82032 | 2103923.07952 | 37.757737117488 | -122.39597018278 | (37.757737117488, -122.39597018278) | ||||
| 41201 | 41201 | 239588 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1245 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007705.967209999 | 2102462.31706 | 37.7533964721949 | -122.41625361541901 | (37.7533964721949, -122.416253615419) | |||
| 41679 | 41679 | 50158 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1863@ ORTEGA 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | 4 | Permit Number 46871 | 5985958.4054 | 2102559.7986 | 37.7524172606528 | -122.491467392102 | (37.7524172606528, -122.491467392102) | ||
| 42057 | 42057 | 239606 | Undocumented 2 | Schinus molle :: California Pepper 138 | 179 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997457.76068 | 2107065.24918 | 37.7654533761877 | -122.452025957451 | (37.7654533761877, -122.452025957451) | |||
| 42854 | 42854 | 136368 | Undocumented 2 | Schinus molle :: California Pepper 138 | 2945 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000986.416069999 | 2118529.18744 | 37.797131913463 | -122.44064352427601 | (37.797131913463, -122.440643524276) | |||
| 42973 | 42973 | 32952 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 673X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554.0 | 2103938.0 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | |||
| 43312 | 43312 | 197492 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1501 25th St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6014180.0421 | 2101964.05724 | 37.7523902711102 | -122.393829855665 | (37.7523902711102, -122.393829855665) | ||||
| 43881 | 43881 | 214165 | Undocumented 2 | Schinus molle :: California Pepper 138 | 428 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5996451.80809 | 2106977.8264900004 | 37.7651556637169 | -122.455498978198 | (37.7651556637169, -122.455498978198) | |||
| 43931 | 43931 | 142226 | Undocumented 2 | Schinus molle :: California Pepper 138 | 542 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004780.8856 | 2110726.6251 | 37.77592337522171 | -122.426957720143 | (37.7759233752217, -122.426957720143) | |||
| 44428 | 44428 | 117357 | Undocumented 2 | Schinus molle :: California Pepper 138 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6004937.66325 | 2110937.7592700003 | 37.776511961701296 | -122.42643042192101 | (37.7765119617013, -122.426430421921) | |||
| 44834 | 44834 | 33144 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 4238 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.755569316923705 | -122.438212219782 | (37.7555693169237, -122.438212219782) | |||
| 45199 | 45199 | 239570 | Undocumented 2 | Schinus molle :: California Pepper 138 | 540 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003051.59742 | 2098931.52845 | 37.7434389383601 | -122.432097274966 | (37.7434389383601, -122.432097274966) | |||
| 45267 | 45267 | 239617 | Undocumented 2 | Schinus molle :: California Pepper 138 | 998 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009142.86586 | 2103412.7293599998 | 37.756086783293 | -122.411351634886 | (37.756086783293, -122.411351634886) | |||
| 45788 | 45788 | 239646 | Undocumented 2 | Schinus molle :: California Pepper 138 | 211 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004207.2629 | 2104504.88213 | 37.7588075193625 | -122.428498452559 | (37.7588075193625, -122.428498452559) | |||
| 45914 | 45914 | 32430 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 36 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | 16 | Permit Number 36957 | 6002798.58811 | 2093563.75666 | 37.7286859198974 | -122.43258877877301 | (37.7286859198974, -122.432588778773) | ||
| 46227 | 46227 | 244226 | Undocumented 2 | Schinus molle :: California Pepper 138 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003259.6765 | 2109534.4722 | 37.7725638844758 | -122.432134818626 | (37.7725638844758, -122.432134818626) | |||
| 47417 | 47417 | 214167 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993435.6717300005 | 2102452.28847 | 37.752556179832396 | -122.465602172524 | (37.7525561798324, -122.465602172524) | |||
| 47877 | 47877 | 214164 | Undocumented 2 | Schinus molle :: California Pepper 138 | 900 Junipero Serra Blvd | 99 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991142.149230001 | 2090504.7144400002 | 37.7196186222819 | -122.47266246032 | (37.7196186222819, -122.47266246032) | |||
| 48030 | 48030 | 247658 | Undocumented 2 | Schinus molle :: California Pepper 138 | 129 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001895.26535 | 2108435.04385 | 37.76946767553439 | -122.436775732636 | (37.7694676755344, -122.436775732636) | |||
| 48346 | 48346 | 239652 | Undocumented 2 | Schinus molle :: California Pepper 138 | 759 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002456.72459 | 2103769.1209400003 | 37.7566880780974 | -122.434500008993 | (37.7566880780974, -122.434500008993) | |||
| 48863 | 48863 | 49624 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 180 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | 8 | Permit Number 46480 | 6007909.99126 | 2109730.21129 | 37.7733638956484 | -122.41606272084199 | (37.7733638956484, -122.416062720842) | |
| 48914 | 48914 | 136376 | Undocumented 2 | Schinus molle :: California Pepper 138 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | |||
| 49367 | 49367 | 214153 | Undocumented 2 | Schinus molle :: California Pepper 138 | 391 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5992476.6794300005 | 2094212.83068 | 37.729877357943394 | -122.46831913413999 | (37.7298773579434, -122.46831913414) | |||
| 49536 | 49536 | 239630 | Undocumented 2 | Schinus molle :: California Pepper 138 | 431 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 3ft | 6003562.89343 | 2102710.70444 | 37.753844647533604 | -122.430598954102 | (37.7538446475336, -122.430598954102) | |||
| 50400 | 50400 | 239580 | Undocumented 2 | Schinus molle :: California Pepper 138 | 4019 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6003715.87137 | 2100677.69284 | 37.748271139596 | -122.429924914027 | (37.748271139596, -122.429924914027) | |||
| 50609 | 50609 | 239578 | Undocumented 2 | Schinus molle :: California Pepper 138 | 4092 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6003302.876630001 | 2100696.16376 | 37.748298459202296 | -122.43135435584401 | (37.7482984592023, -122.431354355844) | |||
| 50705 | 50705 | 247657 | Undocumented 2 | Schinus molle :: California Pepper 138 | 165 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6001871.68544 | 2108600.41157 | 37.769920394235704 | -122.43686913440901 | (37.7699203942357, -122.436869134409) | |||
| 50787 | 50787 | 239625 | Undocumented 2 | Schinus molle :: California Pepper 138 | 811 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002472.06672 | 2103464.35538 | 37.7558521357906 | -122.434425161094 | (37.7558521357906, -122.434425161094) | |||
| 51154 | 51154 | 239601 | Undocumented 2 | Schinus molle :: California Pepper 138 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001018.49265 | 2103293.22516 | 37.7552996363918 | -122.439439814104 | (37.7552996363918, -122.439439814104) | |||
| 51209 | 51209 | 239599 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1627 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003378.62695 | 2098678.67199 | 37.7427631886738 | -122.43094844770901 | (37.7427631886738, -122.430948447709) | |||
| 51542 | 51542 | 136372 | Undocumented 2 | Schinus molle :: California Pepper 138 | 2005 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5999418.04323 | 2115732.63691 | 37.7893638888782 | -122.445869229291 | (37.7893638888782, -122.445869229291) | |||
| 51867 | 51867 | 239653 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3512 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6004899.76423 | 2103707.095 | 37.7566561476773 | -122.42604666863501 | (37.7566561476773, -122.426046668635) | |||
| 52026 | 52026 | 239594 | Undocumented 2 | Schinus molle :: California Pepper 138 | 636 Douglass St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6001191.4238 | 2102669.11785 | 37.753595828508395 | -122.43879704705 | (37.7535958285084, -122.43879704705) | |||
| 52314 | 52314 | 239657 | Undocumented 2 | Schinus molle :: California Pepper 138 | 671 Church St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004329.6886 | 2104859.6882 | 37.7597886599416 | -122.428100332557 | (37.7597886599416, -122.428100332557) | |||
| 52448 | 52448 | 124365 | Undocumented 2 | Schinus molle :: California Pepper 138 | 69 Palm Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5995847.941980001 | 2114000.61223 | 37.7844037185844 | -122.458095888318 | (37.7844037185844, -122.458095888318) | |||
| 55044 | 55044 | 239637 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3691 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003808.38299 | 2103603.27195 | 37.7563093313217 | -122.429813654389 | (37.7563093313217, -122.429813654389) | |||
| 55131 | 55131 | 35756 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 6838 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1998 12:00:00 AM | 8 | Permit Number 39022 | 5985797.58958 | 2112563.51135 | 37.7798752557854 | -122.492760252761 | (37.7798752557854, -122.492760252761) | ||
| 55151 | 55151 | 179424 | Undocumented 2 | Schinus molle :: California Pepper 138 | 363 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6005844.59075 | 2092020.24805 | 37.7246200507507 | -122.421948945488 | (37.7246200507507, -122.421948945488) | |||
| 55788 | 55788 | 239592 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1643 Diamond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6002072.60016 | 2099184.21674 | 37.744077207902606 | -122.435500467872 | (37.7440772079026, -122.435500467872) | |||
| 55841 | 55841 | 35755 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 6838 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1998 12:00:00 AM | 7 | Permit Number 39022 | 5985827.9768199995 | 2112563.40957 | 37.7798767531698 | -122.49265512383002 | (37.7798767531698, -122.49265512383) | ||
| 56388 | 56388 | 239662 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1128 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002485.47315 | 2102221.41113 | 37.75244006837129 | -122.434289939928 | (37.7524400683713, -122.434289939928) |
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");