When GeoServer SQL Server stores won’t load on a new server We’ve been migrating a large GeoServer instance onto a new Windows 2019 server. The old GeoServer instance was running version 2.7, the new one version 2.15.1. Nearly everything “just worked” after... read more Posted by Crispin Flower 01 June 2020 Categories: GeoServer Comments(2)
How to remove .png files recursively from a folder tree without removing .png8 files too We have some large GeoWebCache caches of Ordnance Survey map tiles in .png8 format. Unfortunately a few million .png files have crept into the caches too (accidental bad config at some point),... read more Posted by Crispin Flower 27 May 2020 Categories: GeoServer Ordnance Survey Python Comments(0)
When MapServer refuses to run in an ASP.NET Core MVC site (401 - unauthorized) Well that was two hours I won’t get back, but I’ll make a note here in case it helps anyone else. I had simply overlooked one of those many tiny things…We use MapServer as a lightweight GIS engine in ... read more Posted by Crispin Flower 19 October 2019 Categories: .Net Core Cloudscribe MapServer WFS Comments(0)
A Guide to the Ordnance Survey Archaeological Records Our HBSMR application is for collecting and managing Historic Environment Record (HER) data, usually as the permanent inventory for an area, and sometimes for short-term data collection or research... read more Posted by Crispin Flower 07 April 2019 Categories: HBSMR Ordnance Survey Comments(3)
Configuring Geoserver with Geo web cache (GWC) The aim of this is to improve the performance of our mapping (obvious really I hope) both in terms of the speeds a user experiences and in terms of the number of users our server can support. In... read more Posted by 21 February 2019 Categories: GeoServer Comments(0)
Mapserver returning WFS attributes scrambled when using msplugin_mssql2008 plugin We recently upgraded Mapserver to the current version for a project because we wanted the WFS id field to be populated in geojson which required a recent version of (OGR >=2.3) which was included... read more Posted by 21 February 2019 Categories: MapServer SQL Server WFS Comments(0)
Using cloudscribe with Identity Server 4 with a SQL Server store on .Net Core 2 MVC securing APIs Well that’s a bit of a mouthful of a title – but it does describe what I was trying to do, and I didn’t find it easy. It’s not that complicated when you know how, but there are an awful lot of... read more Posted by 03 November 2017 Categories: .Net Core API Cloudscribe Identity Server 4 Security SQL Server Visual Studio Comments(6)
How to link SQL Server / RDBMS tables into MS Access without a DSN Linking tables from RDBMS like SQL Server into an Access front end doesn't need an ODBC DSN to be configured, it can be done with a one-liner. I’m just posting this here because I keep having to look ... read more Posted by Crispin Flower 30 March 2017 Categories: MS Access SQL Server Comments(0)
Opening ESRI Personal Geodatabases in QGIS In the more recent 64-bit versions of QGIS it is no longer possible to open ESRI personal geodatabases using the 'Add vector layer' functionality. However, it is possible to enable access to personal ... read more Posted by Steve Ellwood 01 March 2017 Categories: ArcGIS GIS (general) Quantum GIS (QGIS) Comments(4)
GeoServer WFS fails on SQL Server tables/views with GUID data type Just a quick note that might be useful to some. The problem... If you publish a SQL Server (in this case 2014) table or view with a GUID field using GeoServer (version 2.10), it will fail to... read more Posted by Crispin Flower 11 January 2017 Categories: GeoServer OGR/GDAL SQL Server WFS Comments(0)