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
2answers
64 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
50 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 ...
4
votes
1answer
395 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
138 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
102 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
47 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
182 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
116 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
73 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
114 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
120 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
1
vote
2answers
722 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
178 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
210 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
76 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
355 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
1k 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
34 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
76 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 ...
0
votes
0answers
560 views

Convert a decimal degree to meters from the MySQL Spatial GLength

The MySQL Spatial function GLength returns the distance between two points, this distance is in the same unit from the projection. Since I'm using the WGS84 (SRID:4326) the answer will be with ...
1
vote
0answers
340 views

Check if a point is near a linestring with MySQL Spatial Extension (untrustable)

I have to discover if a given point is at least 500 meters (ou other distance) from a route line that exist in my database recorded using the MySQL Spatial. I see there is no similar function in ...
2
votes
1answer
606 views

How to set appropriate spatial index for a feature class in Oracle?

I wanted to ask is there any known method how to set spatial index for my feature class in Oracle. I am working with ESRI 10.1 and I have various feature classes covering the whole area of my country ...
0
votes
1answer
67 views

Are .shp files coordinates in a certain direction?

I'm working on a project where I'm importing a .shp file into SQL Server. I'm using the Catfood.dll and I'm wondering if each point in the polygon are sequential (going in the same direction)?
2
votes
0answers
286 views

Publish ESRI Feature Services from spatial view on ArcGIS Server 10.1

I have a feature class layer and a handful of non spatial plain tables in a 10.1 SDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as for ...
3
votes
1answer
78 views

Should states/provinces be stored as geographic or geometric data types?

While reading the GeoDjango documentation, they advise using geometric rather than the geographic data type when storing values that are on a continental scale. The Canadian province of Ontario, for ...
1
vote
0answers
74 views

Why is my linestring not valid ? was recorded from GPX file

I have a linestring that was built from points from GPX file. I've insert it to sql as geometry and when I try to run funcs on it (like STStartPoint ) I get error that line isn't valid and I need to ...
2
votes
1answer
327 views

Where can I get documentation for Netezza Spatial Functions

I am looking for some documentation or manual or reference guide for Netezza Spatial Functions. Any idea where can I get the same. Thank you. Dharmesh
1
vote
0answers
85 views

Working with ambiguous AddGeometryColumn functions

I'm using PostGIS to add geometry columns to tables, but keep receiving the error: ERROR: function addgeometrycolumn(character varying, character varying, integer, character varying, integer) is not ...
3
votes
1answer
199 views

Does NASA DEM contain objects?

Following an answer to my previous question I am planning to work with NASA ASTER GDEM global dataset. I am trying to download it according to instructions given here for a couple of days now. ...
7
votes
2answers
274 views

Basics about Spatial Indexes

I was asking on a forum if it could be a good idea to create spatial indexes on subsets of a table when your application display on map only those subsets and never the entire table. I was asking ...
0
votes
1answer
68 views

How to find within a geodatabase from the catalog window

I have a geodatabase containing hundreds of feature classes that I want to be able to search within so that I know which feature class to load. All the feature classes come from different data ...
16
votes
4answers
2k views

What is the difference between node and vertex in GIS?

I know it is a stupid question, but to understand the subject you have to know the basics. In graph theory the term of node and vertex are equivalent, but sometimes in the GIS world the nodes and ...
1
vote
0answers
107 views

Polygon not a valid geography instance

I am trying to create and insert data from ESRI shape files. This is one of the many features in the shape file, you can copy paste it and try it yourself: DECLARE @g geography; SET @g = ...
18
votes
2answers
1k views

Which geodatabase type is most appropriate for both open source and ESRI use?

Main Question: Is there a geodatabase type that seamlessly works with both ESRI and open source products? Details: My company currently passes around geodata in various vector and raster file ...
0
votes
1answer
97 views

Design a routing system

I am trying to develop an application, firstly web, later mobile, that builds a route based on points of interest, basically it should show the route and the points of interest and when the user ...
0
votes
0answers
132 views

copying and pasting files - geodatabase

I have been sent a zipped folder containing files in a geodatabase format. To view them in ArcMap I've created a new file outside ArcCatalog with the extension .gdb and copied the unzipped files into ...
9
votes
6answers
1k views

Is there a way to connect to PostgreSQL in ArcCatalog without SDE? [duplicate]

Is there a way to connect to PostgreSQL in ArcCatalog without SDE? I came across this post from 2011 that suggested using zigGIS but I can’t find a working link to the program. A little background: ...
4
votes
1answer
214 views

Change the Default geodatabase in ArcGIS 10?

In a multi-user environment I have a need to be able to configure ArcGIS so that it uses an SDE connection as the default geodatabase instead of the Default.gdb in each users' profile. What is the ...
1
vote
3answers
222 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,
4
votes
2answers
856 views

How to determine lock on file geodatabase?

I'm trying to delete a file geodatabase through Windows Explorer but I get the error message: The action can't be completed because the folder or file in it is open in another program. Close the ...
3
votes
2answers
128 views

Merge two geodatabases with identical structure

I'm using an ArcGIS addon which stores all created data (shapes and tables) in a gdb. The addon is made for single user use but to safe time I want to split the work with someone else. After that I ...
0
votes
1answer
81 views

Schema for offline map editing and pass to production environment

I'm working with QuantumGIs and PostgreSQL/Postgis. So when I edit the layers, the changes are reflected on the DB. The thing is I want to do some "offline" editing before committing the changes to ...
1
vote
0answers
64 views

Solve Mysql Spatial error

Converting shp2mysql will leads an null value in geom filed. how to rectify the the problem. shp2mysql -s 32643 landuse landuse LIS >landuse.sql
3
votes
2answers
2k views

How to import ArcGIS 10.1 File geodatabase to MS SQL Server 2012?

I would like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I have never done it before, so I expect to do the import the same way as import data from excel table. Problem ...
0
votes
1answer
101 views

Correlation and terrain databases [duplicate]

I would like to know what kind of computation I could perform on a terrain database. I'm making terrain for VBS2 from raw data (shp files and DTM Elevation files) and then I'd like to be able to check ...
2
votes
1answer
106 views

SpatialRefSys as foreign key

Using the working stuff reported here, I've written the following django model: from django.contrib.gis.models import SpatialRefSys class LandCover(models.Model): shp_name = ...
1
vote
0answers
37 views

Determining the SRID of a dataset in PostGIS [duplicate]

Sometimes the dataset provides some information about its projection. For example, it can mention Horizontal_Datum_Name: North American Datum of 1983, Ellipsoid_Name: GRS1980, ...
2
votes
1answer
45 views

Importing labels for check in/out from an SDE to file geodatabase

I am working on a large project where I am using the ArcMap 10 'distributed geodatabase' feature to check out a file geodatabase from our SDE file. I have tried several ways to avoid having to ...