Skip to content

Instantly share code, notes, and snippets.

View peterdesmet's full-sized avatar

Peter Desmet peterdesmet

102 followers · 13 following
View GitHub Profile
@peterdesmet
peterdesmet / cc0-organizations.md
Last active January 3, 2016 08:39
List of organizations in the field of life sciences requiring CC0 for submitted data.
@peterdesmet
peterdesmet / LatLong Crosshairs.js
Last active January 2, 2016 19:28
LatLong Crosshairs for Google Maps by Pierre Bélisle and Peter Desmet for Canadensys. http://www.canadensys.net/latlong-crosshairs
javascript:var coord;var output;var xhs;if(!document.getElementById('xhs')){xhs=document.createElement('div');xhs.setAttribute('id','xhs');xhs.setAttribute('style', 'background:url(\'http://www.canadensys.net/crosshair.png\') top left no-repeat;position:absolute;top:50%;left:50%;margin-top:-7px;margin-left:-7px;height:15px;width:15px;');xhs.onclick=function(){coord = [gApplication.getMap().getCenter().lat(),gApplication.getMap().getCenter().lng()];output = Math.round(coord[0]*10000000)/10000000 + '\t' + Math.round(coord[1]*10000000)/10000000;prompt('Latitude and Longitude',output);};void(document.getElementById('map').appendChild(xhs));}else{void(document.getElementById('map').removeChild(xhs));}
@peterdesmet
peterdesmet / belgian-lambert-to-wgs84.sql
Last active August 29, 2015 14:07
Transform Belgian Lambert to WGS84 in PostgreSQL
-- SetSRID defines the datum. Use 31370, not 31300 for Belgian Lambert 72
SELECT
*,
ST_Transform(ST_SetSRID(ST_MakePoint(x,y),31370),4326) as geom_from_lambert,
ST_Y(ST_Transform(ST_SetSRID(ST_MakePoint(x,y),31370),4326)) as latitude_from_lambert,
ST_X(ST_Transform(ST_SetSRID(ST_MakePoint(x,y),31370),4326)) as longitude_from_lambert
FROM table_name
@peterdesmet
peterdesmet / rbins_radar_prepare_data.sql
Last active August 29, 2015 14:07
SQL queries to dive into the data from the RBINS radar.
ALTER TABLE rbins_radar_occurrences
RENAME COLUMN expr1000 to date;
ALTER TABLE rbins_radar_occurrences
ALTER COLUMN area SET data type integer USING area::integer;
ALTER TABLE rbins_radar_occurrences
ALTER COLUMN av_reflectivity SET data type integer USING av_reflectivity::integer;
ALTER TABLE rbins_radar_occurrences
ALTER COLUMN date SET data type timestamp with time zone USING date::timestamp with time zone;
ALTER TABLE rbins_radar_occurrences
@peterdesmet
peterdesmet / ericSuperimposedDailyTorque.css
Last active August 29, 2015 13:56
CartoDB CSS and SQL to visualize flights of gull Eric with days superimposed on each other.
/** torque visualization */
Map {
-torque-frame-count:2048;
-torque-animation-duration:30;
-torque-time-attribute:"date_time";
-torque-aggregation-function:"count(cartodb_id)";
-torque-resolution:1;
-torque-data-aggregation:linear;
}