Invalid args using ElementaryGeometries

[ckgoo...@gmail.com]

Hello.  I have a table spt_Intersections with a geometry column called polygon that has just one row of data.  The geometry returns GEOMETRYCOLLECTION from GeometryType.

I want to split this collection into its simple geometries so I try:

select ElementaryGeometries( 'spt_Intersections', 'polygon', 'spt_Output', 'pk', 'polyID');

 

Neither pk or polyID are present in spt_Intersections.

Yet I get an invalid args error.

I’ve read the documentation, googled it and AI’ed it but I can’t see where I am going wrong.

Any help please?

Regards, Chris

 

[a.fu...@lqt.it]

Hi Chris,

have you verified that your input table is a genuine geometry table
correctly registered?

in other words, does it contain a geometry created by
AddGeometryColumn()
that is defined by a corresponding row into the "geometry_columns"
system table?

if not an "invalid args" error will be certainly returned.

bye Sandro

[ckgoo...@gmail.com]

Thanks, that did the trick.
I had previously been just using
Polygon GEOMETRY
In my CREATE TABLE statement.
Best, Chris

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/spatialite-users/0f43dcd2530a9b1ddd0965f75c806153%40lqt.it.