Category Archives: Diverse

Create GeoJSON in php

GeoJSON is a text format for encoding various geographical structures. I have a large number of point data with various extra information stored in a postgresql data base. I fetch all the data into an array in php, using PDO::FETCH_ASSOC, … Continue reading

Posted in Diverse | Comments Off on Create GeoJSON in php

Postgres in python using flask-psycopg2

Not the most well-documented module I’ve ever seen… To make it connect to your database of choise, in the app-settings, feed in PSYCOPG2_DATABASE_URI=”pgsql://dbuser:dbpassword@dbhost/database” e.g. PSYCOPG2_DATABASE_URI=”pgsql://postgres:Secr1tPsswrd@localhost/postgres”

Posted in Diverse | Comments Off on Postgres in python using flask-psycopg2

.44 magnum cortado

When Clint Eastwood shows up in the foam, the coffe is strong enough to defend itself. Continue reading

Posted in Diverse | Comments Off on .44 magnum cortado

Gymtider

Gymtimene på 80-tallet var for de sterke og minnene kommer strømmende på. Gymlæreren min i 2. og 3. vgs hadde stor tro på at langdistanseløp var det eneste saliggjørende. Ut for 5000m på Bislett. Han sto på kanten og sekunderte. … Continue reading

Posted in Diverse | Comments Off on Gymtider

Client based web-mapping

Maps with R – part III shows how to make an active svg-map from R. In that example, a specialiced data set was used. I have redone it by using a map pulled in from postgis and also added on … Continue reading

Posted in Diverse | Comments Off on Client based web-mapping

Om å lage en scene

Enhver hage med respekt for seg selv bør ha en festival fra tid til annen- og da trenges det en scene. Vår scene blir bygget hovedsaklig av 2″x6″,det er mulig det kunne holdt med 2″x4″, men det var nå en … Continue reading

Posted in Diverse | Comments Off on Om å lage en scene

Fixing damaged pickguard

There should be some limits to stupidity – I tried to pick up my bass while the cable was plugged in and I was standing on the cable… It ended up with a broken pickguard: I don’t know how easy … Continue reading

Posted in Diverse | Comments Off on Fixing damaged pickguard