trees
129 rows where Police Districts = 2 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153520 | 191063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6011640.41223 | 2111625.07225 | 37.7787757828176 | -122.403291923287 | (37.7787757828176, -122.403291923287) | 14 | 2 | 9 | 28856 | 34 | |||
153618 | 191068 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 106 Langton St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6010213.08223 | 2110716.24311 | 37.7762005309779 | -122.408165525739 | (37.7762005309779, -122.408165525739) | 8 | 2 | 9 | 28853 | 34 | |||
154045 | 85524 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
154436 | 224108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006456.73439 | 2109332.89582 | 37.7721911464267 | -122.42106153229 | (37.7721911464267, -122.42106153229) | 8 | 2 | 9 | 28853 | 19 | |||
154801 | 191074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6008299.25709 | 2108795.98424 | 37.7708206066084 | -122.414650066644 | (37.7708206066084, -122.414650066644) | 8 | 2 | 9 | 28853 | 19 | |||
156242 | 254734 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 2 | 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 | |||
156315 | 192936 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 394 12th St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6008599.77798 | 2108564.43517 | 37.7702017066658 | -122.413594175352 | (37.7702017066658, -122.413594175352) | 8 | 2 | 9 | 28853 | 19 | |||
157074 | 224102 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006317.41461 | 2109580.74517 | 37.77286382673 | -122.421561058002 | (37.77286382673, -122.421561058002) | 8 | 2 | 9 | 28853 | 19 | |||
159134 | 85529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | 8 | 2 | 9 | 28853 | 19 | ||
159359 | 173644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 6 | 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 | ||||
160632 | 191058 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011781.36835 | 2111952.66121 | 37.7796831376017 | -122.402827343412 | (37.7796831376017, -122.402827343412) | 14 | 2 | 9 | 28856 | 34 | |||
161023 | 116584 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 GOUGH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006450 | 2109317 | 37.7721471206774 | -122.421083698286 | (37.7721471206774, -122.421083698286) | 8 | 2 | 9 | 28853 | 19 | |||
161508 | 91021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
162095 | 251319 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
163766 | 85549 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 4 | 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 | |||
165019 | 90434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | ||
169450 | 191070 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6008653.1077 | 2108592.53019 | 37.7702818434688 | -122.413411694812 | (37.7702818434688, -122.413411694812) | 8 | 2 | 9 | 28853 | 19 | |||
171133 | 90439 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 48X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006368.067431 | 2109508.884182 | 37.7726693696552 | -122.421380739497 | (37.7726693696552, -122.421380739497) | 8 | 2 | 9 | 28853 | 19 | ||
172574 | 87147 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 555 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50132 | 6010000.21916 | 2111782.15708 | 37.7791153596345 | -122.408977105416 | (37.7791153596345, -122.408977105416) | 14 | 2 | 9 | 28853 | 34 | |
173736 | 191660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013043.398 | 2110850.10481 | 37.7767261559098 | -122.3983840225 | (37.7767261559098, -122.3983840225) | 6 | 2 | 9 | 28856 | 34 | |||
177147 | 191675 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008016.56974 | 2108896.04904 | 37.7710794746583 | -122.415634977181 | (37.7710794746583, -122.415634977181) | 8 | 2 | 9 | 28853 | 19 | |||
180320 | 191668 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013300.95519 | 2111099.53181 | 37.7774253698298 | -122.397510546978 | (37.7774253698298, -122.397510546978) | 6 | 2 | 9 | 28856 | 34 | |||
181867 | 191069 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008685.67935 | 2108575.69988 | 37.770237460112 | -122.413297838836 | (37.770237460112, -122.413297838836) | 8 | 2 | 9 | 28853 | 19 | |||
183853 | 191678 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 194 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007565.31413 | 2109155.0801 | 37.7717653363258 | -122.417214247857 | (37.7717653363258, -122.417214247857) | 8 | 2 | 9 | 28853 | 19 | |||
183924 | 191075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6008288.60526 | 2108804.28402 | 37.7708427973966 | -122.414687499122 | (37.7708427973966, -122.414687499122) | 8 | 2 | 9 | 28853 | 19 | |||
187727 | 85557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008653.68072 | 2108532.35146 | 37.7701166389055 | -122.413405456202 | (37.7701166389055, -122.413405456202) | 8 | 2 | 9 | 28853 | 19 | |||
189658 | 224100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2x Gough St | 4 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006621.45587 | 2109260.75005 | 37.7720023355618 | -122.420486623569 | (37.7720023355618, -122.420486623569) | 8 | 2 | 9 | 28853 | 19 | |||
193613 | 191676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 288 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008127.34613 | 2108835.28118 | 37.7709188467549 | -122.415247494384 | (37.7709188467549, -122.415247494384) | 8 | 2 | 9 | 28853 | 19 | |||
194004 | 85541 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 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) );