CartoDB - Revision history

Stefan verhoeven: Update url

2015-09-11T13:59:16Z

Update url

2015-08-18T09:45:51Z

Added export image kaput

2015-08-04T08:46:39Z

2015-08-04T07:45:21Z

‎GPS tables: More tables copied

2015-07-30T13:42:10Z

‎Example queries

2015-07-30T13:33:14Z

‎Example queries

2015-07-29T15:35:02Z

‎Create CartoDB map visualization based on eEcology data

2015-07-29T14:44:12Z

2015-07-28T15:47:00Z

2015-07-28T15:01:01Z

‎Limitations

@@ Line 1: / Line 1: @@
 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 .
+Our own CartoDB server is at http://cartodb.e-ecology.vm.surfsara.nl .
 Accounts can be made on request by s.verhoeven@esciencecenter.nl after being OK-ed by Willem Bouten.

@@ Line 46: / Line 46: @@
 * Login with Google+ does not work
 * Making visualization of a lot of rows (more than 65000 rows per tile) can be very slow
 == Create CartoDB map visualization based on eEcology data ==

@@ Line 4: / Line 4: @@
 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
+Installation documentation of CartoDB server can be found at https://github.com/NLeSC/eEcology-CartoDB
 == GPS tables ==
@@ Line 45: / Line 45: @@
 * 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 ==
@@ Line 87: / Line 88: @@
 Sharing has several different levels:
-* public
+* public, visualization is listed on your public profile page
 * public if url is known
-* readable by CartoDB users
+* readable by logged in users
 * private

@@ Line 16: / Line 16: @@
 * gps.ee_track_session_limited
 * gps.ee_tracking_speed_limited
 The tables have the same colums as described on [[DB_Views_2015]]

@@ Line 55: / Line 55: @@
 A time window of a single tracker
-<code>
+<pre>
 SELECT *
 FROM gps.ee_tracking_speed_limited
@@ Line 62: / Line 62: @@
 AND
 date_time BETWEEN '2013-01-01' AND '2014-01-01'
-</code>
+</pre>
 Compare 2 species
-<code>
+<pre>
 SELECT cartodb_id, the_geom, the_geom_webmercator, date_time, english_name
 FROM
@@ Line 77: / Line 77: @@
 AND
 english_name IN ('Herring Gull', 'Lesser Black-backed Gull')
-</code>
+</pre>

@@ Line 44: / Line 44: @@
 == Create CartoDB map visualization based on eEcology data ==
-. Press `NEW MAP` button
+# Press `NEW MAP` button
-. Press `CREATE NEW MAP` button
+# Press `CREATE NEW MAP` button
-. Press `CREATE EMPTY MAP` button
+# Press `CREATE EMPTY MAP` button
-. Enter a SQL query in the SQL tab (SQL icon left side of screen)
+# Enter a SQL query in the SQL tab (SQL icon left side of screen)
-. Press `Apply query` button
+# Press `Apply query` button
-. Switch to `MAP VIEW` to see the map
+# Switch to `MAP VIEW` to see the map
 === Example queries ===

@@ Line 36: / Line 36: @@
 == 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

@@ Line 17: / Line 17: @@
 * 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
+The tables have the same colums as described on [[DB_Views_2015]]
 Tables with a location column have been made CartoDB compliant by