Database design is the process of specifying the logical and/or physical parts of a database.

learn more… | top users | synonyms

15
votes
5answers
1k views

Is good database design less important for spatial databases?

I have a strong feeling that database design and normalisation often comes in second hand when dealing with spatial data. With software costing a fortune and databases with over 100 fields tables I ...
2
votes
3answers
2k views

Creating unique IDs for file geodatabase using ArcGIS for Desktop?

I use ArcEditor licence level, ArcGIS 10.0 version, and we're talking about a file geodatabase. I have several feature classes (electric energy domain) and I want to connect them using relationship ...
0
votes
2answers
814 views

Is there a way to have a single point feature with multiple records?

Is there a way to have a single point feature and have multiple attributes records associated with it? Multipoint approach won't work as it gives me one attribute set (database row). I am trying to ...
10
votes
2answers
1k views

How to design a Spatial Database for temporal Data?

I am working on a Weather based GIS App. I have the data from several weather stations, and this data will updated daily (by a web service). The obstacles I am facing are: There are currently 40 ...
3
votes
2answers
545 views

What's a good way store borehole data in SQLite / SpatiaLite?

I have a bunch of bores / wells with downhole data. The 'header' info for each borehole can easily go into a single table, but I'm wondering how best to store the downhole log data. Typically they are ...
11
votes
4answers
1k views

How to model a graveyard - one point per deceased or one per grave? [closed]

This is a continuation of my previous question about our project on how to economically get away with the implementaion of a graveyard in a GIS system… On the graveyard we can find Regular ...
11
votes
2answers
956 views

When is it safe to use ObjectIDs as keys in a relationship class?

I've always avoided using ObjectIDs when defining relationship classes. It is my understanding that some actions on a geodatabase will re-set objectIDs (like import/export). However I do see a lot ...
0
votes
1answer
55 views

Creating spatial database with many categories that have same set of values?

I am working on creating a spatial database of county agricultural data where each county has multiple crops (30+) and for every crop there are several production metrics (yield, harvested area, ...
0
votes
1answer
159 views

QGIS Value Map Edit Widget with properties dependent on another field

I'm having a problems with Edit Widgets in QGIS. I'm working on a GIS Database for archaeological data, where every site is represented by a polygon. In the attributes there is a field for the era ...