Skip to content

Instantly share code, notes, and snippets.

@neogis-de
neogis-de / voronoi.sql
Last active August 29, 2015 14:15 — forked from djq/voronoi.sql
/*
Feb 5, 2013
Original source from here: http://punkish.org/Voronoi-Diagrams-In-PostGIS
Updated old PostGIS function names to work with PostGIS2.0 (buffer, intersect, intersection and srid)
-djq
This function uses the deldir library in R to generate voronoi polygons for
an input set of points in a PostGIS table.
Original function by Mike Leahy mgleahy at alumni.uwaterloo.ca
ProxyRequests Off
<Proxy *>
Order deny,allow
Allow from all
</Proxy>
ProxyPass /geoserver http://localhost:8080/geoserver
ProxyPreserveHost On
ProxyStatus On
from PIL import Image
from PIL.ExifTags import TAGS, GPSTAGS
def get_exif_data(image):
"""Returns a dictionary from the exif data of an PIL Image item. Also converts the GPS Tags"""
exif_data = {}
info = image._getexif()
if info:
for tag, value in info.items():
decoded = TAGS.get(tag, tag)
@neogis-de
neogis-de / proxy.php
Last active August 29, 2015 14:20 — forked from bmcbride/proxy.php
<?php
$ch = curl_init($_GET['url']);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
curl_close($ch);
echo $output;
?>
# run in the geoserver webapp dir:
cd geoserver/src/web/app/
# If you use SVN
rm -rf /tmp/release
svn export ../../../data/release/ /tmp/release/
mvn jetty:run -DGEOSERVER_DATA_DIR=/tmp/release/
# if you use git-svn
git clean -xdf -- ../../../data/release/
point title description icon
10,20 my orange title my orange description
2,4 my aqua title my aqua description
42,-71 my purple title my purple description
#301 Redirects for .htaccess
#Redirect a single page:
Redirect 301 /pagename.php http://www.domain.com/pagename.html
#Redirect an entire site:
Redirect 301 / http://www.domain.com/
#Redirect an entire site to a sub folder
Redirect 301 / http://www.domain.com/subfolder/
@neogis-de
neogis-de / merge_ordnance_survey.bat
Last active September 4, 2015 10:14
ogr2ogr merge Ordnance Survey shapefiles from different subfolders together
@echo off
set OSGEO4W_ROOT=C:\OSGeo4W64
call "%OSGEO4W_ROOT%\bin\o4w_env.bat"
SETLOCAL ENABLEDELAYEDEXPANSION
rem set your folder which contains the shapefiles and change to this folder:
set verzeichnis=C:\YourShapefileFolder\
@neogis-de
neogis-de / postgis_trigger.sql
Last active June 30, 2018 05:02
postgis Trigger between polygon and point layer insert update delete ST_Intersection
CREATE TABLE label_point (
gid serial NOT NULL,
geom geometry(point, 3857),
label_sample varchar(255),
CONSTRAINT label_point_pkey PRIMARY KEY (gid)
);
CREATE TABLE soil (
gid serial NOT NULL,
geom geometry(polygon, 3857),
@neogis-de
neogis-de / geojson.js
Created September 28, 2015 07:32
geojson testfile
{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"properties": {
"name": "Null Island"
},
"geometry": {
"type": "Point",