Paul Norman pnorman

## gist:0999b98f28780e20a9afc7e988e0fe29
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

## log.txt
(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

## process-osm-data.sh
#!/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

## 4krw.txt
[global]
name=4k random rw 4ios in 32 queues
filename=fio.bin
ioengine=libaio
direct=1
bs=4k
rw=randrw
iodepth=32
numjobs=8
buffered=0

## changesetmd-partition.sql
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);

## index.html
<!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/leaflet@1.3/dist/leaflet.css" />
<script src="https://unpkg.com/leaflet@1.3/dist/leaflet.js"></script>
<script src="leaflet-hash.js"></script>
<style type="text/css">
  .leaflet-tile-container {
	pointer-events: auto;

## Go_COC.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                pnorman
                / Go_COC.md
            
            
              Last active
              August 18, 2016 00:31
            
              
                Go Code of Conduct
              
          
    Go Community Code of Conduct

Why have a Code of Conduct?

Online communities include people from many different backgrounds. The Go contributors are committed to providing a friendly, safe and welcoming environment for all, regardless of age, disability, gender, nationality, race, religion, sexuality, or similar personal characteristic.
The first goal of the Code of Conduct is to specify a baseline standard of behavior so that people with different social values and communication styles can talk about Go effectively, productively, and respectfully.
The second goal is to provide a mechanism for resolving conflicts in the community when they arise.

  
## commands.sh
# These commands won't set anything up but will pre-download
# the big packages

sudo apt-get update && sudo apt-get upgrade
sudo apt-get install zip unzip curl git ca-certificates \
  postgresql-9.5-postgis-2.2 postgresql-contrib-9.5 \
  osm2pgsql proj-bin mapnik-utils node-carto \
  fonts-dejavu-core fonts-droid-fallback ttf-unifont \
  automake libtool g++ libmapnik-dev apache2 apache2-dev

## profile.lua
--[[
    This script calls the tag transform functions to profile their performance


]]--


require("../openstreetmap-carto")

-- repeatable runs

## index.html
<!DOCTYPE html>
<html>
<head>
  <script src='http://api.tiles.mapbox.com/mapbox.js/v0.6.7/mapbox.js'></script>
  <link href='http://api.tiles.mapbox.com/mapbox.js/v0.6.7/mapbox.css' rel='stylesheet' />
  <style>
    body { margin:0; padding:0; }
    #map { position:absolute; top:0; bottom:0; width:100%; }
  </style>
</head>
	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
	(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
	#!/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
	[global]
	name=4k random rw 4ios in 32 queues
	filename=fio.bin
	ioengine=libaio
	direct=1
	bs=4k
	rw=randrw
	iodepth=32
	numjobs=8
	buffered=0
	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);
	<!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/leaflet@1.3/dist/leaflet.css" />
	<script src="https://unpkg.com/leaflet@1.3/dist/leaflet.js"></script>
	<script src="leaflet-hash.js"></script>
	<style type="text/css">
	.leaflet-tile-container {
	pointer-events: auto;
	# These commands won't set anything up but will pre-download
	# the big packages

	sudo apt-get update && sudo apt-get upgrade
	sudo apt-get install zip unzip curl git ca-certificates \
	postgresql-9.5-postgis-2.2 postgresql-contrib-9.5 \
	osm2pgsql proj-bin mapnik-utils node-carto \
	fonts-dejavu-core fonts-droid-fallback ttf-unifont \
	automake libtool g++ libmapnik-dev apache2 apache2-dev
	--[[
	This script calls the tag transform functions to profile their performance


	]]--


	require("../openstreetmap-carto")

	-- repeatable runs
	<!DOCTYPE html>
	<html>
	<head>
	<script src='http://api.tiles.mapbox.com/mapbox.js/v0.6.7/mapbox.js'></script>
	<link href='http://api.tiles.mapbox.com/mapbox.js/v0.6.7/mapbox.css' rel='stylesheet' />
	<style>
	body { margin:0; padding:0; }
	#map { position:absolute; top:0; bottom:0; width:100%; }
	</style>
	</head>