Data Package Quality Report
PackageId: edi.918.1
Report Date/Time: 2022-06-16T10:28:44
Dataset Report
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1packageIdPatternvalid
Type:metadata
System:lter
On failure:error
packageId pattern matches "scope.identifier.revision"Check against LTER requirements for scope.identifier.revision'scope.n.m', where 'n' and 'm' are integers and 'scope' is one of an allowed set of valuesedi.918.1
2emlVersionvalid
Type:metadata
System:lter
On failure:error
EML version 2.1.0 or beyondCheck the EML document declaration for version 2.1.0 or highereml://ecoinformatics.org/eml-2.1.0 or higherhttps://eml.ecoinformatics.org/eml-2.2.0Validity of this quality report is dependent on this check being valid.
3schemaValidvalid
Type:metadata
System:knb
On failure:error
Document is schema-valid EMLCheck document schema validityschema-validDocument validated for namespace: 'https://eml.ecoinformatics.org/eml-2.2.0'Validity of this quality report is dependent on this check being valid.
4parserValidvalid
Type:metadata
System:knb
On failure:error
Document is EML parser-validCheck document using the EML IDs and references parserValidates with the EML IDs and references parserEML IDs and references parser succeededValidity of this quality report is dependent on this check being valid.
5schemaValidDereferencedvalid
Type:metadata
System:lter
On failure:error
Dereferenced document is schema-valid EMLReferences are dereferenced, and the resulting file validatedschema-validDereferenced document validated for namespace: 'https://eml.ecoinformatics.org/eml-2.2.0'Validity of this quality report is dependent on this check being valid.
6keywordPresentvalid
Type:metadata
System:lter
On failure:warn
keyword element is presentChecks to see if at least one keyword is presentPresence of one or more keyword elements11 'keyword' element(s) found
7methodsElementPresentvalid
Type:metadata
System:lter
On failure:warn
A 'methods' element is presentAll datasets should contain a 'methods' element, at a minimum a link to a separate methods doc.presence of 'methods' at one or more xpaths.1 'methods' element(s) foundEML Best Practices, p. 28
8coveragePresentvalid
Type:metadata
System:lter
On failure:warn
coverage element is presentAt least one coverage element should be present in a dataset.At least one of geographicCoverage, taxonomicCoverage, or temporalCoverage is present in the EML.1 'coverage' element(s) found
9geographicCoveragePresentinfo
Type:metadata
System:lter
On failure:info
geographicCoverage is presentCheck that geographicCoverage exists in EML at the dataset level, or at least one entity's level, or at least one attribute's level.geographicCoverage at least at the dataset level.1 'geographicCoverage' element(s) foundMany but not all datasets are appropriate to have spatial coverage.If sampling EML is used within methods, does that obviate geographicCoverage? Or should those sites be repeated or referenced?EML Best Practices v.2, p. 22-23. "One geographicCoverage element should be included, whose boundingCoordinates describe the extent of the data....Additional geographicCoverage elements may be entered at the dataset level if there are significant distances between study sites and it would be confusing if they were grouped into one bounding box." 6 decimal places.
10taxonomicCoveragePresentinfo
Type:metadata
System:lter
On failure:info
taxonomicCoverage is presentCheck that taxonomicCoverage exists in EML at the dataset level, or at least one entity's level, or at least one attribute's level.taxonomicCoverage at least at the dataset level.0 'taxonomicCoverage' element(s) foundOnly when taxa are pertinent to the dataset will they have taxonomicCoverage.Could search title, abstract, keywords for any taxonomic name (huge). Could search keywordType="taxonomic".EML Best Practices v.2, p. 25
11temporalCoveragePresentinfo
Type:metadata
System:lter
On failure:info
temporalCoverage is presentCheck that temporalCoverage exists in EML at the dataset level, or at least one entity's level, or at least one attribute's level.temporalCoverage at least at the dataset level.1 'temporalCoverage' element(s) foundLTER wants to search datasets by time; the best place to search is the dataset level temporal coverage.Most datasets have a temporal range.EML Best Practices v.2, p. 24
12pastaDoiAbsentvalid
Type:metadata
System:lter
On failure:error
An alternateIdentifier with a DOI system attribute that looks like it is generated by PASTA should not be presentReject the data package if it contains an alternateIdentifier DOI that looks like PASTA generated it.No PASTA DOIs are expected to be found in the uploaded data packageNo PASTA DOI alternateIdentifier elements foundPASTA DOI values might appear in an uploaded data package (by various mechanisms). PASTA will assign a DOI after the upload has completed successfully, so an initial one should not be there.
13titleLengthvalid
Type:metadata
System:lter
On failure:warn
Dataset title length is at 5 least words.If the title is shorter than 5 words, it might be insufficient. Title word count between 7 and 20 including prepositions and numbers.Between 7 and 20 words13 words found.EML Best Practices, v.2, p. 13
14fundingPresencewarn
Type:metadata
System:lter
On failure:warn
check to see if funding element is presentChecks to see if the funding element is included.the funding element is expected to be includedfunding not foundSearches will want to display datasets by funder or grant id.Include the funding source, please.
15datasetAbstractLengthvalid
Type:metadata
System:lter
On failure:warn
Dataset abstract element is a minimum of 20 wordsCheck the length of a dataset abstract and warn if less than 20 words.An abstract is 20 words or more.90 words found.EML Best Practices
16duplicateEntityNamevalid
Type:metadata
System:lter
On failure:error
There are no duplicate entity namesChecks that content is not duplicated by other entityName elements in the documententityName is not a duplicate within the documentNo duplicates foundData Manager requires a non-empty, non-duplicate entityName value for every entityDeclare a non-empty entityName and ensure that there are no duplicate entityName values in the document
Entity Report
Entity Name: DJFMP beach seines
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less18
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 2366851 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
12displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
13urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
14onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/BarriersDJFMP.csv
15integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.a6a7045db889f07c29eabc839cc43e68a6a7045db889f07c29eabc839cc43e68Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
16entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.23668512366851Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
17databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE DJFMP_beach_seines("Regions" TEXT,"StationCode" TEXT,"Month" TEXT,"Year" FLOAT,"SampleDate" TIMESTAMP,"Volume" FLOAT,"CommonName" TEXT,"Count" FLOAT);
18examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
19displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayedSan Joaquin, MK004W, 5, 2014, 5/2/2014, 57.6, largemouth bass, 1
20dataLoadStatuswarn
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityError inserting data at row 1.ERROR: date/time field value out of range: "5/2/2014"
21headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
22dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format string'5/2/2014' is not congruent with the formatString 'YYYY-MM-DD' as specified in the metadata. regex: ^(\d\d\d\d)-(01|02|03|04|05|06|07|08|09|10|11|12)-(0[1-9]|[1-2]\d|30|31)$One or more datetime values found in the data do not match the format string specified in the metadata.Dates should be consistently formatted and match the formatString in metadata.
23onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/d1c59e6c9af348bea7e26e0e6a979756
Entity Report
Entity Name: Barrierstations
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less15
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 2028 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
11displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
12urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
13onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/Barrierstations.csv
14integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.0fa3259959a1cc876ad25b7ef40a00070fa3259959a1cc876ad25b7ef40a0007Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
15entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.20282028Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
16databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE Barrierstations("StationCode" TEXT,"Latitude" FLOAT,"Longitude" FLOAT,"Survey" TEXT,"DataTypes" TEXT);
17examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
18displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayedMK004W, 38.12746155, -121.5804697, DJFMP, Fish catch
19onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/147bd1551f87b82e4946852a5c313da5
20tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
21tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
22dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
23numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data4545The expected number of records (45) was found in the data table.
24headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
25dateFormatMatchesvalid
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringData values matched the specified formatString.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: BarrierTNS
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less10
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 1120607 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYYA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
12attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
13displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
14urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
15onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/BarrierTNS.csv
16integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.a8b23e5dd07c93cacd3e4ca0e3d68437a8b23e5dd07c93cacd3e4ca0e3d68437Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
17entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.11206071120607Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
18databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE BarrierTNS("StationCode" TEXT,"Regions" TEXT,"Year" TIMESTAMP,"Survey" FLOAT,"SampDate" TIMESTAMP,"Species" TEXT,"VolumeOfAllTows" FLOAT,"Catch" FLOAT,"CPUE" FLOAT);
19examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
20displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayed513, Sacramento, 2014, 1, 4-Jun-14, American Shad, 2011, 0, 0
21dataLoadStatuswarn
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityError inserting data at row 1.ERROR: invalid value "Ju" for "MM" Detail: Value must be an integer.
22headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
23dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format string'4-Jun-14' is not congruent with the formatString 'YYYY-MM-DD' as specified in the metadata. regex: ^(\d\d\d\d)-(01|02|03|04|05|06|07|08|09|10|11|12)-(0[1-9]|[1-2]\d|30|31)$One or more datetime values found in the data do not match the format string specified in the metadata.Dates should be consistently formatted and match the formatString in metadata.
24onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/1953a2a8b09d172049cd165b74aa175d
Entity Report
Entity Name: ContinuousWQ
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less12
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 433988 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringwarn
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.'MM/DD/YYYY' is not in the set of preferred values.In the current version of EML (2.1), the dateTime/formatString is interpreted as ISO-8601. This check is classified as a warn, so other formats are allowed. In the future (e.g., future version of EML), other formatStrings may be added to the preferred list.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
12displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
13urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
14onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/ContinuousWQ.csv
15integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.2a3109c6015dffce5fd7d424722c40c22a3109c6015dffce5fd7d424722c40c2Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
16entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.433988433988Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
17databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE ContinuousWQ("Date" TIMESTAMP,"Station" TEXT,"EC" FLOAT,"Tem" FLOAT,"Tur" FLOAT,"DO" FLOAT);
18examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
19displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayed4/1/2020, BET, 304.375, NA, NA, NA
20onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/9f489e06694d516bd3240fa90c39cb94
21tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
22tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
23dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
24numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data1152011520The expected number of records (11520) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
26dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringNot checked.'MM/DD/YYYY' is not a preferred format string and was not checked for congruency with the datetime values.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: Hydrodynamics_Data_2015_2020_2021
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less33
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 27268816 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringwarn
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.'MM/DD/YYYY hh:mm' is not in the set of preferred values.In the current version of EML (2.1), the dateTime/formatString is interpreted as ISO-8601. This check is classified as a warn, so other formats are allowed. In the future (e.g., future version of EML), other formatStrings may be added to the preferred list.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
12displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
13urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
14onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/Hydrodynamics_Data_2015_2020_2021.csv
15integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.1ca2f038408ede80bf822a92c09451181ca2f038408ede80bf822a92c0945118Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
16entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.2726881627268816Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
17databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE Hydrodynamics_Data_2015_2020_2("Station" TEXT,"DateTime" TIMESTAMP,"GageHeight" FLOAT,"GageHeight_QC" TEXT,"Vmean" FLOAT,"Vmean_QC" TEXT,"Discharge" FLOAT,"Discharge_QC" TEXT,"NetFlow" FLOAT);
18examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
19displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayedDSJ, 3/30/2015 0:00, 4.54, A, -1.53, A, -7480, A, NA
20onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/b421e36c2db9e0edfc01924e89b3468b
21tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
22tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
23dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
24numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data475523475523The expected number of records (475523) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
26dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringNot checked.'MM/DD/YYYY hh:mm' is not a preferred format string and was not checked for congruency with the datetime values.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: Turbidity compliance data
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less25
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 20034 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringwarn
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.'MM/DD/YYYY' is not in the set of preferred values.In the current version of EML (2.1), the dateTime/formatString is interpreted as ISO-8601. This check is classified as a warn, so other formats are allowed. In the future (e.g., future version of EML), other formatStrings may be added to the preferred list.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.hhmmA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
12attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
13displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
14urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
15onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/EDB_Turbidity.csv
16integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.c98a5753b6236e595fbbc6302b8c2b52c98a5753b6236e595fbbc6302b8c2b52Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
17entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.2003420034Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
18databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE Turbidity_compliance_data("Date" TIMESTAMP,"Technician" TEXT,"Sample" TEXT,"Tide" TEXT,"Location" TEXT,"Time" TIMESTAMP,"Turbidity" FLOAT,"SS" TEXT,"Observation" TEXT);
19examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
20displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayed6/3/2021, Chris Weber, Morning, Flood, North - East, -, -, -, Placing rock in water. South channel only.
21dataLoadStatuswarn
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityError inserting data at row 3.ERROR: date/time field value out of range: "916"
22headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
23dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringNot checked.'916' is not congruent with the formatString 'hhmm' as specified in the metadata. regex: ^([0-1]\d|2[0-4])([0-5]\d)$\n'MM/DD/YYYY' is not a preferred format string and was not checked for congruency with the datetime values.Dates should be consistently formatted and match the formatString in metadata.
24onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/a2ec02f8c27268d7704f96cbd689ba67
Entity Report
Entity Name: edb_predators_modelingdata
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less26
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 746707 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringwarn
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.'MM/DD/YYYY' is not in the set of preferred values.In the current version of EML (2.1), the dateTime/formatString is interpreted as ISO-8601. This check is classified as a warn, so other formats are allowed. In the future (e.g., future version of EML), other formatStrings may be added to the preferred list.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDThh:mm:ssA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
12dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDThh:mm:ssA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
13dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDThh:mm:ssA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
14dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDThh:mm:ssA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
15attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
16displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
17urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
18onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/edb_predators_modelingdata.csv
19integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.5aafb06ca93425f8307f79be628aaeeb5aafb06ca93425f8307f79be628aaeebMatching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
20entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.746707746707Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
21databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE edb_predators_modelingdata("SAMPLE_ID" TEXT,"SAMPLE_DATE" TIMESTAMP,"RELEASE_SEQ" FLOAT,"DEVICE_NUM" FLOAT,"DEPLOY_DATETIME" TIMESTAMP,"VESSEL" TEXT,"DEPLOY_LAT" FLOAT,"DEPLOY_LONG" FLOAT,"RECOVER_DATETIME" TIMESTAMP,"RECOVER_LAT" FLOAT,"RECOVER_LONG" FLOAT,"TRIGGER_DATETIME" TIMESTAMP,"FISH_STATUS" TEXT,"TRIGGER_LAT" FLOAT,"TRIGGER_LONG" FLOAT,"TRIGGER_GPS_DATETIME" TIMESTAMP,"TRIGGER_DIFF" FLOAT,"TIMER" FLOAT,"BITE_MARKS" TEXT,"WEEDS" TEXT,"ROCKS" TEXT,"EDDY" TEXT,"TANGLED" TEXT,"TEMPERATURE" FLOAT,"DISSOLVED_OXYGEN" FLOAT,"SPC" FLOAT,"SALINITY" FLOAT,"PH" FLOAT,"TURBIDITY" FLOAT,"SECCHI_DEPTH" FLOAT,"DEVICE_NAME" TEXT,"COMMENTS" TEXT,"TRIGGERED" TEXT,"PERIOD" TEXT,"QC_COMMENTS" TEXT);
22examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
23displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayed
24onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/dd5c4ede466b66f8d31213df90d7e2a5
25tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
26tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
27dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
28numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data24302430The expected number of records (2430) was found in the data table.
29headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
30dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringNot checked.'MM/DD/YYYY' is not a preferred format string and was not checked for congruency with the datetime values.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: DiscreteWQ
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less10
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 161670 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringwarn
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.'MM/DD/YYYY' is not in the set of preferred values.In the current version of EML (2.1), the dateTime/formatString is interpreted as ISO-8601. This check is classified as a warn, so other formats are allowed. In the future (e.g., future version of EML), other formatStrings may be added to the preferred list.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
12displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
13urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
14onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/DiscreteWQ2.csv
15integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.d0778755ffbe8a32d2fbae7005132135d0778755ffbe8a32d2fbae7005132135Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
16entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.161670161670Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
17databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE DiscreteWQ("StationCode" TEXT,"Sample_Code" TEXT,"Date" TIMESTAMP,"DissBromide" TEXT,"DissChloride" FLOAT,"SC" FLOAT,"pH" FLOAT,"Temperature" FLOAT,"DO" FLOAT,"Turbidity" FLOAT,"TSS" TEXT,"Chla" TEXT,"Pheophytin" TEXT,"DissAmmonia" TEXT,"DissNitrateNitrite" TEXT,"DOC" FLOAT,"TOC" FLOAT,"DON" TEXT,"DissOrthophos" TEXT,"TotPhos" FLOAT,"TKN" FLOAT,"SamplingProgram" TEXT,"TotAlkalinity" FLOAT,"DissCalcium" FLOAT,"DissSilica" FLOAT,"TDS" FLOAT,"VSS" FLOAT);
18examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
19displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayedBET, CF0714B0817, 7/1/2014, 0.6, 173, 801, 8.15, 22.9, NA, 4.46, 4, 2.49, 0.52, 0.04, 0.19, 3.6, 3.6, 0.2, 0.07, 0.09, 0.3, WQES, NA, NA, NA, NA, NA
20onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/55377c8def782e6572808200dba65a3e
21tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
22tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
23dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
24numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data13941394The expected number of records (1394) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
26dateFormatMatcheswarn
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringNot checked.'MM/DD/YYYY' is not a preferred format string and was not checked for congruency with the datetime values.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: schism_ec_difference
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less20
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 53009826 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
11displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
12urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
13onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/schism_ec_difference.csv
14integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.2daefd6073a4f87c4449b69f4fd0fb722daefd6073a4f87c4449b69f4fd0fb72Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
15entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.5300982653009826Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
16databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE schism_ec_difference("month" TEXT,"schism_node" FLOAT,"x" FLOAT,"y" FLOAT,"ec_diff" FLOAT);
17examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
18displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayedAug, 1, 611016, 4295640.00, 0.00
19onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/6a4e1d48b92f3b86bcf9c728fa203b08
20tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
21tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
22dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
23numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data15291701529170The expected number of records (1529170) was found in the data table.
24headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
25dateFormatMatchesvalid
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringData values matched the specified formatString.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: schism_station_output
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less21
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.'numHeaderLines' element: 1
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidvalid
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expected,A valid fieldDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentvalid
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0A\r\nA valid recordDelimiter value was foundhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7numberOfRecordsPresencevalid
Type:metadata
System:knb
On failure:warn
Is the numberOfRecords element present?Warn the user if the numberOfRecords check is not presentA number of records element is expected for this entitynumberOfRecords element foundThis is a valuable check that we have the correct table.
8entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 4497988 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
9integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
10dateTimeFormatStringvalid
Type:metadata
System:knb
On failure:warn
dateTime/formatString specified in metadata is from a preferred set of valuesCertain features of dateTime data formats are preferred, eg, ISO 8601, 4-digit years. This check looks at metadata to see if the dateTime format is in that preferred list.A formatString value that is a member of the preferred set is expected.YYYY-MM-DDThh:mmA preferred format string was found.Modify the dateTime/formatString, selecting from among the preferred values one that best matches the data format
11attributeNamesUniquevalid
Type:metadata
System:knb
On failure:warn
Attribute names are uniqueChecks if attributeName values are unique in the table. Not required by EML.Unique attribute names.trueA good table does not have duplicate column names.EML Best Practices
12displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayed
13urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
14onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/schism_station_output.csv
15integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.83034eacc8bf0a02382781424bccd15b83034eacc8bf0a02382781424bccd15bMatching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
16entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.44979884497988Examining the entity size is a method for checking that this is the correct entity.Check the entity size.
17databaseTableCreatedvalid
Type:metadata
System:knb
On failure:error
Database table createdStatus of creating a database tableA database table is expected to be generated from the EML attributes.A database table was generated from the attributes descriptionCREATE TABLE schism_station_output("datetime" TIMESTAMP,"scenario" TEXT,"bet" FLOAT,"clc" FLOAT,"bac" FLOAT);
18examineRecordDelimitervalid
Type:congruency
System:knb
On failure:warn
Data are examined and possible record delimiters are displayedIf no record delimiter was specified, we assume that \r\n is the delimiter. Search the first row for other record delimiters and see if other delimiters are found.No other potential record delimiters expected in the first row.No other potential record delimiters were detected. A valid record delimiter was previously detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
19displayFirstInsertRowinfo
Type:data
System:knb
On failure:info
Display first insert rowDisplay the first row of data values to be inserted into the database tableThe first row of data values should be displayed2021-05-01T00:00, edb, 380.0, 471.9, 403.9
20onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: file:///home/pasta/local/data/edi.918.1/a0285ec86aca8d80d461f7afc041d5d5
21tooFewFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have fewer fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
22tooManyFieldsvalid
Type:congruency
System:knb
On failure:error
Data does not have more fields than metadata attributesCompare number of fields specified in metadata to number of fields found in a data recordNo errors detectedhttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#dataFormat
23dataLoadStatusvalid
Type:congruency
System:knb
On failure:warn
Data can be loaded into the databaseStatus of loading the data table into a databaseNo errors expected during data loading or data loading was not attempted for this data entityThe data table loaded successfully into a database
24numberOfRecordsvalid
Type:congruency
System:knb
On failure:warn
Number of records in metadata matches number of rows loadedCompare number of records specified in metadata to number of records found in data104869104869The expected number of records (104869) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare the content of the data header row to the content of EML attribute names.No expectation, information only Customer should evaluate the findings
26dateFormatMatchesvalid
Type:congruency
System:lter
On failure:warn
Date format in metadata matches datadateTime/formatString in attribute metadata is from the preferred list, and the data matches. A non-match generates only a warn.Format string is preferred, and all data values match the format stringData values matched the specified formatString.Dates should be consistently formatted and match the formatString in metadata.
Entity Report
Entity Name: EDB_Effectiveness_Report_ADA_rev
Entity Identifier:
# Identifier Status Quality Check Name Description Expected Found Explanation Suggestion Reference
1entityNameLengthvalid
Type:metadata
System:knb
On failure:warn
Length of entityName is not excessive (less than 100 char)length of entity name is less than 100 charactersentityName value is 100 characters or less32
2entityDescriptionPresentvalid
Type:metadata
System:lter
On failure:warn
An entity description is presentCheck for presence of an entity description.EML Best practices pp. 32-33, "...should have enough information for a user..."trueWith entityName sometimes serving as a file name rather than a title, it is important to be very descriptive here.
3numHeaderLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numHeaderLines' element is presentCheck for presence of the 'numHeaderLines' element.Document contains 'numHeaderLines' element.No 'numHeaderLines' element foundIf data file contains header lines, 'numHeaderLines' must be specified.Add 'numHeaderLines' element if needed.
4numFooterLinesPresentinfo
Type:metadata
System:knb
On failure:info
'numFooterLines' element is presentCheck for presence of the 'numFooterLines' element.Document contains 'numFooterLines' element.No 'numFooterLines' element foundIf data file contains footer lines, 'numFooterLines' must be specified.Add 'numFooterLines' element if needed.
5fieldDelimiterValidinfo
Type:metadata
System:knb
On failure:error
Field delimiter is a single characterField delimiters should be one character onlyA single character is expectednullA fieldDelimiter value is not checked for binary entities or entities with an externally defined formathttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#fieldDelimiter
6recordDelimiterPresentinfo
Type:metadata
System:knb
On failure:warn
Record delimiter is presentCheck presence of record delimiter. Check that the record delimiter is one of the suggested values.A record delimiter from a list of suggested values: \n, \r, \r\n, #x0A, #x0D, #x0D#x0AnullA recordDelimiter value is not checked for binary entities or entities with an externally defined formathttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-physical.html#recordDelimiter
7entitySizePresencevalid
Type:metadata
System:knb
On failure:warn
Check for presence of an entity size elementLook for entity size element as a prep for checking congruence, and if not present, generate a warn. Note that to be most useful (i.e, to check congruence), entity size should contain the most precise measure of size, which is "byte" (the default unit); however, the presence or name of the entity size unit is NOT checked.Entity size is present. If unit="byte" or unit is omitted (default = byte), then congruence can be checked.Found entity size element with value of 35356485 and size unit specified as 'byte'.Examining the entity size is prep for checking congruence. Including the element is best practice, and if not present, a warn is generated. To be most useful, entity size should contain the most precise measure of size, which is "byte" (the default unit).Include an entity size in bytes Example success: knb-lter-sbc.3.12. Example of size in units other than byte: knb-lter-mcr.6.56.
8integrityChecksumPresencevalid
Type:metadata
System:lter
On failure:warn
A physical/authentication element is present and specifies a method attribute with a value of MD5 or SHA-1Check for presence of a physical/authentication element containing a checksum or hash value for an integrity check (e.g. MD5, SHA-1). Warn if an entity does not have a physical/authentication element, or if none of the physical/authentication elements specify a method attribute with a value of MD5 or SHA-1.At least one physical/authentication element with a method attribute specifying MD5 or SHA-1 and containing a checksum or hash value that can be used to perform an integrity check on the data.truePASTA will use this value to check the integrity of the data it downloads from your site. In addition, PASTA is planning to compare the contributor-supplied checksum/hash value documented in the physical/authentication element to the checksum/hash value of this entity downloaded from previous revisions of this data package. If PASTA already has a copy of this entity, it will be able to avoid an unnecessary download of the entity from your site, resulting in faster processing of the new data package revision when you update it in PASTA.Add a physical/authentication element and store the entity checksum or hash value in it using a method such as MD5 or SHA-1.
9displayDownloadDatainfo
Type:data
System:knb
On failure:info
Display downloaded dataDisplay the first kilobyte of data that is downloadedUp to one kilobyte of data should be displayedCannot display NON-PLAIN TEXT DATA
10urlReturnsDatavalid
Type:congruency
System:knb
On failure:error
URL returns dataChecks whether a URL returns data. Unless the URL is specified to be function="information", the URL should return the resource for download.A data entity that matches the metadatatruehttp://knb.ecoinformatics.org/software/eml/eml-2.1.0/eml-resource.html#UrlType
11onlineURLsvalid
Type:congruency
System:knb
On failure:error
Online URLs are liveCheck that online URLs return somethingtruetrueSucceeded in accessing URL: https://ezeml.edirepository.org/user-data/iep-6f022aeb59daaf04006d61b9f2d3a887/uploads/West%20False%20River%20Barrier%20Monitoring/EDB_Effectiveness_Report_ADA_rev.pdf
12integrityChecksumvalid
Type:congruency
System:lter
On failure:error
Compare the metadata checksum for an entity to the checksum of the downloaded entityTwo possible responses: valid if checksums match; error if checksums do not match.4365b727cdc49c6e8f5a8274397841054365b727cdc49c6e8f5a827439784105Matching checksums will ensure data integrity during upload to the repository.If the found integrity hash value does not match the expected integrity hash value, there may have been a loss of integrity in the data download. Check that the hash method and hash value documented in the metadata are the correct values.
13entitySizeCongruencevalid
Type:congruency
System:knb
On failure:error
Check that the entity size in the Level 0 metadata matches the one PASTA+ generates.Compare raw file size of file to [entity]/physical/size element in metadata. Return error if not matching.3535648535356485Examining the entity size is a method for checking that this is the correct entity.Check the entity size.