We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [database]

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.

Filter by
Sorted by
Tagged with
3
votes
2answers
1k 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) ...
4
votes
3answers
2k views

Delete a feature data set in SDE 10 programmatically

Is there a way to delete a feature data set and all of its feature classes programmatically either by using custom code or pre-existing command line tools? There is a tool provided by SDE called ...
2
votes
1answer
265 views

Are there any efficient methods for processing ArcGIS-based database tables outside of the ArcEtc program library?

Let us say, for the sake of argument, that you are working with a table that is over 2 GB in size (so .dbf is automatically ruled out... right?). To even create such a document, ArcGIS requires that ...
8
votes
3answers
1k views

What are the Pros and Cons of hstore data type in postgis?

PostgreSQL has a module named hstore that implement the use of key/value pairs (it's something like the OpenStreetMap model, but in a single table). What are the Pros and Cons of hstore regarding GIS ...
2
votes
1answer
388 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" ...
1
vote
2answers
847 views

Apply Database based Rules to Openlayers

im trying to apply rules, where the data is fetched from an external database. This is my code: // create a new style and add rules var defStyle = new OpenLayers.Style({ ...
11
votes
2answers
2k views

Future for geospatial on App Engine?

2 years ago, this question was posted here at Gillies's blog, on date of 2009-05-15. Future for geospatial on App Engine? At that time there was no news relating to any apps of GIS web services ...
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
3answers
284 views

Using a web map to identify and access data

I am trying to making a webpage where the user pans and zooms on a map, and based on the location and zoom level, some data is displayed on the webpage (drawn from another source). The data that will ...
7
votes
1answer
2k views

Why is my XY Event Source layer only displaying at full extent?

My XY Event Source layer is only displaying at full extent and when I zoom in, the features disappear. If I select a feature in the attribute table, the feature is highlighted. When I see this for a ...
7
votes
1answer
1k views

Imagery Database/Metadata Store

I'm a Remote Sensing PhD student, and as such I have a large number of satellite images that I'm working with. I'm starting to fail to keep track of them all and I have a lot of metadata that I want ...
13
votes
4answers
3k views

What is a good taxonomy or naming convention for files and folders containing GIS data? [closed]

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 ...
1
vote
2answers
1k views

osm2pgrouting connection failed

I'm importing data from my OSM file to a postgresql database using osm2pgrouting. I followed everything in from here and it went smoothly, until I try using osm2pgrouting. This is what happens: root@...
1
vote
5answers
1k views

Store Geometry in a database with the ESRI Silverlight API

Is it possible to store geometry objects in a database using the ESRI Silverlight API? For this particular case, the client may have SQL Server 2005 installed instead of 2008 and therefore I can not ...
21
votes
9answers
21k views

Choosing database for storing spatial data?

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 ...
26
votes
9answers
6k 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 ...