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.
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?
...
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
95 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
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 ...
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 ...
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
77 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
85 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
80 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
60 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
55 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
112 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
121 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
140 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 ...
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 ...
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 ...
2
votes
1answer
154 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
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
56 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: ...
2
votes
1answer
310 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
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
116 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
54 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 ...
5
votes
1answer
134 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 ...
10
votes
2answers
348 views
What is the best hack for importing large datasets into PostGIS?
I have to import large Shapefiles (> 1 million records) into PostGIS, and I have been wondering about the best way to do it.
In my question I used the word "hack", instead of tool, on purpose ...
4
votes
1answer
113 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
1answer
465 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 ...
0
votes
0answers
34 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. ...
1
vote
1answer
63 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
0answers
89 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 ...
2
votes
1answer
133 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 ...
0
votes
1answer
140 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
89 views
Is there a special tag to calculate way length in osm2pgsql?
There are special tag 'way_area' in osm2pgsql creating a database column that stores the area of polygon fatures. So is there something like this for calculation of length of line oblects?
0
votes
0answers
79 views
world city database (with lon,lat) & population per year
I'm building a visualisation with cities population around the globe for a website, found the MaxMind free database that includes most cities around the globe with coordinates and population, which is ...
0
votes
1answer
34 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
33 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 ...
2
votes
1answer
115 views
Best simple GIS for Estate inventory and mapping
I think my GIS needs would be considered simple for the 3500 acre estate I manage:
create maps of our roads, trails, fields, and buildings, and show distances on the roads and trails;
calculate ...
1
vote
1answer
189 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 ...
1
vote
1answer
76 views
Possible to store 3D features such as dome into geospatial database?
Is it possible to store 3D features such as dome into geospatial database such as PostGIS?
I know that it can store x,y,z data, can such complex features be stored into database?
0
votes
0answers
15 views
Aggregated zoning (sq footage) records by town [duplicate]
Is there a database of zoning records where you can find the square footage by room of an address? I would like access to it to create a cost splitting application.
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 ...
