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

Hi! Could someone please post the structure of a mysql-database for OSM? (a pasteable sql would be great from phpmyadmin for example)

Greetings John

(I'm happy I found this help.openstreetmap.org page. It seems not to be linked on the main page. And the forum that I found before isn't so handy as this help-systen here.)

asked 08 Mar '15, 23:42

John215's gravatar image

John215
31225
accept rate: 0%

Not to answer your question, but for the avoidance of doubt, help.openstreetmap.org is linked to from http://www.openstreetmap.org/help (from the help button on openstreetmap.org), along with the "welcome" page and the wiki.

(09 Mar '15, 00:08) SomeoneElse ♦

There is no "the mysql database" - see this page for info.

If you want to know about the "main" OpenStreetMap PostgreSQL database (used by what is referred to as the "Rails Port") see here and here, and follow the links from those pages. If you want to know about how to store data so that it can be rendered, then the actual database structure can depend on the data selected to be rendered. This file determines the columns used by OpenStreetMap's "standard" style.

Of course, depending on what you want to do with OSM data, it's perfectly possible to think of ways to store it in MySQL, so a bit more information about what you're trying to do here would really help.

permanent link

answered 09 Mar '15, 00:19

SomeoneElse's gravatar image

SomeoneElse ♦
36.9k71370866
accept rate: 16%

Basically I just want all data in a db to be able to do many queries on it, to get preprocessed data. - I already found part of your links. I still asked because there are other pages on the wiki that still explicitly talk about the possibility to use mysql. As I only found this help-system here today, I only was able to find a similiar question today. The user asking had obviously the same error as I had. Your last link seems most helpful. I'll wait a bit before I mark your answer as accepted; maybe someone posts a working example for mysql-import of an osm-file - but I doubt that.

(09 Mar '15, 01:20) John215

I'm just curious. Is it possible to see those of my comments, that were deleted? (And who they were deleted by?)

(09 Mar '15, 15:10) John215

@John215 It wasn't me that deleted them :) I received the notification emails for them but they were gone when I read the question. I'm not aware of a way of seeing revisions of a deleted comment. Maybe have a look over on http://meta.osqa.net/ , but probably not worth asking there as it's pretty moribund these days.

(09 Mar '15, 15:20) SomeoneElse ♦

Ty again for your reply. I really wanted to know, before I hit accept at your answer. What I posted: It was 100% along what should go into the comments. I will add some of it later to my original question. - And then I wrote about stackoverflow: Yes, those were two offtopic sentences. But just look, someone complains at SO I would have made a crosspost there, because of here! SO=OSM? Lol

(09 Mar '15, 17:16) John215

Now I remember what else I wrote and why probably it was deleted. I wrote that the other user got downvoted on his last question on here, and is now inactive.

(09 Mar '15, 17:19) John215
1

You should either completely avoid making crossposts or mention them in every question. Otherwise you are wasting ressources by letting multiple people think about your problems that have probably already been solved elsewhere. It also makes finding the solution easier for other people having the same problem.

(10 Mar '15, 17:27) scai ♦

@scai: Just to put it straight, I make one comment to this: I first posted on stackoverflow a couple of questions about OSM, and I never got a real answer there, because most people over there simply don't know. - If you would mind to read the text consciously that you are commenting on, you would know by now, that I only yesterday found this help system here on OSM - and then I immediatly made an account here and asked here. And see! Here I got the right answer. Plain, fast, exactly to the point. (Ty again @SomeoneElse!) - (No Ty to you, Scai, sorry.) And OSM!=SO.

(10 Mar '15, 20:41) John215

@Scai: Now that I am at it, a really last comment. I also found similiar questions on stackoverflow, that were some years old, and got no answer, or even got downvoted. - Most people over there just do not know anything about OSM, at least when it comes to putting a 40+GByte osm-file into a database. Answers on that specific topic usually use words like: Should, may, might, could, and 'I haven't tried it myself'.

(10 Mar '15, 20:47) John215
1

@John215: Stack Overflow is about programming. Your question is not about programming, hence it is completely offtopic for Stack Overflow and people will start downvoting it. However it might be ontopic for http://gis.stackexchange.com where you will also find way more more people with OSM knowledge than at SO. Also you didn't really get my point from my previous comment. And this is the wrong place for this discussion.

(11 Mar '15, 07:49) scai ♦
showing 5 of 9 show 4 more comments
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:

×118
×21
×18
×12
×4

question asked: 08 Mar '15, 23:42

question was seen: 6,720 times

last updated: 01 Aug '18, 11:29

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