[Webinar] Learn how to a build a cloud-first strategyRegister Now


How to make geometry checks using SQL?

Posted on 2009-04-21
Medium Priority
Last Modified: 2013-12-24

 I would like to know is there is another way to check geometrys of spatial data stored in a database more than using DBunit.

 I am currently using a Informix Database and I would like to make some geometry checks like overlapping of layers. etc

 Exist a sofware, technique, technology.. that I can use to make this geometry checks?

 Thanks in advance.
Question by:Fionageo
  • 4
LVL 62

Accepted Solution

gheist earned 1344 total points
ID: 24225733
You have to create stored procedures for geometry needs.
I'd suggest converting to PostGIS which is free GIS database with all geometry included.
LVL 43

Assisted Solution

pcelba earned 672 total points
ID: 24231400
MS SQL Server 2008 supports new data types Geography and Geometry. These new data types support polygon unions and intersections and more. I am just studying that and it seems to be interesting (for me at least) and it is closely tied to CLR of MS Visual Studio 2008. Both SQL and VS 2008 are available as trial versions, so why not to try it? (In other words a good reason to leave Informix :-).
LVL 62

Expert Comment

ID: 24231755
Not even as trial versions - you can get free ones also. Look for SQL2008 express - at least it does not expire.
PostGIS has .NET driver as well to integrate with VS2008.
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Expert Comment

ID: 24237100
Hi, thanks for your reply, but I cannot change the Informix DB, because that is the DB that the user has.
LVL 62

Assisted Solution

gheist earned 1344 total points
ID: 24237107
OK - http://www-01.ibm.com/software/data/informix/blades/spatial/
It costs btw, but otherwise no problem...
LVL 62

Expert Comment

ID: 24419428
Two alternate GIS systems were recommended, after limiting scope to Informix only a costly option was available
I suggest a split between http:#24237107 http:#24231400 and http:#24225733

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Stellar Exchange Toolkit: this 5 in 1 toolkit comes loaded with mega-software tool. Here’s an introduction to tools’ usage and advantages:
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question