Skip to content

Instantly share code, notes, and snippets.

View alexanno's full-sized avatar

Alexander Salveson Nossum alexanno

30 followers · 17 following
  • Norway
View GitHub Profile
@alexanno
alexanno / index.html
Last active October 29, 2015 21:37
<!doctype><html><head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Odyssey.js Scroll</title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="icon" type="image/x-icon" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">
<link rel="icon" type="image/png" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">
@alexanno
alexanno / postgis2geojson.sql
Created November 3, 2015 19:43
SELECT row_to_json(fc)
FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features
FROM (SELECT 'Feature' As type
, ST_AsGeoJSON(lg.geom, 4)::json As geometry
, row_to_json((SELECT l FROM (SELECT fylkesnr, navn) As l
)) As properties
FROM sandbox.fylker As lg ) As f ) As fc;
@alexanno
alexanno / cartodb-json-flattener.sql
Created November 24, 2015 12:30
SELECT *,
(select string_agg(value->>'tekstfelt',', ') a from
json_array_elements(tekstfelt::json) m) tekstfelt_streng
FROM mellomlag m
@alexanno
alexanno / index.html
Created December 3, 2015 14:45
yeBWbZ
http://www.webatlas.no/mediakart/testbuild_v2/embed/kart.htm
@alexanno
alexanno / notater.md
Created January 14, 2016 12:11
Webinar #1 - 2016. FME+CartoDB
@alexanno
alexanno / sql-notater.sql
Last active April 12, 2016 22:08
-- http://overpass-turbo.eu/
-- https://gist.github.com/atlefren/60234fb68d8299136c05
-- http://www.norkart.no/produkt/datavarehus/
-- toalett og kommunekart
SELECT
f.cartodb_id,
f.the_geom_webmercator,
f.the_geom,
@alexanno
alexanno / cartodb-kurs-nmbu.md
Last active February 3, 2016 12:10
Kurs og bedriftspresentasjon for NMBU 3. februar 2016
@alexanno
alexanno / webinar-01.04.16
Created March 31, 2016 21:04
Klippe raster til et polygon for visning
* Du har en WMS
** Eksporter det område du vil ha som geotiff
*** Save as image (rimelig ok oppløsning)
*** Print composer (~300dpi)
** Last inn igjen og sett projeksjonen eksplisitt (raster-projection-assign projection)
* Finn frem favorittpolygonet ditt
** Eller tegn på frihånd et scratch layer
@alexanno
alexanno / NTNU - postgis-kurs
Last active April 13, 2016 21:56
NTNU kurs i postgis / cartodb
Introduksjon
-------
* NORKART
* https://vimeo.com/92617228
* Webinar:
* http://www.norkart.no/kurs/gratis-webinar-laer-alt-du-vil-vite-om-fme-og-open-source-27/
* http://www.norkart.no/kurs/gratis-webinar-cartodb-og-mediakart-3/
* Sommerjobb i Trondheim
* Utvikler - JS, HTML, PostGIS, linux/devop
@alexanno
alexanno / wms leaflet
Last active April 13, 2016 16:31
var globalCartoDB_SQL_Layer = null;
$("#btn_runquery").click(function() {
var query = $("#sqlcommand").text();
var cartocss = $("#cartocss").text();
runSQL_API(query);
updatemap(query, cartocss);
})
function createMap() {