Hello (Bonjour Christophe) I don't use french cadastre, only specific archaelogical data.
Thanks for this, I try but, I don't realy understand how worked topogeo_addpolygon.
If I do : CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; SET search_path = topology,public; I import my layer with QGIS SELECT topology.CreateTopology('ec_topo', 27572);SELECT topology.AddTopoGeometryColumn('ec_topo','public','ec','topo_geom','POLYGON');
DO $$DECLARE r record; BEGIN FOR r IN SELECT * FROM ec LOOP BEGIN SELECT topology.TopoGeo_AddPolygon('ec_topo',st_geometryn(r.geom,1),1); EXCEPTION WHEN OTHERS THEN RAISE WARNING 'Loading of record % failed: %', r.id, SQLERRM; END; END LOOP; END$$; I have :ATTENTION: Loading of record 1 failed: la requête n'a pas de destination pour les données résultantes
I don't know where I'm wrong If you have an idea Thanks Regards LudovicPS : (si j'avais sur que c'était toi qui répondrait, j'aurai écrit sur nos forums francophone ;-) )
Le 15/01/2014 08:25, Christophe Vergon a écrit :
Hello, (bonjour)When you udpdate a topology by using a SET statement if a polygon intersect an other you will have this error. If you want to create a topology from polygons try to use the topogeo_addpolygon function, the intersection between two polygons will be a new face.If, as I mean, you use a french survey "cadastre" data set, it's the best way to do that.Ludovic Granjon a écrit :Hi allI try to import a polygon layer to postgis and build topology with tolerance.I try something like that SELECT CreateTopology('ec_topo2', 27572);SELECT AddTopoGeometryColumn('ec_topo2', 'public', 'ec', 'topogeom2', 'MULTIPOLYGON');UPDATE ec SET topogeom2 = toTopoGeom(geom, 'ec_topo', 1, 1.0); But when I do that, I have ********** Erreur ********** ERREUR: Spatial exception - geometry intersects edge 262 État SQL :P0001Contexte : fonction PL/pgsql « topogeo_addlinestring », ligne 124 à affectation SQL statement "SELECT array_cat(edges, array_agg(x)) FROM ( select topology.TopoGeo_addLinestring(atopology, rec.geom, tol) as x ) as foo"fonction PL/pgsql « topogeo_addpolygon », ligne 24 à affectationfonction PL/pgsql « totopogeom », ligne 112 à FOR sur des lignes de SELECTfonction PL/pgsql « totopogeom », ligne 94 à affectation I try to modify the tolerance parameter but it still doesn't work Have you a solution for that ? Thanks a lot Regards Ludovic _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
<<attachment: ludovic_granjon.vcf>>
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users