search

aodn / public-schema

Shared schema specifications for data exchange (WFS, CSV, etc...)
GNU General Public License v3.0
1 stars 0 forks source link

Bgc #2

Closed sedgar closed 3 years ago

sedgar commented 3 years ago

Initial pull request, using tabular-data-resource to describe 3 tables: bgc_trip , bgc_stationinfo, bgc_chemistry.

mhidas commented 3 years ago

Responding to email from @clairedavies :

I have added station code to the bgc_trip table although it would be pretty simple to just take the first 3 chr’s of the trip_code to get the statin code if required. This change will filter through as Steve updates etc.

:+1: Thanks.

I would rather not change the station code as you suggested, the NRS information is already in the ProjectName column. These can be concatenated for linking to the CTD product. The station code for all sites including non NRS stations is 3 letters. This is used a lot for plotting and products so it is a bit of a pain to change all that, it’s a bit of 6 and two 3’s but as we have set up this way, I’m loathe to change to make one query easier, when it isn’t really tricky in the first place.

Ok, we can make that work. (Hopefully it won't get more complex than "NRS" + STATIONCODE if PROJECTNAME="NRS" else STATIONCODE.)

mhidas commented 3 years ago

RESOLVED :+1: Once last comment for now: The bgc_trip table currently doesn't seem to exist on the CSIRO geoserver. When I try to access the specified URL, I get an error with the message java.io.IOExceptionORA-00942: table or view does not exist

mhidas commented 3 years ago

@sedgar I think all that remains is to remove bgc_phyto_countraw, then we can merge this!