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: [email protected] [mailto:[email protected]] On Behalf Of tommy408 Sent: Thursday, June 25, 2009 9:39 AM To: [email protected] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
