rastermanden’s gists

rastermanden / stat2pg

Created April 16, 2015 11:16

statistikbanken til postgresql

	DROP TABLE IF EXISTS stat.folketal;
	CREATE TABLE stat.folketal
	(
	komkode character varying,
	tid character varying,
	antal integer
	);

	COPY stat.folketal
	FROM PROGRAM

rastermanden / get_setsm.sh

Created April 17, 2015 19:38

download arctic dem

	#!/bin/bash

	tiles=( 14_39 15_37 15_38 15_39 16_37 16_38 16_39 16_40 17_37 17_38 17_39 17_40 18_37 18_38 18_39 18_40 19_37 19_38 19_39 19_40 20_37 20_38 20_39 21_37 21_38 21_39 21_40 22_37 22_38 22_39 22_40 23_37 23_38 23_39 23_40 )
	for i in "${tiles[@]}"
	do
	echo fetching $i
	filelist=`wget -q -O - http://repository.agic.umn.edu/imagery/stereoDEM/SETSM/ArcticDEM/$i/10m/ \| sed -n 's/.href="$[^"]$.*/\1/p' \| grep SETSM_ArcticDEM_`

	for file in $filelist
	do

rastermanden / moduler.md

Last active August 29, 2015 14:22

workshop_postgis

https://www.youtube.com/channel/UCmcMHysP0ErDq_0tPz2RJkg

rastermanden / 000-default.conf

Last active August 16, 2019 20:52

mapcache

	LoadModule mapcache_module /usr/lib/apache2/modules/mod_mapcache.so
	<VirtualHost *:80>
	# The ServerName directive sets the request scheme, hostname and port that
	# the server uses to identify itself. This is used when creating
	# redirection URLs. In the context of virtual hosts, the ServerName
	# specifies what hostname must appear in the request's Host: header to
	# match this virtual host. For the default virtual host (this file) this
	# value is not decisive as it is used as a last resort host regardless.
	# However, you must set it for any further virtual host explicitly.
	#ServerName www.example.com

rastermanden / program.md

Last active November 19, 2015 08:26

kurusprogram

#Dag 1

Tidspunkt	Emne	Form	Forberedelsestid
9:00-10:00
10:00-10:10	PAUSE
10:10-11:10
11:10.11:15	PAUSE
11:15-12:00
12:00-12:30	FROKOST
12:30-13:30

rastermanden / qgis.json

Last active March 31, 2016 12:03

{"map": {"layer": [{"features_host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs&SERVICE=WFS&REQUEST=GetFeature&typeName=jernb&outputformat=GeoJSON", "name": "Jernbanen", "features_type": "LineString", "visible": false, "host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs", "layer_name": "jernb", "features_dataType": "json"}, {"features_host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs&SERVICE=WFS&REQUEST=GetFeature&typeName=togstat&outputformat=GeoJSON", "name": "togstat", "features_type": "Point", "visible": true, "host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs", "layer_name": "togstat", "features_dataType": "json"}, {"features_host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs&SERVICE=WFS&REQUEST=GetFeature&typeName=skov&outputformat=Ge

rastermanden / valgrind_output.txt

Created December 9, 2016 10:49

	==78577== Memcheck, a memory error detector
	==78577== Copyright (C) 2002-2015, and GNU GPL'd, by Julian Seward et al.
	==78577== Using Valgrind-3.12.0 and LibVEX; rerun with -h for copyright info
	==78577== Command: ogr2ogr -overwrite -a_srs epsg:25832 -f postgresql pg:dbname=udsigt\ active_schema=kilde /Users/mbj/Downloads/PGV_bygning.sqlite pgv_bygning -nln bygning --config PG_USE_COPY YES
	==78577==
	==78577== Conditional jump or move depends on uninitialised value(s)
	==78577== at 0x7FFF5FC23DC7: bcmp (in /usr/lib/dyld)
	==78577== by 0x7FFF5FC11AF4: ImageLoaderMachO::validateFirstPages(linkedit_data_command const, int, unsigned char const, unsigned long, long long, ImageLoader::LinkContext const&) (in /usr/lib/dyld)
	==78577== by 0x7FFF5FC16D6A: ImageLoaderMachOCompressed::instantiateFromFile(char const, int, unsigned char const, unsigned long, unsigned long long, unsigned long long, stat const&, unsigned int, unsigned int, linkedit_data_command const, encryption_info_command const, ImageLoader::L

rastermanden / tinglysning.sql

Created September 4, 2017 11:38

tinglysning_func.sql

	DROP function IF EXISTS get_tinglysning_uuid(vejnavn text, husnummer text, etage text, doer text, supplerendebynavn text, postnummer text);
	CREATE OR REPLACE FUNCTION get_tinglysning_uuid(vejnavn text, husnummer text, etage text, doer text, supplerendebynavn text, postnummer text)
	RETURNS json AS
	$BODY$


	from urllib2 import urlopen
	#from simplejson import loads
	import urllib
	## need to set inputarguments as global variables

rastermanden / ejerbolig_randers.xml

Last active October 19, 2017 08:23

ejerbolig sld

	<sld:StyledLayerDescriptor xmlns:sld="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc">
	<sld:NamedLayer>
	<sld:Name>conzoom:public_wms_2015</sld:Name>
	<sld:UserStyle>
	<sld:FeatureTypeStyle>
	<sld:Rule>
	<Title>1: Primært ejerbolig</Title>
	<ogc:Filter>
	<ogc:Or>a
	<And>

rastermanden / ejerbolig_org.xml

Last active October 19, 2017 08:45

	<sld:StyledLayerDescriptor xmlns:sld="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc">
	<sld:NamedLayer>
	<sld:Name>conzoom:public_wms_2015</sld:Name>
	<sld:UserStyle>
	<sld:FeatureTypeStyle>
	<sld:Rule>
	<Title>1: Primært ejerbolig</Title>
	<ogc:Filter>
	<ogc:Or>
	<And>

Martin Bjærge Jensen rastermanden