Coordinates In Map Mashup Display In Wrong Locations

[ShannonB]

I am using the map mash up to display the locations of different ports using there coordinates but the markers are showing the wrong locations. For example, Houston in american is 95.02 W 29.61 N but the marker is being placed in the middle of China?

 

Any suggestions would help

 

Thanks,

Shannon

[VAP1]

Hi Shannon,

 

I think the issue is that you are using DMS (degrees, minutes, seconds) when you should be using decimal degrees (latitude and longitude).  The Caspio Google Maps mashup uses Latitude and longitude: 

 

http://howto.caspio.com/extensions/map-mashup/map-mashup-guide/

 

 

You can play around with the following website to get an idea of this: http://www.gps-coordinates.net/

If you plug in 29.61 as Latitude and 95.02 as Longitude it will take you to china. If you plug the same numbers in as DMS, it will take you to Houston.

 

If you only have a few locations you need to convert to latitude and longitude you can do it manually on the above website or in google maps.  If not you can use an opensource GIS program like QGIS to convert a large table of locations.

 

hope that helps.

[ChrisCarlson]

Also check if negative or positive coordinates, this will land a US address in China if incorrect.

[ChrisCarlson]

I checked for Houston and your first coordinate (longitude) should have a negative in front.

[NailDyanC]

Hi, also just to add an additional information, Google now restricts the rate which non-geocoded addresses can be plotted on a map (approximately 10 addresses per second). And, Google API key needs to have a billing enabled (though you will not be charged) to fully access the Geocoding API that you will place in the map. You also need to enable this two:

1. Geocoding API 

2. Maps Javascript API