Monday, November 18, 2019

Open Street Maps Nominatim Part 3: Adding US Census TIGER Address Data

Part 1 | Part 2 | Part 3 Overview: The base Open Street Maps (OSM) planet files shall not contain street/house address numbers for the United...

Open Street Maps Nominatim Part 2: Importing Planet File

Part 1 | Part 2 | Part 3 Overview: The following instructions explain how to create a Nominatim database from an OSM planet file. It is...

Open Street Maps Nominatim Part 1: Standing up a Reverse Geocoding Solution

Part 1 | Part 2 | Part 3 Overview: This is the first of three articles discussing the process to stand up an OSM Nominatim instance....

MySQL: Quick Session Collation Script

Overview: As discussed in many threads and Stack Overflow postings, collation settings were not as important in MySQL V5.OLDDAYS. With MySQL 5.5 onward, the impact...