Skip to content

Instantly share code, notes, and snippets.

View middleforkgis's full-sized avatar

Steve Walker middleforkgis

  • Middle Fork Geographic Information Services
View GitHub Profile
@middleforkgis
middleforkgis / osm2pgsql_sql_statements.txt
Created September 24, 2018 20:19
osm2pgsql statement capture
SET synchronous_commit TO off;;
SET client_min_messages = WARNING;
DROP TABLE IF EXISTS planet_osm_point CASCADE;
DROP TABLE IF EXISTS planet_osm_point_tmp;
RESET client_min_messages;
BEGIN;
CREATE UNLOGGED TABLE planet_osm_point (osm_id int8,"access" text,"addr:housename" text,"addr:housenumber" text,"addr:interpolation" text,"admin_level" text,"aerialway" text,"aeroway" text,"amenity" text,"area" text,"barrier" text,"bicycle" text,"brand" text,"bridge" text,"boundary" text,"building" text,"capital" text,"construction" text,"covered" text,"culvert" text,"cutting" text,"denomination" text,"disused" text,"ele" text,"embankment" text,"foot" text,"generator:source" text,"harbour" text,"highway" text,"historic" text,"horse" text,"intermittent" text,"junction" text,"landuse" text,"layer" text,"leisure" text,"lock" text,"man_made" text,"military" text,"motorcar" text,"name" text,"natural" text,"office" text,"oneway" text,"operator" text,"place" text,"population" text,"power" text,"power_source" text,"public