Grazie a tutti, con OSMembrane ho capito un po' come funzionano le query di osmosis. Ho deciso che il mio primo passo è quello di caricarmi un osm dentro postgis e poi magari usare qualche tool per dare qualche query precisa.
Ho provato con il comando osmosis --read-xml europe-latest.osm.bz2 --write-pgsimp user="postgres" database="mydb" password="secret" dove ovviamente ho cambiato i dati personali. osmosis mi dà però un errore ERROR: relation "schema_info" does not exist (in coda incollo tutto l'output) non capisco perché, non sono una cima in db ma quel postgis mi funziona bene. mah 15-mar-2013 23.13.13 org.openstreetmap.osmosis.core.Osmosis run INFO: Osmosis Version 0.42 15-mar-2013 23.13.13 org.openstreetmap.osmosis.core.Osmosis run INFO: Preparing pipeline. 15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.Osmosis run INFO: Launching pipeline execution. 15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.Osmosis run INFO: Pipeline executing, waiting for completion. 15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion GRAVE: Thread for task 1-read-xml failed org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to read the schema version from the schema info table. at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:90) at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:50) at org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlWriter.initialize(PostgreSqlWriter.java:183) at org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlWriter.process(PostgreSqlWriter.java:773) at org.openstreetmap.osmosis.xml.v0_6.impl.BoundsElementProcessor.end(BoundsElementProcessor.java:84) 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:111) at java.lang.Thread.run(Thread.java:679) Caused by: org.postgresql.util.PSQLException: ERROR: relation "schema_info" does not exist Posizione: 21 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:71) ... 19 more 15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.Osmosis main GRAVE: 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:47) Il giorno 15 marzo 2013 17:15, Martin Koppenhoefer <dieterdre...@gmail.com>ha scritto: > 2013/3/15 Andrea Zedda <andreazedd...@gmail.com>: > > Ciao a tutti, > > sto lavorando ad un progetto open e mi servirebbe estrarre tutti i > confini > > amministiivi, per tutti i livelli (admin_level=*) per tutto il pianeta e > > metterli in un geojson. > > Ho il file planet.osm, potreste suggerirmi un modo semplice attraverso il > > quale ottenere questo risultato? > > Si tratta di un grosso file come ben sapete e pensavo di usare osmosis. > Nel > > caso sapreste suggerirmi una query? (son proprio negato con le query..) > > tnx tnx > > Andrea > > > lo puoi fare con Osmosis (guardati tagfilter ed includi anche la > geometria da quale dipende (nodi)). Lo puoi usare in modo piped: > "bzcat planet.tar.bz2 | osmosis ...." per evitare di estrarre tutto su > disco. Anche osmfilter e osmconvert e probabilmente tanti altri tools > te lo consentono di fare... > > ciao, > Martin > > _______________________________________________ > Talk-it mailing list > Talk-it@openstreetmap.org > http://lists.openstreetmap.org/listinfo/talk-it > -- Andrea Zedda skype: andria.tzedda twitter: @Andria_Tzedda ----------------------------------- Kode srl via Gioacchino Volpe, 74 56121 Ospedaletto (Pisa) http://kode-solutions.net ----------------------------------- Sardinia Open Data http://sardiniaopendata.org/ -----------------------------------
_______________________________________________ Talk-it mailing list Talk-it@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-it
