Post List - Exegesis Spatial Data Management

When GeoServer forgets about GeoWebCache

Posted by Crispin Flower 05 March 2013 Categories: GeoServer GIS (general) WMS

I’ve been setting up some new mapping services (WMS) in GeoServer, with GeoWebCache allowing the map tiles to be cached for performance. For this to work, and for the WMS to use its cache of tiles,... read more

Comments(0)

Transferring user accounts from ASP.NET to MojoPortal

Posted by 04 March 2013 Categories: mojoPortal SQL Server

Occasionally we need to transfer user accounts from existing ASP.NET membership based sites into MojoPortal Note : if the databases are on the same server, or can be linked, then it is possible to ... read more

Comments(0)

QGIS field calculator backslash gotcha

Posted by Crispin Flower 28 February 2013 Categories: Quantum GIS (QGIS)

Quantum GIS has a powerful field calculator, similar to that in ArcGIS, and described here. I was using it to update a tile index shapefile for use with GeoServer and a folder full of georeferenced... read more

Comments(0)

How to set the spell checking language in CKEditor as used in mojoPortal

Posted by Crispin Flower 14 February 2013 Categories: mojoPortal

mojoPortal uses either CKEditor or TinyMCE as the default HTML editor. We tend to use CKEditor. The default configuration is American English. To change this in such a way that mojoPortal... read more

Comments(0)

MapLink issue when packaged with ArcMap 10 and HBSMR or CAMS using AppV

Posted by 17 December 2012 Categories: AppV CAMS HBSMR MapLink

ArcGIS (v10 on) no longer reads component categories from the registry, instead component category information is read from configuration files (*.ecfg) stored in: C:\Program Files... read more

Comments(0)

British National Grid in MapInfo

Posted by Mike Lush 28 November 2012 Categories: GIS (general) MapInfo Professional Projections

A problem frequently encountered with sharing data between MapInfo and ArcGIS is that the British National Grid projection used by ArcGIS is accurate to 1 mm, whilst the standard projection used... read more

Comments(2)

How to take a SQL Server backup without breaking the backup sequence

Posted by Crispin Flower 06 October 2012 Categories: SQL Server

When a SQL Server is configured to run scheduled full backups followed by a sequence of differential backups, taking an ad hoc backup will affect how backups can be restored, potentially breaking the ... read more

Comments(0)

WMS GetFeatureInfo in OpenLayers on right click

Posted by Stewart Bellamy 01 October 2012 Categories: OpenLayers WMS

Assuming that one already has a WMSGetFeatureInfo on the map then its quite simple: Add new class Use new class New class // A control class for capturing click... read more

Comments(1)

Handling different character encodings when importing tabular data from CSV

Posted by Crispin Flower 24 September 2012 Categories: HBSMR MS Access VBA

I’ve been fixing some minor issues with the utility in HBSMR that imports data from the Portable Antiquities Scheme. One issue was that some characters were mojibaked during the import, for example... read more

Comments(0)

How to drop all connections to a SQL Server database

Posted by Crispin Flower 18 September 2012 Categories: SQL Server

Mike S-G has passed me this useful tool for dropping all connections from a database. This is required before deleting or re-naming databases, for example. This creates a stored procedure in... read more

Comments(0)

Categories

Archives