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

1
vote
1answer
45 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
32 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
58 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
12 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 ...
0
votes
1answer
30 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 ...
-1
votes
1answer
41 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 ...
1
vote
1answer
54 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
47 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 ...
0
votes
0answers
16 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
74 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
37 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
44 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 ...
0
votes
2answers
100 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
81 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
37 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 ...
0
votes
1answer
33 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 ...
0
votes
0answers
24 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 ...
1
vote
3answers
33 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
41 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 ...
0
votes
1answer
78 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 ...
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
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 ...
2
votes
1answer
98 views

Is it possible to render map tiles with a Nominatim PostGIS db?

I've imported a OSM database using Nominatim's setup.php. It's possibile to use some software to render the tiles using that database, or I have to re-import in a different DB for Mapnik et similia? ...
1
vote
1answer
75 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 ...
2
votes
2answers
224 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 ...
1
vote
1answer
62 views

Attribute table field default value not transfering to new edited features

Using ESRI ArcMap 10.0, in a versioned environment, we are in a geo-database and have a feature class with a default value populated in field properties. When we create a new feature using editing ...
2
votes
1answer
50 views

Topology Editing using ArcView (now called Basic) license level of ArcGIS Desktop?

I am building a geodatabase from data collected on a GPS handheld in the field. The GPS device collects decently accurate information but I need to make sure all the polygons, lines, and points are ...
1
vote
0answers
68 views

Road traffic database sample?

I would like to do some experiments on a traffic forecasting neural network and I need some real traffic data to run the network. My question is where can I download some real traffic statistics data ...
0
votes
1answer
38 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 ...
1
vote
0answers
218 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 ...
3
votes
2answers
287 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] ...
3
votes
1answer
181 views

Put LeafletJS geoJSON's into a MySQL database through PHP

I'm doing a project that will let users manipulate a map through LeafletJS, creating circles and polygons on top of the map. I need to gather these inputs for later analysis, using a MySQL database ...
0
votes
0answers
10 views

Web Mapping Service Beginnings [duplicate]

I currently have a small relational database with six or seven tables that I've put together in Access on my home PC. One table includes locations, with columns for latitude and longitude ...
0
votes
2answers
77 views

How to obtain data to create average precipitation in 2012?

I am currently doing a final project, which I have to create a map of 2012 average precipitation of lower 48 states by using natural neighbour interpolation. The problem is that how can I get the ...
2
votes
0answers
74 views

Creating an automatic connection to Microsoft SQL database instance in QGIS

I have connected to an MS SQL database in QGIS using the Add MS SQL table(s) tool. However I have a lot of feature in my database and so it is inconvenient to reconnect to the database every time I ...
1
vote
1answer
41 views

How to save selected features from a postgis database into a new mini database

I have a postgis(v2.1.3)/postgresql(v9.3) database with geometry (geom1, geom2, etc.) and attribute (attr1, attr2, attr3, etc.) tables. The attribute tables are linked to the geometry tables using ...
3
votes
1answer
172 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. ...
1
vote
1answer
157 views

How to import geometry data from csv file to postgres?

I have geometry file in *.xls file, but when I save in *.csv it say "some feature in your workbook might be lost if you save it as CSV (Comma delimited)" however I keep that file anyway and when I ...
2
votes
0answers
253 views

Inserting coordinates from Google Maps into a Database

My question is pretty basic. I am using Android Google Maps to take the coordinates off a location on the map and I want to insert it into a PostgreSQL database. I know I have to use PostGIS but how ...
1
vote
1answer
218 views

How to transfer layer data from OpenLayers to PostGIS database or QGIS?

Supposing I have a created some layers in OpenLayers containing only Geometry Points, how do I transfer my data to a postGIS database? Is there a way to turn pure javascript/openlayers to a table in ...
1
vote
1answer
387 views

Why use a database when you can have all of your data in javascript/openlayers?

I have a really simple and basic question. First of all, I have to mention that I am pretty new to web applications and GIS. I am working on a web application using Openlayers, Postgresql/postGIS and ...
1
vote
3answers
58 views

Disconnect QGIS from database without closing the whole program

I'm making PostGIS queries to a GIS database from python and I'm using QGIS to visually check the results of my queries, but every time I want to run a new query I have to close QGIS because it keeps ...
0
votes
0answers
19 views

Backend: look-up address, spatial join, and enter to db

I'm not a GIS admin and we don't have one, so I am completely lost on this one. We currently have an sql db where folks remotely enter address data via web-browser interface and it is recorded as ...
2
votes
1answer
240 views

using arcpy to get all database names within a server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
1
vote
1answer
104 views

Google Maps, here maps data in one database

I want to create a database from here and Google Maps to combine with my data. Then I create an application that can use this database. Basically I want to host the server with Google and here map ...
0
votes
1answer
92 views

Loaded SQL Point Data not displaying correctly in QGIS map

Having some issue getting my SQL data to display correctly in my QGIS map layout. I am using Postgresql/Postgis, QGIS 2.4, Windows 7 (64bit OS). I created a database with some point data that is ...
3
votes
1answer
70 views

How do versioned views work with multiple editors?

I understand that in the database environment, by executing version_util.set_current_version('version1') Editor1 is able to write SQL statements against [table_name]_vw views to edit the data at ...
0
votes
1answer
50 views

About the storage of GIS attributes

I'm quite new to the GIS world and I currently have some technical questions for which I have no answers yet. I'd like to know the good way to store the attributes for a feature using the PostgreSQL ...