Data source: data.sfgov.org
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137271 | 137271 | 191088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 01st St | 19 | : Yard 23 | Tree 1 | Private 1 | 18 | 6014455.34951 | 2105889.6924799997 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | ||||
| 129487 | 129487 | 115382 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 625 Moultrie St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | ||
| 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) | |||
| 150194 | 150194 | 246625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3300 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009033.3388 | 2099395.8346 | 37.7450511430894 | -122.411446641942 | (37.7450511430894, -122.411446641942) | ||||
| 13315 | 13315 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 100x OGDEN AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||||
| 122239 | 122239 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 4355 ANZA ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | ||||
| 24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 172751 | 172751 | 224097 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6002522.9823199995 | 2101416.25277 | 37.7502314233618 | -122.434102675005 | (37.7502314233618, -122.434102675005) | |||
| 32354 | 32354 | 224078 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 37 Mars St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 5999600.0223900005 | 2105581.97574 | 37.761503152657106 | -122.444509776331 | (37.7615031526571, -122.444509776331) | |||
| 34670 | 34670 | 185158 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.49380155463699 | (37.7388527871834, -122.493801554637) | |||
| 36646 | 36646 | 191087 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | ||||
| 40591 | 40591 | 191084 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6014440.039609999 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | ||||
| 51462 | 51462 | 191085 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6014420.63086 | 2105780.4317900003 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | ||||
| 59512 | 59512 | 104074 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 2 | Permit Number 770392 | 5986000.25731 | 2110187.13166 | 37.7733622428275 | -122.491884144737 | (37.7733622428275, -122.491884144737) | ||
| 73147 | 73147 | 191083 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597748998 | (37.7628958266015, -122.39315597749) | ||||
| 75029 | 75029 | 181341 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985179.8406 | 2097655.4564 | 37.738905739718795 | -122.49379838145501 | (37.7389057397188, -122.493798381455) | |||
| 82440 | 82440 | 103917 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 87135 | 87135 | 103919 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 121549 | 121549 | 103923 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 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) | |||
| 138966 | 138966 | 103921 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 141000 | 141000 | 103915 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 153372 | 153372 | 191086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | |||
| 11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 121120 | 121120 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 748 Treat Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 8 | 3x3 | 6008496.2 | 2104169.0 | 37.758127039951205 | -122.41364151852801 | (37.7581270399512, -122.413641518528) | |||
| 116818 | 116818 | 113391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2151 15TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602.0 | 2100781.0 | 37.7478613219593 | -122.47182147099899 | (37.7478613219593, -122.471821470999) | |
| 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) | |||
| 159291 | 159291 | 223373 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Bosworth St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6003068.252 | 2095170.8031799998 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | ||||
| 180123 | 180123 | 223533 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 53 Newburg St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 10ft | 6002432.22452 | 2099844.0691299997 | 37.7459094263876 | -122.43430413393601 | (37.7459094263876, -122.434304133936) | |||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 91273 | 91273 | 107688 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 6008820.4 | 2095497.5 | 37.734335221774394 | -122.411907523711 | (37.7343352217744, -122.411907523711) | ||||
| 97416 | 97416 | 96594 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 115664 | 115664 | 85184 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 501 Bartlett St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822.0 | 2100867.0 | 37.748966349809606 | -122.419197411761 | (37.7489663498096, -122.419197411761) | |||
| 116314 | 116314 | 96592 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 121581 | 121581 | 96589 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 2565 | 2565 | 191072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.770338555601505 | -122.41354738542101 | (37.7703385556015, -122.413547385421) | ||
| 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) | |||
| 24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
| 28441 | 28441 | 189265 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536001 | (37.7416407727111, -122.40119276536) | |||
| 28661 | 28661 | 189257 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2231 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | |||
| 28700 | 28700 | 189264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2207 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011951.89121 | 2098108.4509400004 | 37.741679530779294 | -122.401264295606 | (37.7416795307793, -122.401264295606) | |||
| 29324 | 29324 | 246575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005230.8128 | 2109313.1532400004 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | |||
| 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) | |||
| 32052 | 32052 | 189240 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013877.57271 | 2103955.2138 | 37.7578407445781 | -122.39501530244 | (37.7578407445781, -122.39501530244) | |||
| 32578 | 32578 | 189248 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1575 Bay Shore Blvd | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011796.69629 | 2092248.5093 | 37.7255806984826 | -122.401389189886 | (37.7255806984826, -122.401389189886) | |||
| 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) | |||
| 33710 | 33710 | 191077 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 334 12th St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6008423.37153 | 2108669.51917 | 37.770480335524894 | -122.414211801833 | (37.7704803355249, -122.414211801833) | |||
| 36121 | 36121 | 189263 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2211 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011935.60653 | 2098120.24236 | 37.7417109989595 | -122.401321431357 | (37.7417109989595, -122.401321431357) | |||
| 36333 | 36333 | 189242 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013899.94699 | 2103926.17826 | 37.757762263422705 | -122.394935888703 | (37.7577622634227, -122.394935888703) | |||
| 36717 | 36717 | 191109 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011772.01455 | 2102301.09153 | 37.753181579175404 | -122.40218095120399 | (37.7531815791754, -122.402180951204) | |||
| 37308 | 37308 | 191071 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008644.67271 | 2108598.9889599998 | 37.7702991041399 | -122.413441328359 | (37.7702991041399, -122.413441328359) | |||
| 38407 | 38407 | 250069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 307 Austin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005709.21572 | 2115345.18544 | 37.7886572546664 | -122.424074905926 | (37.7886572546664, -122.424074905926) | |||
| 39807 | 39807 | 246473 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004475.07524 | 2099887.00412 | 37.7461430567683 | -122.427243293056 | (37.7461430567683, -122.427243293056) | |||
| 39850 | 39850 | 207617 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 385 Victoria St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993228.76427 | 2089783.4849099999 | 37.717758864755794 | -122.46539747963001 | (37.7177588647558, -122.46539747963) | |||
| 40237 | 40237 | 189241 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013889.32799 | 2103940.39875 | 37.75780071933279 | -122.394973609851 | (37.7578007193328, -122.394973609851) | |||
| 40355 | 40355 | 207621 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993736.2843 | 2088924.46634 | 37.7154294623887 | -122.463580914754 | (37.7154294623887, -122.463580914754) | |||
| 40539 | 40539 | 189270 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 59 Robblee Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | |||
| 41573 | 41573 | 189255 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2249 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011757.211209999 | 2097196.1976799998 | 37.739163814067396 | -122.40187332639499 | (37.7391638140674, -122.401873326395) | |||
| 42199 | 42199 | 207620 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993530.060819999 | 2090669.11588 | 37.7202079660024 | -122.46442030687099 | (37.7202079660024, -122.464420306871) | |||
| 43225 | 43225 | 191064 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011636.45479 | 2111621.6337599996 | 37.778766120497295 | -122.403305371746 | (37.7787661204973, -122.403305371746) | |||
| 43807 | 43807 | 191073 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 352 12th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008306.80877 | 2108790.44152 | 37.7708058118746 | -122.41462355283998 | (37.7708058118746, -122.41462355284) | |||
| 44316 | 44316 | 191057 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 Saint Francis Pl | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6013212.85575 | 2113183.5161599996 | 37.78314260738 | -122.39796154170901 | (37.78314260738, -122.397961541709) | |||
| 44765 | 44765 | 246572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6005238.2187 | 2109262.1859999998 | 37.7719282296287 | -122.42527145302601 | (37.7719282296287, -122.425271453026) | |||
| 46847 | 46847 | 191076 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 320 12th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008335.79472 | 2108708.57829 | 37.7705826631 | -122.414517495805 | (37.7705826631, -122.414517495805) | |||
| 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) | |||
| 47949 | 47949 | 207615 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | |||
| 48099 | 48099 | 207613 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 171 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997069.50028 | 2088848.5087700002 | 37.7154123950516 | -122.45205442099 | (37.7154123950516, -122.45205442099) | |||
| 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) | |||
| 50565 | 50565 | 246488 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004022.94651 | 2099813.62498 | 37.7459159950372 | -122.428801466541 | (37.7459159950372, -122.428801466541) | |||
| 50577 | 50577 | 191067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 374 06th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011934.76855 | 2111785.94153 | 37.779233928048 | -122.402284937117 | (37.779233928048, -122.402284937117) | |||
| 53543 | 53543 | 189266 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 550 Bay Shore Blvd | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6010210.57589 | 2097161.88665 | 37.7389831663466 | -122.407218500042 | (37.7389831663466, -122.407218500042) | |||
| 56916 | 56916 | 246579 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 140 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005220.7586 | 2109411.73941 | 37.772337880726 | -122.425342493187 | (37.772337880726, -122.425342493187) | |||
| 58142 | 58142 | 189258 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2231 Newcomb Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011848.21009 | 2098186.58426 | 37.741888283226 | -122.40162828271299 | (37.741888283226, -122.401628282713) | |||
| 58901 | 58901 | 191078 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 394 12th St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008574.85023 | 2108580.21149 | 37.7702436249715 | -122.413681516591 | (37.7702436249715, -122.413681516591) | |||
| 59407 | 59407 | 191111 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6011810.68033 | 2102303.0748 | 37.7531891829555 | -122.402047375812 | (37.7531891829555, -122.402047375812) | |||
| 59884 | 59884 | 191069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6008685.67935 | 2108575.6998799997 | 37.770237460112 | -122.413297838836 | (37.770237460112, -122.413297838836) | |||
| 61582 | 61582 | 189260 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2223 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011881.3428 | 2098161.01193 | 37.7418199158556 | -122.401511923044 | (37.7418199158556, -122.401511923044) | |||
| 64501 | 64501 | 191079 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1559 Howard St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6007858.27887 | 2109378.1367200003 | 37.7723942745191 | -122.416216661379 | (37.7723942745191, -122.416216661379) | |||
| 65127 | 65127 | 189243 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013912.25282 | 2103910.20868 | 37.757719098672 | -122.39489221129999 | (37.757719098672, -122.3948922113) | |||
| 65952 | 65952 | 191070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008653.1077 | 2108592.5301900003 | 37.770281843468794 | -122.413411694812 | (37.7702818434688, -122.413411694812) | |||
| 69540 | 69540 | 189239 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 670 Texas St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013865.85822 | 2103972.02889 | 37.7578862637531 | -122.39505699408998 | (37.7578862637531, -122.39505699409) | |||
| 70646 | 70646 | 191068 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010213.082230001 | 2110716.2431099997 | 37.776200530977896 | -122.40816552573901 | (37.7762005309779, -122.408165525739) | |||
| 70731 | 70731 | 189252 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Loomis St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6010838.98568 | 2097984.0880299998 | 37.74127590426679 | -122.40510361565 | (37.7412759042668, -122.40510361565) | |||
| 71390 | 71390 | 246489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004042.8614 | 2099814.35756 | 37.745919133669 | -122.42873265580299 | (37.745919133669, -122.428732655803) | |||
| 72085 | 72085 | 191061 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 0 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | |||
| 74605 | 74605 | 217746 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 631 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5996538.5455 | 2107286.52393 | 37.7660082444099 | -122.455221286434 | (37.7660082444099, -122.455221286434) | |||
| 74875 | 74875 | 189272 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1789 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014048.88892 | 2096189.76773 | 37.7365279946626 | -122.393879249144 | (37.7365279946626, -122.393879249144) | |||
| 75307 | 75307 | 191075 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 352 12th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008288.60526 | 2108804.28402 | 37.770842797396604 | -122.41468749912201 | (37.7708427973966, -122.414687499122) | |||
| 75312 | 75312 | 191063 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011640.41223 | 2111625.07225 | 37.778775782817604 | -122.40329192328699 | (37.7787757828176, -122.403291923287) | |||
| 75912 | 75912 | 189238 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2126 24th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | |||
| 77053 | 77053 | 217739 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 695 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996222.62463 | 2107246.57774 | 37.76588043186471 | -122.45631109749901 | (37.7658804318647, -122.456311097499) | |||
| 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) | |||
| 130731 | 130731 | 207610 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 51 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997347.38565 | 2089696.67863 | 37.7177571866363 | -122.451155061159 | (37.7177571866363, -122.451155061159) | |||
| 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) |
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");