trees
2,421 rows where qSpecies_id = 8 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29548 | 251781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070 | 2087245 | 37.7112378586553 | -122.438112149268 | (37.7112378586553, -122.438112149268) | 9 | 7 | 6 | 28861 | 5 | ||
| 157529 | 55450 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1238 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20687 | 5995498.97479315 | 2107131.57167312 | 37.7655230868492 | -122.458805707854 | (37.7655230868492, -122.458805707854) | 15 | 5 | 11 | 56 | 12 | ||
| 173914 | 254375 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1238 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778703 | 5993632.74679 | 2107063.55913 | 37.7652288969897 | -122.465255577799 | (37.7652288969897, -122.465255577799) | 11 | 8 | 11 | 56 | 12 |
| 111112 | 54727 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1239 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2010 12:00:00 AM | 16 | Permit Number 10570 | 5993898.14221717 | 2107049.18908111 | 37.7652047418661 | -122.464336602201 | (37.7652047418661, -122.464336602201) | 11 | 5 | 11 | 56 | 12 | ||
| 72062 | 207650 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5992348.57689 | 2106988.87327 | 37.7649496901864 | -122.469691736987 | (37.7649496901864, -122.469691736987) | 11 | 8 | 11 | 56 | 12 | |||
| 152043 | 69057 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33065 | 5992349.25716829 | 2107019.71250197 | 37.7650344058537 | -122.469691629397 | (37.7650344058537, -122.469691629397) | 11 | 8 | 11 | 56 | 12 | ||
| 145999 | 53552 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 124 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20052 | 5997008.15708783 | 2089291.43789618 | 37.7166250615868 | -122.452298391323 | (37.7166250615868, -122.452298391323) | 9 | 8 | 6 | 28861 | 24 | ||
| 73087 | 88794 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1240 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2010 12:00:00 AM | 3x3 | Permit Number 51706 | 5994624.7 | 2107112.8 | 37.7654212536678 | -122.461828244278 | (37.7654212536678, -122.461828244278) | 15 | 5 | 11 | 56 | 12 | |||
| 29467 | 191681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1241 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017111.18893 | 2093915.90803 | 37.7304541363294 | -122.383133251796 | (37.7304541363294, -122.383133251796) | 10 | 3 | 8 | 58 | 1 | |||
| 157578 | 191680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1241 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017088.63788 | 2093939.5635 | 37.7305178434155 | -122.383212860684 | (37.7305178434155, -122.383212860684) | 10 | 3 | 8 | 58 | 1 | |||
| 131855 | 207545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994515.71143 | 2107079.97224 | 37.7653248424019 | -122.462202826907 | (37.7653248424019, -122.462202826907) | 11 | 5 | 11 | 56 | 12 | |||
| 27234 | 69058 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33066 | 5992350.1648235 | 2106993.32933415 | 37.7649620171359 | -122.469686569205 | (37.7649620171359, -122.469686569205) | 11 | 8 | 11 | 56 | 12 | ||
| 87618 | 207651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992350.99659 | 2106967.18215 | 37.7648902719794 | -122.469681788681 | (37.7648902719794, -122.469681788681) | 11 | 8 | 11 | 56 | 12 | |||
| 106925 | 38109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 4 | Permit Number 40277 | 5987050.95818325 | 2106810.63919781 | 37.7641526918478 | -122.488001527428 | (37.7641526918478, -122.488001527428) | 1 | 8 | 3 | 56 | 35 | |
| 17745 | 207576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1245 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993280.81145 | 2107003.85945 | 37.7650446756837 | -122.466468488529 | (37.7650446756837, -122.466468488529) | 11 | 8 | 11 | 56 | 12 | |||
| 163147 | 54271 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1247 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 10024 | 5993280.22580381 | 2106998.95550637 | 37.7650311769521 | -122.466470157661 | (37.7650311769521, -122.466470157661) | 11 | 8 | 11 | 56 | 12 | |||
| 164180 | 207546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1249 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993899.6739 | 2106983.20983 | 37.7650236684223 | -122.46432651386 | (37.7650236684223, -122.46432651386) | 11 | 5 | 11 | 56 | 12 | |||
| 132916 | 207652 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1249 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992353.95742 | 2106910.47377 | 37.7647347369382 | -122.469667419325 | (37.7647347369382, -122.469667419325) | 11 | 8 | 11 | 56 | 12 | |||
| 179303 | 69059 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1249 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33067 | 5992351.52630546 | 2106953.75460707 | 37.7648534341248 | -122.46967897894 | (37.7648534341248, -122.46967897894) | 11 | 8 | 11 | 56 | 12 | ||
| 71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
| 84067 | 223485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009074.65326 | 2097933.54072 | 37.7410383222477 | -122.411200507415 | (37.7410383222477, -122.411200507415) | 10 | 7 | 7 | 28859 | 2 | |||
| 60727 | 92277 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52726 | 5992357 | 2098417 | 37.7414140378166 | -122.469038721636 | (37.7414140378166, -122.469038721636) | 1 | 8 | 4 | 59 | 40 | ||
| 172645 | 207581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992198.24643 | 2098404.03839 | 37.7413692745846 | -122.469586688073 | (37.7413692745846, -122.469586688073) | 1 | 8 | 4 | 59 | 40 | |||
| 71467 | 207631 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1253 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993899.35074 | 2106950.14127 | 37.7649328521939 | -122.464325230527 | (37.7649328521939, -122.464325230527) | 11 | 5 | 11 | 56 | 12 | |||
| 188515 | 111022 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1254 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993942 | 2106950 | 37.7649349225469 | -122.464177708405 | (37.7649349225469, -122.464177708405) | 11 | 5 | 11 | 56 | 12 | ||||
| 189731 | 207629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1256 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993954.61606 | 2106931.98149 | 37.7648861755735 | -122.464132764815 | (37.7648861755735, -122.464132764815) | 11 | 5 | 11 | 56 | 12 | |||
| 24478 | 69061 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33069 | 5992353.79544263 | 2106887.79671216 | 37.764672462389 | -122.469666328544 | (37.764672462389, -122.469666328544) | 11 | 8 | 11 | 56 | 12 | ||
| 177663 | 207653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5992353.42647 | 2106870.06919 | 37.7646237659879 | -122.469666314052 | (37.7646237659879, -122.469666314052) | 11 | 8 | 11 | 56 | 12 | |||
| 110883 | 27510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6005834.02618 | 2101632.44152 | 37.7510123874197 | -122.422668221463 | (37.7510123874197, -122.422668221463) | 2 | 4 | 5 | 28859 | 19 | |||
| 147036 | 33049 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37325 | 6005839.09502219 | 2101642.93131356 | 37.7510414759561 | -122.422651438228 | (37.7510414759561, -122.422651438228) | 2 | 4 | 5 | 28859 | 19 | ||
| 37282 | 95858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5993372.82916 | 2114637.22815 | 37.7860091664792 | -122.466705142577 | (37.7860091664792, -122.466705142577) | 11 | 6 | 2 | 54 | 11 | |||
| 31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
| 124905 | 246577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | 7 | 9 | 11 | 28852 | 10 | |||
| 178180 | 246578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005224.61763 | 2109380.51832 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | 7 | 9 | 11 | 28852 | 10 | |||
| 84483 | 51679 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2005 12:00:00 AM | Permit Number 47959 | 5997000.93217055 | 2089281.06298021 | 37.7165961605731 | -122.452322615904 | (37.7165961605731, -122.452322615904) | 9 | 8 | 6 | 28861 | 24 | ||
| 134259 | 207626 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1261 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995452.06588 | 2106953.75297 | 37.7650321463401 | -122.45895507823 | (37.7650321463401, -122.45895507823) | 15 | 5 | 11 | 56 | 12 | |||
| 54927 | 223447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1261 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003898.74209 | 2100909.80549 | 37.7489188214426 | -122.429309101453 | (37.7489188214426, -122.429309101453) | 2 | 4 | 5 | 28862 | 22 | |||
| 89327 | 207630 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1262 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993959.14351 | 2106898.71187 | 37.7647950868467 | -122.464114690252 | (37.7647950868467, -122.464114690252) | 11 | 5 | 11 | 56 | 12 | |||
| 97010 | 40609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1262 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 10 | Permit Number 41619 | 6005248.55961 | 2120627.08998 | 37.8031340049926 | -122.426044866398 | (37.8031340049926, -122.426044866398) | 13 | 9 | 1 | 28858 | 17 | ||
| 105897 | 38100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1265 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 4 | Permit Number 40271 | 5987674.53427275 | 2106687.60559412 | 37.7638512322332 | -122.485835754297 | (37.7638512322332, -122.485835754297) | 1 | 8 | 3 | 56 | 35 | |
| 161598 | 63432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 127 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1987 12:00:00 AM | 9 | Permit Number 24018 | 6005906.17265772 | 2095879.01582361 | 37.7352188514571 | -122.422010059455 | (37.7352188514571, -122.422010059455) | 2 | 7 | 7 | 28859 | 2 | ||
| 23823 | 45113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1272 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43975 | 5992408.94148991 | 2106797.24353803 | 37.7644270145157 | -122.46946900258 | (37.7644270145157, -122.46946900258) | 11 | 8 | 11 | 56 | 12 | ||
| 118919 | 207575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1272 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992404.81832 | 2106813.55032 | 37.7644715503328 | -122.469484450466 | (37.7644715503328, -122.469484450466) | 11 | 8 | 11 | 56 | 12 | |||
| 119594 | 10207 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1273 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6005836.97194 | 2101563.95801 | 37.7508245136462 | -122.422653168634 | (37.7508245136462, -122.422653168634) | 2 | 4 | 5 | 28859 | 19 | |||
| 106458 | 69062 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1277 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33070 | 5992357.87988852 | 2106769.07253093 | 37.7643467133278 | -122.469643557992 | (37.7643467133278, -122.469643557992) | 11 | 8 | 11 | 56 | 12 | ||
| 100535 | 207654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1279 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992358.22699 | 2106733.7624 | 37.7642497811258 | -122.469639786754 | (37.7642497811258, -122.469639786754) | 11 | 8 | 11 | 56 | 12 | |||
| 11695 | 32589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.7631295295897 | -122.493148331917 | (37.7631295295897, -122.493148331917) | 1 | 8 | 3 | 56 | 35 | |
| 38208 | 207601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | 9 | 8 | 6 | 28861 | 24 | |||
| 63071 | 58747 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30343 | 5995606.37444292 | 2090757.94596432 | 37.7205713407191 | -122.457249650747 | (37.7205713407191, -122.457249650747) | 9 | 8 | 6 | 28861 | 24 | ||
| 65154 | 47258 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||
| 178036 | 117440 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||||
| 144162 | 26619 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1291 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/1998 12:00:00 AM | 6 | 3X3 | 6011585.48367 | 2093253.8886 | 37.728329475411 | -122.402189991188 | (37.728329475411, -122.402189991188) | 10 | 3 | 8 | 58 | 1 | ||
| 27076 | 69940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1295 30th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | 1 | 8 | 3 | 56 | 35 | |
| 133392 | 38112 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1296 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.487755232649 | (37.763186144894, -122.487755232649) | 1 | 8 | 3 | 56 | 35 | ||
| 111171 | 176256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000782.55302 | 2093188.1019 | 37.7275399228115 | -122.439531400151 | (37.7275399228115, -122.439531400151) | 9 | 7 | 6 | 28861 | 25 | |||
| 138935 | 176257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000825.3698 | 2093157.80225 | 37.7274591636907 | -122.439381211582 | (37.7274591636907, -122.439381211582) | 9 | 7 | 6 | 28861 | 25 | |||
| 150420 | 95859 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5993374.31334 | 2114625.40648 | 37.7859767930617 | -122.466699148127 | (37.7859767930617, -122.466699148127) | 11 | 6 | 2 | 54 | 11 | |||
| 48117 | 254837 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992465 | 2114587 | 37.7858188208387 | -122.469842298582 | (37.7858188208387, -122.469842298582) | 11 | 6 | 2 | 54 | 11 | |||
| 42001 | 223564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.411350181559 | (37.7408301058168, -122.411350181559) | 10 | 7 | 7 | 28859 | 2 | |||
| 186402 | 66454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29604 | 6009026.99951004 | 2097886.74358701 | 37.7409071549012 | -122.411361972152 | (37.7409071549012, -122.411361972152) | 10 | 7 | 7 | 28859 | 2 | ||
| 34296 | 90168 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991509.01668 | 2111361.24003 | 37.7769064676002 | -122.472914393951 | (37.7769064676002, -122.472914393951) | 11 | 6 | 2 | 54 | 26 | ||
| 48123 | 90166 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991544.41484 | 2111361.65556 | 37.7769096577615 | -122.472791972421 | (37.7769096577615, -122.472791972421) | 11 | 6 | 2 | 54 | 26 | ||
| 96200 | 90169 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991494.59321 | 2111359.60779 | 37.7769011508917 | -122.472964169589 | (37.7769011508917, -122.472964169589) | 11 | 6 | 2 | 54 | 26 | ||
| 154413 | 90167 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991524.58191 | 2111361.68634 | 37.7769085941456 | -122.472860582152 | (37.7769085941456, -122.472860582152) | 11 | 6 | 2 | 54 | 26 | ||
| 32637 | 122259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991408.07058 | 2113443.99656 | 37.7826193002424 | -122.473415543385 | (37.7826193002424, -122.473415543385) | 11 | 6 | 2 | 54 | 26 | |||
| 137391 | 122258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991414.12952 | 2113444.52375 | 37.7826210986154 | -122.473394620723 | (37.7826210986154, -122.473394620723) | 11 | 6 | 2 | 54 | 26 | |||
| 806 | 189267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Fairfax Ave | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6017011.55747 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | 10 | 3 | 8 | 58 | 1 | |||
| 91032 | 223537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | 2 | 4 | 5 | 63 | 22 | |||
| 35198 | 6735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | 10 | 3 | 8 | 58 | 1 | ||
| 71069 | 6736 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 2 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
| 80495 | 6734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017044.07799 | 2097171.21021 | 37.7393888388325 | -122.383591809817 | (37.7393888388325, -122.383591809817) | 10 | 3 | 8 | 58 | 1 | |||
| 83138 | 6733 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | 10 | 3 | 8 | 58 | 1 | |||
| 89263 | 6737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
| 48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 159416 | 103923 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 179325 | 103921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 187500 | 103915 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 2999 | 94036 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/14/2019 09:52:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | 10 | 3 | 8 | 58 | 1 | |
| 139451 | 189250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Bay Shore Blvd | 4 | : | Tree | Private 2 | 11 | Width 5ft | 6011646.80648 | 2093004.20248 | 37.7276473117623 | -122.401960449138 | (37.7276473117623, -122.401960449138) | 10 | 3 | 8 | 58 | 1 | |||
| 175105 | 189249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Bay Shore Blvd | 3 | : | Tree | Private 2 | 10 | Width 4ft | 6011651.62195 | 2092980.93303 | 37.7275836874237 | -122.401942166815 | (37.7275836874237, -122.401942166815) | 10 | 3 | 8 | 58 | 1 | |||
| 188358 | 64226 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | Permit Number 32010 | 5991523.10149866 | 2113391.31438149 | 37.7824813099729 | -122.473013746659 | (37.7824813099729, -122.473013746659) | 11 | 6 | 2 | 54 | 26 | ||
| 65679 | 126541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007346.83481 | 2121683.49611 | 37.8061529931217 | -122.418858679793 | (37.8061529931217, -122.418858679793) | 5 | 1 | 1 | 28858 | 32 | |||
| 124643 | 95601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 131 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2011 12:00:00 AM | 2 | Permit Number 767201 | 5990817.89228 | 2114523.5069 | 37.78554914201 | -122.475536133375 | (37.78554914201, -122.475536133375) | 11 | 6 | 2 | 54 | 26 | ||
| 189927 | 58574 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 131 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1992 12:00:00 AM | Permit Number 30452 | 5997850.5042079 | 2106776.22062192 | 37.7646822655699 | -122.450646713878 | (37.7646822655699, -122.450646713878) | 15 | 5 | 11 | 29492 | 9 | ||
| 127209 | 207632 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1314 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994271.86788 | 2106534.82687 | 37.763813972349 | -122.463006662539 | (37.763813972349, -122.463006662539) | 1 | 5 | 11 | 56 | 12 | |||
| 98021 | 244489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1314 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000169.4163 | 2109230.0491 | 37.7715523247212 | -122.442802449862 | (37.7715523247212, -122.442802449862) | 15 | 5 | 11 | 29492 | 9 | |||
| 52892 | 64551 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1315 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25434 | 6016281.43381852 | 2094844.2486814 | 37.7329572884599 | -122.386066550856 | (37.7329572884599, -122.386066550856) | 10 | 3 | 8 | 58 | 1 | ||
| 150505 | 244490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1316 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000139.8345 | 2109225.3958 | 37.7715378614524 | -122.442904440425 | (37.7715378614524, -122.442904440425) | 15 | 5 | 11 | 29492 | 9 | |||
| 172916 | 62981 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1317 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 11 | Permit Number 23371 | 6007225.76848 | 2118431.56402 | 37.7972171916732 | -122.419046847643 | (37.7972171916732, -122.419046847643) | 5 | 1 | 10 | 28858 | 32 | |
| 99906 | 61867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1318 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1999 12:00:00 AM | Permit Number 21907 | 6010305.63286425 | 2101528.54455683 | 37.7509783771367 | -122.407197563662 | (37.7509783771367, -122.407197563662) | 2 | 4 | 7 | 28859 | 19 | ||
| 188777 | 67134 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1319 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30557 | 5994845.70633792 | 2106566.77166106 | 37.7639347220406 | -122.461024259768 | (37.7639347220406, -122.461024259768) | 15 | 5 | 11 | 56 | 12 | ||
| 21319 | 91088 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207 | 2088751 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | 9 | 8 | 6 | 64 | 24 | ||
| 115511 | 68221 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1320 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 8 | Permit Number 32011 | 5991372.40112 | 2113442.77696 | 37.7826138859717 | -122.473538854201 | (37.7826138859717, -122.473538854201) | 11 | 6 | 2 | 54 | 26 | |
| 58360 | 207655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994849.00569 | 2106528.59646 | 37.7638300927003 | -122.461010081256 | (37.7638300927003, -122.461010081256) | 15 | 5 | 11 | 56 | 12 | |||
| 49386 | 88828 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 80102 | 88825 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 125816 | 88827 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 173356 | 88826 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 42483 | 83354 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1322-24 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50904 | 5992731.01277957 | 2106452.183429 | 37.763498178334 | -122.468329951548 | (37.763498178334, -122.468329951548) | 1 | 8 | 11 | 56 | 12 |
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) );