Re: [sqlite] geopoly - rules re data entry

2018-11-19 Thread David Raymond
ys pronounce it in a way that rhymes with monopoly. Would anyone be up for a game of Mono Poly?) -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Graham Hardman Sent: Saturday, November 17, 2018 8:37 PM To: sqlite-users@mailinglis

Re: [sqlite] geopoly - rules re data entry

2018-11-18 Thread Thomas Kurz
> I discovered that >many legacy GeoJSON files do not follow the rules and put polygon >vertexes in CW order. As far as I know, the Open Geospatial Consortium defines polygons with CCW order (and iCW inner rings) as "seen from top", and an iCW exterior ring (with CCW inner rings) as "seen from

Re: [sqlite] geopoly - rules re data entry

2018-11-18 Thread Richard Hipp
On 11/18/18, Graham Hardman wrote: > Thanks for the clarification and news of the up-coming additions. This > issue will not impede me for the moment. > > Oh, and by the way - the pragma compile_options sql command is still not > including geopoly in the return list. (using 3.25.3) Please

Re: [sqlite] geopoly - rules re data entry

2018-11-17 Thread Graham Hardman
Thanks for the clarification and news of the up-coming additions. This issue will not impede me for the moment. Oh, and by the way - the pragma compile_options sql command is still not including geopoly in the return list. (using 3.25.3) Graham On 18-11-2018 3:57 pm, Richard Hipp wrote: On

Re: [sqlite] geopoly - rules re data entry

2018-11-17 Thread Richard Hipp
On 11/17/18, Richard Damon wrote: > On 11/17/18 8:37 PM, Graham Hardman wrote: >> >> My question then is, is it really necessary to ensure a counterclockwise >> order when a polygon shape is entered for the first time in the table. >> > My guess would be that SOME operations will need the

Re: [sqlite] geopoly - rules re data entry

2018-11-17 Thread Richard Damon
On 11/17/18 8:37 PM, Graham Hardman wrote: > Hi, > > The documentation for the geopoly module states that the vertices must > be defined in a counter-clockwise order so that the interior of the > polygon is on the left of the element as it is drawn. > > However, I have discovered that a polygon

[sqlite] geopoly - rules re data entry

2018-11-17 Thread Graham Hardman
Hi, The documentation for the geopoly module states that the vertices must be defined in a counter-clockwise order so that the interior of the polygon is on the left of the element as it is drawn. However, I have discovered that a polygon transformed with geopoly_xform can result in a polygon