2010/1/11 Smith Roman <[email protected]> > > 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 > [email protected] > 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/ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
