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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
