[postgis-users] ERROR: Operation on two geometries with different SRIDs

Stefan Schwarzer stefan.schwarzer at unep.org
Mon Nov 7 07:22:17 PST 2011


>> Now, trying to import it with:
>> 
>>        shp2pgsql -s EPSG:26191 -I -D morocco.shp morocco>  morocco.sql
>>        psql -U xxxx my_database<  morocco.sql
> 
> Hi Stefan,
> 
> The SRID argument to shp2pgsql should just be a plain numeric field, and not have the EPSG prefix in front of it, e.g.:
> 
> shp2pgsql -s 26191 -I -D morocco.shp morocco>  morocco.sql
> 
> This should generate you a file with the SRID 26191 which should load without any further issues.

That did the trick! Great. Thanks a lot!!


More information about the postgis-users mailing list