<!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 been thinking my head off trying to figure it out and
documentation won't help me.<br>
<br>
Yesterday I recieved the tip to use a GUID as a database wide unique
key. Well, I think it is the only option I have.<br>
<br>
I import a shape file into a temp table.<br>
>From this temp table is then insert the content into 2 other tables:
final_attributes and final_geom<br>
<br>
Final_attributes should contain all the attribute fields plus a column
to connect it to final_geom<br>
Final_geom should contain a column to connect to Final_attributes plus
the_geom.<br>
<br>
Because Final_attributes is a table that also connects to other
geom_tables; it needs a id that is unique over 3 or even more tables.<br>
<br>
If I can generate GUIDs with php, Is that a good option?<br>
Is there a way to use the geometry column to generate some sort of
unique ID? I would also like to check if the geometry is unique within
it's final_geom table!<br>
<br>
What datatype should I use to store the GUID?<br>
<br>
I cannot figure it out... please lend me a hand<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"> </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>