Re: [jump-users] SRID Puzle

Uwe Dalluege Mon, 09 Feb 2009 04:18:53 -0800

Hi Ravi,

please have a look at the
PostGIS table geometry_columns and
check the srid-value together
with the table-name.
Maybe there is something wrong with this table.
Please check whether the table-name is twice
in geometry_columns.


Can you save your layer with another name?

Regards

Uwe


RAVI KUMAR schrieb:

Hi Uwe,
1. jump_postgis_plugin_srid_v1.2.1 --> this is the version of plugin downloaded 
on 17-11-2008. I checked that the latest download on date has the same number 
v1.2.1.

2. The postgis table saved earlier with SRID=3000 retains it when opened afresh in Oj.

Cheers

Ravi Kumar

From: Uwe Dalluege <[email protected]>
Subject: Re: [jump-users] SRID Puzle
To: [email protected], "JUMP Users Discussion" 
<[email protected]>
Date: Monday, February 9, 2009, 12:14 PM
Hi Ravi,

1. Do you use the PostGIS-Plugin V6.11.6B ?

2. Is it possible, that the table already exists
in PostGIS?

If this table already exists please load it to
OJ and have a look to the SRID-Value.

Regards

Uwe

RAVI KUMAR schrieb:

Hi,
using OJ on Vista.
1. getting the error below when I try to save a file

in PostGIS.

java.lang.IllegalStateException: AddGeometryColumn

statement failed: org.postgresql.util.PSQLException: ERROR:
AddGeometryColumns() - invalid SRID

SELECT AddGeometryColumn( 'postgis',

'lithologysrid100', 'geometry', 100,
'GEOMETRY', 2 )

at

net.refractions.postgis.PostGISConnection.executeUpdate(PostGISConnection.java:779)

at

net.refractions.postgis.PostGISConnection.executeUpdate(PostGISConnection.java:1185)

at

com.vividsolutions.jump.workbench.datasource.AbstractSaveDatasetAsPlugIn.run(AbstractSaveDatasetAsPlugIn.java:33)

at

com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:149)

        at java.lang.Thread.run(Unknown Source)
2. How ever the same is saved when I change SRID
Layer -> Change SRID Plugin -> SRID=3000 (this I

arrived at by chance)

SRID= 0 or SRID=100, give the above error.

3. I wish not to project the layer at all..
   I can save layer as ESRI Shape file but not as

PostGIS data.

Cheers

Ravi


      _______________________________________________
jump-users mailing list
[email protected]

http://lists.refractions.net/mailman/listinfo/jump-users

_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users

Re: [jump-users] SRID Puzle

Reply via email to