NOTICE: help.openstreetmap.org 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?

Thanks

asked 19 Jul '17, 13:36

aitizazk's gravatar image

aitizazk
217710
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 ♦
44.7k13326701
accept rate: 18%

edited 19 Jul '17, 15:21

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×165
×11
×6
×4

question asked: 19 Jul '17, 13:36

question was seen: 2,234 times

last updated: 20 Jul '17, 08:35

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