We are looking for a simple windows application that calculates the amount of time spent in a given area or set of areas. The application will take two input files, and analyse the data in the second file to calculate the length of time spent within a given area, or set of areas, as defined by the first file. The application will create a csv output file that details the instances of presence within the defined area/s.
Area definition file: A KML file will be used to define an area or areas. The <LinearRing> element will define a given polygon, within a <Placemark>.
[url removed, login to view],33.6282509714184,0 [url removed, login to view],33.62668612164413</coordinates>
Data file: A CSV will contain tracking information, with defined points (WGS-84), grouped into tracks. Each track will need to be analyzed to determine how much time has been spent within the area/s defined above. A sample file is attached. There are many redundant fields.
A csv will be created that will list the instances of tracks occurring within the defined areas. For each instance where a track goes within the area, a line will list the following fields:
Track number, DateTime of entry, DateTime of exit, Total time in area, Name of Area, Average Speed, Speed of Zero (Boolean)
Track number: Taken from the CSV input file
DateTime of entry: Taken from the CSV input file (the first point within a given area) (use local time)
DateTime of exit: Taken from the CSV input file (the first point not within the area that was previously occupied) (use local time)
Total time in area: Difference between the entry and exit times (must be able to handle a transition from one day to the next)
Name of Area: Taken from the KML file
Average Speed: numerical average of 'speed values' from points within the area, including the entry point and exit point
Speed of Zero (Boolean): True if any speed value < 5, otherwise false
The time of entry is assumed to be the first point inside the area
The time of exit is assumed to be the first point outside the area
The application needs to have a simple UI with the ability to load the kml file, then select the csv to process, and then prompt the user once analysis is complete to save the output csv file.
We require source code.
Escrow payment, but one only payment at the end once we're happy with result.