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:
- id
- osm_id
- osm_type (node, way, route)
- name
- latitude
- longitude
- pt
- type
- icon_carto (OSM symbols)
- icon_fontawesome (Font Awesome names)
- address_street (1234 My Street)
- address_city
- address_region (TX)
- address_postalcode
- address_country
- visited_count
- created_at
- updated_at
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.