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

8
votes
3answers
818 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 ...
0
votes
2answers
29 views

Global roads information prefrably with traffic volume

Im looking for a high quality global roads database. The only constraints I have is that it should be completely open (even foe commercial use) I have looked into some publicly available databases ...
1
vote
0answers
12 views

Web map linked to database that shows one spatial location at a time

I have a simple database with a record for each research project that occured on a national forest. Each project area is associated with a polygon, and there are around 200 polygons that are piled ...
-2
votes
1answer
73 views

What are shapefiles, layer files, and databases and what are their relationships? [duplicate]

What exactly is a shapefile in ArcGIS, and how is it related to a database or a layer file. What are the differences between these 3 things?
0
votes
2answers
58 views

How is a database related to a .mxd file?

What exactly is an mxd file, and how is it related to a database? Can a single database have multiple mxd files?
-1
votes
1answer
56 views

What is a database in ArcGIS? [on hold]

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 ...
3
votes
1answer
181 views

Building a ol3 webapplication with dynamic content and user registration

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. ...
3
votes
2answers
106 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...
2
votes
1answer
100 views

Tag for calculating way length in osm2pgsql?

There is a special tag 'way_area' in osm2pgsql creating a database column that stores the area of polygon features. So is there something like this for calculation of length of line objects?
1
vote
0answers
33 views

Combining Datasets from multiple scraped data CSV files using FME [duplicate]

My main goal is to collect information of US Golf courses located in the United States and geocode them to create a meaningful map. I was able to scrape from four sites in which I created 4 CSV ...
1
vote
1answer
149 views

connecting cartodb to existing mysql database

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 ...
4
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 ...
4
votes
1answer
457 views

Configuring spatialite database access for Python 2.6.6

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 ...
0
votes
0answers
27 views

How to use NewSQL Database with GPS tool with Node.JS as server side programming

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 ...
0
votes
1answer
240 views

Setting up a GIS server or platform

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 ...
1
vote
1answer
47 views

Where to store lat/lon data with additional informations?

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 ...
2
votes
0answers
35 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
6
votes
3answers
74 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 ...
0
votes
1answer
15 views

Adding data column by column in postgreSQL database

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 ...
-1
votes
1answer
53 views

Adding a column of WKT format in the table (postgreSQL)

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 ...
0
votes
1answer
40 views

How to change field length with ArcObject?

I want to change some string field in sdegeodatabse with bellow code. The code are running without any problem. but after running, filed length return to default length. What am i missing? static ...
2
votes
1answer
759 views

Installed PostGIS extension not listed for database

I have a PostgreSQL database with the PostGIS extension enabled. I know that this extension is enabled, since I am using PostGIS functions, and I can actually see the PostGIS functions. However, ...
1
vote
1answer
57 views

Column length editing in QGIS or ARCGIS

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 ...
0
votes
1answer
43 views

ArcGIS Route Analysis

I have a pipe network that is a imported CAD file converted to lines showing complete runs of pipe in a system. I also have a Access database imported to ArcGIS set up as a relate to my Pipe line ...
0
votes
1answer
76 views

Cannot add database connection using windows authetication SQL Server and ArcSDE 10.3

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 ...
62
votes
8answers
6k views

How do I get started with PostGis

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 ...
23
votes
11answers
32k views

Where can I obtain an up-to-date list of US ZIP Codes with Latitude and Longitude Geocodes?

NOTE: This began as a question on Stack Overflow, which has subsequently been closed. I also noticed a similar question about Most Up-To-Date Source for US Zip Code Boundaries, but I believe this ...
0
votes
0answers
19 views

Publishing Linked Datasets Format

This past summer for research I was working on linking the NOAA Rivers Database (http://water.weather.gov/ahps/forecasts.php), The National Atlas Lake Database, and the the USBGN datasets so that ...
0
votes
0answers
86 views

Is it possible to connect a libreoffice database to qgis?

Is it possible to connect a libreoffice database to qgis? I developed a database for our exploration points and would like to connect it directly to QGIS instead of exporting to csv.
0
votes
0answers
59 views

Geo spatial extensions in MariaDB vs MySQL

MariaDB is interchangeable with MySQL, but are there any differences in terms of each respective GIS features? Switching from one to the other is still a drop-in replacement with geo data types or ...
0
votes
0answers
56 views

Why is mapserver returning a blank image?

I am trying to load a layer from a postgis database, mapserver does not return anything. I think I have narrowed the problem down to the fact that the sql query mapserver is running is returning ...
4
votes
1answer
165 views

Pulling CSV file directly from website into QGIS?

I want to be able to automatically update my csv files in a QGIS project. My organization has an online database that can easily export csv files. These csv files are constantly updated with new ...
0
votes
2answers
110 views

Seeking web service that returns elevation profile between two points and can process 5000 requests per second

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 ...
1
vote
0answers
28 views

Export only one value from a one-band raster

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 ...
1
vote
1answer
106 views

How do I remove username / password from an ArcGIS mxd?

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 ...
1
vote
1answer
40 views

Adding non geographic data from MSSQL Database to QGIS?

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 ...
2
votes
3answers
862 views

Extracting data from GeoMedia *.mdf database without using GeoMedia?

Is it possible to extract data from Geomedia .mdf without Geomedia? Preferably with use of QGIS or ArcGIS for Desktop?
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
1answer
242 views

Joining MS Access (accdb) table to Feature Layer in ArcGIS for Desktop?

I would like to join a table from a microsoft access database (.accdb) to a featurelayer in ArcGIS 10.1. How do I associate tables from that database with existing layers that have a matching ...
0
votes
1answer
39 views

Connect MATLAB to cartoDB using Database Explorer?

I set up a database on cartoDB. I'm trying to use MATLAB to connect to the database using Database Explorer. I've downloaded the PostgreSQL driver. MATLAB asks for connection Parameters: Server ...
1
vote
1answer
82 views

Maintaining CAD drawings and Esri Geodatabase simultaneously?

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 ...
0
votes
0answers
31 views

How to visualize GPS dataset fro MysQL database and select dense areas

I am using Geolife dataset for simulation. I followed the pre-processing data tutorial to store all .plt files in a mysql database and export it in a .csv file. However, I want to select the ...
2
votes
2answers
951 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 ...
1
vote
3answers
37 views

How to find which areas/regions a list of lat/lons are in?

The Australian Bureau of Statistics (ABS) issues Esri shapefiles or MapInfo files which have a code # for each geographical area at various 'resolutions' and I have a database with a column of ...
0
votes
2answers
47 views

Importing and exporting KML into and from DashDB for Geospatial Analysis

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 ...
1
vote
0answers
239 views

Filemaker interface with QGIS

I have created a map of features on an archaeological site. The artifact inventory is in FileMaker Pro 12. Rather than creating a CSV file and using that as the attribute table, I would rather, if ...
1
vote
2answers
71 views

Using geodatabase for processing 7200 polylines?

I have 7200 lines and I want to divide each of them every 100 meters and take the coordinates of points from them. For that task should I create a geodatabase and put them in there? I am totally ...
0
votes
1answer
94 views

WMS layer connected to SQL database

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. ...
2
votes
2answers
54 views

Is a multi-database select possible with DB Manager?

I have data in two locations: geometry data (with attributes) on a PostGIS server (read only) a geometryless table on a local SpatiaLite DB (read+write) I need to select features based on data ...
0
votes
1answer
29 views

Migrating Data to Another Database whit FDOToolbox

I want to migrate my data (Shapefile) to a PostgresSQL using a FDOtoolbox , i searched a tutorial for that but i dont found it . can any one explain the steps to do for migarte the data from a ...