Thanks. I knew it wasn't related to Topology, but my postgresql skills. This is now, the first and only documented, somewhat simple explanation of what one does with one's first biggish topology to CreateTopoGeom between the conference material and complex examples in Postgis Topology.
So thanks, thanks, thanks from the merely mortal. I'll report my progress. Chris ---------------------------------------- > Date: Wed, 14 Dec 2011 17:51:06 +0100 > From: s...@keybit.net > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] createtopogeom confusion > > On Wed, Dec 14, 2011 at 11:36:04AM -0500, Chris English wrote: > > > Insert into union_cty_topo.summit_fa (g) > > values ( > > topology.createtopogeom( > > 'union_cty_topo', --topo name > > 3, -- type areal > > 2, --layer id > > foo.faces) > > from ( select > > topology.topologyelementarray_agg(array[union_cty_topo.face_id,3]))as faces > > ) > > )as foo; > > > > ERROR: syntax error at or near "from" > > This is really unrelated to Topology. > You'll need something like: > > INSERT INTO union_cty_topo.summit_fa (g) > SELECT topology.createtopogeom( > 'union_cty_topo', --topo name > 3, -- type areal > 2, --layer id > topology.topologyelementarray_agg(array[face_id,3]) > ) from union_cty_topo.face > WHERE face_id > 0; > > NOTE: not checked. > > > trying firefox for verticle, but probably doesn't matter, a hotmail problem > > Better than nothing. > > --strk; > > ,------o-. > | __/ | Thank you for PostGIS-2.0 Topology ! > | / 2.0 | http://www.pledgebank.com/postgistopology > `-o------' > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
