10 May
2011
10 May
'11
9:03 p.m.
Hi all,
During the past few days I was playing around with the code to do a test
implementation for GIS data visualization. Now I have pushed it to my repo
and I would like to hear you comments about it. You can check it out at [1].
Currently it does the following
1. 'Visualize GIS data' link is displayed in 'Query results options' pane
ONLY for query results that has atleast one geometric column.
2. If there are more than one geometric columns in the results, the user can
chose which column to be used for th visualization
3. You chose out of non-geometric columns a label column, which is used for
tooltips.
4. Also, try zooming and panning.
I created a database with geometric data (database: opengis), so it would be
easy for you to test the above. In case database server has reset by the
time you login and you can't find the database, I have also attached the sql
file here.
--
Thanks and Regards,
Madhura Jayaratne
[1] http://demo.phpmyadmin.net/gsoc-madhura
10 May
10 May
9:09 p.m.
Madhura Jayaratne a écrit :
Hi all,
During the past few days I was playing around with the code to do a test
implementation for GIS data visualization. Now I have pushed it to my
repo and I would like to hear you comments about it. You can check it
out at [1].
Currently it does the following
1. 'Visualize GIS data' link is displayed in 'Query results options'
pane ONLY for query results that has atleast one geometric column.
2. If there are more than one geometric columns in the results, the user
can chose which column to be used for th visualization
3. You chose out of non-geometric columns a label column, which is used
for tooltips.
4. Also, try zooming and panning.
I created a database with geometric data (database: opengis), so it
would be easy for you to test the above. In case database server has
reset by the time you login and you can't find the database, I have also
attached the sql file here.
Madhura,
no file was attached but I suggest opening a patch artifact and
attaching your file there.
--
Marc Delisle
http://infomarc.info
9:21 p.m.
New subject: [Phpmyadmin-devel] Prototype implementation - Visualizing GIS data
On Tue, May 10, 2011 at 11:39 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Madhura Jayaratne a écrit :
I opened a patch artifact and attached the sql file there. You can find it
at [1]
--
Thanks and Regards,
Madhura Jayaratne
[1]
https://sourceforge.net/tracker/?func=detail&aid=3300081&group_id=2…
Hi all,
During the past few days I was playing around with the code to do a test
implementation for GIS data visualization. Now I have pushed it to my
repo and I would like to hear you comments about it. You can check it
out at [1].
Currently it does the following
1. 'Visualize GIS data' link is displayed in 'Query results options'
pane ONLY for query results that has atleast one geometric column.
2. If there are more than one geometric columns in the results, the user
can chose which column to be used for th visualization
3. You chose out of non-geometric columns a label column, which is used
for tooltips.
4. Also, try zooming and panning.
I created a database with geometric data (database: opengis), so it
would be easy for you to test the above. In case database server has
reset by the time you login and you can't find the database, I have also
attached the sql file here.
Madhura,
no file was attached but I suggest opening a patch artifact and
attaching your file there.
Ooops!!
9:29 p.m.
New subject: [Phpmyadmin-devel] Prototype implementation - Visualizing GIS data
On Tue, May 10, 2011 at 11:51 PM, Madhura Jayaratne <madhura.cj(a)gmail.com>wrote;wrote:
On Tue, May 10, 2011 at 11:39 PM, Marc Delisle <marc(a)infomarc.info> wrote:
One problem I encountered during the implementation is that flot does not
support drawing polygons with voids inside them. I had to draw another
polygon with its fill color set to background color in order to pretend the
void and i'm not vary happy with that :(
However reading the SVG specification I didn't find it to support polygons
with voids either [1]. I'm wondering what to do about that.
--
Thanks and Regards,
Madhura Jayaratne
[1] http://www.w3.org/TR/SVG11/shapes.html#PolygonElement
Madhura Jayaratne a écrit :
I opened a patch artifact and attached the sql file there. You can find
it
at [1]
Hi all,
During the past few days I was playing around with the code to do a test
implementation for GIS data visualization. Now I have pushed it to my
repo and I would like to hear you comments about it. You can check it
out at [1].
Currently it does the following
1. 'Visualize GIS data' link is displayed in 'Query results options'
pane ONLY for query results that has atleast one geometric column.
2. If there are more than one geometric columns in the results, the user
can chose which column to be used for th visualization
3. You chose out of non-geometric columns a label column, which is used
for tooltips.
4. Also, try zooming and panning.
I created a database with geometric data (database: opengis), so it
would be easy for you to test the above. In case database server has
reset by the time you login and you can't find the database, I have also
attached the sql file here.
Madhura,
no file was attached but I suggest opening a patch artifact and
attaching your file there.
Ooops!! 
11 May
11 May
2:07 a.m.
New subject: [Phpmyadmin-devel] Prototype implementation - Visualizing GIS data
2011/5/10 Madhura Jayaratne <madhura.cj(a)gmail.com>om>:
On Tue, May 10, 2011 at 11:51 PM, Madhura Jayaratne <madhura.cj(a)gmail.com>
wrote:
What do you mean by "polygons with voids"? It you mean that you need a
polygon's outline, use <polyline> with the first point repeated at the
end, this should do the trick.
--
Piotr Przybylski
On Tue, May 10, 2011 at 11:39 PM, Marc Delisle <marc(a)infomarc.info> wrote:
One problem I encountered during the implementation is that flot does not
support drawing polygons with voids inside them. I had to draw another
polygon with its fill color set to background color in order to pretend the
void and i'm not vary happy with that :(
However reading the SVG specification I didn't find it to support polygons
with voids either [1]. I'm wondering what to do about that.
Madhura Jayaratne a écrit :
Ooops!!
I opened a patch artifact and attached the sql file there. You can find it
at [1]
Hi all,
During the past few days I was playing around with the code to do a
test
implementation for GIS data visualization. Now I have pushed it to my
repo and I would like to hear you comments about it. You can check it
out at [1].
Currently it does the following
1. 'Visualize GIS data' link is displayed in 'Query results options'
pane ONLY for query results that has atleast one geometric column.
2. If there are more than one geometric columns in the results, the
user
can chose which column to be used for th visualization
3. You chose out of non-geometric columns a label column, which is used
for tooltips.
4. Also, try zooming and panning.
I created a database with geometric data (database: opengis), so it
would be easy for you to test the above. In case database server has
reset by the time you login and you can't find the database, I have
also
attached the sql file here.
Madhura,
no file was attached but I suggest opening a patch artifact and
attaching your file there.
5:24 a.m.
New subject: [Phpmyadmin-devel] Prototype implementation - Visualizing GIS data
On Wed, May 11, 2011 at 4:37 AM, Piotr Przybylski <piotr.prz(a)gmail.com>wrote;wrote:
2011/5/10 Madhura Jayaratne
<madhura.cj(a)gmail.com>om>:
the
In a polygon object like
POLYGON((35 10,10 20,15 40,45 45,35 10),(20 30,35 35,30 20,20 30))
(35 10,10 20,15 40,45 45,35 10) refers to the outer ring while (20 30,35
35,30 20,20 30) refers to the inner ring.
A polygon has exactly one outer ring and zero or more inner rings.
When visualizing the polygon, area under the outer ring, but not under any
inner rings should be colored.
So the hack I have used is, I have drawn the outer ring and on top of that
drawn the inner rings with the background color. You can find a polygon
which has inner rings in the dataset I have uploaded to the demo. (database:
opengis, table:gis_all)
--
Thanks and Regards,
Madhura Jayaratne
On Tue, May 10, 2011 at 11:51 PM, Madhura Jayaratne <
madhura.cj(a)gmail.com>
wrote:
>
>
> On Tue, May 10, 2011 at 11:39 PM, Marc Delisle <marc(a)infomarc.info>
wrote:
>>
>> Madhura Jayaratne a écrit :
>> > Hi all,
>> >
>> > During the past few days I was playing around with the code to do a
>> > test
>> > implementation for GIS data visualization. Now I have pushed it to my
>> > repo and I would like to hear you comments about it. You can check it
>> > out at [1].
>> >
>> > Currently it does the following
>> > 1. 'Visualize GIS data' link is displayed in 'Query results
options'
>> > pane ONLY for query results that has atleast one geometric column.
>> > 2. If there are more than one geometric columns in the results, the
>> > user
>> > can chose which column to be used for th visualization
>> > 3. You chose out of non-geometric columns a label column, which is
used
>> > for tooltips.
>> > 4. Also, try zooming and panning.
>> >
>> > I created a database with geometric data (database: opengis), so it
>> > would be easy for you to test the above. In case database server has
>> > reset by the time you login and you can't find the database, I have
>> > also
>> > attached the sql file here.
>> >
>>
>> Madhura,
>> no file was attached but I suggest opening a patch artifact and
>> attaching your file there.
>>
> Ooops!!
> I opened a patch artifact and attached the sql file there. You can find
it
at [1]
One problem I encountered during the implementation is that flot does not
support drawing polygons with voids inside them. I had to draw another
polygon with its fill color set to background color in order to pretend void and i'm not vary happy with that :(
However reading the SVG specification I didn't find it to
support polygons
with voids either [1]. I'm wondering what to
do about that.
What do you mean by "polygons with voids"? It you mean that you need a
polygon's outline, use <polyline> with the first point repeated at the
end, this should do the trick.
4880
days inactive
4881
days old
5 comments
3 participants
participants (3)
-
Madhura Jayaratne -
Marc Delisle -
Piotr Przybylski