[postgis-users] Topology Postgis 2.0

ps.tiara ps.tiara at yahoo.com
Thu Sep 27 04:58:24 PDT 2012


I used PostgreSQL 9.1 and PostGIS 2.0 for PostgreSQL 9.1

I tried in two ways..
FIRST, I populated geometry to the schema using CreateTopoGeo, and then
updated 
the topology column using CreateTopoGeom... (the query and data attached)
but when i visualized the result of topology in x3d, it was mess..maybe i
made a mistake by wrong query??

SECOND, i tried to update the topology column using toTopoGeom..but
this not succeeded..the query and the message error as below

UPDATE simpanglima.ruang
SET ruang_topo = topology.toTopoGeom(ruang_geom,'simpanglima_topo',3)
WHERE rid='1';


ERROR:  function topogeo_addpolygon(unknown, geometry, numeric) does not
exist
LINE 1: ...yer_id, element_type, element_id) SELECT 5, 3, 3, topogeo_ad...
                                                             ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
QUERY:  INSERT INTO simpanglima_topo.relation(topogeo_id, layer_id,
element_type, element_id) SELECT 5, 3, 3,
topogeo_addPolygon('simpanglima_topo',
'01030000A0ED7F0000010000000400000055F245CB23A31A41C1C4936F859961410AD7A3703DDA4440AEF945CB23A31A41FCC4936F859961410AD7A3703D5A43402943025443A31A41E870AE05859961410AD7A3703DDA444055F245CB23A31A41C1C4936F859961410AD7A3703DDA4440'::geometry,
3.32183207231238e-008);
CONTEXT:  PL/pgSQL function "totopogeom" line 129 at EXECUTE statement



Which one is the best methode to complete my research?
Many thanks..


createtopogeo.sql
<http://postgis.17.n6.nabble.com/file/n5000052/createtopogeo.sql>  
createtopogeom.sql
<http://postgis.17.n6.nabble.com/file/n5000052/createtopogeom.sql>  
simpang5.backup
<http://postgis.17.n6.nabble.com/file/n5000052/simpang5.backup>  



--
View this message in context: http://postgis.17.n6.nabble.com/Topology-Postgis-2-0-tp5000006p5000052.html
Sent from the PostGIS - User mailing list archive at Nabble.com.



More information about the postgis-users mailing list