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

3
votes
1answer
913 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. ...
3
votes
1answer
278 views

Geoserver Link to External MS-Access Database

Is there a way that I can link a shape (as a polygon, with a LINK_ID = 12345) from Geoserver and have it open or link to the specific information (LINK_ID_DB = 12345) within an online Web Microsoft ...
3
votes
2answers
836 views

Table structure for a reverse geocoding database

I should start by saying that I do not have much experience with GIS so this question may be foolish. What I do have is a database for performing a lookup from a set of coordinates to find the ...
3
votes
2answers
112 views

Delete table rows in non-spatial database using arcpy

Working on a python script that does a bit of spatial analysis on a few layers, a spatial join of those layers, and then pulls data from a couple of other tables and holds them all in an in_memory ...
3
votes
0answers
32 views

DataB and DataB-copy worked on simultaniously - how merge DataB-copy into DataB

ArcGis 10 - EDITED (sorry for not being more specific, quite new to the arcgis world) We need to enter A LOT of Map data (Sewage system) into a Database in a relatively short time. It involves an ...
3
votes
0answers
84 views

Search in Bounding Boxes and Locations

Description of the problem (what I need): I have a set of bounding boxes (maybe the actual data is a location[longitude, latitude] in which case the bounding box will have identical corners). I have ...
3
votes
1answer
146 views

Choosing a GIS which imports a list of stage addresses, calculates the route, allows to modify and export it

I'm new to GISs. I'm searching for a GIS to meet following requirements. I have a list of street addresses [A,B,C,D,E,...], with additional information associated (basically which orders to deliver ...
2
votes
2answers
487 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 ...
2
votes
3answers
7k views

Python script: Access data from databases [closed]

I need to access data that is inside an oracle database using a python script. Its a Unix server running oracle 10g. I dont have much access to the database server. It works fine on model builder ...
2
votes
3answers
757 views

Looking for map calibration software and city database

I'm in need of a mapping software which, given a map, lets you calibrate it (choose which geographic coordinates project to which pixels on the map image) and then given a database of cities, you can ...
2
votes
2answers
620 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
281 views

Collapsing the multi-row output of a one-to-many spatial join to single-row (arcmap 10.1)

I'm working with TIGER data, looking at the relationships among incorporated places and counties. Not all places are completely contained by counties; some do span multiple counties. In the final ...
2
votes
1answer
131 views

spatial data filtering without GIS?

I have access to a database here (description of the columns are also available) containing spatial data in text format and with WGS84-EPSG:4326 coordinates. I would like to only select data in my ...
2
votes
2answers
606 views

Create a dbf table by copying the structure of another dbf table

I have a dbf table and I wish to automatically create another dbf table with a different name but with exactly the same structure i.e.fields as the existing table. Is there any ready code in VBA and ...
2
votes
3answers
1k views

Extracting data from GeoMedia *.mdf database without using GeoMedia?

Is it possible to extract data from Geomedia .mdf without Geomedia? Preferably with use of QGIS or ArcGIS for Desktop?
2
votes
1answer
362 views

stratigraphic ranking with field calculator?

I would like to populate a feature class float attribute with a numerical ranking of a text attribute of a geologic map. I have a field named [sheet_unit] with strings such as "H10, Q" and "J10, Pl" ...
2
votes
1answer
526 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? ...
2
votes
2answers
368 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 ...
2
votes
1answer
136 views

Tag for calculating way length in osm2pgsql?

There is a special tag 'way_area' in osm2pgsql creating a database column that stores the area of polygon features. So is there something like this for calculation of length of line objects?
2
votes
1answer
190 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 ...
2
votes
2answers
2k 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 ...
2
votes
2answers
1k views

ArcGIS Server simple link with SQL Server database

I am using ArcGIS Server 10 to create Rich Internet Application with embeded Maps. Basicaly, I created an Optimized Map Service on ArcGIS Server, from an MXD file (produced with Arc Map). I have ...
2
votes
2answers
993 views

Having trouble getting specific items from a list. What am I doing wrong?

I am a total beginner when it comes to python. I received some help already getting this code started but I hit a wall. I have a directory with 200 folders, each with a geodatabase, feature dataset, ...
2
votes
1answer
249 views

Are there any efficient methods for processing ArcGIS-based database tables outside of the ArcEtc program library?

Let us say, for the sake of argument, that you are working with a table that is over 2 GB in size (so .dbf is automatically ruled out... right?). To even create such a document, ArcGIS requires that ...
2
votes
1answer
76 views

OSM update without loosing own additional data

I have added data (e.g. name keys) to my OSM PostgreSql database. How can I update my database without deleting or overwriting this data? In other words, how can I merge newer OSM data to my existing ...
2
votes
1answer
126 views

How to fix: update of view in private qgis.db failed error

After a change in permissions, I started to get this error message: Update of view in private qgis.db failed. table vw_srs already exists I know that changing the ownership of the db or deleting ...
2
votes
1answer
195 views

How to change field length with ArcObject?

I want to change some string field in sdegeodatabse with bellow code. The code are running without any problem. but after running, filed length return to default length. What am i missing? static ...
2
votes
2answers
67 views

Is a multi-database select possible with DB Manager?

I have data in two locations: geometry data (with attributes) on a PostGIS server (read only) a geometryless table on a local SpatiaLite DB (read+write) I need to select features based on data ...
2
votes
1answer
590 views

Using ArcPy to get all database names within 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 ...
2
votes
1answer
1k 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
1answer
143 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 ...
2
votes
1answer
290 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 ...
2
votes
1answer
466 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 ...
2
votes
1answer
126 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 ...
2
votes
2answers
447 views

Looking for ArcPy tool for calculating statistics on field with summary field AND boolean fields

What I'm searching for is a tool that will sum a field by a secondary unique field AND booleans... Let's say I have 12 table each with 4mil records and the following fields: Donation_Amount ($ ...
2
votes
1answer
307 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 ...
2
votes
1answer
189 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...
2
votes
0answers
28 views

Attribute table update after v.split on GRASS GIS [duplicate]

So I just used v.split to create shorter segments (with just 2 vertices) of my contour lines. I was left with about 22000 lines but, when I open the attributes table, I find no more than 45 entry ...
2
votes
1answer
85 views

Visualize PostGIS 3D line geometry [closed]

I have PostGIS table with 2 geometries ( "GEOMETRY(MULTILINESTRINGZ)" and "GEOMETRY(LINESTRINGZ)" ). There are lines made just from 2 points - XY are WGS and both of them have random elevation Z (I ...
2
votes
0answers
29 views

Is there any map API that allows you to pull an address range from a polygon?

I've seen a lot of answers saying you can't draw polygons and get the exact addresses of all of the places contained; thankfully, I don't need so much info. I'm looking for a way to get a vague ...
2
votes
0answers
52 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
2
votes
0answers
47 views

Publishing Linked Datasets Format [closed]

This past summer for research I was working on linking the NOAA Rivers Database (http://water.weather.gov/ahps/forecasts.php), The National Atlas Lake Database, and the the USBGN datasets so that ...
2
votes
0answers
516 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 ...
2
votes
0answers
95 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 ...
2
votes
0answers
576 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
2k 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
0answers
74 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 ...
2
votes
0answers
69 views

Raster layer with unique vector for each raster cell?

I have been looking around several hours, even days, but couldn't find a clear answer to my question. I am working on a WebGIS tool that interprets local geology. From more than 70 asc-files, I would ...
1
vote
2answers
535 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' 50....
1
vote
2answers
994 views

osm2pgrouting connection failed

I'm importing data from my OSM file to a postgresql database using osm2pgrouting. I followed everything in from here and it went smoothly, until I try using osm2pgrouting. This is what happens: ...