Difference between revisions of "CartoDB"

From ecology
Jump to: navigation, search
Line 8: Line 8:
 
== GPS tables ==
 
== GPS tables ==
  
The e-ecology gps.ee*limited tables are available on the CartoDB server.
+
The following tables are available on the CartoDB server:
The tables available are the same as on https://services.e-ecology.sara.nl/wiki/index.php/DB_Views_2015, but with following changes to tables with a location column:
 
  
* Added cartodb_id column, as primary key
+
* gps.ee_species_limited
* Added the_geom_webmercator column
+
* gps.ee_individual_limited
* Renamed location column to the_geom column
+
* 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 https://services.e-ecology.sara.nl/wiki/index.php/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
  
Only data from the gull projects is available on the CartoDB server.
 
 
The data is not synced.
 
The data is not synced.
  
 
== Limitations ==
 
== Limitations ==
  
* Not all links are working like:
+
* 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 please don't contact Cartodb.com, but contact s.verhoeven@esciencecenter.nl
+
* Geocoding (eg. converting city name to lat,lon) is not working
 +
* Login with Google+ does not work

Revision as of 14:52, 28 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

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 https://services.e-ecology.sara.nl/wiki/index.php/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

  • 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