[postgis-users] CityGML in PostGIS - 3D City Database released
felix-kunde at gmx.de
Wed Dec 19 04:36:24 PST 2012
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.
> -------- 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
> hi Felix,
> I'm sorry, and thank you for your help , I am interest by this tool
> 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
> modeled then run the interrogations.
> but I will still disturb you again with my "stupidity" and my questions
> 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
> exists in the database!!
> really sorry for these questions but the tutorial is not clear enough
> View this message in context:
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users