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
0answers
58 views

Bounding Box approximation when calculating in euclidic space?

Although I will illustrate my problem using a database, I think this is a quite general GIS question. I hope I came to the right place to ask. I am working with a system that runs on a normal ...
1
vote
1answer
139 views

Importation of .csv on grass gis converts numeric data to string data

When importing a csv file on grass7, the numeric data is converted into a data of type string. My csv looks like this : id_core value 1 F1 83.0611472396 2 F2 98.8584345936 3 F3 ...
3
votes
2answers
173 views

Non-spatial database analysis in ArcGIS - need alternative solution

I've recently joined an organisation where we use ArcGIS to do a lot of non-spatial analysis on a spatial dataset. Our main dataset is an environmental polygon survey with lots of attributes (in an ...
4
votes
1answer
2k views

Offline SLIPPY Map (Tiles) Database for Leaflet

How can create an offline cache of a large number of SLIPPY tile (PNG, 256x256) inside a web browser and then display them from that offline cache. For example, can one use HTML5 IndexedDB as an ...
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 ...
0
votes
0answers
43 views

How can I import layers into a database?

According to the QGIS User Guide (release 1.8.0, page 203/204) I only have to drag a layer from the QGIS Browser to the DB Manager. But for me this does not work.
7
votes
2answers
285 views

Basics about Spatial Indexes

I was asking on a forum if it could be a good idea to create spatial indexes on subsets of a table when your application display on map only those subsets and never the entire table. I was asking ...
0
votes
1answer
344 views

How to use a database in Qgis

What is the primary use of database in Q-Gis? How to connect to a database in Qgis?
3
votes
2answers
440 views

How to add data to relationship table in ArcGIS 10.1 database design?

I have created 2 tables HORSE and VENDOR and a relationship table VENDOR_HORSE With the foreign key in Horse being the Primary key in VENDOR (VendorID) and the foreign key in VENDOR being the primary ...
2
votes
0answers
64 views

Raster layer with unique vector for each raster cell?

I have been looking around several hours, even days, but couldn't find a clear answer to my question. I am working on a WebGIS tool that interprets local geology. From more than 70 asc-files, I would ...
3
votes
0answers
29 views

DataB and DataB-copy worked on simultaniously - how merge DataB-copy into DataB

ArcGis 10 - EDITED (sorry for not being more specific, quite new to the arcgis world) We need to enter A LOT of Map data (Sewage system) into a Database in a relatively short time. It involves an ...
1
vote
1answer
628 views

Trigger a python script to run after a row is added to the feature class

I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
5
votes
2answers
391 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 ...
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
751 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
121 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
183 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
591 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
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 ...
10
votes
4answers
797 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
206 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
733 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
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: ...
7
votes
2answers
455 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
335 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
66 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
566 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
302 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
600 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
238 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
215 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
698 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
252 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
351 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
193 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
797 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
607 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
345 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
359 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
556 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 ...
8
votes
2answers
867 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
133 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
445 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
139 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
784 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 ...