I am a newbie in Geoserver and I have a question about it. In my situation,
I have developed one application that will store a longitude and latitude
into MySQL. And there’s one other form that will pass the longitude and
latitude to the Geoserver. There should be waypoint that shows the exact
location, referring to the longitude and latitude on the map. Is there any
idea or any tips that I can follow in order to make it’s happen? And is it
possible Geoserver can do all this things? Hopefully there’s somebody out
there that can help me out. Thank you.
A couple of questions to make sure I understand. So you are storing lon lat in a mysql database. Are you using one column for x and one column for y, or are you using the POINT mysql spatial type? I assume that if you are able to view the data on a map in GeoServer that you are using the mysql plugin and therefore using the geometry type.
So what you want is to show a map and have the actual coordinates viewable? One way to accomplish this would be with a WMS GetFeatureInfo request. If you look at the GeoServer "MapPreview" and click on the map you will attribute information about the feature or point you are clicking on. Is this similar to what you want to achieve. Or do you want to have the map styles so that points are labeled with lon,lat values?
I hope I understood your request. Please ask more questions if anything is unclear or I did not quite understand.
-Justin
Azzmy wrote:
Hi,
I am a newbie in Geoserver and I have a question about it. In my situation,
I have developed one application that will store a longitude and latitude
into MySQL. And there’s one other form that will pass the longitude and
latitude to the Geoserver. There should be waypoint that shows the exact
location, referring to the longitude and latitude on the map. Is there any
idea or any tips that I can follow in order to make it’s happen? And is it
possible Geoserver can do all this things? Hopefully there’s somebody out
there that can help me out. Thank you.
regards,
Azzmy
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
Thanks for your response. In my situation, I’m using one column for x and
one column for y in MySQL. Actually, I want to develop one system that will
track the location. For example, the system will send a message telling that
there’s an emergency at one location. So it will store the longitude and
latitude in the database, and geoserver will pick up the position and
display on the map. And what I need is, there will be one pinpoint that
shows the exact location where the incident is happen(Include with a message
for example,"Fire in Mega complex!"). It’s exactly like what you were saying
to have the map styles so that points are labeled with lon, lat values.
Kindly advice me if there’s any tools that I can work with it or any work
around that I can follow to ensure this task can be done. Don’t hesitate to
ask me back, if you still confuse about this matter. I’m glad to work with
you in further. Big thanks!
regards,
-Azzmy
jdeolive-2 wrote:
Hi Azzmy,
A couple of questions to make sure I understand. So you are storing lon
lat in a mysql database. Are you using one column for x and one column
for y, or are you using the POINT mysql spatial type? I assume that if
you are able to view the data on a map in GeoServer that you are using
the mysql plugin and therefore using the geometry type.
So what you want is to show a map and have the actual coordinates
viewable? One way to accomplish this would be with a WMS GetFeatureInfo
request. If you look at the GeoServer "MapPreview" and click on the map
you will attribute information about the feature or point you are
clicking on. Is this similar to what you want to achieve. Or do you want
to have the map styles so that points are labeled with lon,lat values?
I hope I understood your request. Please ask more questions if anything
is unclear or I did not quite understand.
-Justin
Azzmy wrote:
Hi,
I am a newbie in Geoserver and I have a question about it. In my
situation,
I have developed one application that will store a longitude and latitude
into MySQL. And there’s one other form that will pass the longitude and
latitude to the Geoserver. There should be waypoint that shows the exact
location, referring to the longitude and latitude on the map. Is there
any
idea or any tips that I can follow in order to make it’s happen? And is
it
possible Geoserver can do all this things? Hopefully there’s somebody
out
there that can help me out. Thank you.
regards,
Azzmy
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
I am still a little confused about how your are getting the data into GeoServer? Are you using the mysql datastore extension?
Regardless, you may be able to do this with a label in an SLD. Andrea (CC'd) should know for sure.
Andrea: Do you know if this is possible in SLD? Doing a label which is made up of multple attributes?
Azzmy wrote:
Hi Justin,
Thanks for your response. In my situation, I’m using one column for x and
one column for y in MySQL. Actually, I want to develop one system that will
track the location. For example, the system will send a message telling that
there’s an emergency at one location. So it will store the longitude and
latitude in the database, and geoserver will pick up the position and
display on the map. And what I need is, there will be one pinpoint that
shows the exact location where the incident is happen(Include with a message
for example,"Fire in Mega complex!"). It’s exactly like what you were saying
to have the map styles so that points are labeled with lon, lat values.
Kindly advice me if there’s any tools that I can work with it or any work
around that I can follow to ensure this task can be done. Don’t hesitate to
ask me back, if you still confuse about this matter. I’m glad to work with
you in further. Big thanks!
regards,
-Azzmy
jdeolive-2 wrote:
Hi Azzmy,
A couple of questions to make sure I understand. So you are storing lon lat in a mysql database. Are you using one column for x and one column for y, or are you using the POINT mysql spatial type? I assume that if you are able to view the data on a map in GeoServer that you are using the mysql plugin and therefore using the geometry type.
So what you want is to show a map and have the actual coordinates viewable? One way to accomplish this would be with a WMS GetFeatureInfo request. If you look at the GeoServer "MapPreview" and click on the map you will attribute information about the feature or point you are clicking on. Is this similar to what you want to achieve. Or do you want to have the map styles so that points are labeled with lon,lat values?
I hope I understood your request. Please ask more questions if anything is unclear or I did not quite understand.
-Justin
Azzmy wrote:
Hi,
I am a newbie in Geoserver and I have a question about it. In my
situation,
I have developed one application that will store a longitude and latitude
into MySQL. And there’s one other form that will pass the longitude and
latitude to the Geoserver. There should be waypoint that shows the exact
location, referring to the longitude and latitude on the map. Is there
any
idea or any tips that I can follow in order to make it’s happen? And is
it
possible Geoserver can do all this things? Hopefully there’s somebody
out
there that can help me out. Thank you.
regards,
Azzmy
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
So Azzmy, this should probably work for you. Are you familiar with setting up SLD styles in GeoServer?
-Justin
Andrea Aime wrote:
Justin Deoliveira ha scritto:
Hi Azzmy,
I am still a little confused about how your are getting the data into GeoServer? Are you using the mysql datastore extension?
Regardless, you may be able to do this with a label in an SLD. Andrea (CC'd) should know for sure.
Andrea: Do you know if this is possible in SLD? Doing a label which is made up of multple attributes?
Yeah, labels do support mixed syntax, meaning that you can mix in the
same parent element text and subelements freely:
<Label><ogc:PropertyName>PROP_A</ogc:PropertyName> some text <ogc:PropertyName>PROP_B</ogc:PropertyName></Label>
should render fine.
Let me know if it does not.
Cheers
Andrea
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,4863a5a098811096210785!
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
Sorry to make you confuse with my problem. Anyway, thanks for the reply. The
real story behind the issue is like this. There will be two separate
systems. One is called “call card system” that will receive all the
information regarding the incident and another one is dispatcher system
(we’re using TCAD300(TETRA computer aided dispatcher)). Call card system
will capture the information includes name, incident id, location name, and
positions. All these will restore in MySQL. TCAD300 have one function to
display map and it’s integrate with geoserver. I’m thinking to work with
geoserver to plot the position on the dispatcher (on map viewer). I can say
the plotting is a real time plotting. When new record comes in, then it will
automatically plot on the map. I don’t have any rights to work around with
TCAD 300 using it's source code. So,I am thinking to start with geoserver to
handle this situation. Is it possible for me to follow your idea in order to
resolve this matter? Or maybe there’s other way that I can work with
geoserver to resolve it? I need to know how far geoserver can work to make
it’s happen. Really appreciate on your help. Thanks.
regards,
Azzmy
Justin Deoliveira-4 wrote:
Cool, Thanks Andrea,
So Azzmy, this should probably work for you. Are you familiar with
setting up SLD styles in GeoServer?
-Justin
Andrea Aime wrote:
Justin Deoliveira ha scritto:
Hi Azzmy,
I am still a little confused about how your are getting the data into
GeoServer? Are you using the mysql datastore extension?
Regardless, you may be able to do this with a label in an SLD. Andrea
(CC'd) should know for sure.
Andrea: Do you know if this is possible in SLD? Doing a label which is
made up of multple attributes?
Yeah, labels do support mixed syntax, meaning that you can mix in the
same parent element text and subelements freely:
<Label><ogc:PropertyName>PROP_A</ogc:PropertyName> some text
<ogc:PropertyName>PROP_B</ogc:PropertyName></Label>
should render fine.
Let me know if it does not.
Cheers
Andrea
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,4863a5a098811096210785!
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hi Justin,
My previous problem is already solved and thanks to you on your tips. I’ve
another question, whenever the map received the new point, I would like to
make sure the map will 'zoom in' to the direct point. Right now, when the
new point comes in, I have to clicking on the point to go deeper and deeper
to know what the location name is and so on. I want to reduce the time by
clicking and waiting the Geoserver to refresh for every layer that it’s go.
Do you have any tips on that? Kindly ask me again if my explanation is not
clear. Thanks.
regards,
Azzmy
Azzmy wrote:
Hi Justin,
Sorry to make you confuse with my problem. Anyway, thanks for the reply.
The real story behind the issue is like this. There will be two separate
systems. One is called “call card system” that will receive all the
information regarding the incident and another one is dispatcher system
(we’re using TCAD300(TETRA computer aided dispatcher)). Call card system
will capture the information includes name, incident id, location name,
and positions. All these will restore in MySQL. TCAD300 have one function
to display map and it’s integrate with geoserver. I’m thinking to work
with geoserver to plot the position on the dispatcher (on map viewer). I
can say the plotting is a real time plotting. When new record comes in,
then it will automatically plot on the map. I don’t have any rights to
work around with TCAD 300 using it's source code. So,I am thinking to
start with geoserver to handle this situation. Is it possible for me to
follow your idea in order to resolve this matter? Or maybe there’s other
way that I can work with geoserver to resolve it? I need to know how far
geoserver can work to make it’s happen. Really appreciate on your help.
Thanks.
regards,
Azzmy
Justin Deoliveira-4 wrote:
Cool, Thanks Andrea,
So Azzmy, this should probably work for you. Are you familiar with
setting up SLD styles in GeoServer?
-Justin
Andrea Aime wrote:
Justin Deoliveira ha scritto:
Hi Azzmy,
I am still a little confused about how your are getting the data into
GeoServer? Are you using the mysql datastore extension?
Regardless, you may be able to do this with a label in an SLD. Andrea
(CC'd) should know for sure.
Andrea: Do you know if this is possible in SLD? Doing a label which is
made up of multple attributes?
Yeah, labels do support mixed syntax, meaning that you can mix in the
same parent element text and subelements freely:
<Label><ogc:PropertyName>PROP_A</ogc:PropertyName> some text
<ogc:PropertyName>PROP_B</ogc:PropertyName></Label>
should render fine.
Let me know if it does not.
Cheers
Andrea
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,4863a5a098811096210785!
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hi Justin,
My previous problem is already solved and thanks to you on your tips. I’ve
another question, whenever the map received the new point, I would like to
make sure the map will 'zoom in' to the direct point. Right now, when the
new point comes in, I have to clicking on the point to go deeper and deeper
to know what the location name is and so on. I want to reduce the time by
clicking and waiting the Geoserver to refresh for every layer that it’s go.
Do you have any tips on that? Kindly ask me again if my explanation is not
clear. Thanks.
Hi Justin,
My previous problem is already solved and thanks to you on your tips. I’ve
another question, whenever the map received the new point, I would like to
make sure the map will 'zoom in' to the direct point. Right now, when the
new point comes in, I have to clicking on the point to go deeper and deeper
to know what the location name is and so on. I want to reduce the time by
clicking and waiting the Geoserver to refresh for every layer that it’s go.
Do you have any tips on that? Kindly ask me again if my explanation is not
clear. Thanks.
regards,
Azzmy
Azzmy wrote:
Hi Justin,
Sorry to make you confuse with my problem. Anyway, thanks for the reply.
The real story behind the issue is like this. There will be two separate
systems. One is called “call card system” that will receive all the
information regarding the incident and another one is dispatcher system
(we’re using TCAD300(TETRA computer aided dispatcher)). Call card system
will capture the information includes name, incident id, location name,
and positions. All these will restore in MySQL. TCAD300 have one function
to display map and it’s integrate with geoserver. I’m thinking to work
with geoserver to plot the position on the dispatcher (on map viewer). I
can say the plotting is a real time plotting. When new record comes in,
then it will automatically plot on the map. I don’t have any rights to
work around with TCAD 300 using it's source code. So,I am thinking to
start with geoserver to handle this situation. Is it possible for me to
follow your idea in order to resolve this matter? Or maybe there’s other
way that I can work with geoserver to resolve it? I need to know how far
geoserver can work to make it’s happen. Really appreciate on your help.
Thanks.
regards,
Azzmy
Justin Deoliveira-4 wrote:
Cool, Thanks Andrea,
So Azzmy, this should probably work for you. Are you familiar with setting up SLD styles in GeoServer?
-Justin
Andrea Aime wrote:
Justin Deoliveira ha scritto:
Hi Azzmy,
I am still a little confused about how your are getting the data into GeoServer? Are you using the mysql datastore extension?
Regardless, you may be able to do this with a label in an SLD. Andrea (CC'd) should know for sure.
Andrea: Do you know if this is possible in SLD? Doing a label which is made up of multple attributes?
Yeah, labels do support mixed syntax, meaning that you can mix in the
same parent element text and subelements freely:
<Label><ogc:PropertyName>PROP_A</ogc:PropertyName> some text <ogc:PropertyName>PROP_B</ogc:PropertyName></Label>
should render fine.
Let me know if it does not.
Cheers
Andrea
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users