GIS Stack Exchange
GIS Stack Exchange

Questions tagged [spatial-database]

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.

http://en.wikipedia.org/wiki/Spatial_database

464 questions
22
votes
3 answers

(When) should I use a GIS-enabled database?

I am a long-time programmer, new to GIS. I am trying to get a feel for the database aspects of GIS and I understand that there are some databases which are specialized for GIS use. Basically I am trying to understand whether to use such a database…
Mawg says reinstate Monica
  • 537
  • 1
  • 6
  • 19
13
votes
4 answers

What is a good taxonomy or naming convention for files and folders containing GIS data?

My company has collected about 30 TBs of GIS data over the past 8 years, and I always find myself asking the following questions: What type of data do we have for a given geographic area? What are the details about that data (e.g., resolution in…
Sipp
  • 341
  • 3
  • 6
3
votes
2 answers

epsilon in spatial data

What is epsilon and why do we need it in GIS operations?
tina
  • 333
  • 1
  • 2
  • 11
3
votes
1 answer

Normalizing a spatial datasource (5NF)?

I am designing a spatial database and I am including a variety of already existent datasources (ex: Lakes, rivers, road network, contour lines, cities, etc). Those sources can be updated every once in a while. Except from these sources, the database…
TurboGraphxBeige
  • 1,467
  • 10
  • 24
3
votes
1 answer

How to calculate the number of buildings along the left/right side of a street?

I'm struggling to find a way to get the line direction stored on shape file from its geometry, is there any tool can get it for me? Also, I have two layers of map: Roads layer (of type polyline), Building layer (of type polygon) I want to get the…
m.sai
  • 31
  • 1
1
vote
2 answers

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 understand that user is in the coordinates (with tolerance…
Ghouse Katiri
  • 11
  • 1
1
vote
2 answers

Spatial query in PostgreSQL to find a route to a specific point?

I drew 2 shapefiles - point.shp and line.shp. Line.shp has some lines intersecting points in point.shp. I converted the shapefile to PostgreSQL, but how can I make a spatial query to select a line from one point to another point ?
newToAndroid
  • 143
  • 1
  • 1
  • 6
1
vote
0 answers

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, military/civil conflict or other natural…
Semo
  • 111
  • 3
0
votes
2 answers

Download Solar Insolation Data from NASA in R

I need to get solar insolation data from different parts of the world. I have several latitude and longitude coordinates and I would like to get a mean solar insolation value across different years. I found this data from…
GabrielMontenegro
  • 123
  • 1
  • 4
-1
votes
2 answers

How to extract small portion of GIS database from entire database

Is it possible to extract a small portion of data from an entire database? If possible then how can I do it. I want data to be extracted which is within my map view only, so that other data objects are excluded: only objects contained in the map…
Anshu
  • 1