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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 2240 | 2240 | 122755 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.40411744427601 | (37.7615439863765, -122.404117444276) | |||
| 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) | |
| 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) | |
| 7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
| 8115 | 8115 | 12319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | |||
| 10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
| 17867 | 17867 | 98680 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 19677 | 19677 | 55532 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | |||
| 20291 | 20291 | 61846 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | ||
| 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) | ||
| 23320 | 23320 | 6751 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.5380000002 | 37.738173145164104 | -122.38185469014499 | (37.7381731451641, -122.381854690145) | |||
| 23365 | 23365 | 5074 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 5593 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 3 | 6001579.88731 | 2097086.51396 | 37.73828941133 | -122.43705400175699 | (37.73828941133, -122.437054001757) | |||
| 24017 | 24017 | 65613 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 743 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 18 | Permit Number 28520 | 6001843.34769 | 2089618.0611400001 | 37.71779771097221 | -122.43560893330299 | (37.7177977109722, -122.435608933303) | |
| 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) | |
| 24146 | 24146 | 42768 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146000001 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | ||
| 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) | ||
| 25947 | 25947 | 62018 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1985 12:00:00 AM | 7 | Permit Number 22090 | 5999587.6363 | 2114469.4142 | 37.785905091635605 | -122.44519160183201 | (37.7859050916356, -122.445191601832) | ||
| 26110 | 26110 | 64561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1542 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 10 | Permit Number 25452 | 6000444.413 | 2110313.5657 | 37.774543061584794 | -122.441929006028 | (37.7745430615848, -122.441929006028) | |
| 26516 | 26516 | 64472 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1970 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 5 | Permit Number 25343 | 5999749.3718 | 2111255.5704 | 37.777089935824996 | -122.44440099324899 | (37.777089935825, -122.444400993249) | ||
| 26705 | 26705 | 59243 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 844 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1980 12:00:00 AM | 13 | Permit Number 18574 | 5992945.970290001 | 2110731.04138 | 37.7752591962743 | -122.467897727976 | (37.7752591962743, -122.467897727976) | ||
| 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) | |
| 26884 | 26884 | 54531 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | ||
| 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) | |
| 27045 | 27045 | 72016 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | ||
| 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) | |
| 28383 | 28383 | 49433 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 364@ KEARNY Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 8 | Permit Number 46371 | 6011642.68179 | 2116034.05853 | 37.7908819508039 | -122.403594362585 | (37.7908819508039, -122.403594362585) | ||
| 28719 | 28719 | 65929 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 35 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28948 | 5995849.4697199995 | 2114245.46982 | 37.7850761197315 | -122.45810832997 | (37.7850761197315, -122.45810832997) | |
| 30079 | 30079 | 65628 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1330 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 12 | Permit Number 28536 | 5999777.227000001 | 2113475.6396 | 37.783187264222796 | -122.44446422560301 | (37.7831872642228, -122.444464225603) | |
| 31990 | 31990 | 59227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 801 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1980 12:00:00 AM | 8 | Permit Number 18548 | 5993132.18227 | 2110683.6114 | 37.7751397174352 | -122.467250134298 | (37.7751397174352, -122.467250134298) | ||
| 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) | |
| 32186 | 32186 | 73447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 5 | 6007557.7828 | 2115066.68598 | 37.787996759296796 | -122.417659373585 | (37.7879967592968, -122.417659373585) | ||
| 33362 | 33362 | 55257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.48421806494801 | (37.7741363990758, -122.484218064948) | ||
| 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) | |
| 34069 | 34069 | 61665 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 9 | Permit Number 21661 | 5992088.12386 | 2114525.07918 | 37.78562701181829 | -122.47114165946199 | (37.7856270118183, -122.471141659462) | |
| 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) | |
| 34553 | 34553 | 71312 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2015 12:00:00 AM | 13 | 6000471.9495 | 2110316.0552 | 37.7745514662119 | -122.44183393088998 | (37.7745514662119, -122.44183393089) | ||
| 35039 | 35039 | 65901 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 180 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1990 12:00:00 AM | 11 | Permit Number 28908 | 5995949.76859 | 2113077.47191 | 37.7818748717492 | -122.457676787407 | (37.7818748717492, -122.457676787407) | |
| 36676 | 36676 | 65829 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 9 | Permit Number 28819 | 6000416.29807 | 2119955.15085 | 37.8010147480994 | -122.442718709912 | (37.8010147480994, -122.442718709912) | |
| 37738 | 37738 | 62093 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 421 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 12 | Permit Number 22182 | 6013256.61588 | 2105083.54347 | 37.760904341792 | -122.397241966241 | (37.760904341792, -122.397241966241) | |
| 38218 | 38218 | 71535 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1995 12:00:00 AM | 6 | 6007520.46607 | 2118819.9604700003 | 37.7983002218264 | -122.41805466610201 | (37.7983002218264, -122.418054666102) | ||
| 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) | |
| 41312 | 41312 | 49432 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 364@ KEARNY Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 7 | Permit Number 46371 | 6011662.833319999 | 2116037.23111 | 37.7908917875712 | -122.403524862095 | (37.7908917875712, -122.403524862095) | ||
| 41459 | 41459 | 61346 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2966 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1984 12:00:00 AM | 5 | Permit Number 21251 | 5999326.7118 | 2114325.9429 | 37.785496260071504 | -122.44608400180599 | (37.7854962600715, -122.446084001806) | ||
| 41938 | 41938 | 62597 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.49730988283301 | (37.7744677278845, -122.497309882833) | |
| 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) | |
| 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) | |
| 42965 | 42965 | 61941 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 178 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | Permit Number 21999 | 6005366.58200406 | 2100230.03647017 | 37.747135322118204 | -122.424184964624 | (37.7471353221182, -122.424184964624) | ||
| 43536 | 43536 | 73588 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1145 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1995 12:00:00 AM | 8 | 6007504.431890001 | 2118817.2788 | 37.798291956169294 | -122.41810995911699 | (37.7982919561693, -122.418109959117) | ||
| 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) | |
| 44078 | 44078 | 66992 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.721336430114796 | -122.457251654811 | (37.7213364301148, -122.457251654811) | ||
| 44656 | 44656 | 61666 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 182 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | 10 | Permit Number 21662 | 5992143.35704 | 2114256.7455 | 37.7848934361496 | -122.470931016199 | (37.7848934361496, -122.470931016199) | |
| 44989 | 44989 | 72175 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 9 | 6000606.57902 | 2119937.60106 | 37.80097740645329 | -122.44205899784201 | (37.8009774064533, -122.442058997842) | ||
| 45147 | 45147 | 65822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2231 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 5 | Permit Number 28812 | 6000656.13395 | 2119945.18642 | 37.8010010577013 | -122.44188806188 | (37.8010010577013, -122.44188806188) | |
| 45437 | 45437 | 71814 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 68 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/1990 12:00:00 AM | 18 | 5995915.832219999 | 2114038.69637 | 37.7845121880339 | -122.45786376992201 | (37.7845121880339, -122.457863769922) | ||
| 45623 | 45623 | 65828 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2270 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 5 | Permit Number 28818 | 6000482.650780001 | 2119964.5331599996 | 37.8010442917326 | -122.44248977580601 | (37.8010442917326, -122.442489775806) | |
| 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) | |
| 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) | ||
| 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) | |
| 47966 | 47966 | 65893 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 116 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 9 | Permit Number 28900 | 5995931.63622 | 2113606.82428 | 37.7833272906212 | -122.457777832601 | (37.7833272906212, -122.457777832601) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 51935 | 51935 | 62475 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 14 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 14 | Permit Number 22646 | 6001230.174240001 | 2093762.35137 | 37.729142145995 | -122.43802508971201 | (37.729142145995, -122.438025089712) | |
| 52162 | 52162 | 66502 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1631 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29665 | 5999570.2909 | 2114608.6731 | 37.7862864702045 | -122.445261627973 | (37.7862864702045, -122.445261627973) | |
| 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) | |
| 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) | |
| 53835 | 53835 | 64389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 4 | Permit Number 25231 | 6006529.57186 | 2114155.94695 | 37.78543818176271 | -122.421152111986 | (37.7854381817627, -122.421152111986) | ||
| 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) | ||
| 54890 | 54890 | 106128 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6012212.28641 | 2101900.78254 | 37.75210698286921 | -122.400630274471 | (37.7521069828692, -122.400630274471) | ||||
| 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) | ||
| 55221 | 55221 | 73723 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | ||
| 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) | |
| 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) | |
| 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) | |
| 57258 | 57258 | 61503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.784654374553206 | -122.479617149177 | (37.7846543745532, -122.479617149177) | |
| 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) | |
| 57491 | 57491 | 62699 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005257.84776 | 2117174.75811 | 37.793655307103 | -122.425766849977 | (37.793655307103, -122.425766849977) | ||
| 58120 | 58120 | 40227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.0178400003 | 37.78138030849961 | -122.39387241520001 | (37.7813803084996, -122.3938724152) | ||
| 58270 | 58270 | 59242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 563 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1980 12:00:00 AM | 8 | Permit Number 18573 | 5992504.0033599995 | 2111618.37405 | 37.777670040058496 | -122.469491184767 | (37.7776700400585, -122.469491184767) | ||
| 58938 | 58938 | 73718 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 73 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 11 | 6001058.666669999 | 2093583.8318599998 | 37.7286422173636 | -122.438605218052 | (37.7286422173636, -122.438605218052) | ||
| 59630 | 59630 | 65900 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 168 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28907 | 5995947.205130001 | 2113189.79047 | 37.782183121353896 | -122.457693785315 | (37.7821831213539, -122.457693785315) | |
| 59917 | 59917 | 66499 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1608 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 12 | Permit Number 29662 | 5999635.4257 | 2114496.7899 | 37.7859829858425 | -122.445028233013 | (37.7859829858425, -122.445028233013) | |
| 60703 | 60703 | 54978 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 655 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 11 | Permit Number 10856 | 5993145.12705 | 2111021.56757 | 37.7760684014385 | -122.46722993386899 | (37.7760684014385, -122.467229933869) | ||
| 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) | |
| 60857 | 60857 | 65931 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 115 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 7 | Permit Number 28950 | 5995872.00692 | 2113664.41853 | 37.7834820032566 | -122.45798829440201 | (37.7834820032566, -122.457988294402) | |
| 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) | |
| 63022 | 63022 | 59140 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | Permit Number 18446 | 5992233.6974599995 | 2111729.4961200003 | 37.7779595257589 | -122.470434351154 | (37.7779595257589, -122.470434351154) | ||
| 63108 | 63108 | 56420 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.564180001 | 2113818.4640099998 | 37.783578588527796 | -122.47755460021799 | (37.7835785885278, -122.477554600218) | ||
| 64603 | 64603 | 62591 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.774573792054795 | -122.497317337939 | (37.7745737920548, -122.497317337939) | |
| 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) | |
| 65546 | 65546 | 61848 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | ||
| 65681 | 65681 | 54939 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 537 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 7 | Permit Number 10817 | 6013054.91789 | 2086947.83958 | 37.7110962400835 | -122.396668170907 | (37.7110962400835, -122.396668170907) | ||
| 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) | |
| 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) |
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");