SpatiaLite2 Provider - Bug fix

Topics: Data Access, SharpMap v2.0
Jun 15, 2009 at 12:23 PM

Hi I' ve made some changes in SpatiaLite2 Provider now it can work normally


SharpMap v.2.0

line 444
old: y.srtext as [SpatialReference]
new: y.ref_sys_name as [SpatialReference]

line 1113
old: string ssrid = ((string)result);
new: string ssrid = ((string)result).ToUpper();

best regards:


Jun 15, 2009 at 3:43 PM

Hi Faxy,

I admit, the spatialite-db's I use and set up have an extended spatial_ref_sys table. I add a column called srtext which is supposed to contain the WKT of the SRS.

You might want to consider setting up something like 

Upper( y.[auth_name] ) || ':' || y.[auth_srid] as [SpatialReference]

if you are sure that your SRS is defined in srs-list of the Proj4Utility project and you don't want that column at all.