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.

learn more… | top users | synonyms

1
vote
2answers
979 views

One Polygon Joining to Database with Many matching records

Using ArcMap 10.1. Is this possible to have one polygon and join to a database/excel with many matching records? I would like to have 1 polygon but match to 100 corresponding records in a table. When ...
3
votes
1answer
678 views

Using Google Earth to query database

I've been reading about using Google Earth to query data (this article) and I'm interested in learning how to make one of these. I just have a couple of questions: 1. Is this possible with the free ...
1
vote
1answer
377 views

QGIS error when open project when layer via accesses the database

I changed from QGIS 1.7.3 to 1.8.0. Problem is that I can´t open QGIS Projects, QGIS crashes when there are layers involved loaded via access-database connection. I used eVis. What can I do?
2
votes
1answer
120 views

spatial data filtering without GIS?

I have access to a database here (description of the columns are also available) containing spatial data in text format and with WGS84-EPSG:4326 coordinates. I would like to only select data in my ...
13
votes
2answers
604 views

Need a spatial database that can be used by QGIS and R

I'm quite new to QGIS and I'm searching for a simple way to create a Database that allows me to use the tables in QGIS and R. I have a lot of data stored in Excel spreadsheets wich will be used for ...
8
votes
2answers
2k views

Converting ms-access database into easy to use spatial database

I've recently come into ownership of an MS-Access database (2007 accdb), which I want to be able to use in a GIS. I know a little bit about GIS (I've used QGIS and ArcGIS quite a bit) but very little ...
1
vote
0answers
69 views

Database has duplicate values after running pgrouting

I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that. I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
8
votes
2answers
937 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 ...
1
vote
1answer
151 views

Creating admin roles with limited access to PostGIS

I'm trying to cram three different organisations into one server. Today they each have their own geoserver instance connected to separate PostGIS databases, which works fine. But now they also need to ...
10
votes
3answers
461 views

How can I handle tables with 256+ variables?

I'm working with census data and downloaded several CSV files, each with with 600ish columns/variables. I'd like to store them all in a query-able database, but everything I've tried so far (MS ...
0
votes
2answers
142 views

Web site with: google map like or GIS, one million record database and a feature to run advanced search

What is the GPL way - without or with little developing - to build a web site runnning on apache which has to feature: one million record database (MySQL; which may be editable), an advanced search ...
2
votes
2answers
837 views

ArcGIS Server simple link with SQL Server database

I am using ArcGIS Server 10 to create Rich Internet Application with embeded Maps. Basicaly, I created an Optimized Map Service on ArcGIS Server, from an MXD file (produced with Arc Map). I have ...
4
votes
2answers
340 views

Fastest way to remove matched points

Hoping someone can see a faster way of doing this, because at the moment I'm averaging 9 hours per run for what I'm trying to do and well basically getting my behind chewed off by the boss :-) The ...
3
votes
1answer
132 views

Choosing a GIS which imports a list of stage addresses, calculates the route, allows to modify and export it

I'm new to GISs. I'm searching for a GIS to meet following requirements. I have a list of street addresses [A,B,C,D,E,...], with additional information associated (basically which orders to deliver ...
9
votes
2answers
332 views

How do you protect your PostGIS credentials when using QGIS 1.7?

I'm fairly certain this should be a community wiki, but I don't know how to make it one. So if an admin sees this please change if appropriate. So.....How do you protect your PostGIS database data ...
4
votes
2answers
424 views

Where can I find GeoJSON resources files?

I'm looking for demographic information and various things, and most of the time data are available as CSV (my application use geoJSON format). Shall I encode the CSV to geoJSON or is there a ...
2
votes
3answers
4k views

Python script: Access data from databases [closed]

I need to access data that is inside an oracle database using a python script. Its a Unix server running oracle 10g. I dont have much access to the database server. It works fine on model builder ...
8
votes
2answers
4k views

QGIS supported databases?

Does anyone know if there is some kind of documentation on which database types that you can connect to in QGIS? I would also like to know if: Can I use the databes for read only or read & write. ...
5
votes
1answer
437 views

GIS-based reporting and maintenance tool

Background Conceptually, I am looking for a tool, or suite of software tools that can be readily integrated to help browse data using a GIS-based map (such as Google Maps). The proposed architecture ...
2
votes
2answers
853 views

Having trouble getting specific items from a list. What am I doing wrong?

I am a total beginner when it comes to python. I received some help already getting this code started but I hit a wall. I have a directory with 200 folders, each with a geodatabase, feature dataset, ...
6
votes
1answer
637 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 ...
2
votes
1answer
209 views

Automate database conversion from NAD83 to Web Mercator

A NAD83 database is updated daily while a Web Mercator clone is only update when time is available. Looking to automate this process of Copying Layers Projecting them to Web Mercator Placing in ...
1
vote
1answer
776 views

Linking SharePoint database with ArcGIS…possible?

Ok, so I the organization I am working for has a sharepoint database that multiple people update every time they do an inspection of natural resources on a parcel in the county. This database has the ...
4
votes
1answer
267 views

Spatial index vs two coordinates indexes

I have a table with two columns: latitude and longitude. I want to get all objects inside a "rectangular" (well, rectangular in a lat/lon coordinate metric) bounding box: min-max latitude and min-max ...
3
votes
1answer
811 views

Correct way to perform point-in-polygon queries on streaming point data?

Short version: What is the "correct" Esri-based solution to the presumably-common scenario of receiving dynamic asset location data (eg. aircraft), checking to see whether those points are within any ...
1
vote
0answers
193 views

How exactly is an SLD_body object (when extracted from its XML href) structured when using a cElementTree to parse it?

I'm trying to export data from a PostGIS database into a geoserver and I've gotten it to where I can get the PostGIS database to point to the geoserver (I'm doing this as a python script for a GIS ...
10
votes
5answers
577 views

Database versus Files for Solo Developer

I'm just getting started in GIS and am interested in using it to create maps of mountain biking trails in my area and nearby. I've been learning QGIS and have made enough progress to generate a decent ...
4
votes
1answer
2k views

Good place to get Country, State, City, and Zipcode information?

I'd like to populate a database with common location information. I'm not entirely certain that addresses across the globe have similar or even the same entities as the Country, State, City, and ...
4
votes
1answer
337 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
5
votes
1answer
402 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 ...
8
votes
2answers
411 views

How can I find the median column in a database?

I have data on period of construction for dwellings in dissemination areas. I have transferred this data to my study areas and would like to determine the median period of construction for each study ...
13
votes
4answers
1k 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 ...
2
votes
3answers
582 views

Looking for map calibration software and city database

I'm in need of a mapping software which, given a map, lets you calibrate it (choose which geographic coordinates project to which pixels on the map image) and then given a database of cities, you can ...
4
votes
2answers
1k views

Is there a way to quickly reduce precision in a number of DOUBLE fields?

I was wondering if there is a way to reduce the precision for display of a DOUBLE field of a number of fields, in a shapefile. I have 25 fields and would like to do it as automatically as possible but ...
18
votes
7answers
2k views

Spatial databases learning resources for newbies

Would be taking up a course on spatial databases next semester. Would anybody know a newbie friendly introductory resource? A vendor neutral one would be preferable. Thanks.
11
votes
5answers
321 views

Why do most GIS packages need a numeric id?

This is a simple yet possibly controversial question: why do most (if not all) GIS packages require that a determined layer have a unique not nullable numeric identifier? Why there is the need for ...
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 ...
3
votes
1answer
2k views

Casting a Geography type in PostGIS

I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY, boundary GEOGRAPHY(Polygon) ); I added the following test polygon to the ...
2
votes
2answers
476 views

Create a dbf table by copying the structure of another dbf table

I have a dbf table and I wish to automatically create another dbf table with a different name but with exactly the same structure i.e.fields as the existing table. Is there any ready code in VBA and ...
2
votes
1answer
185 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...
1
vote
0answers
95 views

Getting started with storing LoST and GML searching

I am working on a logging and search database application. The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
3
votes
2answers
677 views

Table structure for a reverse geocoding database

I should start by saying that I do not have much experience with GIS so this question may be foolish. What I do have is a database for performing a lookup from a set of coordinates to find the ...
7
votes
3answers
2k 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 ...
4
votes
3answers
363 views

Looking for good resources for batch files in relation to databases/geodatabases

I hesitated a bit before asking this, as it isn't necessarily a GIS specific question, though I'm using it to update geodatabases. I have found plenty of hits on a Google search, but frankly, many of ...
3
votes
1answer
459 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
699 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
217 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 ...
2
votes
1answer
342 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" ...
10
votes
2answers
950 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 ...
1
vote
2answers
768 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({ ...