trees
312 rows where Police Districts = 8 and qSpecies_id = 8 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
14053 | 62766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1988 12:00:00 AM | Permit Number 25290 | 5993348.39587904 | 2103942.72221653 | 37.7566434919089 | -122.466012277578 | (37.7566434919089, -122.466012277578) | 1 | 8 | 4 | 56 | 12 | ||
14205 | 79589 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1746 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53534 | 5993448.84463132 | 2103598.20779392 | 37.7557033388246 | -122.465639863764 | (37.7557033388246, -122.465639863764) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||
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 | ||
23668 | 66231 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/1994 12:00:00 AM | Permit Number 29328 | 5997721.47171687 | 2090151.04761265 | 37.7190261896858 | -122.449894746819 | (37.7190261896858, -122.449894746819) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
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 | ||
24551 | 62760 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23114 | 5993046.38592213 | 2104560.1415905 | 37.7583213372073 | -122.467101616449 | (37.7583213372073, -122.467101616449) | 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 | ||
25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 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 | ||
28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
30539 | 67015 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | 9 | 8 | 6 | 28861 | 24 | ||
32297 | 48573 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
32978 | 66244 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | 9 | 8 | 6 | 28861 | 24 | ||
34300 | 92278 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52728 | 5991376 | 2097700 | 37.7393886087034 | -122.472378389349 | (37.7393886087034, -122.472378389349) | 1 | 8 | 4 | 29491 | 40 | ||
36832 | 64890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25916 | 5990747.37657328 | 2098534.47311176 | 37.7416434544453 | -122.474612755594 | (37.7416434544453, -122.474612755594) | 1 | 8 | 4 | 29491 | 40 | ||
37755 | 39665 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41055 | 5993542.26347395 | 2090641.85281267 | 37.7201338116039 | -122.464376148313 | (37.7201338116039, -122.464376148313) | 9 | 8 | 6 | 64 | 24 | ||
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 | ||
40773 | 41963 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46995 | 5993511.89759083 | 2094752.0237459 | 37.73141758734 | -122.464779433581 | (37.73141758734, -122.464779433581) | 9 | 8 | 4 | 59 | 40 | ||
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 | ||
46775 | 44051 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1714 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43580 | 5993441.9028453 | 2103807.69125105 | 37.7562781258297 | -122.465679089291 | (37.7562781258297, -122.465679089291) | 1 | 8 | 4 | 56 | 12 | |||
48084 | 39666 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
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 | ||
49669 | 39646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.5137176 | 2090402.3957614 | 37.7195128594848 | -122.462166418076 | (37.7195128594848, -122.462166418076) | 9 | 8 | 6 | 28861 | 24 | ||
53966 | 37491 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39960 | 5990646.15475208 | 2106518.49529305 | 37.7635596145943 | -122.475545577058 | (37.7635596145943, -122.475545577058) | 1 | 8 | 3 | 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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
67962 | 33202 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51141 | 5994405.76875734 | 2099294.92155065 | 37.743942754277 | -122.462018491778 | (37.743942754277, -122.462018491778) | 1 | 8 | 4 | 59 | 40 | ||
68593 | 50890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2242 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47400 | 5991328.18651744 | 2100148.47255099 | 37.7461087183508 | -122.472722183475 | (37.7461087183508, -122.472722183475) | 1 | 8 | 4 | 29491 | 40 | ||
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 | ||
78686 | 83962 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 626 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767447 | 5992636.32789452 | 2105971.3213845 | 37.7621723886495 | -122.46862244319 | (37.7621723886495, -122.46862244319) | 1 | 8 | 11 | 56 | 12 | |
79788 | 82191 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1995 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49854 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | 1 | 8 | 3 | 29491 | 35 | ||
80598 | 37489 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1639 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39958 | 5990687.69704484 | 2106519.91830078 | 37.7635659299099 | -122.475402000804 | (37.7635659299099, -122.475402000804) | 1 | 8 | 3 | 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 | ||
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 | ||
87941 | 52641 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 171@ LAKEVIEW Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2006 12:00:00 AM | Permit Number 48723 | 5997085.87939987 | 2088850.31270085 | 37.7154182864299 | -122.451997937847 | (37.7154182864299, -122.451997937847) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||
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 | ||
99353 | 48571 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
102682 | 50911 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47414 | 5990675.27966813 | 2102143.29452462 | 37.751548162175 | -122.47512542803 | (37.751548162175, -122.47512542803) | 1 | 8 | 4 | 29491 | 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 | ||
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 | |
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 | ||
111961 | 84637 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2475 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52714 | 5991692.33939789 | 2098594.23862083 | 37.741862263783 | -122.471349776517 | (37.741862263783, -122.471349776517) | 1 | 8 | 4 | 29491 | 40 | ||
112357 | 52984 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | Permit Number 49125 | 5994735.92329309 | 2091572.62185735 | 37.7227582139901 | -122.460317500192 | (37.7227582139901, -122.460317500192) | 9 | 8 | 4 | 28861 | 24 | |||
113126 | 65476 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/1992 12:00:00 AM | Permit Number 28357 | 5994791.83411089 | 2091786.89258453 | 37.7233497659919 | -122.460139745717 | (37.7233497659919, -122.460139745717) | 9 | 8 | 4 | 28861 | 24 | ||
122742 | 110457 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775373 | 5991635.3 | 2099042.5 | 37.7430897750827 | -122.471579655796 | (37.7430897750827, -122.471579655796) | 1 | 8 | 4 | 29491 | 40 | |||
123359 | 39647 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 76 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41041 | 5994176.75103926 | 2090428.14003501 | 37.719583560751 | -122.462167463801 | (37.719583560751, -122.462167463801) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
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 | ||
134104 | 49431 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 430-438 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2006 12:00:00 AM | 3x3 | Permit Number 46370 | 5993243.20305227 | 2105992.08375012 | 37.7622644352537 | -122.466525019945 | (37.7622644352537, -122.466525019945) | 1 | 8 | 11 | 56 | 12 | ||
135849 | 65483 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28367 | 5994794.44790156 | 2091930.41721855 | 37.7237440004853 | -122.460141103458 | (37.7237440004853, -122.460141103458) | 9 | 8 | 4 | 28861 | 24 | ||
136129 | 60469 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20062 | 5996935.23090665 | 2089095.72294646 | 37.7160834957462 | -122.452536343277 | (37.7160834957462, -122.452536343277) | 9 | 8 | 6 | 28861 | 24 | ||
136449 | 65460 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28338 | 5995896.95851716 | 2090334.96533864 | 37.7194266209016 | -122.45621463281 | (37.7194266209016, -122.45621463281) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
138243 | 49336 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2210& RIVERA 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2003 12:00:00 AM | Permit Number 46330 | 5982985.87424051 | 2100072.90742452 | 37.7454147931586 | -122.501562767219 | (37.7454147931586, -122.501562767219) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
141241 | 92271 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.470780259887 | (37.7354220869049, -122.470780259887) | 1 | 8 | 4 | 59 | 40 | ||
141323 | 94854 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 71 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52718 | 5992899.3 | 2098697.8 | 37.7422163623862 | -122.467184064018 | (37.7422163623862, -122.467184064018) | 1 | 8 | 4 | 59 | 40 | |
142819 | 64850 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | Permit Number 25865 | 5990734.04742599 | 2098925.10305057 | 37.7427152512508 | -122.474687346453 | (37.7427152512508, -122.474687346453) | 1 | 8 | 4 | 29491 | 40 | ||
145092 | 110714 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 FAXON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994812 | 2091798 | 37.7233814241751 | -122.460070840792 | (37.7233814241751, -122.460070840792) | 9 | 8 | 4 | 28861 | 24 | ||||
145695 | 65471 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28352 | 5995649.70460039 | 2090232.90843382 | 37.7191322005073 | -122.457061914585 | (37.7191322005073, -122.457061914585) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
146588 | 95613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 433 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52567 | 5993573 | 2105260 | 37.7602733497891 | -122.46533120514 | (37.7602733497891, -122.46533120514) | 1 | 8 | 4 | 56 | 12 | |
147599 | 35066 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1767 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38621 | 5993091.79613018 | 2103456.13602806 | 37.7552926457444 | -122.466864312925 | (37.7552926457444, -122.466864312925) | 1 | 8 | 4 | 56 | 12 | ||
148040 | 50894 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47404 | 5990914.17502957 | 2104244.6173879 | 37.7573316845763 | -122.47445263879 | (37.7573316845763, -122.47445263879) | 1 | 8 | 4 | 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 | ||
158089 | 84476 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 71 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52718 | 5992866.3330519 | 2098645.80444652 | 37.7420716926906 | -122.467294272683 | (37.7420716926906, -122.467294272683) | 1 | 8 | 4 | 59 | 40 | |
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 | |||
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 | |||
159143 | 94155 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53541 | 5990589.8 | 2102714 | 37.7531102147949 | -122.475462689636 | (37.7531102147949, -122.475462689636) | 1 | 8 | 4 | 56 | 12 | ||
163041 | 92283 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 345 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52731 | 5991916 | 2097076 | 37.7377065018101 | -122.470465891371 | (37.7377065018101, -122.470465891371) | 1 | 8 | 4 | 59 | 40 | ||
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 | |||
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 | |||
166499 | 35079 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 8 | 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 | ||
169814 | 50895 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47404 | 5990914.17502957 | 2104244.6173879 | 37.7573316845763 | -122.47445263879 | (37.7573316845763, -122.47445263879) | 1 | 8 | 4 | 56 | 12 | ||
170647 | 64892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25918 | 5990741.15630477 | 2098716.76707671 | 37.7421436262999 | -122.474647564393 | (37.7421436262999, -122.474647564393) | 1 | 8 | 4 | 29491 | 40 | ||
171970 | 64849 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2427 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | Permit Number 25864 | 5990735.82464568 | 2098873.0190571 | 37.7425723450195 | -122.474677400881 | (37.7425723450195, -122.474677400881) | 1 | 8 | 4 | 29491 | 40 | ||
173568 | 62767 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 330 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23121 | 5993312.675705 | 2103941.46380685 | 37.7566379758683 | -122.466135718391 | (37.7566379758683, -122.466135718391) | 1 | 8 | 4 | 56 | 12 | ||
174081 | 101247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9951 | 5993550 | 2106615 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | 1 | 8 | 11 | 56 | 12 | ||||
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 | ||
176884 | 39667 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
177300 | 60455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 60 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20041 | 5997245.01433776 | 2089631.74975866 | 37.7175730452663 | -122.451504230583 | (37.7175730452663, -122.451504230583) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||||
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 | ||
180088 | 51547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2475 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2005 12:00:00 AM | Permit Number 47846 | 5990746.48796302 | 2098560.51512066 | 37.7417149076087 | -122.474617728253 | (37.7417149076087, -122.474617728253) | 1 | 8 | 4 | 29491 | 40 | ||
183774 | 115293 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644 | 37.7474306230823 | -122.475067792345 | (37.7474306230823, -122.475067792345) | 1 | 8 | 4 | 29491 | 40 | |||
186659 | 54213 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9951 | 5993547.73398631 | 2106617.88649247 | 37.7640002940645 | -122.465517235123 | (37.7640002940645, -122.465517235123) | 1 | 8 | 11 | 56 | 12 | |||
187188 | 64891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2462 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25917 | 5990795.79188789 | 2098640.41442028 | 37.741937147211 | -122.474453082867 | (37.741937147211, -122.474453082867) | 1 | 8 | 4 | 29491 | 40 | ||
187921 | 62758 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1602 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23109 | 5992796.63106595 | 2104544.17081443 | 37.7582630660405 | -122.46796420941 | (37.7582630660405, -122.46796420941) | 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) );