Decide on columns in fish_tracking_tags

[peterdesmet]

• [x] cartodb_id
• [x] the_geom → which coordinates to choose for map: catch or release?
• [x] catch_latitude
• [x] catch_length → verify values
• [x] catch_location
• [x] catch_longitude
• [x] catch_weight → verify values
• [x] catched_at
• [x] is_ghost
• [x] project
• [x] release_latitude
• [x] release_location
• [x] release_longitude
• [x] released_at
• [x] remarks
• [x] scientific_name
• [x] sex → see #7
• [x] tag_id
• [x] tag_type
• [x] vernacular_name → see #8
• [x] updated_at
• [x] created_at

[ammouton]

length and weight should be added both catch and release location should be included; maybe we can include an additional field catch = release (1/0) to allow that release stays empty I would not remove the UTC time of "released at"? catch time should be added as well also catch ID, project, remarks and tag type

[peterdesmet]

length and weight should be added

Are added as catch_length and catch_weight

both catch and release location should be included;

Was already included

maybe we can include an additional field catch = release (1/0) to allow that release stays empty.

Yes, although it will be easier to work if those fields are just populated with the same data.

I would not remove the UTC time of "released at"?

released_at_time is now included in released_at. The old field has been removed. released_at has now the same format as all other datetime columns: yyyy-mm-ddThh:mm:ss

catch time should be added as well

If that info is available, it can be added to the catched_at datetime.

also catch ID

What would this identify?

project, remarks and tag type

All included.

[ammouton]

ok perfect

catch id was an error of mine; I meant tag id

problem solved