[postgis-users] "Deutsches Hauptdreiecksnetz" missing in spatial_ref_sys

[Guido Lemoine]

Frank,

Look at EPSG=31469

"PROJCS["DHDN / Gauss-Kruger zone 
5",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 
1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",15],PARAMETER["scale_factor",1],PARAMETER["false_easting",5500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","31469"]]"

GL

Frank Durstewitz wrote:
> Hi together,
>
> please, can someone convert the prj definition below into a insert 
> statement for use in spatial_ref_sys?
>
> I got some data for evaluation, but since the datum is not in my 
> spatial_ref_sys, i'm stuck. And i'm not sure how to create the 
> necessary sql.
>
> PROJCS["Transverse_Mercator",GEOGCS["Geographic Coordinate 
> System",DATUM["D_DEUTSCHES_HAUPTDREIECKSNETZ",SPHEROID["Bessel 
> 1841",6377397.155,299.1528131060786]], 
> PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433]], 
> PROJECTION["Transverse_Mercator"],PARAMETER["scale_factor",1], 
> PARAMETER["central_meridian",12],PARAMETER["latitude_of_origin",0], 
> PARAMETER["false_easting",4500000], 
> PARAMETER["false_northing",0],UNIT["Meter",1]]
>
> TIA, Frank
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   

-- 
----------------------------------------------------------------
Guido Lemoine
Joint Research Centre, European Commission
Institute for the Protection and Security of the Citizen (IPSC)
Support to External Security
Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
WWW: http://ses.jrc.it
----------------------------------------------------------------
Disclaimer:
Views expressed are those of the individual and do not represent 
the views of the European Commission