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

0
votes
0answers
11 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
2answers
34 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
15 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 ...
0
votes
1answer
48 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
61 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
27 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
17 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
18 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
70 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
78 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
51 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
14 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
46 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 ...
1
vote
1answer
125 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 ...
1
vote
2answers
98 views

Most optimal way to create a (spatial) database for big amounts of data?

I am using QGIS, and on my way to set up a huge spatial database (geographical), where most of the data is points without geometry), along with other types of data (like lines in DXF and areas in ...
4
votes
3answers
322 views

QGIS, Postgis: Geometry type does not match column type

I'm trying to import some polygon shapefiles to Postgis in QGIS via SPIT. One of them can't be imported and returns this error: ERROR: Geometry type (Polygon) does not match column type ...
0
votes
2answers
69 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
0answers
56 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
0
votes
0answers
30 views

Compatibility between ArcGIS for Desktop 10.2.1 and Node4j databases

The software that I use for spatial analysis and database connection with an external database is ArcGIS for Desktop 10.2.1, by Esri. Do you know if it is technically possible to connect ArcGIS for ...
1
vote
1answer
110 views

Calculation to convert db data to Lat/Lng degrees

In a database I have the following Lat/Lng data. I wish to convert it to a readable format. 177514245:34726053 => S 32 7.3947, E 115 51.4245 177513828:34726948 => S 32 7.3052, E 115 51.3828 ...
0
votes
0answers
15 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 ...
0
votes
0answers
32 views

How do you assign classes to percentage data in a data layer?

As a learning project I need to coneptualize a GIS output for assigning classes to data in a raster layer. In this case i have the unemployment rates for relevant magisterial districts in my ...
1
vote
0answers
36 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 ...
0
votes
2answers
96 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 ...
2
votes
1answer
163 views

is there any direct access to Mapbox data? (similar to CartoDB's sql api)

I've been asked to add a form to a map that will write data in the background (e.g., ajax to a magic file that does datawrites and some emailing, notifications etc) and a new marker will be added to ...
1
vote
2answers
98 views

spatial database vs spatial datastructure?

I am building an automated system that has to process several hundred spatial queries in the form of a polygon every day. The queries have to return both spatial and nonspatial data from different ...
0
votes
0answers
35 views

How to export QGIS elevation data to Mysql WAMP

is there a way to export elevation data from QGIS to wamp server(mysql)? please help me. I need to store all the data to mysql wamp.. thanks!
1
vote
2answers
25 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 ...
1
vote
2answers
105 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 ...
0
votes
0answers
103 views

PyQGIS + PostGis: FATAL: sorry, too many clients already

I searched for questions regarding this problem and hadn't find one. I'm developing a custom application with a map canvas to show some geographic information from a PostGis database. After some ...
0
votes
0answers
28 views

ArcGIS 10.1 MakeTableView doesn't filter records

I'm running ArcGIS10.1 on Win7 64bit with Oracle 11g and I'm having trouble with database table connections in Oracle. In Modelbuilder I use the MakeTableView tool and apply a filter expression so ...
1
vote
0answers
35 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 ...
0
votes
0answers
52 views

Best OpenSource Database to serve images on web?

I am using a mysql database where I store images as blobs. From here, I serve them on the web. Does anyone know if there is another opensource option that works better? I would need something to ...
0
votes
0answers
41 views

Los Angeles Public Parking Lot Polygons?

So, I'm looking for some relevant data to incorporate into my map, and one of them is public parking polygons. Is there such a .shp file with these data?
1
vote
1answer
41 views

Spatial database data representation vs. spatial programistic libraries representation [closed]

Can anyone tell me what is the difference between spatial database data representation and spatial programistic libraries representation? It is not clear to me. I have tried to google it and I can ...
4
votes
1answer
149 views

Extract points from regular data.frame with coordinates based on SpatialPolygonsDataFrame in R

I have a regular data.frame called datos.merged class(datosmerged) [1] "data.frame" The last two columns are the corresponding geographical coordinates datosmerged[1,c(23,24)] XCOORD ...
2
votes
0answers
108 views

How do I capture data from an OBD-II device?

So I happen to have a little bit of web experience, and have recently bought an OBD-II device. Basically, I'm trying to log certain metrics from the car, such as location and other diagnostics. I ...
2
votes
0answers
34 views

Insertion of a raster geotiff in PostgreSQL database

I am new in PostgreSQL and psql. What is the method to insert a raster geotiff in a postgreSQL database using command psql? What is the best format? Someone indicates to save a raster image as BLOB ...
1
vote
1answer
82 views

Detecting patterns in vehicle GPS data

I need to analyze data uploaded from vehicle GPS devices to detect travel patterns and then attempt to learn about the normal travel patterns for that vehicle so that predictions can be made about ...
0
votes
0answers
10 views

Can we use bounding box with Mysql? [duplicate]

I need to show the data from the database, but only those data in the current user's view. I need bounding box option for that. Is it possible with mysql?
0
votes
0answers
223 views

How to add lat/lon data in ArcGis 10.1?

How do you add xy data to a DEM Raster in ArcGIS 10.1? I have done this before, and it has worked just fine. However, when I recently tried adding a MS Access database which has lat/lon coordinates ...
3
votes
1answer
68 views

How to combine Spatialite Databases

I'm trying to combine a few Spatialite Databases into a single database, so that I can properly reference them, etc. I don't care about referencing them to one another (No foreign keys, etc), but I ...
1
vote
0answers
160 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
1answer
139 views

How I can insert feature attribute after feature drawing complete

I am new to OpenLayers. I am trying to insert wfs feature information to my map after drawing like this. I can draw a WFS feature like (polygon, line, point) on map and after drawing the feature ...
0
votes
0answers
50 views

How to get Geodatabase into Oracle database/ Tables

Simple question possibly. But how can I import a Geodatabase into a oracle database. I like to put data into tables but just wondering what is the best way or tools to use? Will it be through FME ...
0
votes
1answer
51 views

How to get edge length(distance) from pgrouting DB

I have implemented pgRouting workshop and it's working fine. I need to get every edges length in kilometers to do some calculations I studied the ways table. It contains a length attribute, but it ...
1
vote
2answers
126 views

County-Level Ethnic Shapefile: United States

My professor usually provides the shapefiles that we deal with in our analyses of the United States--population, votes, etc., but I'd like to know how I can get these myself. I'd like, in particular, ...
6
votes
2answers
206 views

What technology is used behind arcpy cursors?

I'm using ArcGIS Server 10.0. I have a geoprocessing using arcpy search, update and insert cursors. I'd like to know more about the technology behind these cursors. Does it use any driver or pool to ...
1
vote
3answers
190 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
3answers
1k views

How to create a new 'gis' database in PostGIS?

I'd like to create a new database in PostGIS, so I can load stuff into it while the current database is being used. According to the docs Some packaged distributions of PostGIS (in particular the ...