<div dir="ltr"><span id="result_box" class="" lang="en"><span class="hps">hi</span><br> <span class="hps">I followed</span> <span class="hps">the tutorial</span><span>, but</span> <span class="hps">I have not</span> <span class="hps">accomplished</span> <span class="hps">the</span> <span class="hps">desired result :(,</span> <span class="hps">I made</span> <span class="hps">screenshot,</span> <span class="hps"></span><span class="hps"> can</span> <span class="hps alt-edited">you specify me</span> <span class="hps">my mistakes please.</span><br>
<span class="hps">I have some questions</span><br> <span class="hps">1)</span> <span class="hps">in the tutorial,</span> <span class="hps">"A</span> <span class="hps">more</span><span>" comfortable</span> <span class="hps">way</span> <span class="hps">is</span> <span class="hps">CREATE_DB.bat</span> <span class="hps">Offered</span> <span class="hps">with</span> <span class="hps">shell scripts</span> <span class="hps">for Microsoft Windows</span> <span class="hps">family</span> <span class="hps">or</span> <span class="hps">CREATE_DB.sh</span> <span class="hps">for UNIX</span> <span class="hps">/ Linux</span> <span class="hps">and</span> <span class="hps">derivates</span> <span class="hps">as</span> <span class="hps">well</span> <span class="hps">as</span> <span class="hps">MacOS</span> <span class="hps atn">X "</span><span> so </span></span><span id="result_box" class="" lang="en"><span><span id="result_box" class="" lang="en"><span class="hps alt-edited">I understand that</span></span></span> .<span class="hps">Sh</span> <span class="hps">file only for</span> <span class="hps">unix /</span> <span class="hps">Linux</span> <span class="hps">OS?</span><br>
<span class="hps">but</span> <span class="hps">after</span> <span class="hps">you talked about</span><span>. sh</span> <span class="hps">(The</span><span>. sh</span> <span class="hps">scripts</span> <span class="hps">can</span> <span class="hps">be</span> <span class="hps">run</span> <span class="hps">from</span><span class="hps"> Within a</span> <span class="hps">shell</span> <span class="hps">environment)</span> <span class="hps atn">in my case (</span><span>I</span> use<span class="hps"></span> <span class="hps">windows</span><span class="hps"> OS</span><span>)</span> so<span class="hps"> I</span> <span class="hps">am interested</span> <span class="hps">only</span><span> by .bat</span> <span class="hps">file?</span> and </span><span id="result_box" class="" lang="en"><span id="result_box" class="" lang="en"><span class="hps">I</span> <span class="hps">never use .sh file.</span></span> <span class="hps">so I have to</span> <span class="hps atn">"</span><span>chmd</span> <span class="hps">u</span> <span class="hps">+</span> <span class="hps">x"</span> <span class="hps">and ". /</span> <span class="hps">CREATE__DB.sh</span><span>" for</span> <span class="hps">CREATE__DB.bat</span><span>?<br>
<br></span> <span class="hps">2) "The</span> <span class="hps">Windows</span> <span class="hps">batchfiles</span> <span class="hps">are</span> <span class="hps">then</span> <span class="hps">Executed</span> <span class="hps">by</span> <span class="hps atn">double-</span><span>clicking"</span><span>.</span> <span class="hps">when I</span> <span class="hps">click</span> <span class="hps">on</span><span> .bat</span> <span class="hps">file</span> <span class="hps">it displays</span> <span class="hps">a list of commands</span> <span class="hps">and when I</span> <span class="hps">press a key</span> <span class="hps">it closes</span><span>?</span> <span class="hps">so I</span> <span class="hps">repeated this</span> <span class="hps">step</span> <span class="hps">twice?</span><br>
<span class="hps">3) "</span> <span class="hps">3dcitydb/postgis</span> <span class="hps atn">"</span><span>subfolder</span> <span class="hps">Within</span> <span class="hps">the</span> <span class="hps">installation directory</span> <span class="hps">of the</span> <span class="hps">Import / Export.</span><span>"</span> <span class="hps">is what I</span> <span class="hps">Work</span> <span class="hps">with</span> <span class="hps">the file.</span> <span class="hps alt-edited">bat</span> <span class="hps alt-edited">where the location is</span><br>
<span class="hps">"C:</span> <span class="hps">\ Program</span> <span class="hps">Files \</span> <span class="hps">Import</span><span class="atn">-</span><span>Export</span><span class="atn">-</span><span class="">3DCityDB</span> <span class="hps">\</span> <span class="hps">3dcitydb</span> <span class="hps">\</span> <span class="hps">postgis</span> <span class="hps">\</span> <span class="hps">CREATE_DB.bat</span><span>"</span><br>
<span class="hps">4)</span> <span class="hps">you do not</span> <span class="hps">talk about</span> <span class="hps">CREATE_DB.sql</span> <span class="hps">and</span> <span class="hps">CREATE_GEODB_PKG.sql</span><span>?</span><br>
</span><br>thank you for any help:)<br><br><div class="gmail_quote">2012/12/12 Felix Kunde [via PostGIS] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5002070&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span><br>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Babou
<br><br>I'm happy to hear that you're starting tests with the 3D City Database in PostGIS. I've thought my little tutorial was easy to understand. But let me help you out.
<br><br>First of all: PostGIS version 2.0 is mandatory for the 3D City Database. It will not work with PostGIS 1.4! PostgreSQL 8.4 is ok.
<br><br>From your screenshot I can see that the database you have created ('citydb') has no PostGIS elements inside. No functions etc. Create a new database using a PostGIS 2.0 template (template_postgis_20 or postgis20) or add the PostGIS extensions.
<br><br>Then you have to set up the database with a script. This is explained in detail in the tutorial (Step 4 on page 14). You can edit and execute the batchfile CREATE_DB.bat to make it a bit easier. The script will create all tables and also the additional schema 'geodb_pkg'. Only then you will be able to connect to your 3D City Database with the Importer/Exporter tool.
<br><br>Any further questions?
<br><br>cheers
<br>Felix
<br><br>-------- Original-Nachricht --------
<br>> Datum: Wed, 12 Dec 2012 06:24:13 -0800 (PST)
<br>> Von: babou <<a href="http://user/SendEmail.jtp?type=node&node=5002029&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>>
<br>> An: <a href="http://user/SendEmail.jtp?type=node&node=5002029&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>> Betreff: Re: [postgis-users] CityGML in PostGIS - 3D City Database released
<br><div><br>> hi,
<br>> thank you for your answer (despite that it is a little late )
<br><div class="im">> I built a model of a city with CityGML and I want to queries the CityGML
<div class='shrinkable-quote'><br>> file in a database, and as 3D city database can help me in this task I try
<br>> to use it.
<br>> I instaled this tool, 3D City Database for PostGIS 8.4 Postgersql
<br>> postgis1.4.0. Purpose When I connect to the database an error is displayed
<br>> "failed to connect to the database, error: schema" geodb_pkg "does not
<br>> exist." (the result found in the attached document)
<br>> I think it is an instalation error in fact I did not Understand how to
<br>> install this tool.: (
<br>> I have even read all documents provided with this tool but I did not find
<br>> a
<br>> good tutoriale explains well the instalation.
</div></div><div class="im">> I just installed 3DCityDB well-Import-Export in (C: \ Program Files) then
<br>> I
<br>> do not know where i shoulds integrate 3Dcjtydb-2.0.6.!
<br>> how come the link Between Postgersql and 3Dcjtydb-2.0.6?
<br>> can you please guide me to solve this problem?
<br>> and if it is possible to make a video which explains the process of
<br>> instalation and operation of 3D City Database for PostGIS?
<br>> thanks for any help :)
<br></div>> <<a href="http://postgis.17.n6.nabble.com/file/n5002027/Sans_titre.png" rel="nofollow" link="external" target="_blank">http://postgis.17.n6.nabble.com/file/n5002027/Sans_titre.png</a>>
<br>> <<a href="http://postgis.17.n6.nabble.com/file/n5002027/citydb_PostgreSQL.png" rel="nofollow" link="external" target="_blank">http://postgis.17.n6.nabble.com/file/n5002027/citydb_PostgreSQL.png</a>>
<br><div class="im">>
<br>>
<br>>
<br>> --
<br>> View this message in context:
<br></div>> <a href="http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002027.html" rel="nofollow" link="external" target="_blank">http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002027.html</a><div class="im">
<br>> Sent from the PostGIS - User mailing list archive at Nabble.com.
<br>> _______________________________________________
<br>> postgis-users mailing list
<br></div>> <a href="http://user/SendEmail.jtp?type=node&node=5002029&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></div>_______________________________________________
<br>postgis-users mailing list
<br><a href="http://user/SendEmail.jtp?type=node&node=5002029&i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<hr color="#cccccc" noshade size="1">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif"><div class="im">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
</div><a href="http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002029.html" target="_blank" rel="nofollow" link="external">http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002029.html</a>
</div><div class="HOEnZb"><div class="h5">
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from CityGML in PostGIS - 3D City Database released, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></div></div></blockquote></div><br></div>
<div class="small"><br/><img src="/images/icon_attachment.gif" > <strong>create_db file bat.png</strong> (84K) <a href="http://postgis.17.n6.nabble.com/attachment/5002070/0/create_db%20file%20bat.png" target="_top" rel="nofollow" link="external">Download Attachment</a><br/><img src="/images/icon_attachment.gif" > <strong>batfile.png</strong> (73K) <a href="http://postgis.17.n6.nabble.com/attachment/5002070/1/batfile.png" target="_top" rel="nofollow" link="external">Download Attachment</a><br/><img src="/images/icon_attachment.gif" > <strong>citydb.png</strong> (277K) <a href="http://postgis.17.n6.nabble.com/attachment/5002070/2/citydb.png" target="_top" rel="nofollow" link="external">Download Attachment</a></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002070.html">Re: CityGML in PostGIS - 3D City Database released</a><br/>
Sent from the <a href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html">PostGIS - User mailing list archive</a> at Nabble.com.<br/>