The database-design tag has no wiki summary.
3
votes
2answers
68 views
Traversing a PostGIS table tree
I'm developing a geospatial db for a company that operates at a number of large facilities. Its primary purpose is to help staff locate themselves and equipment within each facilities' multi-storey ...
6
votes
2answers
83 views
Advice in setting up foundational OSGeo enterprise GIS
First let me describe the task:
My lab has approached me about setting up a simple GIS for a colleagues 'non-spatial' lab. There are a couple of key characteristics to the intended setup:
Fully open ...
5
votes
1answer
98 views
Is adding a new table for every layer a good design idea?
Is it a good design idea to maintain separate tables for each layer in a PostGIS database?. Every layer is defined by users. A user creates his/her layer say ATM location. Thats meant by defined by ...
3
votes
1answer
69 views
Should I use ISO 3166-1 Numeric codes as Primary Keys for Countries in a database table?
My main concern is, will one country ever adopt a numeric code that has been used for another in the past, such as can happen with alphanumeric 3166-1 codes? If not, then it seems like a perfect ...
0
votes
0answers
58 views
comparison detween UML and ArcGisDiagrammer [closed]
I am doing my Thesis and I want to compare two software design tools... This is the Thesis. Comparison.
The one software is the ArcGisDiagrammer and the other is Enterprise Architect a UML tool.
How I ...
0
votes
2answers
86 views
creating one tree to many observations in qgis
Looking to create a database for QGIS where each point represents a tree (with name attribute) and another table of observations about each tree over time. Ideally I can update tree location in QGIS ...
2
votes
2answers
838 views
How to design a database for continents, countries, regions, cities and POIs?
I'm brand new to GIS programming and I am designing a GIS application. Target is to create system with continents, countries, regions (including states, sub-regions, provinces), cities and places in ...
1
vote
3answers
774 views
creating unique ID-s for my file geodatabase
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 ...
2
votes
2answers
281 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 ...
1
vote
2answers
258 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 ...
2
votes
1answer
127 views
Attributes that characterize a geodetic track
I need a way to index and retrieve a large amount of track data. To do this I need to derive from every track as many attributes as I can. For now, I derive
Name
Tortuosity
Speed (average, max)
...
1
vote
1answer
684 views
How to import/copy geodatabase schema from multiple tables to a single table
I have an existing ArcGIS 10 geodatabase which has a complicated schema containing multiple tables and joins, and I wish to simplify this for faster web delivery.
For example, Featureclass1 is ...
12
votes
4answers
618 views
Database design: road topology in GIS
Is there a standard or a best practice way to store certain features about roads:
Road directionality:
One way streets: Roads going in one direction only
Center Turning lanes: roads that exist ...
4
votes
4answers
295 views
Record Date and User for an edited feature
The client has a Feature Class in SDE 9.3.1. When a feature in the feature class is edited the client wants to automatically record the date/time and who edited it in the feature class attributes.
...
3
votes
1answer
300 views
Sharding of geospatial data
Reading through Rosenberg & Mateos' The Cloud at Your Service I stumbled upon the concept of database sharding.
Authors point out to several advantages of such approach including high (online) ...
8
votes
2answers
667 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 ...
9
votes
1answer
320 views
Is it possible to maintain primary keys on versioned featureclasses without arcobjects code?
Since it is not a good idea to use ObjectIDs as primary keys in relationships, some other column will need to be used. Is it possible to use DBMS sequences to populate primary key columns in ...
11
votes
2answers
498 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 ...
13
votes
6answers
916 views
Is good database design less important for a spatial database
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 ...
