dart_sql_dart_2011_2013_dsq.sql

URL: http://dartportal.leeds.ac.uk/dart_public/dart_excavation_data/dart_sql_dart_2011_2013_dsq.sql

A SQL script to create the excavation database, supporting tables and inject data into those tables in the postgres environment.

No preview available.
No handler defined for data type: sql.

Additional Information

Field Value
Last updated Dec 09, 2013
Created Dec 09, 2013
Format text/plain
License Open Data Commons Attribution License
createdDecember 9, 2013
formatsql
hashf685c2681466a4d2f8d78eada8572b0467d61de8
id933a404d-c9ef-4fdd-929d-cae5ecc8dd97
last modifiedDecember 9, 2013
license idodc-by
mimetypetext/plain
on same domain1
position4
resource group id2e73c8f5-5e34-46fa-b602-e985a6cf0bd3
resource.abstractA SQL script to create the excavation database, supporting tables and inject data into those tables in the postgres environment.
resource.accessConstraintsNone
resource.bibliographicCitation@data{dart_sql_dart_2011_2013_dsq.sql, doi = {not allocated}, url = {http://dartportal.leeds.ac.uk/dart_public/dart_excavation_data/dart_sql_dart_2011_2013_dsq.sql}, author = "{Keith Wilkinson}", publisher = {DART repository, School of Computing, University of Leeds}, title = {dart_sql_dart_2011_2013_dsq.sql}, year = {2013}, note = {DART is a Science and Heritage project funded by AHRC and EPSRC. Further DART data and details can be found at http://dartportal.leeds.ac.uk} }
resource.completenessComplete
resource.consistencyConsistent data structure, attribution and relationships.
resource.contributor.emaila.r.beck@leeds.ac.uk,dxb043@bham.ac.uk,r.j.fry@student.bradford.ac.uk,LEP001@bham.ac.uk,scds@leeds.ac.uk,Keith.Wilkinson@winchester.ac.uk
resource.contributor.nameAnthony Beck,Dan Boddice,Robert Fry,Laura Pring,David Stott,Keith Wilkinson
resource.contributor.orcIDhttp://orcid.org/0000-0002-2991-811X,http://orcid.org/0000-0002-3738-2327,http://orcid.org/0000-0002-9711-1131,http://orcid.org/0000-0002-5363-7959,http://orcid.org/0000-0003-3042-2813,http://orcid.org/0000-0002-3996-0696
resource.creation.endDateTime2013--
resource.creation.startDateTime2011--
resource.creation.statusComplete
resource.creator.emaila.r.beck@leeds.ac.uk
resource.creator.nameAnthony Beck
resource.creator.orcIDhttp://orcid.org/0000-0002-2991-811X
resource.custodian.emaila.r.beck@leeds.ac.uk
resource.custodian.nameAnthony Beck
resource.custodian.orcIDhttp://orcid.org/0000-0002-2991-811X
resource.descriptionA SQL script to create the excavation database, supporting tables and inject data into those tables in the postgres environment.
resource.distribution.techniqueDownload only
resource.edition1
resource.fileFormat.zip
resource.funderScience and Heritage Programme, Arts and Humanities Research Council, Engineering and Physical Sciences Research Council
resource.instructionalMethodNone - this resource is not part of an education pack. Look at the education pack collection.
resource.keywordsContexts, Plans, Finds, Sections
resource.languageeng
resource.licensecc-by
resource.license.typeURLhttp://creativecommons.org/licenses/by/3.0/
resource.lineageNone: this is raw data
resource.localURIhttp://dartportal.leeds.ac.uk/dart_public/dart_excavation_data/dart_sql_dart_2011_2013_dsq.sql
resource.metadata.creator.emailKeith.Wilkinson@winchester.ac.uk
resource.metadata.creator.nameKeith Wilkinson
resource.metadata.creator.orcIDhttp://orcid.org/0000-0002-3996-0696
resource.metadata.languageeng
resource.processingStageComplete
resource.publisherSchool of Computing, University of Leeds
resource.purposemulti-temporal heritage detection
resource.relatedResourcesDartProjectOverview
resource.repositoryNamehttp://dartportal.leeds.ac.uk/
resource.reuseConstraintsNo conditions apply for reuse (remix it, publish it, share it, commercialise it, sell it etc.) except attribution (see resource.bibliographicCitation)
resource.reusePotentialarchaeology, environment, heritage, soil science, farming, ecology, geography, earth science
resource.topicgeoscientificInformation, environment, heritage, farming, climatology/Meteorology/Atmosphere, imageryBaseMapsEarthCover, society, structure
resource.typeDataset collection
resource.type.specificText, Vector, GIS
resource.updateFrequencynot planned
revision id702ee06c-383d-4948-a8c7-5f684d5b933c
revision timestampDecember 9, 2013
size134 KiB
spatial{ "type": "Polygon", "coordinates": [ [ [-1.907587, 52.280552],[-0.246205, 52.280552], [-0.246205, 51.703178], [-1.907587, 51.703178], [-1.907587, 52.280552] ] ] }
spatial-textUnited Kingdom
spatial.boundingBox.OSGB36.east519,741
spatial.boundingBox.OSGB36.north266,160
spatial.boundingBox.OSGB36.referenceSystemOSGB36
spatial.boundingBox.OSGB36.south200,497
spatial.boundingBox.OSGB36.west406,483
spatial.boundingBox.WGS84.eastLongitude-0.246
spatial.boundingBox.WGS84.northLatitude52.28
spatial.boundingBox.WGS84.referenceSystemWGS84
spatial.boundingBox.WGS84.southLatitude51.703
spatial.boundingBox.WGS84.westLongitude-1.908
spatial.defaultReferenceSystemOSGB36
spatial.driftGeologyDDCF: http://www.bgs.ac.uk/lexicon/lexicon.cfm?pub=TILMP, DDPF: http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=T1T2, HHCC: Clay: no superficial drift geology, HHQF: no superficial drift geology
spatial.landusePermanent pasture: DDPF, Arable: DDCF, HHCF, HHQF
spatial.ordnanceSurveyPlaceNameHarnhill (http://data.ordnancesurvey.co.uk/id/50kGazetteer/109734) and Diddington (http://data.ordnancesurvey.co.uk/id/50kGazetteer/72767)
spatial.polygon.OSGB36{ "type": "Polygon", "coordinates": [ [ [406483, 266160],[519741, 266160], [519741, 200497], [406483, 200497], [406483, 266160] ] ] }
spatial.polygon.WGS84{ "type": "Polygon", "coordinates": [ [ [-1.907587, 52.280552],[-0.246205, 52.280552], [-0.246205, 51.703178], [-1.907587, 51.703178], [-1.907587, 52.280552] ] ] }
spatial.solidGeologyDDCF and DDPF: http://www.bgs.ac.uk/lexicon/lexicon.cfm?pub=OXC, HHCC: http://www.bgs.ac.uk/lexicon/lexicon.cfm?pub=CB, HHQF: http://www.bgs.ac.uk/lexicon/lexicon.cfm?pub=SI
stateactive
temporal.rangeDescribedByDataDateTime.endNow
temporal.rangeDescribedByDataDateTime.startIron Age
temporal.resource.availableDate2013-07-15
title.alternativedart_excavation_data
title.patternWhere appropriate each resource has been named with the following pattern: DART_<3 character sensor/collection name>_<spatial location>_<StartDateTime YYYYMMDD with optional HHMM>_<endDateTime YYYYMMDD with optional HHMM>_<stage PRO or RAW to refer to processed or raw data>_<other stuff>.<suffix>. Hence, the file DART_T3P_DDCF_20110823_20130106_PRO.csv refers to DART data collected using the T3P Imko soil moisture probes at Diddington Clay Field between 23rd August 2011 and 6th January 2013 which has been processed and is available in a comma separated text format.
typefile.upload