PROTECTED] puolesta: Luiz
> Gustavo Ribeiro Pagani
> Lähetetty: ti 22.4.2008 5:05
> Vastaanottaja: jump-pilot-devel@lists.sourceforge.net
> Aihe: [JPP-Devel] Datastore query - Error: Unknown WKB type
>
> Hi,
>
> I load some ESRI Shapes in PostGIS using shp2pgsql loader
Hi,
Try it like "select asbinary(geom),attribute_1,attribute_2 from table".
-Jukka Rahkonen-
-Alkuperäinen viesti-
Lähettäjä: [EMAIL PROTECTED] puolesta: Luiz Gustavo Ribeiro Pagani
Lähetetty: ti 22.4.2008 5:05
Vastaanottaja: jump-pilot-devel@lists.sourceforge.net
Aihe:
Hi,
I load some ESRI Shapes in PostGIS using shp2pgsql loader.
I can successful add and use this tables in OpenJUMP using "Add Datastore
Layer" functionality.
But trying to execute a valid query(select * from table) to load the same
tables, "Run Datastore query" functionality threw this exception
so
where WKB is concerned (adding support for it).
Pedro Doria Meunier
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Sunburned Surveyor
Sent: quinta-feira, 8 de Fevereiro de 2007 15:52
To: List for discussion of JPP development and use.
Subject: [Norton AntiSpam] Re: [JPP-Devel]
15:21
*To:* List for discussion of JPP development and use.
*Subject:* [Norton AntiSpam] Re: [JPP-Devel] Datastore query
Pedro,
I'm guessing from the information that you provided that there is a
problem with the format of your WKT "Point" geometry. Or at least OpenJUMP
think
be correct. :D )
Pedro Doria Meunier
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Sunburned Surveyor
Sent: quarta-feira, 7 de Fevereiro de 2007 15:21
To: List for discussion of JPP development and use.
Subject: [Norton AntiSpam] Re: [JPP-Devel] Datastore query
Pedr
Pedro,
I'm guessing from the information that you provided that there is a problem
with the format of your WKT "Point" geometry. Or at least OpenJUMP thinks
that there is.
Can you check to make sure the WKT geometry your storing is a valid format
and get back to us?
The Sunburned Surveyor
On
Hi group,
Trying to execute a valid query for a valid geom. type (point) fires this
baby:
The query:
select friendly_name, curr_location from units where id=8135;
in the table definition:
CONSTRAINT enforce_point CHECK (geometrytype(curr_location) = 'POINT'::text)
The 'baby':
com.v
