search

lifewatch / etn-otn-exchange

European Tracking Network (ETN) and Ocean Tracking Network (OTN) data exchange issues
4 stars 2 forks source link

OTN -> ETN missing layer fields #15

Closed aubrivliz closed 2 years ago

aubrivliz commented 3 years ago

For 2 layers we are missing fields that are mapped with ETN fields.

otnunit:etn_animals
tag_owner_pi
tag_manufacturer
otnunit:etn_deployments
station_no
deploy_lat
deploy_long
ins_model_no
ins_serial_no
deployed_by
recover_lat
recover_long
download_date_time
last_download
diniangela commented 3 years ago

Thank you for the list! I have now included these into the layers

I also made a list of Geoserver layers and their columns and descriptions in OTN_geoserver_layers_and_columns.md

Please let me know if these look good and work

aubrivliz commented 3 years ago

@diniangela On the layers i get following error:

otnunit:etn_animals: java.lang.RuntimeException: java.io.IOException java.io.IOExceptionorg.postgresql.util.PSQLException: ERROR: column "type" does not exist Position: 8 ERROR: column "type" does not exist Position: 8

otnunit:etn_deployments: java.lang.RuntimeException: java.io.IOException java.io.IOExceptionorg.postgresql.util.PSQLException: ERROR: column "model" does not exist Position: 33 ERROR: column "model" does not exist Position: 33

diniangela commented 3 years ago

@aubrivliz I changed some of the names of the fields (e.g. type --> tag_type)

It has now been fixed in the Geoserver layers

aubrivliz commented 2 years ago

@diniangela I've just noticed that we are missing the receiver manfacturer. Is it possible to add this in the etn_deployments layer?

diniangela commented 2 years ago

@aubrivliz Yup, I've added a "manufacturer" field into the etn_deployments layer and have fixed the duplicate catalognumber issue that was happening earlier 😄

aubrivliz commented 2 years ago

Is it possible to add the tag frequency in the layer "otnunit:etn_animals" ?

diniangela commented 2 years ago

Yup, it should be in there now as tag_frequency