Hi Uwe, SRID is to be changed fro SRID=0 for any shape file I try to save as PostGIS table. SRID=3000 works.
Changing SRID from Zero to 3000 has not effectet it's geo-referrence. Both files when opened sit exactly on one another. This is happenning only from the time I reloaded Postgres and PostGIS in Vista. I solved by, 1. Turning UCA off 2. Creating an account for administrator. In fact I was struck for a few days in this before I stumbled on changing SRID from Zero to 3000. Cheers Ravi Kumar --- On Mon, 2/9/09, Uwe Dalluege <[email protected]> wrote: > From: Uwe Dalluege <[email protected]> > Subject: Re: [jump-users] SRID Puzle > To: [email protected] > Cc: [email protected] > Date: Monday, February 9, 2009, 5:46 PM > 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
