[postgis-users] EPSG and Spatial ref system table

[Stone, Matthew (DHS-HISP)]

I am having trouble seeing a test layer of my PostGIS data projected correctly.  California uses a NAD 27 Teale-Albers projection that I tried to implement in the spatial-ref-sys table by generating the following srtext and proj4 text.  However, I had to create a "madeup" EPSG code since there is not one that I could find from the standard proj4 library that ships with PostGIS.  Can anyone assist or tell me what I should try to do?  


I am testing with Geoserver....


Matthew

SRTEXT:
PROJCS["NAD27 / CA Teale-Albers",GEOGCS["NAD27",DATUM["D_North_American_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],UNIT["Meter",1.0]]";"

PROJ4 Text
+proj=aea +lat_1=34 +lat_2=40.5 +lat_0=0 +lon_0=-120 +x_0=0 +y_0=0 +ellps=clrk66 +datum=NAD27 +units=m +no_defs "

Matthew Stone, MPH
UCSF/CA Dept. of Health Services
Health Information & Strategic Planning (HISP)
Office of County Health Services (OCHS)
1501 Capitol Ave MS 5204
Mailing Address:
PO BOX 997413, MS 5204
Sacramento CA 95899-7413
Physical Address:
1501 Capitol Avenue, Suite 71.5195, MS 5204
Sacramento, CA 95814
_____________________________
PH: 916-552-9918
FAX: 916-552-8024 or 916-552-8260
mstone at dhs.ca.gov