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
1answer
30 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 ...
1
vote
1answer
144 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 ...
2
votes
1answer
98 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
64 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?
3
votes
1answer
525 views

Schema locking logistics on ArcSDE for SQL Server?

I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks. I have a interpretable ...
0
votes
3answers
53 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 ...
54
votes
8answers
4k 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
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.
7
votes
6answers
2k views

I'm looking for a comprehensive database of all cities/towns in South Africa

The title says it all really - I'm looking for a comprehensive list/database of all cities/towns in South Africa. I know about these guys: http://www.afrigis.co.za/, but they're just not getting back ...
0
votes
0answers
42 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
2answers
135 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 ...
7
votes
3answers
2k 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
89 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
67 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
156 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 ...
3
votes
3answers
2k views

Create an ArcCatalog OLE DB Connection using Python

Is it possible to create an OLE DB connection (*.odc) to a database in ArcGIS 10 , but using Python instead of the ArcCatalog GUI wizard? I don't need to necessarily create a file on disk, just make ...
0
votes
0answers
18 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
34 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 ...
4
votes
3answers
4k views

Is there a way to link ArcGIS to MS Access and use that DB?

I have an IT background but I am new to GIS. I recently recieved training using ARCMAP. I have about 5000 farmers that I need to put in a database and access the information using GIS. The vision is ...
1
vote
0answers
37 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
2answers
142 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 ...
2
votes
1answer
341 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 ...
6
votes
3answers
585 views

Suggestions for an efficient way to store raster files for lab use?

I'm trying to create a repository for our raster files from various sources and Im exploring the possibilities on how to store them and deliver them in our local intranet. I have come across rasdaman ...
1
vote
2answers
32 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
54 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!
8
votes
3answers
975 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
2answers
218 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
127 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
35 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
40 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
69 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
58 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?
8
votes
3answers
1k views

How to fix “Unable to initialize ODBC connection to DSN for ALC_AV_CO”?

So I am new to the QGIS community, and I have been trying to bring in some rather large access databases with little to no success. I have windows 7, so I've gone in through administrative tools/Data ...
1
vote
1answer
54 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 ...
1
vote
1answer
87 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. ...
4
votes
1answer
329 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
177 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
54 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 ...
2
votes
1answer
194 views

How can I copy archive data from one server to another?

I have an SDE 10.0 server and an SDE 10.1 server and I am trying to migrate the layers from 10.0 to 10.1. (On a side note the 10.0 server is running SQL Server 2005 and the 10.1 server is running SQL ...
1
vote
1answer
64 views

How to write unique ID(s) of polygons in layer A intersecting polygons in layer B to field in layer B?

I'm working in ArcGIS 10.1. Suppose that I have two polygon layers, A and B. Polygons in layer B can have one of a few relationships to those in layer A: They may be completely contained by ...
19
votes
8answers
7k views

What are the best databases for storing spatial data? Pros and Cons

A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...
16
votes
3answers
3k views

Database for offline slippy map tiles

I currently have an offline HTML5 map application (built on Leaflet & KendoUI with custom additions) that has an app manifest and works fine on multiple platforms. However, I am hesitant to use ...
17
votes
10answers
20k views

Where can I obtain an up-to-date list of US ZIP Codes with Latitude and Longitude Geocodes?

NOTE: This began as a question on Stack Overflow, which has subsequently been closed. I also noticed a similar question about Most Up-To-Date Source for US Zip Code Boundaries, but I believe this ...
0
votes
0answers
306 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
110 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
377 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
190 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 ...
1
vote
1answer
293 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
2answers
161 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, ...
0
votes
1answer
64 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 ...