[postgis-users] CityGML in PostGIS - 3D City Database released

babou hiba.maalaoui at gmail.com
Sun Dec 16 08:05:25 PST 2012


hi
I followed the tutorial, but I have not accomplished the desired result :(, I
made screenshot,  can you specify me my mistakes please.
I have some questions
1) in the tutorial, "A more" comfortable way is CREATE_DB.bat Offered
with shell
scripts for Microsoft Windows family or CREATE_DB.sh for UNIX / Linux and
derivates as well as MacOS X " so I understand that .Sh file only for unix /
Linux OS?
but after you talked about. sh (The. sh scripts can be run from Within a
shell environment) in my case (I use windows OS) so I am interested only by
.bat file? and I never use .sh file. so I have to "chmd u + x" and ". /
CREATE__DB.sh" for CREATE__DB.bat?

2) "The Windows batchfiles are then Executed by double-clicking". when I
click on .bat file it displays a list of commands and when I press a key it
closes? so I repeated this step twice?
3) " 3dcitydb/postgis "subfolder Within the installation directory of
the Import
/ Export." is what I Work with the file. bat where the location is
"C: \ Program Files \ Import-Export-3DCityDB \ 3dcitydb \ postgis \
CREATE_DB.bat"
4) you do not talk about CREATE_DB.sql and CREATE_GEODB_PKG.sql?

thank you for any help:)

2012/12/12 Felix Kunde [via PostGIS] <ml-node+s17n5002029h72 at n6.nabble.com>

> Hi Babou
>
> 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.
>
> 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.
>
> 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.
>
> 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.
>
> Any further questions?
>
> cheers
> Felix
>
> -------- Original-Nachricht --------
> > Datum: Wed, 12 Dec 2012 06:24:13 -0800 (PST)
> > Von: babou <[hidden email]<http://user/SendEmail.jtp?type=node&node=5002029&i=0>>
>
> > An: [hidden email]<http://user/SendEmail.jtp?type=node&node=5002029&i=1>
> > Betreff: Re: [postgis-users] CityGML in PostGIS - 3D City Database
> released
>
> > hi,
> > thank you for your answer  (despite that it is a little late )
> > I built a model of a city with CityGML and I want to queries the CityGML
> > file in a database, and as 3D city database can help me in this task I
> try
> > to use it.
> > I instaled this tool, 3D City Database for PostGIS 8.4 Postgersql
> > postgis1.4.0. Purpose When I connect to the database an error is
> displayed
> > "failed to connect to the database, error: schema" geodb_pkg "does not
> > exist." (the result found in the attached document)
> > I think it is an instalation error in fact I did not Understand how to
> > install this tool.: (
> > I have even read all documents provided with this tool but I did not
> find
> > a
> > good tutoriale explains well the instalation.
> > I just installed 3DCityDB well-Import-Export in (C: \ Program Files)
> then
> > I
> > do not know where i shoulds integrate 3Dcjtydb-2.0.6.!
> > how come the link Between Postgersql and 3Dcjtydb-2.0.6?
> > can you please guide me to solve this problem?
> > and if it is possible to  make a video which explains the process of
> > instalation and operation of 3D City Database for PostGIS?
> > thanks for any help :)
> > <http://postgis.17.n6.nabble.com/file/n5002027/Sans_titre.png>
> > <http://postgis.17.n6.nabble.com/file/n5002027/citydb_PostgreSQL.png>
> >
> >
> >
> > --
> > View this message in context:
> >
> http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002027.html
>
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=5002029&i=2>
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5002029&i=3>
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002029.html
>  To unsubscribe from CityGML in PostGIS - 3D City Database released, click
> here<http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4998980&code=aGliYS5tYWFsYW91aUBnbWFpbC5jb218NDk5ODk4MHwxOTY3MjkzNzg4>
> .
> NAML<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>
>


create_db file bat.png (84K) <http://postgis.17.n6.nabble.com/attachment/5002070/0/create_db%20file%20bat.png>
batfile.png (73K) <http://postgis.17.n6.nabble.com/attachment/5002070/1/batfile.png>
citydb.png (277K) <http://postgis.17.n6.nabble.com/attachment/5002070/2/citydb.png>




--
View this message in context: http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002070.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121216/e95fc91e/attachment.html>


More information about the postgis-users mailing list