<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16825" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=118175414-13052009>Genis,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><A
href="http://www.spatialreference.org/ref/epsg/23031/">http://www.spatialreference.org/ref/epsg/23031/</A></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=118175414-13052009><FONT face=Arial
color=#0000ff size=2>use the PostGIS isnert statement. i susually change
the srid to match the EPSG.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=118175414-13052009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=118175414-13052009><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=118175414-13052009><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Genís
Pujol Hamelink<BR><B>Sent:</B> Wednesday, May 13, 2009 10:44 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
spatial_ref_sys<BR></FONT><BR></DIV>
<DIV></DIV><BR clear=all>Hello list,<BR><BR>In the postgis datatable there is an
entry for the ED50 / 30N but not for ED50 / 31N and I need to add this into the
db:<BR><BR>PROJCS["ED_1950_UTM_Zone_31N",<BR>
GEOGCS["GCS_European_1950",<BR>
DATUM["European_Datum_1950",<BR>
SPHEROID["International_1924",
<DIV class="ii gt"
id=:1kh>6378388.0,297.0]],<BR>
PRIMEM["Greenwich",0.0],<BR>
UNIT["Degree",0.0174532925199433]],<BR>
PROJECTION["Transverse_Mercator"],<BR>
PARAMETER["False_Easting",500000.0],<BR>
PARAMETER["False_Northing",0.0],<BR>
PARAMETER["Central_Meridian",3.0],<BR>
PARAMETER["Scale_Factor",0.9996],<BR>
PARAMETER["Latitude_Of_Origin",0.0],<BR> UNIT["Meter",1.0]]<BR
clear=all><BR>I miss the info regarding the EPSG or the auth codes and I'm not
sure if I can add it as a custom dataset and make up those codes without braking
anything... <BR><BR>How can I add this into the db without braking anything?
sorry I'm a noob at gis... :)<BR><BR>regards, <BR><BR>Genis<BR></DIV><BR>--
<BR>Genís<BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>