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
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
