trees
74 rows where Fire Prevention Districts = 7 and qSpecies_id = 8
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1541 | 70231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | 7 | 9 | 11 | 28852 | 10 | |||
| 2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
| 4522 | 141909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.7792188274982 | -122.427751880486 | (37.7792188274982, -122.427751880486) | 7 | 9 | 11 | 29490 | 41 | |||
| 6315 | 46517 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | ||
| 7024 | 141437 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005239.6877 | 2110933.7323 | 37.7765179730819 | -122.425385345316 | (37.7765179730819, -122.425385345316) | 7 | 9 | 11 | 28852 | 10 | |||
| 11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
| 18297 | 51025 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | 7 | 9 | 5 | 28852 | 10 | |||
| 31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
| 32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 33012 | 138860 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 523 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004843.1098 | 2111063.3665 | 37.7768515029621 | -122.426766456726 | (37.7768515029621, -122.426766456726) | 7 | 9 | 11 | 28852 | 10 | |||
| 33184 | 31346 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 5 | Permit Number 34957 | 6004784.8126 | 2111056.6827 | 37.7768298546653 | -122.426967648313 | (37.7768298546653, -122.426967648313) | 7 | 9 | 11 | 28852 | 10 | |
| 34618 | 63613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24252 | 6005229.19307431 | 2109538.39058576 | 37.7726861107413 | -122.425322331795 | (37.7726861107413, -122.425322331795) | 7 | 9 | 11 | 28852 | 10 | ||
| 37947 | 224082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004326.71028 | 2109072.08218 | 37.7713547130825 | -122.428410875685 | (37.7713547130825, -122.428410875685) | 7 | 9 | 11 | 28852 | 10 | |||
| 38299 | 66118 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29177 | 6004443.55987266 | 2109134.3816324 | 37.771532383715 | -122.428011127655 | (37.771532383715, -122.428011127655) | 7 | 9 | 11 | 28852 | 10 | ||
| 47759 | 246581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 184 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6005207.86965 | 2109476.17522 | 37.772514077681 | -122.425391663601 | (37.772514077681, -122.425391663601) | 7 | 9 | 11 | 28852 | 10 | |||
| 48492 | 141906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | 7 | 9 | 11 | 29490 | 41 | |||
| 51071 | 246580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005210.93182 | 2109452.28431 | 37.7724486520281 | -122.425379370776 | (37.7724486520281, -122.425379370776) | 7 | 9 | 11 | 28852 | 10 | |||
| 51136 | 224091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004510.25041 | 2109143.13465 | 37.7715601901838 | -122.427781065151 | (37.7715601901838, -122.427781065151) | 7 | 9 | 11 | 28852 | 10 | |||
| 58419 | 32155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 521 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 7 | Permit Number 35505 | 6004828.77889 | 2111059.03276 | 37.7768387933121 | -122.426815722994 | (37.7768387933121, -122.426815722994) | 7 | 9 | 11 | 28852 | 10 | ||
| 59517 | 139858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 702 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005734.4525 | 2112096.2581 | 37.779737926575 | -122.4237564888 | (37.779737926575, -122.4237564888) | 7 | 9 | 11 | 28852 | 41 | |||
| 60161 | 33723 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 71932 | 88741 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 72095 | 58393 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 511 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2008 12:00:00 AM | 20 | 3x3 | Permit Number 51724 | 6005404.80617926 | 2110951.74140997 | 37.7765767492195 | -122.424815434114 | (37.7765767492195, -122.424815434114) | 7 | 9 | 11 | 28852 | 10 | |
| 72717 | 246573 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.425276447877 | (37.771957957636, -122.425276447877) | 7 | 9 | 11 | 28852 | 10 | |||
| 73987 | 14750 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 940 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2000 12:00:00 AM | 3 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
| 75073 | 63599 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | 8x6 | Permit Number 24233 | 6004551.34106685 | 2109096.89343089 | 37.7714355473733 | -122.427635635138 | (37.7714355473733, -122.427635635138) | 7 | 9 | 11 | 28852 | 10 | |
| 75209 | 224088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004610.98363 | 2109155.17088 | 37.7715989365628 | -122.427433480775 | (37.7715989365628, -122.427433480775) | 7 | 9 | 11 | 28852 | 10 | |||
| 81351 | 31348 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.7766352121679 | -122.42638959957 | (37.7766352121679, -122.42638959957) | 7 | 9 | 11 | 28852 | 10 | ||
| 85115 | 100357 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
| 87301 | 224087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 216 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004639.34009 | 2109155.86974 | 37.7716024592153 | -122.427335443897 | (37.7716024592153, -122.427335443897) | 7 | 9 | 11 | 28852 | 10 | |||
| 87541 | 83184 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51667 | 6004633.65578728 | 2109108.35984762 | 37.7714716870977 | -122.427351721243 | (37.7714716870977, -122.427351721243) | 7 | 9 | 11 | 28852 | 10 | ||
| 93556 | 224095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004037.99786 | 2108888.07328 | 37.77083312788 | -122.429396421106 | (37.77083312788, -122.429396421106) | 7 | 9 | 11 | 29492 | 10 | |||
| 96474 | 142259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004708.2263 | 2110563.0976 | 37.7754702599594 | -122.427197416812 | (37.7754702599594, -122.427197416812) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||
| 98434 | 224090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004557.93322 | 2109147.67974 | 37.7715753671272 | -122.427616451463 | (37.7715753671272, -122.427616451463) | 7 | 9 | 11 | 28852 | 10 | |||
| 102272 | 64786 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25781 | 6005246.79588468 | 2109227.98306531 | 37.7718348011935 | -122.425239349655 | (37.7718348011935, -122.425239349655) | 7 | 9 | 11 | 28852 | 10 | ||
| 103766 | 224084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004527.68926 | 2109092.69188 | 37.7714226730598 | -122.427717148539 | (37.7714226730598, -122.427717148539) | 7 | 9 | 11 | 28852 | 10 | |||
| 109183 | 246574 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6005235.59585 | 2109292.29359 | 37.7720107496197 | -122.425282668482 | (37.7720107496197, -122.425282668482) | 7 | 9 | 11 | 28852 | 10 | |||
| 111285 | 33722 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 113456 | 139822 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005086 | 2111993 | 37.7794177784995 | -122.425992418184 | (37.7794177784995, -122.425992418184) | 7 | 9 | 11 | 28852 | 41 | |||
| 114388 | 224085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004536.35935 | 2109097.26869 | 37.7714357303029 | -122.427687484405 | (37.7714357303029, -122.427687484405) | 7 | 9 | 11 | 28852 | 10 | |||
| 115234 | 224083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 285 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004355.4783 | 2109071.91707 | 37.7713558875841 | -122.428311353983 | (37.7713558875841, -122.428311353983) | 7 | 9 | 11 | 28852 | 10 | |||
| 116146 | 246582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | 7 | 9 | 11 | 28852 | 10 | |||
| 117720 | 224094 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004048.7307 | 2108889.92984 | 37.7708388331853 | -122.42935942839 | (37.7708388331853, -122.42935942839) | 7 | 9 | 11 | 29492 | 10 | |||
| 118432 | 63598 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | Permit Number 24232 | 6004516.72851683 | 2109144.57400335 | 37.7715645087532 | -122.427758759583 | (37.7715645087532, -122.427758759583) | 7 | 9 | 11 | 28852 | 10 | ||
| 120322 | 54863 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 214 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1987 12:00:00 AM | Permit Number 24224 | 6005092.72768528 | 2109571.89850043 | 37.7727704046159 | -122.425796766194 | (37.7727704046159, -122.425796766194) | 7 | 9 | 11 | 28852 | 10 | ||
| 124905 | 246577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | 7 | 9 | 11 | 28852 | 10 | |||
| 128406 | 246572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6005238.2187 | 2109262.186 | 37.7719282296287 | -122.425271453026 | (37.7719282296287, -122.425271453026) | 7 | 9 | 11 | 28852 | 10 | |||
| 128831 | 50287 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 184 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46998 | 6005208.32538613 | 2109504.30413696 | 37.7725913386303 | -122.425392089284 | (37.7725913386303, -122.425392089284) | 7 | 9 | 11 | 28852 | 10 | ||||
| 130476 | 42780 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 523 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 6 | Permit Number 42749 | 6004831.2275 | 2111061.5099 | 37.7768457333764 | -122.426807428963 | (37.7768457333764, -122.426807428963) | 7 | 9 | 11 | 28852 | 10 | |
| 130525 | 224086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004621.17543 | 2109107.92251 | 37.7714697804289 | -122.427394860302 | (37.7714697804289, -122.427394860302) | 7 | 9 | 11 | 28852 | 10 | |||
| 132271 | 141989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1019 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004298.7778 | 2111838.3869 | 37.7789487270827 | -122.42870472731 | (37.7789487270827, -122.42870472731) | 7 | 9 | 11 | 29490 | 41 | |||
| 134877 | 63600 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 232 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | Permit Number 24234 | 6004580.75107621 | 2109153.49232734 | 37.7715926177163 | -122.427537937355 | (37.7715926177163, -122.427537937355) | 7 | 9 | 11 | 28852 | 10 | ||
| 138813 | 139857 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005751.5937 | 2112096.7775 | 37.7797403203321 | -122.423697226772 | (37.7797403203321, -122.423697226772) | 7 | 9 | 11 | 28852 | 41 | |||
| 139588 | 246579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 Laguna St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6005220.7586 | 2109411.73941 | 37.772337880726 | -122.425342493187 | (37.772337880726, -122.425342493187) | 7 | 9 | 11 | 28852 | 10 | |||
| 139624 | 63612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 216 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24249 | 6004653.91972039 | 2109163.68469829 | 37.7716247417412 | -122.427285568873 | (37.7716247417412, -122.427285568873) | 7 | 9 | 11 | 28852 | 10 | ||
| 146300 | 32154 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 521 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 6 | Permit Number 35505 | 6004839.16565 | 2111059.45396 | 37.7768405370874 | -122.426779822042 | (37.7768405370874, -122.426779822042) | 7 | 9 | 11 | 28852 | 10 | ||
| 149291 | 246575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6005230.8128 | 2109313.15324 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | 7 | 9 | 11 | 28852 | 10 | |||
| 151841 | 224092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004449.56008 | 2109136.25999 | 37.77153788069 | -122.427990506479 | (37.77153788069, -122.427990506479) | 7 | 9 | 11 | 28852 | 10 | |||
| 152935 | 14731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 912X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 6 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | |||
| 154292 | 142260 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004691.5283 | 2110560.7676 | 37.7754629180406 | -122.427255013183 | (37.7754629180406, -122.427255013183) | 7 | 9 | 11 | 28852 | 10 | |||
| 155242 | 138855 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 517 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004909.9473 | 2111074.8774 | 37.776886887754 | -122.426536065317 | (37.776886887754, -122.426536065317) | 7 | 9 | 11 | 28852 | 10 | |||
| 156402 | 63611 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24248 | 6004626.48147455 | 2109159.86255859 | 37.7716126952933 | -122.427380207094 | (37.7716126952933, -122.427380207094) | 7 | 9 | 11 | 28852 | 10 | ||
| 157616 | 141987 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004139.84 | 2111815.1387 | 37.7788758968254 | -122.429252898528 | (37.7788758968254, -122.429252898528) | 7 | 9 | 11 | 29490 | 41 | |||
| 159777 | 31349 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.7766352121679 | -122.42638959957 | (37.7766352121679, -122.42638959957) | 7 | 9 | 11 | 28852 | 10 | ||
| 168367 | 14641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.7799040650672 | -122.422330778736 | (37.7799040650672, -122.422330778736) | 7 | 9 | 11 | 28852 | 41 | ||
| 171610 | 48731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2002 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | |||
| 176409 | 100356 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
| 178180 | 246578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005224.61763 | 2109380.51832 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | 7 | 9 | 11 | 28852 | 10 | |||
| 179067 | 246576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216 | (37.7721221684335, -122.42531053216) | 7 | 9 | 11 | 28852 | 10 | |||
| 187709 | 28242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | 7 | 9 | 11 | 29492 | 10 | ||
| 188422 | 224093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 353 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004017.83242 | 2109024.56898 | 37.7712067701103 | -122.429475909489 | (37.7712067701103, -122.429475909489) | 7 | 9 | 11 | 29492 | 10 | |||
| 190922 | 69233 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 539 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33289 | 6005277.10094302 | 2110933.89585771 | 37.77652053588 | -122.42525593371 | (37.77652053588, -122.42525593371) | 7 | 9 | 11 | 28852 | 10 | ||
| 192290 | 255522 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 513 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782014 | 6004052.85891 | 2110487.65333 | 37.7752260248335 | -122.429459106998 | (37.7752260248335, -122.429459106998) | 7 | 9 | 11 | 29492 | 10 |
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) );