I'm a streamkeeper for Stoney Creek, which is in Burnaby, not Coquitlam. I'm appalled that there are only 2 records for Stoney Creek in this database as we have been counting spawners and relaying that information to DFO for years: 38982942 Stoney Creek (Coquitlam) Coho Run 1 1996 1996 4 29C Coho RELEASED UNKNOWN Not Applicable 100-020100-56600-00000-0000-0000-000-000-000-000-000-000 NEAR FINAL 32895509 NOT INSPECTED 81765549 Stoney Creek (Coquitlam) Coho Run 1 1997 1997 4 29C Coho RELEASED UNKNOWN Unknown Estimate Method 100-020100-56600-00000-0000-0000-000-000-000-000-000-000 NEAR FINAL 44696786 PRESENT 10 How can we get our data into this database for others to see?
NuSEDS-New Salmon Escapement Database System
NuSEDS is the Pacific Region’s centralized Oracle database that holds adult salmon escapement data.
- Publisher - Current Organization Name: Fisheries and Oceans Canada
- Licence: Open Government Licence - Canada
|Resource Name||Resource Type||Format||Language||Links|
Geographic Region Name:
- British Columbia
Hi there, your escapement data in CSV format is very difficult to navigate and interpret for the average person. Please refer to the extremely simple and easily interpreted escapement data source for the Columbia River in the below link. You simply enter location, species and year range that you want the data for and it gives you a well organized CSV file. I wish NuSEDS was as user friendly. http://www.fpc.org/web/apps/adultsalmon/Q_adultcounts_dataquery.php
Thanks you, your comment has been forwarded to the Department of Fisheries and Oceans. Open Government Team
Hello, Response from the data owner: The way Open Data is structured it does not allow for actual queries of the data sources till after they are downloaded by the user. The NuSEDS dataset is bulky, but it does allow the user to download all of the data and perform their own queries on the whole dataset. There are plans underway to present the NuSEDS data on Open Maps/FGP, where users will have the ability to perform more queries and retrieve only the data they are interested in. Regards, Momin The Open Government team
May I ask if DFO might have this data in a more synthesized form so that the public can understand it? It took me quite a while to download the data but am having difficulties making sense of any of it. Thank you.
Hi Bo, thanks for your comment. I have forwarded your question to DFO for their response. Stay tuned! Momin, the Open Government team.
Bo, here's the response from the data owner: “The data as presented is in raw format and not rolled up into any form of synthesis. This allows the user of these data to roll up in any way that they choose. Published CSAS documents would provide a synthesis of these data. The metadata files presented on open data for the NuSEDS dataset describe the fields and also provide explanations of the data and how to interpret it. Hope this helps. Thanks.” CSAS publications may be searched by region, topic, etc. at this location: http://www.meds-sdmm.dfo-mpo.gc.ca/csas-sccs/applications/publications/search-recherche-eng.asp Please do not hesitate to contact us again if you have further comments or questions. Thank you, Momin, the Open Government team.
FYI - I noticed that all Conservation_* csv files are sending 550 Err. Example: 550 Folder /pub/openData/Conservation_Unit_Data.csv not found
Hi, thank you for the heads-up. We're working on it now.
Files seem to be fine though very large so some take awhile to open. The NuSEDS data steward looked into it and found everything to be working. It's possible that the 550 errors are email related - would you mind sending a screenshot to email@example.com if you're still getting the issue? Thank you, Kent on behalf of the open government team