Street_Tree_List

Data source: data.sfgov.org

2,282 rows where qSpecies = 49 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
4183 4183 180766 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1206 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:29:00 AM 3 Width 8ft   6001093.57723 2087421.33847 37.7117233858917 -122.438043283865 (37.7117233858917, -122.438043283865)
4389 4389 177791 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 400 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:44:00 AM 3 Width 8ft   6001956.24423 2086810.19432 37.710094340458 -122.435017995105 (37.710094340458, -122.435017995105)
32041 32041 223379 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 2730 22nd St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 7ft   6009758.65341 2103393.8455 37.756069450652795 -122.4092206931 (37.7560694506528, -122.4092206931)
3437 3437 180625 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 18 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 6ft   6002816.84046 2087215.85653 37.711257028952495 -122.432072557104 (37.7112570289525, -122.432072557104)
3478 3478 180626 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 18 Winding Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 6ft   6002802.39914 2087193.02957 37.7111935323316 -122.432120840807 (37.7111935323316, -122.432120840807)
3993 3993 180622 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 771 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:19:00 AM 3 Width 6ft   6002476.28052 2087135.9896900002 37.7110184181363 -122.433243913293 (37.7110184181363, -122.433243913293)
4059 4059 251733 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 824 Prague St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 08:24:00 AM 3 Width 6ft   6002320.95082 2087061.4224099999 37.7108048597154 -122.43377544319401 (37.7108048597154, -122.433775443194)
4069 4069 251732 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 824 Prague St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 08:20:00 AM 3 Width 6ft   6002320.95082 2087061.4224099999 37.7108048597154 -122.43377544319401 (37.7108048597154, -122.433775443194)
4071 4071 251734 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 856 Prague St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 08:08:00 AM 3 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
4108 4108 180634 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 824 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 08:16:00 AM 3 Width 6ft   6002320.95082 2087061.4224099999 37.7108048597154 -122.43377544319401 (37.7108048597154, -122.433775443194)
4114 4114 180623 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 755 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:23:00 AM 3 Width 6ft   6002495.21129 2087156.5558200001 37.711075962150204 -122.43317995261499 (37.7110759621502, -122.433179952615)
4209 4209 180663 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 355 Chicago Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 01:48:00 PM 3 Width 6ft   6002383.84355 2086445.14687 37.709116270155604 -122.43351405884898 (37.7091162701556, -122.433514058849)
26480 26480 207665 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 315 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 6ft   5996615.28225 2106600.5600799997 37.7641291658503 -122.454906302505 (37.7641291658503, -122.454906302505)
27081 27081 176269 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Curtis St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6000993.66237 2087160.73145 37.711002134104795 -122.43836995721901 (37.7110021341048, -122.438369957219)
34552 34552 246582 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 198 Laguna St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 6ft   6005203.89906 2109501.9724 37.7725846861634 -122.425407234452 (37.7725846861634, -122.425407234452)
35931 35931 246581 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 184 Laguna St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6005207.86965 2109476.17522 37.772514077680995 -122.425391663601 (37.772514077681, -122.425391663601)
45395 45395 223368 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3450 26th St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6006716.9370800005 2100883.67936 37.7490062301666 -122.419561903754 (37.7490062301666, -122.419561903754)
46450 46450 246577 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 126 Laguna St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6005225.24464 2109364.93457 37.7722096193969 -122.425323644264 (37.7722096193969, -122.425323644264)
52210 52210 223407 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 819 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 6ft   6010188.626680001 2104419.00233 37.758908381026295 -122.407805979477 (37.7589083810263, -122.407805979477)
56816 56816 207586 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1917 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993746.75792 2102455.0649099997 37.7525817412531 -122.464526593251 (37.7525817412531, -122.464526593251)
59380 59380 207668 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 330 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   5993218.37994 2103939.27456 37.756626524017 -122.466461665387 (37.756626524017, -122.466461665387)
60106 60106 207624 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1217 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 6ft   5995447.45032 2107265.73285 37.765888496982 -122.458993633074 (37.765888496982, -122.458993633074)
61749 61749 223367 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3450 26th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6006755.66784 2100887.58392 37.7490191327351 -122.41942824923099 (37.7490191327351, -122.419428249231)
63158 63158 223392 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 35 Oakwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6005261.50146 2105224.90356 37.7608441312586 -122.424903631195 (37.7608441312586, -122.424903631195)
63479 63479 207666 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 316 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 6ft   5993287.90775 2103943.6101599997 37.756642440205106 -122.46622153019501 (37.7566424402051, -122.466221530195)
132019 132019 207667 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 318 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   5993246.28637 2103941.58644 37.7566344820998 -122.466365323703 (37.7566344820998, -122.466365323703)
132540 132540 207572 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1640 09th Ave 3 Front Yard : Yard 7 Tree 1 Private 1     1 Width 6ft   5993421.18819 2104299.1531 37.757626357879296 -122.465786433692 (37.7576263578793, -122.465786433692)
153130 153130 246578 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 126 Laguna St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6005224.61763 2109380.5183200003 37.7722523731835 -122.425326922304 (37.7722523731835, -122.425326922304)
163964 163964 246580 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 182 Laguna St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6005210.93182 2109452.28431 37.7724486520281 -122.425379370776 (37.7724486520281, -122.425379370776)
164320 164320 223391 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 41 Oakwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 6ft   6005260.46282 2105206.1033799998 37.7607924517343 -122.424905885809 (37.7607924517343, -122.424905885809)
171876 171876 176267 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6000986.70381 2087103.4067099998 37.710844337262294 -122.43838990328899 (37.7108443372623, -122.438389903289)
186597 186597 176268 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Curtis St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6000987.65781 2087139.8501 37.7109444570035 -122.43838921531 (37.7109444570035, -122.43838921531)
1009 1009 223537 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300 Noe St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   6003218.0959 2100594.3408 37.7480140720016 -122.431640256605 (37.7480140720016, -122.431640256605)
23709 23709 223384 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1 Cumberland St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6005565.506580001 2104580.7732 37.759092667419 -122.42380640884701 (37.759092667419, -122.423806408847)
24000 24000 246500 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Duncan St 1 : 4 Tree 1 Private 1     10 Width 5ft   6004745.35521 2099854.76299 37.746069811469 -122.426306403626 (37.746069811469, -122.426306403626)
28506 28506 223371 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3527 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6006033.70926 2105484.59441 37.7616007686849 -122.42225135332899 (37.7616007686849, -122.422251353329)
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)
39194 39194 126540 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1926 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6008669.99624 2119504.05364 37.800243203509005 -122.414125355424 (37.800243203509, -122.414125355424)
39950 39950 176266 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 928 Excelsior Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6004692.43448 2091256.7125 37.7224585032472 -122.425877480072 (37.7224585032472, -122.425877480072)
46166 46166 223369 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3520 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6006269.04554 2100859.97677 37.7489159094411 -122.42110903535101 (37.7489159094411, -122.421109035351)
47087 47087 223577 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 180 Bonview St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6007069.07199 2097998.10728 37.7411029259504 -122.418139669131 (37.7411029259504, -122.418139669131)
54974 54974 207657 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1343 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   5994851.17406 2106389.13082 37.7634472809955 -122.46099247254699 (37.7634472809955, -122.460992472547)
59294 59294 223445 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 318 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   6003784.31175 2099553.81383 37.74518910450939 -122.429608106246 (37.7451891045094, -122.429608106246)
60019 60019 223396 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 90 Lapidge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6006003.81464 2104993.73555 37.76025129906861 -122.42231986997 (37.7602512990686, -122.42231986997)
68683 68683 176235 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 19 Brunswick St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6001042.78255 2087493.5862099999 37.711918873330205 -122.43822401612499 (37.7119188733302, -122.438224016125)
74078 74078 207703 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 161 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6000991.68804 2094917.7837900002 37.7323011315777 -122.438932323977 (37.7323011315777, -122.438932323977)
74588 74588 176265 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 928 Excelsior Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6004683.740019999 2091261.8142 37.7224720200432 -122.42590789782601 (37.7224720200432, -122.425907897826)
75839 75839 223600 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 300 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6007768.16924 2106112.90661 37.76342365039 -122.41629704999399 (37.76342365039, -122.416297049994)
129925 129925 176236 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 19 Brunswick St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6001058.00654 2087498.50838 37.711933254377 -122.438171750223 (37.711933254377, -122.438171750223)
130480 130480 224045 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 118 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6000330.71148 2104908.09647 37.7596945117222 -122.44193426187799 (37.7596945117222, -122.441934261878)
137053 137053 189250 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1301 Bay Shore Blvd 4 : 4 Tree 1 Private 1     11 Width 5ft   6011646.806480001 2093004.20248 37.7276473117623 -122.40196044913799 (37.7276473117623, -122.401960449138)
146443 146443 191058 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 215 05th St 1 : 4 Tree 1 Private 1     1 Width 5ft   6011781.36835 2111952.66121 37.7796831376017 -122.402827343412 (37.7796831376017, -122.402827343412)
146540 146540 207635 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1450 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   5994307.66331 2105637.8573 37.761353188916395 -122.462817781532 (37.7613531889164, -122.462817781532)
150910 150910 126495 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 2700 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6000053.14506 2117822.05774 37.7951371326294 -122.44382203238001 (37.7951371326294, -122.44382203238)
157268 157268 191059 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 215 05th St 2 : 4 Tree 1 Private 1     6 Width 5ft   6011805.95608 2111927.87879 37.7796164636776 -122.402740539939 (37.7796164636776, -122.402740539939)
157367 157367 207656 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1331 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   5994848.43771 2106461.0106900004 37.763644487022795 -122.461007146788 (37.7636444870228, -122.461007146788)
161450 161450 118075 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 426 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5985334.5387699995 2112983.7129 37.781001920437795 -122.494393110571 (37.7810019204378, -122.494393110571)
174179 174179 224098 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1414 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6002523.84844 2101397.51058 37.7501800108976 -122.434098340276 (37.7501800108976, -122.434098340276)
174559 174559 207658 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1347 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   5994853.56719 2106361.61895 37.7633718782394 -122.460982201389 (37.7633718782394, -122.460982201389)
179524 179524 126517 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3835 Scott St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6000579.5194 2121468.07283 37.8051781307269 -122.44226256568001 (37.8051781307269, -122.44226256568)
180532 180532 223599 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 300 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6007767.1377 2106084.40018 37.763345320342495 -122.41629859860501 (37.7633453203425, -122.416298598605)
184033 184033 224099 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 33 Harper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6003688.866090001 2098162.22587 37.7413627203269 -122.42983890015101 (37.7413627203269, -122.429838900151)
184233 184233 223598 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 304 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6007773.137630001 2106049.50965 37.763249856425396 -122.41627537542 (37.7632498564254, -122.41627537542)
186771 186771 223597 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 306 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6007773.4938900005 2106023.20364 37.7631776462561 -122.416272279958 (37.7631776462561, -122.416272279958)
188754 188754 223383 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1 Cumberland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6005540.24064 2104579.79946 37.759088567411794 -122.423893721341 (37.7590885674118, -122.423893721341)
851 851 234149 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3652 23rd St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6005288.48907 2102558.72214 37.753524945734 -122.42462062893601 (37.753524945734, -122.424620628936)
3736 3736 223410 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 898 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/1993 12:00:00 AM 9 Width 4ft Permit Number 32344 6010171.02881 2104045.21453 37.7578810584907 -122.407840483778 (37.7578810584907, -122.407840483778)
4062 4062 216659 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1022 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 07:44:00 AM 3 Width 4ft   5995946.33237 2090713.9624 37.7204700913979 -122.456071352615 (37.7204700913979, -122.456071352615)
4144 4144 216652 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 329 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/06/2017 08:15:00 AM 3 Width 4ft   5994725.9247 2090785.7094700001 37.7205969659665 -122.460295076156 (37.7205969659665, -122.460295076156)
25085 25085 223541 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 814 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6001016.96065 2102616.12439 37.7534403941744 -122.43939657921301 (37.7534403941744, -122.439396579213)
25319 25319 124355 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1108 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5992124.25378 2111386.32559 37.7770109442204 -122.470787948699 (37.7770109442204, -122.470787948699)
27265 27265 207601 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 129 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995608.85604 2090759.60342 37.720576034226 -122.457241192545 (37.720576034226, -122.457241192545)
28721 28721 223467 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 812 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5998670.80107 2107458.83461 37.7666034705969 -122.447858683442 (37.7666034705969, -122.447858683442)
29080 29080 223542 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 4112 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6001417.09599 2102930.9043099997 37.7543274674466 -122.43803537522699 (37.7543274674466, -122.438035375227)
29213 29213 224107 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 33 Gough St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6006435.98558 2109358.16079 37.7722593483308 -122.421135098612 (37.7722593483308, -122.421135098612)
29535 29535 207637 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1461 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5994257.76347 2105584.20435 37.761202997648795 -122.46298647005199 (37.7612029976488, -122.462986470052)
30277 30277 207570 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1425 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5993940.55788 2105777.49426 37.7617154448214 -122.464097572554 (37.7617154448214, -122.464097572554)
30930 30930 223427 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 357 Precita Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008897.95249 2100223.67255 37.747316608191 -122.411973275956 (37.747316608191, -122.411973275956)
32595 32595 223390 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 61 Oakwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6005265.03811 2105111.68435 37.760533457783104 -122.42488334431101 (37.7605334577831, -122.424883344311)
33533 33533 223540 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1661 Noe St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6003385.2005900005 2098555.09449 37.7424242458904 -122.43091690040701 (37.7424242458904, -122.430916900407)
33933 33933 207650 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1239 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5992348.57689 2106988.87327 37.7649496901864 -122.469691736987 (37.7649496901864, -122.469691736987)
34295 34295 223385 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3667 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6005189.30238 2104853.5381 37.759820370941895 -122.4251269113 (37.7598203709419, -122.4251269113)
35224 35224 191095 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1951 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6012592.465340001 2102823.04083 37.7546604998905 -122.39938028876499 (37.7546604998905, -122.399380288765)
36382 36382 223498 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 255 Bartlett St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6006745.96401 2102320.90162 37.7529541496195 -122.41956348298001 (37.7529541496195, -122.41956348298)
37221 37221 223386 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3665 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6005227.0374300005 2104855.48781 37.759827855995205 -122.42499654287901 (37.7598278559952, -122.424996542879)
38118 38118 176257 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 13 Santa Ysabel Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6000825.3698 2093157.80225 37.7274591636907 -122.43938121158199 (37.7274591636907, -122.439381211582)
38241 38241 207574 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 447 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5992827.2239 2104547.6082099997 37.7582742708466 -122.46785865694599 (37.7582742708466, -122.467858656946)
38665 38665 191094 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1951 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6012582.07272 2102822.21844 37.754657662544396 -122.39941617174401 (37.7546576625444, -122.399416171744)
39459 39459 223403 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 3624 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6005621.17135 2101994.19422 37.7519936655859 -122.423430010205 (37.7519936655859, -122.423430010205)
40579 40579 223499 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 255 Bartlett St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6006746.2446 2102306.01848 37.752913299731 -122.41956145679801 (37.752913299731, -122.419561456798)
41664 41664 223536 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 4126 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6003045.79799 2100681.24519 37.7482429233912 -122.432242260973 (37.7482429233912, -122.432242260973)
43503 43503 126528 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 2865 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5999858.5831 2117397.02889 37.7939590162525 -122.444464683403 (37.7939590162525, -122.444464683403)
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)
47187 47187 207659 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1340 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5994898.23943 2106428.28078 37.7635574848094 -122.460832527225 (37.7635574848094, -122.460832527225)
47689 47689 189251 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 120 Loomis St 1 : 4 Tree 1 Private 1     1 Width 4ft   6010844.92077 2097998.29295 37.7413152397136 -122.405084094075 (37.7413152397136, -122.405084094075)
47846 47846 207531 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1325 18th Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5990492.61494 2106135.1233599996 37.76249807624271 -122.476048615548 (37.7624980762427, -122.476048615548)
49778 49778 207584 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 165 Merced Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5994383.58117 2099287.47444 37.7439210289412 -122.462094670844 (37.7439210289412, -122.462094670844)
51112 51112 126557 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1005 Sansome St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6011999.63961 2119254.38216 37.7997441211609 -122.402585850275 (37.7997441211609, -122.402585850275)
52331 52331 126558 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1005 Sansome St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6012003.3055 2119230.3844 37.7996784337747 -122.402571476413 (37.7996784337747, -122.402571476413)
52641 52641 207623 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1209 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5995446.62936 2107316.27502 37.7660272254875 -122.45900013246401 (37.7660272254875, -122.459000132464)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 724.953ms · Data source: data.sfgov.org