Category: Database

Arches project has been accepted into Google Summer of Code!

Arches project has been accepted into Google Summer of Code!

Farallon Geographics applied to Google Summer of Code for the Arches project (ArchesProject.org). We are excited to announce that we have been approved to be a mentoring organization! We are looking forward to an exciting summer with awesome contributions from students from the international community. What is Google Summer of Code? Google invites students from all over the world, to come up with interesting, non-trivial problems/solutions or enhancements for...
Using MS Access as the query interface to Oracle Spatial

Using MS Access as the query interface to Oracle Spatial

Like many people, I cut my teeth in the database world using MS Access.  And, early in my career, I was much more comfortable writing queries using Access’s sql GUI than I was writing sql in a command prompt.  As such, it was common practice for me to make ODBC links to my Oracle Spatial database, and use Access as the interface to do the actual querying. In the...
Remodeling GIS Parcel Data for Ease of Use

Remodeling GIS Parcel Data for Ease of Use

In GIS parcel layers, I find that users tend to assume that APN (assessor parcel number) represents a unique key for each parcel geometry in a County. Nine times out of ten, this assumption is wrong, and results in an inaccurate analysis. Here is why… APN’s represent property tax accounts (a bit like your local gas and electric utility account number), and parcel geometries represent a piece of geography...
eCatch 2.0 – rebuilding sustainable fisheries on the California coast using GIS

eCatch 2.0 – rebuilding sustainable fisheries on the California coast using GIS

If you follow environmental news then you probably already read about eCatch, a new iPad app developed by The Nature Conservancy that gives fishermen real-time access to the latest information on where the fish are – the abundant ones they want to catch and the overfished ones they need to avoid. The basic idea behind eCatch is that some fish are becoming endangered through overfishing, and the best way...
Software development iterations and data backup for GIS web applications: Part 1

Software development iterations and data backup for GIS web applications: Part 1

Enterprise GIS web application development is about how to represent your existing data and how to capture new data. Here at Farallon, we have successfully built some very smart geospatial web applications that guide the user in that process. This post is about how we support the backing up of data for these advanced geospatial apps in order to facilitate the web app development life cycle as well as...
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...