Import information from OpenStreetMap

sanax
Topic Author
Offline
Senior Member

4 years 4 months ago - 4 years 4 months ago #13648 by sanax

Import information from OpenStreetMap was created 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: 4 years 4 months ago by sanax.

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

Dima
Offline
Platinum Member

4 years 4 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

4 years 4 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.

Dima
Offline
Platinum Member

4 years 4 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!

insert into `demo2_zhgooglemaps_maps` (
`id`,
`catid`,
`title`,
`width`,
`height`,
`latitude`,
`longitude`,
`zoom`,
`minzoom`,
`maxzoom`,
`draggable`,
`doubleclickzoom`,
`scrollwheelzoom`,
`zoomcontrol`,
`scalecontrol`,
`maptype`,
`maptypecontrol`,
`balloon`,
`openballoon`,
`posmaptype`,
`poszoom`,
`posscale`,
`description`,
`markermanager`,
`published`,
`markercluster`,
`markerclustergroup`,
`clusterzoom`,
`kmllayer`,
`markergroupcontrol`,
`markergrouptype`,
`markergroupwidth`,
`markergroupshowicon`,
`markergroupshowiconall`,
`markergroupcss`,
`markergroupdesc1`,
`markergroupdesc2`,
`markergrouptitle`,
`markergroupsep1`,
`markergroupsep2`,
`markergrouporder`,
`markergroupsearch`,
`markerlist`,
`markerlistpos`,
`markerlistwidth`,
`markerlistheight`,
`markerlistbgcolor`,
`markerlistaction`,
`markerlistcontent`,
`markerlistbuttonpos`,
`markerlistbuttontype`,
`markerlistsearch`,
`markerlistsync`,
`headerhtml`,
`footerhtml`,
`headersep`,
`footersep`,
`openstreet`,
`opentopomap`,
`nztopomaps`,
`usercontact`,
`useruser`,
`usermarkers`,
`usermarkersfilter`,
`usermarkerspublished`,
`usermarkersicon`,
`usercontactpublished`,
`usermarkersinsert`,
`usermarkersupdate`,
`usermarkersdelete`,
`routedraggable`,
`routeshowpanel`,
`autoposition`,
`geolocationcontrol`,
`geolocationpos`,
`geolocationbutton`,
`lang`,
`custommaptype`,
`custommaptypelist`,
`usercontactattributes`,
`css2load`,
`js2load`,
`cssclassname`,
`mapbounds`,
`routedriving`,
`routewalking`,
`routebicycling`,
`routetransit`,
`routeavoidhighways`,
`routeavoidtolls`,
`routeunitsystem`,
`useajax`,
`useajaxobject`,
`markergroupctlmarker`,
`markergroupctlpath`,
`placemark_rating`,
`hovermarker`,
`hoverinfobubble`,
`disableautopan`,
`ajaxbufferplacemark`,
`ajaxbufferpath`,
`ajaxbufferroute`,
`ajaxgetplacemark`,
`mapcentercontrol`,
`mapcentercontrolpos`,
`markerorder`,
`markerspinner`,
`showcreateinfo`,
`override_id`,
`panelinfowin`,
`panelwidth`,
`panelstate`,
`overlayopacitycontrol`,
`overlayopacitycontrolpos`,
`gogoogle`,
`gogoogle_map`,
`auto_center_zoom`,
`closepopuponclick`,
`params`,
`placestypeac`,
`placestype`,
`routeaddress`,
`mapstyles`
)
select
`id`,
`catid`,
`title`,
`width`,
`height`,
`latitude`,
`longitude`,
`zoom`,
`minzoom`,
`maxzoom`,
`draggable`,
`doubleclickzoom`,
`scrollwheelzoom`,
`zoomcontrol`,
`scalecontrol`,
`maptype`,
`maptypecontrol`,
`balloon`,
`openballoon`,
`posmaptype`,
`poszoom`,
`posscale`,
`description`,
`markermanager`,
`published`,
`markercluster`,
`markerclustergroup`,
`clusterzoom`,
`kmllayer`,
`markergroupcontrol`,
`markergrouptype`,
`markergroupwidth`,
`markergroupshowicon`,
`markergroupshowiconall`,
`markergroupcss`,
`markergroupdesc1`,
`markergroupdesc2`,
`markergrouptitle`,
`markergroupsep1`,
`markergroupsep2`,
`markergrouporder`,
`markergroupsearch`,
`markerlist`,
`markerlistpos`,
`markerlistwidth`,
`markerlistheight`,
`markerlistbgcolor`,
`markerlistaction`,
`markerlistcontent`,
`markerlistbuttonpos`,
`markerlistbuttontype`,
`markerlistsearch`,
`markerlistsync`,
`headerhtml`,
`footerhtml`,
`headersep`,
`footersep`,
`openstreet`,
`opentopomap`,
`nztopomaps`,
`usercontact`,
`useruser`,
`usermarkers`,
`usermarkersfilter`,
`usermarkerspublished`,
`usermarkersicon`,
`usercontactpublished`,
`usermarkersinsert`,
`usermarkersupdate`,
`usermarkersdelete`,
`routedraggable`,
`routeshowpanel`,
`autoposition`,
`geolocationcontrol`,
`geolocationpos`,
`geolocationbutton`,
`lang`,
`custommaptype`,
`custommaptypelist`,
`usercontactattributes`,
`css2load`,
`js2load`,
`cssclassname`,
`mapbounds`,
`routedriving`,
`routewalking`,
`routebicycling`,
`routetransit`,
`routeavoidhighways`,
`routeavoidtolls`,
`routeunitsystem`,
`useajax`,
`useajaxobject`,
`markergroupctlmarker`,
`markergroupctlpath`,
`placemark_rating`,
`hovermarker`,
`hoverinfobubble`,
`disableautopan`,
`ajaxbufferplacemark`,
`ajaxbufferpath`,
`ajaxbufferroute`,
`ajaxgetplacemark`,
`mapcentercontrol`,
`mapcentercontrolpos`,
`markerorder`,
`markerspinner`,
`showcreateinfo`,
`override_id`,
`panelinfowin`,
`panelwidth`,
`panelstate`,
`overlayopacitycontrol`,
`overlayopacitycontrolpos`,
`gogoogle`,
`gogoogle_map`,
`auto_center_zoom`,
`closepopuponclick`,
`params`,
'',
'',
'',
''
from `demo_zhosmmaps_maps`
;

Lets import placemarks

Warning: Spoiler!

SET sql_mode = 'NO_ZERO_DATE';

insert into `demo2_zhgooglemaps_markers` (
`id`,
`catid`,
`title`,
`latitude`,
`longitude`,
`addresstext`,
`mapid`,
`openbaloon`,
`actionbyclick`,
`zoombyclick`,
`baloon`,
`icontype`,
`iconofsetx`,
`iconofsety`,
`description`,
`descriptionhtml`,
`descriptionfullhtml`,
`hoverhtml`,
`published`,
`hrefsite`,
`hrefimage`,
`hrefimagethumbnail`,
`hrefsitename`,
`markergroup`,
`markercontent`,
`contactid`,
`createdbyuser`,
`showcontact`,
`showuser`,
`publish_up`,
`publish_down`,
`createddate`,
`userprotection`,
`params`,
`attribute1`,
`attribute2`,
`attribute3`,
`attribute4`,
`attribute5`,
`attribute6`,
`attribute7`,
`attribute8`,
`attribute9`,
`tabid`,
`tab1`,
`tab2`,
`tab3`,
`tab4`,
`tab5`,
`tab6`,
`tab7`,
`tab8`,
`tab9`,
`tab10`,
`tab11`,
`tab12`,
`tab13`,
`tab14`,
`tab15`,
`tab16`,
`tab17`,
`tab18`,
`tab19`,
`tab1title`,
`tab2title`,
`tab3title`,
`tab4title`,
`tab5title`,
`tab6title`,
`tab7title`,
`tab8title`,
`tab9title`,
`tab10title`,
`tab11title`,
`tab12title`,
`tab13title`,
`tab14title`,
`tab15title`,
`tab16title`,
`tab17title`,
`tab18title`,
`tab19title`,
`tab1image`,
`tab2image`,
`tab3image`,
`tab4image`,
`tab5image`,
`tab6image`,
`tab7image`,
`tab8image`,
`tab9image`,
`tab10image`,
`tab11image`,
`tab12image`,
`tab13image`,
`tab14image`,
`tab15image`,
`tab16image`,
`tab17image`,
`tab18image`,
`tab19image`,
`tab_info`,
`ordering`,
`rating_value`,
`rating_count`,
`labelanchorx`,
`labelanchory`,
`labelclass`,
`labelcontent`,
`includeinlist`,
`access`,
`alias`,
`hrefcontact`,
`hrefarticle`,
`hrefdetail`,
`toolbarcontact`,
`toolbararticle`,
`toolbardetail`,
`articleid`,
`attributesdetail`,
`userorder`,
`showgps`,
`iframearticleclass`,
`gogoogle`,
`preparecontent`,
`tag_show`,
`tag_style`
)
select
`id`,
`catid`,
`title`,
`latitude`,
`longitude`,
`addresstext`,
`mapid`,
`openbaloon`,
`actionbyclick`,
`zoombyclick`,
`baloon`,
`icontype`,
`iconofsetx`,
`iconofsety`,
`description`,
`descriptionhtml`,
`descriptionfullhtml`,
`hoverhtml`,
`published`,
`hrefsite`,
`hrefimage`,
`hrefimagethumbnail`,
`hrefsitename`,
`markergroup`,
`markercontent`,
`contactid`,
`createdbyuser`,
`showcontact`,
`showuser`,
`publish_up`,
`publish_down`,
`createddate`,
`userprotection`,
`params`,
`attribute1`,
`attribute2`,
`attribute3`,
`attribute4`,
`attribute5`,
`attribute6`,
`attribute7`,
`attribute8`,
`attribute9`,
`tabid`,
`tab1`,
`tab2`,
`tab3`,
`tab4`,
`tab5`,
`tab6`,
`tab7`,
`tab8`,
`tab9`,
`tab10`,
`tab11`,
`tab12`,
`tab13`,
`tab14`,
`tab15`,
`tab16`,
`tab17`,
`tab18`,
`tab19`,
`tab1title`,
`tab2title`,
`tab3title`,
`tab4title`,
`tab5title`,
`tab6title`,
`tab7title`,
`tab8title`,
`tab9title`,
`tab10title`,
`tab11title`,
`tab12title`,
`tab13title`,
`tab14title`,
`tab15title`,
`tab16title`,
`tab17title`,
`tab18title`,
`tab19title`,
`tab1image`,
`tab2image`,
`tab3image`,
`tab4image`,
`tab5image`,
`tab6image`,
`tab7image`,
`tab8image`,
`tab9image`,
`tab10image`,
`tab11image`,
`tab12image`,
`tab13image`,
`tab14image`,
`tab15image`,
`tab16image`,
`tab17image`,
`tab18image`,
`tab19image`,
`tab_info`,
`ordering`,
`rating_value`,
`rating_count`,
`labelanchorx`,
`labelanchory`,
`labelclass`,
`labelcontent`,
`includeinlist`,
`access`,
`alias`,
`hrefcontact`,
`hrefarticle`,
`hrefdetail`,
`toolbarcontact`,
`toolbararticle`,
`toolbardetail`,
`articleid`,
`attributesdetail`,
`userorder`,
`showgps`,
`iframearticleclass`,
`gogoogle`,
`preparecontent`,
`tag_show`,
`tag_style`
from `demo_zhosmmaps_markers`
;

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