×

Warning

JUser: :_load: Unable to load user with ID: 316003172

Community Q&A:

Do the databases support spatial data?

Asked by:
HubFans / n/a Points Time:
2017-07-31 2:07 pm EST Category:
Databases Hits:
464
Hello,
I would like to upload a database with spatial references to my website. Do the PostgreSQL or MySQL database support spatial data?
Is it possible to do if not and how, at what cost?
Many thanks
Marc

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

timothy_sisson
361 Points
2017-07-31 3:09 pm EST
Good morning,

Thanks for your question about spatial data and MySQL. Yes, MySQL supports spatial data. Here's their reference on <a href="https://dev.mysql.com/doc/refman/5.7/en/spatial-extensions.html">using spatial data in MySQL</a>.

I hope this helps!

Thanks!

Tim S

To submit a comment on this answer, please first login.

Hi Tim,
and thanks for your answer. What about PostgreSQL?
Cheers
Marc
Sacapuce
6 Points

2017-08-02 11:12 pm EST
Hi, Marc!

Thanks for your comment regarding PostgreSQL. It looks like PostgreSQL supports spatial data as well. Here's their documentation for <a href="https://www.postgresql.org/docs/9.5/static/datatype-geometric.html">using spatial data in PostgreSQL</a>. I hope this helps!

Sincerely,
Carlos E



2017-08-02 11:25 pm EST
Hi,
and many thanks for the links.
For the MySQL, is the spatial extension part of the existing build?
For the Postgress one, is PostGIS installed as well? http://postgis.net/
Cheers
Marc
Sacapuce
6 Points

2017-08-04 1:48 pm EST
Hello Sacapuce,

Thanks for your question about the spatial extension for MySQL and Postgre. I checked with our systems guys and the Spatial extension for MySQL isn't so much an extension as it is a table that's added. Check out this guide: How to use MySQL spatial extension. The Postgres one is a definitely a plugin that is not loaded and cannot be loaded in a HUB hosting account.

I hope this helps to answer your questions, please let us know if you require any further assistance.

Regards,
Arnel C.
arnelc
17,314 Points
Staff
2017-08-04 6:53 pm EST
Want to share this Question?

Help Center Login

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Ticket: Submit a Support Ticket
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.
}