Archive for the 'Uncategorized' Category


Adding Tiled Map Services from ArcGIS to MapGuide

MapGuide 3.1.2 is recently out, and it has some really cool changes.  The best, IMO, is the XYZ Maps.


For example, the ESRI Satellie MapServer (

If there are Tiles you can view them in MapGuide 3.1.2 (using MapGuide Maestro of course!).

Using the following syntax:${z}/${y}/${x}

Notice the dollar signs before each of the XYZ items. This where MapGuide passes the XYZ to ArcGIS to get the correct tile.

For a few more to try:

ESRI Streets:${z}/${y}/${x}
Esri Topography:${z}/${y}/${x}


Or you can use any ESRI Server with Tiles.  For example here is the State of New Jersey’s NJGINE GIS 2015 Aerials:${z}/${y}/${x}

Here is an example in Princeton, NJ:


So if you have an ArcGIS Server with Tiled layers, you can consume them in MapGuide Open Source 3.1.2 now!





ECW and MR SID with MapGuide Open Source (3.1.1)

So I keep Googling my own Post on Nabble, the MapGuide-Users forum where I describe how to roll out the ECW and MR SID Aerial Photo Support for MapGuide Open Source 3.1.1.

To save me, and anyone else time looking for it, I have posted the process here:

For MapGuide 3.1.1 in Windows 64 bit:

1. Download

2. Stop the MapGuide Service  (using Control Panel > Administrator tools > Services)

3, Unzip and copy contents of the BIN folder from the ZIP into the
C:\Program Files\OSGeo\MapGuide\Server\Fdo folder 

4. Copy the C:\Program Files\OSGeo\MapGuide\Server\Fdo\gdal\plugins folder
and paste it in the C:\Program Files\OSGeo\MapGuide\Server\bin folder.

5. Rename the plugins to gdalplugins so you end up with a folder called
C:\Program Files\OSGeo\MapGuide\Server\bin\gdalplugins 

6. Start the MapGuide Service (using Control Panel > Administrator tools > Services)

This works for me every time.

If you are migrating from Autodesk Infrastructure Map Server, you will have to re-create your Raster Data Sources, but just rename them the same name as the original and your layers will point to the new GDAL ones.

Example of new GDAL data source using multiple ECW files:



Editing SQL Server with MapWindow 5

In the past two posts, we saw how to edit with:

  • AutoCAD Map 3D
  • QGIS
  • ArcMap
  • ArcGIS Pro
  • MapInfo

In this video, we connect to the exact same table in SQL Server and try to edit with MapWindow 5.


Bonus SQL Server Spatial editing: MapInfo 16

In a previous post, I demonstrated editing SQL Server Spatial with 2 out of 3 standard GIS Desktop software.  Here is a 4th – MapInfo.


Comparison of SQL Server Editing with ArcMap, QGIS and AutoCAD Map 3D

Here is a quick video of me creating a very simple SQL Server table with a Geometry column, and try to edit data in 3 GIS Platforms:

  1. AutoCAD Map 3D 2018
  2. QGIS 2.18.14
  3. ArcMap 10.5.2


Magic of WKT (Well Known Text)

It’s been a long, long while since I posted anything, but I have been anything but idle.

I have been porting a lot of GIS Applications from Oracle Spatial to SQL Server Spatial. This is true for the Oracle OSE and the Topobase customers lately.

Typically Oracle 11g to Microsoft SQL Server 2014 is the migration path I have been following.

My first reaction is always to create a Safe Software FME batch file to do the translation but sometimes I like to do it the hard way.

I wanted a live view in SQL Server to look at the Oracle tables.  Normally very easy with a “Linked Server” in SQL Server.


But, try doing this with Oracle’s SDO_GEOM datatype (NOT!).

Until I found the magic of Well Known Text (WKT).  This is a common Geometry standard that is shared between both SQL and Oracle.  It looks something like this:

POLYGON ((632995.706198033 6925343.8592000678, 632951.17949780729 6925366.6051015854, 632922.04199836869 6925309.5665011816, 632966.56860080548 6925286.8205018751, 632995.706198033 6925343.8592000678))

Now during the query to Oracle, I can ask for the SDO_GEOM column like this:

select SDO_UTIL.TO_WKBGEOMETRY(geom)  as wkt_geom from Parcels;

If I want to see that data in SQL Server, can query the linked server:

select geometry::STGeomFromText(wkt_geom, 26911) from [linked_oracle].gis_prod.Parcels;

NOTE: 26911 is UTM coordinate system.

So this little magic lets me go dynamically from Oracle to SQL Server without static translation.

Worth the wait I hope!





Paper Map to the rescue

Recently, on a road trip from my home in Guelph, I headed out on a road trip to Princeton New Jersey.

I was using Google Maps on my phone, but the power drained in my Moto G despite being plugged in.

I was map-less!

So, in the middle of Pennsylvania I stopped at the first gas station, no maps.  Went another 50km – no maps at that gas station either.  5 stations later I finally found a map – really small scale of North Eastern States.

So from now on, when the lights go out, I am always going to have a paper version of the map.

Like the boyscout motto: “Be Prepared”

Gordon Luckett

Arrow Geomatics Inc's Gordon Luckett


gordon dot luckett at arrowgeo dot com 1-519-837-9500 (Arrow Geomatics Inc.)

Checkout MapGuide Guy’s Youtube Channel