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

[Paul Ramsey]

We need patches for Java issues as we have no active JDBC/Java maintainers ATM.

P.

On Sat, Dec 21, 2013 at 11:31 AM, Baris Ergun <barisergun75 at gmail.com> wrote:
> I have tested the issue with latest snapshot 2.1.0SVN for  jdbc driver. The
> GeometryCollection still cannot parse the String value correctly. There is a
> similar issue in postgis extension source codes.
> http://trac.osgeo.org/postgis/ticket/724
>
> So with the Java based jdbc codes it looks like we hit the same case. If I
> could report this as a bug to trac I would do it right away but I dont have
> access to there.
>
>
> On 21 December 2013 11:57, Baris Ergun <barisergun75 at gmail.com> wrote:
>>
>> 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
>
>
>
>
> --
> Barış
> www.linkedin.com/in/barisergun
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users