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)

1
vote
1answer
14 views

Strategies for managing (and ultimately merging) duplicate business locations in a spatial database

I am working on a project right now that involves using multiple (very large) "location directories" to identify with the highest possible inclusiveness, a diverse set of business locations. These ...
0
votes
0answers
24 views

Is it possible pull multiple documents out of a geodatabase?

I am working on a sliverlight application in which a municipality will be able to view multiple assets for a water treatment plant within a GIS. Within this application, the user will be able to pull ...
0
votes
0answers
7 views

project from mongodb to a map

Is there any way I can directly project my coordinates stored in mongoDB onto a map? Some sort of opensource tool like OpenJump or something, which would allow me to connect to mongoDB and extract ...
0
votes
0answers
37 views

How to create a many to one spatial join?

I have a polygon feature class of territories and a point feature class of trees. The points have many attributes, one of them is the tree species name. I need to get the list of all the tree species ...
1
vote
0answers
14 views

Using polygons with libspatialindex

I am investigating using some C/C++ libraries for point-in-polygon lookups and libspatialindex seems popular. I've written some code that seems to do what I want but I'm not entirely sure if what I ...
1
vote
0answers
30 views

Precision for an FGDB raster dataset?

I would like to know the precision for an ArcGIS raster stored within a file geodatabase (FGDBR format); I can't seem to find this information anywhere in their documentation (apologies if I have ...
3
votes
2answers
53 views

Is transformation of spatial data lossy?

I have a shapefile that contains data of a country from the following Geographic Coordinate System ( GCS_North_American_1927 aka NAD27 ) contents from the shape file .prj: ...
1
vote
2answers
40 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 ...
0
votes
1answer
35 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
0answers
12 views

ArcGIS 000210 error copy to feature class [duplicate]

I have a script tool that: Creates a feature dataset within a file geodatabase Performs a Select by Attributes on a cadastral layer Copies the selected polygons into the feature dataset. The copied ...
0
votes
0answers
20 views

Group Nearest neighbor query in SQL Server 2012 spatial database

I am looking for way to perform GNN query over road networks in SQL Server. Any pointers
0
votes
0answers
16 views

GeoDatabase user access based on administration boundry

I have silverlight application consuming Map service. Now I want to create user login. The scenarion is somethinkg like when a user logs he should only be able to query on data belongs to his area. ...
1
vote
2answers
242 views

Is there a python script to count the number of feature classes in a geodatabase?

I would like to count the number of feature classes in a geodatabase. Some of the classes are in feature datasets as well. I have tried get count management, but that returns the number of rows in ...
4
votes
1answer
79 views

Homogeneous vs Heterogeneous schema in Postgis

Introduction I'm working on creating a spatial database in Postgis, to be viewed and edited trough QGIS to help managing some farmland areas. One of my goals is the have a centralized place where ...
1
vote
0answers
32 views

PostGIS replace view crashes PostgreSQL server from ArcGIS script

I have the following script which when from ArcGIS (and a similar script from a QGIS plugin) will update a view. Every so often (around 1 in 5 times the script is run) it causes the PostgreSQL ...
0
votes
2answers
51 views

Best way to combine 7 different shapefiles into one geodatabase

I have 7 different point shapefiles, and want to join them into one geodatabase. What would be the best method to do this in ArcGIS10?
1
vote
1answer
60 views

is MySQL spatial ready for production?

currently I'm using PostgreSQL/PostGIS for a small spatial project. Last week the project manager asked me if we could migrate to MySQL with Spatial Extension. I know MySQL but have no experience ...
0
votes
1answer
57 views

How to use the output file of a script as an input file for the rest of the script in arcpy?

If my question does not make sense or needs clarification please let me know. I am struggling to solve it so I was struggling to phrase it into a question. I have this code here: import arcpy,os ...
1
vote
1answer
105 views

How can I use Openflights database in QGIS?

I would like to have a shape file with the airports position and the routes of the planes I've found Openfilghts but I can't use it in QGIS. Seems that the format of the DB .dat is not supported by ...
1
vote
2answers
96 views

Connect AutoCAD Map 3D 2014 with MySQL

I need to connect AutoCAD Map 3D 2014 with an Spatial MySQL database (version 5.5) but first I have to install "libmysql.dll" to connect as specified in the software user's manual. This file is ...
1
vote
2answers
36 views

Joining data points to matching polygons

I have polygon data on coral reefs at great barrier reef and separate point data for areas of coral bleaching. I have created a clip that only includes points that exist with in the reef polygons. ...
4
votes
1answer
75 views

Extract points from regular data.frame with coordinates based on SpatialPolygonsDataFrame in R

I have a regular data.frame called datos.merged class(datosmerged) [1] "data.frame" The last two columns are the corresponding geographical coordinates datosmerged[1,c(23,24)] XCOORD ...
3
votes
1answer
178 views

Multiple geometry columns for points, lines, and polygons in spatialite?

I'm rather new to the GIS world and even newer to Spatialite and trying to create a new DB for our application. I would like to create spatial index(es) on the geometry column(s), but our geometry ...
2
votes
1answer
111 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
66 views

Downloading an unzipped File Geodatabase from USGS

I am attempting to download a file geodatabase from the pubs.usgs.gov site. The file db is DDS69ff.gdb The browser sees the file as a directory so I am having trouble downloading the complete file ...
0
votes
1answer
75 views

Choosing a database for cartesian coordinates

I'm trying to figure out, which database would be the best choice to store cartesian coordinates (x,y,z). I want to query for the distance between 2 positions, which positions are in a sphere ...
2
votes
2answers
343 views

How to convert 6 digit Latitude & 7 digit longitude to degrees

Sorry, but I'm a bit knew to the whole GIS world, and though I am making great headway drawing Polygons and such in Bing Maps, I am currently stuck. In our SQL Spacial Data, I came across ...
0
votes
1answer
295 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 ...
0
votes
0answers
22 views

Why does MAPublisher need to install Office 2010 redistributable x64 version to connect to Personal Geodatabase (MS Access)?

I am trying to connect to a personal geodatabase. a .mdb file, with MAPublisher but I get the message immediately to install a Office 2010 redistributable x64 version. I have installed 64 bit office ...
1
vote
2answers
46 views

Calculate Coordinates with tolerance

I am trying to find the XY coordinates that can be allowed with the tolerance of 2 meters. In the above image, When the user(smiley) with GPS reach the ----- border line, the system should ...
0
votes
0answers
45 views

How to get Geodatabase into Oracle database/ Tables

Simple question possibly. But how can I import a Geodatabase into a oracle database. I like to put data into tables but just wondering what is the best way or tools to use? Will it be through FME ...
3
votes
1answer
289 views

How to create linestrings with a definite angle and length, that are fixed to a point

I want to create linestrings with a definite angle (e.g. 160°) and length (e.g. 2m) that are fixed to a number of points of another linestring. So, I want to use the ST_DumpPoints function to find the ...
0
votes
0answers
16 views

Can't connect QGIS 2.0 to postgresql 9.3 remote server with postgis 2.1 [duplicate]

I am trying to connect qgis to my postgresql server using the add postgis layer option in qgis dufour. I am not getting any details from qgis other then 'connection failed check settings.' However, ...
5
votes
1answer
122 views

How to build query expression to display text from one-to-many relationship in ArcMap?

I have two tables in an enterprise geodatabase stored in PostgreSQL and accessed via ArcSDE: parcel and person 1 or + parcel can have 1 or + person (relationship is pll_person) I can display all ...
1
vote
0answers
93 views

Is the postgis layer option in qgis 2.0.1 Dufour two way? Was the spit plugin built in?

I am trying to install postgresql with postgis on a remotely accessed terminal only installation of ubuntu 12.04 that I want to use to connect to qgis 2.0.1 and hopefully have a two way transfer ...
1
vote
1answer
39 views

How to specify relationships (foreign keys) in a spatially enabled database for census geography?

Lets use the Canadian census geography design as an example: In my experience, a spatially enabled database for census geography can be created in two ways: Each geography contains a foreign key ...
4
votes
0answers
143 views

Weather conditions forecasting / interpolation

I'm trying to carry out weather conditions interpolations. I have information of 92 weather stations for 800,000 km2. As you can imagine the extension of land is huge and I need some kind or weather ...
2
votes
1answer
105 views

How to construct geographies from WKTs

I am using a SQL Server 2012 database. I have noticed that geometries and geographies interpret WKTs differently. For instance, if I construct a square polygon, clockwise: DECLARE @geom ...
0
votes
1answer
55 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 ...
2
votes
1answer
97 views

Model or Code to query all feature classes in geodatabase by selecting by attribute

I have a geodatabase that has 60+ feature classes that each contain records for 60+ locations. I need to export all records from each feature class for a specific location. In each FC there is a ...
1
vote
1answer
89 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
2answers
463 views

“Create Enterprise Geodatabase” errors

I am trying to use " Create Enterprise Geodatabase" option in arcmap 10.1: I am getting two following errors: You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL ...
2
votes
0answers
151 views

GeoDatabase topology and rules with a *.rul file

I have been working for some time on a solution to a problem much like this question. I have several layers that I want to resolve together. I have them all in topology (geodatabase) and have been ...
1
vote
0answers
157 views

where to copy ST_geometry.so on Linux server?

I run PostgreSQL 9.2 on an Ubuntu server. Through ArcCatalog 10.1 I can connect to the database (although it is empty right now). When trying to "Enable Enterprise Geodatabase" I get the following ...
3
votes
0answers
72 views

How to express not within/inside predicate in spatial database with good performance

In our application we want to express some spatial predicates as objects not within some areas, but unfortunately it has very bad performance. The following SQL is generated by our application: ...
2
votes
1answer
229 views

Can Tiff files from ESRI Geodatabase be loaded into QGIS

I have been able to load an ESRI geodatabase which contains shape files into QGIS, however when I try to load a geodatabase containing tiff files I get an error message saying ...."is not a valid or ...
2
votes
0answers
30 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 ...
3
votes
1answer
576 views

Oracle spatial SDO_RELATE: why better performance result from UNION ALL/INTERSECT combined individual specified mask

Initially I was trying to find out why it's so slow to do a spatial query with multiple SDO_REALTE in a single SELECT statement like this one: SELECT * FROM geom_table a WHERE ...
1
vote
0answers
32 views

How to load or query data directly to R from a PostGIS database using RPostgreSQL and rgdal [duplicate]

Is it possible to load/query a shapefile to R, which is stored in a postgres/postgis database? I've built up a connection to my postgres database via DBI, RPostgreSQL and I want to make some ...
0
votes
1answer
60 views

QGIS Value Map Edit Widget with properties dependent on another field

I'm having a problems with Edit Widgets in QGIS. I'm working on a GIS Database for archaeological data, where every site is represented by a polygon. In the attributes there is a field for the era ...