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)

4
votes
2answers
4k 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
0answers
11 views

GeoServer - Web application [duplicate]

for a science project at university I have the task to create a web application based on Geoserver. The data is already stored, I have to visualize it now on the web for different users. Each user can ...
2
votes
2answers
54 views

How to get an area Latlong geometry directly from google map?

I am new to field of GIS. I need to know that do we have an option of getting latlong of a building that we see in google earth or any Point of Interest areas. Something like i create & drag ...
4
votes
0answers
36 views

Can I clip a geodatabase vector layer in QGIS?

I have a Vector layer loaded from a .gdb (geodatabase directory). I'm seeing my contour lines fine. I've drawn a polygon on top of the area I want to crop on a new layer. I select Geoprocessing ...
3
votes
2answers
2k views

Opening geodatabase files using Browse Dialog Command (VB.NET/C#) of ArcObjects?

I am currently using the following method with ArcGIS 10 to open raster files from a form: Public Function BrowseRaster(ByVal sTitle As String, ByRef sFolder As String, ByRef sName As String) As ...
1
vote
0answers
16 views

Spatial decision support tools for spatial planning, licensing, and permitting, alternative to FlexiCadastre? [closed]

I'm tasked to design and develop an information management system, i.e. GIS-based spatial decision support system to guide, inform, evaluate, and monitor regulatory processes in spatial planning, ...
1
vote
1answer
24 views

Load postgis database with PK from two fields in QGIS [closed]

I have a PostGIS database having a Primary Key from two fields id_cat and id_cdad. When I load this database in QGIS in my computer under Linux there are no problem. I unmark "Select ID" and I can ...
3
votes
1answer
40 views

Mapping SQL tables in ArcGIS Desktop

I have several tables in SQL server. I am trying to visualize my data in ArcGIS. However, I have not been able to do so. I started off my making a database connection in Arc Catalog to my SQL. I did ...
1
vote
1answer
308 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
0answers
29 views

Changing/editing original feature class referenced in ArcGIS map package?

I created two different map packages (say, mappack1 and mappack2) that included a common layer (polyline feature class in a file geodatabase, say LINE). Then I unpacked mappack1 and edited the common ...
0
votes
0answers
19 views

Automatically picking up OBJECTID in ArcMap from Create View in SQL Server

I have a plain SQL table stored in an SDE database on SQL Server 2008 as below. CREATE TABLE [dbo].[AAA_TEST]( [ID] [int] NOT NULL, [LON] [decimal](9, 6) NOT NULL, [LAT] [decimal](9, 6) ...
2
votes
0answers
23 views

Is there any P2P GIS or SDI?

Have you heard/read about a distributed SDI (Spatial Data Infrastructure) or GIS ? I'm thinking on a system that uses something similar to the torrent protocol for managing spatial data and also be ...
0
votes
0answers
18 views

How to find Nearest point on line from a point cordinate in SQL server

I want to find out the nearest point on my road network which is a multiline string from a point with lat lon value. The below code I have tried for finding buffer distance line from a point. ...
6
votes
1answer
120 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 ...
4
votes
1answer
1k views

Creating adjacency matrix of topology graph of ArcMap for shortest path using ArcObjects? [closed]

I have created a topology graph of a polygon feature and I want to find the individual FIDS of the lines of the polygon. I want to construct an adjacency matrix to create the shortest path. How can I ...
5
votes
1answer
2k views

Reset Object ID After Truncating Table In SQL Server

I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
1
vote
0answers
31 views

Mysql 5.5 spatial to Google Maps API

I've got a mysql table with points and polygons spatial geometries. I can see that MySQL 5.5 doesn't have the ST_AsGeoJSON() function to extract to GeoJSON. I'm looking for the simplest way to ...
0
votes
0answers
26 views

Google static map path from MS SQL spatial data

I am trying to generate Google static maps on the fly that include a path based on data I have in a MS SQL Server geometry column. I currently use the encoded path algorithm to reduce the length of my ...
0
votes
0answers
40 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in ...
3
votes
2answers
82 views

PostGIS database design: For polygon data

I am designing a spatial database using PostGIS. My main aim of this spatial database is to organize Administrative (250 polygon layer) and postal layers (154 layers) in a database. These layers ...
0
votes
5answers
6k 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 ...
2
votes
1answer
50 views

algorithm to get the nearest line segment (link) to a point

What is the fastest algorithm to get the nearest line segment to a point (that is not on any line segment) in a GIS database?
0
votes
0answers
24 views

returning id's from spatial query

I am doing a spatial query to see if water sensors exist or not in a database. If so I want to return the unique identifier # that exists on the ones in the database so I can match it to the ones ...
5
votes
3answers
857 views

Storing features in NoSQL database like Cassandra?

I want to make a new contrib development based on NoSQL databases like Cassandra. Does anyone know of a University or Research Group, or anyone else, who works in "Geo-Cassandra" currently?
1
vote
1answer
74 views

Cloud based database solution [closed]

I'm looking for a cloud based database solution where I can store about 1 GB worth of tabular data and both myself and my client can access to perform SQL queries. I'm looking for this database to ...
1
vote
1answer
55 views

Raster data QGIS and SpatiaLite?

I am a german student and study Geoinformatik. I have the task to store Raster data in SQLite. So use the turotial from the gaia page to Create a database and store a image (TIFF) named NaturalEarth. ...
1
vote
0answers
32 views

how to fix projection in QGIS from earth data

After downloading and opening natural earth data in QGIS, the result shows like this I have tried uncheck simplify geometry but it doesn’t work. I think the problem is related with globe ...
0
votes
0answers
12 views

UNique ID Field for Oracle versioned GDB

We had a successful trigger through ArcFM, but we have abandoned their datamodel/product. We have a successful trigger when new features are added in a versioned edit session, BUT it does not work for ...
11
votes
3answers
3k views

Intersecting a raster with a polygon using PostGIS - artefact error

I'm using PostGIS2.0 to do some raster/polygon intersections. I'm having difficulty understanding which operation I should use, and what the quickest way of performing this is. My problem is as ...
4
votes
1answer
175 views

Clustering Technique?

I have the following 9 clusters (each colour represent the appropriate cluster): I am looking for a clustering algorithm (if any) that would achieve "realistic" results. The data represents ...
0
votes
2answers
67 views

Getting Started Using Leaflet Draw to CrowdSource Shapes on a Map

I want to crowdsource shapes on a map for an organization I'm working with. It seems like Leaflet Draw something along the lines of the Mapping Neighborhoods projects. As someone with some experience ...
1
vote
0answers
232 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 ...
0
votes
0answers
34 views

Problem with stretched value and classified value in ARCGIS desktop? They are different than each other

I want to classify the value of an image into 3 groups. when I check properties of a raster image, stretched value is different than classified value. Here I have uploaded the images as follow. I ...
1
vote
2answers
51 views

Aegean Islands Spatial Dataset

I need a .csv file about the coordinates of all the Islands in Aegean Sea. Do you have any idea how I can find them?
0
votes
2answers
192 views

APDM - error exporting database from Oracle

I have a fairly large database on a slow network and I am using a third party tool to update data which calculates other fields and so on. I have a guid string with an empty box (weird glyph - seen ...
0
votes
0answers
213 views

how to write Topology Graph Edges geometry to polyline feature class

i have created topologygraph of a polygon feature . and iwant individual ids of polylines i want to write Topology Graph Edges geometry to new polyline feature class any samples OR documentation ...
17
votes
6answers
2k views

Spatial databases learning resources for newbies

Would be taking up a course on spatial databases next semester. Would anybody know a newbie friendly introductory resource? A vendor neutral one would be preferable. Thanks.
1
vote
0answers
34 views

GeoServer: Use oracle as raster store without spatial extension

Is it possible to store raster data (e.g. GeoTIFFs) in an oracle table and access it from geoserver without using the oracle spatial extension/GeoRaster? I would store the images as blobs, but I don't ...
1
vote
1answer
46 views

PostGIS/QGIS: Update polygon attribute based on the mode value from a cluster of points

I'm updating a PostGIS table of polygons denoting property boundaries with some values that form part of a code for sites scattered across the properties. Neither dataset is 100% accurate so I can't ...
1
vote
1answer
53 views

How to convert a complex project of shape files to a spatialite database?

We have a QGIS project made of ~10 shape file layers. The layers are saved on a shared server, and the project is used on different computers. Recently polygons and polylines have been been ...
1
vote
3answers
204 views

How do I find points that are NOT within a list of polygons using MS SQL?

I have a table of points, and and a table of polygons. I have managed to build queries (MS SQL) to get the containing polygon for a given point, as well as listing all the points within a specified ...
1
vote
1answer
99 views

Where can I find global spatial data for net primary productivity (NPP)?

The title is more or less self-explanatory. I have looked and looked but have met various road blocks. Does anyone know of a reliable source for such data? Thanks!
0
votes
1answer
19 views

Standardized format for contributing street closure data to navigation apps

I am wanting to put together an application that will digest georeferenced road closure data. I am wondering if any such format currently exists for notifying google maps or other navigation ...
1
vote
1answer
44 views

Can't import multiple features or rasters into file geodatabase

I am trying to use the import multiple features into geodatabase option in ArcCatalog (ArcGIS 10.1). Or, similarly, I try to use the import raster option, which screen layout is similar to the ...
10
votes
6answers
6k views

How to get “.GDB” Esri File Geodatabase in QGIS for MAC OSX 10.6?

I understand there are programs like OSGeo4W that allow windows users to work with File Geodatabases, but is there something similar for Mac OSX?
0
votes
1answer
152 views

Install Postgresql / Postgis with SFCGAL

I need to access ST_StraightSkeleton() function. At the moment i have a Postgresql instalation PostgreSQL 9.3.4 compiled by Visual C++ build 1600, 64-bit installed via EDB with Postgis 2.1.7 on a ...
0
votes
0answers
16 views

How to convert File Geodatabase to Personal Geodatabase [duplicate]

I have a file geodatabase (gdb) and I want to convert it to personal geodatabase. I am using ArcMap 10.2. Does esri support this conversion? Any easy steps? what I would like to achieve is to access ...
32
votes
2answers
2k views

What coordinate system should be used to store geography data for celestial coordinates?

I am doing an astronomy project. I want to have the information about our images stored in a spatially enabled database. This, I would think, should be a very easy special case for GIS functions ...
5
votes
0answers
434 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
2answers
45 views

Any free Tools to display more than 5000 geography objects in SQL Server?

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or ...