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

[Rémi Cura]

Hey,
you need to ad an entry to the "public.spatial_ref_sys" table
for your new srid.
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.

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131212/463431aa/attachment.html>