[GIS] Storing SRID:4326 data as Geometry or Geography

qgissql serversql-server-spatialsrid

I used OGR2OGR to import SRID 4326 point data into MSSQL Server. Didn't realize that it defaults to creating a geometry column instead of detecting the data as 4326 and creating a geography column. I know the code to get around this so no issue there.

The data as is in a geometry column shows up just fine in QGIS. So do I actually need to put the data in a geography column?

thanks!

Best Answer

If you do not need to measure distances over the spheroid then geometry suits well. The PostGIS manual contains understandable info about this http://postgis.net/docs/manual-2.0/using_postgis_dbmanagement.html#PostGIS_Geography and it is valid also for MSSQL.

Related Solutions

[GIS] How to get a country border data set into the geography column

Check geometry_columns table: Does it contain a line for "world" table with SRID = 4326? If not, add/edit it. (The shapefile from thematicmapping.org seems to be in 4326.)

Also, looks like the conversion from geometry to geography is missing:

"the_geom"::geography

[GIS] Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type

From @Jakub Kania tip :

ALTER TABLE routes ADD temp geometry;
select UpdateGeometrySRID('public', 'routes', 'temp', 4326) ;
update routes set temp = ST_Transform(the_geom,4326);
select UpdateGeometrySRID('public', 'routes', 'the_geom', 4326) ;
update routes set the_geom = temp;
alter table routes drop column temp;

Best Answer

Related Solutions

[GIS] How to get a country border data set into the geography column

[GIS] Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type

Related Question