Month: April 2011

Efficient processing of source address data into a Master Address Database (MAD) data model

Efficient processing of source address data into a Master Address Database (MAD) data model

I’m kinda jazzed because I just proved out a script that ingests a series of raw address files and loads them to the Master Address Database (MAD) data model that we built for San Francisco last year as part of their Enterprise Addressing System. (We are also in the process of implementing the same MAD data model for Walnut Creek and San Mateo County.) The data processing required is significant....
Where’s my stuff? Using Open Source GIS to track archeological treasures in the Middle East

Where’s my stuff? Using Open Source GIS to track archeological treasures in the Middle East

We’ve been working on the Middle Eastern Geodatabase for Antiquities (www.megajordan.org), a very cool Open Source and web-based GIS for documenting archeological sites. MEGA has just been launched for the Kingdom of Jordan, and we’re already hard at work on deploying it for Iraq. While MEGA does lots of things, we see it as the definitive geospatial inventory of archeology in Jordan. And while that might not sound too...
Developing spatial applications with SqlServer 2008, Sharepoint, .NET MVC

Developing spatial applications with SqlServer 2008, Sharepoint, .NET MVC

I’m sure that most people would agree (well GIS folks for sure) that the arrival of SqlServer 2008 with native spatial types was pretty exciting news. It’s only recently, though, that I’ve really had a chance to see it in action. I’ve just had the opportunity to be involved in a large scale GIS project involving the complete Microsoft stack: Sharepoint, .NET MVC, and SqlServer 2008. So what’s it...
Liftoff!  Just back from the official rollout of Middle Eastern Geodatabase for Antiquities (MEGA)

Liftoff! Just back from the official rollout of Middle Eastern Geodatabase for Antiquities (MEGA)

I’ve just returned from the formal launch of the Middle Eastern Geodatabase for Antiquities (www.megajordan.org) in Amman, Jordan. Since Farallon has been working on this project since 2007, the publicity and public announcement of MEGA was super gratifying. Plus, it’s the first project that I’ve worked on that had a member of a Royal Family (Jordan’s Princess Sumaya) gave the keynote address at the launch. Below is a YouTube...
Understanding the lingo of GIS

Understanding the lingo of GIS

Executives and other mere mortals really get the short stick when it comes to the lingo of GIS. It’s kind of like slang in that it evolves at a much faster rate than anyone can really keep up with, and the meanings of these words can vary significantly depending who says them. My blog is dedicated to those professionals (GIS and otherwise) who get blindsided by the GIS jargon...