Difference between revisions of "CartoDB"
| Line 36: | Line 36: | ||
== Limitations == | == 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 | * 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 | * 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 | * Geocoding (eg. converting city name to lat,lon) is not working | ||
* Login with Google+ does not work | * 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 | ||
| + | |||
| + | Do not press `create dataset from query` link as this will duplicate data. | ||
| + | |||
| + | === Example queries === | ||
| + | |||
| + | A time window of a single tracker | ||
| + | <code> | ||
| + | SELECT * | ||
| + | FROM gps.ee_tracking_speed_limited | ||
| + | WHERE | ||
| + | device_info_serial = 355 | ||
| + | AND | ||
| + | date_time BETWEEN '2011-05-26' AND '2011-05-26' | ||
| + | </code> | ||
Revision as of 14:44, 29 July 2015
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
Contents
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
Do not press `create dataset from query` link as this will duplicate data.
Example queries
A time window of a single tracker
SELECT *
FROM gps.ee_tracking_speed_limited
WHERE
device_info_serial = 355
AND
date_time BETWEEN '2011-05-26' AND '2011-05-26'
