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

[Frank Durstewitz]

Thanks Guido,

i found this record (and others which look similar), but it's not the 
same and i need the exact definition.

The data i have to examine is claimed to be the exactest data available 
for building positions in germany (top roof), and i have to verify this 
very careful, because the whole dataset is very expensive.

Anyone other ideas?

TIA, Frank


Guido Lemoine am 29.07.2008 08:56:
> 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
>>   
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3281 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080729/686adc3e/attachment.bin>