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.

videocam_off

Technical level

Intermediate

Section

Working with Geo Data

Session type

Demo

Status

Submitted

Vote on this proposal

Login to vote

Total votes:  +3

Objective

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

Description

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

  • 1
    Deepak Kannan (@deepak) 6 years ago

    how is this different over http://funnel.hasgeek.com/cartonama-workshop/200-geo-enabled-databases

    • 1
      Kiran Jonnalagadda (@jace) Reviewer 6 years ago

      It's the same. Mayank missed that initially.

Login with Twitter or Google to leave a comment