[Geoserver-users] Newbie question

Alvaro_Gutierrez · February 23, 2006, 4:10pm

Hi everyone.
I know that this is a very generalist question, but i'm going crazy trying to get a solution for this. To finish my studies i'm trying to do an application for keeping keep track of where the vehicle is at any given moment.. Besides you could plan a route between two streets.
i've been playing with MapServer, GeoServer, MapBuilder,... but i don't know very well if these tools are enough for this task.
Some suggestions please.

Thanks.

Alexander_Petkov · February 23, 2006, 4:21pm

To finish my studies i'm trying to do
an application for keeping keep track of where the vehicle is at any
given moment..

Is that real time data? I can't see right away how that can be
accomplished in real time.

Besides you could plan a route between two streets.

This one is interesting. Maybe possible routes can be returned from a
rule set in an SLD file.

Alex

Carolyn_Cole · February 23, 2006, 4:40pm

We are plotting real time data by storing it in a mysql table and using SLD to filter it.

You can define your mysql database as a geoserver store, and then define a feature type for the table that would contain your real time data.

Then you could periodically query geoserever for the feature type.

At 11:21 AM 2/23/2006, Alexander Petkov wrote:

>To finish my studies i'm trying to do
> an application for keeping keep track of where the vehicle is at any
> given moment..
Is that real time data? I can't see right away how that can be
accomplished in real time.

>Besides you could plan a route between two streets.
This one is interesting. Maybe possible routes can be returned from a
rule set in an SLD file.

Alex
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÓ+ó^µéX¬²'²Þu¼±<Âÿj
èºw[æ¤x,r¸©¶)à©à¹¨¶{^Û¦bq«b¢{"Ú0y¶§vjW¦yØümzwméb½ìmÆ¬µ©Ý§¶©®)uëÞ^®
èºëy©"§¶aÉÞÁÊx-zºâ¶òþm§ÿÿ±éÿjÏî³÷ÚF þwþÇ¥ýÉþH÷ÿn'Û{ÛOÝjÛ^¸Ûÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿê,z»Þ¯û¬z»&j)b b²Ñ¢Ç«½êÿºÇ«³ùb²Ûÿ²«qçè®ÿëa¶ÚlÿÿåËlþÊ.Ç¢¸þwþX¬¶ÏåËbú?ê,z»Þ¯û¬

Carolyn_Cole · February 23, 2006, 5:18pm

I can point you in the direction I went, but it may not be the way you want to go based on your experience.

We have a java program using JDBC on the back end feeding the data to the mysql table. I have no idea how to capture GPS positions, but once you have them you just need to do an insert into the table. GeoServer will pick up the data and plot it if it has a point field.

My table create script is:
create table eventresults (
userID VARCHAR(64) not null,
configName VARCHAR(64) not null,
location POINT not null,
) TYPE =MyISAM;
The two important things to note are the POINT column and the fact that the table is of Type MyISAM. The MyISAM thing was a bit hard to track down.

The you will want to insert points into the DB using SQL that looks a bit like:
insert into eventResults (userID, configName, location)
values ( ‘user’, ‘config’, GeomFromText('POINT(-80, 120));

I have no idea how to input a detailed base map. We use a really simplistic shape file.

As for the periodic update you can use many things, but the siplest is using the HTML refresh parameter.