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

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 ...
2
votes
1answer
676 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 ...
2
votes
1answer
112 views

Collapsing the multi-row output of a one-to-many spatial join to single-row (arcmap 10.1)

I'm working with TIGER data, looking at the relationships among incorporated places and counties. Not all places are completely contained by counties; some do span multiple counties. In the final ...
4
votes
1answer
171 views

How to determine correlation between two databases?

I need to perform some tests and verifications on databases and/or datasets. I need for example to analyze two databases and then determine if there is enough correlation between both. My main issue ...
4
votes
2answers
556 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 ...
0
votes
1answer
86 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 ...
10
votes
4answers
774 views

Open Street Map and PostgreSQL what do I exactly need?

I make my first steps in the GIS world and everything is very new for me even if I work on a "huge" project (ie: for a single programmer) very related to maps. My project needs to know informations ...
11
votes
1answer
203 views

Naming conventions PostGIS Database

We are starting to build up a database with PostGIS. The database is supposed to be for a team of about 5-8 researches who work frequently with geodata and statistics. Has anybody experience with ...
6
votes
2answers
665 views

GIS Database Migration Project (Oracle to ArcGIS)

I have been tasked with converting an Oracle Database into an ESRI file geodatabase. The data represents a gas network. The client's Oracle database has over 400 tables, 120 of which are spatial. ...
35
votes
3answers
6k views

Are there newer routing algorithms (than Dijkstra, A*) in GIS databases?

There are works like Reach for A* from Microsoft researchers and Highway Hierarchies by Sanders and Schtolz (if I spell the name correctly) from Karlsruhe Uni. Both of them reduce the calculations ...
1
vote
0answers
69 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: ...
7
votes
2answers
430 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 ...
1
vote
0answers
306 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
65 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
527 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 ...
0
votes
1answer
293 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 ...
3
votes
2answers
536 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 ...
0
votes
1answer
190 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 ...
0
votes
1answer
199 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.*, ...
1
vote
2answers
678 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: ...
1
vote
1answer
226 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 ...
1
vote
1answer
327 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
185 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
694 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
559 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
320 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?
17
votes
2answers
349 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
117 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
541 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 ...
8
votes
2answers
824 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
120 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
436 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
136 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
750 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
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 ...
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?
3
votes
1answer
127 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
290 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 ...
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
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. ...
5
votes
1answer
372 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
785 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
567 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
661 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
237 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 ...