<p>The best open-source and free geospatial database is in my opinion PostGIS. It is easy to use and has a huge support group (also for example at  <a href="https://gis.stackexchange.com/">https://gis.stackexchange.com/</a>)</p>

<p>It also connect to all sorts of different open-source programs and web-interfaces which should make data editing, viewing and sharing easy.</p>

<p>It can handle the date-line and the poles:</p>

<pre><code> 4.2.3.2.
 What about the date-line and the poles?
 All the calculations have no conception of date-line or poles, the coordinates are spherical (longitude/latitude) so a shape that crosses the dateline is, from a calculation point of view, no different from any other shape. 
</code></pre>

<p>(<a href="http://postgis.net/docs/manual-1.5/ch04.html#id358535" rel="nofollow noreferrer">http://postgis.net/docs/manual-1.5/ch04.html#id358535</a>)</p>

<p>Link: <a href="http://postgis.net/" rel="nofollow noreferrer">http://postgis.net/</a></p>

CC BY-SA 3.0
2014-04-20T21:56:51.187Z
+1 for Postgres/PostGIS - this is the first question that is relevant to my day job :-)
winwaed
CC BY-SA 3.0
2014-04-21T02:16:40.320Z
Last I checked, PostGIS doesn't support polar search, nor crossing the IDL. It makes the ubiquitous mistake of all GIS that latitude/longitude is a Cartesian coordinate system. The answer isn't as easy as that.
kwknowles
CC BY-SA 3.0
2014-04-21T15:02:53.343Z
That takes care of half the multiple hemisphere problem. The other half is arcs longer than 180 degrees. (http://postgis.net/docs/manual-1.5/ch04.html#id358554)
kwknowles
CC BY-SA 3.0
2014-04-21T19:08:54.937Z
Using only two data points, how would you define an arc longer than 180 degrees? I don't think it is possible. You always have to assume (define a priori) how the two points will be joined, and the shortest segment on a Great Circle connecting the points is the only reasonable way I can think of.
winwaed
CC BY-SA 3.0
2014-04-21T20:30:57.723Z
I was also thinking that similar to a tangent function you always have to tell the algorithm which quadrant or in this case distance you are interested in.
tobias47n9e
CC BY-SA 3.0
2014-04-20T16:02:11.427Z
2014-04-21T08:10:23.353Z
2017-04-13T12:33:47.360Z
tobias47n9e
<p>I agree with Speissburger that PostGIS (an extension of Postgre) has excellent Geospatial support. In the open source world, this would also be my recommendation.
(MySQL claims to have some geospatial support but it is very limited in capabilities)</p>

<p>For completeness, Microsoft's SQL Server also has good geospatial support - I think it was introduced as an extension to SQL Server 2008, and then standard after that.
I have heard that Oracle also has good geospatial support, although I have never use it.</p>

CC BY-SA 3.0
2014-04-21T02:20:54.680Z
Are you sure these can do polar searches? Or, multi-hemisphere i.e. crossing prime meridian, IDL, over a pole, over both poles? I can't find this information. Do you have a reference?
kwknowles
CC BY-SA 3.0
2014-04-21T12:52:54.427Z
I'm not sure, but I thought it was implied (unlike say MySQL where the Search cabilities are so limited, one would not expect this kind of support). I see Speissburger has updated his answer...
winwaed
CC BY-SA 3.0
2014-04-20T22:01:11.923Z
2014-04-20T22:01:11.923Z
winwaed
<p>We need to store coverage areas and search by location over arbitrarily large areas. It has to be able to handle polar searches and coverage areas that span multiple hemispheres. No GIS can do this. Informix has the Geospatial Datablade, but it costs like a hundred grand. Does anyone use something more affordable--preferably free? </p>

CC BY-SA 3.0
2014-04-20T16:21:12.897Z
Meh, I'm not really sure that this is off-topic. I'm going to post a meta question about it (not that this is a bad question, I'm just not sure if software-recommendations are on-topic here). **EDIT:** Meta question asked: [Are software-requests on-topic?](http://meta.earthscience.stackexchange.com/questions/121/are-software-requests-on-topic)
hichris123
<geospatial><database>
Does anyone know of a DBMS with global geospatial search?
kwknowles
# Does anyone know of a DBMS with global geospatial search?

(Asked by: username_0 on 2014-04-20)

We need to store coverage areas and search by location over arbitrarily large areas. It has to be able to handle polar searches and coverage areas that span multiple hemispheres. No GIS can do this. Informix has the Geospatial Datablade, but it costs like a hundred grand. Does anyone use something more affordable--preferably free?

**Tags:** geospatial, database

> **Comments:**
> **username_1**: Meh, I'm not really sure that this is off-topic. I'm going to post a meta question about it (not that this is a bad question, I'm just not sure if software-recommendations are on-topic here). **EDIT:** Meta question asked: [Are software-requests on-topic?](http://meta.earthscience.stackexchange.com/questions/121/are-software-requests-on-topic)  

---

## 2 answers

### Answer by username_2 on 2014-04-20. Score: 7

The best open-source and free geospatial database is in my opinion PostGIS. It is easy to use and has a huge support group (also for example at <https://gis.stackexchange.com/>)

It also connect to all sorts of different open-source programs and web-interfaces which should make data editing, viewing and sharing easy.

It can handle the date-line and the poles:

```
 4.2.3.2.
 What about the date-line and the poles?
 All the calculations have no conception of date-line or poles, the coordinates are spherical (longitude/latitude) so a shape that crosses the dateline is, from a calculation point of view, no different from any other shape. 

```

(<http://postgis.net/docs/manual-1.5/ch04.html#id358535>)

Link: <http://postgis.net/>

> **Comments:**
> **username_3**: +1 for Postgres/PostGIS - this is the first question that is relevant to my day job :-)  
> **username_0**: Last I checked, PostGIS doesn't support polar search, nor crossing the IDL. It makes the ubiquitous mistake of all GIS that latitude/longitude is a Cartesian coordinate system. The answer isn't as easy as that.  
> **username_0**: That takes care of half the multiple hemisphere problem. The other half is arcs longer than 180 degrees. (http://postgis.net/docs/manual-1.5/ch04.html#id358554)  
> **username_3**: Using only two data points, how would you define an arc longer than 180 degrees? I don't think it is possible. You always have to assume (define a priori) how the two points will be joined, and the shortest segment on a Great Circle connecting the points is the only reasonable way I can think of.  
> **username_2**: I was also thinking that similar to a tangent function you always have to tell the algorithm which quadrant or in this case distance you are interested in.  

---

### Answer by username_3 on 2014-04-20. Score: 4

I agree with Speissburger that PostGIS (an extension of Postgre) has excellent Geospatial support. In the open source world, this would also be my recommendation.
(MySQL claims to have some geospatial support but it is very limited in capabilities)

For completeness, Microsoft's SQL Server also has good geospatial support - I think it was introduced as an extension to SQL Server 2008, and then standard after that.
I have heard that Oracle also has good geospatial support, although I have never use it.

> **Comments:**
> **username_0**: Are you sure these can do polar searches? Or, multi-hemisphere i.e. crossing prime meridian, IDL, over a pole, over both poles? I can't find this information. Do you have a reference?  
> **username_3**: I'm not sure, but I thought it was implied (unlike say MySQL where the Search cabilities are so limited, one would not expect this kind of support). I see Speissburger has updated his answer...  

---

