Database

Hiring another web map developer

October 24, 2011

We are looking to hire another web map developer to help us build out the NPMap framework and work on various NPS and partner web mapping projects. If you know of any experienced JavaScript developers in the Denver area who are looking for work, please let them know about the position. We also really appreciate [...]

Read the full article →

Microsoft finally adding support for spatial types to the Entity Framework

May 8, 2011

Microsoft introduced the spatial data types to SQL Server in 2008. Since then, they’ve released multiple versions of the entity framework and Visual Studio, but support in Microsoft’s developer frameworks and toolkits for the spatial data types has always been virtually non-existent. This has required developers to implement “creative” workarounds when integrating SQL Server spatial [...]

Read the full article →

Virtual Earth and SQL Server 2008 – A Match Made in Heaven?

May 1, 2008

Johannes Kebeck has an interesting post showing how to get the benefits of the MapPoint Web Service method, FindNearRoute, through the use of SQL Server 2008. He uses a newly-added feature of the Virtual Earth API that allows developers to gain access to a complete returned route-geometry when performing a route. This new feature, however, [...]

Read the full article →

Microsoft SQL Server 2008 November CTP

November 19, 2007

Those of you who use Microsoft SQL Server will be interested to hear that the SQL Server team has just released the November Community Technology Preview of SQL Server 2008 “Katmai”. Of special note for us GIS types is that this is the first publicly available release that includes support for the new spatial data [...]

Read the full article →

ESRI White Paper – ‘An Overview of Distributing Data with Geodatabases’

July 18, 2007

This past week, ESRI released several new white papers. The one that I’m most interested in is “An Overview of Distributing Data with Geodatabases“. This is the white paper that was promised during the “Managing Distributed Data with Geodatabase Replication” session at the ESRI 2007 UC. The first several pages are full of the now [...]

Read the full article →

Connecting MapDotNet Server 2007 to ArcSDE 9.2

May 11, 2007

I’ve been experimenting quite a bit recently with MapDotNet Server 2007 (from hereon, referred to as MDNS), and I’ll say that I’m pretty impressed. Building maps in MDNS is admittedly more difficult than simply publishing an .mxd with ArcGIS Server – MDNS uses MapServer’s map file format, but the power of gaining access to Virtual [...]

Read the full article →

Using ASP.NET AJAX’s CascadingDropDown with SQL Server Database

November 9, 2006

I’ve been using Microsoft’s ASP.NET AJAX implementation since the early “Atlas” beta days, but am just now starting to feel comfortable enough with its stability to use it in actual projects. Most of the sample controls that are included with the framework are remarkably easy (and fun) to setup and use. It’s pretty amazing how [...]

Read the full article →

Geodatabase Replication and Synchronization

October 13, 2006

As many of you probably already know, ESRI’s upcoming ArcGIS 9.2 release will greatly enhance the ability of an organization to expand its enterprise GIS to multiple sites through the use of geodatabase replication and synchronization. This ability comes with the workgroup and enterprise versions of ArcSDE; it does not work with personal or file-based [...]

Read the full article →

Geodatabase Design and Documentation

September 7, 2006

I’ve been looking for a better way to design, diagram, and document my geodatabase designs. Visio is my tool of choice for database design. It is easy to use and allows me to visualize and demonstrate the capabilities and limitations of my data model before actually creating the geodatabase. Using Visio, I can generate a [...]

Read the full article →

PostgreSQL/PostGIS Installation

August 30, 2006

I’ve worked with PostgreSQL for a while now, but everytime I perform a new install (usually with PostGIS added on soon after the initial install) I am amazed at how simple it is and how smoothly it goes. In the past, I’ve worked on some pretty complex database installs – especially complex, at least for [...]

Read the full article →