[Qgis-developer] QGIS 0.8 requires an update to sterea [was: Re: 0.8; here I go]

[Stephan Holl]

Hello Maciej, 

On Wed, 26 Jul 2006 21:54:57 +0200 Maciej Sieczka <tutey at o2.pl> wrote:

> Maciek Sieczka napisal(a):
> 
> > On Wed, 5 Apr 2006 00:06:57 +0100
> > "Tim Sutton" <tim at linfiniti.com> wrote:
> 
> >>> 2.
> >>> Settings, Project properties, Projection:
> >>>
> >>> SRIDSs 172-175 (EPSG 2170-2174) declare "+proj=stere", while it
> >>> should be "sterea". Eg.:
> >>>
> >> 8<-----------snip -------------
> >>
> >>> Maciek
> >>>
> >>> Should I fill bug reports in Trac?
> >> Bug reports are good. Bug reports accompanied with fixes are even
> >> better! You will find under the svn checkout two sqlite.db files
> >> under
> >>
> >> qgis/resources
> >>
> >> qgis.db is the template for user database of srs's (its blank to
> >> start with for each user)
> >> srs.db is the system wide srs database.
> >>
> >> You are welcome to provide patches for the latter in the form of
> >> sql insert / update statements.
> 
> 
> Hi,
> 
> I have at least extracted all the projections which require updating
> from +proj=stere to +proj=sterea in QGIS 0.8.
> 
> In Proj 4.5 beta and Gdal 1.3.2 sterea is used in GDAL for 14 European
> stereographic grids (18 listed below, but 4 are duplicate
> "deprecated"):
> 
> $ grep -B1 '+proj=sterea' /usr/local/share/proj/epsg | awk '/^#/
> {print} /^</ {print $1" "$2}'
> 
> # NAD83(CSRS98) / New Brunswick Stereo (deprecated)
> <2036> +proj=sterea
> # Pulkovo 1942(58) / Poland zone I (deprecated)
> <2171> +proj=sterea
> # Pulkovo 1942(58) / Poland zone II
> <2172> +proj=sterea
> # Pulkovo 1942(58) / Poland zone III
> <2173> +proj=sterea
> # Pulkovo 1942(58) / Poland zone IV
> <2174> +proj=sterea
> # ATS77 / New Brunswick Stereographic (ATS77)
> <2200> +proj=sterea
> # ATS77 / Prince Edward Isl. Stereographic (ATS77)
> <2290> +proj=sterea
> # NAD83(CSRS98) / Prince Edward Isl. Stereographic (NAD83)
> (deprecated) <2291> +proj=sterea
> # NAD83(CSRS98) / Prince Edward Isl. Stereographic (NAD83)
> (deprecated) <2292> +proj=sterea
> # NAD83(CSRS) / New Brunswick Stereo
> <2953> +proj=sterea
> # NAD83(CSRS) / Prince Edward Isl. Stereographic (NAD83)
> <2954> +proj=sterea
> # Pulkovo 1942(58) / Poland zone I
> <3120> +proj=sterea
> # Pulkovo 1942(58) / GUGiK-80
> <3328> +proj=sterea
> # Deir ez Zor / Levant Stereographic
> <22780> +proj=sterea
> # Amersfoort / RD Old
> <28991> +proj=sterea
> # Amersfoort / RD New
> <28992> +proj=sterea
> # Dealul Piscului 1933/ Stereo 33
> <31600> +proj=sterea
> # Dealul Piscului 1970/ Stereo 70
> <31700> +proj=sterea
> 
> 
> It is necessary to update this in QGIS before 0.8 release to spare
> users problems and possible data corruption.
> 
> Sorry I can't do it myself. I hope this tip helps though.

This is a first one:

echo "UPDATE tbl_srs SET projection_acronym = 'sterea' WHERE
projection_acronym LIKE '%stere';"|sqlite3 resources/srs.db

The 'stere' in column parameter is even harder, but I cannot

Best regards

	Stephan

-- 
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office      -     Mengendamm 16d      -     D-30177 Hannover
Internet: www.gdf-hannover.de      -      Email: holl at gdf-hannover.de
Phone : ++49-(0)511.39088507       -        Fax: ++49-(0)511.39088508