gah, that happens for reading too quickly and replying without thinking. Looks like a bug indeed.
On Fri, Mar 30, 2012 at 1:52 PM, Rahkonen Jukka <[email protected]> wrote: > Hi, > > I did not read the original message propertly either. The real problem is > that the similar gml:Point leads to different axis order with wfs:Insert and > wfs:Update. Thas feels odd. > > -Jukka- > > > ________________________________________ > Lähettäjä: Gabriel Roldan [[email protected]] > Lähetetty: 30. maaliskuuta 2012 22:42 > Vastaanottaja: Rahkonen Jukka > Kopio: Sjoerd Brandsma; [email protected] > Aihe: Re: [Geoserver-users] XY get swapped after WFS-T Update with EPSG:3007 > > Jukka, you're right the transaction should come with the urn style crs > identifier. > The behavior is not a bug, is by design. As he's using WFS 1.1, the > urn style crs identifier should be used to respect the ESPG database > axis order. Using the "EPSG:xxx" crs style identifier to mean "force > X/Y lon/lat axis order" > > > Cheers, > Gabriel > > On Fri, Mar 30, 2012 at 1:05 AM, Rahkonen Jukka > <[email protected]> wrote: >> Hi, >> >> You are right, things should go in a similar way, right or wrong, with both >> inserts and updates. This feels like a bug. >> >> Could you have another try with this urn-style srsName >> urn:ogc:def:crs:EPSG::3007 >> >> And then it would not harm to add srsName also to the geometries in >> inserts/updates. Then there is less play with the defaults. We seem to get >> this kind of inputs for our system >> >> <gml:Point srsName="urn:ogc:def:crs:EPSG::3067"> >> <gml:pos srsDimension="2">385338.63323124044 6680121.5237366</gml:pos> >> </gml:Point> >> >> -Jukka Rahkonen- >> >> Sjoerd Brandsma wrote: >>> >>> Hi Jukka, >>> >>> Thanks for your answer. I'm not really an coordinate system export but >>> when it's an easting, northing issue things should also fail when >>> doing an insert? >>> >>> What basically happens (when using EPSG:3007 and Geoserver 2.1.1): >>> >>> Insert two values (let's call them A and B) with WFS-T insert. With >>> Postgresql this is read back as A,B >>> Update two values (let's call them A' and B') with WFS-T update. With >>> Postgresql this is read back as B', A' >>> >>> I cannot think of any reason why I should swap A and B when doing an >>> update and not doing this with an insert. >>> >>> >>> Thanks for your help. >>> >>> Best regards, >>> Sjoerd Brandsma >>> CycloMedia >>> >>> On Fri, Mar 30, 2012 at 6:26 AM, Rahkonen Jukka >>> <[email protected]> wrote: >>> > Hi, >>> > Are these EPSG data correct? >>> > >>> > >>> http://www.epsg-registry.org/report.htm?type=selection&entity= >> urn:ogc:def:crs:EPSG::3007&reportDetail=short&style=urn:uuid:report-> >> style:default-with-urn&style_name=OGP%20Default%20With%20Urn&title=swe >>> > >>> > It tells that the first coordinate is northing, second >>> easting. PostGIS lists coordinates always as easting, >>> northing. If EPSG info is t´right, you should flip the >>> coordinates in your update GML into >>> > <gml:pos> 6397415.081100176 145944.27274535838</gml:pos> >>> > >>> > -Jukka Rahkonen- >>> > ________________________________________ >>> > Sjoerd Brandsma wrote: >>> > >>> >> Hi, >>> > >>> >> I'm experiencing some weird problems with a WFS-T update >>> with EPSG:3007. >>> > >>> >> When inserting a point with the following transaction: >>> > >>> > <wfs:Transaction service="WFS" version="1.1.0" >>> > xmlns:wfs="http://www.opengis.net/wfs";> >>> > <wfs:Insert inputFormat="text/xml; subtype=gml/3.1.1" >>> srsName="EPSG:3007"> >>> > <SE:inventory_project_e45got_verkeer_2012 >>> > xmlns:SE="http://www.cyclomedia.se";> >>> > <SE:the_geom xlink:type="simple" >>> > xmlns:xlink="http://www.w3.org/1999/xlink";> >>> > <gml:Point xmlns:gml="http://www.opengis.net/gml";> >>> > <gml:pos>145944.27274535838 6397415.081100176</gml:pos> >>> > </gml:Point> >>> > </SE:the_geom> >>> > </SE:inventory_project_e45got_verkeer_2012> >>> > </wfs:Insert> >>> > </wfs:Transaction> >>> > >>> > The following PostgreSql is executed to get the point information: >>> > SELECT st_asewkt(the_geom) FROM >>> inventory_project_e45got_verkeer_2012 >>> > This gives the following (correct) result: >>> > "SRID=3007;POINT(145944.272745358 6397415.08110018)" >>> > >>> > Then an update transaction is performed: >>> > >>> > <wfs:Transaction service="WFS" version="1.1.0" >>> > xmlns:wfs="http://www.opengis.net/wfs";> >>> > <wfs:Update typeName="SE:inventory_project_e45got_verkeer_2012" >>> > inputFormat="text/xml; subtype=gml/3.1.1" srsName="EPSG:3007" >>> > xmlns:SE="http://www.cyclomedia.se";> >>> > <wfs:Property> >>> > <wfs:Name>SE:the_geom</wfs:Name> >>> > <wfs:Value> >>> > <gml:Point xmlns:gml="http://www.opengis.net/gml";> >>> > <gml:pos>145944.30681447688 6397415.045897427</gml:pos> >>> > </gml:Point> >>> > </wfs:Value> >>> > </wfs:Property> >>> > <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc";> >>> > <ogc:GmlObjectId >>> > gml:id="inventory_project_e45got_verkeer_2012.696" >>> > xmlns:gml="http://www.opengis.net/gml"/> >>> > </ogc:Filter> >>> > </wfs:Update> >>> > >>> > With the SQL query the point now has X and Y swapped >>> > "SRID=3007;POINT(6397415.04589743 145944.306814477)" >>> > >>> > >>> > Any idea what can be the problem here? >>> > >>> > Thanks, >>> > >>> > Sjoerd Brandsma >>> > CycloMedia >>> > >>> > >>> -------------------------------------------------------------- >>> ---------------- >>> > This SF email is sponsosred by: >>> > Try Windows Azure free for 90 days Click Here >>> > http://p.sf.net/sfu/sfd2d-msazure >>> > _______________________________________________ >>> > Geoserver-users mailing list >>> > [email protected] >>> > https://lists.sourceforge.net/lists/listinfo/geoserver-users >>> >> ------------------------------------------------------------------------------ >> This SF email is sponsosred by: >> Try Windows Azure free for 90 days Click Here >> http://p.sf.net/sfu/sfd2d-msazure >> _______________________________________________ >> Geoserver-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > -- > Gabriel Roldan > OpenGeo - http://opengeo.org > Expert service straight from the developers. -- Gabriel Roldan OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
