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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96494 | 96494 | 110186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 106587 | 106587 | 122454 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||||
| 114292 | 114292 | 98326 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5999516.2 | 2114621.9 | 37.786319700098296 | -122.445449719271 | (37.7863197000983, -122.445449719271) | |||
| 115141 | 115141 | 110189 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 105551 | 105551 | 66457 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 441 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29607 | 6004072.71052571 | 2110301.27189775 | 37.7747153911121 | -122.42937714182399 | (37.7747153911121, -122.429377141824) | ||
| 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) | ||
| 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) |
| 123474 | 123474 | 64827 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 274 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25836 | 6004793.11366146 | 2099029.61430965 | 37.74380684184 | -122.426082529577 | (37.74380684184, -122.426082529577) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 98240 | 98240 | 65617 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | Permit Number 28524 | 6004220.92651357 | 2094058.36358609 | 37.7301245583022 | -122.42770689303002 | (37.7301245583022, -122.42770689303) | ||
| 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) | ||
| 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) | ||
| 104680 | 104680 | 67018 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30374 | 5995620.26197767 | 2090586.55623665 | 37.7201015427641 | -122.457189254526 | (37.7201015427641, -122.457189254526) | ||
| 139428 | 139428 | 67005 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 48 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30360 | 5995649.51069731 | 2090220.09677054 | 37.7190970115741 | -122.457061658607 | (37.7190970115741, -122.457061658607) | ||
| 142846 | 142846 | 67008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30363 | 5995610.42846311 | 2090973.17671265 | 37.721162546103 | -122.457251199338 | (37.721162546103, -122.457251199338) | ||
| 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) | |
| 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) | |
| 97232 | 97232 | 66503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1700X LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 6 | 3x3 | Permit Number 29666 | 5999626.0 | 2114704.0 | 37.7865513928089 | -122.445075745226 | (37.7865513928089, -122.445075745226) |
| 111064 | 111064 | 66498 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | Permit Number 29661 | 5999602.83353685 | 2114377.91240421 | 37.7856547189649 | -122.445132443034 | (37.7856547189649, -122.445132443034) | ||
| 140777 | 140777 | 66500 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1699X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 3x3 | Permit Number 29663 | 6005806.0 | 2115518.0 | 37.7891372243478 | -122.423752338781 | (37.7891372243478, -122.423752338781) | |
| 164215 | 164215 | 62019 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1617 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29660 | 5999580.2026 | 2114540.2826 | 37.7860992534846 | -122.445222417327 | (37.7860992534846, -122.445222417327) | |
| 165245 | 165245 | 62020 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1615 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 9 | Permit Number 29670 | 5999582.1849 | 2114512.53 | 37.786023165226496 | -122.44521356308901 | (37.7860231652265, -122.445213563089) | |
| 186959 | 186959 | 66501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1625 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29664 | 5999574.2556 | 2114579.9293 | 37.7862077735321 | -122.44524584382 | (37.7862077735321, -122.44524584382) | |
| 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) | |
| 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) | |
| 121186 | 121186 | 62592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | ||
| 154101 | 154101 | 62594 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.8986299997 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | |
| 159008 | 159008 | 62593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.2368799997 | 37.7750775975018 | -122.49734715750401 | (37.7750775975018, -122.497347157504) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 111380 | 111380 | 65629 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2555 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | Permit Number 28537 | 6001294.02640189 | 2114543.2007518997 | 37.7862049421015 | -122.439293267044 | (37.7862049421015, -122.439293267044) | ||
| 188762 | 188762 | 65630 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2510 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 8 | Permit Number 28538 | 6001388.347 | 2114610.3564 | 37.7863947012265 | -122.43897175770701 | (37.7863947012265, -122.438971757707) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 72514 | 72514 | 61855 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066002 | (37.7540649402035, -122.40731493066) | ||
| 78084 | 78084 | 61853 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.75412631741629 | -122.407320968841 | (37.7541263174163, -122.407320968841) | ||
| 79635 | 79635 | 61858 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1150 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21898 | 6010250.43626462 | 2102515.61174925 | 37.7536855558022 | -122.40745802144 | (37.7536855558022, -122.40745802144) | ||
| 85474 | 85474 | 61845 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21884 | 6010284.24906681 | 2102833.32009511 | 37.7545598048232 | -122.407363484663 | (37.7545598048232, -122.407363484663) | ||
| 90947 | 90947 | 61850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1078 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21889 | 6010226.10973791 | 2102942.52266102 | 37.754856396543204 | -122.407572245672 | (37.7548563965432, -122.407572245672) | ||
| 91185 | 91185 | 61842 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21881 | 6010272.43259961 | 2103046.27865741 | 37.7551438802467 | -122.40741936190001 | (37.7551438802467, -122.4074193619) | ||
| 94202 | 94202 | 61851 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21890 | 6010288.806738901 | 2102753.58958513 | 37.7543411376679 | -122.407342102556 | (37.7543411376679, -122.407342102556) | ||
| 103303 | 103303 | 61861 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2750 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21901 | 6010264.84701821 | 2102255.53595422 | 37.752972251984794 | -122.40738985197599 | (37.7529722519848, -122.407389851976) | ||
| 104027 | 104027 | 61866 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1337 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21906 | 6010360.39666157 | 2101479.92866797 | 37.7508479533215 | -122.407004757895 | (37.7508479533215, -122.407004757895) | ||
| 106703 | 106703 | 61847 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21886 | 6010217.4028677 | 2103099.43948978 | 37.7552867678032 | -122.407613419659 | (37.7552867678032, -122.407613419659) | ||
| 112602 | 112602 | 61862 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1208 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21902 | 6010270.34996768 | 2102167.49523516 | 37.7527308196896 | -122.407364615493 | (37.7527308196896, -122.407364615493) | ||
| 118809 | 118809 | 61863 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1212 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | 3x3 | Permit Number 21903 | 6010271.5831249 | 2102145.16353886 | 37.7526695708202 | -122.407358776803 | (37.7526695708202, -122.407358776803) | |
| 120391 | 120391 | 61844 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21883 | 6010281.13947097 | 2102889.36180769 | 37.754713508851 | -122.40737818911 | (37.754713508851, -122.40737818911) | ||
| 120523 | 120523 | 61840 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1031 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21879 | 6010263.10380919 | 2103214.40384755 | 37.7556049923888 | -122.40746347613 | (37.7556049923888, -122.40746347613) | ||
| 123467 | 123467 | 61859 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1160 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | 8 | Permit Number 21899 | 6010253.66087773 | 2102459.66274806 | 37.75353211276 | -122.40744292581101 | (37.75353211276, -122.407442925811) | |
| 127865 | 127865 | 61857 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | ||
| 145670 | 145670 | 61864 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1266 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | 11 | 3x3 | Permit Number 21904 | 6010288.23074759 | 2101843.68563372 | 37.7518427109773 | -122.40727995543502 | (37.7518427109773, -122.407279955435) |
| 87789 | 87789 | 63516 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3130 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24125 | 6009013.02136045 | 2104526.43175215 | 37.7591374742847 | -122.41187937836399 | (37.7591374742847, -122.411879378364) | ||
| 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) | ||
| 118055 | 118055 | 63517 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3000 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24127 | 6009328.3554345 | 2104544.08998515 | 37.7592036456391 | -122.410790045257 | (37.7592036456391, -122.410790045257) | ||
| 93525 | 93525 | 66553 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 160 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29737 | 6005262.81634386 | 2104026.69666345 | 37.7575542112069 | -122.424813838267 | (37.7575542112069, -122.424813838267) | ||
| 128219 | 128219 | 66558 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3726 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29744 | 6005466.23183665 | 2104329.54931664 | 37.7583972608009 | -122.42413188215201 | (37.7583972608009, -122.424131882152) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 86556 | 86556 | 61933 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | 36 | Permit Number 21990 | 6005702.47179 | 2100196.42976905 | 37.747062005493206 | -122.42302109514699 | (37.7470620054932, -122.423021095147) | |
| 112331 | 112331 | 61938 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 160 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | Permit Number 21995 | 6005481.86313575 | 2100236.37622324 | 37.7471592381001 | -122.42378678205401 | (37.7471592381001, -122.423786782054) | ||
| 113586 | 113586 | 61944 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 28 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | Permit Number 22003 | 6006088.71912986 | 2100269.74948978 | 37.7472851127708 | -122.421690689107 | (37.7472851127708, -122.421690689107) | ||
| 118036 | 118036 | 61939 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | Permit Number 21996 | 6005456.24511446 | 2100234.96738966 | 37.747153923555295 | -122.42387526706499 | (37.7471539235553, -122.423875267065) |
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");