[Phpmyadmin-devel] More options for browsing OpenGIS data
Hi all, I have pushed the implementation of the feature 'More options for browsing GIS data' to my repository and you can test it at the demo server[1]. With this, three options have been added to the ‘Options’ section of query result browsing window - To view geometric data in Well Known Text (WKT) format - To view geometric data in Well Known Binary (WKB) format - To view geometric data with Geometric type indication and size (e.g. [GEOMETRY – 2.2KiB]) You can use geometric data in the 'OpenGIS' database to test the feature. If the database is not there by the time you visit, please use the SQL file at [2] to generate the database. Your feedback is highly valued :) Thanks in advance, Madhura Jayaratne [1] http://demo.phpmyadmin.net/gsoc-madhura/index.php [2] https://sourceforge.net/tracker/?func=detail&aid=3300081&group_id=23067&atid...
On Mon, 2011-05-23 at 23:26 +0530, Madhura Jayaratne wrote:
Hi all,
I have pushed the implementation of the feature 'More options for browsing GIS data' to my repository and you can test it at the demo server[1].
With this, three options have been added to the ‘Options’ section of query result browsing window
* To view geometric data in Well Known Text (WKT) format * To view geometric data in Well Known Binary (WKB) format * To view geometric data with Geometric type indication and size (e.g. [GEOMETRY – 2.2KiB]) You can use geometric data in the 'OpenGIS' database to test the feature. If the database is not there by the time you visit, please use the SQL file at [2] to generate the database. Your feedback is highly valued :)
Thanks in advance,
Madhura Jayaratne
Hi Madhura, I'm not very familiar with GIS format so I can't really give you any feedback with that. All I noticed that might need to be looked at is the labels near the "Width", "Height", "Label Column" and "spatial Column" which are not correctly aligned vertically with respect to the input fields. Also it looks like you have hardcoded the width of these input fields, so sometimes they are unnecessarily pushed down onto a new row, though I'm not sure about what is the best way to handle that. Rouslan
On Tue, May 24, 2011 at 3:51 AM, Rouslan Placella <rouslan@placella.com>wrote:
On Mon, 2011-05-23 at 23:26 +0530, Madhura Jayaratne wrote:
Hi all,
I have pushed the implementation of the feature 'More options for browsing GIS data' to my repository and you can test it at the demo server[1].
With this, three options have been added to the ‘Options’ section of query result browsing window
* To view geometric data in Well Known Text (WKT) format * To view geometric data in Well Known Binary (WKB) format * To view geometric data with Geometric type indication and size (e.g. [GEOMETRY – 2.2KiB]) You can use geometric data in the 'OpenGIS' database to test the feature. If the database is not there by the time you visit, please use the SQL file at [2] to generate the database. Your feedback is highly valued :)
Thanks in advance,
Madhura Jayaratne
Hi Madhura,
I'm not very familiar with GIS format so I can't really give you any feedback with that. All I noticed that might need to be looked at is the labels near the "Width", "Height", "Label Column" and "spatial Column" which are not correctly aligned vertically with respect to the input fields. Also it looks like you have hardcoded the width of these input fields, so sometimes they are unnecessarily pushed down onto a new row, though I'm not sure about what is the best way to handle that.
Rouslan
Hi Rouslan, Thanks for you feedback. However you are looking at the feature 'Visualizing GIS data', which I have not yet finalized. Sure, I will look into the alignment problem. I believe you are seeing it with the theme pmahomme. -- Thanks and Regards, Madhura Jayaratne
2011/5/24 Madhura Jayaratne <madhura.cj@gmail.com>:
I have pushed the implementation of the feature 'More options for browsing GIS data' to my repository and you can test it at the demo server[1].
With this, three options have been added to the ‘Options’ section of query result browsing window
* To view geometric data in Well Known Text (WKT) format * To view geometric data in Well Known Binary (WKB) format * To view geometric data with Geometric type indication and size (e.g. [GEOMETRY – 2.2KiB]) You can use geometric data in the 'OpenGIS' database to test the feature. If the database is not there by the time you visit, please use the SQL file at [2] to generate the database. Your feedback is highly valued :)
I have'nt looked closely, but one thing struck me - please add space before units in "[GEOMETRY – 2.2KiB]", seeing "2KiB" may look ok, but "2bytes" is just wrong :) -- Piotr Przybylski
On Tue, May 24, 2011 at 12:00 PM, Piotr Przybylski <piotr.prz@gmail.com>wrote:
2011/5/24 Madhura Jayaratne <madhura.cj@gmail.com>:
I have pushed the implementation of the feature 'More options for browsing GIS data' to my repository and you can test it at the demo server[1].
With this, three options have been added to the ‘Options’ section of query result browsing window
* To view geometric data in Well Known Text (WKT) format * To view geometric data in Well Known Binary (WKB) format * To view geometric data with Geometric type indication and size (e.g. [GEOMETRY – 2.2KiB]) You can use geometric data in the 'OpenGIS' database to test the feature. If the database is not there by the time you visit, please use the SQL file at [2] to generate the database. Your feedback is highly valued :)
I have'nt looked closely, but one thing struck me - please add space before units in "[GEOMETRY – 2.2KiB]", seeing "2KiB" may look ok, but "2bytes" is just wrong :)
-- Piotr Przybylski
Hi Piotr, Thank you for your comment. Displaying the text 'GEOMETRY' and size next to it was the default way the geometry data were displayed and I did not make any alterations to it. I only added the other two types (WKT and WKB). Looking into it a bit I noticed that a similar way is used for BINARY and BLOB. Further 2 bytes are displayed as 2B. -- Thanks and Regards, Madhura Jayaratne
Hi Dne Tue, 24 May 2011 12:52:44 +0530 Madhura Jayaratne <madhura.cj@gmail.com> napsal(a):
Displaying the text 'GEOMETRY' and size next to it was the default way the geometry data were displayed and I did not make any alterations to it. I only added the other two types (WKT and WKB). Looking into it a bit I noticed that a similar way is used for BINARY and BLOB.
Further 2 bytes are displayed as 2B.
Anyway but in other places space is used so I've changed this one as well. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi Dne Mon, 23 May 2011 23:26:55 +0530 Madhura Jayaratne <madhura.cj@gmail.com> napsal(a):
If the database is not there by the time you visit, please use the SQL file at [2] to generate the database.
I've created the opengis database and it will be refreshed same way as currently sakila or world are, so it should be always present. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
On Tue, May 24, 2011 at 4:26 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Mon, 23 May 2011 23:26:55 +0530 Madhura Jayaratne <madhura.cj@gmail.com> napsal(a):
If the database is not there by the time you visit, please use the SQL file at [2] to generate the database.
I've created the opengis database and it will be refreshed same way as currently sakila or world are, so it should be always present.
Thanks Michal, this is a great help for all of us to test the new features supporting OpenGIS data types. -- Thanks and Regards, Madhura Jayaratne
participants (4)
-
Madhura Jayaratne -
Michal Čihař -
Piotr Przybylski -
Rouslan Placella