Import information from OpenStreetMap

  • sanax
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 8 months ago - 3 years 8 months ago #13648 by sanax
Hi Dima

I did some research but I couldn't find an answer and I believe it has been asked before.

How can I import all the maps, placemarks, groups eic. from openstreetmap to google map. I assume it has to be with the database but i would like some documentation on how to do it.

TIA
Last edit: 3 years 8 months ago by sanax.

Please Log in or Create an account to join the conversation.

More
3 years 8 months ago #13651 by Dima
Replied by Dima on topic Import information from OpenStreetMap
Hi.
Today you can't import into Zh GoogleMap from Zh OpenStreetMap by component admin part.

But if you have some knowledge of SQL and access to database, I can explain. Just tell me.

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

  • sanax
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 8 months ago #13658 by sanax
Replied by sanax on topic Import information from OpenStreetMap
Thank you, Dima

Yes, I have access to myphp in my cPanel

I will appreciate the help.

Please Log in or Create an account to join the conversation.

More
3 years 8 months ago #13661 by Dima
Replied by Dima on topic Import information from OpenStreetMap
Hi.
I got current columns for Zh GoogleMap, and create 2 files to upload maps and markers.

The Zh OpenStreetMap extension was created based on Zh GoogleMap extension. Therefore most of columns are the same.
But it can contain different values (for example for control positions)

After you upload your data, you need to fix problems - categories have different IDs for different extension.
You just need to write UPDATE clause and change "old" category ID from OSM, to "new" category for Google.
The field is catid

I hope your Zh GoogleMaps tables is empty (ie you haven't any data in extension)

In my scripts I created google tables with prefix demo2, and OSM tables have prefix demo,
But in your real tables there is the same prefix

Lets import maps

Warning: Spoiler!


Lets import placemarks
Warning: Spoiler!


I did it in phpMyAdmin SQL window

After you complete - fix categories.
Probably some action you need to do, just tell me and I'll check.

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

  • sanax
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 8 months ago #13663 by sanax
Replied by sanax on topic Import information from OpenStreetMap
Thank you, Dima!

I will run a few tests and report back!

Please Log in or Create an account to join the conversation.

Time to create page: 0.096 seconds

Donate


Go to top