Marko, Can't think of why number of points would make a difference if it showed up before. That could mean a bug of some sort in newer PostGIS in which case, it would be great to get a bug report with an attachment of the offending table. Before that though - lets rule out some non-bug possibilities. When you restored -- did you restore to a new version of PostGIS or same version and which version of PostGIS are you running now and before? One common possibility is that the spatial_ref_sys record is not registered for the srid of this table. Since QGIS/FME are srid aware, they might not be showing it because its off in la la land to them. What often causes this behavior is if you restored on top of a new PostGIS template database any custom records that were added/modified to spatial_ref_sys may be lost. To rule this out 1) What is the srid of this table and verify it exists in spatial_ref_sys 2) If it does exist, do a SELECT proj4text from spatial_ref_sys where srid = srid_here on both the old working database and the new database and verify they return the same answer. If that isn't the issue To rule point out, you can dump the data into a new table and simplify it to reduce number of points http://www.postgis.org/documentation/manual-svn/ST_SimplifyPreserveTopology. html SELECT gid, ST_SimplifyPreserveTopology(the_geom, 1000) As the_geom INTO newtable FROM badtable The 1000 is in units of spatial coordinate (so if your data is in long lat use something like 0.01 or something instead) The count of your points in your new table should then be much lower. If that still doesn't display then not a number of points issue. Either way if its a number of points or some other issue, would be nice to get a bug report. http://trac.osgeo.org/postgis/newticket which you will need an osgeo account -- http://www.osgeo.org/osgeo_userid if you don't have one already. Thanks, Regina and Leo http://www.postgis.us
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Marko Cubranic Sent: Monday, April 26, 2010 3:16 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] restore database Leo and Regina, I have verified my table , and table contanis one object geometry (about 40 000 points). Maybe the problem is in too large object. Marko 2010/4/23 Paragon Corporation <[email protected]> Marko, Not sure off hand what could be wrong here. Did you verify the table you can't visualize has data? Its possible the data didn't load or didn't get backed up because it had a very invalid geometry in it like a polygon with two few points. This issue was fixed in PostGIS 1.4.2 and PostGIS 1.5.1. Before it was possible that you could create a record in PostGIS that was clearly invalid and you would no longer be able to export it out or reimport it. We are guessing that might be the issue here. Leo and Regina http://www.postgis.us _____ From: [email protected] [mailto:[email protected]] On Behalf Of Marko Cubranic Sent: Friday, April 23, 2010 3:27 AM To: [email protected] Subject: [postgis-users] restore database Dear, i have made backup of spatial database and after i v restored it i couldn't visualize one geometry table in Qgis, uDIG,FME-viewer.Before i did backup of database i could visualize all data. I did backup and restore on same computer with PostgreSQL 8.3 installed. Database consists of 7 geometry tables, which 2 of geometry tables are loaded from shapefile, and one of those two cannot be visualized after backup and restore. So if anyone can help, thank you. -- Marko Čubranić _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users -- Marko Čubranić
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
