pnorman’s gists

pnorman / results.csv

Last active January 3, 2019 21:52

pnorman / LICENCE

Created June 6, 2018 05:55

open mouth emoji

This SVG is licensed CC0 by Paul Norman

pnorman / tiledemo.html

Created May 25, 2018 08:31

	<!DOCTYPE html>
	<html style="height:100%;margin:0;padding:0;">
	<title>Leaflet page with OSM render server selection</title>
	<meta charset="utf-8">
	<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/leaflet.css" />
	<script src="https://unpkg.com/[email protected]/dist/leaflet.js"></script>
	<script src="https://unpkg.com/[email protected]/leaflet-hash.js"></script>
	<style type="text/css">
	.leaflet-tile-container { pointer-events: auto; }
	</style>

pnorman / names.csv

Last active March 25, 2018 09:05

name data

pnorman / 7_19_43.geojson

Created February 26, 2018 00:53

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

pnorman / gist:0999b98f28780e20a9afc7e988e0fe29

Created September 18, 2017 20:58

osm2pgsql RC email

	We're looking at releasing osm2pgsql 0.94.0 soon and could use testing
	of the 0.94.0-RC1 version. Testing from packagers is appreciated,
	particularly if you are doing something different with libosmium.

	Major changes

	- Store unprojected coordinates in slim tables and use osmium dense file
	array for flat nodes

	This fixes a number of projection-related issues

pnorman / log.txt

Created March 25, 2017 08:23

osmium error with osm2pgsql changes

	(gdb) run -d osm2pgsql_test --number-processes 1 --output multi --style cleartables.json --flat-nodes nodes.bin ~/osm/osm2pgsql/tests/liechtenstein-2013-08-03.osm.pbf
	Starting program: /home/pnorman/osm/osm2pgsql/build/osm2pgsql -d osm2pgsql_test --number-processes 1 --output multi --style cleartables.json --flat-nodes nodes.bin ~/osm/osm2pgsql/te
	sts/liechtenstein-2013-08-03.osm.pbf
	[Thread debugging using libthread_db enabled]
	Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
	osm2pgsql version 0.93.0-dev (64 bit id space)

	Using lua based tag processing pipeline with script admin.lua
	Using lua based tag processing pipeline with script admin.lua
	Using lua based tag processing pipeline with script place.lua

pnorman / process-osm-data.sh

Last active April 7, 2022 20:00

	#!/usr/bin/env bash

	# This script will
	# 1. Download OSM data and load it into a DB
	# 2. Update that DB
	# 3. Keep a local copy of the planet up to date

	# Requirements
	# - osmium-tool
	# - osmosis

pnorman / 4krw.txt

Last active January 30, 2017 10:35

pnorman / changesetmd-partition.sql

Last active January 6, 2017 06:49

Partion ChangesetMD tables

	UPDATE osm_changeset_state SET update_in_progress = 1; -- lock out ChangesetMD from updating
	ALTER TABLE osm_changeset RENAME TO old_osm_changeset;

	CREATE TABLE osm_changeset (LIKE old_osm_changeset INCLUDING CONSTRAINTS);

	CREATE TABLE osm_changeset_0m AS SELECT * FROM old_osm_changeset WHERE id >= 0 AND id < 10000000;
	ALTER TABLE osm_changeset_0m ADD CHECK (id >= 0 AND id < 10000000);
	CREATE UNIQUE INDEX osm_changeset_0m_pkey ON osm_changeset_0m (id) WITH (fillfactor = 100);
	ALTER TABLE osm_changeset_0m ADD PRIMARY KEY USING INDEX osm_changeset_0m_pkey;
	CREATE INDEX ON osm_changeset_0m (user_id) WITH (fillfactor = 100);