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
253 views

How to count number of feature classes in geodatabase using ArcPy?

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 ...
1
vote
1answer
17 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
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
1
vote
0answers
16 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
1answer
173 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 ...
2
votes
1answer
100 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 = ...
0
votes
4answers
1k views

Where can I find base data shapefiles for whole US?

I am looking for the base layers for whole U.S. - roads, hydrological lines etc with flexibilities of changing symbology and labels. TIGER is a good source but it is at county level. I am running on ...
6
votes
1answer
360 views

Metadata server and spatial server - a must? [closed]

I have been using ArcMap (only) for the past two years (read: newbie) in the oil and gas (upstream) industry. I currently have about 200 GB of files (shp, tif, grids, a few fgdb, all sitting in a ...
1
vote
2answers
145 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,
3
votes
4answers
315 views

What Application for Vector and Cartesian Coordinate System

Goal: Visualize a picture in SQL server 2012 spatial data based on geometry Problem: In order to display a vector picture I need to retrieve X, Y coordinate (cartesian coordinate system) and ...
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
116 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 ...
0
votes
1answer
36 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 ...
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: ...
17
votes
7answers
3k views

File Geodatabase Open API

Any ESRI boffins (insiders) know when this will be available? 2010, 2011? FINAL UPDATE now released 20th January 2011 - Can be downloaded here - ...
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 ...
1
vote
2answers
100 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 ...
6
votes
3answers
432 views

Suggestions for an efficient way to store raster files for lab use?

I'm trying to create a repository for our raster files from various sources and Im exploring the possibilities on how to store them and deliver them in our local intranet. I have come across rasdaman ...
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
21 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. ...
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 ...
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 ...
1
vote
2answers
865 views

mulitlinestring to linestring

I am using postgres with postgis and I have a set of points which I would like to interpolate with a set of lines. Now my problem is that the set of lines are of type multilinestring. Is there a ...
3
votes
1answer
181 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 ...
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?
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 ...
2
votes
1answer
260 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
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 ...
8
votes
4answers
2k views

Embedded spatial database for Java

Are there any embedded spatial databases for Java? I've come across H2 Spatial, but it was difficult to tell the status of that and if it can be used as an embedded spatial database. thanks, Jeff
3
votes
2answers
1k 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 ...
27
votes
5answers
2k views

Does ArcGIS for Desktop support SpatiaLite?

SpatiaLite is playing an increasing role in my organization. As it stood in 2012, using SpatiaLite alongside ArcGIS Desktop required an amount of importing and exporting of data that was not always ...
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
77 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 ...
5
votes
2answers
2k views

How to clip/export multiple selected vector layers in a map to extent of another raster/vector layer in ArcGIS?

Is there a way to clip/export selected vector layers (more than one) in a map to the extent of another raster/vector layer at a time?? in Arcgis or any other software. I am using Arcgis10. I am ...
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 ...
19
votes
8answers
5k views

What are the best databases for storing spatial data? Pros and Cons

A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...
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
353 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
303 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 ...
4
votes
4answers
447 views

How to test whether two countries are adjacent?

I have an interesting question: Is there a dataset by which I can use to test whether two countries are adjacent? For example, if inputs are Mexico and U.S., they are adjacent; if inputs are England ...
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 ...
3
votes
1answer
500 views

Does MySQL only support bounding boxes calculations instead of the real polygon geometry?

Within our company we are deciding which DBMS we will use to store spatial data. IT wants MySQL with the Spatial extension because there is already knowledge about handling MySQL DB. We are doing ...
7
votes
2answers
3k views

Spatially enabled Postgres database

I am trying to create a spatially enabled PostGIS database. I am following the PostGIS documentation, http://postgis.net/docs/manual-1.5/ch02.html#id2648455. In the short version, i executed, ...