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

2
votes
1answer
10 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? ...
3
votes
1answer
344 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
1answer
141 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
190 views

Flatten / collapse one-to-many table and keep the 'many' attributes separate

I have a data set that contains intersection data. Each intersection node has up to 6 links which is identified by IN_LINK and OUT_LINK attributes. I want to create a new dataset that includes the ...
0
votes
0answers
21 views

Industries Database - EPRTR?

I am looking for a coherent , complete (At least EU coverage) and reliable (spatial accuracy) databse for INDUSTRIES I have been checking EPRTR database. Basically, it shows around 24,000 industrial ...
1
vote
1answer
35 views

Maintaining CAD drawings and GDB, best practice

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
99 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 ...
2
votes
1answer
318 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
25 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 ...
3
votes
2answers
86 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] ...
2
votes
1answer
26 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
2answers
36 views

attach point grid data non-grid points

Possibly a strange one: I have a dataset with loads of fields of environmental (explanatory) data, as a regular grid of points (black dots in image), and another dataset of sampled (response) values ...
0
votes
0answers
43 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
15 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
79 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
1answer
81 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
1answer
474 views

POI database of tourist attractions, or POI database with popularity index

I'd like to build a list of popular points of interest and tourist attractions for many/every city in the world. Is there any sort of dataset that I can use for this which either contains only popular ...
57
votes
8answers
5k 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 ...
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 ...
1
vote
1answer
798 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 ...
2
votes
1answer
135 views

Lidar and Opengeo suite

Opengeo suite has provided a tutorial on how to manage LiDAR data using postgresql. I was trying to follow the tutorial in this link. I am new to Linux and using Ubuntu 12.04. I have successfully ...
3
votes
1answer
4k views

Establishing a MySQL connection in ArcGIS 10

Is it possible to create a connection to a MySQL database in ArcGIS 10?
0
votes
2answers
63 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 ...
8
votes
4answers
4k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
2
votes
0answers
57 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
32 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 ...
2
votes
0answers
114 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
74 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
123 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 ...
2
votes
1answer
156 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 ...
4
votes
3answers
164 views

Hydrology, operational rainfall-runoff models

I am trying to collect information about operational rainfall-runoff models used around the world. I hope to build database with country outline with attached information what organization is covering ...
5
votes
3answers
8k views

How to 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 ...
1
vote
3answers
279 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
142 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
373 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 ...
18
votes
3answers
444 views

(When) should I use a GIS-enabled database?

I am a long-time programmer, new to GIS. I am trying to get a feel for the database aspects of GIS and I understand that there are some databases which are specialized for GIS use. Basically I am ...
1
vote
3answers
50 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 ...
5
votes
3answers
504 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. ...
5
votes
1answer
136 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 ...
0
votes
0answers
16 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 ...
1
vote
1answer
69 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
67 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
57 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
47 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 ...
1
vote
0answers
57 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
77 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
1answer
129 views

How do I join an MS Access (accdb) table to a Feature Layer in ArcGIS 10.1?

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 ...
1
vote
2answers
117 views

Cannot convert dms to dd in Excel 2007 using VBA code

I am trying to convert the data in an Excel sheet from dms (degree-minute-second) to dd (decimal degree) format using the vba script available here. Here is sample data: 53° 0' 39.31" 6° 44' ...
2
votes
2answers
55 views

PostGIS SQL NOT EXISTS Statements? [closed]

I'm trying to query my PostGIS database for ID of people who did X but did not do Y. I've attempted the query below, but it does not return any results. I'm very new to SQL so I may be overlooking ...
4
votes
3answers
227 views

Using a web map to identify and access data

I am trying to making a webpage where the user pans and zooms on a map, and based on the location and zoom level, some data is displayed on the webpage (drawn from another source). The data that will ...