Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 1494 | 1494 | 251576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490X Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 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 | |||||||||
| 9955 | 9955 | 173749 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299x 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006897.0 | 2106023.0 | 37.7631277620706 | -122.41930377135598 | (37.7631277620706, -122.419303771356) | ||||
| 10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10226 | 10226 | 173925 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
| 12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 74401 | 74401 | 121592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002342.0 | 2100313.0 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | ||||
| 75753 | 75753 | 108149 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 77326 | 77326 | 54931 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1466 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 3x3 | Permit Number 51416 | 6003271.64345897 | 2099695.83318704 | 37.7455500147976 | -122.43139096057 | (37.7455500147976, -122.43139096057) | ||
| 77555 | 77555 | 99747 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002274.0 | 2100636.0 | 37.7480748999105 | -122.434907877013 | (37.7480748999105, -122.434907877013) | ||||
| 77722 | 77722 | 50451 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.768953206578296 | -122.445784947419 | (37.7689532065783, -122.445784947419) | |||
| 78044 | 78044 | 68850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | ||
| 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) | ||
| 78314 | 78314 | 62107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 373 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49980 | 6006792.08421569 | 2101617.3134298 | 37.751024854952796 | -122.419354081346 | (37.7510248549528, -122.419354081346) | ||
| 79610 | 79610 | 32821 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
| 79613 | 79613 | 51053 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 557 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47523 | 6002734.05323147 | 2103248.96658127 | 37.7552755973804 | -122.433503735784 | (37.7552755973804, -122.433503735784) | |||
| 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) | ||
| 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) | ||
| 80855 | 80855 | 57660 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4417 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1976 12:00:00 AM | 3x3 | Permit Number 772993 | 6001718.02788931 | 2104070.42319625 | 37.7574734209258 | -122.437076257467 | (37.7574734209258, -122.437076257467) | ||
| 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) | ||
| 81970 | 81970 | 114877 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 226 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001315.0 | 2109584.0 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | ||||
| 82585 | 82585 | 44826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.40619016379601 | (37.7120713475932, -122.406190163796) | |||
| 82598 | 82598 | 62789 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.44101991790899 | (37.7234373055999, -122.441019917909) | ||
| 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) | ||
| 84112 | 84112 | 68819 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.44437438127702 | (37.729117226145, -122.444374381277) | ||
| 85009 | 85009 | 98240 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 800 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 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) | ||
| 85767 | 85767 | 99103 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006380.0 | 2111267.6 | 37.7774990526419 | -122.421464387784 | (37.7774990526419, -122.421464387784) | ||||
| 86603 | 86603 | 114790 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013060.0 | 2086881.0 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | ||||
| 87389 | 87389 | 46271 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 325 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2002 12:00:00 AM | Permit Number 44555 | 6006560.87997001 | 2097281.80561087 | 37.739107504355005 | -122.419846001297 | (37.739107504355, -122.419846001297) | |||
| 87544 | 87544 | 61695 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 9 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1984 12:00:00 AM | Permit Number 21694 | 6005214.10969137 | 2107753.44919209 | 37.7677842392376 | -122.425247470035 | (37.7677842392376, -122.425247470035) | ||
| 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) | ||
| 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) | ||
| 88051 | 88051 | 62207 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | Permit Number 22329 | 6001115.41413851 | 2093618.10384038 | 37.728739548363 | -122.438411493533 | (37.728739548363, -122.438411493533) | ||
| 88113 | 88113 | 41267 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | |||
| 88400 | 88400 | 89032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 88630 | 88630 | 38432 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40460 | 5995813.83516301 | 2115862.46033815 | 37.7895138928462 | -122.45834869498002 | (37.7895138928462, -122.45834869498) | |||
| 89336 | 89336 | 68787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.74477610705139 | -122.470428661516 | (37.7447761070514, -122.470428661516) | ||
| 90728 | 90728 | 63893 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1X BRADY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24602 | 6006435.0 | 2109828.0 | 37.773549358695796 | -122.42117187599301 | (37.7735493586958, -122.421171875993) | ||
| 90812 | 90812 | 114431 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2787 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000638.0 | 2114779.0 | 37.7868150321065 | -122.44157986784799 | (37.7868150321065, -122.441579867848) | ||||
| 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) | ||
| 91213 | 91213 | 68860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.554712901 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | ||
| 91983 | 91983 | 61697 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 22 Ramona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1984 12:00:00 AM | Permit Number 21696 | 6005166.04109398 | 2107681.05439541 | 37.767582744756 | -122.425408581153 | (37.767582744756, -122.425408581153) | ||
| 92026 | 92026 | 58585 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1979 12:00:00 AM | 3x3 | Permit Number 17781 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||
| 92119 | 92119 | 64694 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 114 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005548.53237974 | 2104042.55194245 | 37.757613879648105 | -122.42382684305099 | (37.7576138796481, -122.423826843051) | ||
| 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) | ||
| 92605 | 92605 | 112350 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 130 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992742.0 | 2097684.0 | 37.7394236424672 | -122.46765424156 | (37.7394236424672, -122.46765424156) | ||||
| 93483 | 93483 | 68881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | ||
| 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) | ||
| 93685 | 93685 | 61047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | ||
| 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) | ||
| 94503 | 94503 | 112343 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 28 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993108.0 | 2098132.0 | 37.740674863300704 | -122.46642133706301 | (37.7406748633007, -122.466421337063) | ||||
| 94612 | 94612 | 103609 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 98371 | 98371 | 122342 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994723.0 | 2112183.0 | 37.7793483429351 | -122.461855927769 | (37.7793483429351, -122.461855927769) | ||||
| 98649 | 98649 | 58460 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 225 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1978 12:00:00 AM | 3x3 | Permit Number 17614 | 5998947.71410924 | 2106866.99110148 | 37.764994241098705 | -122.446858301796 | (37.7649942410987, -122.446858301796) | ||
| 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) | |||
| 99192 | 99192 | 101266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989175.0 | 2106519.0 | 37.7634756077712 | -122.48063381405599 | (37.7634756077712, -122.480633814056) | ||||
| 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) | ||
| 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) | ||
| 100920 | 100920 | 94496 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1600X Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 6x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 104458 | 104458 | 105873 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 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) | ||
| 105991 | 105991 | 109819 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 909X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.779331512641896 | -122.42693096158101 | (37.7793315126419, -122.426930961581) | ||||
| 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) | ||
| 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) | ||
| 107084 | 107084 | 101265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989459.10715 | 2106523.8610900003 | 37.7635054630097 | -122.47965154526001 | (37.7635054630097, -122.47965154526) |
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");