Hi Matthieu,

  Thank you for the information. I am very interested as that is what we are trying to do also.

We have made some progress towards having a web interface to our fisheries acoustic data and I would be interested in seeing what you’ve done.

Can you give me the web link or tell me how to access via QGis?

Thanks,

Adam

 

Hi Adam (& co),
I also have someone here in Canada who is working on a relational database fully aligned with the ICES metadata standard. I'll get in touch with him and get back to you.
-sg


-----Original Message-----
From: Adam Dunford [mailto:Adam.Dunford@niwa.co.nz]
Sent: Mon 2/24/2014 7:23 PM
To: Carrie Wall Bell - NOAA Affiliate; Michael Jech - NOAA Federal
Cc: Tim.Ryan@csiro.au; alex.derobertis@noaa.gov; Chris Taylor - NOAA Federal; ddoolittle@ku.edu; davidm@echoview.com; Ryan.Downie@csiro.au; erwan.josse@ird.fr; gavinj@imr.no; nilsolav@imr.no; Hassan.Moustahfid@noaa.gov; jeff.condiotty@simrad.com; jhorne@u.washington.edu; julien.barde@ird.fr; Gordon.Keith@csiro.au; lars.nonboe.andersen@simrad.com; Laura Kracker - NOAA Federal; Laurent.Berger@ifremer.fr; Mathieu.Doray@ifremer.fr; Melvin, Gary D; niklas.larson@slu.se; nolwenn.behagle@ird.fr; hector.pena@imr.no; Reka Domokos - NOAA Federal; Richard O'Driscoll; Rick Towler - NOAA Federal; s_elayoubi@hotmail.com; sascha.fassler@wur.nl; sigurdur@hafro.is; sof@bas.ac.uk; Gauthier, Stephane; sromain@gmail.com; Taina.Honkalehto@noaa.gov; tomasz.laczkowski@mir.gdynia.pl; Verena.Trenkel@ifremer.fr; Brent Wood
Subject: RE: Implementation of metadata standard

Hi all,
   We also have implemented a relational database for our acoustic metadata. The ERD is attached, and like the NOAA WCD one from Carrie, we've also implemented an organisation/hierarchy that is closely aligned with the ICES metadata convention.

We've provided WFS access to our acoustic metadata via QGIS and, using QGIS's action feature (developed by Gavin Macaulay, one of the lead DB creators), we can provide access to echogram images for all transects in the database.

The echogram images for all transects are stored in an Atlas database which NIWA hosts and public access is available via
atlas.niwa.co.nz/public.jsp (click on toggle images/documents on the RH sidebar once logged in to display all 70K pictures - note not all are echograms)

As the database is slightly customised to our own system, and as we're now moving to a different system paradigm with its own particularities I'm designing a multi-schema database which will have a public-facing schema which is fully ICES metadata compliant. Probably as a materialised view, drawn from a number of private schema which are more data/format/system specific.

So I'm particularly interested in whether anyone has tried to implement a relational model which is totally based on the ICES metadata convention.

Cheers,
Adam

From: Carrie Wall Bell - NOAA Affiliate [mailto:carrie.wall@noaa.gov]
Sent: Tuesday, 25 February 2014 9:50 a.m.
To: Michael Jech - NOAA Federal
Cc: Tim.Ryan@csiro.au; alex.derobertis@noaa.gov; Chris Taylor - NOAA Federal; ddoolittle@ku.edu; davidm@echoview.com; Ryan.Downie@csiro.au; erwan.josse@ird.fr; gavinj@imr.no; nilsolav@imr.no; Hassan.Moustahfid@noaa.gov; jeff.condiotty@simrad.com; jhorne@u.washington.edu; julien.barde@ird.fr; Gordon.Keith@csiro.au; lars.nonboe.andersen@simrad.com; Laura Kracker - NOAA Federal; Laurent.Berger@ifremer.fr; Mathieu.Doray@ifremer.fr; Gary.Melvin@dfo-mpo.gc.ca; niklas.larson@slu.se; nolwenn.behagle@ird.fr; hector.pena@imr.no; Reka Domokos - NOAA Federal; Richard O'Driscoll; Rick Towler - NOAA Federal; s_elayoubi@hotmail.com; sascha.fassler@wur.nl; sigurdur@hafro.is; sof@bas.ac.uk; Stephane.Gauthier@dfo-mpo.gc.ca; sromain@gmail.com; Taina.Honkalehto@noaa.gov; tomasz.laczkowski@mir.gdynia.pl; Verena.Trenkel@ifremer.fr; Adam Dunford
Subject: Re: Implementation of metadata standard

Hi all,

I provided the attached metadata schematic to Tim earlier today but perhaps it's more prudent to disseminate it to the group and thus directly to Adam. We have implemented a relational database and it seems to be working quite well for us currently. Some of our terminology is slightly different from that of ICES but the general hierarchy and fields are very closely aligned.  Please note the floating dark green cubes are views for our web-based map service and can be ignored.

I will be at WGFAST in May and am looking forward to presenting an update on the archive and our metadata efforts.  I would be delighted to have a follow-up discussion at the meeting and am open to either an informal or formal setting.

Until then, if you have any questions about the attached or other aspects of our metadata/archive project, please don't hesitate to let me know.

Carrie.



--

Carrie C. Wall, PhD

Fisheries Acoustician



Cooperative Institute for Research in Environmental Sciences (CIRES)

University of Colorado at Boulder

NOAA/NGDC Marine Geology and Geophysics Division

325 Broadway E/GC3, Boulder, CO 80305



T: 303-497-4459, F: 303-497-6513

Office: 1B121, NOAA David Skaggs Research Center

On Mon, Feb 24, 2014 at 1:38 PM, Michael Jech - NOAA Federal <michael.jech@noaa.gov<mailto:michael.jech@noaa.gov>> wrote:
Hi Tim and Adam,
I'm glad Carrie Wall is on this list because she and Chuck Anderson
are leading the US effort to archive and set up metadata for the water
column acoustic data coming off the NOAA vessels. Adam should contact
her directly, and hopefully can avoid re-inventing the wheel in
different hemispheres.

I'm hoping Carrie will give a presentation at the WGFAST meeting this
year, to give everyone an update on our progress. If there is enough
interest, we could get together after a day of the meeting, or we
could meet informally for beers and discussion. If you want to meet a
bit more formally, let me know - I know the co-hosts of the meeting to
set up a room :)

Thanks,
mike

On 2/23/14, Tim.Ryan@csiro.au<mailto:Tim.Ryan@csiro.au> <Tim.Ryan@csiro.au<mailto:Tim.Ryan@csiro.au>> wrote:
> Hi all,
>
> I trust everybody is well.
>
> Email below from Adam Dunford (NIWA) asking about implementation of the
> metadata convention in a relational database. If you have some experience of
> this and can help please contact Adam.
>
>
> I'm trying to get my head around the ICES metadata convention with the
> intention of implementing it in a relational database. Scary, I know - and
> making my head hurt at times as I try and talk to our DB people and metadata
> experts :)
> But I was wondering if you knew of anyone else trying to do the same sort of
> thing and if so what relational model they ended up with. No point
> re-inventing the wheel.
>
> I know that the final report carefully avoids both recommending any
> particular implementation or even being so closely aligned to one particular
> methodology that it's obvious for (e.g. netCDF). I just wondered if at
> various times through the iteration of the metadata convention you had any
> discussions as to how it might be done as an RDB if one was going to do so.
> Adam Dunford [Adam.Dunford@niwa.co.nz<mailto:Adam.Dunford@niwa.co.nz>]
>
>
> More generically, as people implement the metadata they are bound to find
> aspects that could be improved or elements that are missing. Are people on
> this mailing list happy to continue as a group that can serve to update the
> metadata convention in response to user feedback? Hopefully this would not
> be too much work and could be done mostly by email, but with the possibility
> of meeting up either formally or informally at FAST if warranted.
>
> If you want out, let me know and I can take you off the email list,
> otherwise I'll renew your free lifetime membership :).
>
>
> Best regards
>
>
>
>
> Tim
>


--
########################################################
# J. Michael Jech
# NEFSC
# 166 Water St.                            (voice) 508-495-2353<tel:508-495-2353>
# Woods Hole, MA 02543              (fax) 508-495-2115<tel:508-495-2115>
# michael.jech@noaa.gov<mailto:michael.jech@noaa.gov>
########################################################

--
Please consider the environment before printing this email.
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.

-- 

Mathieu Doray, PhD

Ifremer

Département Ecologie et Modèles pour l'Halieutique

rue de l'Ile d'Yeu

B.P. 21105

44311 Nantes Cedex 03

mathieu.doray@ifremer.fr

Tel./Phone: 02 40 37 41 65 / International: 332 40 37 41 65

Fax : 02.40.37.40.01 / International: 332 40 37 40 01

CV / resume: http://annuaire.ifremer.fr/cv/17093/