James Chevalier JamesChevalier

An area ID in Overpass is the OSM relation ID + 3600000000

This information is kind of buried in the Overpass API wiki page documenting the available filters: https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL#By_area_.28area.29

The OSM relation ID can be seen in two places:

Visit https://www.openstreetmap.org and search for the city
Click on its entry and you will be taken to a https://www.openstreetmap.org/relation/SOME_NUMBER_HERE page
The relation ID is in the URL as "SOME_NUMBER_HERE" in the bullet point above
The relation ID will also be in parentheses next to the city name in the left column

Keybase proof

I hereby claim:

I am jameschevalier on github.
I am jameschevalier (https://keybase.io/jameschevalier) on keybase.
I have a public key ASAQJByN_kqSZ1GZddqGIXmHZ_yBBo8GelVseYAaPBgEiAo

To claim this, I am signing this object:

migration to enable uuid in postgres

class EnableUuidExtension < ActiveRecord::Migration[5.0]
  def change
    enable_extension 'uuid-ossp'
  end
end

select the existing instance in the Instances list
open the Actions menu
select Image -> Create Image
enter 'Interim AMI' for the Image name
enter 'Interim AMI' for the Image description
if you cannot accept downtime of the origin instance, check the box for No reboot
- The No reboot option means that the new image is created without gracefully stopping the machine first.
- This can be problematic for some things, like a database that's mid-write.
- If you can handle downtime, don't check the No reboot box.
click the Create Image button

Let's say you have a User with this relation:

has_one :item

The has_one relation disallows you from doing this:

first_user = User.first
first_user.item.create(field_one: value, field_two: value)

Installing Nominatim on Amazon Linux / EC2

Introduction

The official instructions for installing Nominatim are complete, but brief in places, and several steps must be changed in the Amazon Linux environment (which is roughly CentOS / Redhat). The steps below are rough record of what I did to get it working, but I didn't keep perfect track so you shouldn't rely on them as a shell script. Just follow each step, make sure it worked, and hopefully you'll need to adapt very little (version numbers, for one thing). (I also skip in and out of root, but you can be more careful if you like.)

Setting up the EC2 instance

Create an SSL Certificate for your website

In the Certificate Manager console, click the Request a certificate button
Enter the domain name in the field
Click the Review and request button
Click the button in the email that this request sends you to validate the request

Create the bucket for your website in S3

Create a new bucket in s3

	#!/usr/bin/env ruby
	require 'rubygems'
	require 'bundler/setup'
	require 'nokogiri'
	require 'json'
	require 'ap'

	# Small script for scraping POIs from JOSM (http://wiki.openstreetmap.org/wiki/JOSM_file_format).
	class Parser
	# Tags in data that we ignore.

	#!/bin/bash

	# collect the list of docker images
	images=$(docker images --format "{{.Repository}}:{{.Tag}}")

	# iterate through each image
	for image in $images
	do
	if [[ $image != "<none>" ]]; then
	# the image is tagged, so pull the latest version

	require 'benchmark'

	iterations = 100_000
	array_one = []
	array_two = []
	array_three = []

	Benchmark.bmbm do \|bm\|
	bm.report('<<') do
	iterations.times do