[postgis-users] AsText returns nothing but geometries exist in table

[Ben Madin]

In lieu of an informed answer, logic would suggest the geometry must be in the table (if it is displaying correctly in a GIS application).

Therefore, I would suggest that there may be some aspect of displaying it other than in a GIS application that is the problem.

Are you using pgAdmin to view the table data? What operating system? There is a character limit - the normal limit on postgres rows is 2048 characters. But geometry data are not actually stored in the table, rather they are stored in a TOAST table. I would suggest that you try looking at it in psql (the command line application) or I believe there is a plug-in for pgAdmin that might help display the data there.

Be aware also that if your geometries are large, the rows will be wide, and so displaying them in psql might be somewhat frustrating as you will have a large amount of blank space in the table heading etc.

cheers

Ben



On 18/07/2011, at 8:30 PM, Phil James wrote:

> I have loaded some geometry into a postgis table but although the geometry is there (displays in Quantum and can query with ST_various correctly) it does not appear with AsText() or in the Edit Table view.  The type is MultiPolygon using postgres 9 Postgis 1.5.  Is there some character limit it exceeds?  If so why does the the_geom column appear blank in Edit Table using PGADMIN as well?  I have checked the geometry and it is valid.
> 
> Thanks
> 
> Phil
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101018/2812a916/attachment.html>