Hello,

I'm help a little town in France who actually use Quantum Gis, i creat for us the database for 855 point of street light with other data like coordinate, power, lenght of the pole,...

I can extract data to csv file but how can i import data directly to Openstreetmap ?

I see on website i can put the data to Cartodb.com and display a layer above Openstreetmap, but it seem extremly complex for me.

I have no budget to create a GIS server.

Have you got a simple solution to do that ?

I wan't to tell to the mayor, the locals can participate in the update data. But how is defined the principle of validation is that the mayor has always given control over to revalidated. The goal is to be certain that erroneous data is not added.

Best regards.

Addition:

For readability I put only one line with the header, of course I can put following the OpenStreetMap format separation value as "," or ";" in the end you see the geographical coordinates Lambert93 I can convert WGS84 if necessary.

REPERE  SECTEUR LIEU_DIT    CATEGORIE   TYPE_SUPPORT    ETAT    HAUTEUR_SUPPORT TYPE_LAMPE  NBRE_LAMPE  MARQUE  MODELE  DATE_POSE   ETAT    DERNIERE_INTERVENTION   COMMENTAIRE_1   COMMENTAIRE_2   PUISSANCE   Position X  Position Y

1   1   Avenue de Rodez Point lumineux  Candelabre  SATISFAISANT    8m  Lampe à sodium haute pression 100 watts 1   Thorn   Pilote  oct-98  SATISFAISANT                100 000000.00   0000000.00

asked 20 May '13, 20:38

gabriel45895's gravatar image

gabriel45895
11113
accept rate: 0%

edited 20 May '13, 22:09

aseerel4c26's gravatar image

aseerel4c26 ♦
32.2k16239552

4

Aside from the technical question, make sure that you are aware that there are quality standards for imports. In particular, consensus in the local community and documentation are mandatory. It's also good to have solid previous experience with OSM before performing an import.

(20 May '13, 21:48) Tordanik

Please understand that in OSM there is no "protected" data. If you enter street lights into OSM then others can edit that data. You, the mayor, or others can watch these edits of course but you will not be asked to approve them.

permanent link

answered 20 May '13, 23:13

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
73.5k866651139
accept rate: 24%

There is a OpenData plugin (http://wiki.openstreetmap.org/wiki/JOSM/Plugins/OpenData) for the JOSM editor. It allows one to import CSV-files and can convert from a number of coordinate systems, such as Lambert. But as others wrote, the import of data has to be described on the wiki

permanent link

answered 21 May '13, 05:03

escada's gravatar image

escada
18.8k16159301
accept rate: 20%

2

Because of this, I strongly recommend to coordinate with the french OSM community, who can be reached at http://forum.openstreetmap.org/viewforum.php?id=22 .

(21 May '13, 10:32) gormo

I usually convert csv to OSM format using awk, but you are maybe more happy with this csv2osm script.

hth
malenki

permanent link

answered 20 May '13, 20:45

malenki's gravatar image

malenki
4.7k24683
accept rate: 6%

Thank you malenki for your fast answere.

I use windows and i don't know pearl language, i know GIS software like Quantum Gis, Autocad map 3D. I know xhtml, css and Autoit so you see i'm not really a programmer.

Can you develop me the whole process ?

1 - convert csv to OSM

2 - How to import 855 line in OSM into Openstreetmap ?

Thanks.

(20 May '13, 20:52) gabriel45895

The linked file contains helpful hints in English. As I said I didn't use it myself (it doesn't match my purposes). When you want to run it, you have to install the [perl environment][1] before. Then you can run the script with perl $scriptname.

(21 May '13, 22:28) malenki

After converting you can load the OSM file with QGis or JOSM and check if the data is located and tagged correctly.

Before you upload anything you should have ticked off every point of the Import Guidelines - maybe compare if the English version of the guideline has some more information.

btw: I am less coder then you are. The little HTML I made I just copied. ;)

(21 May '13, 22:28) malenki

Try adding csv in the blank window below Questions and youll find several similar questions and solutions. You even could transfer the inventarisation into a community project and add several participants to tag.

permanent link

answered 20 May '13, 20:49

Hendrikklaas's gravatar image

Hendrikklaas
8.7k182216357
accept rate: 5%

edited 20 May '13, 20:54

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:

×178
×118
×3
×2

question asked: 20 May '13, 20:38

question was seen: 5,297 times

last updated: 21 May '13, 22:28

powered by OSQA