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

4
votes
2answers
367 views

Where can I find GeoJSON resources files?

I'm looking for demographic information and various things, and most of the time data are available as CSV (my application use geoJSON format). Shall I encode the CSV to geoJSON or is there a ...
4
votes
2answers
195 views

Using a web map to identify and access data

I am trying to making a webpage where the user pans and zooms on a map, and based on the location and zoom level, some data is displayed on the webpage (drawn from another source). The data that will ...
4
votes
2answers
490 views

Calculate Field based on field value in a second table

I have a table in a MSSQL Server Enterprise SDE database. I need to join a table from a MS SQLExpress Workgroup SDE database and then calculate 11 fields in the Enterprise table based on values in ...
4
votes
1answer
383 views

SDE analysis - file locking logistics - ArcSDE 10 on MSSQL

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 ...
4
votes
2answers
2k views

Arcpy Insert Cursor not inserting all rows

Good morning all, I have a script here that takes data from a cross-tabulated non-spatial dataset where monthly values are stored in a single table row for a given year and linearizes those data so ...
4
votes
1answer
216 views

Spatial index vs two coordinates indexes

I have a table with two columns: latitude and longitude. I want to get all objects inside a "rectangular" (well, rectangular in a lat/lon coordinate metric) bounding box: min-max latitude and min-max ...
4
votes
2answers
293 views

Fastest way to remove matched points

Hoping someone can see a faster way of doing this, because at the moment I'm averaging 9 hours per run for what I'm trying to do and well basically getting my behind chewed off by the boss :-) The ...
4
votes
1answer
1k views

Good place to get Country, State, City, and Zipcode information?

I'd like to populate a database with common location information. I'm not entirely certain that addresses across the globe have similar or even the same entities as the Country, State, City, and ...
4
votes
1answer
151 views

How to determine correlation between two databases?

I need to perform some tests and verifications on databases and/or datasets. I need for example to analyze two databases and then determine if there is enough correlation between both. My main issue ...
4
votes
1answer
327 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
3
votes
2answers
147 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 ...
3
votes
2answers
455 views

Can I import a .gml file into Spatialite in QGIS?

I have some Ordnance Survey Address Base data files which have a .gml extension. I have imported them to GGIS as vector layers along with some mapping data but would like to explore them with ...
3
votes
1answer
2k views

Establishing a MySQL connection in ArcGIS 10

Is it possible to create a connection to a MySQL database in ArcGIS 10?
3
votes
1answer
53 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 ...
3
votes
1answer
462 views

Using Google Earth to query database

I've been reading about using Google Earth to query data (this article) and I'm interested in learning how to make one of these. I just have a couple of questions: 1. Is this possible with the free ...
3
votes
1answer
700 views

Correct way to perform point-in-polygon queries on streaming point data?

Short version: What is the "correct" Esri-based solution to the presumably-common scenario of receiving dynamic asset location data (eg. aircraft), checking to see whether those points are within any ...
3
votes
1answer
1k views

Casting a Geography type in PostGIS

I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY, boundary GEOGRAPHY(Polygon) ); I added the following test polygon to the ...
3
votes
2answers
263 views

How to add data to relationship table in ArcGIS 10.1 database design?

I have created 2 tables HORSE and VENDOR and a relationship table VENDOR_HORSE With the foreign key in Horse being the Primary key in VENDOR (VendorID) and the foreign key in VENDOR being the primary ...
3
votes
1answer
382 views

Sharding of geospatial data

Reading through Rosenberg & Mateos' The Cloud at Your Service I stumbled upon the concept of database sharding. Authors point out to several advantages of such approach including high (online) ...
3
votes
1answer
284 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
2answers
213 views

Adding a GIS feature to existing database entry with QGIS

I've built a database with postgreSQL with tables, which include geometry columns. When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my database using postgis. ...
3
votes
1answer
168 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
969 views

How to read the GEOMETRY table inside a sqlite database

I'm working on an android app which should display some lineobjects stored in a sqlite database. This sqlite database is created through an export in QuantumGIS. My first question is it a real ...
3
votes
2answers
598 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
0answers
27 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
60 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
2answers
122 views

Hydrology, operational rainfall-runoff models

I am trying to collect information about operational rainfall-runoff models used around the world. I hope to build database with country outline with attached information what organization is covering ...
3
votes
1answer
125 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
4answers
1k views

Qgis: How to display special characters German “ÄÜÖß” in a Map?

I have a shape file with names for Regions. These don't seem to contain special characters but ugly hyroglyphes. What can I do do display them correctly. If I import the shape as UTF-8 it doesn't ...
2
votes
3answers
466 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
3answers
1k 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 ...
2
votes
1answer
477 views

What is the proper way to delete an SQL Server database in order to delete an SDE geodatabase?

I'm new to this SDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the SDE geodatabase. Is it as easy as right clicking on the database in SQL ...
2
votes
1answer
112 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
437 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
1answer
324 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
78 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
3answers
3k 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
2answers
742 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
203 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
414 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
2answers
696 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
1answer
185 views

Automate database conversion from NAD83 to Web Mercator

A NAD83 database is updated daily while a Web Mercator clone is only update when time is available. Looking to automate this process of Copying Layers Projecting them to Web Mercator Placing in ...
2
votes
2answers
595 views

.mdf Geomedia database

Question for today: Is it possible to extract data from Geomedia .mdf without Geomedia? Preferably with use of QGIS or ArcGIS? Thanks Tomek
2
votes
2answers
180 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
174 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
184 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
65 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
22 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
0answers
48 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
60 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 ...