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

2
votes
1answer
781 views

What is the proper way to delete an SQL Server database in order to delete an SDE geodatabase?

I'm new to this SDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the SDE geodatabase. Is it as easy as right clicking on the database in SQL ...
5
votes
3answers
389 views

Adding a GIS feature to existing database entry with QGIS

I've built a database with postgreSQL with tables, which include geometry columns. When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my database using postgis. ...
1
vote
0answers
70 views

Allocate places according to distance

I've asked this over on Stack Overflow but thought that someone may have a GI point of view that may help: As an over-simplified example I have a list of events that have a maximum attendance: ...
5
votes
2answers
401 views

Who knows GIS based Customer Relationships Management (CRM) tools?

I'm searching for a tool like something around a "GIS based Customer Relationships Management Tool". The functionality I am looking for is: 1) collect: collecting customer related data in several ...
7
votes
2answers
463 views

How to create something similar to GDB in QGIS?

I used to work with ArcGIS. There I had geodatabases in which I could store several shapefiles with defined layer styles. Is there a way to do something similar with QGIS? The background is: we are ...
0
votes
1answer
88 views

How to detect(condition) if Query Layer Connection is failing?

I have a job (arcpy script) which relies on a query layer but it fails sometimes. It has to do with the query layer connection (the point where job fails randomly)- which is totally under the control ...
4
votes
2answers
613 views

Calculate Field based on field value in a second table

I have a table in a MSSQL Server Enterprise SDE database. I need to join a table from a MS SQLExpress Workgroup SDE database and then calculate 11 fields in the Enterprise table based on values in ...
1
vote
0answers
338 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
1
vote
0answers
67 views

Creating tables using the coordinates of weighted graph?

Hello All, Kindly let me know how to create tables using the coordinates of a weighted graph ??
8
votes
4answers
581 views

Geolocation database of beaches

Anyone know where or how to obtain a database of worldwide beaches? Required fields are: name latitude longitude coastline aspect (if possible) Alternatively, is there a way to query Google Maps ...
3
votes
2answers
624 views

Can I import a .gml file into Spatialite in QGIS?

I have some Ordnance Survey Address Base data files which have a .gml extension. I have imported them to GGIS as vector layers along with some mapping data but would like to explore them with ...
15
votes
3answers
3k views

Database for offline slippy map tiles

I currently have an offline HTML5 map application (built on Leaflet & KendoUI with custom additions) that has an app manifest and works fine on multiple platforms. However, I am hesitant to use ...
0
votes
1answer
250 views

Column exists in DatabaseMetaData, but does not exist in relation?

I am using JDBC to query a PostgreSQL database. And I want to populate a column called wiki_url based on the value of another column, level which will determine which value of 5 columns to concatenate ...
3
votes
0answers
68 views

Search in Bounding Boxes and Locations

Description of the problem (what I need): I have a set of bounding boxes (maybe the actual data is a location[longitude, latitude] in which case the bounding box will have identical corners). I have ...
5
votes
1answer
1k views

ARCMAP ERROR 000464: Cannot get exclusive schema lock

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
4
votes
3answers
154 views

Hydrology, operational rainfall-runoff models

I am trying to collect information about operational rainfall-runoff models used around the world. I hope to build database with country outline with attached information what organization is covering ...
1
vote
1answer
354 views

Google maps api, several moving markers using a csv file containing the coordinates

I collected 5 sets of coordinates of moving vehicles and I want to play the scene using googlemaps API showing those 5 vehicles moving. The sets are saved in a postgresql table. is it possible ? if ...
3
votes
1answer
194 views

Geoserver Link to External MS-Access Database

Is there a way that I can link a shape (as a polygon, with a LINK_ID = 12345) from Geoserver and have it open or link to the specific information (LINK_ID_DB = 12345) within an online Web Microsoft ...
1
vote
2answers
842 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
623 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
1k 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
263 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
4k 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 ...
18
votes
3answers
393 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
119 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
565 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
67 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
303 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
4k 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
354 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
192 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
138 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
229 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
2k 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
447 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
140 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
472 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
2k 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
797 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 ...
5
votes
3answers
7k views

How to import info from mdb file into a project?

I need to import info on a QGIS project. The info are in a MDB file (population, mean age, number of cars and so on: one record per region) that is written to be connected with a region shape from an ...
3
votes
1answer
4k 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
312 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
405 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
484 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
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 ...
7
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. ...
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
413 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
825 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, ...