trees
115 rows where qSpecies_id = 267
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171113 | 175149 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 185 Bertita St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000379.58344 | 2089864.55399 | 37.7183912761038 | -122.440686171946 | (37.7183912761038, -122.440686171946) | 9 | 7 | 6 | 28861 | 25 | |||
| 174392 | 220559 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 199 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005086.47648 | 2103971.64406 | 37.7573930881476 | -122.425419775506 | (37.7573930881476, -122.425419775506) | 2 | 4 | 5 | 28859 | 19 | |||
| 175775 | 5636 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1265 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005218.82041 | 2100995.20586 | 37.7492279571106 | -122.42475033817 | (37.7492279571106, -122.42475033817) | 2 | 4 | 5 | 28859 | 19 | |||
| 175808 | 5588 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1077 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/1990 12:00:00 AM | 6 | 3x3 | 6005154.78082 | 2102086.1715 | 37.7522198792618 | -122.425049401425 | (37.7522198792618, -122.425049401425) | 2 | 4 | 5 | 28859 | 19 | ||
| 178291 | 5545 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 937 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6005113.2293 | 2102897.95475 | 37.7544464999301 | -122.425250853145 | (37.7544464999301, -122.425250853145) | 2 | 4 | 5 | 28859 | 19 | ||
| 179555 | 220573 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1027 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009453.66032 | 2103181.05755 | 37.7554680910955 | -122.410260442478 | (37.7554680910955, -122.410260442478) | 2 | 4 | 7 | 28859 | 19 | |||
| 181177 | 5419 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 431 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 12 | 4X4 | 6004950.08194 | 2105826.48665 | 37.7624783406172 | -122.426023520063 | (37.7624783406172, -122.426023520063) | 8 | 4 | 5 | 28859 | 19 | ||
| 181247 | 220577 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 4256 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000785.1959 | 2102896.48874 | 37.7541970145069 | -122.440218172849 | (37.7541970145069, -122.440218172849) | 2 | 4 | 5 | 28862 | 22 | |||
| 183042 | 109565 | Permitted Site 7 | Aesculus x carnea :: Red Horse Chestnut 267 | 56 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) | 9 | 7 | 6 | 28861 | 25 |
| 184127 | 3473 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 301X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 184579 | 220566 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1464 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6005195.59267 | 2099861.91607 | 37.7461148917963 | -122.424750048571 | (37.7461148917963, -122.424750048571) | 2 | 7 | 5 | 63 | 22 | |||
| 187142 | 99505 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 2828 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000030 | 2117468 | 37.7941636633745 | -122.443876667305 | (37.7941636633745, -122.443876667305) | 13 | 9 | 1 | 57 | 27 | ||||
| 193462 | 256126 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1250X Florida St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
| 194085 | 83479 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2010 12:00:00 AM | 1 | Permit Number 53461 | 6015479.82715 | 2105607.22668 | 37.7624657842962 | -122.389589366061 | (37.7624657842962, -122.389589366061) | 10 | 3 | 8 | 28856 | 29 | |
| 194135 | 203442 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 1315 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994845.11154 | 2106585.71345 | 37.7639866970507 | -122.461027689985 | (37.7639866970507, -122.461027689985) | 15 | 5 | 11 | 56 | 12 |
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) );