Points and Polygons table

[tommy408]

I imported some points from a shapefile to a PostGIS table.  But I can't insert polygons into the same table because of the constaint below.  Should I store points in a separate table from polygons or put them together in one table and remove the following constaint?

enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL)

[Paragon Corporation-2]

Its preferable to store them in a different table.  It really depends what
you are planning to do with these.  I would suggest though that since you
are new to PostGIS it would be best to stick with the standard conventions
of different geometry types/srids in different tables.  You can mix them
together, but there are caveats involved if you want to ever display these
in Desktop apps or using web mapping servers/feature servers if you go down
that road.

Leo

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of tommy408
Sent: Thursday, June 25, 2009 9:39 AM
To: postgis-users@...
Subject: [postgis-users] Points and Polygons table


I imported some points from a shapefile to a PostGIS table.  But I can't
insert polygons into the same table because of the constaint below.  Should
I store points in a different table from polygons or put them together in
one table and remove the following constaint?

enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL)
--
View this message in context:
http://www.nabble.com/Points-and-Polygons-table-tp24203451p24203451.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users