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

[Felix Kunde]

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 <hiba.maalaoui at gmail.com>
> An: postgis-users at postgis.refractions.net
> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users