Italian Sardinia custom proj is wrong

[lucacasagrande]

Hello folks, the proj string for custom Italian Sardinia projection is wrong because it has got 2 towgs84 setting.
The right one is this:

+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-168.6,-34.0,38.6,-0.374,-0.679,-1.379,-9.48 +no_defs

I think that would be better to add GB Roma40 to the name of each custom projections.

Thanks
Luca

[timlinux]

r12821 implements these updates. For the record:

update tbl_srs set description = description || ' GB Roma40' where srs_id > 3639;
update tbl_srs set parameters='+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-168.6,-34.0,38.6,-0.374,-0.679,-1.379,-9.48 +no_defs' where srs_id=3643;

[lucacasagrande]

I noticed that towgs84 parameters are not right for Italy. According to GRASS those are the right ones:

ROMA40 Fuso 1 Peninsular +proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +no_defs

ROMA40 fuso 2 Peninsular +proj=tmerc +lat_0=0 +lon_0=15 +k=0.9996 +x_0=2520000 +y_0=0 +ellps=intl +units=m +towgs84=-104. 1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +no_def

ROMA 40 Sardinia +proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-168.6,-34.0,38.6,-0.374,-0.679,-1.379,-9.48 +no_defs

ROMA 40 Sicily +proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-50.2,-50.4,84.8,-0.690,-2.012,0.459,-28.08 +no_def

[niccolo]

Please note that there are also unwanted spaces as in "-104. 1", etc.

I attach the SQL statements to fix 3 entries in the database (only one is correct).

[jef]

applied in r13266. Thanks.