Mar 23, 2008
Generic-user-small Bill Parrill 2 posts

Topic: Pragmatic GIS / Manipulating Data: us_states to us_50

I’m on chapter 5.9 and have reached the point where I’m supposed to create the multipolygons. However, when I run the select statement, I get an error:

g4wd=# select name, GeomUnion(the_geom) as location into us_50 from us_states group by name; ERROR: Operation on mixed SRID geometries

Any ideas what’s going on? Thanks! I’m using PostgreSQL 8.3.1.

 
Mar 23, 2008
Generic-user-small Bill Parrill 2 posts

Topic: Pragmatic GIS / shp2pgsql troubles

I had a similar problem using the Windows compiled version. I had to copy libiconv2.dll to libiconv-2.dll in order for it to work properly.

2 posts