[postgis-users] detabase design question

[marco vieira]

Andre,
 My one cent: use schemes to organize your data conceptually and transform
your data to an unique srid preserving the original srid in some way
(another geometry column or backup). This last issue will be helpful when
designing spatial queries. The rest is thinking your data according to its
application.

Cheers,

-- 
Marco Vieira
+55 21 9499-6800
e-mail: maovieira at gmail.com

2008/1/25, Andre Schoonbee <andresch at iway.na>:
>
> I do not have years of experience and am faced with a challenge:
> My client have lots of vector data. Some are from a few years ago and they
> want to load all data into postgis. The data covering a wide spectrum -
> basically all spatial data for the country. This is census data, regions
> and
> the subsequent changes to the regions, National rainfall and also regional
> rainfall. Mining, roads and the changing of the roads the past 10 years.
> Boreholes from 10 years ago, and subsequently replaced by pipelines.
> Veterinarian data, etc...
>
> So some of the data is national data and some is regional data. But the
> regional data is not always related to the current region, because the
> regions have changed in the last couple of years.
>
> So my question:  Is there a basic concept design that will cater for these
> kind of scenarios? Any ideas might help
>
> Thanks
>
> Andre
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080125/c42b3fee/attachment.html>