[postgis-users] Solved missing proj4text in spatial_ref_sys causing dump restore problems.

[Ben Madin]

Mea Culpa,

I was opening it in a text editor that was trimming whitespace from each line ending... (including tabs) .. before I committed it.

Although I still don't understand why no proj4text?

cheers

Ben




On 14/11/2011, at 1:35 PM, Ben Madin wrote:

> G'day all,
> 
> I'm having some problems with dumping / restoring a database, I think due to missing proj4text in the definitions. I'll preface this with a note that I don't want this particular projection, so I could just delete it, but the mechanism for the problem is intriguing me.
> 
> the problems are in the srid=2046 - 2055 range Hartebeesthoek94.
> 
> from sptatial_ref_sys.sql
> 
> ---
> --- EPSG 2046 : Hartebeesthoek94 / Lo15
> ---
> INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (2046,'EPSG',2046,'PROJCS["Hartebeesthoek94 / Lo15",GEOGCS["Hartebeesthoek94",DATUM["Hartebeesthoek94",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6148"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4148"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Transverse_Mercator_South_Orientated"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",15],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","2046"],AXIS["Y",WEST],AXIS["X",SOUTH]]','');
> 
> When I dump, I get :
> 
> 2046	EPSG	2046	PROJCS["Hartebeesthoek94 / Lo15",GEOGCS["Hartebeesthoek94",DATUM["Hartebeesthoek94",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6148"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4148"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Transverse_Mercator_South_Orientated"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",15],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","2046"],AXIS["Y",WEST],AXIS["X",SOUTH]]
> 
> with no extra whitespace (ie tabs) at the end, so my attempt to load ends with 
> 
> _postgis.dump:15201: ERROR:  missing data for column "proj4text"
> CONTEXT:  COPY spatial_ref_sys, line 476: "2046	EPSG	2046	PROJCS["Hartebeesthoek94 / Lo15",GEOGCS["Hartebeesthoek94",DATUM["Hartebeesthoek94",S..."
> 
> both the original database and the new one are in utf8, the file was dumped on my local machine and shared via subversion, but I'm still having the same problem on my local machine. 
> 
> I can get around it by deleting these before dumping, or maybe by using full inserts, but I'd rather not do that for size reasons - my questions are:
> 
> why has the space been lost, and
> has this never happened to anyone else, and 
> why does this group of projections not have proj4text?
> 
> cheers
> 
> Ben
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users