Add Bus Stops to Map

General talk
1

Hi,

I’m brandnew to this program and unfortunately the search doesn’t seem to work properly, so I don’t know if a topic like mine already exists.

Here’s my question:

I have the coordinates for about 1000 busstops in a german state. Unfortunately, they are saved in an .xls table!

Is there a way to upload these coordinates without typing them in one-by-one?

Hope someone can help.

Cheers,
TAHL

2

Hi,

it should be possible to do a mass import with some scripting - the hard part would probably be connecting the bus stops with the existing road network and avoiding duplicates. I personally don’t have experience with automated imports, so I’ll leave the technical support to someone else.

I have some questions, though:

  • What’s the source of that data?
  • What information is in there? Just coordinates and names or some other details (street name, direction, bus routes), too?
3

Hi

The bus stops are for demand responsive public transport in the administrative district of Anhalt-Bitterfeld.
I got the coordinates directly from the operating company.
Information is name and number of the stop and the associated municipality. As it’s demand responsive transport, only few of them have specific directions or bus routes.

4

Hi,

I don’t know if there is any “csv2osm” or “poi2osm” tool yet. In your case it should feed the values from your spread sheet into osm.xml file so that the result would be something like this:

<?xml version='1.0' encoding='UTF-8'?>

I can’t program anything but I feel that making a csv2osm program transferring coordinates and attributes from a text file to osm.xml format would not be extra difficult for anybody who can. Then were would be the work with checking the data, cleaning out dublicates etc. that should be done prior to uploading.

5

@TAHL: If you are comfortable using mailing lists, my suggestion would be to contact the German “talk-de” mailing list - your data seems to be Germany-related and some people on the list should have experience with imports - or the generic “imports” mailing list. Of course, I don’t want to discourage you from further relying on the forum for answers, but it tends to be less active than the mailing lists, especially for more technical questions.

6

Just a thought, but most of this is fixed text, so if it’s in Excel already you could insert the fixed text around each of the variable lat and lon figures. I don’t think each point would have to be on multiple lines and you would have 1 line per point.

So if the lat is in A1 and the lon is in B1, C1 would contain something like:
=“ … ”

I don’t know if the id=-1 value has to change, but this would be easy enough to make it a variable too.

Add the headers and footers and export column C as a text file and you’ve done it. Easy!! :wink:

I don’t think you can import a list of nodes like this directly, but open it in JOSM and upload the changes that way.

Hope this helps.

Steve