<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi, to use the grid file in order to transform from ETRS89 to ED50
and viceversa you should download the .gsb (PENR2009.gsb in the
example) file from the IGN web site and copy that file to your proj4
directory.<br>
<br>
Then modify the spatial_Ref_sys with (change the utm zone if you
need it):<br>
<br>
update spatial_ref_sys set proj4text = '+proj=utm +zone=30
+ellps=GRS80 +units=m +no_defs +nadgrids=null' where srid =25830;<br>
update spatial_ref_sys set proj4text = '+proj=utm +zone=30
+ellps=intl +units=m +no_defs +nadgrids=PENR2009.gsb' where srid =
23030;<br>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 14">
<meta name="Originator" content="Microsoft Word 14">
<link rel="File-List"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml">
<link rel="themeData"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx">
<link rel="colorSchemeMapping"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-134238209 -371195905 63 0 4129279 0;}
@font-face
{font-family:"\@Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-134238209 -371195905 63 0 4129279 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:3.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-align:justify;
text-indent:14.2pt;
mso-pagination:none;
font-size:10.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Arial Unicode MS";
mso-ansi-language:ES-TRAD;
mso-fareast-language:JA;}
p.ejemplosql, li.ejemplosql, div.ejemplosql
{mso-style-name:ejemplosql;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
margin-top:5.65pt;
margin-right:0cm;
margin-bottom:5.65pt;
margin-left:28.4pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpFirst, li.ejemplosqlCxSpFirst, div.ejemplosqlCxSpFirst
{mso-style-name:ejemplosqlCxSpFirst;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:5.65pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:28.4pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpMiddle, li.ejemplosqlCxSpMiddle, div.ejemplosqlCxSpMiddle
{mso-style-name:ejemplosqlCxSpMiddle;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:28.4pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpLast, li.ejemplosqlCxSpLast, div.ejemplosqlCxSpLast
{mso-style-name:ejemplosqlCxSpLast;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:5.65pt;
margin-left:28.4pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
span.ejemplosqlCar
{mso-style-name:"ejemplosql Car";
mso-style-unhide:no;
mso-style-locked:yes;
mso-style-link:ejemplosql;
mso-ansi-font-size:8.0pt;
font-family:"Courier New";
mso-ascii-font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-hansi-font-family:"Courier New";
mso-fareast-language:ES;
font-weight:bold;
mso-bidi-font-weight:normal;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
mso-fareast-language:JA;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>update spatial_ref_sys set proj4text = '+proj=longlat
+ellps=intl +units=m nadgrids=PENR2009.gsb +no_defs' where srid =
4230;<br>
update spatial_ref_sys set proj4text = '+proj=longlat +ellps=GRS80
+towgs84=0,0,0,0,0,0,0 +no_defs' where srid = 4258;<br>
<br>
after that you can check it out using:<br>
<br>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
with tabla (geom) as (<br>
select st_geomfromtext ('POINT (465348.7823 4473240.8768)',23030)<br>
)<br>
select 'to25830' as crs, st_astext(st_transform (geom, 25830)) from
tabla<br>
union all<br>
select 'to4230', st_astext(st_transform (geom, 4230)) from tabla<br>
union all<br>
select 'to4258', st_astext(st_transform (geom, 4258)) from tabla;<br>
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 14">
<meta name="Originator" content="Microsoft Word 14">
<link rel="File-List"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml">
<link rel="themeData"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx">
<link rel="colorSchemeMapping"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-134238209 -371195905 63 0 4129279 0;}
@font-face
{font-family:"\@Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-134238209 -371195905 63 0 4129279 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:3.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-align:justify;
text-indent:14.2pt;
mso-pagination:none;
font-size:10.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Arial Unicode MS";
mso-ansi-language:ES-TRAD;
mso-fareast-language:JA;}
p.ejemplosql, li.ejemplosql, div.ejemplosql
{mso-style-name:ejemplosql;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
margin-top:5.65pt;
margin-right:0cm;
margin-bottom:5.65pt;
margin-left:28.4pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpFirst, li.ejemplosqlCxSpFirst, div.ejemplosqlCxSpFirst
{mso-style-name:ejemplosqlCxSpFirst;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:5.65pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:28.4pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpMiddle, li.ejemplosqlCxSpMiddle, div.ejemplosqlCxSpMiddle
{mso-style-name:ejemplosqlCxSpMiddle;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:28.4pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpLast, li.ejemplosqlCxSpLast, div.ejemplosqlCxSpLast
{mso-style-name:ejemplosqlCxSpLast;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:5.65pt;
margin-left:28.4pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
span.ejemplosqlCar
{mso-style-name:"ejemplosql Car";
mso-style-unhide:no;
mso-style-locked:yes;
mso-style-link:ejemplosql;
mso-ansi-font-size:8.0pt;
font-family:"Courier New";
mso-ascii-font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-hansi-font-family:"Courier New";
mso-fareast-language:ES;
font-weight:bold;
mso-bidi-font-weight:normal;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
mso-fareast-language:JA;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style><br>
and you must get this result:<br>
<br>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
crs | st_astext <br>
---------+-------------------------------------------<br>
to25830 | POINT(465239.372687467 4473032.96844837)<br>
to4230 | POINT(-3.40836762519858 40.4083676249853)<br>
to4258 | POINT(-3.40966841871938 40.40718544315)<br>
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 14">
<meta name="Originator" content="Microsoft Word 14">
<link rel="File-List"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml">
<link rel="themeData"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx">
<link rel="colorSchemeMapping"
href="file:///C:%5CUsers%5CJOMARL%7E1.UPV%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-134238209 -371195905 63 0 4129279 0;}
@font-face
{font-family:"\@Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:128;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-134238209 -371195905 63 0 4129279 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:3.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-align:justify;
text-indent:14.2pt;
mso-pagination:none;
font-size:10.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Arial Unicode MS";
mso-ansi-language:ES-TRAD;
mso-fareast-language:JA;}
p.ejemplosql, li.ejemplosql, div.ejemplosql
{mso-style-name:ejemplosql;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
margin-top:5.65pt;
margin-right:0cm;
margin-bottom:5.65pt;
margin-left:28.4pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpFirst, li.ejemplosqlCxSpFirst, div.ejemplosqlCxSpFirst
{mso-style-name:ejemplosqlCxSpFirst;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:5.65pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:28.4pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpMiddle, li.ejemplosqlCxSpMiddle, div.ejemplosqlCxSpMiddle
{mso-style-name:ejemplosqlCxSpMiddle;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:28.4pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
p.ejemplosqlCxSpLast, li.ejemplosqlCxSpLast, div.ejemplosqlCxSpLast
{mso-style-name:ejemplosqlCxSpLast;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-link:"ejemplosql Car";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:5.65pt;
margin-left:28.4pt;
mso-add-space:auto;
text-indent:-14.2pt;
mso-pagination:lines-together;
mso-hyphenate:none;
font-size:8.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-bidi-font-family:"Times New Roman";
font-weight:bold;
mso-bidi-font-weight:normal;}
span.ejemplosqlCar
{mso-style-name:"ejemplosql Car";
mso-style-unhide:no;
mso-style-locked:yes;
mso-style-link:ejemplosql;
mso-ansi-font-size:8.0pt;
font-family:"Courier New";
mso-ascii-font-family:"Courier New";
mso-fareast-font-family:"Arial Unicode MS";
mso-hansi-font-family:"Courier New";
mso-fareast-language:ES;
font-weight:bold;
mso-bidi-font-weight:normal;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
mso-fareast-language:JA;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style><br>
which means PostGIS is using the ntv2 grid file with CRS: 4258,
4230, 23030 and 25830.<br>
Regards,<br>
Jose<br>
<br>
<br>
On 17/05/2012 19:20, José María Amuedo wrote:
<blockquote
cite="mid:CANVkuyjGtqdmice-98P9rZGnUxYCa9oANifXccOOvfia+i0tFQ@mail.gmail.com"
type="cite">Buenas, <br>
<br>
Me gustaría saber si Postgis puede gestionar la información
topológica a través de la rejilla elaborada por el IGN y no tener
problemas de cálculos de mediciones.<br>
<br>
Saludos,<br>
<br>
Jose Maria<br>
<br>
Hello,<br>
<br>
I would like to know if it is possible working with geographic
information with spanish ETRS89 projection in Postgis.<br>
<br>
Wishes,<br>
<br>
Jose Mariai<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
------------------------------
José Carlos Martínez Llario
Producción Cartográfica y SIG.
Dpto. Ingeniería Cartográfica.
Univ. Politécnica de Valencia.
E-mail: <a class="moz-txt-link-abbreviated" href="mailto:jomarlla@cgf.upv.es">jomarlla@cgf.upv.es</a>
Telf: 963877000 ext. 75599
------------------------------
</pre>
</body>
</html>