[postgis-users] Geometry appears empty

[Tim Bowden]

Geoff,

This earlier thread may be of interest:
http://postgis.refractions.net/pipermail/postgis-users/2008-March/018814.html

It deals with limitations of pgadmin and postgis.

If the geometries really are null, are you also able to try loading the
data with ogr2ogr to see if you get the same result?   Are you sure you
don't have any invalid geometries?  I don't know how FME handles these.

HTH,
Tim Bowden
On Tue, 2008-07-01 at 17:12 -0700, geoffi wrote:
> I have translated some polygon data into a PostGIS table using FME. The
> translation was successful with no errors reported. All the records appear
> in the PostGIS table (using the pgAdminIII application) except for about 90%
> of the geometries (see image below).
> 
> http://www.nabble.com/file/p18227858/table.jpg 
> 
> However, using the FME Universal Viewer all records are displayed with their
> correct geometry as I would expect.
> 
> What is causing the Geometry column in the table to appear empty?
> Is there a setting in PostGIS to force the data to be visible in the
> pgAdminIII application?
> 
> Attempts to generate a WMS from this table using GeoServer only displays
> those records that appear to have geometry.
> 
> Performing a similar exercise using point geometries, there was no problem.
> 
-- 
vim is a good example of an IDE done properly.  emacs is an example of
an IDE done poorly.  Anything that involves little pictures is a
mis-umderstanding of what an IDE should be.