Data Package Quality Report
PackageId: edi.708.1
Report Date/Time: 2022-01-13T12:04:00
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.708.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 elements19 '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.16 '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 words12 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.119 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: CAL_Secchi_1959_2020
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 30410 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_Secchi_1959_2020.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.54fe4e62439ebe837cc2ee997f38212454fe4e62439ebe837cc2ee997f382124Matching 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.3041030410Examining 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 CAL_Secchi_1959_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Secchi_m" 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 displayed1959, June, 6/9/59, 11
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.708.1/cfe3d9775f892042566d59a83320e526
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 data11811181The expected number of records (1181) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_AirTemp_1959_2020
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 29302 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_AirTemp_1959_2020.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.0d7a27d9e307a512895080b3559bfbfa0d7a27d9e307a512895080b3559bfbfaMatching 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.2930229302Examining 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 CAL_AirTemp_1959_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"ppt_mm" FLOAT,"mintemp_C" FLOAT,"meantemp_C" FLOAT,"maxtemp_C" 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 displayed1959, January, 1/1/59, 568.84, -2.6, 1.4, 5.4
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.708.1/a79d0949e1f2f86f0f42582ca4f19b13
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 data744744The expected number of records (744) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_WaterTemp_1959_2020
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 less23
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 1356380 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_WaterTemp_1959_2020.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.9b517eecec303a2c0c096a2321cb63b09b517eecec303a2c0c096a2321cb63b0Matching 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.13563801356380Examining 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 CAL_WaterTemp_1959_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Depth_m" FLOAT,"Temp_C" 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 displayed1959, June, 6/9/59, 0, 13.76
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.708.1/4febaa4b5c69061c12a4aefa1129d559
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 data4891248912The expected number of records (48912) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_IceOff_1962_2020
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 1421 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_Iceoff_1962_2020.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.1f4c9e9d537c4c7bf069088cd7ccdeb61f4c9e9d537c4c7bf069088cd7ccdeb6Matching 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.14211421Examining 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 CAL_IceOff_1962_2020("Year" FLOAT,"Month" TEXT,"Iceout_date" TIMESTAMP,"Julian_Day_Iceout" TEXT);
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 displayed1962, May, 05/15/62, 135
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 35.ERROR: invalid value "ND" for "MM" Detail: Value must be an integer.
21headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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 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.
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.708.1/848293c90b8490deae874ca652172b17
Entity Report
Entity Name: CAL_Chlorophyll_1982_2020
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 93845 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_Chlorophyll_1982_2020.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.dd1c08ffac9290032fc564115c35ddcddd1c08ffac9290032fc564115c35ddcdMatching 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.9384593845Examining 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 CAL_Chlorophyll_1982_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Depth_m" FLOAT,"Chla_µgL_1" 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 displayed1982, June, 6/27/82, 3, 0.45
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 3268.For attribute name "Depth_m", data value 10a is not the expected data type of 'FLOAT': For input string: "10a"
21headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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 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.
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.708.1/6fd793b2fcd0d7f7b4707329c0ff1727
Entity Report
Entity Name: CAL_PrimaryProductivity_1961_2020
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 439446 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_PrimaryProductivity_1961_2020.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.b4e3203c200be355cf2e493bf05e8694b4e3203c200be355cf2e493bf05e8694Matching 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.439446439446Examining 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 CAL_PrimaryProductivity_1961_2("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Depth_m" FLOAT,"Net_PPr" 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 displayed1961, June, 6/11/61, 0, 0.862
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.708.1/a1e1b088ff01fd03ff1217e38b61e01d
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 data1448314483The expected number of records (14483) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL _Daily_Phytoplankton_1967_1984
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 less34
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 69017 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL%20_Daily_Phytoplankton_1967_2020.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.887ff367d284a1cd039e49523cfeed21887ff367d284a1cd039e49523cfeed21Matching 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.6901769017Examining 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 CAL__Daily_Phytoplankton_1967_("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Water_Column_Integrated" TEXT,"Chlorophyceae_mm^3L^_1" FLOAT,"Chrysophytceae_mm^3L^_1" FLOAT,"Bacilariophyceae_mm^3L^_1" FLOAT,"Dinophyceae_mm^3L^_1" FLOAT,"Cyanophyceae_mm^3L^_1" FLOAT,"Flagellates_mm^3L^_1" FLOAT,"Euglenophyceae_mm^3L^_1" FLOAT,"Cryptophyceae_mm^3L^_1" 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 displayed1967, June, 6/5/67, Whole Column, 7907.003367, 207.5555556, 1422.845118, 0, 1730.053872, 753.1851852, 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.708.1/ee630946c9fc939e4ec54bf5511cf66d
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 data641641The expected number of records (641) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_PMLZooplankton_Concentration_Biomass_1968_2020
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 less50
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 125369 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_PMLzoop_conc_biomass_1968_2020.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.bee8e09ec8d3fa850d3f7ce8b21f8741bee8e09ec8d3fa850d3f7ce8b21f8741Matching 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.125369125369Examining 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 CAL_PMLZooplankton_Concentrati("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Time" TEXT,"Depth" TEXT,"diaptomus_conc_indv*L^_1" FLOAT,"cyclopoid_conc_indv*L^_1" FLOAT,"daphnia_conc_indv*L^_1" FLOAT,"bosmina_conc_indv*L^_1" FLOAT,"holopedium_conc_indv*L^_1" FLOAT,"Nauplii_conc_indv*L^_1" FLOAT,"Diaphanosoma_conc_indv*L^_1" FLOAT,"Polyphemus_conc_indv*L^_1" FLOAT,"total_conc" FLOAT,"diaptomus_biomass_microg*L^_1" FLOAT,"cyclopoid_biomass_microg*L^_1" FLOAT,"daphnia_biomass_microg*L^_1" FLOAT,"bosmina_biomass_microg*L^_1" FLOAT,"holopedium_biomass_microg*L^_1" FLOAT,"total_biomass" 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 displayed1968, May, 05/30/1968, ND, ND, 4.738083334, 0, 0.285713542, 0, 0.282119497, ND, ND, ND, 5.305916373, 9.476166667, 0, 1.828566667, 0, 2.990466667, 14.2952
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.708.1/ffce0fe4638b77d00307e3fa434d1b71
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 data784784The expected number of records (784) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_DOC_2012_2020
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 less17
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 36298 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_DOC_2012_2020.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.279cae8ad15fa2ffef33befaef0085c5279cae8ad15fa2ffef33befaef0085c5Matching 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.3629836298Examining 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 CAL_DOC_2012_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Depth_m" TEXT,"DOC_mg*L_1" TEXT);
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 displayed2012, June, 6/20/2012, 0, 2.67817373
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.708.1/ee40d373a5a6909075103b8123505920
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 data10351035The expected number of records (1035) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_DIC_2014_2020
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 less17
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 40765 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_DIC_2014_2020.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.2e6d1528f298234e3507488abcb11b632e6d1528f298234e3507488abcb11b63Matching 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.4076540765Examining 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 CAL_DIC_2014_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Depth_m" FLOAT,"DIC_mg*L_1" TEXT);
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 displayed2014, June, 6/11/2014, 0, 5.556
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.708.1/42f7a773fb5f6035055fe5f9af91924f
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 data12221222The expected number of records (1222) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_Nutrients_1968_2020
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 less23
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 251373 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_Nutrients_1968_2020.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.2b644f817ae92cb953ddacb17845a4e72b644f817ae92cb953ddacb17845a4e7Matching 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.251373251373Examining 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 CAL_Nutrients_1968_2020("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Depth_m" TEXT,"NH4_N_ppb" TEXT,"NO3_N_ppb" TEXT,"SRP_ppb" FLOAT,"TDP_ppb" FLOAT,"TP_ppb" 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 displayed1968, June, 6/4/68, 5, 85, 5.6, ND, ND, ND
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.For attribute name "SRP_ppb", data value ND is not the expected data type of 'FLOAT': For input string: "ND"
21headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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 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.
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.708.1/4c009429e5083d80478e537be4203c31
Entity Report
Entity Name: CAL_FishCatch_2009_2019
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 less23
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 87671 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_FishCatch_2009_2019.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.dee07b66936d8f0f5c7f7f5c02cfc11bdee07b66936d8f0f5c7f7f5c02cfc11bMatching 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.8767187671Examining 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 CAL_FishCatch_2009_2019("Year" FLOAT,"Month" TEXT,"Date" TIMESTAMP,"Location" TEXT,"Depth" TEXT,"Species" TEXT,"Fish_No" TEXT,"Sl" TEXT,"TL_cm" FLOAT,"Weight_g" TEXT,"Sex" TEXT);
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 displayed2009, June, 6/12/09, Spring, ND, RT, 2009_001, 12.2, 35.3, 280, M
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.708.1/6016fcab6e80cb6e89c89bc0ac7d4827
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 data14891489The expected number of records (1489) was found in the data table.
25headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_Fishstocking_1959_2020
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 1284 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_Fishstocking_1959_2020.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.ab2331c5004d005b015015c733e8c52fab2331c5004d005b015015c733e8c52fMatching 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.12841284Examining 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 CAL_Fishstocking_1959_2020("Year" FLOAT,"Number_Fingerling" FLOAT,"Number_Catchable" FLOAT,"TotalWeight_Fingerling" FLOAT,"TotalWeight_Catchable" 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 displayed1959, 10001, 0, 39.81, 0
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.708.1/53e3900c836b4010d1b9d6e35608b27d
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 data6262The expected number of records (62) was found in the data table.
24headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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: CAL_Bathymetry
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 less14
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 209474 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/castle-ff53512af45bda01fc82b4e357e1f9be/uploads/Castle%20Lake%20Low%20Frequency%20Data/CAL_sonar_merged.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.7e3168397f8a96f4e1a128f4f01085427e3168397f8a96f4e1a128f4f0108542Matching 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.209474209474Examining 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 CAL_Bathymetry("Latitude" FLOAT,"Longitude" TEXT,"Depth_m" 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 displayed41.22763652, -122.3850655, 1.5
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.708.1/7bf9d41990d005dc5509281fdd6f51ff
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 data68456845The expected number of records (6845) was found in the data table.
24headerRowAttributeNamesinfo
Type:congruency
System:lter
On failure:info
Header row is displayed alongside attribute namesCompare tne 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.