CSV Content in HydroShare
CSV is a widely used, interoperable spreadsheet file format that is commonly sued to hold many types of data. HydroShare will automatically recognize CSV content and display a preview of top 50 rows of content in the file in the content metadata panel to the right of the file upload section. To upload csv content, upload any file with the .csv file extension.
The first row in the CSV will be assumed to contain the column headers if all the values in that row have string values. However, a CSV file is valid even if it does not contain a header row. All rows that begin with the hash symbol “#” will be assumed to be comment headers and will be skipped when parsing/validating a CSV file. All other rows will be considered as data rows. There must be at least one data row in a CSV file.
For the CSV content type, the user needs to provide these metadata
- Title (required) - by default, this will be assigned as the file name but can be modified by the user.
- Description (optional) - a longer text description of the data in the CSV file.
- Keywords (optional) - one or more topical keywords associated with the content in the CSV file.
- Temporal Coverage (optional) - the date range associated with the content in the CSV file.
- Spatial Coverage (optional) - a point or bounding box showing the geospatial extent associated with the data in the CSV file.
- Key/Value metadata (optional) - user-defined key-value pair metadata.