Try including one non-spatial field in the table you dump. P
On Thu, Nov 27, 2008 at 11:33 AM, Travis Kirstine <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
