Hi Jukka,
please can you send me a sql-file from your table?
With pgAdminIII you can make a backup of the table:
1. RightClick on the table
2. Choose a file-name
3. Choose: Plain, Insert commands, Create DB
Maybe I can read this sql-file
Rahkonen Jukka schrieb:
Hi Uwe,
I am in a happy situation in having a brand new and controlled environment and
data so I can well answer your question.
PostgreSQL is installed from Windows installer postgresql-8.2.4-1.zip
PostGIS comes from postgis-pg82-setup-1.3.2-1.exe
The data is OpenStreetMap data loaded into PostGIS with a osm2pgsql utility
that is still under development. I will ask the author if I can send the
executable for you. In that case you could very simply install the same data
for you by downloading OSM data dump from hypercube.telasciense.org and running
osm2pgsql.
The error comes if I try to read those OSM data layers with PostGIS-PlugIn. OpenJUMP
reads the same tables fine with its own "Open Datastore Layer" function. And
If I create new layers in OpenJUMP I can store them into PostGIS with PostGIS-PlugIn, and
those tables I can also read with the PlugIn.
I will let you hear if I can send the development version of osm2pgslq for
Windows for you. In any case it will be available soon for everybody and it
makes the use of OSM data through PostGIS extremely easy.
Regards,
-Jukka-
-----Alkuperäinen viesti-----
Lähettäjä: [EMAIL PROTECTED] puolesta: Uwe Dalluege
Lähetetty: pe 11.1.2008 9:00
Vastaanottaja: JUMP Users Discussion
Aihe: Re: [jump-users] Newbie's experience on OpenJUMP and PostGIS
Hi Rahkonen,
please tell me what do you do to reveive this error-message
with the PostGIS-Plugin?
It is not clear whether you use OpenJUMP with the
PostGIS-PlugIn or JUMP???
Which version of PostgreSQL/PostGIS do you use?
Rahkonen Jukka schrieb:
Hi,
...
PostGIS with SRID Plugin
The installation of this plugin went OK. However, I wonder why the Postgres
driver must be copied into the Java directory instead of OpenJUMP lib or
/lib/ext. Actually in the OpenJUMP installed from nightly build there seems to
be newer Postres driver in /lib folder. Not a brand new that either. I wonder
if I still need to copy that old driver into Java directory. In our managed
environment I could not even do that by myself but I had to bother
administrators.
Strange thing with this plugin was that I managed to store new layers made with
JUMP into new tables in PostGIS and read those self made tables back. However,
I could not read the existing tables but got error messages like this:
java.lang.IllegalStateException: ERROR: syntax error at or near ","
at
net.refractions.postgis.PostGISConnection.executeQuery(PostGISConnection.java:274)
at
net.refractions.postgis.PostGISConnection.executeQuery(PostGISConnection.java:1169)
at
org.openjump.core.ui.plugin.file.DataSourceQueryChooserOpenWizard.run(DataSourceQueryChooserOpenWizard.java:84)
at
org.openjump.core.ui.plugin.file.OpenWizardPlugIn.run(OpenWizardPlugIn.java:93)
at
com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:149)
at java.lang.Thread.run(Unknown Source)
...
Regards,
-Jukka Rahkonen-
Regards
Uwe
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
--
Regards
Uwe Dalluege
--------------------------------------------------------------------------
HafenCity Universitaet Hamburg
Department Geomatik
Rechenzentrum
Dipl.-Ing. Uwe Dalluege :-)
Hebebrandstr. 1
22297 Hamburg
Tel.: +49 40 42827 - 5335 oder 5353 oder 5313
Fax: +49 40 42827 - 5409
E-Mail: mailto:[EMAIL PROTECTED]
Url: http://www.hcu-hamburg.de/geomatik/
--------------------------------------------------------------------------
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
