[postgis-users] Postgis db for vehicle tracking ?

[Brian Modra]

2010/1/11 Smith Roman <autisi at yahoo.com>
>
> Hi everyone,
> I intend developing a vehicle tracking system with post gis as back end. The database will have a road layer,
> poi layer and a layer to represent moving vehicles whose objects change in real time. Two applications will
> be developed for the system. The first application will update the locations of vehicles in real time,
> the second app will be web based and having viewing and routing capabilities. My questions are as follows
> 1. Which jdbc code is best to do the updates ? eg  plain postgis jdbc, geotools, hibernate spatial etc

I've developed a Vehicle tracking system using PostGIS.
The issue you will come up against is that to get the logged positions
into the tables, you should really create the WKB format yourself,
which I did using C++, but you could equally as well use Java, and
there may be some libs already for this.
But you don't want to use WKT format, as that will be inefficient.
Mine receives the coords in x,y,z coords, and converts this to
lat/long/height in the server before writing to the database. I store
lat/long in a linestring, and an array of heights for the logs. I use
a number of tables at different time-based resolutions... so that
quick "zoomed out" retrievals are possible.

> 2. My application is expected to also have routing capabilities. This means that I will have to use pgrouting.
> Which jdbc code is best suited for this ?

We wrote our own routing before pgrouting came available, but I
suspect its just plain SQL.

> I intend using geomajas to develop the web based front end.
> Thanks,
> Roman.
> Smith.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



--
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/