alexanno

wget --keep-session-cookies --save-cookies cookies.txt --post-data 'name={USERNAME}&pass={PASSWORD}&form_build_id=form-NaPSEn1C_qDxG4CVz3n0wf5wis4cZuSin2WrZJr68xY&form_id=user_login_block&op=Logg%20inn' http://data.kartverket.no/download/content/velkommen?destination=node/134

wget --load-cookies cookies.txt http://data.kartverket.no/download/mine/downloads

grep -o "http://data.kartverket.no/download/system/files/terrengdata/10m/utm33/Terrengdata.*zip" downloads > dllist

wget --load-cookies cookies.txt -i dllist

alexanno

• Portland:
  • Bryggerier og tap rooms overalt
  • Universitetsby
  • Kulturell/kunstnerisk
• Animasjon
  • OL3, Mapbox GL, Leaflet continuous zoom, Torque.js/CartoDB
  • Klient-rendring
  • 3D
  • Cesium: kraftig og modent
• OL3: 1.0

alexanno

alexanno

alexanno

find ./ -name \*Elveg.SOS -execdir echo "ogr2ogr -update -append -f PostgreSQL PG:'host=localhost port=54321 dbname=sandbox user=postgres active_schema=sandbox' -progress -nln elveg {}" \;

find ./ -name \*Adresser.SOS -execdir ogr2ogr -update -append -f PostgreSQL PG:'host=localhost port=54321 dbname=sandbox user=postgres active_schema=sandbox' -progress -nln adresser {} \;

####################################################
#using shp2pgsql
#!/bin/bash

for f in *.shp
do

alexanno

set search_path to "sandbox","public";
DROP VIEW IF EXISTS grid_test_001;
CREATE VIEW grid_test_001 as (
SELECT g.gid, g.the_geom, count(*) FROM hex_grid_001 g 
JOIN n1000_turisthytte p 
ON g.the_geom && st_transform(p.wkb_geometry,4326)
GROUP BY g.gid, g.the_geom
);

CREATE TABLE sandbox.t_grid_n1000_byggpkt_0125 AS 

alexanno

#!/usr/bin/env bash
 
COLOR="\033[;35m"
COLOR_RST="\033[0m"

sudo apt-get update
sudo apt-get -y install python-software-properties build-essential curl

echo -e "${COLOR}--- Installing PHP5 ---${COLOR_RST}"
sudo apt-get install -y php5 php5-curl php5-pgsql

alexanno

READHOST=***
READUSER=***
READPASSWORD=***
WRITEHOST=***
WRITEPASSWORD=***
WRITEUSER=***
## vars need integration in commands with ex: host=$READHOST

ogr2ogr --config PG_USE_COPY YES -f GeoJSON testsql.geojson PG:'host=localhost dbname=alexanno user=alexanno' -progress -sql "SELECT * FROM sandbox.kommuner" -lco COORDINATE_PRECISION=5

alexanno

#http://kartoza.com/how-to-create-a-qgis-pdf-report-with-a-few-lines-of-python/

# coding=utf-8
 
# A simple demonstration of to generate a PDF using a QGIS project
# and a QGIS layout template.
#
# This code is public domain, use if for any purpose you see fit.
# Tim Sutton 2015
 

alexanno

• https://github.com/spatialdev/PGRestAPI/blob/master/docs/VectorTiles.md

• supports filtering with 'where clause'

• http://localhost:30001/services/postgis/vector_n50_adminflate/geometri/vector-tiles/{z}/{x}/{y}.pbf?fields=komm,navn&where=komm%3d1601

• https://github.com/SpatialServer/Leaflet.MapboxVectorTile

• https://github.com/spatialdev/PGRestAPI/blob/master/docs/Ubuntu_Install.md

• https://github.com/spatialdev/PGRestAPI/blob/master/docs/VectorTiles.md

• http://spatialserver.spatialdev.com/services/tables/philippines_coverage/geom/vector-tiles

• http://54.212.251.211/services