One or more structured sets of persistent data, managed and stored as a unit and generally associated with software to update and query the data.
23
votes
9answers
3k views
Is there any way I can use a Key-Value store for geospatial data?
I have used many relational databases in the past, but I have also read about all NoSQL databases, and the Key-Value stores looks interresting.
When I store geometric object I mostly use five indexed ...
1
vote
3answers
406 views
Qgis: How to display special characters German “ÄÜÖß” in a Map?
I have a shape file with names for Regions. These don't seem to contain special characters but ugly hyroglyphes. What can I do do display them correctly. If I import the shape as UTF-8 it doesn't ...
44
votes
7answers
1k views
How do I get started with PostGis
I have been reading a lot about it, but I am struggling to find a good beginner's guide.
Which tutorials/books do you recommend? My past experience involves python and arcgis. But I have never worked ...
15
votes
6answers
3k views
What are the best databases for storing spatial data? Pros and Cons
A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...
10
votes
3answers
847 views
What is a good taxonomy or naming convention for files and folders containing GIS data?
My company has collected about 30 TBs of GIS data over the past 8 years, and I always find myself asking the following questions:
What type of data do we have for a given geographic area?
What are ...
6
votes
1answer
339 views
Data visualization and maintenance tool
Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The ...
5
votes
1answer
266 views
How many kinds of “address” are there? [closed]
I'm defining "address" as "a physical location, usually visibly numbered". Numbered was used in the definition to exclude purely geographical features not usually considered to have or need an ...
16
votes
2answers
219 views
(When) should I use a GIS-enabled database?
I am a long-time programmer, new to GIS. I am trying to get a feel for the database aspects of GIS and I understand that there are some databases which are specialized for GIS use. Basically I am ...
7
votes
3answers
909 views
Suggestion about the database to be used with OpenLayers
Can anyone suggest me which database to be used with OpenLayers? I have to store the values in a DB table and retrieve them (trivial tasks). which is better MySQL or PostGIS? Can anybody give benefits ...
5
votes
2answers
2k views
Data organization strategies for .csv and .shp
I'm organizing a large amount of data for a project and the data is stored in .csv format, with a code to relate each row to a polygon in a .shp. I was planning on converting the .csv data into .dbf ...
4
votes
1answer
290 views
SDE analysis - file locking logistics - ArcSDE 10 on MSSQL
I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks.
I have a interpretable ...
4
votes
2answers
1k views
Arcpy Insert Cursor not inserting all rows
Good morning all, I have a script here that takes data from a cross-tabulated non-spatial dataset where monthly values are stored in a single table row for a given year and linearizes those data so ...
2
votes
1answer
283 views
stratigraphic ranking with field calculator?
I would like to populate a feature class float attribute with a numerical ranking of a text attribute of a geologic map. I have a field named [sheet_unit] with strings such as "H10, Q" and "J10, Pl" ...
