[Phpmyadmin-devel] Spatial Support Improvements for GSoC 2011

Michal Čihař michal at cihar.com
Fri Mar 4 16:37:53 CET 2011


Dne Fri, 4 Mar 2011 21:30:03 +0800
Liauw Jian Mei <liauw at nus.edu.sg> napsal(a):

> I am interested in contributing to the phpMyAdmin project over the coming
> summer, of which I have been a user for more than a decade.

Nice to hear that!

> I've had much experience in web development and programming, and have
> contributed in terms of extension development for other open source projects
> of which I was actively working on, such as Moodle.
> I'm particularly interested in implementing OpenGIS support, as listed in
> the GSoC Idea List for the past 2 years (
> https://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support).
> I believe that this topic is of great relevance to me, as I am minoring in
> Geospatial Information Systems, and have experience with spatial analysis
> and databases, such as Geodatabase and shapefiles with ESRI ArcGIS.
> I've looked into the supported spatial features of both MySQL and
> phpMyAdmin, and have found that phpMyAdmin already supports creation of
> columns with MySQL supported spatial types as well as well known text (WKT)
> and well known blob (WKB) spatial functions.
> However, user input of spatial data is still very much textual
> with Backus-Naur grammar and is not sufficiently intuitive. It'd be
> interesting and useful to support graphical data input and spatial data
> representation with the following improvements:
>    1. Browser transformation to represent spatial data in a variety of
>    formats, such as an image with point/line/polygon or Google Maps with
>    overlay,
>    2. Spatial data entry with Google Map location pinning.

I'd prefer using OpenStreetMap instead of proprietary Google Maps for
this. However graphical entering of data is surely welcome.

	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110304/c8d12f5d/attachment.sig>

More information about the Developers mailing list