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
678 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
547 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 ...
8
votes
3answers
878 views

How to fix “Unable to initialize ODBC connection to DSN for ALC_AV_CO”?

So I am new to the QGIS community, and I have been trying to bring in some rather large access databases with little to no success. I have windows 7, so I've gone in through administrative tools/Data ...
1
vote
1answer
221 views

How to connect QGIS to an online database on Mac OS X? [closed]

I'm a real beginner/dummy when it comes to QGIS and online databases. I have tried a variety of things trying to connect to Spatialite, PostGIS and MySQL but all attempts have failed due to my lack of ...
4
votes
3answers
3k views

Is there a way to link ArcGIS to MS Access and use that DB?

I have an IT background but I am new to GIS. I recently recieved training using ARCMAP. I have about 5000 farmers that I need to put in a database and access the information using GIS. The vision is ...
17
votes
2answers
347 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 ...
2
votes
1answer
116 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 ...
12
votes
2answers
534 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
1k 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
66 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 ...
0
votes
1answer
291 views

Problem in Spatialite database creation

When I try create a new DataBase, Spatialite plugin return the dialog error box: The SQL query seems to be invalid. no suck table: views_goemetry_columns When I click in OK button, a second dialog ...
8
votes
4answers
3k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
1
vote
1answer
318 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
182 views

How can I copy archive data from one server to another?

I have an SDE 10.0 server and an SDE 10.1 server and I am trying to migrate the layers from 10.0 to 10.1. (On a side note the 10.0 server is running SQL Server 2005 and the 10.1 server is running SQL ...
1
vote
1answer
117 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 ...
0
votes
1answer
196 views

Why is the database connection lost on every query?

Every time I started a query the connection with the database is lost. Anyone familiar with this problem? This problem occurs with various query, for instance: CREATE TABLE table SELECT a.*, ...
2
votes
4answers
1k 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 ...
10
votes
3answers
432 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
135 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 ...
0
votes
1answer
442 views

Character encoding for Oracle DB and Geoserver

I have a setup that uses Oracle database->GeoServer->OpenLayers->my JavaScript. I use the UTF-8 character set in GeoServer and the JavaScript layers. The Oracle instance is configured to use WIN1252 ...
3
votes
3answers
1k views

Create an ArcCatalog OLE DB Connection using Python

Is it possible to create an OLE DB connection (*.odc) to a database in ArcGIS 10 , but using Python instead of the ArcCatalog GUI wizard? I don't need to necessarily create a file on disk, just make ...
2
votes
2answers
742 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
3answers
6k views

How to import info from mdb file?

I need to import info on a QGIS project. The info are in a MDB file (population, mean age, number cars and so on per Town) that is possible to connect with a region shape from an ID (the ID is the ...
3
votes
1answer
3k views

Establishing a MySQL connection in ArcGIS 10

Is it possible to create a connection to a MySQL database in ArcGIS 10?
9
votes
2answers
287 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
384 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 ...
3
votes
1answer
432 views

Schema locking logistics on ArcSDE for SQL Server?

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 ...
2
votes
3answers
3k 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 ...
7
votes
2answers
3k 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. ...
4
votes
3answers
1k views

How to read the GEOMETRY table inside a sqlite database

I'm working on an android app which should display some lineobjects stored in a sqlite database. This sqlite database is created through an export in QuantumGIS. My first question is it a real ...
5
votes
1answer
369 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
780 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, ...
4
votes
2answers
2k 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 ...
4
votes
2answers
312 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 ...
6
votes
1answer
558 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
191 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
655 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 ...
6
votes
3answers
470 views

Suggestions for an efficient way to store raster files for lab use?

I'm trying to create a repository for our raster files from various sources and Im exploring the possibilities on how to store them and deliver them in our local intranet. I have come across rasdaman ...
4
votes
1answer
235 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
746 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
186 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
561 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
1k 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
335 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
344 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
347 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
967 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
520 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 ...
11
votes
5answers
315 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 ...