CartoDB

CartoDB is an open source tool that allows for the storage and visualization of geospatial data on the web. See http://www.cartodb.com

Our own CartoDB server is at http://cartodb.e-ecology.cloudlet.sara.nl . Accounts can be made on request by s.verhoeven@esciencecenter.nl after being OK-ed by Willem Bouten.

Documentation for setup of CartoDB server can be found at https://github.com/NLeSC/eEcology-CartoDB

GPS tables

The following tables are available on the CartoDB server:

• gps.ee_species_limited
• gps.ee_individual_limited
• gps.ee_project_limited
• gps.ee_tracker_limited
• gps.ee_track_session_limited
• gps.ee_tracking_speed_limited

The tables have the same colums as described on DB_Views_2015

Tables with a location column have been made CartoDB compliant by

• Adding cartodb_id column, as primary key
• Adding the_geom_webmercator column
• Renaming the location column to the_geom column

Only data from the following projects is available on the CartoDB server:

• lbbg_texel
• hg_texel
• hb_veluwe
• ef_alegranza

The data is not synced.

Limitations

• Disk space is limited, please do not copy data from gps.* tables to your own account
• Some links will redirect back to http://cartodb.com
• Whenever you see an error or have a support question please don't contact support at cartodb, but contact s.verhoeven@esciencecenter.nl
• Geocoding (eg. converting city name to lat,lon) is not working
• Login with Google+ does not work

Create CartoDB map visualization based on eEcology data

1. Press `NEW MAP` button
2. Press `CREATE NEW MAP` button
3. Press `CREATE EMPTY MAP` button
4. Enter a SQL query in the SQL tab (SQL icon left side of screen)
5. Press `Apply query` button
6. Switch to `MAP VIEW` to see the map

Example queries

A time window of a single tracker

SELECT * FROM gps.ee_tracking_speed_limited WHERE device_info_serial = 344 AND date_time BETWEEN '2013-01-01' AND '2014-01-01'

Compare 2 species

SELECT cartodb_id, the_geom, the_geom_webmercator, date_time, english_name FROM gps.ee_species_limited s JOIN gps.ee_individual_limited i ON s.latin_name = i.species_latin_name JOIN gps.ee_track_session_limited USING (ring_number) JOIN gps.ee_tracking_speed_limited USING (device_info_serial) WHERE date_time BETWEEN '2015-01-01' AND '2015-06-02' AND english_name IN ('Herring Gull', 'Lesser Black-backed Gull')