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?

  • $\begingroup$ 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? $\endgroup$ – hichris123 Apr 20 '14 at 16:21

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


Link: http://postgis.net/

  • 3
    $\begingroup$ +1 for Postgres/PostGIS - this is the first question that is relevant to my day job :-) $\endgroup$ – winwaed Apr 20 '14 at 21:56
  • $\begingroup$ 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. $\endgroup$ – kwknowles Apr 21 '14 at 2:16
  • $\begingroup$ That takes care of half the multiple hemisphere problem. The other half is arcs longer than 180 degrees. (postgis.net/docs/manual-1.5/ch04.html#id358554) $\endgroup$ – kwknowles Apr 21 '14 at 15:02
  • 1
    $\begingroup$ 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. $\endgroup$ – winwaed Apr 21 '14 at 19:08
  • $\begingroup$ 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. $\endgroup$ – tobias47n9e Apr 21 '14 at 20:30

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.

  • $\begingroup$ 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? $\endgroup$ – kwknowles Apr 21 '14 at 2:20
  • $\begingroup$ 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... $\endgroup$ – winwaed Apr 21 '14 at 12:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.