trees
312 rows where Police Districts = 8 and 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36200 | 207691 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992956.08252 | 2099027.95475 | 37.7431261613357 | -122.46701172672 | (37.7431261613357, -122.46701172672) | 1 | 8 | 4 | 59 | 40 | |||
| 56204 | 207693 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992963.53977 | 2099050.31915 | 37.7431879987389 | -122.466987567326 | (37.7431879987389, -122.466987567326) | 1 | 8 | 4 | 59 | 40 | |||
| 59586 | 52350 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 153388 | 207692 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992959.6562 | 2099040.51355 | 37.7431608508894 | -122.467000282841 | (37.7431608508894, -122.467000282841) | 1 | 8 | 4 | 59 | 40 | |||
| 158823 | 52349 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 165563 | 52351 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 46447 | 175836 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994366.58552 | 2086543.72285 | 37.7089288002067 | -122.46122985489 | (37.7089288002067, -122.46122985489) | 9 | 8 | 6 | 28861 | 25 | |||
| 164864 | 216659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1022 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:44:00 AM | 3 | Width 4ft | 5995946.33237 | 2090713.9624 | 37.7204700913979 | -122.456071352615 | (37.7204700913979, -122.456071352615) | 9 | 8 | 6 | 28861 | 24 | ||
| 43567 | 30935 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.7216856645565 | -122.456226438915 | (37.7216856645565, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
| 191324 | 30936 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.99468 | 2091121.8923 | 37.7215880844914 | -122.456226438915 | (37.7215880844914, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
| 188987 | 216737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.50939 | 37.7184704425356 | -122.454167365558 | (37.7184704425356, -122.454167365558) | 9 | 8 | 6 | 28861 | 24 | ||
| 31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 146520 | 81459 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1119 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49734 | 5989696.8991 | 2098996.9987 | 37.7428525058761 | -122.47827872443 | (37.7428525058761, -122.47827872443) | 1 | 8 | 3 | 29491 | 35 | |
| 40210 | 84682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | 9 | 8 | 6 | 28861 | 24 | ||
| 170509 | 207602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996198.32663 | 2090727.04827 | 37.7205204831134 | -122.455201239645 | (37.7205204831134, -122.455201239645) | 9 | 8 | 6 | 28861 | 24 | |||
| 153698 | 207603 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996240.91229 | 2090722.7587 | 37.7205111481621 | -122.455053725648 | (37.7205111481621, -122.455053725648) | 9 | 8 | 6 | 28861 | 24 | |||
| 176058 | 81911 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3X3 | Permit Number 49718 | 5996247.30096369 | 2090708.70815365 | 37.7204729351862 | -122.455030627418 | (37.7204729351862, -122.455030627418) | 9 | 8 | 6 | 28861 | 24 | ||
| 8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
| 495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
| 77403 | 207649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992350.24318 | 2107007.29573 | 37.7650003696822 | -122.469687315036 | (37.7650003696822, -122.469687315036) | 11 | 8 | 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 |
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 139287 | 83969 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1322-24 11th Ave | 1 | 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 | ||
| 108049 | 207559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992726.03942 | 2106443.21953 | 37.763473278578 | -122.468346500487 | (37.763473278578, -122.468346500487) | 1 | 8 | 11 | 56 | 12 | |||
| 160195 | 207558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992727.49382 | 2106432.28501 | 37.7634433392744 | -122.468340674684 | (37.7634433392744, -122.468340674684) | 1 | 8 | 11 | 56 | 12 | |||
| 177087 | 207531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1325 18th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5990492.61494 | 2106135.12336 | 37.7624980762427 | -122.476048615548 | (37.7624980762427, -122.476048615548) | 1 | 8 | 3 | 56 | 12 | |||
| 163323 | 207556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1333 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5993304.33349 | 2106388.43984 | 37.7633562525083 | -122.46634240179 | (37.7633562525083, -122.46634240179) | 1 | 8 | 11 | 56 | 12 | |||
| 5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
| 8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
| 12755 | 214559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1342 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | 11 | 8 | 11 | 56 | 12 | ||
| 154557 | 214493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781360 | 5991433.81997 | 2106159.32578 | 37.7626190602323 | -122.47279512831 | (37.7626190602323, -122.47279512831) | 1 | 8 | 11 | 56 | 12 |
| 147442 | 182142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5988379.3786 | 2105646.146 | 37.7610327154794 | -122.483321592218 | (37.7610327154794, -122.483321592218) | 1 | 8 | 3 | 56 | 35 | |||
| 136562 | 46899 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1422 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44954 | 5991823.56760325 | 2105741.5278605 | 37.7614944523713 | -122.471416700261 | (37.7614944523713, -122.471416700261) | 1 | 8 | 4 | 56 | 12 | ||
| 191771 | 207536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1422 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991820.20399 | 2105720.01268 | 37.7614351827994 | -122.471426765747 | (37.7614351827994, -122.471426765747) | 1 | 8 | 4 | 56 | 12 | |||
| 106387 | 55390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1430 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53915 | 5993375.48106326 | 2105742.52731258 | 37.7615868508254 | -122.466049388804 | (37.7615868508254, -122.466049388804) | 1 | 8 | 11 | 56 | 12 | |
| 194475 | 207568 | Prune Opt Out 3 | Eriobotrya deflexa :: Bronze Loquat 8 | 1430 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 788015 | 5993375.17513 | 2105731.36286 | 37.7615561785078 | -122.466049635587 | (37.7615561785078, -122.466049635587) | 1 | 8 | 11 | 56 | 12 | ||
| 160738 | 207562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1441 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992705.62394 | 2105635.27158 | 37.7612536870231 | -122.4683583275 | (37.7612536870231, -122.4683583275) | 1 | 8 | 4 | 56 | 12 | |||
| 104971 | 66338 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1447 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29459 | 5986477.48679656 | 2105401.18553313 | 37.7602492515012 | -122.489881304154 | (37.7602492515012, -122.489881304154) | 1 | 8 | 3 | 56 | 35 | ||
| 81292 | 207563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1453 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993327.97162 | 2105609.42801 | 37.7612186539421 | -122.466204030294 | (37.7612186539421, -122.466204030294) | 1 | 8 | 4 | 56 | 12 | |||
| 59529 | 66339 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | 1 | 8 | 3 | 56 | 35 | ||
| 103024 | 207564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1457 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993330.19725 | 2105578.31991 | 37.7611333676392 | -122.46619407211 | (37.7611333676392, -122.46619407211) | 1 | 8 | 4 | 56 | 12 | |||
| 48777 | 54276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/1972 12:00:00 AM | 5x6 | Permit Number 10029 | 5993329.78711521 | 2105558.33296163 | 37.761078465039 | -122.466194038055 | (37.761078465039, -122.466194038055) | 1 | 8 | 4 | 56 | 12 | ||
| 74169 | 207565 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5993329.70544 | 2105554.91485 | 37.7610690750853 | -122.466194072125 | (37.7610690750853, -122.466194072125) | 1 | 8 | 4 | 56 | 12 | |||
| 26247 | 207604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 146 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996244.76197 | 2090857.98578 | 37.7208826706709 | -122.45505018502 | (37.7208826706709, -122.45505018502) | 9 | 8 | 6 | 28861 | 24 | |||
| 128120 | 207566 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1465 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993331.08215 | 2105529.08118 | 37.7609982220075 | -122.466187433302 | (37.7609982220075, -122.466187433302) | 1 | 8 | 4 | 56 | 12 | |||
| 61104 | 182266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986219.9712 | 2105233.6732 | 37.759774269018 | -122.490759591455 | (37.759774269018, -122.490759591455) | 1 | 8 | 3 | 56 | 35 | |||
| 61559 | 92240 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.490674680595 | (37.7597856659048, -122.490674680595) | 1 | 8 | 3 | 56 | 35 | |||
| 32358 | 207561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992400.09167 | 2105443.15658 | 37.7607085377924 | -122.469401040143 | (37.7607085377924, -122.469401040143) | 1 | 8 | 4 | 56 | 12 | |||
| 157918 | 67731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774581 | 5992402.99511967 | 2105448.3839166 | 37.7607230584725 | -122.46939137901 | (37.7607230584725, -122.46939137901) | 1 | 8 | 4 | 56 | 12 | |
| 19415 | 207567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993332.90632 | 2105478.86698 | 37.7608604521776 | -122.466177475135 | (37.7608604521776, -122.466177475135) | 1 | 8 | 4 | 56 | 12 | |||
| 158740 | 94125 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1478 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2010 12:00:00 AM | 3x3 | Permit Number 53485 | 5986246.3 | 2105188 | 37.7596504010073 | -122.490665173884 | (37.7596504010073, -122.490665173884) | 1 | 8 | 3 | 56 | 35 | |||
| 98336 | 203684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1494 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 778446 | 5991831.94405 | 2105275.25669 | 37.7602146795817 | -122.471353755176 | (37.7602146795817, -122.471353755176) | 1 | 8 | 4 | 56 | 12 | |
| 91286 | 84679 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49720 | 5996250.33825299 | 2090885.9667732 | 37.7209598197785 | -122.455032930449 | (37.7209598197785, -122.455032930449) | 9 | 8 | 6 | 28861 | 24 | ||
| 146682 | 207647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1520 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992154.93945 | 2105081.8462 | 37.7597023043237 | -122.470222592396 | (37.7597023043237, -122.470222592396) | 1 | 8 | 4 | 56 | 12 | |||
| 148596 | 38856 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | 1 | 8 | 3 | 56 | 35 | |
| 81776 | 207535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1531 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990841.25621 | 2104949.97528 | 37.7592641852056 | -122.474756299665 | (37.7592641852056, -122.474756299665) | 1 | 8 | 4 | 56 | 12 | |||
| 192449 | 207534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1531 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990839.12843 | 2104968.89337 | 37.7593160059549 | -122.474765039286 | (37.7593160059549, -122.474765039286) | 1 | 8 | 4 | 56 | 12 | |||
| 97678 | 92546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1534 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52889 | 5985305.6485 | 2104749.3445 | 37.7583909829975 | -122.493886044317 | (37.7583909829975, -122.493886044317) | 1 | 8 | 3 | 56 | 35 | |
| 183880 | 207638 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1538 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993396.48962 | 2104999.12354 | 37.7595468700202 | -122.465922710668 | (37.7595468700202, -122.465922710668) | 1 | 8 | 4 | 56 | 12 | |||
| 159603 | 38858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1539 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40685 | 5989290.38339079 | 2104868.56062873 | 37.7589506522356 | -122.480113948201 | (37.7589506522356, -122.480113948201) | 1 | 8 | 3 | 56 | 35 | |
| 17913 | 35078 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 25797 | 35077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 59509 | 35073 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 74034 | 35084 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 75288 | 35080 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 84043 | 35075 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 93466 | 35076 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 127181 | 35074 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 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) );