[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] long geometries aren't display on pgAdmin
From:       Barend_Köbben <kobben () itc ! nl>
Date:       2011-05-26 9:56:19
Message-ID: CA03EFFF.7490%kobben () itc ! nl
[Download RAW message or body]

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@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@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. \
_______________________________________________ postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]