I'm a total beginner with PostGIS, and trying to create a database with the geonames dataset.
Their table has latitude and longtitude coordinates:
latitude : latitude in decimal degrees (wgs84)
longitude : longitude in decimal degrees (wgs84)
Since the data is global and in WGS84, I've used the type:
geography(point,4326), and inserted it using
However, I get a lot of warnings:
NOTICE: Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY
Did I use the wrong type?