[postgis-users] Create topologic layers from simple geometries

[celati laurent]

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, lcelati at 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 : lcelati at latitude-geosystems.com
>> http://www.latitude-geosystems.com
>>
>>
>>
>> ----- Fin du message transféré -----
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at 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 : lcelati at latitude-geosystems.com
http://www.latitude-geosystems.com