[postgis-users] Support for LINESTRING and CIRCULARSTRING in the same polygon.

Mats Taraldsvik mats.taraldsvik at gmail.com
Wed Jul 20 12:39:29 PDT 2011


On 07/20/2011 09:35 PM, James David Smith wrote:
> Mats,
>
> Maybe the thing to do is to use the below function...?
>
> GEOMETRYCOLLECTION(POINT(2 3),LINESTRING((2 3,3 4)))
>
> Then inside the Geometry collection, you can put both a Polygon and a
> Curve Polygon ?
>

I don't think that would render correctly in e.g. QuantumGIS, though. 
Also, a polygon consists of closed rings. Therefore, it would not work.

> This webpage seems to be a good place to read about all the different
> types of shape you can store... though I guess you've seen it
> already...
>
> http://postgis.refractions.net/docs/ch04.html
>
> Cheers
>
> James
>
> On 20 July 2011 20:27, Mats Taraldsvik<mats.taraldsvik at gmail.com>  wrote:
>> Hi,
>>
>> On 07/20/2011 08:53 PM, James David Smith wrote:
>>> Hey Mats,
>>>
>>> I'm just a newbie, so don't really have an answer for you I'm afraid,
>>> but if a Polygon has a curved line, then it isn't a Polygon I don't
>>> think. Polygons have only straight lines.
>>>
>> Yes. My internal polygon objects (for a corporate gis system) may contain
>> both, though, and I need a way to store them in PostGIS.
>>
>>> Am quite curious what the answer is to your query though... ! Good luck.
>>>
>>> James
>> Thanks! :)
>>
>> cheers,
>> Mats
>>
>>> On 20 July 2011 19:48, Mats Taraldsvik<mats.taraldsvik at gmail.com>    wrote:
>>>> Hi,
>>>>
>>>> I have to deal with Polygons which have curves as well as straight lines.
>>>> How should I store them in postgis? (If I understand the documentation
>>>> correctly, Polygon is for linestrings, CurvePolygon is for
>>>> circularstrings,
>>>> but none of them handles a mix of both..?)
>>>>
>>>> Regards,
>>>> Mats Taraldsvik
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list