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
65 views

What is best way to reorganize osm into PostGIS database entity?

I'm just wondering how to reorganize the OSM given entity to more flexible and schematic purpose. The OSM gave 4 entities the planet_osm_line, planet_osm_point, planet_osm_polygon and ...
1
vote
2answers
291 views

What is a good Javascript API for weather data?

I'm looking for a good javascript api which gives access to a weather data-base. I want to extract information like average number of rain days, amount of sunshine and average temperature. Is there ...
1
vote
3answers
283 views

How to create efficient database for routing?

I created a database of many important features and locations of my city, and I want to find shortest/fastest path between two locations. Now, I'm calculating the route by using A* algorithm in Java ...
1
vote
1answer
90 views

How to import a postgis database in ubuntu (osgeo live 7)

How does one import a postgis database in the ubuntu/osgeo live environment? In windows I would copy the backed up database file into the postgres bin folder and then use cmd to restore the databse. ...
1
vote
1answer
78 views

Saving a subset of a database

Here is a complete beginner´s question, maybe someone has time to help: I just downloaded the Corine land cover sqlite file, the whole database has 5.5 GB and takes forever to open. How can I save a ...
1
vote
2answers
187 views

ArcReader 10.1 trouble (loading and printing is taking very long ime)

We've run into printing problems in ArcReader 10.1. Our trouble is with a particular floodplain feature class located in an SDE database. It simply takes forever to load! Then, when printing, it takes ...
1
vote
1answer
197 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 ...
1
vote
1answer
830 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 ...
1
vote
1answer
362 views

Are database client files platform specific?

I'm just looking for some clarification on a question that came up with me this morning. Are the DLL client files (libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll) platform ...
1
vote
3answers
515 views

Load information about a feature

I must mention first of all that I am very new to this area... I am developing a GIS application. I created a simple map using geoserver with openlayers, it is all working through apache tomcat - and ...
1
vote
1answer
842 views

Linking SharePoint database with ArcGIS…possible?

Ok, so I the organization I am working for has a sharepoint database that multiple people update every time they do an inspection of natural resources on a parcel in the county. This database has the ...
1
vote
2answers
61 views

I have 7200 polylines should I use a geodatabase for processing them?

Hello 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 ...
1
vote
1answer
78 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 ...
1
vote
0answers
58 views

Word cloud labels in QGIS from database

I would like to do some word clouding as labels in QGIS from a series of tables in a database. Examples of word clouds can be found here: Word Cloud - Google Search I have two tables in a database: ...
1
vote
0answers
79 views

Adding information from excel into ArcGIS [closed]

I am working in ArcGIS and have a excel sheet with data pertaining to properties. I want to add this data to a map in ArcGIS of which i have property boundaries as a shapefile? I have a common folio ...
1
vote
0answers
93 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 ...
1
vote
0answers
41 views

Is it possible to retrieve lost versioned data in SQL Server Management Studio?

One of my staff accidentally deleted a feature class she was creating in her version before I reconciled it. I have grabbed a back up of the database from yesterday in SQL Management Studio. Is ...
1
vote
0answers
43 views

Appropriate data structure for a bunch of polygons

I'm not a GIS guy so this might be a very misguided question. At present I have compiled a python dictionary, on which I perform some simple processing and return some answers. My data is structured ...
1
vote
0answers
565 views

Coverting annotation into a shapefile

I have created an annotation feature class in Arc10 and when viewed within the database, looks great. However, whenever I go into catalog and export the annotation feature class to a shapefile, it ...
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: ...
1
vote
0answers
366 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
71 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 ??
1
vote
1answer
296 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
0answers
70 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 ...
1
vote
0answers
193 views

How exactly is an SLD_body object (when extracted from its XML href) structured when using a cElementTree to parse it?

I'm trying to export data from a PostGIS database into a geoserver and I've gotten it to where I can get the PostGIS database to point to the geoserver (I'm doing this as a python script for a GIS ...
1
vote
0answers
97 views

Getting started with storing LoST and GML searching

I am working on a logging and search database application. The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
0
votes
2answers
137 views

Do I have to convert a line shapefile to points to store it in another database?

This is the surprisingly the first time I've come across this. If I wanted to export a line shapefile from ArcGIS to another database (say Access) would I first need to convert the vertices to points ...
0
votes
1answer
312 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 ...
0
votes
2answers
66 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 ...
0
votes
2answers
96 views

QGIS Connection PostGIS and shapefile

I'm working on QGIS with a database created in PostGIS and a shapefile. Inside the database, I have geometry type data about location of some points, instead on the shapefile there some selected ...
0
votes
1answer
501 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?
0
votes
1answer
336 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 ...
0
votes
1answer
277 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.*, ...
0
votes
2answers
149 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 ...
0
votes
1answer
72 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 ...
0
votes
1answer
48 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 ...
0
votes
1answer
35 views

web map service - does it update by default when data is amended in Oracle source tables?

I have a WMS which source data is held in Oracle. Every year an amendment to the view in Oracle is run to update records. Does the web map service need to be re-published once these amendments are ...
0
votes
1answer
37 views

GPL-compatible database of country & region names

For WordPress's sister project BuddyPress, we are looking for relatively-reputable resources that manage a list of countries and regions. Due to the WordPress OpenSource philosophy, we are only ...
0
votes
3answers
57 views

Integrating ArcGIS for Desktop with Past Perfect for mapping public art objects?

I am working on a project where I need to map out several assets that are found around the city. The Arts Department utilizes a software called Past Perfect to catalogue and track any art assets. My ...
0
votes
2answers
664 views

How to join MySQL database to QGIS polygons

I Have an *.sql file that has no spatial information. For every record there is an id. I also have a Qgis project with polygons without any id. How can i connect the polygons with the database? I ...
0
votes
1answer
91 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 ...
0
votes
1answer
29 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. ...
0
votes
1answer
22 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 ...
0
votes
0answers
48 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
0answers
17 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
0answers
99 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 ...
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
0answers
17 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 ...
0
votes
0answers
35 views

How to get sql error from postgis when a plugin fail to load vector layer?

I am writing a plugin for qgis that load a sql layer from postgis database. I am disappointed that when the layer fails to load i can't find a way to get the sql error message from database server. ...
0
votes
1answer
150 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 ...