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
253 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
2
votes
1answer
273 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 ...
1
vote
0answers
15 views

Difference between adding spatial layer from MSSQL through “browser” and “add MSSQL table”

So I am trying to pinpoint the difference of adding layers from MSSQL Database that contains spatial layers like geography and geometry. I have noticed that when adding from the browser it retains it ...
1
vote
0answers
31 views

Issues creating ArcSDE sde_logfile for certain users (username begins with a numeral)

I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication ...
5
votes
3answers
109 views

Poor performance with storing large rasters in PostGIS and visualising in QGIS

my question concerns the use and performance of several software tools in conjunction, namely PostgreSQL, PostGIS, QGIS, and GDAL. I'm a long-time ArcGIS, Python, and R user who is interested in ...
4
votes
5answers
672 views

How to test whether two countries are adjacent using ArcGIS Desktop?

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

geojson coordinate conversion to the format of the data coming from PostgreSQL?

I use hibernate spatial and geotools this is save to vector code : if (vectorType.equalsIgnoreCase("Point")) { LineString point =new GeometryJSON().readPoint(item.getData()); ...
0
votes
0answers
11 views

Importing feature class into feature dataset of different coordinate system

So currently I'm creating a geodata base and I'm arranging alot of the data into feature datasets. I have been using the feature class to geodatabase tool to import the data directly into the feature ...
2
votes
0answers
32 views

How do I optimise performance on a local QGIS + PostGIS installation?

I'm learning how to manage a local PostGIS (ver 2.1) database, with spatial indexing enabled on the shapefiles that I've imported (using the PostGIS Shapefile Import/Export Manager). I have imported a ...
0
votes
0answers
26 views

Visualizing map from Spatialite DB on Mobile

I am working on an Android application for a school project. I am converting shapefiles (examples) into SQLite databases using SpatiaLite and performing queries on those databases on the mobile with ...
5
votes
2answers
4k views

Clipping/exporting multiple selected vector layers in map to extent of another raster/vector layer in ArcGIS Desktop?

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 ...
9
votes
2answers
1k views

Future for geospatial on App Engine?

2 years ago, this question was posted here at Gillies's blog, on date of 2009-05-15. Future for geospatial on App Engine? At that time there was no news relating to any apps of GIS web services ...
4
votes
3answers
3k 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 ...
3
votes
1answer
43 views

Showing multiple burials in same grave for Cemetery GIS?

I am an intern creating a Geodatabase for a municipal cemetery. The one lot can hold up to 3 people (2 people, 1 cremation) two people at the most. How would I show that information on the map ...
0
votes
0answers
52 views

How do I design a database for storing GPX tracks and supporting spatial queries? [duplicate]

I have a series of GPX files that contain 1...n tracks. Each track contains roughly 5k - 10k points. The GPX files do not contain waypoints or routes. I want to design a database with the following ...
3
votes
2answers
3k views

How to convert 6 & 7 digit coordinates to degrees latitude & longitude

I'm a bit new 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 spatial data, I came across MULTIPOLYGON data, where ...
0
votes
1answer
45 views

Select and count street pattern features (morphology) using ArcGIS for Desktop?

I'd like to be able to select and count the number of cul-de-sacs, lollipops, dead ends, or other types of street structure in a hillside community.
1
vote
1answer
33 views

Edit xy domain of feature classes during import from boilerplate geodatabase schema (ArcGIS)

Situation: I work for a company that creates geodatabases for a client that are restricted to a specific boilerplate schema (eg domains, subtypes, etc.). During a recent draft review, the client ...
7
votes
3answers
3k views

how to find 20 closest points efficiently

Say I want to find 20 closest business near me. My table structure is like this: BusinessID varchar(250) utf8_unicode_ci No None Browse distinct values Change Drop ...
-1
votes
1answer
38 views

How to import data into a table from another similar table?

I am working with PostgreSQL to import a table from a .shp file and my task is to populate another table (same attributes as this .shp table) with the data of the table of the .shp file table that i ...
3
votes
1answer
26 views

PostGIS - interfacing with CADCORP 7.1 and QGIS - user 'postgres' can import, but no other roles can

I'm new to PostGIS (reasonably) - but I'm plagued with one on-going problem: I'm able to access PostGIS from various GIS systems using the main 'postgres' user. Using a newly created user ...
-1
votes
1answer
61 views

Adding a column of WKT format in the table (postgreSQL)

I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use? I need to create this database for mapping. There are about 30000 features ...
0
votes
1answer
44 views

How to change field length with ArcObject?

I want to change some string field in sdegeodatabse with bellow code. The code are running without any problem. but after running, filed length return to default length. What am i missing? static ...
1
vote
0answers
18 views

Most efficient way to rasterize a planet

I'm working on a Webservice where GIS supports my services as a Crowd Intelligence Aggregator to help civilian (like civilized) aid to support provisioners in a case of emergency, e.g. pestilence, ...
0
votes
0answers
22 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
1
vote
1answer
54 views

Creating geodjango model with geometry field that can accept different projections

I am working on web application with GeoDjango and within the model (db table) RoadAxis I have geometry field or more precisely LineStringField where I need to store different polylines (road axis) ...
0
votes
1answer
18 views

rural, urban data of the UK

I am looking for some reliable and potentially free data the divides the UK into rural, urban etc. sections: https://www.gov.uk/government/collections/rural-urban-definition the classification can ...
3
votes
2answers
75 views

Need a vector format that is editable in QGIS and supports >10 character column names

For reasons, I need to create a new column in a vector shapefile with a name longer than 10 characters, and export to mapinfo TAB format. I know .shp's don't support >10 character column names, so ...
0
votes
0answers
60 views

bounding box - generate coordinates

I will be using mongodb database which supports data on an Euclidean plane (not spherical). I will be performing queries which return all points within a box. For the box I need to specify the upper ...
1
vote
1answer
45 views

Raster appears like polygon in Arcmap

I copied rasters across into my geodatabase for a client but when they open the raster dataset in ArcMap they appear in tiles as shown in the image below. When I drag and drop individual rasters over ...
1
vote
0answers
20 views

Is order of selection in Spatial Data important (attribute, location, graphic)?

When dealing with spatial data in a GIS system, does it matter which way you select the information if you're using all 3 - attribute location and graphical selection? In my experience it seems to not ...
1
vote
2answers
43 views

GIS and Geodatabase with Reminder Function

a friend of mine, a landscape gardener, asked me wether it is possible to represent his garden (mainly big trees and a few flower fields) in a GIS so he could administrate these on his computer by ...
0
votes
0answers
32 views

Dealing with multiple georeferenced, but possibly slightly offset datasets

I have elevation data stored at 5 meter resolution in a raster file. I would like to go in and add this data into a database (lat, lon, elevation.) I have another rasterfile with other data, also at ...
4
votes
1answer
712 views

How to Reduce Decimal Precision of Image Value in ArcGIS Desktop?

I'd like to ask about the value on following image. This is an interpolated precipitation layer using IDW method in ArcGIS Desktop. On this layer, the values is like this: This is a raster image. ...
0
votes
0answers
89 views

Geo spatial extensions in MariaDB vs MySQL

MariaDB is interchangeable with MySQL, but are there any differences in terms of each respective GIS features? Switching from one to the other is still a drop-in replacement with geo data types or ...
15
votes
5answers
1k views

Is good database design less important for spatial databases?

I have a strong feeling that database design and normalisation often comes in second hand when dealing with spatial data. With software costing a fortune and databases with over 100 fields tables I ...
1
vote
1answer
56 views

spatialite : spatial index on geometries

I'm currently learning to use spatial access methods for query optimization. I'm going through the examples in spatialite cookbook and got stuck in here ...
0
votes
1answer
30 views

urban and rural areas of the UK

Just curious, is anyone aware of any (commercial) data sets that divide the UK into urban and rural areas based on admin data (e.g. outcode postcodes) and/or physical data (e.g. eastings and northing ...
2
votes
1answer
63 views

Full Text Search in ArcSDE

We have a quite large ArcSDE (~120 versioned feature classes & tables, 1M-3M records) which has Oracle or SQL underlying DBMS. This SDE is exposed through a MapService and we use ArcGIS JS API to ...
0
votes
1answer
55 views

Creating spatial database with many categories that have same set of values?

I am working on creating a spatial database of county agricultural data where each county has multiple crops (30+) and for every crop there are several production metrics (yield, harvested area, ...
4
votes
2answers
1k views

3D Building Generator Tool

I am using ArcGIS desktop 10 and I would like to change a 2D polygon into 3D building. Does anyone have any idea from where I can download the 3D building generator tool for ArcGIS Desktop? I read ...
0
votes
2answers
46 views

Using Arcpy to search geodatabase for feature with smallest number of rows and export as .SHP

I have created a bunch of grids for a city boundary area. I would like to know how to use the Arcpy module to look through a geodatabase and find the grid with the smallest number of rows (assuming ...
1
vote
1answer
56 views

Performance is downgrading with multiple feature datasets design for ArcGIS?

My company develops a spatial planning solution since 2009. Initially it was an ArcMap application to create and maintain spatial plans (competing with AutoCAD folks) but recently we developed ...
0
votes
2answers
53 views

How to convert GeomSHP to WKB

I have imported a point shapefile called site_locations.shp into a personal geodatabase. Now I'm trying to retrieve the data from the database using SQL: dbpath = ...
1
vote
0answers
88 views

Add Rasters to a new GDB/Mosaic Dataset in ArcGIS ModelBuilder

I'm attempting to add rasters to a new mosaic dataset in a new file geodatabase, all in the same model. However, the Add Rasters To Mosaic Dataset tool does not recognize the NewMosaicDataset or the ...
12
votes
1answer
309 views

How do you organize your geodata?

A geodatabase doesn't provide much flexibility in organizing your data hierarchically. All feature sets live either at the top level of the database, or one level down in feature datasets. A feature ...
0
votes
0answers
42 views

Unable to create a model from a preexisting spatial database in Postgresql, .NET provider for postgresql doesn't exist

I'm having this problem that's blocking me for over 4 days now. I'm developing a WCF webservice and tried connecting to my Postgresql spatial database (created in ArcCatalog) via Visual Studio 2010. I ...
1
vote
3answers
37 views

How to find which areas/regions a list of lat/lons are in?

The Australian Bureau of Statistics (ABS) issues Esri shapefiles or MapInfo files which have a code # for each geographical area at various 'resolutions' and I have a database with a column of ...
1
vote
1answer
56 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
2answers
183 views

How to change different projections of feature classes in geodatabase to one projection in new geodatabase?

I want to create a script that iterates through feature classes with different projections in a geodatabase and exports them into a new geodatabase, all with the same projections. What I want is to ...