<html>
<head />
<body>
Hi Babou<br /><br />don't get me wrong. I'm happy that you want to test the 3DCityDB. <br />And thanks to your feedback I can improve the tutorial.<br /><br />Temporal queries sounds interesting. The building table already has columns for 'year_of_construction' and 'year_of_demolition'. Just for info.<br /><br />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?<br /><br />Concerning your error:<br />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.<br /><br />Kind regards<br />Felix<br /><blockquote type="cite">
<p>-------- Original-Nachricht --------<br />Datum: Mon, 17 Dec 2012 13:10:40 -0800 (PST)<br />Von: babou <hiba.maalaoui@gmail.com><br />An: postgis-users@postgis.refractions.net<br />Betreff: Re: [postgis-users] CityGML in PostGIS - 3D City Database released<br /><br /></p>
hi Felix,<br /><br />I'm sorry, and thank you for your help , I am interest by this tool because<br />I will import my CityGML file into postgis to make queries on a temporal<br />axis so I will add two collonnes (start_time and end_time) to each building<br />modeled then run the interrogations.<br />but I will still disturb you again with my "stupidity" and my questions<br />"sorry"<br />I used the same SRID that you used in the example of tutorial just for<br />testing but here the error shown in the screenshot.<br />what am I doing in this case? I understand there is a realtion which already<br />exists in the database!!<br />really sorry for these questions but the tutorial is not clear enough<br /><http://postgis.17.n6.nabble.com/file/n5002080/test.png> <br /><br /><br /><br />--<br />View this message in context: http://postgis.17.n6.nabble.com/CityGML-in-PostGIS-3D-City-Database-released-tp4998980p5002080.html<br />Sent from the PostGIS - User mailing list archive at Nabble.com.<br />_______________________________________________<br />postgis-users mailing list<br />postgis-users@lists.osgeo.org<br />http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br /></blockquote>
</body>
</html>