Hi Chuchichäschtli, you can use ogc_fid as primary key from your tables or create on schema for one village.
What "Chuchichäschtli" mean in german? Gr Ralf Am Montag 20 September 2010 09:34:11 schrieb Thomas Andres: > Dear List, > > > > im Swiss and my English isnt the most best. Even, I will try the explain > You my problem. Perhaps You will understand J > > > > In Switzerland the parts of the country were measured by different offices. > The informations of the terrain (parcelles, rows, lakes, jungle etc ) are > exchanged by Interlis Files (*.itf). > > > > With ogr2ogr this files can be imported into a Postgres Database. > > > > When You import only one file, its not a problem. Every Line, Point, > Polygone and so on, has its own Feature-Id, which can be linked with > another feature. > > I.e.: The geometry of a parcelle is linked with his number. > > > > Now, when I would like add a second village to my GIS, in the same > Database, to be loaded in Mapserver with a mapfile layer the parcelle > with the same Feature ID will appear twice so the link to the number of > the parcelle is wrong > > > > What I made in a first time: after have imported the first village, I add > to the primary and foreign keys, which I really Im going to use in my GIS > a Char (a in example) by using PostgreSQL only after I imported the > second file. This is a solution which works, but not for long time J > > > > I asked me, or better: I ask You, if there isnt a mechanism in PostGIS or > PostgreSQL which is specially implemented for this kind of collage Some > kind of namespaces or I dont know You understand =-) ? > > > > Thänk You very much for Your help. > > > > Salutation from Chuchichäschtli > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
