search

inbo / fish-tracking

🐟 Collection of scripts for processing and analysing fish tracking data
3 stars 0 forks source link

Change data flow for receiver metadata #3

Closed peterdesmet closed 9 years ago

peterdesmet commented 9 years ago

Current data flow

  1. Receiver metadata are manually maintained in Access.
  2. To see those on a map, they are exported to a GIS programme.

    New data flow

  3. Receiver metadata are manually maintained on CartoDB:
    • Data are maintained online, in one place.
    • Locations can be seen on a map.
    • The map can be shared (optionally with password) with external users.
    • The API will be used to connect the metadata with the data.
  4. A SQL script will be provided to translate the lat/long to lambert coordinates, so the data can be exported and used in a GIS programme to create publication-ready maps.

    Fields

Addressed in #6

receiver_id
location_id (or station_id)
location
location_admin or other name
latitude
longitude
deployed_at
removed_at
battery_started_at
battery_stops_at
remarks
project_name
receiver_owner (?)
peterdesmet commented 9 years ago

@ammouton, can you review the issues description? When can we expect the data?

ammouton commented 9 years ago

Description looks good; data should be delivered by next Wednesday

peterdesmet commented 9 years ago

The SQL script is now available in https://github.com/LifeWatchINBO/fish-tracking/blob/master/cartodb/README.md, the other issues are addressed in #6.