[Phpmyadmin-devel] GSoC Idea OpenGIS Support
Hi, I have the following suggestions regarding the OpenGIS support in phpMyAdmin. Problem: There is no proper representation of spatial data. The current version shows the bytes occupied by the spatial data value. Suggestion: A visual representation of data will be more apt or at least a representation to show which type of geometry class it is has to be there. Problem: Inserting data of spatial type. Suggestion: A simple interface where user can select the geometry class from the list and enter the data in a convenient form. For example, If a MULTILINESTRING has to be entered, the user has to manually type MULTILINESTRING and then type its constituents. MULTILINESTRING(LINESTRING(....), LINESTRING(...), .....). Since these datatypes are fixed, a simple interface to select the types will be useful. Problem: The user cannot edit the fields of spatial data. Raw data is displayed. Suggestion: A similar interface mentioned above can be used to edit the value of a spatial field. The corresponding visual representation can be displayed if required. Problem: No support for spatial indexes. Suggestion: Provision for specifying spatial indexes on spatial fields can be added. Problem: Search on spatial data tables. Suggestion: Currently the search functionality on spatial tables is not appropriate. The search has to return the matching geometric entries. A visual representation can be additionally displayed to show the matching geometrics that has the given search item. Problem: Specifying values in WKB format. Suggestion: When user wishes to enter the values in WKB format, an interface must be built to generate the bits in appropriate endian form and conversion from WKB to WKT must be provided. Problem: Spatial table on export produces raw data. Suggestion: The spatial data can be exported as svg or png for the given scale or at least in a form that represents data in a proper way. These are some of my suggestions, improvements have to be done everywhere to support spatial data types. What else can I add to the above list? Thank you
Hi Dne Wed, 23 Mar 2011 02:02:32 +0530 Ravindra Nath Kakarla <ravindhranath@gmail.com> napsal(a):
I have the following suggestions regarding the OpenGIS support in phpMyAdmin.
Problem: There is no proper representation of spatial data. The current version shows the bytes occupied by the spatial data value. Suggestion: A visual representation of data will be more apt or at least a representation to show which type of geometry class it is has to be there.
Problem: Inserting data of spatial type. Suggestion: A simple interface where user can select the geometry class from the list and enter the data in a convenient form. For example, If a MULTILINESTRING has to be entered, the user has to manually type MULTILINESTRING and then type its constituents. MULTILINESTRING(LINESTRING(....), LINESTRING(...), .....). Since these datatypes are fixed, a simple interface to select the types will be useful.
Problem: The user cannot edit the fields of spatial data. Raw data is displayed. Suggestion: A similar interface mentioned above can be used to edit the value of a spatial field. The corresponding visual representation can be displayed if required.
There was also suggestion to allow use of maps like openstreetmap.org or google maps for displaying/editing the data.
Problem: No support for spatial indexes. Suggestion: Provision for specifying spatial indexes on spatial fields can be added.
Problem: Search on spatial data tables. Suggestion: Currently the search functionality on spatial tables is not appropriate. The search has to return the matching geometric entries. A visual representation can be additionally displayed to show the matching geometrics that has the given search item.
Again, maps could be used for this.
Problem: Specifying values in WKB format. Suggestion: When user wishes to enter the values in WKB format, an interface must be built to generate the bits in appropriate endian form and conversion from WKB to WKT must be provided.
Isn't this rather import/export issue?
Problem: Spatial table on export produces raw data. Suggestion: The spatial data can be exported as svg or png for the given scale or at least in a form that represents data in a proper way.
I guess you want to export raw data for SQL export, for things like PDF, it could definitely be image representing the data. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi Michal, Thanks for your feedback. On Thu, Mar 24, 2011 at 9:50 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Wed, 23 Mar 2011 02:02:32 +0530 Ravindra Nath Kakarla <ravindhranath@gmail.com> napsal(a):
I have the following suggestions regarding the OpenGIS support in phpMyAdmin.
Problem: There is no proper representation of spatial data. The current version shows the bytes occupied by the spatial data value. Suggestion: A visual representation of data will be more apt or at least a representation to show which type of geometry class it is has to be there.
Problem: The user cannot edit the fields of spatial data. Raw data is displayed. Suggestion: A similar interface mentioned above can be used to edit the value of a spatial field. The corresponding visual representation can be displayed if required.
There was also suggestion to allow use of maps like openstreetmap.org or google maps for displaying/editing the data.
I feel a simple graphical editor for manipulating spatial data will be more appropriate. Not all data may correspond to real world geography. Additionally, the data can be linked to OSM if user wishes to manipulate it that way. Is there any license issue with using google maps?
On Sat, Mar 26, 2011 at 2:02 AM, Ravindra Nath Kakarla < ravindhranath@gmail.com> wrote:
Hi Michal,
Thanks for your feedback.
On Thu, Mar 24, 2011 at 9:50 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Wed, 23 Mar 2011 02:02:32 +0530 Ravindra Nath Kakarla <ravindhranath@gmail.com> napsal(a):
I have the following suggestions regarding the OpenGIS support in phpMyAdmin.
Problem: There is no proper representation of spatial data. The current version shows the bytes occupied by the spatial data value. Suggestion: A visual representation of data will be more apt or at least a representation to show which type of geometry class it is has to be there.
Problem: The user cannot edit the fields of spatial data. Raw data is displayed. Suggestion: A similar interface mentioned above can be used to edit the value of a spatial field. The corresponding visual representation can be displayed if required.
There was also suggestion to allow use of maps like openstreetmap.org or google maps for displaying/editing the data.
I feel a simple graphical editor for manipulating spatial data will be more appropriate. Not all data may correspond to real world geography. Additionally, the data can be linked to OSM if user wishes to manipulate it that way. Is there any license issue with using google maps?
Hi,
A good compromise would be to link to OSM when a spacial reference id is present and visualize GIS data in simple graphical editor otherwise. -- Thanks and Regards, Madhura Jayaratne
Hi Dne Sat, 26 Mar 2011 02:02:59 +0530 Ravindra Nath Kakarla <ravindhranath@gmail.com> napsal(a):
I feel a simple graphical editor for manipulating spatial data will be more appropriate. Not all data may correspond to real world geography. Additionally, the data can be linked to OSM if user wishes to manipulate it that way. Is there any license issue with using google maps?
Definitely not everything needs to match real world, however having it as an option is definitely useful. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
participants (3)
-
Madhura Jayaratne -
Michal Čihař -
Ravindra Nath Kakarla