Managing Map Data in MySQL or PostgreSQL
Submitted by Mayank Sharma (@mayanks) (proposing) on Thursday, 2 February 2012
This is a proposal requesting for someone to speak on this topic. If you’d like to speak, leave a comment.
Section: Working with Geo Data Technical level: Intermediate Session type: Demo Status: Submitted
Understanding how OGC is used in MySQL and PostGIS is used in PostgreSQL to use MySQL or PostgreSQL as Map server.
MySQL implements Geo spatial extensions using opengis and PostgreSQL uses PostGIS. Both these extensions enhances traditional databases to perform geo spatial queries. Queries like existence of a Point in a polygon or distance between points/polygons can directly be executed in the DB.
This workshop will talk about these extensions (opengis and/or postgis) and demonstrate the type of database queries that can be run using them.
I am co-founder of ONZE Technologies. We provide India specific driving directions for some of the major metros in the country.