Forgot to mention, we are currently running Postgres 9.0.7 with PostGIS 2.0.2 on Windows.
- John On Thu, Mar 21, 2013 at 2:37 PM, John Callahan <[email protected]>wrote: > I have a few spatial tables that are POLYGON and MULTIPOLYGON as the > geometry type, each with between 1k and 10k features. They only a couple > of attributes and generally look good., and display in QGIS nicely. I also > have a separate (non-spatial) data table (called geodatatable) with about > 50 records that contains numerous attributes and is joined to the polygons > as follows > > CREATE OR REPLACE VIEW public.geomapview AS > SELECT geomap.gid, geomap.unitcode, tab.name, tab.description, > tab.geologicunittype, tab.metadata, geomap.geom > FROM geomap > LEFT JOIN geodatatable tab ON geomap.unitcode::text = > tab.unitcode::text; > > However. when I look at the geometry_columns view, the srid is listed as 0 > and the type is listed as GEOMETRY. Shouldn't they be the same as the > spatial table? Is there a way to manually fix this or something I can > check? Thanks for your help. > > - John > > > John Callahan > Research Scientist > Delaware Geological Survey > University of Delaware > http://www.dgs.udel.edu > [email protected] > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
