Questions tagged [database]
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.
389
questions
28
votes
9answers
6k views
Is there any way I can use a Key-Value store for geospatial data?
I have used many relational databases in the past, but I have also read about all NoSQL databases, and the Key-Value stores looks interresting.
When I store geometric object I mostly use five indexed ...
25
votes
3answers
33k views
How to create a new 'gis' database in PostGIS?
I'd like to create a new database in PostGIS, so I can load stuff into it while the current database is being used. According to the docs
Some packaged distributions of PostGIS (in particular the ...
24
votes
5answers
13k 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 ...
23
votes
2answers
3k views
What is the best hack for importing large datasets into PostGIS?
I have to import large Shapefiles (> 1 million records) into PostGIS, and I have been wondering about the best way to do it.
In my question I used the word "hack", instead of tool, on purpose because ...
16
votes
2answers
2k 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 ...
16
votes
2answers
1k 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 ...
15
votes
4answers
2k 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 ...
14
votes
3answers
5k views
How to refresh the attribute table of a layer after editing the table in the DB-Manager?
Is there any way to refresh the attribute table of a layer after editing the table (e.g. add a column) in the DB-Manager?
13
votes
4answers
3k views
What is a good taxonomy or naming convention for files and folders containing GIS data? [closed]
My company has collected about 30 TBs of GIS data over the past 8 years, and I always find myself asking the following questions:
What type of data do we have for a given geographic area?
What are ...
12
votes
4answers
1k 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
5answers
389 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 ...
11
votes
3answers
5k 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. ...
11
votes
2answers
2k 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 using ...
10
votes
5answers
18k views
How to display special German characters “ÄÜÖß” in a map?
I have a shapefile with names for Regions. These don't seem to contain special characters "Ä", "Ü", "Ö", "ß" but ugly hieroglyphs.
What can I do to display them correctly. If I import the shape as ...
10
votes
6answers
1k 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 ...
10
votes
3answers
917 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 ...
10
votes
3answers
2k 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 ...
10
votes
3answers
6k 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 ...
9
votes
8answers
13k views
Comprehensive database of all cities/towns in South Africa?
The title says it all really - I'm looking for a comprehensive list/database of all cities/towns in South Africa. I know about these guys: http://www.afrigis.co.za/, but they're just not getting back ...
9
votes
2answers
985 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 ...
9
votes
3answers
5k views
How to design a bus station query database schema?
We have bus station data, and we want to build an application which will provide the line/multiple line for a given start station and the end station.
For example user try to get a bus line ...
9
votes
2answers
6k 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 ...
8
votes
3answers
3k 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 database table and retrieve them (trivial tasks). Which is better MySQL or PostGIS? Can anybody give ...
8
votes
2answers
3k views
How to load a data table as a 'vector layer' using PyQGIS?
This might be a simple problem, but how does one load a simple two column CSV with no associated geometric data?
I have given a couple go's via QgsVectorlayer[delimited text, spatialite] types - but ...
8
votes
2answers
6k 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.
...
8
votes
3answers
596 views
Efficient processing of difference between input data and database
I have an input dataset whose records will be appended to an existing database. Prior to being appended, the data will go through heavy, time-intensive processing. I want to filter out records from ...
8
votes
4answers
3k 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 to ...
8
votes
3answers
2k 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 ...
8
votes
2answers
1k 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 ...
8
votes
1answer
1k views
Using QField with Multi-User Access also Offline?
I got 10-20 QGIS-Users which edit all one Project online and offline. Sometimes they do it at the same time. Until now we only used QGisDesktop with a PostGis Database stored in QGIS Cloud(50MB ...
7
votes
3answers
4k 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 ...
7
votes
2answers
11k views
ST_Transform doesn't work in PostgreSQL
When i run the query with ST_Tranform I get this error:
Input geometry has unknown (0) SRID
SQL state: XX000
How can I resolve this error? I want to convert from UTM into geographic lat/lon.
...
7
votes
3answers
13k 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 ...
7
votes
1answer
8k 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 ...
7
votes
1answer
1k 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 ...
7
votes
1answer
2k views
Why is my XY Event Source layer only displaying at full extent?
My XY Event Source layer is only displaying at full extent and when I zoom in, the features disappear. If I select a feature in the attribute table, the feature is highlighted.
When I see this for a ...
7
votes
1answer
1k views
Imagery Database/Metadata Store
I'm a Remote Sensing PhD student, and as such I have a large number of satellite images that I'm working with. I'm starting to fail to keep track of them all and I have a lot of metadata that I want ...
7
votes
3answers
11k 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 ...
6
votes
3answers
28k views
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 ...
6
votes
1answer
1k 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 ...
6
votes
1answer
739 views
PyQGIS - Adding layer from PostGis database [duplicate]
I want to add new layer from PostGIS database but this code isn't working... Can someone help me?
uri = QgsDataSourceURI()
uri.setConnection("IP address", "5432", "ruian", "user", "pass", ...
6
votes
1answer
1k views
Need Advice - Displaying very large amounts of data on Leaflet js from database
I'm researching the best way to display a very large weather dataset (850mb +/-) for folks to use on their mobile and desktop devices. This huge dataset (1 point every 12km across the USA) that I'd ...
6
votes
2answers
2k 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. I'...
6
votes
3answers
43k views
How to embed a map into Access Database?
I am developing a database for my organisation that could be spatially enabled.
I have to use MS Access 2007 on Windows and am therefore looking for any possibilities to incorporate my Access ...
6
votes
0answers
74 views
Saving ArcMap/ArcGIS Pro symbology to a PostGIS DB for each layer
I want to have a default style/symbology assigned to each layer in a PostGIS database so that whenever it is loaded in ArcMap/ArcGIS Pro, it will come up with the default style.
There is a way in QGIS ...
5
votes
2answers
2k views
Data organization strategies for .csv and .shp
I'm organizing a large amount of data for a project and the data is stored in .csv format, with a code to relate each row to a polygon in a .shp. I was planning on converting the .csv data into .dbf ...
5
votes
1answer
11k views
Establishing a MySQL connection in ArcGIS 10
Is it possible to create a connection to a MySQL database in ArcGIS 10?
5
votes
1answer
1k views
Extract points from regular data.frame with coordinates based on SpatialPolygonsDataFrame in R
I have a regular data.frame called datos.merged
class(datosmerged)
[1] "data.frame"
The last two columns are the corresponding geographical coordinates
datosmerged[1,c(23,24)]
XCOORD ...
5
votes
1answer
582 views
PostGis and datatypes WKT
I dont't have any experience with the geographics databases so I hope that you be patiente with me, the thing is: I know that the datatype geography is used if all you care about is measuring ...
5
votes
2answers
3k views
Converting Date field to string using ArcGIS for Desktop?
I'm working with two data sets that require a compound key to join or relate.
The two fields are:
'Node_ID' which is a long integer field referring to a particular electrical substation [887932]
'...
