trees
2,421 rows where qSpecies_id = 8 sorted by Police Districts
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1511 | 260421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
| 3265 | 255205 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 3729 | 260419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
| 4341 | 255207 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 4693 | 255208 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 7451 | 255209 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 8207 | 47474 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 9047 | 47479 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
| 12861 | 253706 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
| 14527 | 255214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 16949 | 255206 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 17633 | 255212 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 18139 | 260420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
| 18342 | 253705 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
| 18784 | 255213 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 1628 | 72055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008082.6141 | 2119894.27994 | 37.8012816578905 | -122.416185586193 | (37.8012816578905, -122.416185586193) | 5 | 1 | 1 | 308 | 32 | |||
| 6449 | 71444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | 3 | 1 | 10 | 28860 | 6 | |||
| 8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
| 8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
| 10927 | 74852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | 3 | 1 | 10 | 308 | 4 | |||
| 12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 15002 | 73575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | 3 | 1 | 10 | 28860 | 6 | |||
| 15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 | ||
| 15688 | 126539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008917.81168 | 2119409.99919 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | 3 | 1 | 10 | 308 | 32 | |||
| 16533 | 74989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.412162212732 | (37.798876023557, -122.412162212732) | 3 | 1 | 10 | 308 | 4 | |||
| 25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
| 26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
| 27975 | 126544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008150.08042 | 2119430.1089 | 37.800010953609 | -122.415919233995 | (37.800010953609, -122.415919233995) | 5 | 1 | 1 | 308 | 32 | |||
| 32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 33909 | 71627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.7989453738906 | -122.402416977385 | (37.7989453738906, -122.402416977385) | 3 | 1 | 10 | 308 | 23 | ||
| 34935 | 126546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008154.11673 | 2119394.05894 | 37.7999121963461 | -122.415902712567 | (37.7999121963461, -122.415902712567) | 5 | 1 | 1 | 308 | 32 | |||
| 36123 | 126557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | 3 | 1 | 10 | 308 | 23 | |||
| 37659 | 62959 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.7965860510683 | -122.416344986535 | (37.7965860510683, -122.416344986535) | 5 | 1 | 10 | 28858 | 21 | |
| 39577 | 126542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 789 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009244.5501 | 2119059.64752 | 37.7990552287775 | -122.412105741595 | (37.7990552287775, -122.412105741595) | 3 | 1 | 10 | 308 | 4 | |||
| 40787 | 64563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.7949443413606 | -122.409858709005 | (37.7949443413606, -122.409858709005) | 3 | 1 | 10 | 28857 | 4 | |
| 41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
| 45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
| 45874 | 126550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.7986426917617 | -122.402360227452 | (37.7986426917617, -122.402360227452) | 3 | 1 | 10 | 308 | 23 | |||
| 47502 | 126551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012059.41755 | 2118828.15816 | 37.7985771500692 | -122.402349010193 | (37.7985771500692, -122.402349010193) | 3 | 1 | 10 | 308 | 23 | |||
| 53575 | 46871 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 54705 | 126555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | 3 | 1 | 10 | 308 | 23 | |||
| 59528 | 126534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008369.15173 | 2117857.28388 | 37.795704680394 | -122.415049773051 | (37.795704680394, -122.415049773051) | 5 | 1 | 10 | 28858 | 21 | |||
| 63290 | 126560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | 3 | 1 | 10 | 308 | 23 | |||
| 65679 | 126541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007346.83481 | 2121683.49611 | 37.8061529931217 | -122.418858679793 | (37.8061529931217, -122.418858679793) | 5 | 1 | 1 | 28858 | 32 | |||
| 70526 | 66093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.416894219588 | (37.8004974059005, -122.416894219588) | 5 | 1 | 1 | 308 | 32 | |
| 71572 | 126556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499876 | -122.402609980888 | (37.799883499876, -122.402609980888) | 3 | 1 | 10 | 308 | 23 | |||
| 78300 | 126552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012094.9021 | 2119101.47961 | 37.7993296056227 | -122.402245448777 | (37.7993296056227, -122.402245448777) | 3 | 1 | 10 | 28860 | 6 | |||
| 79356 | 66089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.97147 | 2120081.10266 | 37.8017685454413 | -122.417803248017 | (37.8017685454413, -122.417803248017) | 5 | 1 | 10 | 308 | 32 | |
| 86029 | 112676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |||
| 88936 | 88727 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51662 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 92474 | 32710 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776816 | 6008703.66491 | 2115446.6282 | 37.7891044021039 | -122.413721697414 | (37.7891044021039, -122.413721697414) | 5 | 1 | 10 | 28858 | 21 |
| 96112 | 126554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | 3 | 1 | 10 | 308 | 23 | |||
| 105051 | 108580 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
| 106009 | 108578 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
| 109118 | 42845 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 704 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 1 | Permit Number 42776 | 6007326.6292 | 2121624.2795 | 37.8059892616711 | -122.418924402261 | (37.8059892616711, -122.418924402261) | 5 | 1 | 1 | 28858 | 32 | |
| 112367 | 59922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1501 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19392 | 6009252.52632 | 2118479.54886 | 37.797462868466 | -122.412037123318 | (37.797462868466, -122.412037123318) | 3 | 1 | 10 | 308 | 21 | |
| 113991 | 126532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | 3 | 1 | 10 | 28857 | 4 | |||
| 116323 | 126538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | 3 | 1 | 10 | 308 | 32 | |||
| 124459 | 126545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008151.87492 | 2119410.8388 | 37.7999581436157 | -122.415911658989 | (37.7999581436157, -122.415911658989) | 5 | 1 | 1 | 308 | 32 | |||
| 129370 | 62958 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23344 | 6008125.85575238 | 2118255.57771401 | 37.7967846215561 | -122.415919842071 | (37.7967846215561, -122.415919842071) | 5 | 1 | 10 | 28858 | 21 | ||
| 130734 | 126548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008157.98833 | 2119355.87849 | 37.7998075800257 | -122.415886610195 | (37.7998075800257, -122.415886610195) | 5 | 1 | 1 | 308 | 32 | |||
| 136867 | 126533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008367.41227 | 2117875.57513 | 37.7957548058969 | -122.415057087242 | (37.7957548058969, -122.415057087242) | 5 | 1 | 10 | 28858 | 21 | |||
| 143270 | 88403 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071 | 2119078 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | 3 | 1 | 10 | 308 | 32 | ||
| 146857 | 126543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008144.06268 | 2119447.51141 | 37.8000583982326 | -122.415941290758 | (37.8000583982326, -122.415941290758) | 5 | 1 | 1 | 308 | 32 | |||
| 148110 | 126540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509 | -122.414125355424 | (37.800243203509, -122.414125355424) | 3 | 1 | 10 | 308 | 32 | |||
| 164066 | 64564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1011 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 11 | Permit Number 25456 | 6009907.55581 | 2117242.96669 | 37.7941042450764 | -122.409683212627 | (37.7941042450764, -122.409683212627) | 3 | 1 | 10 | 28857 | 21 | |
| 165412 | 46870 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 167960 | 126535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008372.45938 | 2117840.81731 | 37.7956596531341 | -122.415037161853 | (37.7956596531341, -122.415037161853) | 5 | 1 | 10 | 28858 | 21 | |||
| 169709 | 126558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | 3 | 1 | 10 | 308 | 23 | |||
| 172916 | 62981 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1317 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 11 | Permit Number 23371 | 6007225.76848 | 2118431.56402 | 37.7972171916732 | -122.419046847643 | (37.7972171916732, -122.419046847643) | 5 | 1 | 10 | 28858 | 32 | |
| 173635 | 126547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.7998627156539 | -122.41589197733 | (37.7998627156539, -122.41589197733) | 5 | 1 | 1 | 308 | 32 | |||
| 177723 | 37514 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782092 | 6007700.5704 | 2114390.54622 | 37.7861482783715 | -122.417117424144 | (37.7861482783715, -122.417117424144) | 13 | 1 | 9 | 28858 | 36 |
| 187764 | 108579 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
| 194176 | 126553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.402179267671 | (37.7993378371204, -122.402179267671) | 3 | 1 | 10 | 28860 | 6 | |||
| 98310 | 63152 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23688 | 6008095.93385005 | 2113196.54307112 | 37.7828920680587 | -122.415664995853 | (37.7828920680587, -122.415664995853) | 7 | 10 | 9 | 28852 | 36 | ||
| 114137 | 253629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
| 119957 | 253631 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6009957.29008 | 2113442.89538 | 37.7836729493992 | -122.409242840109 | (37.7836729493992, -122.409242840109) | 14 | 10 | 9 | 28852 | 36 | ||||
| 134922 | 106798 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009957 | 2113442 | 37.783670474647 | -122.409243780474 | (37.783670474647, -122.409243780474) | 14 | 10 | 9 | 28852 | 36 | ||||
| 181047 | 253628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
| 1156 | 31893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.7706159506067 | -122.414182168285 | (37.7706159506067, -122.414182168285) | 8 | 2 | 9 | 28853 | 19 | |
| 2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
| 9156 | 73920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008409.30532 | 2108731.32076 | 37.7706492380987 | -122.414264830382 | (37.7706492380987, -122.414264830382) | 8 | 2 | 9 | 28853 | 19 | |||
| 9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
| 9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
| 14957 | 85546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
| 15417 | 224105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006280.26739 | 2109523.46395 | 37.7727044515829 | -122.421685485523 | (37.7727044515829, -122.421685485523) | 8 | 2 | 9 | 28853 | 19 | |||
| 15449 | 85521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
| 17486 | 191662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013078.45063 | 2110885.87068 | 37.776826313422 | -122.398265274217 | (37.776826313422, -122.398265274217) | 6 | 2 | 9 | 28856 | 34 | |||
| 17998 | 85553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 332 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008375 | 2108695 | 37.7705475827471 | -122.414380922989 | (37.7705475827471, -122.414380922989) | 8 | 2 | 9 | 28853 | 19 | |||
| 18144 | 70989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 779764 | 6008399.52743 | 2108738.25581 | 37.770667730873 | -122.414299143103 | (37.770667730873, -122.414299143103) | 8 | 2 | 9 | 28853 | 19 | ||
| 18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
| 21310 | 254733 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3x3 | 6008656 | 2108503 | 37.7700361768699 | -122.413395357755 | (37.7700361768699, -122.413395357755) | 8 | 2 | 9 | 28853 | 19 | |||
| 24502 | 191066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011926.00282 | 2111797.31864 | 37.7792646776498 | -122.40231606173 | (37.7792646776498, -122.40231606173) | 14 | 2 | 9 | 28856 | 34 | |||
| 31166 | 191060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.403252800969 | (37.7789796735174, -122.403252800969) | 14 | 2 | 9 | 28856 | 34 | |||
| 32023 | 85527 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 33288 | 191666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.7772741883968 | -122.397701819284 | (37.7772741883968, -122.397701819284) | 6 | 2 | 9 | 28856 | 34 | |||
| 36375 | 191665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013224.69067 | 2111029.20074 | 37.7772280099979 | -122.397769438408 | (37.7772280099979, -122.397769438408) | 6 | 2 | 9 | 28856 | 34 | |||
| 42967 | 173911 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
| 43105 | 85526 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 46431 | 173910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );