cameras.csv does not have key field to connect to deployment/images

[ysa...@g.clemson.edu]

Hi, 

In the cameras.csv file created for download, I do not find a key field that would allow to link this table to the other tables (e.g. images.csv, deployments.csv). For instance, the key field linking images.csv and deployments.csv is "deployment_id".

Am I missing something or is this key field missing ?

Yvan

[Wildlife Insights]

Hi Yvan,

The deployments.csv has the camera_id and camera_name field. Both of these can be linked to information in the cameras.csv.

The images.csv doesn't have a column for camera_id or camera_name, but you can link the image to the deployment in which it was captured using the deployment_id field.

Hope this helps!

Nicole

[ysa...@g.clemson.edu]

Hi Nicole, 

Thanks for getting back to me. I wrote my message to fast and could (should) have figured it out by myself!

Here is a summary if others have the same question:

 cameras.csv             <<  >>                   deployments.csv                  <<  >>         images.csv

   camera_id                                      camera_id    deployment_id                       deployment_id

camera_name                            camera_name

[Wildlife Insights]

Thanks Yvan!