database.csv
Database from the linked DOI, cleaned to meet the requirements of the CKAN datastore. Changes made were:
- Added Columns
-
Study_year_startandStudy_year_end(numeric). -
Value Transformations
- Split
Study_year(s)into start and end years. - Combined years (e.g.,
20092011) correctly split. -
Missing or invalid years replaced with
-1. -
Prefixes
- Added
"Depth "toStructure_depth_(in_seabed). -
Added
"Year "toStudy_year(s). -
Encoding & Formatting
- Standardized to UTF-8.
-
Normalized headers (underscores instead of spaces).
-
Data Types
- Converted new year columns to integers.
Өгөгдлийн толь бичиг
| Багана | Төрөл | Сэтэр | Тайлбар |
|---|---|---|---|
| Type_of_literature | text | ||
| Full_reference | text | ||
| Title | text | ||
| Intervention___level_1 | text | ||
| Population___level_1 | text | ||
| Population___level_2 | text | ||
| Population___level_3 | text | ||
| Outcome___level_1 | text | ||
| Outcome___level_2 | text | ||
| Presence_or_mention_of_non_native_or_invasive_species | text | ||
| Presence_or_mention_of_commercial_species | text | ||
| Study_design___level_1 | text | ||
| Study_design___level_2 | text | ||
| Study_year(s) | text | ||
| Date_of_Publication | numeric | ||
| Structure_ID_name | text | ||
| Structure_type | text | ||
| Structure_age_(at_time_of_study) | text | ||
| Structure_depth_(in_seabed) | text | ||
| Geographical_marine_location___level_1 | text | ||
| Geographical_marine_location___level_2 | text | ||
| Country | text | ||
| Region | text | ||
| Subject | text | ||
| Pressure | text | ||
| Outcome | text | ||
| ES_impact | text | ||
| ES_group | text | ||
| Classification_system_used | text | ||
| Notes | text | ||
| Study_year_start | numeric | ||
| Study_year_end | numeric | ||
| spatial_name | text |
Нэмэлт мэдээлэл
| Талбар | Утга |
|---|---|
| Өгөгдлийн сүүлийн шинэчлэл | 2025 оны арван хоёрдугаар сарын 2 |
| Мета өгөгдөлийн сүүлийн шинэчлэл | 2025 оны арван хоёрдугаар сарын 2 |
| Үүссэн | 2025 оны арван нэгдүгээр сарын 28 |
| Хэлбэр | CSV |
| Ашиглах зөвшөөрөл | Creative Commons Attribution |
| Ckan url | https://plymouth.thedata.place |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Has views | True |
| Hash | 8827a4fa9d1bed702afc1fd4dd1d0d7b |
| Id | 8f4999cc-6ae3-4a04-a628-97e1b501e46b |
| Ignore hash | False |
| Mimetype | text/csv |
| Original url | https://plymouth.thedata.place/dataset/09fe240a-c753-4c68-ae3c-6bb327c609f7/resource/8f4999cc-6ae3-4a04-a628-97e1b501e46b/download/merged_spatial_name_normalized.csv |
| Package id | 09fe240a-c753-4c68-ae3c-6bb327c609f7 |
| Position | 2 |
| Resource id | 8f4999cc-6ae3-4a04-a628-97e1b501e46b |
| Set url type | False |
| Size | 22.5 мегабайт |
| State | active |
| Task created | 2025-12-02 10:08:14.986561 |
| Url type | upload |
