I am trying to setup a GIS system to use PostGIS and Geoserver. I have loaded all of the data into a table. The data that is received has long/lat coordinates in Degrees, Minutes, Seconds, Direction, each of which is a separate column. What I did is created a column (location) of type geography and I'm trying to give proper info for each record. The command that I am using is this (of course this is only in the Western Hemisphere):
UPDATE *tablename* SET location = ST_SetSRID(ST_MakePoint((lat_degrees+(lat_minutes+lat_seconds/60)/60), (-1*(long_degrees+(long_minutes+long_seconds/60)/60))), 4326);
My DMS -> DD conversions should be correct, and I've verified that by creating separate columns to test each individually. But the problem is, my geoserver doesn't detect the proper bounds. When I manually set the bounds (I set them to -180,-180,180,180) and check my data in Google Earth, it only zooms to 0,0 and I can find some horribly warped data, in Antarctica.
One thing to note... not all of my records include location data, could that be an issue? Or is ST_MakePoint simply not creating the right location for my data?
Thanks for the help!