'[postgis-users] dynamic BBOX over several tables'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] dynamic BBOX over several tables
From:       Milo van der Linden <mlinden () zeelandnet ! nl>
Date:       2007-07-31 7:43:06
Message-ID: 46AEE80A.3090504 () zeelandnet ! nl
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Hello list,

I have a tableset construnction as follows:

TheAttributeTable - containing all attributes for my map
ThePolygons - containing polygons with a matching key within
TheAttributeTable
ThePoints - containing points with a matching key within TheAttributeTable
TheLineStrings - containing LineStrings with a matching key within
TheAttributeTable

I would like to be able to run a function that determines a BBOX over
the 3 geometry tables and stores this BBOX in a new table, is this possible?
-- 

Milo van der Linden
mlinden@zeelandnet.nl <mailto:mlinden@zeelandnet.nl>
milovanderlinden@gmail.com <mailto:milovanderlinden@gmail.com>
milo@3dsite.nl <mailto:milo@3dsite.nl>
http://www.3dsite.nl

De informatie in dit bericht reflecteerd mijn persoonlijke mening en
niet die van een bedrijf of instantie. Aan de informatie kunnen geen
rechten worden ontleend. Indien dit bericht onderdeel is van een forum,
mailing-list of community dan gelden automatisch de bijbehorende
voorwaarden.

[Attachment #5 (text/html)]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Helvetica, Arial, sans-serif">Hello list,<br>
<br>
I have a tableset construnction as follows:<br>
<br>
TheAttributeTable - containing all attributes for my map<br>
ThePolygons - containing polygons with a matching key within
TheAttributeTable<br>
</font><font face="Helvetica, Arial, sans-serif">ThePoints - containing
points with a matching key within TheAttributeTable<br>
</font><font face="Helvetica, Arial, sans-serif">TheLineStrings -
containing LineStrings with a matching key within TheAttributeTable<br>
<br>
I would like to be able to run a function that determines a BBOX over
the 3 geometry tables and stores this BBOX in a new table, is this
possible?<br>
</font>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
	background-color: #FFFFFF;
	margin-left: 5px;
	margin-top: 5px;
	margin-right: 5px;
	margin-bottom: 5px;
}
body,td,th {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
  <tbody>
    <tr>
      <td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
      </td>
      <td colspan="2" align="left" height="78" valign="top" width="0">
      <p class="style4">Milo van der Linden
      <br>
      <a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
      <a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
      <a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
      <a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
      </p>
      </td>
      <td rowspan="3" align="left" height="0" valign="top" width="15">&nbsp;</td>
      <td valign="top" width="300">
      <p class="style5"><span lang="NL">De informatie in dit bericht
reflecteerd mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bijbehorende voorwaarden.</span></p>
      </td>
    </tr>
  </tbody>
</table>
</div>
</body>
</html>

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 