[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Projection problem
From: Jaime Fiers <jaime.fiers () gmail ! com>
Date: 2010-07-24 11:13:45
Message-ID: AANLkTik2j8mLKklj1EYIFNBQepuD_BlgEVknsbStpyyb () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Ralf.
You gave me the correct way. Thanks a lot.
Finally, I used a similar SQL, with the double transformation you said, and
result is good:
CREATE OR REPLACE VIEW vista_23030 AS
SELECT "GID", transform_geometry(transform( geom, 4326), '+proj=longlat
+ellps=WGS84 +datum=WGS84 +no_defs '::text, '+proj=utm +ellps=intl +zone=30
+units=m +towgs84=-131,-100.3,-163.4,-1.244,-0.02,-1.14 +no_defs'::text,
23030)
AS geom
FROM capa_25830;
Regards
Jaime
2010/7/23 Ralf Suhr <Ralf.Suhr@itc-halle.de>
> Hi Jaime,
>
> to get transformation with towgs84 parameter working you have to use wgs84
> ellipsoid. Transform from ETRS89 to wgs84 and second from wgs84 to ED50.
>
> ST_Transform(ST_Transform( 25830_geom, 4326), 23030)
>
> Gr
> Ralf
>
> Am Freitag 23 Juli 2010, 08:42:39 schrieb Jaime Fiers:
> > Hello guys
> >
> > I hava a "little" problem with Postgis projection.
> >
> > I need get a reprojected view. Original data layer is in SRS=25830
> (ETRS89
> > UTM30) and view in SRS=23030 (ED50 UTM30)
> >
> > I try this:
> >
> > CREATE OR REPLACE VIEW vista_23030 AS
> > SELECT id, transform_geometry("GEOMETRY", '+proj=utm +zone=30
> +ellps=GRS80
> > +units=m +no_defs
> >
> +towgs84=131.0,100.3,163.4,1.2439999999999989,0.01999999999999998,1.1439999
> > 999999988,-9.39 '::text,
> > '+proj=utm +zone=30 +ellps=intl +units=m +nadgrids +no_defs'::text,
> 23030)
> > AS "GEOMETRY"
> > FROM capa_25830;
> >
> > (If we do not include "+nadgrids" we don't get anything, but that is not
> a
> > problem).
> > I always get a +-90 meter error.
> >
> > Can anybody help me.
> >
> > Thanks in advance
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
[Attachment #5 (text/html)]
Hi Ralf.<br><br>You gave me the correct way. Thanks a lot.<br><br>Finally, I used a \
similar SQL, with the double transformation you said, and result is good:<br><br><br> \
CREATE OR REPLACE VIEW vista_23030 AS <br> SELECT "GID", \
transform_geometry(transform( geom, 4326), '+proj=longlat +ellps=WGS84 \
+datum=WGS84 +no_defs '::text, '+proj=utm +ellps=intl +zone=30 +units=m
+towgs84=-131,-100.3,-163.4,-1.244,-0.02,-1.14 +no_defs'::text, 23030)<br>
AS geom<br>
FROM capa_25830;<br><br>Regards<br>Jaime<br><br><div class="gmail_quote">2010/7/23 \
Ralf Suhr <span dir="ltr"><<a \
href="mailto:Ralf.Suhr@itc-halle.de">Ralf.Suhr@itc-halle.de</a>></span><br><blockquote \
class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, \
204, 204); padding-left: 1ex;"> Hi Jaime,<br>
<br>
to get transformation with towgs84 parameter working you have to use wgs84<br>
ellipsoid. Transform from ETRS89 to wgs84 and second from wgs84 to ED50.<br>
<br>
ST_Transform(ST_Transform( 25830_geom, 4326), 23030)<br>
<br>
Gr<br>
Ralf<br>
<br>
Am Freitag 23 Juli 2010, 08:42:39 schrieb Jaime Fiers:<br>
<div><div></div><div class="h5">> Hello guys<br>
><br>
> I hava a "little" problem with Postgis projection.<br>
><br>
> I need get a reprojected view. Original data layer is in SRS=25830 (ETRS89<br>
> UTM30) and view in SRS=23030 (ED50 UTM30)<br>
><br>
> I try this:<br>
><br>
> CREATE OR REPLACE VIEW vista_23030 AS<br>
> SELECT id, transform_geometry("GEOMETRY", '+proj=utm +zone=30 \
+ellps=GRS80<br> > +units=m +no_defs<br>
> +towgs84=131.0,100.3,163.4,1.2439999999999989,0.01999999999999998,1.1439999<br>
> 999999988,-9.39 '::text,<br>
> '+proj=utm +zone=30 +ellps=intl +units=m +nadgrids +no_defs'::text, \
23030)<br> > AS "GEOMETRY"<br>
> FROM capa_25830;<br>
><br>
> (If we do not include "+nadgrids" we don't get anything, but that \
is not a<br> > problem).<br>
> I always get a +-90 meter error.<br>
><br>
> Can anybody help me.<br>
><br>
> Thanks in advance<br>
</div></div>_______________________________________________<br>
postgis-users mailing list<br>
<div class="im"><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
</div><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</blockquote></div><br>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic