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)

3
votes
1answer
259 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 ...
7
votes
4answers
2k views

Insert points into SQL Server?

I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark. ...
-2
votes
0answers
20 views

Spatial Database Development? [on hold]

Is database become GIS if there is/are spatial? Is it the same --the steps of developing---with normal database development where it have conceptual, logical and physical steps?
1
vote
2answers
35 views

Free solution for an intranet geodatabase for point data, connectable to QGIS / MapInfo

I have a plenty of point measurements - thousands of points with date/time, gps, measured values etc. I would like to make it possible to put all my particular datasets (can decide whether shp or ...
1
vote
0answers
30 views

Error using ST_Geometry Aggregate Function for Hive

I am using the ESRI framework that extends the Hive syntax to support spatial types and operations. In particular, I am trying to use an aggregated geometry function, announced in this blog post in ...
3
votes
3answers
1k views

Global solar radiation data

I need a solar radiation data in central Asia. Is there any global dataset of solar radiation. If someone know about it, please send to me the link. thanks a lot
0
votes
1answer
98 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 ...
1
vote
0answers
16 views

Seeking database that identifies adjacent postal addresses and/or zoning of postal address?

I apologize for asking such a basic question, but can someone point to: a database that identifies adjacent postal addresses (for example, if I provide an address, the database provides address of ...
2
votes
2answers
154 views

Detecting patterns in vehicle GPS data [closed]

I need to analyze data uploaded from vehicle GPS devices to detect travel patterns and then attempt to learn about the normal travel patterns for that vehicle so that predictions can be made about ...
1
vote
1answer
169 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
0
votes
1answer
67 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 ...
0
votes
0answers
98 views

Group Nearest Neighbor query in SQL Server 2012 spatial database

I am looking for way to perform a Group Nearest Neighbor (GNN) query over road networks in SQL Server. Any pointers?
1
vote
2answers
157 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 ...
0
votes
1answer
235 views

Getting fail to store Polygon Shape Object in Geometry Datatype with hibernate spatial API

Tried to store Polygon shape in database with HibernateSpatial API. I have followed this tutorial to store values. I am using Mysql as my database server. So Made some couple of changes for my ...
1
vote
1answer
42 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
0answers
36 views

How to select main cities in a country from planet OSM data

I am trying to create a map with my own style with the help of geoserver and planet OSM data,but trying to give style to the polygon at different zoom level ,need to highlight main in cities in ...
7
votes
2answers
1k views

Is there a performance hit from using a Feature Dataset?

I vaguely remember being taught not to use a Feature Dataset to make things "look neat" in the database, and that the Feature Dataset should only be used when there was some sort of spatial ...
4
votes
2answers
515 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 ...
1
vote
2answers
201 views

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

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 creating a ...
1
vote
1answer
142 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 ...
2
votes
3answers
55 views

Need to extract OSM data for my area from 2 neighbor countries

I need to prepare offline background data for my area of interest which is located around border between Czech Republic and Germany. I need to convert the OSM data to spatialite and then to use in ...
0
votes
1answer
38 views

Commercial Admin Levels

I'm looking to find commercially available admin boundaries (0 through lowest available) for the world that I can place into a user-friendly interface that allows the non-technical user (ie someone ...
0
votes
2answers
100 views

Appending fields from external tables to feature class?

I have some data in a relational database structure within a geodatabase i.e a feature class with several lookup tables. I need to flatten this data so that certain fields from the lookup tables are ...
1
vote
1answer
45 views

How to find a point on linestring and in a range of 10 meter

i have a linestring which is show in diagram and i have a point which is some time on the linestring or out of linestring but in range which is red line and some time its is out of range so how can i ...
0
votes
0answers
20 views

Looking for succesful implementaion of PPDM in form of geodatabase

I am have difficulties in implementing spatial version of Professional Petroleum Data Management (PPDM) for our GIS database. Does anyone have a reference to a sucessful case of implementing PPDM in ...
1
vote
0answers
69 views

Route tracking on google map php

i have to make a software which is track a vehicle on Google map using GPS. I have almost done this project but i am stuck at a point, the client require a system that track the bus in a route. I am ...
2
votes
1answer
41 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
17 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
27 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 ...
0
votes
2answers
58 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
2k 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
33 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 ...
3
votes
1answer
590 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
36 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
47 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 ...
0
votes
1answer
74 views
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
59 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
999 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
426 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
72 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
79 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 ...
15
votes
6answers
14k 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
40 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
92 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
85 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
244 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
22 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 ...