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)

8
votes
5answers
268 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
145 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
214 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
289 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
1k 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
563 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
709 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
383 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
346 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
96 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
365 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
246 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
199 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
161 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 ...
7
votes
1answer
1k 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
74 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
347 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
17
votes
2answers
353 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
544 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
128 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
496 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 ...
4
votes
1answer
947 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
2k 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
4k 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
727 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
99 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 ...
8
votes
6answers
4k 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
270 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 ...
1
vote
2answers
62 views

2 Similar Queries Run at Vastly Different Speed in a Very Surprising Way

I have to be very careful here. Both queries are so similar that the only different is the area searched. What's surprising is the query that run on BIGGER AREA, and naturally yield MORE ROWS, is the ...
2
votes
1answer
539 views

How to speed up this simple MySQL points in the box query

MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
4
votes
3answers
460 views

Do you know of any project that stores features in a NoSQL database like Cassandra?

I'm a Master's student and software developer and I want to make a new contrib development based on NoSQL databases like Cassandra. Does anyone know any people, University or Research Group who works ...
3
votes
2answers
157 views

Is there any site which provide classified image download for soil,vegetation or water resources?

(its particularly for indian states,i need.....,but kindly quote if any other info you have) the raster data may also work for me in above aspects.
5
votes
1answer
133 views

Looking for open-source solution to show map with massive objects(3x3 polygon) on a web site

I don't have much experiance in GIS systems. I am developing a web site which need to show a map with 3m x 3m rectangles for a radius of about 400 meters.(about 58,000 polygons for one location) I ...
0
votes
0answers
291 views

MySQL SQL command to find points within a rectangle with spatial extension and index [duplicate]

Possible Duplicate: how to find 20 closest points efficiently How to find points, sort them based on closeness, and get 1-20, 21-40, etc. Efficiently using Myisam and mysql Actually I ...
1
vote
1answer
108 views

Algorithm to find distance of an uneven polygonal road

While working for my summer internship I have got a task to implement an algorithm to find the crosssecting points of two roads or more and then place that cross-section point a number and then find ...
7
votes
3answers
2k 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 ...
3
votes
1answer
137 views

cannot check in related tables in arcpad 10

I'm using ArcPad Data Manager (ArcMap 10) to check in data in axf file. I can check in feature layers, but I can't check in related tables and the feature class parent of the related tables. I have ...
22
votes
7answers
749 views

GIS Software Choice for a small university research centre

I need to choose a GIS system for a small university research centre. We are handling a broad range of data, (for example, numerical tidal analyses, weather data, poverty, isolated economic activity, ...
4
votes
2answers
290 views

Calculating the space a feature class will use in ArcSDE?

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
7
votes
3answers
4k views

How to export multiple featureclasses to shapefiles?

I have plenty features in a geodatabase. I need to save/export them into shapefiles, because my mate works with Manifold, which is not able to read geodatabases. Any Ideas? Click on every single layer ...
7
votes
2answers
3k views

QGIS supported databases?

Does anyone know if there is some kind of documentation on which database types that you can connect to in QGIS? I would also like to know if: Can I use the databes for read only or read & write. ...
5
votes
1answer
3k views

How to create a table from existing tables (applying new schemas) in postgis DB?

I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this: ...
13
votes
2answers
22k views

How to insert a point into postgis?

I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query? CREATE TABLE app ( p_id INTEGER PRIMARY KEY ); SELECT ...
2
votes
2answers
922 views

DatabaseError: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAHY type

I am using Django 1.3, PostGIS 2.0 , Postgresql 9.0 and GeoDjango. I had a database with a table for places. This table had latitude and longitude for places in the US. I enabled this database with ...
2
votes
0answers
65 views

ArcSDE Feature View in a GeoDatabase other than the Feature's Database

here is the problem I have been struggling with: We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
1
vote
2answers
312 views

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 ...
2
votes
1answer
370 views

Can a spatial View in ArcSDE be viewed in ArcCatalog?

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table? I have a feature class table and an attribute table ...
-1
votes
2answers
110 views

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 ...