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)

3
votes
1answer
434 views

How to Get the Three Nearest Points to an Object (different layer)?

I have two point shapefiles and I want for each point in the 1st shapefile to get the 3 closest (based on air distance) points from the 2nd shapefile. If possible, it would be great to have each of ...
3
votes
1answer
347 views

Possible solution for dangling nodes?

I was just asked in a interview what a dangling nodes was. I had no idea and asked a former co-worker. I was informed that a significant amount of time was spent fixing these. I was confused how ...
0
votes
0answers
492 views

How to represent clustering of geographical points on map in STATA?

I've plotted a map on STATA using user-written program spmap and have also obtained the grid for my space using spgrid program. Now I want to see where most of my data points are clustered on map. Is ...
2
votes
1answer
97 views

postgis values within XYZ viewport in openlayers

I got this XYZ server where I get my maptiles. Now, when the user is at zoom level 1 ( closest). I want it to execute a command that gets the current viewport from the map and Queries my PostGIS ...
3
votes
2answers
210 views

Several questions about using spatial data?

If you have spatial data for SQL server, can you use the spatial data (both geometry and geography) in another application for instance ESRI ArcGIS? Is spatial data a standard that every GIS ...
4
votes
1answer
278 views

SQL Server data modelling + spatial data = what book?

What recommended book can you provide about data modelling for geographical spatial data (geometry) in SQL server?
3
votes
2answers
385 views

Visualize Spatial Data in Reporting Service

Is it possible to visualize a piece of geographical map from SQL server Spatial data (geometry, not geography) in a report from reporting service? If yes, how should it be done in a course of action. ...
4
votes
1answer
305 views

How to Reduce Decimal Precision of Image Value in ArcGIS?

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

How to Export a Geodatabase with Subtypes and Domains to Microsoft Access Without Losing Information?

I want to export a geodatabase file with all subtypes and domains values to open in Microsoft Access without losing any information.
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
221 views

Update query does not affect any rows, privileges are set to public and allow all actions

I've been trying to update a column of integers called level_dept in a table called adminboundaries within the sql query tool on pgadmin3 and the query runs and finishes with a lot of lag, but 0 rows ...
-2
votes
1answer
184 views

How do I set the protocolVersion using the jdbc postgres driver? [closed]

I attempted to concatenate a string to the url parameter of the below in order to set the protocolVersion, but I'm not sure how to keep the string in the url without altering the name of the database, ...
13
votes
5answers
388 views

What in-depth spatial database systems tutorials exist?

Is there a good tutorial that explains in depth the internals of a GIS and a spatial database system such as PostGIS with examples and without any background assumption? I'm specifically looking for ...
9
votes
2answers
829 views

Postgres/Postgis spatial index - no speed up

I have a spatial table in a postgres/postgis database. Every row in it represents a Polygon. It is of following form: +----+--------+ |gid | way | +----+--------+ |241 | 01030..| The geometric ...
5
votes
1answer
143 views

Grid Analysis from samples data

I'm trying to analyze set of samples into vector grids in order to generate average data in corresponding grid.I'm working with 50m separated grids but the size of grid may change over time.That's why ...
0
votes
2answers
165 views

Can I incorporate an existing DBF file with coordinates for Tiff tiles into geodatabase like spatialite?

I have 285 Tiff files that make up the 1:10000 OS map of Norhtern Ireland. I am having problems running QGIS when I try to load all 285 tiff files in for base maps (I think the memory on computer is ...
1
vote
0answers
275 views

How do I find the pgAdmin connection parameters?

I need to create a connection from arcmap to pgadmin using a python module because of an arcpy script, but I am unsure of how to get the pgadmin connection parameters. I think it may be some kind of ...
3
votes
0answers
60 views

Search in Bounding Boxes and Locations

Description of the problem (what I need): I have a set of bounding boxes (maybe the actual data is a location[longitude, latitude] in which case the bounding box will have identical corners). I have ...
0
votes
2answers
194 views

ArcGIS: Summarised Inside Join with Attribute Criteria

I have a situation in which I need to find how many points lie within a polygon, this would be quite simple with a summarized inside join from points to polygons except for the fact that the points ...
4
votes
1answer
246 views

Is it possible to run an arcpy execute SQL method without connecting to any database or server?

I want to simply process a layer by writing a tool script in a toolbox without having to connect any database, so I think I may have to set up a workspace environment in ArcMap, but I'm not sure if I ...
8
votes
5answers
262 views

Is there a climatic geo portal for every point in the world?

I'm looking for a geo portal or climate database that provides me with the daily climatic information like temperature, precipitation and humidity. Forecast data is not of my interest. I need ...
1
vote
0answers
139 views

What is the best way to create polygons on a map and download files associated with the polygon?

My client wants to build a tourist site and for that he wants a backoffice for the map and the ability to draw polygons on the map (that user can see). When the user clicks on a polygon, he gets a ...
1
vote
0answers
28 views

Creation of 3d terrain from real data [duplicate]

Possible Duplicate: 3d terrain from data in postgres I am pretty new to spatial database and 3D data. I have a project where i have to create a 3d terrain from data being taken by me by a ...
6
votes
1answer
196 views

Standard for storing human metadata in spatial databases

Is there an existing, standard, universal approach (and hopefully existing tools that support managing it) for storing geospatial metadata in non-ESRI spatial databases alongside (and therefore able ...
2
votes
2answers
241 views

projection issues from ArcGIS to Qgis

I am pretty new to ArcGIS and Qgis. I have loaded some geometry data in Qgis from my postgres database, then I have also loaded the same data in ArcGIS. Then from ArcGIS i have created a shapefile ...
6
votes
3answers
802 views

Insert points into SQL Server?

I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark. ...
3
votes
1answer
501 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 ...
2
votes
1answer
583 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 ...
1
vote
1answer
318 views

Is the PostGIS Shapefile Import Manager able to upload to phpmyadmin or only pgadmin III?

After trying to import a shapefile into pgadmin III with no success I was wondering how to successfully upload it, but also if it is possible to upload to phpmyadmin instead. In any case, how exactly ...
3
votes
1answer
288 views

Why does AddGeometryColumn error using the libspatialite-2 DLL with pysqlite2?

What I'm trying to achieve is to create a geometry column of a point based on the latitude and longitude of that particular row in the already created table. Given the following code: ...
4
votes
1answer
87 views

Distributed versioning of geospatial data

I'm getting started on the design of a new system that would reconcile, merge, and synchronize changes made across numerous geospatial databases of common ancestry, on an ongoing basis. These ...
17
votes
2answers
329 views

Is there a standard data model for storing traffic volumes, layout, lanes, timing and phasing information?

I am at a crossroads where I want to store more than a scenarios worth of project data from a Synchro study, but do not want to keep this data in a series of text files. The data output by Synchro is ...
0
votes
1answer
194 views

Does a polygon in a layer intersect with another polygon in the same layer [closed]

I am a CS major with little experience in GIS. I am working on vector polygon overlay. Looking at GML and shapefile data, I realized that a map is made up of a large number of polygons. Does a polygon ...
6
votes
2answers
192 views

How to decide what type of GIS to use for my study project?

I'm a student and currently taking a self directed project course. In our assignment, we were given a bunch of shapefiles and the goal is to make a tool, which would display all the data based on ...
2
votes
1answer
146 views

Finding the Geometry within which a Point falls

I have the following query, which takes on average about 4 seconds. How might one improve the query such that the same response comes back faster? SELECT * FROM geometries g ORDER BY ...
5
votes
1answer
741 views

Creating a table containing all filenames (and possibly metadata) in a File Geodatabase

I need to create a metadata-table for all files in a File Geodatabase or Spatial Database. It would be awesome if it were possible to automatically be updated with new filenames, and possibly even ...
3
votes
2answers
71 views

Where can I find spatial data on polar fish populations?

Where can I find spatial data on polar fish populations? I am looking specifically for polar cod, but any fish will do at this point in my project. I also need arctic ocean salinity, temperature, and ...
3
votes
1answer
289 views

Looking for GIS Data for Curitiba, Brazil?

I am wondering if anyone knows where to find building footprints, road network, transit, or environment feature data for Curitiba, Brazil. Thanks
16
votes
2answers
312 views

(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 ...
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 ...
12
votes
2answers
489 views

Need a spatial database that can be used by QGIS and R

I'm quite new to QGIS and I'm searching for a simple way to create a Database that allows me to use the tables in QGIS and R. I have a lot of data stored in Excel spreadsheets wich will be used for ...
0
votes
2answers
125 views

creating one tree to many observations in qgis

Looking to create a database for QGIS where each point represents a tree (with name attribute) and another table of observations about each tree over time. Ideally I can update tree location in QGIS ...
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 ...
3
votes
1answer
751 views

Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”

I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15. When trying to install the raster support, psql -d mydb -f rtpostgis.sql -v ON_ERROR_STOP=1 I get the following error ...
1
vote
2answers
1k views

Convert spatial Geographic data from sql server 2008 to Json

Is there any example to convert spatial data (point,line,polygon) stored as geographic in sql server 2008 into Json and display data using Arcgis Javascript Api 3.0.I have tried converting geographic ...
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, ...
2
votes
1answer
660 views

MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?

Is there a ST_Distance_Sphere, ST_Distance_Spheroid equivalent function in MySQL's GeoSpatial Support? If not, any way to emulate this? What is the metric used in return type of ...
2
votes
1answer
92 views

What are the implications of changing the AutoCommitInterval on file geodatabase inserts?

All, I was wondering if anyone has any advice or "tales from the dark side" about changing the AutoCommitInterval property of the ITransactionsOptions interface? It's the sort of thing I generally ...
7
votes
6answers
3k 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?
12
votes
1answer
261 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 ...