Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 108106 | 108106 | 34423 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47622 | 6003411.17015121 | 2096158.68200715 | 37.7358457184137 | -122.43065613991399 | (37.7358457184137, -122.430656139914) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 64784 | 64784 | 37497 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633000005 | -122.408090243478 | (37.790172633, -122.408090243478) | |
| 47937 | 47937 | 37498 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 10 | Permit Number 39964 | 6010355.28098 | 2115804.39021 | 37.790179340162794 | -122.40803252947201 | (37.7901793401628, -122.408032529472) | |
| 165028 | 165028 | 37499 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010316.35975 | 2115796.38999 | 37.790155194247 | -122.408166630084 | (37.790155194247, -122.408166630084) | |
| 52526 | 52526 | 37500 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 830 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39965 | 6009516.4157 | 2115739.5778900003 | 37.789954378345705 | -122.41093037085501 | (37.7899543783457, -122.410930370855) | |
| 141672 | 141672 | 37544 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 825 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | ||
| 139903 | 139903 | 37549 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | ||
| 104069 | 104069 | 37554 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4515#A 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1998 12:00:00 AM | Permit Number 39993 | 6000985.32111964 | 2105199.93654746 | 37.7605331136342 | -122.439691220259 | (37.7605331136342, -122.439691220259) | ||
| 104091 | 104091 | 37584 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40015 | 5999640.19520847 | 2104544.9581721 | 37.75865805116221 | -122.44429631061199 | (37.7586580511622, -122.444296310612) | ||
| 4819 | 4819 | 38523 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773138 | 6008768.83808 | 2118471.22766 | 37.7974128706661 | -122.41371022836 | (37.7974128706661, -122.41371022836) | |
| 70114 | 70114 | 38632 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 17 | 6x60 | Permit Number 767658 | 6014957.1802 | 2094111.5595 | 37.730872092312204 | -122.390593696874 | (37.7308720923122, -122.390593696874) |
| 179911 | 179911 | 38634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 16 | Permit Number 767658 | 6014976.9663 | 2094092.323 | 37.7308203704303 | -122.390523948894 | (37.7308203704303, -122.390523948894) | |
| 161810 | 161810 | 38641 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | 16 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931001 | (37.7308498822776, -122.39056651931) | |
| 114705 | 114705 | 39756 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 430 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/2002 12:00:00 AM | Permit Number 45959 | 6003532.62268975 | 2103345.12328431 | 37.755584896633295 | -122.430748907314 | (37.7555848966333, -122.430748907314) | ||
| 95774 | 95774 | 39881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.783063851701705 | -122.39458166928499 | (37.7830638517017, -122.394581669285) | ||
| 39400 | 39400 | 40056 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672354995 | -122.385451738871 | (37.727949672355, -122.385451738871) | |
| 106910 | 106910 | 40057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | ||
| 33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
| 76780 | 76780 | 40626 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | |
| 5410 | 5410 | 41173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3253 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779130 | 5999305.0198 | 2120031.7499700002 | 37.801161655947396 | -122.446569707626 | (37.8011616559474, -122.446569707626) | |
| 167171 | 167171 | 41176 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.193109999 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | |
| 155464 | 155464 | 41179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.9248200003 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | |
| 50486 | 50486 | 46971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | |
| 70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
| 10748 | 10748 | 47214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 570 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 6x4 | Permit Number 45165 | 6008824.68232 | 2093406.4927400001 | 37.728594004685895 | -122.41174501811301 | (37.7285940046859, -122.411745018113) |
| 174274 | 174274 | 47892 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 725 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2002 12:00:00 AM | 1 | Permit Number 45636 | 6000495.8068 | 2111504.9503 | 37.7778172299888 | -122.441836750591 | (37.7778172299888, -122.441836750591) | |
| 102900 | 102900 | 52416 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.43565196916799 | (37.717990874718, -122.435651969168) | ||
| 121146 | 121146 | 52481 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 338HOLLY PARK Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48591 | 6006994.57282255 | 2096259.62185295 | 37.7363252369186 | -122.418274030892 | (37.7363252369186, -122.418274030892) | ||
| 77052 | 77052 | 53446 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1145 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/1986 12:00:00 AM | 13 | Permit Number 23061 | 6007531.55063 | 2119171.09402 | 37.799264970461 | -122.418041215832 | (37.799264970461, -122.418041215832) | |
| 118858 | 118858 | 53804 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2960 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1987 12:00:00 AM | Permit Number 24179 | 6008473.78716926 | 2103911.87952165 | 37.757419787102705 | -122.413700845672 | (37.7574197871027, -122.413700845672) | ||
| 129161 | 129161 | 57576 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29580 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||
| 45665 | 45665 | 57616 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 455 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 11 | Permit Number 22179 | 6013266.46923 | 2104945.7243 | 37.7605264691381 | -122.397198223232 | (37.7605264691381, -122.397198223232) | |
| 103273 | 103273 | 57913 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 29 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1985 12:00:00 AM | Permit Number 16871 | 6006087.6140587 | 2100217.61014619 | 37.7471418876888 | -122.421690807656 | (37.7471418876888, -122.421690807656) | ||
| 75355 | 75355 | 57997 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 407 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 10 | Permit Number 22184 | 6013252.809230001 | 2105139.22095 | 37.761057008003796 | -122.397259036287 | (37.7610570080038, -122.397259036287) | |
| 88011 | 88011 | 58120 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 839 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 17101 | 6003847.07815842 | 2110734.06414103 | 37.7758909552538 | -122.430188532102 | (37.7758909552538, -122.430188532102) | ||
| 107291 | 107291 | 58390 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.44875969912201 | (37.7290972609549, -122.448759699122) | ||
| 143030 | 143030 | 59021 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 116 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1988 12:00:00 AM | Permit Number 25608 | 6005536.1099439 | 2104041.86258252 | 37.75761128554 | -122.423869755917 | (37.75761128554, -122.423869755917) | ||
| 57084 | 57084 | 59130 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 10 | Permit Number 18435 | 5992502.82437 | 2111669.37553 | 37.7778100081451 | -122.469498976775 | (37.7778100081451, -122.469498976775) | |
| 108911 | 108911 | 59184 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 226 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1988 12:00:00 AM | Permit Number 25686 | 6001313.09402132 | 2109464.81176347 | 37.7722620581627 | -122.43886323988701 | (37.7722620581627, -122.438863239887) | ||
| 124281 | 124281 | 59329 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602005 | 2103242.41669988 | 37.755619181383096 | -122.411337245149 | (37.7556191813831, -122.411337245149) | ||
| 20844 | 20844 | 59583 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4071 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18981 | 6002727.56027236 | 2101791.13153415 | 37.7512723603586 | -122.433422018052 | (37.7512723603586, -122.433422018052) | ||
| 169859 | 169859 | 60021 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 76 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 14 | Permit Number 19508 | 6014385.60562 | 2112720.25781 | 37.781935850286004 | -122.393871832437 | (37.781935850286, -122.393871832437) | |
| 141136 | 141136 | 60022 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 64 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | ||
| 27190 | 27190 | 60024 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 181 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 14 | Permit Number 19511 | 6014126.74175 | 2112333.046 | 37.7808582655241 | -122.394740263669 | (37.7808582655241, -122.394740263669) | |
| 145562 | 145562 | 60025 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 155 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.39444901599899 | (37.7813091831039, -122.394449015999) | ||
| 75453 | 75453 | 60026 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.094769999 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | |
| 50671 | 50671 | 60028 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 33 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | Permit Number 19516 | 6014481.96574 | 2112615.13715 | 37.7816525674538 | -122.393531108971 | (37.7816525674538, -122.393531108971) | |
| 68009 | 68009 | 60029 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 21 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.39331563861099 | (37.7818164104522, -122.393315638611) | |
| 112751 | 112751 | 60030 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 19 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19518 | 6014680.95467774 | 2112862.0838824 | 37.7823416816232 | -122.392859978153 | (37.7823416816232, -122.392859978153) | ||
| 26846 | 26846 | 60031 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19519 | 6014189.65421 | 2112531.72054 | 37.7814072782548 | -122.394536533027 | (37.7814072782548, -122.394536533027) | |
| 127629 | 127629 | 60032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004008999 | (37.7817828574395, -122.39203004009) | ||
| 57357 | 57357 | 60034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 108 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.8494700002 | 37.7815842801353 | -122.39431291753401 | (37.7815842801353, -122.394312917534) | |
| 171205 | 171205 | 60035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 15 | Permit Number 19524 | 6014295.81848 | 2112435.53684 | 37.7811490811156 | -122.39416251758101 | (37.7811490811156, -122.394162517581) | |
| 24070 | 24070 | 60036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 147 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 12 | Permit Number 19525 | 6014255.98068 | 2112398.36524 | 37.781044802010705 | -122.394297734267 | (37.7810448020107, -122.394297734267) | |
| 129943 | 129943 | 60037 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 84 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 13 | Permit Number 19526 | 6014370.64542 | 2112704.82281 | 37.7818926378878 | -122.393922507437 | (37.7818926378878, -122.393922507437) | |
| 61002 | 61002 | 60588 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 516 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 12 | Permit Number 20205 | 6000644.6678 | 2110770.9269 | 37.7758102690094 | -122.441269110246 | (37.7758102690094, -122.441269110246) | |
| 109542 | 109542 | 61040 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 237 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 20864 | 6003739.14918424 | 2109203.8264119998 | 37.771683184707996 | -122.430452677761 | (37.771683184708, -122.430452677761) | ||
| 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) |
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");