Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2524 | 2524 | 141906 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | |||
2675 | 2675 | 223660 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
25987 | 25987 | 114650 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6001545.1748 | 2113940.4839 | 37.784564324662 | -122.43838116449301 | (37.784564324662, -122.438381164493) | |||
27273 | 27273 | 138750 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 POST ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001227.9034 | 2113893.9374 | 37.7844184685956 | -122.439475475851 | (37.7844184685956, -122.439475475851) | |||
29383 | 29383 | 207619 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993530.3141 | 2090655.8864799999 | 37.720171655864604 | -122.46441847134199 | (37.7201716558646, -122.464418471342) | |||
30000 | 30000 | 72470 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1996 12:00:00 AM | 7 | 6012030.25538 | 2119045.5342200003 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | ||
30932 | 30932 | 74829 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | ||
32722 | 32722 | 191110 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011791.4986 | 2102301.92631 | 37.753184958831895 | -122.40211362973999 | (37.7531849588319, -122.40211362974) | |||
33927 | 33927 | 207670 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990672.18333 | 2102133.32849 | 37.751520618601106 | -122.475135407975 | (37.7515206186011, -122.475135407975) | |||
35080 | 35080 | 191665 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013224.690669999 | 2111029.2007400002 | 37.7772280099979 | -122.39776943840799 | (37.7772280099979, -122.397769438408) | |||
35456 | 35456 | 223428 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | |||
38332 | 38332 | 176262 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 56 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007768.4416 | 2093799.0798400003 | 37.7296126542007 | -122.41542429481899 | (37.7296126542007, -122.415424294819) | |||
40020 | 40020 | 224067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6000076.797040001 | 2105677.0536599997 | 37.7617914060643 | -122.44286764213301 | (37.7617914060643, -122.442867642133) | |||
42290 | 42290 | 223546 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000939.020959999 | 2096709.0709799998 | 37.7372165929608 | -122.43924275106899 | (37.7372165929608, -122.439242751069) | |||
45158 | 45158 | 207655 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1321 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994849.00569 | 2106528.5964599997 | 37.763830092700296 | -122.461010081256 | (37.7638300927003, -122.461010081256) | |||
46569 | 46569 | 207598 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 484 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994786.89964 | 2091797.5049599998 | 37.7233786212014 | -122.460157571622 | (37.7233786212014, -122.460157571622) | |||
47347 | 47347 | 223590 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 500 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008475.14451 | 2096933.16197 | 37.7382578613013 | -122.413202674371 | (37.7382578613013, -122.413202674371) | |||
49805 | 49805 | 45669 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 815 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49963 | 5984453.94726 | 2110275.98244 | 37.7735156996405 | -122.497239525872 | (37.7735156996405, -122.497239525872) | |
50518 | 50518 | 189268 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1721 Oakdale Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014331.30759 | 2095974.08961 | 37.735951477983704 | -122.39288771511002 | (37.7359514779837, -122.39288771511) | |||
51066 | 51066 | 224041 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3900 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004443.2007 | 2101347.0778200002 | 37.750150278415205 | -122.427457508869 | (37.7501502784152, -122.427457508869) | |||
52017 | 52017 | 141629 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1801 GROVE ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999005.9913 | 2110412.5019 | 37.7747326436678 | -122.446911888169 | (37.7747326436678, -122.446911888169) | |||
52128 | 52128 | 32155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 521 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 7 | Permit Number 35505 | 6004828.77889 | 2111059.03276 | 37.7768387933121 | -122.42681572299401 | (37.7768387933121, -122.426815722994) | ||
55656 | 55656 | 126560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | |||
55728 | 55728 | 74929 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 6014021.820230001 | 2112985.48182 | 37.78264387125021 | -122.395148955186 | (37.7826438712502, -122.395148955186) | ||
56193 | 56193 | 223619 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 429 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006801.93738 | 2101276.12036 | 37.7500885714431 | -122.419295806956 | (37.7500885714431, -122.419295806956) | |||
56938 | 56938 | 33335 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) |
60578 | 60578 | 181735 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986996.5941 | 2107070.8859 | 37.7648640858106 | -122.488208680173 | (37.7648640858106, -122.488208680173) | |||
62924 | 62924 | 191663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013137.81115 | 2110946.71833 | 37.7769966935644 | -122.398064196625 | (37.7769966935644, -122.398064196625) | |||
70733 | 70733 | 71444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | ||
71713 | 71713 | 68222 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1324 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 7 | Permit Number 32012 | 5991360.0302800005 | 2113443.0378799997 | 37.78261388597161 | -122.47358167061199 | (37.7826138859716, -122.473581670612) | |
74762 | 74762 | 223400 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3438 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005402.025719999 | 2103738.26826 | 37.7567701160611 | -122.42431188179701 | (37.7567701160611, -122.424311881797) | |||
75138 | 75138 | 223433 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 321 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006139.56315 | 2107708.4180799997 | 37.7677128338021 | -122.422043233108 | (37.7677128338021, -122.422043233108) | |||
76366 | 76366 | 126496 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1695 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004921.92717 | 2119147.2014599997 | 37.7990521458892 | -122.42706971848999 | (37.7990521458892, -122.42706971849) | |||
76579 | 76579 | 248098 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010471.50543 | 2099820.33523 | 37.746297290485295 | -122.40650360018 | (37.7462972904853, -122.40650360018) | |||
81382 | 81382 | 112862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5990594.0 | 2098423.0 | 37.7413284897401 | -122.47513493887301 | (37.7413284897401, -122.475134938873) | |||
91177 | 91177 | 2768 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 238 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 7 | 3X3 | 5994792.462780001 | 2110798.98024 | 37.7755521919136 | -122.461515261652 | (37.7755521919136, -122.461515261652) | ||
116058 | 116058 | 113703 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 14 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6007138.0 | 2099599.0 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | |||
119604 | 119604 | 191100 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2041 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012349.12966 | 2101394.53419 | 37.7507245656958 | -122.40012149651899 | (37.7507245656958, -122.400121496519) | |||
121004 | 121004 | 49497 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
121784 | 121784 | 112066 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 768 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5991979.16642 | 2110231.12718 | 37.77383069132 | -122.47120566172701 | (37.77383069132, -122.471205661727) | |||
129958 | 129958 | 191065 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Clara St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011631.45196 | 2111618.92007 | 37.7787583899224 | -122.403322487638 | (37.7787583899224, -122.403322487638) | |||
130599 | 130599 | 223526 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4128 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002300.1316599995 | 2101812.6373099997 | 37.7513071510194 | -122.434901649798 | (37.7513071510194, -122.434901649798) | |||
131570 | 131570 | 207608 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 299 Tara St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997723.56116 | 2090176.57785 | 37.71909640934621 | -122.44988936340799 | (37.7190964093462, -122.449889363408) | |||
132487 | 132487 | 31506 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 275 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1995 12:00:00 AM | 7 | Permit Number 35066 | 5998177.9524 | 2112750.4955 | 37.781104827172705 | -122.44994476744199 | (37.7811048271727, -122.449944767442) | |
134369 | 134369 | 207591 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 207 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999361.39835 | 2094045.00117 | 37.7298117829776 | -122.444505884965 | (37.7298117829776, -122.444505884965) | |||
134610 | 134610 | 53155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1785@ 3RD ST Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 7 | Permit Number 49078 | 6014228.24564 | 2095345.46405 | 37.7342196759901 | -122.393200070342 | (37.7342196759901, -122.393200070342) | ||
135802 | 135802 | 207636 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1475 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994263.22804 | 2105474.6217900002 | 37.7609024271204 | -122.462959619907 | (37.7609024271204, -122.462959619907) | |||
136320 | 136320 | 207653 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992353.426469999 | 2106870.06919 | 37.7646237659879 | -122.46966631405199 | (37.7646237659879, -122.469666314052) | |||
137143 | 137143 | 189245 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2445 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010120.66455 | 2105943.60701 | 37.7630907960193 | -122.408148550138 | (37.7630907960193, -122.408148550138) | |||
146993 | 146993 | 126553 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.40217926767099 | (37.7993378371204, -122.402179267671) | |||
147207 | 147207 | 120492 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | |||
147225 | 147225 | 31708 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 498 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35209 | 5997262.9247 | 2107438.6115 | 37.766467371667794 | -122.452726796412 | (37.7664673716678, -122.452726796412) | ||
147834 | 147834 | 41577 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 715 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2000 12:00:00 AM | 7 | Permit Number 42091 | 5981330.80652 | 2110844.76376 | 37.774893875261505 | -122.50808495995001 | (37.7748938752615, -122.50808495995) | ||
150014 | 150014 | 176243 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.72042503536171 | -122.40089327761801 | (37.7204250353617, -122.400893277618) | |||
151276 | 151276 | 223611 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006745.90219 | 2102323.75764 | 37.752961988114 | -122.419563899379 | (37.752961988114, -122.419563899379) | |||
152061 | 152061 | 141989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1019 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004298.7778 | 2111838.3869 | 37.77894872708271 | -122.42870472731 | (37.7789487270827, -122.42870472731) | |||
153042 | 153042 | 207605 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 68 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994168.04761 | 2090360.8156299999 | 37.71939820295 | -122.46219266815599 | (37.71939820295, -122.462192668156) | |||
153296 | 153296 | 244881 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1397 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999919.405 | 2109151.3942 | 37.7713221021012 | -122.44366159862601 | (37.7713221021012, -122.443661598626) | |||
155627 | 155627 | 84783 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 280 Charter Oak Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2007 12:00:00 AM | 7 | Permit No. 49320 | 6010967.59518 | 2095106.3489299999 | 37.733381434103705 | -122.404456411357 | (37.7333814341037, -122.404456411357) | ||
158823 | 158823 | 207612 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 157 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5996901.64922 | 2089066.51215 | 37.7160013655568 | -122.452650309965 | (37.7160013655568, -122.452650309965) | |||
159033 | 159033 | 223376 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010275.7458 | 2101037.64941 | 37.74962881461661 | -122.407266315203 | (37.7496288146166, -122.407266315203) | |||
161029 | 161029 | 246486 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 346 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6004013.8028 | 2099862.02066 | 37.746048360848896 | -122.4288365338 | (37.7460483608489, -122.4288365338) | |||
163124 | 163124 | 223606 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007244.98796 | 2104086.07115 | 37.7578289967226 | -122.417962880381 | (37.7578289967226, -122.417962880381) | |||
163427 | 163427 | 71380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1415 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015545.815 | 2094978.0232 | 37.7332838660921 | -122.388619133184 | (37.7332838660921, -122.388619133184) | ||
164431 | 164431 | 207539 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995838.12242 | 2107108.03274 | 37.7654779429827 | -122.457630976687 | (37.7654779429827, -122.457630976687) | |||
164622 | 164622 | 47462 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1818 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45366 | 6000023.68636 | 2115243.51305 | 37.788055445440996 | -122.443738626559 | (37.788055445441, -122.443738626559) | |
165802 | 165802 | 63192 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 439 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/2001 12:00:00 AM | 7 | Permit Number 33572 | 5984052.00356 | 2112858.1902400004 | 37.78058213076871 | -122.49882069014099 | (37.7805821307687, -122.498820690141) | |
166529 | 166529 | 224057 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4677 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000058.79012 | 2105152.70486 | 37.7603506471783 | -122.442892265582 | (37.7603506471783, -122.442892265582) | |||
167242 | 167242 | 224080 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 68 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003118.91153 | 2108722.42334 | 37.7703262160109 | -122.432563724544 | (37.7703262160109, -122.432563724544) | |||
170806 | 170806 | 244883 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1395 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999962.5746 | 2109158.9845 | 37.7713454052089 | -122.443512818846 | (37.7713454052089, -122.443512818846) | |||
171078 | 171078 | 122259 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991408.07058 | 2113443.99656 | 37.7826193002424 | -122.47341554338499 | (37.7826193002424, -122.473415543385) | |||
172122 | 172122 | 207618 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 720 Head St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993529.31712 | 2090633.6912900002 | 37.720110655762 | -122.464420306879 | (37.720110655762, -122.464420306879) | |||
179999 | 179999 | 246031 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 632 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999010.3999 | 2108524.1023 | 37.7695478312752 | -122.446760732499 | (37.7695478312752, -122.446760732499) | |||
180689 | 180689 | 223585 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007537.470430001 | 2096557.5689 | 37.7371738787611 | -122.41641810052099 | (37.7371738787611, -122.416418100521) | |||
181202 | 181202 | 200709 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1399 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015661.7831 | 2095130.2658 | 37.7337083198644 | -122.388228817428 | (37.7337083198644, -122.388228817428) | |||
182554 | 182554 | 126550 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.79864269176171 | -122.402360227452 | (37.7986426917617, -122.402360227452) | |||
187607 | 187607 | 223555 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 700 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007416.45129 | 2095644.8678700002 | 37.7346609957998 | -122.416771878526 | (37.7346609957998, -122.416771878526) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");