We help IT Professionals succeed at work.

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

429 Views
Last Modified: 2013-12-18
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
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Topic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mark WillsTopic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Aplogies AngelIII, only saw the top line, kind of skipped over your reference to "the free sql server express"
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
>I got answer my self. I dont want this question to be continued.
please share that with us, if you don't mind?
Mark WillsTopic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018

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

Author

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
Mark WillsTopic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
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...
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.