trees
2,180 rows where qSpecies_id = 57 sorted by PlantDate descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78795 | 102165 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) | 2 | 4 | 5 | 28862 | 3 |
102592 | 17145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
111216 | 94496 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1600X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | 6x7 | 5998899.3 | 2109049 | 37.7709827197678 | -122.447182803026 | (37.7709827197678, -122.447182803026) | 15 | 5 | 11 | 29492 | 9 | |||
82436 | 68881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | 9 | 7 | 4 | 28861 | 40 | ||
91460 | 68920 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 5 | Permit Number 32904 | 6008796.25541 | 2118594.60343 | 37.79775316962 | -122.413624087676 | (37.79775316962, -122.413624087676) | 3 | 1 | 10 | 308 | 21 | |
127640 | 68918 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1731 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 13 | Permit Number 32899 | 6009145.56642 | 2119236.5699 | 37.799535459556 | -122.412460772349 | (37.799535459556, -122.412460772349) | 3 | 1 | 10 | 308 | 32 | |
184419 | 68922 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1255 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 9 | Permit Number 32906 | 6007550.61627 | 2118479.08218 | 37.7973659521424 | -122.417926160173 | (37.7973659521424, -122.417926160173) | 5 | 1 | 10 | 28858 | 32 | |
5567 | 6767 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017316.52552 | 2096883.88974 | 37.7386149694956 | -122.382629809543 | (37.7386149694956, -122.382629809543) | 10 | 3 | 8 | 58 | 1 | ||
179786 | 6751 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.538 | 37.7381731451641 | -122.381854690145 | (37.7381731451641, -122.381854690145) | 10 | 3 | 8 | 58 | 1 | |||
193927 | 6754 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
18638 | 60588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 516 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 12 | Permit Number 20205 | 6000644.6678 | 2110770.9269 | 37.7758102690094 | -122.441269110246 | (37.7758102690094, -122.441269110246) | 15 | 5 | 11 | 29492 | 10 | |
161700 | 52481 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 338HOLLY PARK Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48591 | 6006994.57282255 | 2096259.62185295 | 37.7363252369186 | -122.418274030892 | (37.7363252369186, -122.418274030892) | 2 | 7 | 7 | 28859 | 2 | ||
20975 | 68850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | 9 | 7 | 4 | 28861 | 40 | ||
86241 | 68860 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.5547129 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | 9 | 7 | 4 | 59 | 40 | ||
90755 | 61047 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | 9 | 7 | 4 | 28861 | 40 | ||
148591 | 68862 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32825 | 5999105.31511453 | 2093467.13996107 | 37.7282104958197 | -122.445349657876 | (37.7282104958197, -122.445349657876) | 9 | 7 | 4 | 28861 | 40 | ||
97197 | 52416 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.435651969168 | (37.717990874718, -122.435651969168) | 9 | 7 | 6 | 28861 | 5 | ||
129455 | 87082 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3119 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50024 | 5999240.5872 | 2116291.11958 | 37.7908872010279 | -122.446523400642 | (37.7908872010279, -122.446523400642) | 13 | 6 | 1 | 29490 | 31 | |
97387 | 67785 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | 10 | Permit Number 31423 | 6002427.0992 | 2114351.4059 | 37.7857427358754 | -122.435359412958 | (37.7857427358754, -122.435359412958) | 13 | 6 | 11 | 29490 | 13 | ||
71624 | 113963 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.97581 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | 8 | 2 | 8 | 28853 | 20 | ||
108751 | 113964 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 11 | 3x3 | 6011665.76024 | 2107233.19616 | 37.7667181107677 | -122.402895261101 | (37.7667181107677, -122.402895261101) | 8 | 2 | 8 | 28853 | 20 | ||
39135 | 12169 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.385349476433 | (37.7333003856228, -122.385349476433) | 10 | 3 | 8 | 58 | 1 | ||
81093 | 12173 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.7336733897742 | -122.385645619675 | (37.7336733897742, -122.385645619675) | 10 | 3 | 8 | 58 | 1 | ||
34718 | 62107 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 373 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49980 | 6006792.08421569 | 2101617.3134298 | 37.7510248549528 | -122.419354081346 | (37.7510248549528, -122.419354081346) | 2 | 4 | 7 | 28859 | 19 | ||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
70767 | 41267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
61550 | 61695 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 9 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21694 | 6005214.10969137 | 2107753.44919209 | 37.7677842392376 | -122.425247470035 | (37.7677842392376, -122.425247470035) | 8 | 4 | 5 | 28853 | 19 | ||
82152 | 61697 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 22 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21696 | 6005166.04109398 | 2107681.05439541 | 37.767582744756 | -122.425408581153 | (37.767582744756, -122.425408581153) | 8 | 4 | 5 | 28853 | 19 | ||
108151 | 61696 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 537 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21695 | 6005240.89979754 | 2107791.37505015 | 37.7678898880098 | -122.425157505123 | (37.7678898880098, -122.425157505123) | 8 | 4 | 5 | 28853 | 19 | ||
87128 | 61700 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 38 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21699 | 6005171.1078492 | 2107589.60782986 | 37.7673319406498 | -122.425384547486 | (37.7673319406498, -122.425384547486) | 8 | 4 | 5 | 28853 | 19 | ||
98675 | 61701 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 92 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21700 | 6005188.20814874 | 2107280.97565933 | 37.7664854766417 | -122.425303435058 | (37.7664854766417, -122.425303435058) | 8 | 4 | 5 | 28853 | 19 | ||
153068 | 61699 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 31 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21698 | 6005220.93430093 | 2107630.2762583 | 37.7674464214018 | -122.425215098838 | (37.7674464214018, -122.425215098838) | 8 | 4 | 5 | 28853 | 19 | ||
63511 | 12823 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3 | 5 | 5988577.51702 | 2114639.82314 | 37.7857383852899 | -122.483295611932 | (37.7857383852899, -122.483295611932) | 11 | 6 | 2 | 55 | 26 | ||
41391 | 68819 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.444374381277 | (37.729117226145, -122.444374381277) | 9 | 7 | 4 | 28861 | 40 | ||
193216 | 68829 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | 9 | 7 | 4 | 63 | 40 | ||
13051 | 55532 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | 11 | 8 | 11 | 56 | 12 | |||
159307 | 15312 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | 8 | 2 | 9 | 28853 | 19 | ||
93937 | 33597 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 236 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37705 | 6006736.00716085 | 2097819.44866051 | 37.7405936167848 | -122.419278618744 | (37.7405936167848, -122.419278618744) | 2 | 7 | 7 | 28859 | 2 | ||
48534 | 114558 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.425814460096 | (37.7936541667538, -122.425814460096) | 13 | 9 | 1 | 28858 | 27 | ||
151462 | 62699 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005257.84776 | 2117174.75811 | 37.793655307103 | -122.425766849977 | (37.793655307103, -122.425766849977) | 13 | 9 | 1 | 28858 | 27 | ||
133053 | 120901 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2032 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778866 | 6001448.95372 | 2115547.55562 | 37.7889714571097 | -122.438829258958 | (37.7889714571097, -122.438829258958) | 13 | 6 | 1 | 29490 | 27 | |
20777 | 41179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.92482 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | 13 | 9 | 1 | 57 | 17 | |
26783 | 41176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.19311 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | 13 | 9 | 1 | 57 | 17 | |
72579 | 68787 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.7447761070514 | -122.470428661516 | (37.7447761070514, -122.470428661516) | 1 | 8 | 4 | 29491 | 40 | ||
175127 | 68799 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2459 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32738 | 5992323.72089278 | 2098718.16784221 | 37.742239045273 | -122.469175702533 | (37.742239045273, -122.469175702533) | 1 | 8 | 4 | 29491 | 40 | ||
89856 | 61666 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 182 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | 10 | Permit Number 21662 | 5992143.35704 | 2114256.7455 | 37.7848934361496 | -122.470931016199 | (37.7848934361496, -122.470931016199) | 11 | 6 | 2 | 54 | 11 | |
97760 | 61663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 121 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | 9 | 6x9 | Permit Number 21657 | 5992393.21685 | 2114622.98494 | 37.7859134760601 | -122.470093267127 | (37.7859134760601, -122.470093267127) | 11 | 6 | 2 | 54 | 11 |
167543 | 61665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 129 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | 9 | Permit Number 21661 | 5992088.12386 | 2114525.07918 | 37.7856270118183 | -122.471141659462 | (37.7856270118183, -122.471141659462) | 11 | 6 | 2 | 54 | 11 | |
87859 | 67716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 560 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 18 | 4x9 | Permit Number 31329 | 6014049.28523 | 2112210.37006 | 37.7805171185161 | -122.394999630825 | (37.7805171185161, -122.394999630825) | 6 | 2 | 9 | 28856 | 34 |
41981 | 57660 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4417 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1976 12:00:00 AM | 3x3 | Permit Number 772993 | 6001718.02788931 | 2104070.42319625 | 37.7574734209258 | -122.437076257467 | (37.7574734209258, -122.437076257467) | 2 | 4 | 5 | 28862 | 3 | ||
28411 | 34516 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 23 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1997 12:00:00 AM | Permit Number 38227 | 6006103.90835028 | 2100218.50622556 | 37.7471452669413 | -122.421634526851 | (37.7471452669413, -122.421634526851) | 2 | 7 | 5 | 28859 | 22 | ||
127812 | 59184 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 226 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1988 12:00:00 AM | Permit Number 25686 | 6001313.09402132 | 2109464.81176347 | 37.7722620581627 | -122.438863239887 | (37.7722620581627, -122.438863239887) | 15 | 5 | 11 | 29492 | 9 | ||
48203 | 33325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.17959 | 37.8023080334521 | -122.428193340463 | (37.8023080334521, -122.428193340463) | 13 | 9 | 1 | 57 | 17 | |
110653 | 33285 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1537 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 6 | Permit Number 37447 | 6008380.61834 | 2117789.48589 | 37.7955191682212 | -122.415005295285 | (37.7955191682212, -122.415005295285) | 5 | 1 | 10 | 28858 | 21 | |
127158 | 63919 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 361 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/1988 12:00:00 AM | Permit Number 24639 | 6004187.93187702 | 2099820.2683611 | 37.745943572802 | -122.428231443138 | (37.745943572802, -122.428231443138) | 2 | 7 | 5 | 63 | 22 | ||
178168 | 63512 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1912 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 24121 | 6000303.945 | 2111684.2477 | 37.7782986006192 | -122.442513341395 | (37.7782986006192, -122.442513341395) | 15 | 5 | 11 | 29490 | 16 |
181135 | 33186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | 1 | 5 | 4 | 59 | 40 | ||
192754 | 66835 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 701 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30135 | 6009204.71418502 | 2115334.29605872 | 37.7888240893158 | -122.41198018251 | (37.7888240893158, -122.41198018251) | 5 | 1 | 10 | 28858 | 21 | ||
121578 | 33112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2628 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 9 | Permit Number 37349 | 6000339.44764 | 2118557.89779 | 37.7971738812189 | -122.442884250816 | (37.7971738812189, -122.442884250816) | 13 | 9 | 1 | 57 | 17 | |
52270 | 32821 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4251 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.437639271349 | (37.7526166065877, -122.437639271349) | 2 | 4 | 5 | 28862 | 22 | ||
117331 | 32822 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4251 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.437639271349 | (37.7526166065877, -122.437639271349) | 2 | 4 | 5 | 28862 | 22 | ||
125859 | 32770 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | 15 | 5 | 11 | 29492 | 10 | |
135159 | 32769 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 6 | Permit Number 37143 | 6000722.0176 | 2110255.3136 | 37.7743989310052 | -122.440964540315 | (37.7743989310052, -122.440964540315) | 15 | 5 | 11 | 29492 | 10 | |
185483 | 32771 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.7743183510223 | -122.440968898129 | (37.7743183510223, -122.440968898129) | 15 | 5 | 11 | 29492 | 10 | ||
185135 | 58462 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 245 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 4x3 | Permit Number 17616 | 5998964.32399237 | 2106748.99637292 | 37.7646712060943 | -122.446792361644 | (37.7646712060943, -122.446792361644) | 15 | 5 | 11 | 29492 | 9 | |
70145 | 62207 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1985 12:00:00 AM | Permit Number 22329 | 6001115.41413851 | 2093618.10384038 | 37.728739548363 | -122.438411493533 | (37.728739548363, -122.438411493533) | 9 | 7 | 6 | 28861 | 25 | ||
32373 | 77649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
67880 | 77637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
133673 | 77636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
135683 | 77635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
141010 | 77633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
180726 | 77634 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
33910 | 50451 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.7689532065783 | -122.445784947419 | (37.7689532065783, -122.445784947419) | 15 | 5 | 11 | 29492 | 9 | |||
85229 | 68478 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32347 | 6010221.7563028 | 2103020.9810754 | 37.755071582179 | -122.407592832606 | (37.755071582179, -122.407592832606) | 2 | 4 | 7 | 28859 | 19 | ||
167845 | 32540 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Roscoe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 10 | Permit Number 37038 | 6006810.39067 | 2095478.81969 | 37.7341709570185 | -122.418855467408 | (37.7341709570185, -122.418855467408) | 2 | 7 | 7 | 28859 | 2 | |
104599 | 67616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1493 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 4 | Permit Number 31197 | 6002054.0075 | 2111526.4952 | 37.7779650512217 | -122.436447944334 | (37.7779650512217, -122.436447944334) | 15 | 5 | 11 | 29492 | 41 | |
115029 | 61248 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.7994807139026 | -122.417425152198 | (37.7994807139026, -122.417425152198) | 5 | 1 | 1 | 308 | 32 | ||
131561 | 58390 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.448759699122 | (37.7290972609549, -122.448759699122) | 9 | 7 | 4 | 28861 | 40 | ||
174750 | 59021 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 116 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1988 12:00:00 AM | Permit Number 25608 | 6005536.1099439 | 2104041.86258252 | 37.75761128554 | -122.423869755917 | (37.75761128554, -122.423869755917) | 2 | 4 | 5 | 28859 | 19 | ||
61580 | 67593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 357 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31160 | 6013799.73337 | 2105430.83352 | 37.7618881461485 | -122.395387878055 | (37.7618881461485, -122.395387878055) | 10 | 3 | 8 | 28856 | 29 | |
93436 | 67592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 355 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31159 | 6013796.23882 | 2105471.52113 | 37.7619996710595 | -122.395402814912 | (37.7619996710595, -122.395402814912) | 10 | 3 | 8 | 28856 | 29 | |
1826 | 62206 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22328 | 6001109.87298 | 2093671.7514 | 37.7288865370674 | -122.438434491679 | (37.7288865370674, -122.438434491679) | 9 | 7 | 6 | 28861 | 25 | |
14672 | 62212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.88226 | 37.7291669843608 | -122.437772711138 | (37.7291669843608, -122.437772711138) | 9 | 7 | 6 | 28861 | 25 | |
16674 | 62213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22336 | 6001177.27304 | 2093672.32892 | 37.7288919563899 | -122.438201526774 | (37.7288919563899, -122.438201526774) | 9 | 7 | 6 | 28861 | 25 | |
59530 | 101406 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50-52 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769364 | 6005160.9 | 2107520.2 | 37.7671407866326 | -122.425414915098 | (37.7671407866326, -122.425414915098) | 8 | 4 | 5 | 28853 | 19 | |
51373 | 6003 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
52357 | 6001 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
124351 | 92632 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
146790 | 92634 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
178030 | 6002 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.4671908 | 2112668.0181364 | 37.7811196348904 | -122.435296499335 | (37.7811196348904, -122.435296499335) | 15 | 5 | 11 | 29490 | 41 | |
50748 | 50368 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2784 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 4 | Permit Number 47035 | 6000204.6547 | 2114445.9464 | 37.7858758547183 | -122.443055209056 | (37.7858758547183, -122.443055209056) | 13 | 6 | 1 | 29490 | 27 | ||
141494 | 13031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 462 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2015 12:00:00 AM | 10 | 3X3 | 6010124.59861 | 2120694.43773 | 37.803593298513 | -122.409175884375 | (37.803593298513, -122.409175884375) | 3 | 1 | 10 | 308 | 23 | ||
179184 | 45683 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.415328273299 | (37.79625955578, -122.415328273299) | 5 | 1 | 10 | 28858 | 21 | ||
89908 | 67501 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | 9 | 7 | 4 | 59 | 40 | ||
54413 | 55257 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.484218064948 | (37.7741363990758, -122.484218064948) | 11 | 6 | 2 | 55 | 26 | ||
54545 | 42985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
120765 | 42988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
145783 | 129585 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Webster St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003281.99401 | 2116331.1346 | 37.7912270809146 | -122.432543180443 | (37.7912270809146, -122.432543180443) | 13 | 9 | 1 | 29490 | 27 | ||
31107 | 111019 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 90x DOWNEY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );