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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93845 | 93845 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 273 Magellan Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 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) | ||
| 94190 | 94190 | 62786 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23142 | 6000618.91780925 | 2091744.38237049 | 37.723566485054 | -122.439993611308 | (37.723566485054, -122.439993611308) | ||
| 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) | ||
| 94280 | 94280 | 61700 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 38 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21699 | 6005171.1078492 | 2107589.60782986 | 37.7673319406498 | -122.425384547486 | (37.7673319406498, -122.425384547486) | ||
| 95375 | 95375 | 98676 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 2 | 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 96364 | 96364 | 62794 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23151 | 6000307.76766309 | 2093181.82122993 | 37.727495644326 | -122.441172281845 | (37.727495644326, -122.441172281845) | ||
| 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) | ||
| 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) | ||||
| 96628 | 96628 | 67501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | ||
| 97255 | 97255 | 110187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | |||||
| 97311 | 97311 | 68478 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32347 | 6010221.7563028 | 2103020.9810753996 | 37.755071582179 | -122.40759283260599 | (37.755071582179, -122.407592832606) | ||
| 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) | ||
| 97461 | 97461 | 63237 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3659 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1988 12:00:00 AM | Permit Number 23785 | 6005918.83139631 | 2104302.58106763 | 37.7583487563714 | -122.422564673736 | (37.7583487563714, -122.422564673736) | ||
| 97683 | 97683 | 98677 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 3 | 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) | ||||
| 97971 | 97971 | 62791 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.44308579022301 | (37.7232016241068, -122.443085790223) | ||
| 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) | ||
| 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) | ||
| 98736 | 98736 | 92942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5992043.0 | 2096735.0 | 37.73677754441 | -122.47000197350701 | (37.73677754441, -122.470001973507) | ||||
| 98744 | 98744 | 51620 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 419 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48838 | 6004007.75048659 | 2096078.78682851 | 37.7356601244905 | -122.428587833263 | (37.7356601244905, -122.428587833263) | |||
| 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) | ||
| 99721 | 99721 | 61701 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 92 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21700 | 6005188.20814874 | 2107280.97565933 | 37.766485476641705 | -122.425303435058 | (37.7664854766417, -122.425303435058) | ||
| 99934 | 99934 | 33771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 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) | ||
| 100780 | 100780 | 63619 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 801X Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1987 12:00:00 AM | Permit Number 24261 | 5993268.63068404 | 2106608.32607844 | 37.7639579422382 | -122.466481867874 | (37.7639579422382, -122.466481867874) | |||
| 100795 | 100795 | 55698 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1660 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1973 12:00:00 AM | 12 | Permit Number 11715 | 6006814.07546 | 2116405.19314 | 37.7916300914035 | -122.420327512825 | (37.7916300914035, -122.420327512825) | ||
| 102126 | 102126 | 61696 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 537 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1984 12:00:00 AM | Permit Number 21695 | 6005240.89979754 | 2107791.37505015 | 37.7678898880098 | -122.42515750512301 | (37.7678898880098, -122.425157505123) | ||
| 102293 | 102293 | 96885 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 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) | ||
| 102595 | 102595 | 34533 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 395 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38241 | 6007729.86435225 | 2097252.7163141 | 37.7390934181522 | -122.415802113579 | (37.7390934181522, -122.415802113579) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 104072 | 104072 | 65909 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1371 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28918 | 5994237.48770801 | 2106190.93763502 | 37.762867761658605 | -122.46310061891899 | (37.7628677616586, -122.463100618919) | ||
| 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) | ||
| 104134 | 104134 | 62790 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | ||
| 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) | ||
| 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) | ||
| 106537 | 106537 | 62784 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 137 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23140 | 6000712.17881294 | 2091681.24596218 | 37.723398435511896 | -122.439666701145 | (37.7233984355119, -122.439666701145) | ||
| 106547 | 106547 | 62782 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23138 | 6000753.3579224 | 2091686.36985433 | 37.7234148482869 | -122.439524720053 | (37.7234148482869, -122.439524720053) | ||
| 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) | ||
| 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) | ||||
| 106599 | 106599 | 34227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 20 | Permit Number 38040 | 6007396.60708097 | 2107020.44544742 | 37.7658946396343 | -122.417646494621 | (37.7658946396343, -122.417646494621) | ||
| 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) | ||
| 106744 | 106744 | 63919 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 361 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/1988 12:00:00 AM | Permit Number 24639 | 6004187.93187702 | 2099820.2683611 | 37.745943572802 | -122.428231443138 | (37.745943572802, -122.428231443138) | ||
| 106790 | 106790 | 67341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2522 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30826 | 6011374.71716137 | 2101864.13092105 | 37.7519595969717 | -122.40352415267999 | (37.7519595969717, -122.40352415268) | ||
| 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) | ||
| 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) | ||
| 107510 | 107510 | 61248 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.799480713902604 | -122.417425152198 | (37.7994807139026, -122.417425152198) | ||
| 107661 | 107661 | 64553 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 363 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25442 | 6000196.58694342 | 2110119.71759225 | 37.7739966786528 | -122.442772359687 | (37.7739966786528, -122.442772359687) | ||
| 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) | ||
| 108690 | 108690 | 62788 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23144 | 6000370.84981794 | 2091713.58104778 | 37.723467786704504 | -122.440848927652 | (37.7234677867045, -122.440848927652) | ||
| 108877 | 108877 | 107463 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | |||||
| 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) | ||
| 109197 | 109197 | 62783 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23139 | 6000734.28765752 | 2091758.59405485 | 37.7236120741182 | -122.439595817461 | (37.7236120741182, -122.439595817461) | ||
| 109511 | 109511 | 92932 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 329 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5992099.0 | 2097070.0 | 37.7377006069055 | -122.46983274150101 | (37.7377006069055, -122.469832741501) | ||||
| 109533 | 109533 | 51073 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 553 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | Permit Number 47535 | 6002758.66460209 | 2103250.32502289 | 37.7552807236709 | -122.43341871948499 | (37.7552807236709, -122.433418719485) | |||
| 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) | ||
| 110592 | 110592 | 52006 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1489 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48222 | 6011774.4965411 | 2101419.07057833 | 37.7507598806074 | -122.402110363809 | (37.7507598806074, -122.402110363809) | ||||
| 110734 | 110734 | 68862 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32825 | 5999105.31511453 | 2093467.13996107 | 37.7282104958197 | -122.445349657876 | (37.7282104958197, -122.445349657876) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 112391 | 112391 | 54212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993618.71802201 | 2106620.31797794 | 37.7640110640874 | -122.465271900961 | (37.7640110640874, -122.465271900961) | |||
| 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) | ||
| 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) | ||
| 112789 | 112789 | 61937 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 154 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1985 12:00:00 AM | Permit Number 21994 | 6005520.29020359 | 2100238.48947557 | 37.7471672098 | -122.42365405439101 | (37.7471672098, -122.423654054391) | |||
| 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) | ||
| 114643 | 114643 | 37534 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1138 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | Permit Number 39980 | 6008135.8621207 | 2116394.85818942 | 37.791676107655704 | -122.415753397731 | (37.7916761076557, -122.415753397731) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 115395 | 115395 | 92910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 312 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5992168.0 | 2097141.0 | 37.7378995431122 | -122.469599344661 | (37.7378995431122, -122.469599344661) | ||||
| 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) | ||
| 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) | ||
| 116452 | 116452 | 63556 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2976 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1987 12:00:00 AM | Permit Number 24175 | 6008374.50243213 | 2103906.39946693 | 37.757399164233796 | -122.41404382523301 | (37.7573991642338, -122.414043825233) | ||
| 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) | ||
| 117184 | 117184 | 98682 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 8 | 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) | ||||
| 117727 | 117727 | 92938 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 345 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5992182.7 | 2096880.8 | 37.7371859491769 | -122.469529584198 | (37.7371859491769, -122.469529584198) | ||||
| 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) | ||
| 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) | ||
| 118589 | 118589 | 34242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.47512505139099 | (37.7643605962692, -122.475125051391) | |||
| 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) | ||
| 119329 | 119329 | 62781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23137 | 6000780.81066937 | 2091689.78578334 | 37.7234257900447 | -122.43943006593099 | (37.7234257900447, -122.439430065931) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 121711 | 121711 | 61699 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 31 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21698 | 6005220.93430093 | 2107630.2762583 | 37.76744642140179 | -122.42521509883801 | (37.7674464214018, -122.425215098838) | ||
| 122091 | 122091 | 114098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 219x VIDAL DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 40 | 5987664.0 | 2090565.0 | 37.719582202213104 | -122.48468943736401 | (37.7195822022131, -122.484689437364) | ||||
| 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) | |
| 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) | ||
| 123503 | 123503 | 92934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5992211.0 | 2096907.0 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) |
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");