Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.

learn more… | top users | synonyms (1)

2
votes
1answer
29 views

Determining date or time Feature Class was created in File Geodatabase?

I had a script running at the office over the last 5 days and tried to remote on unsuccessfully since the 3rd day. I got here and it appears there was a power outage. Is there a way to find out the ...
0
votes
0answers
10 views

How to use linear referencing in Informix DB with Spatial Blade?

Is there any simple solution to use linear referencing in Informix Database with Spatial Datablade?
1
vote
0answers
19 views

Migrate MS Access Data into Oracle DB

I was sent some old MS Access files that contained survey data and served as a "file geodatabase". I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning. I ...
1
vote
1answer
117 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
0
votes
2answers
52 views

SQL filter to show one layer only if another layer is missing

I have two oracle tables that represent buildings in my town. The first table represent buildings that are surveyed and measured accurately but doesn't cover all the parts of the town while the second ...
6
votes
3answers
1k views

What are convenient uml tools to create geodatabase models?

I used to model databases with Microsoft Office Visio, then export the model to xml and import geodatabase schema to GDB with ArcGIS tools. Since Microsoft no longer support Visio export to xml, what ...
1
vote
0answers
26 views

DB manager not updating

I'm trying to learn how to use spatialite databases, so have made a few experimental ones. When I delete them, however, they still show up in QGIS's DB Manager. If I try to open them it comes up with ...
1
vote
1answer
146 views

How to link 2 different images in eCognition

I'd like to link 2 different images in eCognition to find the same pixels on both images. The images have same projection (geog lat/long). How can I do this? Thank you so much
3
votes
1answer
461 views

Problem PostGIS Spatial Query ST_Contains ST_Disjoint ST_Intersects

I'm working on a project with two different tables inside a database. One contains points in a column geometry(Point,4326) type and the second one has a column geometry(MultiPolygon,4326). Now I would ...
0
votes
1answer
33 views

Spatial query to make view

I've got two tables which I want to combine and enrich with each others data. I'm getting stuck on the join part, as this needs to be done via a spatial query. First the table structure: a table with ...
2
votes
2answers
33 views

QGIS Forms - How Do I Display a Read-Only Value?

Older versions of QGIS had an "Immutable" option for form fields to make it obvious that data was read-only. How do I display values in the current version and make it obvious that they are ...
3
votes
1answer
250 views

Accessing data stored in related tables from a network dataset

According to ESRI's transit data model, this implementation, and several thesis papers, any non-spatial information (such as public transport schedules, employee info, trips etc) which is not stored ...
0
votes
1answer
74 views

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
1
vote
2answers
178 views

Using Qt Designer to Create a Form in QGIS that can search for a specific point in a layer

Good Day! I would like to ask if you can create a form in Qt Designer to create a form that can search for a point on the map using data that the user will provide such as the Name. I am currently ...
4
votes
2answers
435 views

FME - How to write all attributes when multiple source files have the same name?

I am using FME to write all the MapInfo TAB files in a directory and it's subdirectories to a File Geodatabase. I'm using dynamic readers and dynamic writers as I don't know the geometry or schema of ...
7
votes
3answers
5k views

How to export multiple featureclasses to shapefiles?

I have plenty features in a geodatabase. I need to save/export them into shapefiles, because my mate works with Manifold, which is not able to read geodatabases. Any Ideas? Click on every single layer ...
20
votes
3answers
1k views

What are the differences between spatial databases?

What is the difference between Oracle Spatial, PostGIS, SQLServer2008, SpatiaLite, and MySQL in terms of their spatial support. Are there specific use cases where each shines. What might you want to ...
0
votes
0answers
41 views

How to work with gdb from c#?

I have installed PostgreSql 9.3, PostGIS(last version) and Npgsql. I have geodatabase(tmp.gdb) how to make conection for this DB from c#? And how to connect this DB to PostgreSql? It possible to ...
1
vote
3answers
386 views

postgresql export database with command or pgAdmin III

I want to export my postgresql db with pgadmin. I search all of its GUI, I also searched the web and I don't find some sueful information. I know how to import the db into postgresql: create a db with ...
18
votes
3answers
402 views

(When) should I use a GIS-enabled database?

I am a long-time programmer, new to GIS. I am trying to get a feel for the database aspects of GIS and I understand that there are some databases which are specialized for GIS use. Basically I am ...
2
votes
1answer
61 views

Databases supporting intersection of multipolygons and a set of points

Currently we use PostGIS to store thousands of MULTIPOLYGONs and we can then use ST_Intersects to return any that rows contain any point in an input collection of points. Are there any other open ...
8
votes
1answer
1k views

Creating table containing all filenames (and possibly metadata) in File Geodatabase?

I need to create a metadata-table for all files in a File Geodatabase or Spatial Database. It would be awesome if it were possible to automatically be updated with new filenames, and possibly even ...
0
votes
0answers
70 views

When to use DBMS instead of System Files for Spatial Data Storage?

I'm having trouble deciding when it is best to use a DBMS instead of System Files for storage of Spatial Data. Are there any specific guidelines and reasons for when one method is preferred over the ...
14
votes
6answers
13k views

Is a Country/State/City Database available?

I asked this question Stack Overflow but I was informed that I would get a better to this question here because it's not related to programming. I am creating a directory which uses locations to ...
2
votes
0answers
38 views

How to know Who is reconciling the Version to DEFAULT(Parent) in Geodatabase

We have Public DEFAULT version and working Versions(Child) have been created directly from DEFAULT. We have also provided Reconcile-Post Option to group of Users placed at separate locations. Hence ...
0
votes
2answers
57 views

How to update Geodatabase point file table from Excel data using FME

I have excel spreadsheet with data that I want to load into a GeoDatabase point table. The table already exists and I want to update the data not append. There is a unique ID to link the Excel data ...
5
votes
1answer
78 views

Spatial+Temporal database request for 4D intersection

Here is the function I need to implement. My application deals with mobile objects with variable position and range (think of radar range). As I can't test each minute if n mobiles detect each other ...
2
votes
1answer
237 views

Does anyone know of a 'best practice' Seabed Survey Data Model (SSDM)?

Many of the offshore oil/gas companies are adopting an initiative from Shell for delivery of spatial data. This is called an SSDM, which is really an ESRI file geodatabase with a standardised ...
1
vote
0answers
20 views

Adding feature to remote geodatabase takes a long time

I have a program that I must add some features to a feature class that is in a sql server remote database. But when I want to open connection and add them, it takes a long time, about one or two ...
3
votes
1answer
51 views

Problem in Backing up a database in PostgreSQL

I need to create a backup from my database (in PostgreSQL 9.3). I have used the pg_dump tool, gives me an error. I have also used pgAdmin III for backing up which also gives me the following error: ...
0
votes
0answers
69 views

Exporting feature class from gdb crashes ArcCatalog

I'm trying to export a polygon feature class from a file geodatabase created and managed using ArcCatalog. When I click "export" a dialog window pops up, then another that says script error, then ...
1
vote
1answer
53 views

Implementing Wrapper of PostgreSQL?

How can I implement the Wrapper of PostgreSQL? I found this useful looking wrapper from a FOSS4G routing with pgRouting Workshop but I do not know how to implement it!
10
votes
4answers
3k views

How to export shape file to SpatiaLite

I have a shapefile with one layer. I can open it with QGis. Now I want to convert this shapefile or layer to Spatialite database. How can I do it? Is it possible to do with QGis?
1
vote
1answer
37 views

Spatial queries to find co-occurrences of POIs

Given a POI database containing different types of points, e.g. hospital and pharmacy, how can I select the locations where a hospital and a pharmacy are closer than a certain threshold (e.g. 1000m)? ...
0
votes
1answer
83 views

Refresh Map after Invoke URL

I am making a map on Auto Desk Infrastructure Map Guide Studio. Now I created a small ASP.NET website and hosted in local machine, Now on click of different buttons in flexible layout toolbar, I ...
5
votes
2answers
124 views

How to replicate ArcGIS Intersect in PostGIS

I'm trying to replicate this ArcGIS process in PostGIS: http://blogs.esri.com/esri/arcgis/2012/11/13/spaghetti_and_meatballs/. This describes how to break buffered points down into polygons based on ...
0
votes
0answers
128 views

Do any geodatabase schema and data migration libraries for .NET exist?

I'm performing code refactoring and database normalization in my project and looking for any .NET library for geodatabase schema and data migrations. Does any solution exist for ArcObjects? During ...
2
votes
0answers
94 views

Import GML data in SQL Server Spatial

I have GML file with Application Schema whose data I need to import into SQL Server Spatial. I have been creted database structure with all thing that I need in database, and now I need to fill it ...
-1
votes
2answers
52 views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
1
vote
1answer
85 views

GeographyFromText and ST_SetSRID+ST_MakePoint different results?

Why am I getting different results? SELECT ST_DISTANCE( ST_GeographyFromText('SRID=4326;POINT(13.401111 52.383343)'), --berlin ST_GeographyFromText('SRID=4326;POINT(9.997559 53.533778)') ...
0
votes
0answers
52 views

PostGIS Spatial query taking a very long time

I'm trying to return a count of crimes (points) that occur in each police grid (polygons), as well as the geometry data, but the query takes ~22 seconds. This seems oddly high and will be problematic ...
7
votes
1answer
334 views

Advantages of R-trees in comparison to geohashes

Geohashes are being widely used in products like: Lucene, mongodb, etc and have become one of the most important technology of present day. Have Geohashes replaced the good old R-trees or do R-trees ...
1
vote
1answer
53 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 ...
0
votes
4answers
58 views

Populate a field from another field with a conditional

I am working in SDE geodatabase where I have a feature class 'Mange_Waste' and "Q1", "Q2" are two fields. I wanted to use python script for populating "Q2" from "Q1" with a condition. Like, if the ...
1
vote
3answers
318 views

Merge Multipart Feature Line

I'd try to merge multipart feature line, but didn't work. would you please teach me how to merge multipart feature line? I work in version environmental and geometry network. Regards,
0
votes
0answers
13 views

Moving Vehicle through know digital data

I have a set of 3D digital map data for objects within an area. I want to drive a vehicle with known dimensions (3D points for extremities) through the area without hitting anything. I would have ...
1
vote
3answers
170 views

How to Build a graph from a map

I spent days looking in all questions here and trying tutorials. I need to build a graph for a region (It will be my input in simulation) I downloaded Postgresql and Postgis and osm2pgsql. Now i can ...
0
votes
1answer
1k views

How to find points inside each polygon in Mysql?

I have points table (with latitude and longitude columns) and polygons table with geometry stored in Mysql. I want to get points inside one polygon, for example in polygon which has column ...
22
votes
7answers
771 views

GIS Software Choice for a small university research centre

I need to choose a GIS system for a small university research centre. We are handling a broad range of data, (for example, numerical tidal analyses, weather data, poverty, isolated economic activity, ...
0
votes
0answers
90 views

How to improve performance using spatial indexing with STIntersects()

I am working on Spatial database. I need to check intersection of state geometry with geometry inside database. I am presently using the query as SELECT a.ID, a.OBJECTID, a.MSID, ...