CYW, Try OpenJump. Its much easier for doing ad-hoc spatial queries than Quantum when you need to see the geometry.
http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-fo r-PostGIS-Spatial-Ad-Hoc-Queries.html Quantum is nice too, but my experience is that its not as good for Ad-Hoc Queries - but nice when you want to pick a table and so forth from PostGIS and its easier to explain to users scared of SQL. You don't seem to have that timidity :) Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 10, 2008 11:22 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] transform - update lakesetthe_geom=transform(the_geom, 26971) Thanks to all. The problem in my case was that I relied on PgAdmin doing my SQL queries and it does not display certain fields if they are too long. CYW ----- Original Message ----- From: "Nicolas Ribot" <[EMAIL PROTECTED]> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net> Sent: Friday, October 10, 2008 10:00 AM Subject: Re: [postgis-users] transform - update lake setthe_geom=transform(the_geom, 26971) >> I have a table city which contains Multipolygons (SRID=4326) in latitude >> and >> longitude. To project it to a plane coordinate (SRID=26971), I did: >> >> update lake set the_geom=transform(the_geom, 26971); >> >> It ran without any error. But some of the resulted values in the_geom >> column >> became null or empty. >> >> Any hitnts why it did this? >> >> Before the transformation, I viewed the table with QuantumGIS, it looked >> OK. >> Afterwards, QuantumGIS showed nothing. >> > > Hi, > Verify that your input table has longitude-latitude values as X-Y > coordinate, not the contrary. > > Also, if some input data fall outside of the range of acceptable > values for the 26971 projection, these data won't be transformed => > null values. > > Nicolas > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
