[postgis-users] Create topologic layers from simple geometries

[lcelati at latitude-geosystems.com]

Hello,

Regarding a big project in Cameroon, i'm testing topology in Postgis. I
have created a db called "Test_Cameroun". I have already import simple
geometries into two tables called "land cover" (MULTYPOLYGONN) and
"network"(MULTILINES).
These two tables are localised into public schema.
I want to create topologic layers from these simple geometries. I have
created a new topology schema (create topology) called "topology_test"
successfully.
Then, I read the example written on toTopoGeom postgis page:

http://postgis.refractions.net/documentation/manual-2.0/toTopoGeom.html

That's why i have created a new table called for instance "nei_topo"  
always in public schema :

CREATE TABLE nei_topo(gid serial primary key, nei varchar(30));

Then,

I added to it a topogeometry column

SELECT topology.AddTopoGeometryColumn('topology_test', 'public',  
'nei_topo', 'topo', 'MULTIPOLYGON') As new_layer_id;


Then,I want to populating the new topogeometry column via use new layer id.

INSERT INTO nei_topo(nei, topo)
SELECT nei,  topology.toTopoGeom(geom, 'topo_cameroun', 1)
FROM Land_cover
WHERE gid BETWEEN 1 and 8;

But i have a error message.

I send you by attachment all screen shots.

Could you throw light for me ASAP please.
Kind regards.

Laurent Celati.




-- 
Laurent Celati - Geospatial applications specialist - LATITUDE GEOSYSTEMS
47, avenue de la Division Leclerc - 95170 Deuil-la-Barre, FRANCE
Tel : + 33 (0)1 34 17 23 84 - Fax : + 33 (0) 1 39 64 04 86
mob : + 33 (0)6 xx xx xx xx
skype lcelati
E-mail : lcelati at latitude-geosystems.com
http://www.latitude-geosystems.com



----- Fin du message transféré -----

-------------- next part --------------
A non-text attachment was scrubbed...
Name: table_land_cover.JPG
Type: image/jpeg
Size: 54694 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120620/ae7be5ac/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SS_SELECT topology.AddTopoGeometryColumn.JPG
Type: image/jpeg
Size: 45197 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120620/ae7be5ac/attachment-0001.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: INSERT INTO nei_topo(nei, topo).JPG
Type: image/jpeg
Size: 50043 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120620/ae7be5ac/attachment-0002.jpe>