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.
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
76 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
2answers
177 views
GIS Database Migration Project (Oracle to ArcGIS)
I have been tasked with converting an Oracle Database into an ESRI file geodatabase. The data represents a gas network. The client's Oracle database has over 400 tables, 120 of which are spatial. ...
4
votes
1answer
304 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 ...
4
votes
0answers
448 views
ARCMAP ERROR 000464: Cannot get exclusive schema lock
I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error...
ERROR 000464: Cannot get exclusive schema lock. ...
3
votes
3answers
983 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 ...
3
votes
1answer
1k 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
225 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
563 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
1answer
308 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
123 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
492 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
492 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
24 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
46 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
113 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
3answers
341 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
154 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 ...
2
votes
3answers
825 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
121 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
95 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
393 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
287 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
3answers
2k 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
568 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
180 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
98 views
Offline SLIPPY Map (Tiles) Database for Leaflet
How can create an offline cache of a large number of SLIPPY tile (PNG, 256x256) inside a web browser and then display them from that offline cache. For example, can one use HTML5 IndexedDB as an ...
2
votes
1answer
36 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
2answers
442 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
147 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
458 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
1answer
122 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
173 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
89 views
Adding polygon to existing database column
I've built a database with postgreSQL with a few geometry columns.
When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my DB using postgis. Now, I want to add ...
1
vote
3answers
457 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 ...
1
vote
5answers
881 views
Store Geometry in a database with the ESRI Silverlight API
Is it possible to store geometry objects in a database using the ESRI Silverlight API? For this particular case, the client may have SQL Server 2005 installed instead of 2008 and therefore I can not ...
1
vote
2answers
60 views
Which data formats can store Bézier curves?
I've heard that ESRI .gdb can. Are there other databases or file formats that can as well?
1
vote
1answer
25 views
Write unique ID(s) of polygons in layer A intersecting polygons in layer B to a field in layer B, in ArcMap?
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 ...
1
vote
1answer
179 views
Google maps api, several moving markers using a csv file containing the coordinates
I collected 5 sets of coordinates of moving vehicles and I want to play the scene using googlemaps API showing those 5 vehicles moving.
The sets are saved in a postgresql table.
is it possible ? if ...
1
vote
2answers
208 views
One Polygon Joining to Database with Many matching records
Using ArcMap 10.1.
Is this possible to have one polygon and join to a database/excel with many matching records?
I would like to have 1 polygon but match to 100 corresponding records in a table. When ...
1
vote
1answer
192 views
QGIS error when open project when layer via accesses the database
I changed from QGIS 1.7.3 to 1.8.0. Problem is that I can´t open QGIS Projects, QGIS crashes when there are layers involved loaded via access-database connection. I used eVis.
What can I do?
1
vote
1answer
74 views
Creating admin roles with limited access to PostGIS
I'm trying to cram three different organisations into one server. Today they each have their own geoserver instance connected to separate PostGIS databases, which works fine. But now they also need to ...
1
vote
2answers
617 views
Apply Database based Rules to Openlayers
im trying to apply rules, where the data is fetched from an external database.
This is my code:
// create a new style and add rules
var defStyle = new OpenLayers.Style({
...
1
vote
1answer
49 views
Trigger a python script to run after a row is added to the feature class
I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
1
vote
1answer
342 views
Linking SharePoint database with ArcGIS…possible?
Ok, so I the organization I am working for has a sharepoint database that multiple people update every time they do an inspection of natural resources on a parcel in the county.
This database has the ...
1
vote
1answer
38 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
124 views
Load information about a feature
I must mention first of all that I am very new to this area... I am developing a GIS application. I created a simple map using geoserver with openlayers, it is all working through apache tomcat - and ...
1
vote
0answers
59 views
Allocate places according to distance
I've asked this over on Stack Overflow but thought that someone may have a GI point of view that may help:
As an over-simplified example I have a list of events that have a maximum attendance:
...
1
vote
0answers
192 views
Connect QGIS to MSSQL view (i.e. not a table)
I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display.
...
