Re: [JPP-Devel] Error while running osm plugin & PostGis PLugin

Rahkonen Jukka Sat, 23 Nov 2013 00:33:00 -0800

Hi,

You must be rather close now. You must be using the "Run database query" tool 
(you could have mentioned it btw).
You must insert a valid SQL query into the box. Use simple queries before you 
understand what the extra buttons do. Use this first:

select * from osm_points limit 10000

Now you should get something into your map.

A valid query which includes the BBOX from the View button looks like this

select * from osm_point
where highway is not null
and way && ${view:4326}

Pay attention to the parameter in ${view:4326}. It is the SRID of your OpenJUMP
project. If you are relatively new to databases and SQL it may be better to
test the SQL queries with psql console or PgAdmin utility first because those
utilities give you more detailed error messages. When you have verified your
query (use AND limit=100 when testing) you can insert it into OpenJUMP's Run
datastore query box.

And please, try to make answering easy also in the future. You could have said
from the very beginning that you want to query OpenStreetMap data with Run
datastore query tool. Have you user osm2pgsql for importing data into PostGIS?
I supposed so but if you have used some other tool then my query example above
will not work for you.

-Jukka Rahkonen-

________________________________
Lähettäjä: sukhjit sehra [sukhjitse...@gmail.com]
Lähetetty: 23. marraskuuta 2013 6:34
Vastaanottaja: OpenJump develop and use
Aihe: Re: [JPP-Devel] Error while running osm plugin & PostGis PLugin

I am connecting it with postgresql and trying to run query $view after
connecting but got error. i am trying to import OpenStreetMap data from the
database.

java.lang.Error: Error : ST_GeomFromText('POLYGON ((0 0, 0 348, 460 348, 460 0,
0 0))',0)
ERROR: syntax error at or near "ST_GeomFromText"
Position: 1
at
com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeatureSchema(PostgisFeatureInputStream.java:95)
at
com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.executeAdhocQuery(PostgisDSConnection.java:80)
at
com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.execute(PostgisDSConnection.java:49)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayer(RunDatastoreQueryPlugIn.java:78)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayerable(RunDatastoreQueryPlugIn.java:47)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLayerPlugIn.run(AbstractAddDatastoreLayerPlugIn.java:33)
at
com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:152)
at java.lang.Thread.run(Thread.java:724)

Please help me out. i

On Fri, Nov 22, 2013 at 1:10 PM, Michaël Michaud
<michael.mich...@free.fr<mailto:michael.mich...@free.fr>> wrote:
Hi sukhjit
- What is your operating system?
tried on linux unbutu 13.04
- Your java version?
openjdk
- What have you installed - OpenJUMP version, what plugin version, from where
did you get it?
from sourceforge website
- What is the problem? Making connection to PostGIS, finding the tables,
reading the data, what?
i have installed the postgis plugin but unable to find postgis linkage or it
may be possible i may not be fully educated to use the plugin.
Which plugin did you install? Most PostGIS capabilities are included
in CORE and PLUS version of OpenJUMP without need to add external plugins.
To read a PostGIS table from OpenJUMP, you need to choose
- File > Open... (choose "Data Store Layer")
or
- File > Run DataStore Query...
please see also documentation. You have a short tutorial here :
https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=Working_with_Databases
and here is a video (a bit old, some menu items have moved)
http://www.pgcon.org/2009/schedule/events/174.en.html

Michaël

- Did you try with version 1.6 or later? If not, why?
>OpenJUMP-1.6.3-rev.3576-CORE-1380520973142

still i will re install everything and do it again.

Thanks
Regards,

-Jukka Rahkonen-

sukhjit
wrote:
Any body could help me in resolving the issues with OSM and Postgis plugin in
Openjump

thanks

--
Er. Sukhjit Singh Sehra

------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net<mailto:Jump-pilot-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

--
Er. Sukhjit Singh Sehra
Assistant Professor
Dept of Computer Science Engg.
Guru Nanak Dev Engineering College, Ludhiana, Punjab
Mobile No:- 09855959200
*In your free time kindly visit Sikh-relics.com - A Gallery of Blessed Relics
of Sikh Guru Sahib

_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net<mailto:Jump-pilot-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] Error while running osm plugin & PostGis PLugin

Reply via email to