trees
2,421 rows where qSpecies_id = 8 sorted by PlantDate descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
106652 | 108684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.7153792289568 | -122.440813996186 | (37.7153792289568, -122.440813996186) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
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 | ||
23536 | 108612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | 15 | 5 | 5 | 28862 | 3 | |
91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 | |
157918 | 67731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774581 | 5992402.99511967 | 2105448.3839166 | 37.7607230584725 | -122.46939137901 | (37.7607230584725, -122.46939137901) | 1 | 8 | 4 | 56 | 12 | |
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 | ||
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 | ||
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 | ||
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 | ||
167235 | 39612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 563 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41014 | 5996904.00542079 | 2107338.98044798 | 37.76617323756 | -122.453961030301 | (37.76617323756, -122.453961030301) | 15 | 5 | 11 | 29492 | 12 | ||
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 | ||
36614 | 40677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 195 Maynard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 1 | Permit Number 774326 | 6004652.68968 | 2093800.00562 | 37.7294395787702 | -122.426195845473 | (37.7294395787702, -122.426195845473) | 9 | 7 | 6 | 28861 | 5 | |
94102 | 28997 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008985.04718 | 2109404.34917 | 37.7725295406243 | -122.412320901705 | (37.7725295406243, -122.412320901705) | 8 | 2 | 9 | 28853 | 34 | ||
136034 | 52464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 635 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 5 | 3x4 | Permit Number 48575 | 5993761.55642 | 2111156.7218 | 37.776475063376 | -122.465107376554 | (37.776475063376, -122.465107376554) | 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 | |
90991 | 246035 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | 6 | Width 0ft | Permit Number 44478 | 5999014.0338 | 2108493.5166 | 37.7694640582811 | -122.446745961985 | (37.7694640582811, -122.446745961985) | 15 | 5 | 11 | 29492 | 9 | |
120751 | 46128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 636 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44478 | 5999007.45186043 | 2108568.17204311 | 37.7696686672108 | -122.446774101055 | (37.7696686672108, -122.446774101055) | 15 | 5 | 11 | 29492 | 9 | ||
64302 | 108554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
122709 | 108553 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
134509 | 80153 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4675-4677 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50049 | 6000057.47834609 | 2105146.79504317 | 37.7603343454923 | -122.442896377988 | (37.7603343454923, -122.442896377988) | 2 | 4 | 5 | 28862 | 3 | ||
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 | ||
183766 | 46113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3xe | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
189274 | 46110 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 3 | 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 | ||
102384 | 37595 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 681 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773784 | 5992529.93541662 | 2110827.20816005 | 37.7754992113625 | -122.469343875957 | (37.7754992113625, -122.469343875957) | 11 | 6 | 2 | 54 | 11 | |
143792 | 37596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 681 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773784 | 5992531.87149 | 2110821.51751 | 37.7754836982564 | -122.469336764375 | (37.7754836982564, -122.469336764375) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
70547 | 97831 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773720 | 6007110.2 | 2105525.4 | 37.7617734734729 | -122.41853109578 | (37.7617734734729, -122.41853109578) | 2 | 4 | 7 | 28859 | 19 | |
97924 | 108432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2676 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773725 | 6010053.51551 | 2103992.82932 | 37.7577306409511 | -122.408243201207 | (37.7577306409511, -122.408243201207) | 2 | 4 | 7 | 28859 | 19 |
65385 | 26833 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1133 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 0 | 3X3 | 6015479.92911 | 2095965.05347 | 37.7359903999296 | -122.388915807139 | (37.7359903999296, -122.388915807139) | 10 | 3 | 8 | 58 | 1 | ||
1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
20072 | 52428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004799.3483 | 2115577.2997 | 37.7892431693813 | -122.427239454587 | (37.7892431693813, -122.427239454587) | 13 | 9 | 11 | 28858 | 27 |
47747 | 52433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1807 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48548 | 6004803.7724 | 2115546.524 | 37.7891589172332 | -122.427221954641 | (37.7891589172332, -122.427221954641) | 13 | 9 | 11 | 28858 | 27 | |
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 | ||
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 | ||
77189 | 52437 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 3 | 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 | ||
104077 | 52438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48550 | 6004816.71348375 | 2115443.64861451 | 37.7888771790913 | -122.427169849357 | (37.7888771790913, -122.427169849357) | 13 | 9 | 11 | 28858 | 27 | ||
104479 | 52429 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
105374 | 52439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48550 | 6004816.71348375 | 2115443.64861451 | 37.7888771790913 | -122.427169849357 | (37.7888771790913, -122.427169849357) | 13 | 9 | 11 | 28858 | 27 | ||
191996 | 52434 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1807 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48548 | 6004817.68850791 | 2115436.94951127 | 37.7888588401734 | -122.427165998542 | (37.7888588401734, -122.427165998542) | 13 | 9 | 11 | 28858 | 27 | ||
102187 | 39314 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
150294 | 39316 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
153178 | 39315 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
132969 | 108369 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773814 | 6001475.26516 | 2090061.55368 | 37.7189945287407 | -122.436912960177 | (37.7189945287407, -122.436912960177) | 9 | 7 | 6 | 28861 | 5 |
143091 | 64168 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 770 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1987 12:00:00 AM | 20 | 4x6 | Permit Number 24949 | 5991979.28943 | 2110202.2151 | 37.7737513136845 | -122.471203129362 | (37.7737513136845, -122.471203129362) | 11 | 6 | 2 | 54 | 11 |
98310 | 63152 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23688 | 6008095.93385005 | 2113196.54307112 | 37.7828920680587 | -122.415664995853 | (37.7828920680587, -122.415664995853) | 7 | 10 | 9 | 28852 | 36 | ||
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 | ||
8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
35198 | 6735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | 10 | 3 | 8 | 58 | 1 | ||
165259 | 52386 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3243PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48511 | 6009040.2496951 | 2099805.3133039 | 37.7461758688375 | -122.411451668833 | (37.7461758688375, -122.411451668833) | 2 | 7 | 7 | 28859 | 2 | ||
162179 | 85184 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 Bartlett St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822 | 2100867 | 37.7489663498096 | -122.419197411761 | (37.7489663498096, -122.419197411761) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
158823 | 52349 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
165563 | 52351 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
187709 | 28242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | 7 | 9 | 11 | 29492 | 10 | ||
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 | ||
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 | |||
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 | |
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 | ||
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 | ||
32770 | 60516 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20119 | 6004763.14449697 | 2099853.52664846 | 37.7460674222913 | -122.42624480255 | (37.7460674222913, -122.42624480255) | 2 | 7 | 5 | 63 | 22 | ||
148006 | 60514 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20115 | 6004602.91474331 | 2099861.26634292 | 37.7460796156332 | -122.426799407471 | (37.7460796156332, -122.426799407471) | 2 | 7 | 5 | 63 | 22 | ||
67793 | 45669 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49963 | 5984453.94726 | 2110275.98244 | 37.7735156996405 | -122.497239525872 | (37.7735156996405, -122.497239525872) | 11 | 6 | 2 | 55 | 26 | |
133465 | 59743 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4377 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22594 | 6000259.423804 | 2105746.15937443 | 37.7619915633709 | -122.442240971868 | (37.7619915633709, -122.442240971868) | 15 | 5 | 5 | 28862 | 3 | ||
162573 | 62434 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4347 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22595 | 6000487.62701634 | 2105758.51838651 | 37.7620385014788 | -122.441452594893 | (37.7620385014788, -122.441452594893) | 15 | 5 | 5 | 28862 | 3 | ||
140396 | 66887 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1991 12:00:00 AM | 9 | Permit Number 30200 | 6013938.0874 | 2104806.5934 | 37.7601818129701 | -122.394865641745 | (37.7601818129701, -122.394865641745) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
29985 | 59550 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24919 | 6003521.85163486 | 2098666.09972032 | 37.7427367824396 | -122.43045232079 | (37.7427367824396, -122.43045232079) | 2 | 7 | 5 | 63 | 22 | ||
31788 | 64128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 627 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24899 | 6002528.44281747 | 2098851.45130448 | 37.7431893908467 | -122.433900486749 | (37.7431893908467, -122.433900486749) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
70702 | 64142 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 387 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24915 | 6003450.8356786 | 2098610.10956553 | 37.7425790233006 | -122.430693879032 | (37.7425790233006, -122.430693879032) | 2 | 7 | 5 | 63 | 22 | ||
74307 | 64143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 461 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24917 | 6002822.78297859 | 2098575.51836339 | 37.7424484420328 | -122.432863028806 | (37.7424484420328, -122.432863028806) | 2 | 7 | 5 | 63 | 22 | ||
77707 | 64130 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | 24 | Permit Number 24901 | 6002310.61439363 | 2098891.53580323 | 37.7432870897096 | -122.434656544552 | (37.7432870897096, -122.434656544552) | 2 | 7 | 5 | 63 | 22 | |
79670 | 64117 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 606 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24888 | 6002640.14988451 | 2098909.68283406 | 37.7433556196147 | -122.433518394217 | (37.7433556196147, -122.433518394217) | 2 | 7 | 5 | 63 | 22 | ||
113437 | 64158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 738 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | 11 | 6x6 | Permit Number 24937 | 5991972.51764 | 2110378.72866 | 37.7742355804515 | -122.471239416809 | (37.7742355804515, -122.471239416809) | 11 | 6 | 2 | 54 | 11 |
126421 | 64123 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 319 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24894 | 6003820.50853257 | 2099508.65029248 | 37.7450671453675 | -122.429479723764 | (37.7450671453675, -122.429479723764) | 2 | 7 | 5 | 63 | 22 | ||
143019 | 64122 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 330 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24893 | 6003743.68198418 | 2099556.50648257 | 37.7451941972726 | -122.429748789002 | (37.7451941972726, -122.429748789002) | 2 | 7 | 5 | 63 | 22 | ||
179872 | 64120 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | 12 | Permit Number 24891 | 6003817.65498965 | 2099560.57193818 | 37.745209548627 | -122.42949329292 | (37.745209548627, -122.42949329292) | 2 | 7 | 5 | 63 | 22 | |
82251 | 37664 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3250 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 40070 | 6007810.11967641 | 2105631.1413248 | 37.7621031933661 | -122.416117835461 | (37.7621031933661, -122.416117835461) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
111285 | 33722 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | 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 | |||
90531 | 59448 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | 4 | 3x3 | Permit Number 18811 | 6003739.62591886 | 2095283.52491985 | 37.7334613379814 | -122.429458147626 | (37.7334613379814, -122.429458147626) | 2 | 7 | 5 | 28861 | 25 | |
106488 | 223660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | 7 | Width 3ft | Permit Number 18811 | 6003709.54346 | 2095276.16661 | 37.7334394304696 | -122.429561626586 | (37.7334394304696, -122.429561626586) | 2 | 7 | 5 | 28861 | 25 | |
105746 | 97421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 84 Liebig St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2011 12:00:00 AM | 3 | 6x15 | Permit Number 768371 | 5995500.38132 | 2086681.75042 | 37.7093729771635 | -122.457321298761 | (37.7093729771635, -122.457321298761) | 9 | 7 | 6 | 28861 | 25 | |
106857 | 111194 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | ||
109380 | 111193 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |
165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
101299 | 84156 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 618-620 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769487 | 6007864.16010864 | 2104318.1275589 | 37.7585009983288 | -122.415837950653 | (37.7585009983288, -122.415837950653) | 2 | 4 | 7 | 28859 | 19 | ||
1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
6423 | 161312 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6002939.11369 | 2090932.78769 | 37.7214698362342 | -122.431915186563 | (37.7214698362342, -122.431915186563) | 9 | 7 | 6 | 28861 | 5 | ||
133251 | 214105 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782625 | 5994448.04607 | 2088422.67439 | 37.7140926462444 | -122.461084417418 | (37.7140926462444, -122.461084417418) | 9 | 8 | 6 | 28861 | 24 |
173146 | 47404 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 522 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2013 12:00:00 AM | 1 | Permit Number 771051 | 5993469.13316 | 2111905.11444 | 37.7785130815905 | -122.466173342611 | (37.7785130815905, -122.466173342611) | 11 | 6 | 2 | 54 | 11 | |
5105 | 153628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3140 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780837 | 6004230.96494 | 2119993.8857 | 37.8013378259475 | -122.429521095049 | (37.8013378259475, -122.429521095049) | 13 | 9 | 1 | 57 | 17 | |
100404 | 48936 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46124 | 6008970.19382594 | 2102433.57534311 | 37.7533885608678 | -122.411879606442 | (37.7533885608678, -122.411879606442) | 2 | 4 | 7 | 28859 | 19 | ||
112026 | 114562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 774856 | 6005427.79379 | 2117145.93262 | 37.7935857616223 | -122.425176769692 | (37.7935857616223, -122.425176769692) | 13 | 9 | 1 | 28858 | 27 | ||
120511 | 114551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322 | -122.401957083855 | (37.759370822322, -122.401957083855) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 |
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) );