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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91968 | 91968 | 37256 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 96040 | 96040 | 37259 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 96424 | 96424 | 37257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 98674 | 98674 | 37252 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 106559 | 106559 | 37255 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 114867 | 114867 | 37258 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 65846 | 65846 | 37203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.49062744276699 | (37.7578682946863, -122.490627442767) | |
| 138925 | 138925 | 37164 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3555 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39738 | 6006329.64997303 | 2100518.61882542 | 37.747982034538296 | -122.420875232711 | (37.7479820345383, -122.420875232711) | ||
| 25839 | 25839 | 36982 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 251 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39606 | 5993044.7391 | 2113780.4585 | 37.7836377719626 | -122.467777899893 | (37.7836377719626, -122.467777899893) | ||
| 32183 | 32183 | 36981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 251 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39606 | 5993043.99125 | 2113791.1250299998 | 37.783667016157295 | -122.46778126318199 | (37.7836670161573, -122.467781263182) | |
| 50348 | 50348 | 36156 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996550.482000001 | 2114121.4423 | 37.7847758271364 | -122.455674094114 | (37.7847758271364, -122.455674094114) | |
| 52188 | 52188 | 36155 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.1283 | 2114145.8086 | 37.784842652821496 | -122.45568053932399 | (37.7848426528215, -122.455680539324) | |
| 179791 | 179791 | 36154 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.8051 | 2114133.6254 | 37.7848092398389 | -122.45567731688699 | (37.7848092398389, -122.455677316887) | |
| 100306 | 100306 | 35775 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3523 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1998 12:00:00 AM | Permit Number 39031 | 6006108.80208441 | 2104899.31213539 | 37.7599979560694 | -122.421950059612 | (37.7599979560694, -122.421950059612) | ||
| 83522 | 83522 | 35726 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 102300 | 102300 | 35728 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 103792 | 103792 | 35727 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 143556 | 143556 | 35620 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 271 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38974 | 6005958.6690018 | 2115368.0219754 | 37.78873403898871 | -122.42321345725901 | (37.7887340389887, -122.423213457259) | |||
| 81286 | 81286 | 35152 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 265 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38683 | 6003463.92079467 | 2109118.95080504 | 37.7714345424169 | -122.431398649315 | (37.7714345424169, -122.431398649315) | ||
| 99490 | 99490 | 34781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1167 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.74978206863771 | -122.41482315731301 | (37.7497820686377, -122.414823157313) | ||
| 124245 | 124245 | 34780 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1167 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.74978206863771 | -122.41482315731301 | (37.7497820686377, -122.414823157313) | ||
| 87503 | 87503 | 34773 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1130 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38414 | 6008029.42163869 | 2101336.50490812 | 37.7503234289999 | -122.41505535764 | (37.7503234289999, -122.41505535764) | |
| 52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
| 61243 | 61243 | 34693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.43438045581301 | (37.799535058456, -122.434380455813) |
| 73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
| 133902 | 133902 | 34692 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) |
| 166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
| 176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
| 102595 | 102595 | 34533 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 395 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38241 | 6007729.86435225 | 2097252.7163141 | 37.7390934181522 | -122.415802113579 | (37.7390934181522, -122.415802113579) | |||
| 128169 | 128169 | 34516 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 23 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1997 12:00:00 AM | Permit Number 38227 | 6006103.90835028 | 2100218.50622556 | 37.747145266941295 | -122.42163452685101 | (37.7471452669413, -122.421634526851) | ||
| 124780 | 124780 | 34389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | ||
| 118589 | 118589 | 34242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.47512505139099 | (37.7643605962692, -122.475125051391) | |||
| 3706 | 3706 | 226704 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 18 | Width 4ft | Permit Number 38040 | 6007388.533559999 | 2107001.8580400003 | 37.7658431486538 | -122.41767310175399 | (37.7658431486538, -122.417673101754) | |
| 106599 | 106599 | 34227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 20 | Permit Number 38040 | 6007396.60708097 | 2107020.44544742 | 37.7658946396343 | -122.417646494621 | (37.7658946396343, -122.417646494621) | ||
| 46889 | 46889 | 34203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1911 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 9 | Permit Number 38022 | 6004270.98382 | 2118013.74533 | 37.7959031355868 | -122.42924133574199 | (37.7959031355868, -122.429241335742) | ||
| 93915 | 93915 | 34045 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 116161 | 116161 | 34044 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 80636 | 80636 | 33769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 95904 | 95904 | 33772 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||
| 99934 | 99934 | 33771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 124552 | 124552 | 33770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 97351 | 97351 | 33597 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 236 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/27/1996 12:00:00 AM | Permit Number 37705 | 6006736.00716085 | 2097819.44866051 | 37.7405936167848 | -122.41927861874399 | (37.7405936167848, -122.419278618744) | ||
| 155754 | 155754 | 33325 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.1795900003 | 37.8023080334521 | -122.42819334046301 | (37.8023080334521, -122.428193340463) | |
| 159755 | 159755 | 33285 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1537 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 6 | Permit Number 37447 | 6008380.6183400005 | 2117789.48589 | 37.795519168221205 | -122.415005295285 | (37.7955191682212, -122.415005295285) | |
| 140794 | 140794 | 33186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | ||
| 129831 | 129831 | 33112 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2628 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37349 | 6000339.44764 | 2118557.8977900003 | 37.7971738812189 | -122.44288425081601 | (37.7971738812189, -122.442884250816) | |
| 79610 | 79610 | 32821 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
| 103890 | 103890 | 32822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
| 75056 | 75056 | 32770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | |
| 76450 | 76450 | 32769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37143 | 6000722.0176 | 2110255.3136 | 37.7743989310052 | -122.440964540315 | (37.7743989310052, -122.440964540315) | |
| 140772 | 140772 | 32771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.774318351022295 | -122.440968898129 | (37.7743183510223, -122.440968898129) | ||
| 43637 | 43637 | 32540 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 58 Roscoe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 10 | Permit Number 37038 | 6006810.39067 | 2095478.8196900003 | 37.7341709570185 | -122.41885546740801 | (37.7341709570185, -122.418855467408) | |
| 38532 | 38532 | 32006 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1516 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1995 12:00:00 AM | 12 | 6x7 | Permit Number 35401 | 5993964.99651 | 2112129.18726 | 37.779156921599004 | -122.46447425023099 | (37.779156921599, -122.464474250231) | |
| 50340 | 50340 | 31871 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 120 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35312 | 5999385.97984 | 2107527.91309 | 37.766833994712 | -122.44538998147699 | (37.766833994712, -122.445389981477) | ||
| 144898 | 144898 | 31669 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | |||
| 48611 | 48611 | 31524 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 14 | Permit Number 35079 | 6011118.34556 | 2102149.1669400004 | 37.752727919775204 | -122.40443078876801 | (37.7527279197752, -122.404430788768) | |
| 136284 | 136284 | 31345 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 10 | Permit Number 34956 | 6006088.23081 | 2111255.80978 | 37.7774502243821 | -122.422472877923 | (37.7774502243821, -122.422472877923) | |
| 51284 | 51284 | 31133 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 212 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 12 | Permit Number 34848 | 5997464.63581 | 2094208.8725700001 | 37.7301533239181 | -122.451074988218 | (37.7301533239181, -122.451074988218) | |
| 134922 | 134922 | 31105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.3076400002 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | |
| 176161 | 176161 | 31106 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | |
| 146966 | 146966 | 30911 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34732 | 5994801.07425 | 2091932.47974 | 37.7237500448081 | -122.460118346802 | (37.7237500448081, -122.460118346802) | |
| 172576 | 172576 | 30910 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34732 | 5994801.3845 | 2091947.2904299998 | 37.723790729247 | -122.46011834680901 | (37.723790729247, -122.460118346809) | ||
| 146797 | 146797 | 66827 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1994 12:00:00 AM | 7 | 3x3 | Permit Number 33308 | 6009276.00847 | 2121806.9136099997 | 37.8066003024322 | -122.412191154694 | (37.8066003024322, -122.412191154694) | |
| 92448 | 92448 | 69203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33251 | 6008996.86818866 | 2101940.25932804 | 37.752035522179206 | -122.411752505652 | (37.7520355221792, -122.411752505652) | ||
| 19690 | 19690 | 69083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.761827789630104 | -122.470363712817 | (37.7618277896301, -122.470363712817) |
| 56944 | 56944 | 68985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1938 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32975 | 5999918.5445 | 2121272.0114700003 | 37.804602105955404 | -122.44453584225 | (37.8046021059554, -122.44453584225) | |
| 116895 | 116895 | 68983 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2377 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32973 | 5999960.55241622 | 2119841.40083737 | 37.800676429994205 | -122.444287600709 | (37.8006764299942, -122.444287600709) | ||
| 60821 | 60821 | 68981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2365 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 6 | Permit Number 32971 | 6000015.55575 | 2119854.08532 | 37.8007143961175 | -122.444098179086 | (37.8007143961175, -122.444098179086) | |
| 34470 | 34470 | 68922 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1255 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32906 | 6007550.61627 | 2118479.08218 | 37.7973659521424 | -122.417926160173 | (37.7973659521424, -122.417926160173) | |
| 56433 | 56433 | 68920 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1652 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32904 | 6008796.25541 | 2118594.60343 | 37.79775316962 | -122.41362408767598 | (37.79775316962, -122.413624087676) | |
| 73115 | 73115 | 68918 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1731 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 13 | Permit Number 32899 | 6009145.56642 | 2119236.5699 | 37.799535459556 | -122.412460772349 | (37.799535459556, -122.412460772349) | |
| 93483 | 93483 | 68881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | ||
| 93685 | 93685 | 61047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | ||
| 110734 | 110734 | 68862 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32825 | 5999105.31511453 | 2093467.13996107 | 37.7282104958197 | -122.445349657876 | (37.7282104958197, -122.445349657876) | ||
| 91213 | 91213 | 68860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.554712901 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | ||
| 78044 | 78044 | 68850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | ||
| 146015 | 146015 | 68829 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | ||
| 84112 | 84112 | 68819 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.44437438127702 | (37.729117226145, -122.444374381277) | ||
| 142205 | 142205 | 68799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32738 | 5992323.72089278 | 2098718.16784221 | 37.742239045272996 | -122.469175702533 | (37.742239045273, -122.469175702533) | ||
| 89336 | 89336 | 68787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.74477610705139 | -122.470428661516 | (37.7447761070514, -122.470428661516) | ||
| 97311 | 97311 | 68478 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32347 | 6010221.7563028 | 2103020.9810753996 | 37.755071582179 | -122.40759283260599 | (37.755071582179, -122.407592832606) | ||
| 154798 | 154798 | 68437 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.41366685765101 | (37.7752540178903, -122.413666857651) | ||
| 85009 | 85009 | 98240 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 800 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 143521 | 143521 | 67985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 212 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31709 | 5996176.45016211 | 2090576.83582112 | 37.7201067800111 | -122.455266009291 | (37.7201067800111, -122.455266009291) | ||
| 116061 | 116061 | 67902 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 115 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31604 | 5997414.89563577 | 2093860.91507447 | 37.7291950674434 | -122.451221861234 | (37.7291950674434, -122.451221861234) | ||
| 79967 | 79967 | 67901 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175004 | -122.45122163283001 | (37.729148458175, -122.45122163283) | ||
| 74427 | 74427 | 67860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.43439798360501 | (37.7992088356751, -122.434397983605) |
| 55092 | 55092 | 67785 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | 10 | Permit Number 31423 | 6002427.0992 | 2114351.4059 | 37.785742735875395 | -122.435359412958 | (37.7857427358754, -122.435359412958) | ||
| 54141 | 54141 | 67725 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1993 12:00:00 AM | Permit Number 31343 | 5992114.71357014 | 2106313.78524878 | 37.763082557956295 | -122.470451434039 | (37.7630825579563, -122.470451434039) | ||
| 73946 | 73946 | 67716 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 560 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 18 | 4x9 | Permit Number 31329 | 6014049.2852300005 | 2112210.3700599996 | 37.7805171185161 | -122.394999630825 | (37.7805171185161, -122.394999630825) |
| 171655 | 171655 | 67616 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1493 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 4 | Permit Number 31197 | 6002054.0075 | 2111526.4952 | 37.777965051221706 | -122.43644794433399 | (37.7779650512217, -122.436447944334) | |
| 42572 | 42572 | 67593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 357 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31160 | 6013799.73337 | 2105430.83352 | 37.7618881461485 | -122.395387878055 | (37.7618881461485, -122.395387878055) | |
| 164660 | 164660 | 67592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 355 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 8 | Permit Number 31159 | 6013796.23882 | 2105471.52113 | 37.7619996710595 | -122.39540281491199 | (37.7619996710595, -122.395402814912) | |
| 26969 | 26969 | 67564 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1015 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/2014 12:00:00 AM | 15 | Permit Number 31116 | 6011653.24401 | 2103633.28884 | 37.756832869857995 | -122.402685364734 | (37.756832869858, -122.402685364734) | |
| 96628 | 96628 | 67501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | ||
| 182678 | 182678 | 67465 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826001 | (37.7202991536555, -122.41105982826) | ||
| 158754 | 158754 | 67388 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 12 | Permit Number 30885 | 5990666.23465 | 2110099.72843 | 37.7733938754744 | -122.475737660544 | (37.7733938754744, -122.475737660544) | |
| 106790 | 106790 | 67341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2522 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30826 | 6011374.71716137 | 2101864.13092105 | 37.7519595969717 | -122.40352415267999 | (37.7519595969717, -122.40352415268) | ||
| 42836 | 42836 | 67278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.7324299999 | 37.7233423191649 | -122.42508335531001 | (37.7233423191649, -122.42508335531) | |
| 185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) |
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");