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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 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) | |||
| 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) | |||
| 1100 | 1100 | 2952 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2001 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004785.43 | 2115651.1441 | 37.789445140420604 | -122.427292872615 | (37.7894451404206, -122.427292872615) | |||
| 1729 | 1729 | 223604 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007683.47887 | 2107616.2985400003 | 37.7675468513265 | -122.41669647756599 | (37.7675468513265, -122.416696477566) | |||
| 1827 | 1827 | 251744 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002620.0 | 2086992.0 | 37.710631205907 | -122.43273690550899 | (37.710631205907, -122.432736905509) | ||||
| 1840 | 1840 | 251759 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 248 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001757.0 | 2086582.0 | 37.709456453529796 | -122.43569030601002 | (37.7094564535298, -122.43569030601) | ||||
| 1849 | 1849 | 251761 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001827.0 | 2086593.0 | 37.709490632951706 | -122.43544916105199 | (37.7094906329517, -122.435449161052) | ||||
| 1859 | 1859 | 251772 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 1861 | 1861 | 251780 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001110.0 | 2087312.0 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | ||||
| 1874 | 1874 | 251773 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 2026 | 2026 | 252856 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 2035 | 2035 | 252855 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 2516 | 2516 | 251771 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 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) | |||
| 2540 | 2540 | 141909 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.779218827498205 | -122.427751880486 | (37.7792188274982, -122.427751880486) | |||
| 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) | ||
| 2674 | 2674 | 223658 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003665.26948 | 2095270.38526 | 37.7334210492488 | -122.429714281988 | (37.7334210492488, -122.429714281988) | ||
| 2678 | 2678 | 223657 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003655.959980001 | 2095270.88152 | 37.7334218847062 | -122.429746502924 | (37.7334218847062, -122.429746502924) | ||
| 2680 | 2680 | 223656 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 18811 | 6003648.753819999 | 2095269.66073 | 37.7334181246305 | -122.42977132959601 | (37.7334181246305, -122.429771329596) | ||
| 2685 | 2685 | 223659 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003694.10013 | 2095275.57225 | 37.7334369240608 | -122.42961497614901 | (37.7334369240608, -122.429614976149) | ||
| 3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
| 3406 | 3406 | 172261 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6001860.0 | 2086600.0 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | |||
| 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) | |||
| 3749 | 3749 | 223601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007724.0 | 2106220.0 | 37.7637152201621 | -122.41645740380899 | (37.7637152201621, -122.416457403809) | |||
| 4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
| 4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 5159 | 5159 | 242086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | |||
| 6880 | 6880 | 18913 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.789593716919704 | -122.43645393002599 | (37.7895937169197, -122.436453930026) | |||
| 9174 | 9174 | 6373 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | |||
| 10212 | 10212 | 173910 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10213 | 10213 | 173644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10216 | 10216 | 173911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10622 | 10622 | 15860 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.44345454060199 | (37.7139670145471, -122.443454540602) | |||
| 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) | |||||
| 14680 | 14680 | 26127 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015993.0176 | 2094731.6994 | 37.7326322840804 | -122.38705584245199 | (37.7326322840804, -122.387055842452) | |||
| 14726 | 14726 | 6733 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | |||
| 14736 | 14736 | 6734 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017044.07799 | 2097171.2102099997 | 37.739388838832504 | -122.383591809817 | (37.7393888388325, -122.383591809817) | |||
| 16121 | 16121 | 26100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.38994422273198 | (37.7342605555935, -122.389944222732) | |||
| 16567 | 16567 | 26102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015232.536 | 2095297.3479 | 37.73414330023979 | -122.389724529704 | (37.7341433002398, -122.389724529704) | |||
| 18802 | 18802 | 509 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008975.21686 | 2102392.50435 | 37.7532760709475 | -122.411859333666 | (37.7532760709475, -122.411859333666) | |||
| 19912 | 19912 | 27292 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 56 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001688.66279 | 2095714.9103400002 | 37.7345294879464 | -122.436579762262 | (37.7345294879464, -122.436579762262) | |||
| 19983 | 19983 | 4397 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004431.54351 | 2102978.61798 | 37.7546294472032 | -122.427614046667 | (37.7546294472032, -122.427614046667) | |||
| 20586 | 20586 | 22918 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006138.942840001 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | |||
| 20683 | 20683 | 12972 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001913.39953 | 2095585.0292900002 | 37.734185633051894 | -122.435793484091 | (37.7341856330519, -122.435793484091) | |||
| 21151 | 21151 | 10207 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1273 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6005836.971940001 | 2101563.9580099997 | 37.7508245136462 | -122.422653168634 | (37.7508245136462, -122.422653168634) | |||
| 21318 | 21318 | 27510 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6005834.02618 | 2101632.44152 | 37.751012387419706 | -122.422668221463 | (37.7510123874197, -122.422668221463) | |||
| 22381 | 22381 | 17744 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1600X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006169.663819999 | 2115620.29477 | 37.789438622529204 | -122.42250137744101 | (37.7894386225292, -122.422501377441) | |||
| 23033 | 23033 | 27530 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6013528.91672 | 2096649.2761900001 | 37.73776079882371 | -122.39570921391199 | (37.7377607988237, -122.395709213912) | |||
| 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) | |||
| 23816 | 23816 | 224059 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.76427650537521 | -122.43386694650499 | (37.7642765053752, -122.433866946505) | |||
| 23983 | 23983 | 224070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000003.97958 | 2105733.8947099997 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | |||
| 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) | |||
| 24032 | 24032 | 207660 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996711.4694300005 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | |||
| 24108 | 24108 | 223503 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.750546046666706 | -122.41878967662 | (37.7505460466667, -122.41878967662) | |||
| 24291 | 24291 | 207706 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 215 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5998739.57891 | 2093599.69117 | 37.7285535657887 | -122.446623550035 | (37.7285535657887, -122.446623550035) | |||
| 24319 | 24319 | 176264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010291.19923 | 2093895.2108900002 | 37.7300180820504 | -122.40670958899099 | (37.7300180820504, -122.406709588991) | |||
| 24524 | 24524 | 223397 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3560 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005876.75311 | 2104933.14392 | 37.7600777604998 | -122.422755010534 | (37.7600777604998, -122.422755010534) | |||
| 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) | |||
| 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) | |||
| 24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
| 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) | |||
| 25196 | 25196 | 137812 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | |||
| 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) | |||
| 25711 | 25711 | 223380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009884.795080001 | 2104504.34853 | 37.7591257084916 | -122.40886279708499 | (37.7591257084916, -122.408862797085) | |||
| 25760 | 25760 | 223377 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010298.3381900005 | 2101037.92652 | 37.7496308398979 | -122.407188209083 | (37.7496308398979, -122.407188209083) | |||
| 25831 | 25831 | 124534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992622.68332 | 2111346.9142400003 | 37.7769315430211 | -122.46906087290701 | (37.7769315430211, -122.469060872907) | |||
| 25939 | 25939 | 223572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 801 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008169.79 | 2095684.73442 | 37.7348128040698 | -122.414170142558 | (37.7348128040698, -122.414170142558) | |||
| 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) | |||
| 26240 | 26240 | 207694 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991855.32533 | 2096348.4574 | 37.7357053452243 | -122.470622695389 | (37.7357053452243, -122.470622695389) | |||
| 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) | |||
| 26513 | 26513 | 207686 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990741.806609999 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | |||
| 26575 | 26575 | 207688 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.47512666388799 | (37.7412797470716, -122.475126663888) | |||
| 26626 | 26626 | 123725 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 549 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993866.33866 | 2110708.86626 | 37.7752514134392 | -122.46471237833799 | (37.7752514134392, -122.464712378338) | |||
| 26741 | 26741 | 126534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1551 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008369.15173 | 2117857.28388 | 37.795704680394 | -122.415049773051 | (37.795704680394, -122.415049773051) | |||
| 26791 | 26791 | 223457 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998436.79798 | 2105994.15168 | 37.7625684428081 | -122.448562558536 | (37.7625684428081, -122.448562558536) | |||
| 26818 | 26818 | 124535 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992606.88484 | 2111346.72253 | 37.7769301037952 | -122.469115510242 | (37.7769301037952, -122.469115510242) | |||
| 26968 | 26968 | 223578 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006732.92847 | 2098549.7578 | 37.7425987089604 | -122.41934105903799 | (37.7425987089604, -122.419341059038) | |||
| 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) | |||
| 27090 | 27090 | 99644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.49266425054701 | (37.7538960444293, -122.492664250547) | ||
| 27188 | 27188 | 138860 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 523 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004843.1098 | 2111063.3665 | 37.7768515029621 | -122.426766456726 | (37.7768515029621, -122.426766456726) | |||
| 27220 | 27220 | 223532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 529 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.744786420455604 | -122.434163917953 | (37.7447864204556, -122.434163917953) | |||
| 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) | |||
| 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) | |||
| 27391 | 27391 | 244450 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 600 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003616.0838 | 2109707.0129 | 37.773057839402796 | -122.430914285765 | (37.7730578394028, -122.430914285765) | |||
| 27448 | 27448 | 223517 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999663.10864 | 2101754.10727 | 37.7509963650963 | -122.44401653863001 | (37.7509963650963, -122.44401653863) | |||
| 27612 | 27612 | 207552 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993922.19207 | 2106326.17113 | 37.7632209099368 | -122.464200926233 | (37.7632209099368, -122.464200926233) | |||
| 27771 | 27771 | 245044 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 155 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | |||
| 27840 | 27840 | 223489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 469 Tompkins Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.737232809540004 | -122.415232573728 | (37.73723280954, -122.415232573728) | |||
| 27871 | 27871 | 248510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861004 | -122.449287603561 | (37.767563696861, -122.449287603561) | |||
| 27900 | 27900 | 111560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | |||
| 28046 | 28046 | 207672 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993147.42915 | 2105300.29395 | 37.76035943445 | -122.46680597172801 | (37.76035943445, -122.466805971728) | |||
| 28353 | 28353 | 207561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992400.09167 | 2105443.1565799997 | 37.7607085377924 | -122.469401040143 | (37.7607085377924, -122.469401040143) | |||
| 28370 | 28370 | 207590 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 434 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998520.921569999 | 2094401.97974 | 37.7307439689499 | -122.447437181086 | (37.7307439689499, -122.447437181086) | |||
| 28440 | 28440 | 122307 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.47630725349701 | (37.7766000733292, -122.476307253497) |
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");