[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