What databases other than oracle that supports GEOMETRY type ( spatial data type).

Hello All,

I am using oracle spatial and locator database in my project.
Now client wants to use some other license free database.
Please suggest if you have any idea about this.

Thanks in advance.
Regards,
dAshish
dashishAsked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
MySQL has tried to include the beginnings, but not quite as advanced as Oracle and SQL Server 2008.

We have had at least one posting here in EE for 2008, and solution worked pretty well by all accounts (considering I was involved).

Have only used it in anger in SQL 2008. Supports both geometry ( for Euclidean or flat-earth - conforming to the Open Geospatial Consortium OGC) and geography  ( for ellipsoidal or round-earth) data types and quite a plethora of functions that go with it. It can be a bit "delicate" meaning it is not hugely tolerant, but does work very well otherwise.

And there is a free database - it is SQL 2008 Express (with advanced services).

Have a look at : http://msdn.microsoft.com/en-us/library/cc280766.aspx
and : http://msdn.microsoft.com/en-us/library/cc280487.aspx


0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
there is no free database I know of supporting this feature.
sql server 2008 does have the geometry/spatial data types, and they are included in the free sql server express edition:
http://msdn.microsoft.com/en-us/library/cc645993.aspx
0
 
Mark WillsTopic AdvisorCommented:
Aplogies AngelIII, only saw the top line, kind of skipped over your reference to "the free sql server express"
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>I got answer my self. I dont want this question to be continued.
please share that with us, if you don't mind?
0
 
Mark WillsTopic AdvisorCommented:
Yes, would enjoy to hear all about the alternatives... I do enjoy spatial data, and anything to further extend understanding and knowledge is most welcomed.
0
 
dashishAuthor Commented:
MySql 5.0 support Geometry type spatial data type and its community version is free.

PostGre database has extended database PostGIS that also support spatial data type column.

Thanks,
dAshish
0
 
Mark WillsTopic AdvisorCommented:
Thought I had mentioned MySQL - but not quite as advanced... So, you are saying that the question needs to be deleted because you found an extension to the PostgreSQL database ? Give me a break - please...

Accept your entry as the "solution" but think some points might be worthy as "assist" - our answers were not wrong...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
actually, my very first sentence was wrong:
>there is no free database I know of supporting this feature.<

and I contradicted myself in that same post:
>sql server 2008 does have the geometry/spatial data types, and they are included in the free sql server express edition:<

mark_wills first comment:
>MySQL has tried to include the beginnings, but not quite as advanced as Oracle and SQL Server 2008.<
also shows one options, but clearly marking it as possibly not the right choice.

and actually, oracle express edition which is also free has the geometry data type as well.

so, I would recommend a assist of
http:#a22603175 (50)
http:#a22621469 (75)
http:#a22728251  (0 points)

angel eyes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.