<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=984532808-05012007>Hi
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=984532808-05012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=984532808-05012007>I have a
question regarding the database design of a PostGIS database. At our institute
we are planning to set up a database where all spatial and non spatial data
should be held central on a server. We have two different working groups. One
works mainly on water projects the other in the cleaner production
context.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=984532808-05012007>We are planning to
setup an intranet interface with QGIS and GRASS in order for the knowledge
and needs of the user to work with the data. For data entries by users we want
to use pgadmin and phppagadmin. As internet and plublic interface we want to use
Mapserver. For documentation a metadatasystem is planned after the ISO19115
where we filter out our needed core elements for the data. Additionally we will
implement a search function for keywords to filter out data quite
rapidly.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=984532808-05012007>For the future we
probably get a lot of tables (count > 200) mixed up in different topics and
types (spatial and non-spatial).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=984532808-05012007>What do you
think? Should we create databases for any topic and try to categorise the
tables or mix it all together in one database and end up in mess. I think
administration in pgadmin suffers with that amount of tables but is always
better than on the commandline with psql.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=984532808-05012007>Thank you for your
comments,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=984532808-05012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=984532808-05012007>Christian</SPAN></FONT><FONT
face=Helv></DIV></FONT></BODY></HTML>