lukasmartinelli

CREATE VIEW poi_label_zoom_level_changes AS (
	SELECT osm_id, timestamp FROM poi_label_z14
);


CREATE VIEW road_zoom_level_changes AS (
	SELECT osm_id, timestamp FROM road_z14
	UNION ALL
	SELECT osm_id, timestamp FROM road_z13
	UNION ALL

lukasmartinelli

import json

doc = json.load(open('cities.json'))
for region, region_obj in doc['regions'].items():
    for city_name, city_obj in region_obj['cities'].items():
        bbox = city_obj['bbox']
        parts = city_name.split('_')

        if len(parts) != 2:
            continue

lukasmartinelli

#!/usr/bin/env python
import csv
import sys
import os
import mercantile

DELIMITER = os.getenv('DELIMITER', ' ')


def calculate_center(x, y, zoom):

lukasmartinelli

import json


ids = {}
for line in open('failed-jobs.json'):
    doc = json.loads(line)
    if not doc['id'] in ids:
        ids[doc['id']] = True
        print(json.dumps(doc))

lukasmartinelli

import fileinput
import sys


def around_north_pole(y):
    return y < 75


def around_south_pole(y):
    return y > 184

lukasmartinelli

import fileinput
import sys

for line in fileinput.input():
    tokens = line.split('"-"')
    time_tokens = tokens[-1].strip().split(' ')

    try:
        nginx_time, php_time = float(time_tokens[0]), float(time_tokens[1])
    except ValueError:

lukasmartinelli

Proposed Changes

Vision

Cut compatibility back to support using slightly modified Mapbox Open Styles (OSM Bright and Basic) and iterate from there.

### Schema

Take a look at the diff between future OSM2VectorTiles v3 and Mapbox Streets v7.

lukasmartinelli

#admin
  [admin_level]
  [disputed]
  [maritime]
  [osm_id]
#aeroway
  [osm_id]
  [type]
#building
  [osm_id]

lukasmartinelli

Usage

Meant to create pyramid jobs for OSM2VectorTiles when only a tile list file is available (e.g. recovering missing tiles).

cat missing_tiles.txt | sed 's/MISSING//g' | python generate_pyramid_jobs.py
```

lukasmartinelli

#!/bin/bash
set -o errexit
set -o pipefail
set -o nounset

function compress_inplace() {
    local filename="$1"
    gdal_translate -co compress=lzw "$filename" "$filename.compressed"
    rm "$filename"
    mv "$filename.compressed" "$f"