[OSM-dev] opensus 11.3 osm2pgsql postgresql nominatim
Hello All, I am still running into this problem. Can anyone shed some light on this: opensuse 11.3 osm2pgsql 0.70.5 from svn nominatim (latest from svn) postgresql 9.0 From the Nominatim folder I execute the following: ./utils/setup.php -all --verbose --osm-file ./test.osm It creates the nominatim database, does all of the loading of data, get the usual NOTICE from osm2pgsql but does not to create the place table. anyone? ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] osm2pgsql revision 25804
Question: I have the latest osm2pgsql code from svn. Compiled it and ran it as following options: -lsc -O gazetteer -C 1 --hstore -j -d nominatim path to osm file I've noticed that this process no longer creates the place table. Is there an option I am missing or file that needs to be updated? Has anyone seen the same issue as I have? Jose ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Rails port and Potlatch2
Hello everyone, Any ideas on how to integrate Potlatch2 into the Rails Port? ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] OSM Stack (Rails Port, Nominatim V1, Potlatch2, mod_tiles, renderd, phusion passenger, apache, postgre) on SUSE
Hello everyone, So far I've been able to do the following: Installation of OSM Rails Port, Nominatim V1, mod_tiles, phusion passenger, and potlatch2. I wanted a self contained enviornment (ie. no external access to resource). As such, I needed to modify in several places hard-coded values: such as pointing to external sources and creation of an OpenLayers OSM Layer to access my tile server (see map.js in rails port). Question is: Is there a version of the Rails Port where all of the hard coded strings/resources are configurable? Also, has anyone integrated Potlatch2 into the Rails Port? jose ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] tiles and OSM rails port
Hello everyone, If anyone is so inclined, could you post onto the OSM wiki a page with the following files: If you have successfully installed OSM rails port, mapnik, mod_tile, and nominatim the following would be helpful to the community: 1. MOD_TILE * The vhost entry to apache * renderd.conf - With some explanation of the URI component in the file as it relates to the OSM rails port (looking to see what changes need to be made to rails port so that it will work with the local renderer -- ie. mod_tile/renderd). - I am also interested in knowing if the XML component in the file is _ONLY_ concerned with the osm.xml file (or osm-local.xml file) and nothing else in the directory where the file is located. - The tile_dir is commented with the following DOES NOT WORK YET. Does the comment still apply? If so, what replaced it? Any other file that needs to be modified to indicate the path -- eg render_config.h 2. OSM Rails Port * What needs to be done ( changes to config files/scripts etc. ) to the rails port so that it would use the local renderer. * What needs to be done to the rails port so that it would use the local NOMINATIM. 3. MAPNIK * I've installed MAPNIK using YAST. When I looked into the SVN tree for mapnik (svn.mapnik.org) I've noticed that there is a www folder. Of what use is that folder? * In the SVN svn.openstreetmap.org there is also a mapnik folder. This folder contains the python scripts for generating the tiles/images. My question is, what modules use the utilities/scripts in this folder? Still navigating my way into the OSM world... jose ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] osmosis
Hello All, I've been trying to import osm files (bz2) into postGres DB using osmosis (version 0.36 - built from svn). The command I used is the following: ./osmosis --read-xml-0.6 file=north_america.osm.bz2 --write-apidb-0.6 populateCurrentTables=yes host=localhost database=openstreetmap user=osm password=osm1 validateSchemaVersion=no The result being the following: SEVERE: Thread for task 1-read-xml-0.6 failed org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to bulk insert nodes into the database. at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.flushNodes(ApidbWriter.java:577) at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1108) at org.openstreetmap.osmosis.core.container.v0_6.NodeContainer.process(NodeContainer.java:58) at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1082) at org.openstreetmap.osmosis.xml.v0_6.impl.NodeElementProcessor.end(NodeElementProcessor.java:117) at org.openstreetmap.osmosis.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:195) at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:108) at java.lang.Thread.run(Thread.java:636) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint nodes_pkey at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.flushNodes(ApidbWriter.java:575) ... 19 more Oct 14, 2010 12:14:21 PM org.openstreetmap.osmosis.core.Osmosis main SEVERE: Execution aborted. org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed. at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146) at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92) at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) at org.codehaus.classworlds.Launcher.main(Launcher.java:31) This has been the case for several other OSM files that I attempted to import. Has anyone run into the above issue? Any solutions? ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] locate places near a cross street / intersection
Hello All, Do any of the services (such as: Nominatim, Name Finder, Gazetteer, the standard Rails Port of OSM, etc. ) provide functionality to locate a place(s) given a cross street / intersection of roads? ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] osmosis foreign key constraint
Hello all, Has anyone run into the following while loading an osm file via osmosis? If so, has anyone found a solution/work around? Any insight as how to proceed? SEVERE: Thread for task 1-read-xml-0.6 failed org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to load current way nodes. at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentWays(ApidbWriter.java:975) at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentTables(ApidbWriter.java:1026) at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:1051) at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:110) at java.lang.Thread.run(Thread.java:636) Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table current_way_nodes violates foreign key constraint current_way_nodes_node_id_fkey Detail: Key (node_id)=(51847177) is not present in table current_nodes. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360) at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentWays(ApidbWriter.java:972) ... 4 more Sep 14, 2010 2:24:48 PM org.openstreetmap.osmosis.core.Osmosis main SEVERE: Execution aborted. org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed. at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146) at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92) at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) at org.codehaus.classworlds.Launcher.main(Launcher.java:31) ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Installation and Configuration of OSM and Nominatim
I have just downloaded the Rails Port of the OSM server. After several configuration and build issues I was able to get it done and running on my local machine. Next, I tried populating the database using Osmosis version 0.36. I downloaded the following osm file, florida.osm.bz2, attempted the load and received the following exception: current_way_nodes violates foreign key constraint current_way_nodes_node_id_fkey -- not sure what steps to take next any help is appreciated. Another question I have is the following: I would like to use the Rails port (OSM) server in a closed network (ie. no access to internet etc). The only maps/data I would like to have in the database is of the USA -- later adding other countries. Upon installing the OSM server and configuring the database, I noticed that attempting a search will cause a request to go out to an external server (Nominatim and GeoNames -- among others). These URLs are hard-coded in the code. What would I need to do to run the server in a self contained closed network? ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev