[postgis-users] Re: Initial SRS and geometry columms table creation

[Mark Wright]

This will get it into your database:

insert into spatial_ref_sys
(srid,auth_name,auth_srid,srtext,proj4text) values
(3310,'EPSG',3310,'PROJCS["Custom",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS
1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0],PARAMETER["False_Northing",-4000000],PARAMETER["Central_Meridian",-120],PARAMETER["Standard_Parallel_1",34],PARAMETER["Standard_Parallel_2",40.5],UNIT["Meter",1]]','+proj=aea
+lat_1=34.00 +lat_2=40.50 +lat_0=0.00 +lon_0=-120.00 +x_0=0.000
+y_0=-4000000.000 +ellps=GRS80 +units=m +datum=NAD83');

You can get the srtext for this and the nad27 projection from the
projections file at ftp://casil.ucdavis.edu


Mark

On 12/16/05, Patrick <pvanlaake at users.sourceforge.net> wrote:
>
> "Ivan Kautter" <ivankautter at hotmail.com> wrote in message
> news:BAY106-F190AFD4ED9D81CD3281610B7380 at phx.gbl...
> >
> > Lastly, I have a spatial reference system that is not defined in EPSG.  It
> > is a system for the entire state of California in NAD83 defined thusly:
> >
> >  # California ALBERS projection information
> >  PROJECTION
> >    "proj=aea"
> >    "y_0=-4000000.0"
> >    "lon_0=-120.0"
> >    "lat_0=0.0"
> >    "lat_1=34.0"
> >    "lat_2=40.5"
> >    "units=m"
> >    "ellps=GRS80"
> >    "datum=NAD83"


--
Have fun or die trying - but try not to actually die.
http://www.AboveCalifornia.com
Got Mac OS X? Get the AboveCalifornia Sherlock Channel:
sherlock://www.AboveCalifornia.com/sherlock/SherlockChannel.xml?action=add