[postgis-users] transform - update lakesetthe_geom=transform(the_geom, 26971)

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
cyw at dls.net
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" <nicky666 at gmail.com>
To: "PostGIS Users Discussion" <postgis-users at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


_______________________________________________
postgis-users mailing list
postgis-users at 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.