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

Felix Kunde felix-kunde at gmx.de
Wed Dec 19 04:36:24 PST 2012

Hi Babou

don't get me wrong. I'm happy that you want to test the 3DCityDB. 
And thanks to your feedback I can improve the tutorial.

Temporal queries sounds interesting. The building table already has columns 
for 'year_of_construction' and 'year_of_demolition'. Just for info.

You should really choose the reference system that is used for the 
geometries of your CityGML file. Otherwise you receive wrong results when 
working with PostGIS functions, I guess. SRID 3068 is for Berlin. Do you 
work with a Berlin dataset?

Concerning your error:
I wonder why the table "database_srs" already exists. This could only 
happen if you have run the script before and it stopped at another position 
due to another error (e.g. 'unknown blablabla' if you are still using 
PostGIS 1.4). To clean up your database use DROP_DB.sql (or .bat). Only 
the spatial_ref_sys table should exist in your public schema before 
executing CREATE_DB.sql. I hope you've already switched to PostGIS 2.0.

Kind regards

> -------- Original-Nachricht --------
> Datum: Mon, 17 Dec 2012 13:10:40 -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 Felix,
> I'm sorry, and thank you for your help , I am interest  by this tool 
> because
> I will import my CityGML file into postgis to make queries on a temporal
> axis so I will add two collonnes (start_time and end_time) to each 
> building
> modeled then run the interrogations.
> but I will still disturb you again with my "stupidity" and my questions
> "sorry"
> I used the same SRID that you used in the example of tutorial just for
> testing but here the error shown in the screenshot.
> what am I doing in this case? I understand there is a realtion which 
> already
> exists in the database!!
> really sorry for these questions but the tutorial is not clear enough
> <http://postgis.17.n6.nabble.com/file/n5002080/test.png> 
> --
> View this message in context: 
> http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002080.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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121219/ea58ff63/attachment.html>

More information about the postgis-users mailing list