Skip to content

Instantly share code, notes, and snippets.

View ImreSamu's full-sized avatar
🗺️

ImreSamu ImreSamu

🗺️
67 followers · 146 following
View GitHub Profile
@ImreSamu
ImreSamu / locale.md
Last active August 29, 2015 14:20
iD Editor statistics - 2015-04-28 .. 2015-05-04

meta

  • source : OpenStreetMap Changeset data
  • where filter: created_by='iD 1.7.1' or created_by='iD 1.7.2'
  • changeset min created_at: "2015-04-28 02:42:25"
  • changeset max created_at: "2015-05-04 05:34:55"
locale changesets
en-US 22631
@ImreSamu
ImreSamu / openstreetmap_changeset_summary2015may04.md
Created May 4, 2015 07:29
OpenStreetMap Changeset Summary for iD Editor users ( 2015.05.04 )

OpenStreetMap Changeset Summary for iD Editor users

  • where platform is not null
  • created_at: min - max : "2015-04-25 00:30:10" - "2015-05-04 07:20:55"
type value count percent
browser Chrome 15.0 1 0.00 %
@ImreSamu
ImreSamu / OpenStreetMap_Changeset_Summary_20150513.md
Last active August 29, 2015 14:21
OpenStreetMap Changeset Summary ( 2 weeks; iD, JOSM )

OpenStreetMap Changeset Summary ( 2 weeks; iD, JOSM )

  • where : 2015-04-30 00:00:01 <= closed_at <= 2015-05-13 23:59:57
  • unique user: COUNT(DISTINCT(uid)) ... group by type, value
  • ordered by : "unique user" descending

Editors ( all )

|group|type|value|unique user | unique user percent per group| changeset sum | changeset percent per group|

@ImreSamu
ImreSamu / imposm3_schema_test.sh
Created January 26, 2016 12:39
#!/bin/bash
set -x
impconnection=postgis://$PGHOST/$PGDATABASE
monaco_osm_pbf=./parser/pbf/monaco-20150428.osm.pbf
mapping_file=./test/single_table_mapping.json
function import {
/go/src/github.com/omniscale/imposm3/imposm3 import -mapping $mapping_file \
@ImreSamu
ImreSamu / analyse_osm2vectortiles_osm_id.sql
Created April 19, 2016 13:15
osm2vectortiles - check mapping

-- analyse osm2vectortiles check: imposm3mapped vs. used osm_id-s
-- draft code
-- current know limitation
-- current imposm3 mapping osm_id is not uniq : "type_mappings" without "use_single_id_space": true,
-- created by ImreSamu
CREATE OR REPLACE FUNCTION count_osmid( tablelist TEXT[] ) RETURNS bigint AS $$
DECLARE
@ImreSamu
ImreSamu / single_id_FALSE_test_report.md
Created April 24, 2016 21:33
Osm2Vectortiles test : use_single_id_space: false & use_single_id_space: true + test code

Osm2Vectortiles test

  • osm2vectortiles version: f00b6e8de3958f3343a99c3c444200c4429d976d
  • mapping file settings: use_single_id_space: false
  • generated: Sun, 24 Apr 2016 23:22:43 +0200

Base OSM testdata - for imposm3 import

<?xml version='1.0' encoding='UTF-8'?>
<osm version="0.6" upload="false" generator="o2vtest">
@ImreSamu
ImreSamu / Dockerfile-osm-history-splitter
Created July 3, 2016 21:01
Dockerfile for osm-history-splitter
##
## Docker file for osm-history-splitter
##
FROM ubuntu:16.04
RUN export DEBIAN_FRONTEND=noninteractive
ENV DEBIAN_FRONTEND noninteractive
#### -- Set the locale
RUN locale-gen en_US.UTF-8
@ImreSamu
ImreSamu / o2tilelist_test01.sh
Created September 2, 2016 15:38
imposm3 - tilelist test ... for -> https://github.com/osm2vectortiles/osm2vectortiles/pull/416
#!/bin/bash
set -o errexit
set -o pipefail
set -o nounset
readonly IMPOSM_CACHE_DIR=${IMPOSM_CACHE_DIR:-/data/cache}
readonly OSM_DB=${OSM_DB:-osm}
readonly OSM_USER=${OSM_USER:-osm}
@ImreSamu
ImreSamu / new_highway.id
Created June 14, 2017 11:17
simple: OSM history file + Osmium + OverpassQuery example
n4699265780
n4699285506
n4745206236
n4745227207
n4745227208
n4745227209
n4745227210
n4757590350
n4757590351
n4757594972
@ImreSamu
ImreSamu / natural_earth_diff.md
Created August 23, 2017 00:35
NaturalEarth wikidataId - SparQL query differences. ( Data generated via WIKIDATA SPARQL )
id name ADM0NAME QA status NE_wikidataid proposed wikidataid SPARQL status found wikidata found wikidata name distance
4 Florida Uruguay WD04: Difference Q812 Q842472
84 Busia Uganda WD04: Difference Q1240823 Q1111957
96 Kibuye Rwanda WD04: Difference Q22218005 Q617032
233 Fribourg Switzerland WD04: Difference Q3067114 Q36378
289 Sabaneta Dominican Republic WD04: Difference Q2049091 Q2021983
53