glam-datasets

1 row where dataset_description = "This series held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives), comprises drawings of Queensland harbour infrastructure, including wharves, jetties, breakwaters, harbour roadworks and drainage, harbour buildings, storage, cranes and other loading facilities including those for coal, sugar and livestock, accommodation including cottages, offices and workshops, wharf railways and tramways, slipways and winches, boat ramps, dolphins and buoys and navigation aids including beacons and leads. The infrastructure drawings relate to the initial construction of the facilities as well as subsequent extensions or modifications. In addition, the series contain some survey drawings including soundings, development and site plans, and a small number of administrative drawings, e.g. departmental organisational charts. It includes drawings and charts of Queensland ports and harbour areas together with port and harbour infrastructure and government vessels. A large proportion of the drawings are of soundings of various reaches, cuttings and sections of waterways throughout Queensland, including surveyed contours and cross sections. Drawings of infrastructure include wharves and jetties including buildings and roadways, terminals and loaders, cranes, dry docks, breakwaters, lighthouses and other navigation aids; vessels include dredges, tugs, launches, pilot cutters, ferries, punts, launches. A small number of related items not being charts or plans are also included in the series.", format = "JSON", licence = "Creative Commons Attribution 4.0" and publisher = "Queensland State Archives"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), file_created (date)

CREATE TABLE [glam-datasets] (
   [dataset_title] TEXT,
   [publisher] TEXT,
   [author] TEXT,
   [dataset_issued] TEXT,
   [dataset_modified] TEXT,
   [dataset_description] TEXT,
   [source] TEXT,
   [info_url] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [file_title] TEXT,
   [download_url] TEXT,
   [format] TEXT,
   [file_description] TEXT,
   [file_created] TEXT,
   [file_modified] TEXT,
   [file_size] TEXT,
   [licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
    ON [glam-datasets] ([source], [publisher], [format], [licence]);