NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi, I am looking for some help setting up openstreetmap in my existing rails app. I am new to the whole maps thing. In my app i am tracking locations of vehicles. now I want to add a feature where I can get the maxspeed, name and type of a road as well. I am considering openstreetmap because I dont want to make third party api calls for every location I get as the number of locations are greater than 1M per day.

Do I need to duplicate entire schema of OSM? as there are many irrelevant tables in the schema. or simple I should parse the .osm file and create tables for nodes ways and relations only? Also I would need to keep this data updated.

I would really appreciate if any one can point me in the right direction.. or share some links that would help me start?


asked 19 Jul '17, 13:36

aitizazk's gravatar image

accept rate: 0%

It would be great if you could help out instead posting crosspost on both platforms...

(20 Jul '17, 08:35) aitizazk

You definitely don't need to use the OSM API schema and likely a (potentially slimmed down) osm2pgsql schema that actually creates the geometries will be a lot less work than rolling your own.

This will give you an updateable DB that contain as many or as little tags that you want.

permanent link

answered 19 Jul '17, 14:46

SimonPoole's gravatar image

SimonPoole ♦
accept rate: 18%

edited 19 Jul '17, 15:21

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 19 Jul '17, 13:36

question was seen: 2,269 times

last updated: 20 Jul '17, 08:35

NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum