[postgis-users] How can get EPSG 15948 into PG?

[Rémi Cura]

Hey,

first you add your custom projection to qgis, so you can check that
everything is good.
For this go in the "options/custom projection" and add yours.
If you already have a shapefile with this projection, just import it in
qgis and save the created "user defined projection".

When you know you have the right parameters for this projection, you insert
it in the spatial_ref_sys :
insert into public.spatial_ref_sys values (
srid , --don't take one already used
  auth_name , --what you want
  auth_srid  , --don't take one already used
  srtext  , --copy paste from qgis
  proj4text  ) --copy past from qgis

an example :
 insert into spatial_ref_sys values (110014000,'IGNF',110014000,'GEOCCS["Ile
d Amsterdam 1963",DATUM["Ile Amsterdam 1963 (carte
1:25000)",SPHEROID["International-Hayford
1909",6378388.0000,297.0000000000000,AUTHORITY["IGNF","ELG001"]],TOWGS84[109.7530,-528.1330,-362.2440,0,0,0,0],AUTHORITY["IGNF","REG014"]],PRIMEM["Greenwich",0.000000000,AUTHORITY["IGNF","LGO01"]],UNIT["metre",1],AXIS["X",OTHER],AXIS["Y",EAST],AXIS["Z",NORTH],AUTHORITY["IGNF","AMST63"]]'
,'+init=IGNF:AMST63');


Cheers,
Rémi-C


2013/12/12 Andreas Laggner <andreas.laggner at ti.bund.de>

>
> Am 12.12.2013 17:27, schrieb Rémi Cura:
>
>  Hey,
>> you need to ad an entry to the "public.spatial_ref_sys" table
>> for your new srid.
>>
> ok, i understand that theoretically - but my question is how can i ad an
> entry to the "public.spatial_ref_sys" table
>
>  You can use QGis before this to ensure the definition you have is correct.
>>
>> Then you use ST_Transform and ST_SetSRID with your data.
>>
> ... and i do not understand that  ;-)
> QGis does not know 15948 too. Is that the way to ad my entry?
>
> Thanks        Andreas
>
>
>
>
>> Cheers
>> Rémi C
>>
>>
>> 2013/12/12 Andreas Laggner <andreas.laggner at ti.bund.de>
>>
>>  Hi list,
>>>
>>> epsg 15948 is needed to transform from DE_DHDN(BeTA, 2007) (for example
>>> 31467) to ETRS89.
>>>
>>> BUT epsg 15948 is neither available in spatial_ref_sys (postgis 2.1) nor
>>> at http://spatialreference.org!!
>>>
>>> I have about 10.000 tables in 31467, because that was standard in germany
>>> last years, but since some years ETRS89 is standard, many new datasets
>>> are
>>> in ETRS89 now and i cannot transform from DE_DHDN to ETRS89!
>>>
>>> I downloaded a sql from http://www.epsg.org with all the epsg-codes but
>>> i
>>> don know how to use it in PostGIS.
>>>
>>> Thanks for help.
>>>
>>> --
>>> Dipl. Geoökologe Andreas Laggner
>>>
>>> Thünen-Institut für Agrarklimaschutz (AK)
>>> Arbeitsgruppe Emissionsinventare
>>> Johann Heinrich von Thünen-Institut (vTI),
>>> Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei
>>>
>>> Thünen Institute of Climate-Smart Agriculture
>>> Johann Heinrich von Thünen Institute (vTI),
>>> Federal Research Institute for Rural Areas, Forestry and Fisheries
>>>
>>> Bundesallee 50
>>> D-38116 Braunschweig
>>>
>>> Tel.: (+49) (0)531 596 2636
>>> Fax : (+49) (0)531 596 2645
>>> E-mail: andreas.laggner at ti.bund.de
>>> Homepage: http://www.ti.bund.de
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>>
> --
> Dipl. Geoökologe Andreas Laggner
>
> Thünen-Institut für Agrarklimaschutz (AK)
> Arbeitsgruppe Emissionsinventare
> Johann Heinrich von Thünen-Institut (vTI),
> Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei
>
> Thünen Institute of Climate-Smart Agriculture
> Johann Heinrich von Thünen Institute (vTI),
> Federal Research Institute for Rural Areas, Forestry and Fisheries
>
> Bundesallee 50
> D-38116 Braunschweig
>
> Tel.: (+49) (0)531 596 2636
> Fax : (+49) (0)531 596 2645
> E-mail: andreas.laggner at ti.bund.de
> Homepage: http://www.ti.bund.de
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131212/18c6b5e6/attachment.html>