Post List - Exegesis Spatial Data Management

When GeoServer SQL Server stores won’t load on a new server

Posted by Crispin Flower 01 June 2020 Categories: GeoServer

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

Comments(2)

How to remove .png files recursively from a folder tree without removing .png8 files too

Posted by Crispin Flower 27 May 2020 Categories: GeoServer Ordnance Survey Python

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

Comments(0)

When MapServer refuses to run in an ASP.NET Core MVC site (401 - unauthorized)

Posted by Crispin Flower 19 October 2019 Categories: .Net Core Cloudscribe MapServer WFS

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

Comments(0)

A Guide to the Ordnance Survey Archaeological Records

Posted by Crispin Flower 07 April 2019 Categories: HBSMR Ordnance Survey

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

Comments(4)

Configuring Geoserver with Geo web cache (GWC)

Posted by 21 February 2019 Categories: GeoServer

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

Comments(0)

Mapserver returning WFS attributes scrambled when using msplugin_mssql2008 plugin

Posted by 21 February 2019 Categories: MapServer SQL Server WFS

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

Comments(0)

Using cloudscribe with Identity Server 4 with a SQL Server store on .Net Core 2 MVC securing APIs

Posted by 03 November 2017 Categories: .Net Core API Cloudscribe Identity Server 4 Security SQL Server Visual Studio

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

Comments(6)

How to link SQL Server / RDBMS tables into MS Access without a DSN

Posted by Crispin Flower 30 March 2017 Categories: MS Access SQL Server

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

Comments(0)

Opening ESRI Personal Geodatabases in QGIS

Posted by Steve Ellwood 01 March 2017 Categories: ArcGIS GIS (general) Quantum GIS (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

Comments(4)

GeoServer WFS fails on SQL Server tables/views with GUID data type

Posted by Crispin Flower 11 January 2017 Categories: GeoServer OGR/GDAL SQL Server WFS

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

Comments(0)

Categories

Archives