Cartonama Workshop

Mapping Workshop

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

Abstract

Understanding how OGC is used in MySQL and PostGIS is used in PostgreSQL to use MySQL or PostgreSQL as Map server.

Outline

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.

Speaker bio

I am co-founder of ONZE Technologies. We provide India specific driving directions for some of the major metros in the country.

Comments

Login with Twitter or Google to leave a comment