[postgis-users] new projection for Postgis

[Torsten Lange]

Hello Frank, Mateusz,
as you have already known, like every one's Postgis even my Postgis has 
DHDN projection entries! I got confused with srids used by Qgis and 
Postgis: DHDN-srids in Qgis are something around 1800+ and Postgis-srids 
start at 2000. So fine, I learned that every Gis database holds a column 
"srid" a the geometry table meaning not that srids are standardised 
projection ID's :-) .

Thank you!!!
Torsten
 

Mateusz Loskot schrieb:
> Frank Koormann wrote:
>   
>> What does
>>
>>         SELECT srid FROM spatial_ref_sys WHERE srtext ~ 'DHDN';
>>
>> return? For me (running PostGIS 1.2.1) this results in 10 matching
>> entries.
>>     
>
> Change this query to read:
>
> SELECT srid, srtext FROM spatial_ref_sys WHERE srtext ~ 'DHDN';
>
> and you will see what it does.
> For more details, walk through following section of PostgreSQL manual:
>
> http://www.postgresql.org/docs/8.2/interactive/functions-matching.html
>
> Shortly, the query fetches all rows with DHDN token in srtext column,
> similarly to LIKE '%DHDN%' but ~ operator comes from regular expressions
> world.
>
> Cheers
>   


-- 
Geowissenschaftliches Zentrum
der Universitaet Goettingen
Abt. Angewandte Geologie
Goldschmidtstr. 3
37077 Goettingen
Deutschland

Tel.: Mo-Mi (Mo-We) +49-(0)551-39-19840
Tel.: Do-Fr (Th-Fr) +49-(0)551-39- 9397
Fax.: +49-(0)551-39-9379