[postgis-users] Re: Error in SPATIAL_REF_SYS table

[Barend Köbben]

Thanks Bart for the tip, but... 

I tried it and although it generaly works and is indeed better then the fixed table in some aspects, it does not solve my problem as I found out the EPSG database actually holds the wrong projection for the Rijksdriehoeksstelsel (Dutch National Grid)!

Worse, it introduces a second problem:
I use the Safe Software FME translations to get data from ArcGIS to PostGIS, but the conversion fails, because the FME engine cannot INSERT in a view... The cause is that the ArcGIS RijksDriehoekstelsel is the correct one, and thus not the same as the EPSG srid 28992. FME then breaks, in the sense that it tries to create a USER entry in the table, which fails because it cannot INSERT into a View. I do not think that Patrick van Laake has to worry about that too much, as I find the FME translator having many other quirks and strange behaviours, so before it's really usefull  they/I  need to address these first.

FYI: FME  doesn't create a primary key, making PostGIS unstable and the attribute data unreachable from ArcGIS, and when it CAN write to the spatial_ref_sys it seems to ignore any  user-defined SRS it created itself [sic!] and just inserts something like LOCAL_CS["NonEarth_Meter",UNIT["METER",1]]...

To be continued...

____________________________

Barend Köbben
International Institute for Geo-information 
Sciences and Earth Observation (ITC) 
PO Box 6, 7500AA Enschede (The Netherlands)
ph: +31 (0)53 4874253; fax: +31 (0)53 4874335


 

> -----Original Message-----
> From: Bart van den Eijnden [mailto:BEN at Syncera-ITSolutions.NL] 
> Sent: 09 November 2005 09:39
> To: Barend Köbben; postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Error in SPATIAL_REF_SYS table
> 
> You could give this a try (srid and srtext from EPSG database):
> 
> http://postgis.refractions.net/pipermail/postgis-users/2005-No
> vember/009848.html
> 
> Best regards,
> Bart
> 
> Bart van den Eijnden
> Syncera IT Solutions
> Postbus 270
> 2600 AG  DELFT
> 
> tel.nr.: 015-7512436
> email: BEN at Syncera-ITSolutions.nl
> >>> kobben at itc.nl 11/09/05 8:59 AM >>>
> Hi there,
> 
> I just started using PostGIS instead of the Spatial 
> Extensions of MySQL, mainly because of the lack of SRID 
> support in the latter. Everything went nicely until 
> yesterday, when I found that there's an error in the 
> SPATIAL_REF_SYS table for the Dutch National Grid. This, 
> officialy called "RijksDriehoeksstelsel" is defined with 
> Projection = Oblique Stereographic. But it should be Double 
> Stereographic...
> 
> All the other coordinates seem right, but the result is still 
> an offset of about 2 meters when combined with properly 
> projected data....
> 
> Any ideas on how this could be remedied, or should I file a 
> bug report?
> 
> ____________________________
> 
> Barend Köbben
> International Institute for Geo-information 
> Sciences and Earth Observation (ITC) 
> PO Box 6, 7500AA Enschede (The Netherlands)
> ph: +31 (0)53 4874253; fax: +31 (0)53 4874335
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

____________________________

Barend Köbben
International Institute for Geo-information 
Sciences and Earth Observation (ITC) 
PO Box 6, 7500AA Enschede (The Netherlands)
ph: +31 (0)53 4874253; fax: +31 (0)53 4874335


 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Patrick
> Sent: 09 November 2005 13:47
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Re: Error in SPATIAL_REF_SYS table
> 
> 
> "Bart van den Eijnden" <BEN at Syncera-ITSolutions.NL> wrote in message 
> news:s371c3c4.003 at SRV-POSTIX-DFT...
> > You could give this a try (srid and srtext from EPSG database):
> >
> > 
> http://postgis.refractions.net/pipermail/postgis-users/2005-No
> vember/009848.html
> 
> Hi Bart,
> 
> I don't think this would be a real solution, because the 
> PostGIS WKT strings 
> are extracted from the EPSG database as well. If it does work 
> it is probably 
> because the EPSG database, latest version 6.8, has had this 
> record updated, 
> while PostGIS WKT strings have been extracted from an earlier version.
> 
> Cheers,
> Patrick 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>