trees
230 rows where Fire Prevention Districts = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 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 | ||
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 | |||
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 | ||
84552 | 46904 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44960 | 5994548.84037989 | 2106162.48962063 | 37.7628075813013 | -122.462021703411 | (37.7628075813013, -122.462021703411) | 1 | 5 | 11 | 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 | ||
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 | |
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 | ||
116668 | 54371 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50890 | 5994261.74442721 | 2105485.85462575 | 37.760933184118 | -122.46296556602 | (37.760933184118, -122.46296556602) | 1 | 5 | 11 | 56 | 12 | ||
116965 | 65907 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1385 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28916 | 5993931.02559851 | 2106089.21026455 | 37.7625707863634 | -122.464153170818 | (37.7625707863634, -122.464153170818) | 1 | 5 | 11 | 56 | 12 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||||
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 | ||
189577 | 35081 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 4 | 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 | ||
191923 | 62765 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23119 | 5993354.34924416 | 2103942.93195158 | 37.7566444112368 | -122.465991704098 | (37.7566444112368, -122.465991704098) | 1 | 8 | 4 | 56 | 12 | ||
192643 | 64883 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1989 12:00:00 AM | Permit Number 25908 | 5990736.71325553 | 2098846.97706037 | 37.7425008919022 | -122.474672428109 | (37.7425008919022, -122.474672428109) | 1 | 8 | 4 | 29491 | 40 | ||
18581 | 207557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 438 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993090.30731 | 2105981.36839 | 37.7622261896015 | -122.467053045158 | (37.7622261896015, -122.467053045158) | 1 | 8 | 11 | 56 | 12 | |||
31204 | 207694 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991855.32533 | 2096348.4574 | 37.7357053452243 | -122.470622695389 | (37.7357053452243, -122.470622695389) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
48490 | 207572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1640 09th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 1 | Width 6ft | 5993421.18819 | 2104299.1531 | 37.7576263578793 | -122.465786433692 | (37.7576263578793, -122.465786433692) | 1 | 8 | 4 | 56 | 12 | |||
57254 | 207697 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993442.50262 | 2102313.15594 | 37.7521745516283 | -122.465568443448 | (37.7521745516283, -122.465568443448) | 1 | 8 | 4 | 29491 | 12 | |||
78086 | 207586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1917 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993746.75792 | 2102455.06491 | 37.7525817412531 | -122.464526593251 | (37.7525817412531, -122.464526593251) | 1 | 8 | 4 | 29491 | 12 | |||
81670 | 207681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991411.6864 | 2097337.95206 | 37.738396582641 | -122.472228618364 | (37.738396582641, -122.472228618364) | 1 | 8 | 4 | 29491 | 40 | |||
89620 | 207671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1734 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990626.77188 | 2103577.88918 | 37.7554843697179 | -122.475397903889 | (37.7554843697179, -122.475397903889) | 1 | 8 | 4 | 56 | 12 | |||
129939 | 207696 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994014.568 | 2105145.1879 | 37.7599835610189 | -122.463795707001 | (37.7599835610189, -122.463795707001) | 1 | 5 | 4 | 56 | 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 | |
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 | |||
169314 | 113391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
908 | 207538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993510.99578 | 2106611.92865 | 37.7639818164203 | -122.465643867796 | (37.7639818164203, -122.465643867796) | 1 | 8 | 11 | 56 | 12 | |||
13393 | 207553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993922.26035 | 2106313.56882 | 37.7631863112193 | -122.464199775125 | (37.7631863112193, -122.464199775125) | 1 | 5 | 11 | 56 | 12 | |||
48236 | 61889 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.7580590010432 | -122.482191490983 | (37.7580590010432, -122.482191490983) | 1 | 8 | 3 | 56 | 35 | |
53137 | 64881 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1989 12:00:00 AM | 10 | 3X3 | Permit Number 25903 | 5990675.59164589 | 2098407.0770941 | 37.7412894981021 | -122.474851664533 | (37.7412894981021, -122.474851664533) | 1 | 8 | 4 | 29491 | 40 |
109418 | 181738 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 2803 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5986967.0668 | 2107072.067 | 37.7648656060734 | -122.488310893002 | (37.7648656060734, -122.488310893002) | 1 | 8 | 3 | 56 | 35 | |||
113891 | 99647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985628.3746 | 2103030.4107 | 37.7536901409617 | -122.492643333781 | (37.7536901409617, -122.492643333781) | 1 | 8 | 3 | 56 | 35 | ||
124224 | 207580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2638 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991779.82441 | 2097449.35591 | 37.7387237676844 | -122.470963901766 | (37.7387237676844, -122.470963901766) | 1 | 8 | 4 | 29491 | 40 | |||
169630 | 99645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985624.4813 | 2103086.5856 | 37.7538441541808 | -122.492660934457 | (37.7538441541808, -122.492660934457) | 1 | 8 | 3 | 56 | 35 | ||
86969 | 207552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993922.19207 | 2106326.17113 | 37.7632209099368 | -122.464200926233 | (37.7632209099368, -122.464200926233) | 1 | 5 | 11 | 56 | 12 | |||
115355 | 99644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.492664250547 | (37.7538960444293, -122.492664250547) | 1 | 8 | 3 | 56 | 35 | ||
132333 | 207690 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 642 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991148.86446 | 2099110.57767 | 37.7432485446942 | -122.473266566413 | (37.7432485446942, -122.473266566413) | 1 | 8 | 4 | 29491 | 40 | |||
143799 | 207554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993924.42937 | 2106289.97984 | 37.7631216670542 | -122.46419056067 | (37.7631216670542, -122.46419056067) | 1 | 5 | 11 | 56 | 12 | |||
151465 | 207550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993920.73068 | 2106351.7347 | 37.7632910165944 | -122.464207836628 | (37.7632910165944, -122.464207836628) | 1 | 5 | 11 | 56 | 12 | |||
152784 | 207634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994548.55797 | 2106167.4368 | 37.7628211487125 | -122.462023038935 | (37.7628211487125, -122.462023038935) | 1 | 5 | 11 | 56 | 12 | |||
159154 | 207551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993920.84097 | 2106341.12127 | 37.7632618812439 | -122.464206684615 | (37.7632618812439, -122.464206684615) | 1 | 5 | 11 | 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 | |||
180819 | 207683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2430 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990785.45213 | 2098828.98971 | 37.7424543273065 | -122.474502592844 | (37.7424543273065, -122.474502592844) | 1 | 8 | 4 | 29491 | 40 | |||
24617 | 207548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993918.37336 | 2106436.18995 | 37.7635227727814 | -122.464222121451 | (37.7635227727814, -122.464222121451) | 1 | 5 | 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) );