Create spatial_ref_sys entry from srtext ?

From: Arnaud Lesauvage <thewild(at)free(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Create spatial_ref_sys entry from srtext ?
Date: 2006-07-28 09:44:17
Message-ID: 44C9DC71.1080103@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list !

I received a bunch of shapefiles with a .prj file.
I can't find the projection in the spatial_ref_sys table (it looks
quite strange, it says "IGNBelg_Lam72").
How can I insert a record for this projection in the
spatial_ref_sys table ?

Here is the .prj file content :
PROJCS["IGNBelg_Lam72",
GEOGCS["Hayford 1924",
DATUM["<custom>",
SPHEROID["International_1924",6378388.0,297.0]
],
PRIMEM["Greenwich",0.0],
UNIT["Degree",0.0174532925199433]
],
PROJECTION["Lambert_Conformal_Conic"],
PARAMETER["False_Easting",150000.013],
PARAMETER["False_Northing",5400088.438],
PARAMETER["Central_Meridian",4.367486666667],
PARAMETER["Standard_Parallel_1",49.83333389],
PARAMETER["Standard_Parallel_2",51.16666729],
PARAMETER["Scale_Factor",1.0],
PARAMETER["Latitude_Of_Origin",90.0],
UNIT["Meter",1.0]
]

Thanks a lot !

Regards
--
Arnaud

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DANTE Alexandra 2006-07-28 10:00:19 Questions about update, delete, ctid...
Previous Message Arnaud Lesauvage 2006-07-28 09:39:45 Re: PostgreSQL and Windows 2003 DFS Replication