trees

2,421 rows where qSpecies_id = 8 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
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
37767 35299 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4128 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1998 12:00:00 AM     Permit Number 38772 6002342.17007059 2101820.0635556 37.7513299284774 -122.434756807393 (37.7513299284774, -122.434756807393) 2 4 5 28862 22
37859 46993 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2011 26th St 10 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM     Permit Number 44999 6012426.60175733 2101420.79231292 37.7508009841444 -122.399855433268 (37.7508009841444, -122.399855433268) 10 3 8 28856 1
38088 99382 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
38276 52807 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 25@ TEXAS Sierra St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48835 6013772.92448179 2104112.24559711 37.7582661000564 -122.39538822301 (37.7582661000564, -122.39538822301) 10 3 8 28856 29
38299 66118 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 262 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29177 6004443.55987266 2109134.3816324 37.771532383715 -122.428011127655 (37.771532383715, -122.428011127655) 7 9 11 28852 10
38466 49860 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 338 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46630 6003649.21999567 2095274.80996329 37.7334322896584 -122.429770085042 (37.7334322896584, -122.429770085042) 2 7 5 28861 25
38592 45299 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2 Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44138 6007485.11382992 2096559.26498899 37.7371755914125 -122.416599241748 (37.7371755914125, -122.416599241748) 2 7 7 28859 2
38599 48554 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 378 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2015 12:00:00 AM     Permit Number 776479 5990306.99232217 2112830.037025 37.7808697161231 -122.477179880009 (37.7808697161231, -122.477179880009) 11 6 2 55 26
38788 46109 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 798 Stanyan St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2001 12:00:00 AM   3x3 Permit Number 44472 5997167.07493712 2107760.6930909 37.767346232554 -122.453081574039 (37.767346232554, -122.453081574039) 15 5 11 29492 9
39029 103456 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 410 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003658 2091068 37.721881827041 -122.429439831937 (37.721881827041, -122.429439831937) 9 7 6 28861 5
39751 96590 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
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
41732 114444 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 140 LOOMIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010781 2097775 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
42029 254843 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1814 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3   5993025 2112122 37.7790829564028 -122.467725532477 (37.7790829564028, -122.467725532477) 11 6 2 54 11
42072 39611 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 786 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2001 12:00:00 AM   6x6 Permit Number 44486 5998641.21928003 2107708.61027258 37.7672876005221 -122.447978986539 (37.7672876005221, -122.447978986539) 15 5 11 29492 9
42483 83354 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1322-24 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50904 5992731.01277957 2106452.183429 37.763498178334 -122.468329951548 (37.763498178334, -122.468329951548) 1 8 11 56 12
42729 64533 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1423 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM     Permit Number 25415 6015974.60065069 2094744.26862441 37.732665776815 -122.387120391311 (37.732665776815, -122.387120391311) 10 3 8 58 1
42967 173911 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 8 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6006450.1 2109317.2 37.7721476754667 -122.421083366581 (37.7721476754667, -122.421083366581) 8 2 9 28853 19
43045 63309 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 320 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1987 12:00:00 AM     Permit Number 23875 6009653.46041158 2099624.96602916 37.7457150505348 -122.409318529175 (37.7457150505348, -122.409318529175) 2 7 7 28859 2
43076 50758 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 286 Willard St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2004 12:00:00 AM   3x3 Permit Number 47298 5996260.1 2110808.5 37.7756626959421 -122.456439068917 (37.7756626959421, -122.456439068917) 11 6 2 54 16
43995 67217 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 412 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1992 12:00:00 AM     Permit Number 30673 6007859.73782149 2096940.24415247 37.7382427386023 -122.415330954317 (37.7382427386023, -122.415330954317) 2 7 7 28859 2
44731 112816 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 575 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2015 12:00:00 AM     Permit Number 773547 5992490.3 2111549.9 37.7774812369392 -122.46953360311 (37.7774812369392, -122.46953360311) 11 6 2 54 11
44789 44020 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 67 Ruth St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2000 12:00:00 AM     Permit Number 43561 6001434.84212338 2091667.66659412 37.7234022554793 -122.437167620555 (37.7234022554793, -122.437167620555) 9 7 6 28861 25
44908 96593 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
45628 251771 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
45695 64260 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 170 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/1988 12:00:00 AM     Permit Number 25062 6009914.7515977 2100087.93471467 37.7470008969248 -122.408447669408 (37.7470008969248, -122.408447669408) 2 7 7 28859 2
45768 47096 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 108 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45078 5996526.30490934 2112305.63939243 37.7797887262832 -122.455626444814 (37.7797887262832, -122.455626444814) 15 6 2 54 16
46236 87868 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 65 Avila St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM   3x3 Permit Number 50830 6001059 2119911 37.8009301387701 -122.440491523393 (37.8009301387701, -122.440491523393) 13 9 1 57 17
46240 49866 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
46394 66647 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 972 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/2000 12:00:00 AM     Permit Number 29858 6010191.86940681 2103559.76448884 37.756549288119 -122.407734178809 (37.756549288119, -122.407734178809) 2 4 7 28859 19
46431 173910 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6006450.1 2109317.2 37.7721476754667 -122.421083366581 (37.7721476754667, -122.421083366581) 8 2 9 28853 19
46531 251773 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 90x Seville St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002045 2087474 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533) 9 7 6 28861 5
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
47805 46326 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3649 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2002 12:00:00 AM     Permit Number 44579 6005434.40207527 2102522.16800234 37.7534328160504 -122.424113430233 (37.7534328160504, -122.424113430233) 2 4 5 28859 19
47946 46990 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2011 26th St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM     Permit Number 44999 6012426.60175733 2101420.79231292 37.7508009841444 -122.399855433268 (37.7508009841444, -122.399855433268) 10 3 8 28856 1
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
48117 254837 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 130 11th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3   5992465 2114587 37.7858188208387 -122.469842298582 (37.7858188208387, -122.469842298582) 11 6 2 54 11
48287 50062 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 259 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46792 6004623.22870051 2103939.22214247 37.7572778811094 -122.427019561527 (37.7572778811094, -122.427019561527) 2 4 5 28862 3
48749 103917 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 4 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
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
49203 63377 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 308 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23957 6006914.1385317 2095742.66094638 37.7349012482628 -122.418515480064 (37.7349012482628, -122.418515480064) 2 7 7 28859 2
49362 63315 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 391 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/1987 12:00:00 AM     Permit Number 23882 6009191.36429374 2100247.35620947 37.7473980957636 -122.410960347715 (37.7473980957636, -122.410960347715) 2 7 7 28859 2
49386 88828 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1321 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52530 6000678 2109601 37.7725998435487 -122.441069852882 (37.7725998435487, -122.441069852882) 15 5 11 29492 9
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
50099 52435 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1808 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM     Permit Number 48549 6004868.1713119 2115451.13806854 37.7889006530789 -122.426992345901 (37.7889006530789, -122.426992345901) 13 9 1 28858 27
51053 58102 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 251 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23965 6006689.2765112 2095813.61990221 37.7350834242778 -122.41929794049 (37.7350834242778, -122.41929794049) 2 7 7 28859 2
51264 49857 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 338 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46630 6003649.21999567 2095274.80996329 37.7334322896584 -122.429770085042 (37.7334322896584, -122.429770085042) 2 7 5 28861 25
51660 122788 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1655 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007172 2109097 37.7715837270561 -122.418570631079 (37.7715837270561, -122.418570631079) 8 2 9 28853 19
52892 64551 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1315 Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25434 6016281.43381852 2094844.2486814 37.7329572884599 -122.386066550856 (37.7329572884599, -122.386066550856) 10 3 8 58 1
52958 64541 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1513 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25424 6015494.68772587 2095105.29398738 37.7336304924024 -122.388804777662 (37.7336304924024, -122.388804777662) 10 3 8 58 1
53101 34891 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 95 Ward St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1997 12:00:00 AM     Permit Number 38498 6011846.48740204 2089823.39477464 37.7189246067483 -122.401046743519 (37.7189246067483, -122.401046743519) 10 7 8 309 39
53539 35777 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3528 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1998 12:00:00 AM     Permit Number 39032 6006085.57014843 2104950.10312581 37.7601361059974 -122.422034016017 (37.7601361059974, -122.422034016017) 2 4 5 28859 19
53575 46871 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1201 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44934 6008372.46317139 2117892.13679596 37.7958005639716 -122.415040782979 (37.7958005639716, -122.415040782979) 5 1 10 28858 21
53756 251780 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1219 Naples St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001110 2087312 37.7114241006266 -122.437978695611 (37.7114241006266, -122.437978695611) 9 7 6 28861 5
53859 63380 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 302 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23960 6006871.71117456 2095746.20400929 37.7349085881089 -122.41866241779 (37.7349085881089, -122.41866241779) 2 7 7 28859 2
53959 64549 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1414 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25432 6015539.44017214 2095047.54254922 37.7334743989165 -122.388646024077 (37.7334743989165, -122.388646024077) 10 3 8 58 1
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
54558 102355 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 176X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012524.1 2106651 37.7651674211522 -122.399885503722 (37.7651674211522, -122.399885503722) 14 3 8 28856 20
54973 95936 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 706 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM   3x3 Permit Number 767632 5987288.3 2111108.8 37.7759680859814 -122.487496400821 (37.7759680859814, -122.487496400821) 11 6 2 55 26
55160 108690 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 61 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005327.5 2105108.8 37.7605290659119 -122.424667111807 (37.7605290659119, -122.424667111807) 2 4 5 28859 19
55451 256092 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 240 12th St 2 Sidewalk: Curb side : Cutout Tree DPW 1           6007860.62906 2108997.35701 37.7713488754693 -122.416181558888 (37.7713488754693, -122.416181558888) 8 2 9 28853 19
55466 52669 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 346@ SANCHEZ Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2006 12:00:00 AM     Permit Number 48750 6004271.44295602 2099877.18374076 37.7461045741604 -122.427946728117 (37.7461045741604, -122.427946728117) 2 7 5 63 22
55473 39119 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 552 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40804 6007242.03781645 2104093.13141214 37.7578482165395 -122.417973583722 (37.7578482165395, -122.417973583722) 2 4 7 28859 19
55786 95669 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 800 Colby St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110 2090446 37.7204811172617 -122.41054968459 (37.7204811172617, -122.41054968459) 9 3 7 309 28
56214 38319 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM     Permit Number 774280 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
56364 67198 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 49 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30650 5998389.1076576 2106230.44875795 37.7632145281987 -122.448744521857 (37.7632145281987, -122.448744521857) 15 5 11 29492 9
56655 99384 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
57637 63381 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 289 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23961 6006861.89612331 2095799.20465588 37.7350535636056 -122.418700109332 (37.7350535636056, -122.418700109332) 2 7 7 28859 2
58711 68462 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 295 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/1993 12:00:00 AM     Permit Number 32324 5991504.44002823 2113463.17784531 37.7826775467792 -122.473083548968 (37.7826775467792, -122.473083548968) 11 6 2 54 26
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
59905 49865 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
60161 33723 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 52 Germania St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37790 6003978.61539507 2108896.55422138 37.7708530523079 -122.429602431291 (37.7708530523079, -122.429602431291) 7 9 11 29492 10
60323 64125 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 623 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24896 6002552.88374737 2098852.79748639 37.7431944740998 -122.433816072766 (37.7431944740998, -122.433816072766) 2 7 5 63 7
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
63210 96591 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
63409 46246 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 107 Alma St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44535 5998156.93644181 2106198.33011415 37.7631130593676 -122.449545206751 (37.7631130593676, -122.449545206751) 15 5 11 29492 9
63637 95714 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 649 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767469 6004402.3 2092291.6 37.7252836757454 -122.426954078943 (37.7252836757454, -122.426954078943) 9 7 6 28861 5
63990 46247 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 107 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/11/2006 12:00:00 AM     Permit Number 44535 5998156.93644181 2106198.33011415 37.7631130593676 -122.449545206751 (37.7631130593676, -122.449545206751) 15 5 11 29492 9
64054 52809 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 25@ TEXAS Sierra St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48835 6013772.92448179 2104112.24559711 37.7582661000564 -122.39538822301 (37.7582661000564, -122.39538822301) 10 3 8 28856 29
64253 114443 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 140 LOOMIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010781 2097775 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
64853 52436 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1808 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM     Permit Number 48549 6004868.1713119 2115451.13806854 37.7889006530789 -122.426992345901 (37.7889006530789, -122.426992345901) 13 9 1 28858 27
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
66207 41815 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 30 Barcelona Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42202 5999705.97173025 2112292.94161938 37.7799358147995 -122.444625705837 (37.7799358147995, -122.444625705837) 15 5 1 29490 16
66319 251315 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399X 12th St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008830 2108632 37.7704001487298 -122.41280261367 (37.7704001487298, -122.41280261367) 8 2 9 28853 19
67865 36987 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 800 Clement St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39609 5993070.986847 2113501.00043119 37.7828719719487 -122.467666762888 (37.7828719719487, -122.467666762888) 11 6 2 54 11
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
68249 56109 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3330 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22207 6006832.6652986 2102651.38828329 37.7538664735729 -122.419287095 (37.7538664735729, -122.419287095) 2 4 7 28859 19
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
68640 52808 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 25@ TEXAS Sierra St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48835 6013772.92448179 2104112.24559711 37.7582661000564 -122.39538822301 (37.7582661000564, -122.39538822301) 10 3 8 28856 29
68951 33009 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3616 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM     Permit Number 37303 6005672.83784214 2102003.77697796 37.752022893602 -122.423252020871 (37.752022893602, -122.423252020871) 2 4 5 28859 19
69549 63385 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 219 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23966 6006529.47672641 2095826.96456486 37.7351110645595 -122.419851373342 (37.7351110645595, -122.419851373342) 2 7 7 28859 2
69628 114796 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 719 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2015 12:00:00 AM     Permit Number 775428 5990315.8 2110460.7 37.7743646815998 -122.476976231877 (37.7743646815998, -122.476976231877) 11 6 2 55 26

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);