trees
25 rows where Fire Prevention Districts = 5 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |
| 90366 | 55965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.14258 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | 5 | 9 | 1 | 28858 | 32 | |
| 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 |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );