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
37 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
73 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
120 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
167 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
196 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
92 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
85 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
36 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
38 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
127 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
250 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
84 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
3answers
59 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 ...
3
votes
1answer
401 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
180 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 ...
9
votes
3answers
3k 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
97 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
74 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 ...
1
vote
1answer
275 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 ...
1
vote
0answers
42 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
832 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
599 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
40 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
319 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
0answers
44 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 ...
4
votes
1answer
507 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
262 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 ...
3
votes
0answers
72 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 ...
3
votes
1answer
145 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 ...
2
votes
0answers
714 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 ...
2
votes
1answer
268 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
1answer
77 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
199 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
259 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
308 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 ...
3
votes
3answers
5k 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 ...
2
votes
2answers
4k views

Reading National Elevation Dataset (ArcGrid/GridFloat/IMG) with python only tools

I've found high precision elevation (1/3 - 1/9 arcsecond resolution) data from the National Elevation Dataset provided by the USGS. It comes int IMG, Arcgrid, and GridFloat formats. I know ArcGrid ...
2
votes
1answer
102 views

How do you get a schema report from SHP, PostGIS, or other file type?

All, We're loading City and County data into our database, but looking to remove several fields we don't use. Those fields we do use I'd like our users to simply highlight on a printout I give them ...
1
vote
1answer
91 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. ...
8
votes
3answers
1k views

How to design a bus station query database schema?

We have bus station data, and we want to build an application which will provide the line/multiple line for a given start station and the end station. For example user try to get a bus line ...
1
vote
1answer
82 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 ...
0
votes
2answers
139 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 ...
3
votes
1answer
624 views

Database connection failed

I am trying to connect from Arc Cataloge (version 10.1) to postgresql 9.2. But every time I try to make "Database Connection" I am getting this error: Failed to connect to the specified server. ...
1
vote
2answers
201 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 ...
0
votes
0answers
100 views

HTML Popup Database Actions

I'm working on a collection of points on the map, each comes with a bunch of properties. I succeeded using a customized XSL template to show the information when I click on any point. And now what I ...
2
votes
1answer
757 views

WFS & Feature Access -> Database connection / Database support (ArcGIS 10.2)

Over the last two days I've tried to set up and to use a postgreSQL database to use WFS and Feature Access. I've also started a thread in the esri forums, but I hope that I can reach a wider audience ...
2
votes
0answers
61 views

Bounding Box approximation when calculating in euclidic space?

Although I will illustrate my problem using a database, I think this is a quite general GIS question. I hope I came to the right place to ask. I am working with a system that runs on a normal ...
1
vote
1answer
221 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 ...
3
votes
2answers
238 views

Non-spatial database analysis in ArcGIS - need alternative solution

I've recently joined an organisation where we use ArcGIS to do a lot of non-spatial analysis on a spatial dataset. Our main dataset is an environmental polygon survey with lots of attributes (in an ...
0
votes
0answers
48 views

How can I import layers into a database?

According to the QGIS User Guide (release 1.8.0, page 203/204) I only have to drag a layer from the QGIS Browser to the DB Manager. But for me this does not work.