Dear Sandro,
*Thank you for your last reply. Ok, Henceforth I will copy & paste the
queries and error messages inline as text instead of sending sceenshots.
I will test Creation of topologic layers from simple geometries later...
*I have a request more urgent : Regarding our big project in Cameroon,
keyborders will capture vector data directly in a postgis db from raster
via Qgis. We want capture topologic data directly in db using Qgis
tools. During the capture, for each object created, we want creation of
a OID and centroid value (for faces).
I understood that "Postgis Topology" creates a new schema storing
topologic objects (node/face/edges). Is it possible to capture and save
topologic data from qgis directly into these topologic tables ?
If it is not the case, could you throw light for me on a new way?
Thank you very much.
Regards.
Laurent Celati.
Le 20/06/2012 13:49, Sandro Santilli a écrit :
It looks like you need to quote "Land_cover" in the INSERT statement.
PS: please copy& paste the queries and error messages inline as text,
it's easier to read than screenshots.
--strk;
Sent from our free software
http://www.gnu.org/philosophy/free-sw.html
On Wed, Jun 20, 2012 at 11:17:04AM +0200, lcel...@latitude-geosystems.com wrote:
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 : lcel...@latitude-geosystems.com
http://www.latitude-geosystems.com
----- Fin du message transféré -----
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
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 : lcel...@latitude-geosystems.com
http://www.latitude-geosystems.com
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users