[postgis-users] GeometryCollection with GEOMETRYCOLLECTIONM, POINTM etc.. value in constructor.

[Baris Ergun]

Hi Remi;

Who should I get in touch about this issue related to
org.postgis.GeometryCollection constructor in postgis jdbc driver.

Thanks.


On 18 December 2013 10:53, Baris Ergun <barisergun75 at gmail.com> wrote:

> Exactly correct. I also tried to tell that the problem was originated from
> org.postgis.GeometryCollection constructor. So I posted to here to
> understand why constructor was behaving like this. This constructor is in
> postgis-jdbc.jar . Anyone knowing about this problem on
> the org.postgis.GeometryCollection constructor?
>
>
> On 18 December 2013 10:35, Rémi Cura <remi.cura at gmail.com> wrote:
>
>> Hey,
>> using this in sql :
>> SELECT ST_AsText(ST_GeomFromText(
>> 'GEOMETRYCOLLECTIONM(
>> POINTM(10 10 100),
>> LINESTRINGM(0 50 100, 100 50 100),
>> POLYGONM((25 25 100,75 25 100,75 75 100,25 75 100,25 25 100),(45 45
>> 100,55 45 100,55 55 100,45 55 100,45 45 100))
>> )'
>> ))
>>
>> It gives you the expected output.
>> I would guess it is the java function you are using that is faulty (the
>> geometrycollection constructer).
>>
>>  Cheers,
>> Rémi-C
>>
>>
>> 2013/12/18 Baris Ergun <barisergun75 at gmail.com>
>>
>>> Hello
>>>
>>> I create a GeometryCollection as below
>>>
>>> GeometryCollection coll = new GeometryCollection(
>>>                             "SRID=-1;GEOMETRYCOLLECTIONM(POINTM(10 10
>>> 100),LINESTRINGM(0 50 100, 100 50 100),POLYGONM((25 25 100,75 25 100,75 75
>>> 100,25 75 100,25 25 100),(45 45 100,55 45 100,55 55 100,45 55 100,45 45
>>> 100)))"));
>>>
>>> when I reprint the coll.toString() I see that my geom string is changed
>>> to below :
>>>
>>> "SRID=-1;GEOMETRYCOLLECTIONM(POINT(10 10 100),LINESTRING(0 50 100, 100
>>> 50 100),POLYGON((25 25 100,75 25 100,75 75 100,25 75 100,25 25 100),(45 45
>>> 100,55 45 100,55 55 100,45 55 100,45 45 100)))"
>>>
>>> As you can see GEOMETRYCOLLECTIONM is preserved but POINTM LINESTRINGM
>>> and POLYGONM is changed to POINT LINESTRING and POLYGON . And because of
>>> this I get cannot mix dimensionality when I am trying to insert this geom
>>> to database.
>>>
>>> I have tried this with postgis jdbc driver 1.1.5; 1.3.3 and 2.0.1
>>> versions.
>>>
>>> This is a test written in datanucleus orm for geospatial extensions and
>>> the test is run against the below table (create script) in postgresql db.
>>>
>>> CREATE TABLE public.samplepggeometrycollectionm
>>> (
>>>   samplepggeometrycollectionm_id integer NOT NULL DEFAULT
>>> nextval('samplepggeometrycollectionm_samplepggeometrycollectionm_id_seq'::regclass),
>>>   geom geometry(GeometryCollectionM),
>>>   id bigint NOT NULL,
>>>   name character varying(255),
>>>   CONSTRAINT samplepggeometrycollectionm_pkey PRIMARY KEY
>>> (samplepggeometrycollectionm_id)
>>> )
>>> WITH (
>>>   OIDS=FALSE
>>> );
>>> ALTER TABLE public.samplepggeometrycollectionm
>>>   OWNER TO postgres;
>>>
>>> Awaiting ur suggestions.
>>> --
>>>  Baris
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
>
> --
> Barış
> www.linkedin.com/in/barisergun
>



-- 
Barış
www.linkedin.com/in/barisergun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131221/dda36009/attachment.html>