trees
113 rows where Supervisor Districts = 8 and qSpecies_id = 63 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172168 | 201743 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015564.44995 | 2087435.02252 | 37.7125733027894 | -122.388028516211 | (37.7125733027894, -122.388028516211) | 10 | 3 | 8 | 58 | 1 | |||
172636 | 194463 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012509.33056 | 2101878.68569 | 37.7520628720051 | -122.399601493222 | (37.7520628720051, -122.399601493222) | 10 | 3 | 8 | 28856 | 29 | ||||
175395 | 201739 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015537.38953 | 2087630.70495 | 37.7131091098792 | -122.388135693819 | (37.7131091098792, -122.388135693819) | 10 | 3 | 8 | 58 | 1 | |||
179258 | 121697 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
182292 | 201774 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015625.88693 | 2087662.37118 | 37.7132009621398 | -122.38783202245 | (37.7132009621398, -122.38783202245) | 10 | 3 | 8 | 58 | 1 | |||
183877 | 201775 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015614.36786 | 2087706.44647 | 37.7133213462866 | -122.387874910195 | (37.7133213462866, -122.387874910195) | 10 | 3 | 8 | 58 | 1 | |||
185304 | 194444 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 25th St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6014137.98688 | 2101954.90704 | 37.7523628094083 | -122.393974650128 | (37.7523628094083, -122.393974650128) | 10 | 3 | 8 | 28856 | 1 | ||||
187046 | 201779 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015589.3271 | 2087835.51364 | 37.7136743526627 | -122.387970461377 | (37.7136743526627, -122.387970461377) | 10 | 3 | 8 | 58 | 1 | |||
187791 | 201745 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015574.32176 | 2087390.64932 | 37.7124520094198 | -122.387991301359 | (37.7124520094198, -122.387991301359) | 10 | 3 | 8 | 58 | 1 | |||
188380 | 201772 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015630.59439 | 2087639.54626 | 37.7131385500726 | -122.387814160092 | (37.7131385500726, -122.387814160092) | 10 | 3 | 8 | 58 | 1 | |||
191105 | 201771 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015632.38361 | 2087621.49757 | 37.7130890909533 | -122.387806717322 | (37.7130890909533, -122.387806717322) | 10 | 3 | 8 | 58 | 1 | |||
191991 | 202090 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Gould St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012861.1738 | 2091181.83519 | 37.7227111623612 | -122.397634574298 | (37.7227111623612, -122.397634574298) | 10 | 3 | 8 | 58 | 1 | ||||
192204 | 201789 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015483.87953 | 2088094.96024 | 37.7143809005356 | -122.388353026664 | (37.7143809005356, -122.388353026664) | 10 | 3 | 8 | 58 | 1 |
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) );