<div dir="ltr">Grazie a tutti,<div style>con OSMembrane ho capito un po' come funzionano le query di osmosis.</div><div style>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.</div>
<div style><br></div><div style>Ho provato con il comando</div><div style><br></div><div style> osmosis --read-xml europe-latest.osm.bz2 --write-pgsimp user="postgres" database="mydb" password="secret"<br>
</div><div style><br></div><div style>dove ovviamente ho cambiato i dati personali.</div><div style><br></div><div style>osmosis mi dà però un errore ERROR: relation "schema_info" does not exist (in coda incollo tutto l'output)</div>
<div style><br></div><div style>non capisco perché, non sono una cima in db ma quel postgis mi funziona bene.</div><div style><br></div><div style>mah</div><div style><br></div><div style><br></div><div style><br></div><div style>
<div>15-mar-2013 23.13.13 org.openstreetmap.osmosis.core.Osmosis run</div><div>INFO: Osmosis Version 0.42</div><div>15-mar-2013 23.13.13 org.openstreetmap.osmosis.core.Osmosis run</div><div>INFO: Preparing pipeline.</div>
<div>15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.Osmosis run</div><div>INFO: Launching pipeline execution.</div><div>15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.Osmosis run</div><div>INFO: Pipeline executing, waiting for completion.</div>
<div>15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion</div><div>GRAVE: Thread for task 1-read-xml failed</div><div>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to read the schema version from the schema info table.</div>
<div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:90)</div><div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:50)</div>
<div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlWriter.initialize(PostgreSqlWriter.java:183)</div><div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlWriter.process(PostgreSqlWriter.java:773)</div>
<div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.xml.v0_6.impl.BoundsElementProcessor.end(BoundsElementProcessor.java:84)</div><div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107)</div>
<div><span class="" style="white-space:pre"> </span>at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)</div><div><span class="" style="white-space:pre"> </span>at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)</div>
<div><span class="" style="white-space:pre"> </span>at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)</div><div><span class="" style="white-space:pre"> </span>at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)</div>
<div><span class="" style="white-space:pre"> </span>at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)</div><div><span class="" style="white-space:pre"> </span>at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)</div>
<div><span class="" style="white-space:pre"> </span>at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)</div><div><span class="" style="white-space:pre"> </span>at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)</div>
<div><span class="" style="white-space:pre"> </span>at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)</div><div><span class="" style="white-space:pre"> </span>at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)</div>
<div><span class="" style="white-space:pre"> </span>at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)</div><div><span class="" style="white-space:pre"> </span>at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)</div>
<div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:111)</div><div><span class="" style="white-space:pre"> </span>at java.lang.Thread.run(Thread.java:679)</div>
<div>Caused by: org.postgresql.util.PSQLException: ERROR: relation "schema_info" does not exist</div><div> Posizione: 21</div><div><span class="" style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)</div>
<div><span class="" style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)</div><div><span class="" style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)</div>
<div><span class="" style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)</div><div><span class="" style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)</div>
<div><span class="" style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)</div><div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.pgsimple.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:71)</div>
<div><span class="" style="white-space:pre"> </span>... 19 more</div><div>15-mar-2013 23.13.14 org.openstreetmap.osmosis.core.Osmosis main</div><div>GRAVE: Execution aborted.</div><div>org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.</div>
<div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)</div><div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)</div>
<div><span class="" style="white-space:pre"> </span>at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)</div><div><span class="" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div><span class="" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</div><div><span class="" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</div>
<div><span class="" style="white-space:pre"> </span>at java.lang.reflect.Method.invoke(Method.java:616)</div><div><span class="" style="white-space:pre"> </span>at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)</div>
<div><span class="" style="white-space:pre"> </span>at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)</div><div><span class="" style="white-space:pre"> </span>at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)</div>
<div><span class="" style="white-space:pre"> </span>at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)</div><div><span class="" style="white-space:pre"> </span>at org.codehaus.classworlds.Launcher.main(Launcher.java:47)</div>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">Il giorno 15 marzo 2013 17:15, Martin Koppenhoefer <span dir="ltr"><<a href="mailto:dieterdreist@gmail.com" target="_blank">dieterdreist@gmail.com</a>></span> ha scritto:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">2013/3/15 Andrea Zedda <<a href="mailto:andreazedda80@gmail.com">andreazedda80@gmail.com</a>>:<br>
<div class="im">> Ciao a tutti,<br>
> sto lavorando ad un progetto open e mi servirebbe estrarre tutti i confini<br>
> amministiivi, per tutti i livelli (admin_level=*) per tutto il pianeta e<br>
> metterli in un geojson.<br>
> Ho il file planet.osm, potreste suggerirmi un modo semplice attraverso il<br>
> quale ottenere questo risultato?<br>
> Si tratta di un grosso file come ben sapete e pensavo di usare osmosis. Nel<br>
> caso sapreste suggerirmi una query? (son proprio negato con le query..)<br>
> tnx tnx<br>
> Andrea<br>
<br>
<br>
</div>lo puoi fare con Osmosis (guardati tagfilter ed includi anche la<br>
geometria da quale dipende (nodi)). Lo puoi usare in modo piped:<br>
"bzcat planet.tar.bz2 | osmosis ...." per evitare di estrarre tutto su<br>
disco. Anche osmfilter e osmconvert e probabilmente tanti altri tools<br>
te lo consentono di fare...<br>
<br>
ciao,<br>
Martin<br>
<div class="HOEnZb"><div class="h5"><br>
_______________________________________________<br>
Talk-it mailing list<br>
<a href="mailto:Talk-it@openstreetmap.org">Talk-it@openstreetmap.org</a><br>
<a href="http://lists.openstreetmap.org/listinfo/talk-it" target="_blank">http://lists.openstreetmap.org/listinfo/talk-it</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Andrea Zedda<br>skype: andria.tzedda<br>twitter: @Andria_Tzedda<div>-----------------------------------<br><div>Kode srl
<br><span style="color:rgb(51,51,51);font-family:Arial,Helvetica">via Gioacchino Volpe, 74 </span><span style="color:rgb(51,51,51);font-family:Arial,Helvetica">56121 Ospedaletto (Pisa)</span><br><a href="http://kode-solutions.net/" target="_blank">http://kode-solutions.net</a></div>
<div>-----------------------------------<br>Sardinia Open Data<br><a href="http://sardiniaopendata.org/" target="_blank">http://sardiniaopendata.org/</a><br>-----------------------------------<br><br></div></div></div>
</div>