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 ...

I was wondering in general, what exactly is a database and is there a difference between that and a geodatabase? I was also wondering when you would use a database as part of ArcGIS. Do you make one ...

My setup:
currently i'm using a postgis database, get it with a geoserver and display it with openlayers 3.
I use the wfs data to display the features in clusters and i'm able to edit them with wfs-t.
...

I'm trying to create a simple heat map based on longitudinal and latitudinal map coordinates that can be transferred from a database on mysql that I've created. I read that cartodb can be connected to ...

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 ...

I'm working on a GIS project, and I would like to implement and test some geo-spatial algorithms in Python. For this purpose, I will not only need sqlite, but also spatialite, in order to store and ...

I am a web project manager and I want to create a website to show current position of cars on the map (google or ARC). I know how to create the website, but I don't know how to fetch the longitudes ...

Sorry for my lack of knowledge.
I have been using GIS for a while but just for analysis and don't know much about the data side of the business.
Recently my boss asked me to think about setting up a ...

I have huge database of lat/lon GPS coordinate points. For every point, I have several other variables (height, surface type, temperature, pressure...).
Also, data will be changed every day and old ...

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 ...

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...

I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use?
I need to create this database for mapping. There are about 30000 features ...

Can anyone suggest how I can change the length of an existing column (For ex. column name -- ABCD, column_Type -- Text, Length -- 254). It would be great to have solution on platforms like ArcGIS or ...

We can't seem to add a database connection from ArcSDE to sql server 2008 using ArcCatalog 10.3.1 from a specific computer with a specific username. When trying to add a database connection using this ...

I have been reading a lot about it, but I am struggling to find a good beginner's guide.
Which tutorials/books do you recommend? My past experience involves python and arcgis. But I have never worked ...

I need a web service that provides elevation profile data between two coordinates with request rates at a minimum of 2000 requests per second but preferably at 5000 per second. The distance between ...

I have a PostGIS database with a georeferenced raster, with one band which contains values from 0 to 255.
I should export it to a transparent GeoTiff picture in which the only visible pixels are those ...

When you create an mxd and use layers from a database connection where you are using "Database authentication" and clicked "Save username and password" and share the mxd with others, why are others ...

In QGIS (2.8) I am trying to add non-geometric data / flat data that originates in a MS SQL database. This flat data later should be joined with other layers etc.
Connecting to the specific 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 ...

I'm wondering if there is a best practice for maintaining both CAD and ESRI GDB sytems simultaneously?
I work for my local municipality and as it is now the Eng Techs update reference drawings in CAD ...

I am a recent convert to IBM's DashDB, and I considering proposing to use it at my work. My case would greatly be bolstered if I could show good, easy integration for geospatial analytics data, namely ...

It is possible to connect a WMS layer to a SQL database or other type of database?
Example: I have created an application with Geoserver and OpenLayers. Now I can see the data from attribute table. ...