eclubb

#!/bin/sh

# This script will migrate schema and data from a SQLite3 database to PostgreSQL.
# Schema translation based on http://stackoverflow.com/a/4581921/1303625.
# Some column types are not handled (e.g blobs).

SQLITE_DB_PATH=$1
PG_DB_NAME=$2
PG_USER_NAME=$3

rodw

#!/bin/bash 
# A simple script to backup an organization's GitHub repositories.

#-------------------------------------------------------------------------------
# NOTES:
#-------------------------------------------------------------------------------
# * Under the heading "CONFIG" below you'll find a number of configuration
#   parameters that must be personalized for your GitHub account and org.
#   Replace the `<CHANGE-ME>` strings with the value described in the comments
#   (or overwrite those values at run-time by providing environment variables).

djq

/*
  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

tmcw

The difference between XYZ and TMS tiles and how to convert between them

Lots of tile-based maps use either the XYZ or TMS scheme. These are the maps that have tiles ending in /0/0/0.png or something. Sometimes if it's a script, it'll look like &z=0&y=0&x=0 instead. Anyway, these are usually maps in Spherical Mercator.

Good examples are OpenStreetMap, Google Maps, MapBox, MapQuest, etc. Lots of maps.

Most of those are in XYZ. The best documentation for that is slippy map tilenames on the OSM Wiki, and Klokan's Tiles a la Google.

minorua

#!/usr/bin/env python3
# name      : fgddem.py
# purpose   : translates digital elevation model of Fundamental Geospatial Data provided by GSI
#             into a GDAL supported format (which has write access).
# license   : The MIT License
# copyright : (c) 2012, Minoru Akagi
#
# Permission is hereby granted, free of charge, to any person obtaining a
# copy of this software and associated documentation files (the "Software"),
# to deal in the Software without restriction, including without limitation

diegovalle

#!/bin/bash
# Author: Diego Valle-Jones
# Web: http://www.diegovalle.net
# Purpose: Download shapefiles of manzanas (blocks), agebs (census areas), ejes
# viales (streets), interesting areas and a whole bunch of other stuff

# Note that you'll need a recent version of innoextract
# http://constexpr.org/innoextract/, one that can work with files
# created by version 5.5 of Inno Setup, the one in Ubuntu universe is
# not recent enough.  The version available at

darrell

CREATE OR REPLACE FUNCTION voronoi(table_name text,geom_col text) returns SETOF record as $$

#############################################################################
#
# Voronoi diagram calculator/ Delaunay triangulator
# Translated to Python by Bill Simons
# September, 2005
#
# Additional changes by Carson Farmer added November 2010
#

cquest

Ingredients

• a decent DEM
• gdal
• some computer

compute grayscale hillshade using gdaldem

gdaldem hillshade -compute_edges your_dem_file hillshade.tif

color-ramp to compute transparency (alpha channel)

In another bowl, prepare the following shade.ramp file:

bertspaan

Python script to convert DBF database file to CSV

• First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
• Then install: sudo python setup.py install

To convert DBF file to CSV:

./dbf2csv database.dbf

denitram

# First, make a dump of the database without data (-s)
$ pg_dump -h localhost -U username -Fc -s -f db_dump dbName

# Create a list of the functions
$ pg_restore -l db_dump | grep FUNCTION > function_list

# Restore the functions in an other database
$ pg_restore -h localhost -U username -d other-dbName -L function_list db_dump