Dear Sandro,
Thank you for your reply. But i don't understand why you advised to me
to quote "Land-cover" in the first line : INSERT INTO nei_topo ?
Mike Toews recommanded to me to renaming "Land_cover" table to
"land_cover" (with a lower case "l"). I did it and i have a new message
error :
INSERT INTO nei_topo(nei, topo)
SELECT topology.toTopoGeom(the_geom, 'public', 1)
FROM land_cover
WHERE gid BETWEEN 1 and 8;
********** Erreur **********
ERREUR: INSERT a plus de colonnes cibles que d'expressions
État SQL :42601
Caractère : 27
COuld you throw light for me?
Thanks
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
