[postgis-users] long geometries aren't display on pgAdmin (Windows 7, 64bit)

[Barend Köbben]

Hi,

It's just PgAdmin not displaying properly, there is actually a value in
the geom column. Try  SELECT ST_IsValid(the_geom) or similar and you'll
find the geometry is actually there, only not displayed by pgAdmin.


--
Barend Köbben (Senior Lecturer)
ITC - University of Twente, Faculty of Geo-Information
Science and Earth Observation
PO Box 217, 7500AE Enschede (The Netherlands)
+31-(0)53 4874 253



On 26-05-11 09:41, "toni hernández" <toni at sigte.udg.edu> wrote:

>hi,
>
>I already tried with psql without any luck. ;-(
>
>Let me explain the issue again  with one example.
>When I load a sql, like the one below, on pgAdmin, authomatically the
>geometry disappears from the screen.
>But only when the geometry is 'too' long.
>
>The insert seems to work fine but only for the columns rec_num and
>data_value. The_Geom column is always empty, even when executing the SQL
>file from psql.
>Example:
>
>SET CLIENT_ENCODING TO UTF8;
>SET STANDARD_CONFORMING_STRINGS TO ON;
>BEGIN;
>CREATE TABLE "kirklees" (gid serial PRIMARY KEY,
>"rec_num" numeric,
>"data_value" numeric);
>SELECT AddGeometryColumn('','kirklees','the_geom','-1','MULTIPOLYGON',2);
>INSERT INTO "kirklees" ("rec_num","data_value",the_geom) VALUES
>('1','1','010600000001000000010300000001000000D303000000000000501419410000
>000030941841000000005014194100000000A092184100000000100E194100000000A09218
>4100000000100E1941000000003094184100000000800C1941000000003094184100000000
>800C194100000000C095184100000000100E194100000000C095184100000000100E194100
>0000005097184100000000800C1941000000005097184100000000800C194100000000709A
>184100000000F00A194100000000709A184100000000F00A194100000000009C1841000000
>00D007194100000000009C184100000000D007194100000000909D184100000000B00419
>...
>
>Yves Jacolin wrote:
>> Le jeudi 26 mai 2011 08:28:32, toni hernández a écrit :
>>
>>> Hi,
>>>
>>> I amb holding a postgresql+postgis course on www.unigis.es
>>> Some of our students have experienced some problems when importing shp.
>>> These students are running postgresql 32 bit on a Windows7 64 bit
>>>platform.
>>> I have run the same import with a windows 7, 64bit but haven't
>>> encountered any problems.
>>>
>>> The shp2pgsql seems to be working fine (the output looks good) but when
>>> loading the SQL file from pgAdmin some geometries aren't displayed.
>>> I think the longest geometries (not very long indeed) are the ones that
>>> are not displayed.
>>>
>>> Any ideas about what's happening?
>>>
>>> thanks in advance.
>>>
>>
>> Hi Toni,
>>
>> I am not sure to have understood your issue, but I know that PgAdmin
>>have some
>> difficulties to display values of geometry field. If you check it via
>>psql you'll
>> see that all geometry values are in the table.
>>
>> Y.
>>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users


Faculty of Geo-Information Science and Earth Observation (ITC)
University of Twente
Chamber of Commerce: 501305360000

E-mail disclaimer
The information in this e-mail, including any attachments, is intended for the addressee only. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or action in relation to the content of this information is strictly prohibited. If you have received this e-mail by mistake, please delete the message and any attachment and inform the sender by return e-mail. ITC accepts no liability for any error or omission in the message content or for damage of any kind that may arise as a result of e-mail transmission.