🗺️ Meridian

OpenStreetMap-based places database and API.

MySQL will be used with support for spatial queries. This requires MySQL version 5.7 or later.

The schema will be a lightweight, simplification of OpenStreetMap tags, streamlined to the basics. Columns:

Longitude and latitude are stored in both separate FLOAT columns and as POINT, for more flexibility with querying and indexes.

The import script will process OSM data and try to determine type and icon for each place. Special files types.json and icons.json map OSM tags like “amenity”, “cuisine”, “tourism”, and others to Meridian’s types and icons.