Talk:Spatial database

This article is rated Start-class on Wikipedia's content assessment scale.
It is of interest to the following WikiProjects:

Databases (inactive)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases articles

Geography C‑class Mid‑importance

This article is within the scope of WikiProject Geography, a collaborative effort to improve the coverage of geography on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.GeographyWikipedia:WikiProject GeographyTemplate:WikiProject Geographygeography articles

C This article has been given a rating which conflicts with the project-independent quality rating in the banner shell. Please resolve this conflict if possible.

Mid This article has been rated as Mid-importance on the project's importance scale.

WikiProject Geography To-do list:

Here are some tasks awaiting attention:

Article requests : See Requested articles/Social sciences/Geography, cities, regions and named places and Missing articles about Locations
Assess : Tag related article talk pages with {{WikiProject Geography}}. To help assess the quality and importance of geography articles, please see: Unassessed geography articles and Unknown-importance geography articles.
Cleanup : See Geography articles needing attention
Deletion sorting : Listed at Geographic related deletion discussions
Geographical coordinates : See Articles missing geocoordinate data by country
Infobox : See Geography articles needing infoboxes
Map : See Wikipedia requested maps
Notability : See Geography articles with topics of unclear notability
Photo : See Wikipedia requested photographs of places
Stubs : See Geography stubs

Individuals with a conflict of interest, particularly those representing the subject of the article, are strongly advised not to directly edit the article. See Wikipedia:Conflict of interest. You may request corrections or suggest content here on the Talk page for independent editors to review, or contact us if the issue is urgent.

Spatial Database and geodatabase

Spatial Database is a more general term than Geo-database and should be retained. Historically, there is a debate between the adjectives "Geo" and "Spatial". However recent trend prefers "Spatial". For example, NSF chose the adjective "Spatial" in renaming the "Geography and Regional Sciences" program. —Preceding unsigned comment added by 128.101.34.46 (talk) 22:37, 1 May 2009 (UTC)[reply]

I agree. A spatial database is not proprietary, but is a distinct type of spatial data tool. A geodatabase is primarily an ESRI product, and does not have the same query ability, or complex tabular management that may be found in a spatially enabled database. These topics should be seperate. SCmurky (talk) 07:07, 28 August 2009 (UTC)[reply]

I'm not sure the "Spatial Databox" product entry applies to this article. I have visited the linked page and it looks more like a web server to me, but I don't know the product, so I can not be sure. —Preceding unsigned comment added by 217.12.16.53 (talk) 09:57, 26 October 2009 (UTC)[reply]

I think that Spatial dataBase is more general than geodata base feels like the spatial data base is a super class and the geodata base is a sub class. —Preceding unsigned comment added by 212.118.13.124 (talk) 08:25, 22 December 2009 (UTC)[reply]

The term geodatabase is also a bit proprietary - having been used by ESRI to describe a database that includes (sometimes discipline specific) spatial objects and operators for those objects. Spatial database is more general term and is probably correct for this article. —Preceding unsigned comment added by 71.56.219.48 (talk) 05:12, 29 December 2009 (UTC)[reply]

"Spatial Database" in particular applies to any dimensionality; while "Geo-Database" somewhat implies a connection to the real world, i.e. 2D or 3D data models (on the spatial index / query key level, that is). So I'm opposed to a "full" merger; however it could make sense to include geo-databases in spatial databases. But there is also a lot to say about requirements specific to geodata, and optimizations possible on geodata, due to its physical properties. For example, euclidean distance is a physical bound for the distance. Such as restriction may not hold for arbitrary spatial databases. --Chire (talk) 17:17, 4 June 2010 (UTC)[reply]

I am sorry: this should be a clear no since the term "Geodatabase" is the name of a product by ESRI - whereas "Spatial Database" is a proper general software description (actually it should be Spatial Database Management System for the software since Spatial Database includes the data). 75.152.163.213 (talk) 21:40, 18 June 2010 (UTC)[reply]

Merge Spatial Index

The article Spatial index is currently only a stub, and should IMHO be merged into this article, in particular to differentiate it from the more specialized Geo-Databases subject. --Chire (talk) 11:18, 5 June 2010 (UTC)[reply]

I disagree - however it could be subsection. A Spatial Database is a software or a concept - while a Spatial Index is a data structure to query spatial data efficiently. 75.152.163.213 (talk) 21:40, 18 June 2010 (UTC)[reply]

I would tend to disagree too but I don't feel strongly about it. Jason Quinn (talk) 02:21, 21 September 2010 (UTC)[reply]

My instinct was to disagree, but then I realized there isn't too much content in Spatial index (nor would I expect a large article). I agree with a merge to a section of Spatial database. +mt 20:41, 28 February 2011 (UTC)[reply]

I disagree of merging spatial index but under some circumstances it can be added as a subsection. —Preceding unsigned comment added by 202.133.55.135 (talk) 04:37, 5 April 2011 (UTC)[reply]

I think merging spatial index as a subsection here would be a good idea; that subject is certainly a sub-area of the spatial database, and the current article ends up having to describe what a spatial database is, before it describes the index-specific information. MeekMark (talk) 20:34, 5 May 2011 (UTC)[reply]

Example DDL and query

I think an example of the DDL required to create a simple spatial table, and sample SQL showing some features, would be quite helpful here. MeekMark (talk) 20:38, 5 May 2011 (UTC)[reply]

Non-notable entry removed

I have removed the recent - probably self-promotional - addition for GeoSpark, as it lacked any independent source let alone an existing Wikipedia article based on such sources. Wikipedia is no venue to promote relatively new applications, and editors with a likely conflict of interest should follow the guideline at WP:COI. GermanJoe (talk) 22:55, 22 October 2018 (UTC)[reply]