I'm having some problems with shapefiles dumped out of postgis using the pgsql2shp utility. I am creating a geometry union using the upgis_cascadeunion function then exploding the multi features to single part features
CREATE TABLE omnr_glcbp_geomunion AS SELECT upgis_cascadeunion(the_geom) as the_geom from omnr_glcbp_watersheds; CREATE TABLE omnr_glcbp_boundary AS SELECT ST_GeometryN(the_geom, generate_series(1, ST_NumGeometries(the_geom))) AS the_geom FROM omnr_glcbp_geomunion ; I then checked that that the geometry was valid and a multipolygon and everything looks fine. When the data is dumped to a shp file I get a error when opening the file with arcgis "Number of shapes does not match number of table records". Also when I check the shapefile with ogrinfo it does not report the geometry (returns Unknown). I thought that upgis_cascadeunion might be causing the problem however I had the same results when using the ST_Buffer(Collect(the_geom), 0) to dissolve the polygons. -- Travis K. Toronto, Canada ------------------------------------------------------------ "She knows there's no success like failure And that failure's no success at all." -Bob Dylan- ------------------------------------------------------------ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
