What’s A Spatial Data Base?

Now that there are connections to Spatial Data Bases in Map have you ever wonder what a spatial database was and how it work? I am sure most of us have created a table in MS Access at one time or another and may even link to them with the Map Explorer. But what is a “Spatial Database” and how is it different than a Access database? I will try to shed some light on what they are and how they work. First thing the big differences is they store the geometry of the features. Be it a point, polygon or line feature each data base has it’s own method of storing the feature type and the coordinates of that feature in a column in a table. For instance lets say we have a point feature at coordinate x=20 y=20. In the table under a column named geometry the value might be “point,20,20”.

A MySQL Table

Sounds simple right? Now the fun starts when we want to know is that 20,20 at lat, lon or a state plane coordinates system. That is where the “relationship”of a database comes into play.

Here is an view of an datastore in a MySQL database and all tables that belong to it. It contains only three features tables, Featureclass1 that is empty, Parcel that is storing parcel information, and UG_Services that is storing under ground electrical services.

Sample Table

Notice all the other tables listed. All the other tables contain the info on those feature tables.  The coordinate systems used in this datastore is stored in a table like this.
The projection table

Depending on what Database and the engine that runs that database depends on how the tables store the data or controls it, but in a nut shell the tables all relate to one another, so if you change one item in one table it may change something in another table. Another example if you look at the parcel feature table (in MySQL Administrator) you see this.
The Table view

Notice the column named “Geometry” in Map when you view the table that column is not displayed. The reason is because that FDO provider is telling MAP what to display in relation to another table in the database. Don’t ask me what one I am no way a MySQL expert but I would take a guess and say one of those with F_attribute in the name.

So in a nutshell that’s what a spatial database is and how they work. If anyone is interested in downloading MySQL and try out the FDO post a comment and I’ll direct you to the FREE Spatial Database.

Advertisements

1 Response to “What’s A Spatial Data Base?”


  1. 1 jasonbirch 04/24/2007 at 10:26 PM

    Great article Murph.

    MySQL is certainly popular, but PostGIS/PostgreSQL is the preferred open source database for most spatial applications. It’s unfortunate that this combination was not looked at earlier, as it offers a great deal more spatial functionality than MySQL. We’re nearing completion of a FDO provider for PostGIS now, and it’s working fairly well in MapGuide Open Source 1.2-beta.

    I’m not sure what level of Map 3D it will work with initially… I haven’t looked at whether it’s compatible with the FDO version that was shipped with Map 3D 2008 or not yet.

    Jason


Comments are currently closed.



Archives

Readers Locations

Top Rated posts

Chat room


%d bloggers like this: