Creating the search query

On the page:

It is possible to form a search query:

By recognized vehicles (Search by vehicles tab);
By alarms (Search by alarms tab).

Creating the search query by recognized vehicles

To create the search query by recognized vehicles, do the following:

Go to the Search by vehicles tab.

In the Vehicle's license plate group:

From the Search operation list (1) select a logical construction, used for uniting several elements of the key phrase, which correspond to the LP numbers or their parts that are being searched:
- AND – for searching by numbers, containing all the elements of the key phrase;
- OR – for searching by numbers, containing at least one element of the key phrase.

In the (2) field, enter the key phrase. The elements of the key phrase can be separated by comma "," or semicolon ";".

Note

The key phrase may include usual characters and picture-characters in the required combination.

Picture-characters	Description of Picture-characters	Example of search query
%	Any string in length from zero and more characters	Search query a%385%78 returns LP numbers, containing the elements 'a', '385' and '78', divided by any number of characters, for example 'AO38578', 'a385mk78'
_ (underlining)	Any single character	Search query 2__5 returns LP numbers, containing the sequence of four characters, the first of which is '2', the last one is '5',for example, 'A256577', '2115OК43'
[]	Any single character within the range ([a-e]) or in the set ([abcde])	Search query [e-m][2-5]53 returns LP numbers, containing the sequence of four characters. The sequence ends in '53', the first character belongs to the range e-m, the second one belongs to the range 2-5, for example, 'k453mn02', 'm253bt63'
[^]	Any single character outside the range ([^a-e]) or the set ([^abcde])	Search query [^e-m]499 returns LP numbers, containing the sequence of four characters. The sequence ends in '499', the first character does not belong to the range e-m, for example 'b499bk57', 'n499578'

Set the License plate not recognized checkbox (3) if it is necessary to display all the numbers.
Note
Selection of the checkbox License plate not recognized is enabled only if the OR logical construction is selected in the Search operation drop-down list.
Set the Partly recognized checkbox if it is necessary to display partially recognized numbers (4).
Set the 'Space' in car number checkbox (5) if it is necessary to display the numbers that contain a space between the characters.
Set the Acceptable error amount check box (6) to display the numbers with the errors (character mismatches), the amount of which is indicated in the drop-down list.
From the Report type drop-down list (7) select the type of vehicle search:
1. Passes - standard search.
2. Escort vehicles - search for all vehicles that have been recorded near the specified vehicle within the time interval set in the Interval before/after, sec parameter.
In the Interval before/after, s field (8), specify the time in seconds within which it is necessary to to search for the vehicle.
Note
This parameter is available if Escort vehicles value is selected in the Report type drop-down list.
In the Min. number of occurrences field (9), specify the minimum number of vehicle records within the time set in the Interval before/after, sec parameter.
Note
This parameter is available if Escort vehicles value is selected in the Report type drop-down list.

In the Regional code group set the checkboxes for those regional codes events for which should be returned while being searched.
Attention!
Only those regional codes are displayed, the license plate of which has already been recognized earlier, since this information is received from the database of recognized license plates.
In the LP region group set the checkboxes for those regions, which events should be returned while being searched.
Attention!
Only those regions are displayed, the license plate of which has already been recognized earlier, since this information is received from the database of recognized license plates.
In the LP colors group select color of regional code and basic color of the license plate.
Attention!
Only those license plate colors are displayed, the license plate of which has already been recognized earlier, since this information is received from the database of recognized license plates.
In the Date/time group set the time range within which the required events have been registered. By default this range is not activated (checkboxes from and to are disabled). To activate it, set the checkboxes From and/or To and then click button and in the appeared calendar set the required date. Enter the required time in the field From and/or To. If only upper or bottom boundary is selected, the search query will return the events, registered before or after the set deadline correspondingly. To disable the search by date and time, uncheck From and To checkboxes.
In the Plate recognizers group set the checkboxes for those plate recognizers, which events are to be returned while being searched.
Information about objects removed from the Axxon PSIM software package is not displayed in the Plate recognizers group. Select Show deleted in the View menu of the Event search in the Recognizers DBs main window to search by removed servers of plate recognizers.
After this all removed servers of plate recognizers will be displayed in the Plate recognizers group. Set checkboxes for those plate recognizers which will be used while being searched.
In the External DB group set the checkboxes for those external databases, which events are to be returned while being searched.

The External database group contains a list of all the databases that have ever been used together with the Vehicle Tracer module but, by default, databases removed from the Axxon PSIM software package are not displayed in the list. Select the Show deleted in the View menu of Event search in the Recognizers DBs main window to search by removed servers of plate recognizers (see previous step). As a result, all external databases removed from the system will be displayed in the list. Set checkboxes for those databases which will be used while being searched.
From the list Registered speed select the required filter of vehicle speed and then in the activated field(s) enter the threshold value(s) of vehicle speed. The following speed filters are available:
- <not important> – events of the vehicle, moving with any speed will be returned.
- More – events of the vehicle, moving with a speed, exceeding a single threshold value, will be returned.
- Less – events of the vehicle, moving with a speed, not exceeding a single threshold value, will be returned.
- Interval – events of the vehicle, moving with a speed, belonging to a single entered threshold value, will be returned.
From the Direction list select the required filter concerning the direction of the vehicle. The following direction filters are available:
- <no matter> – events of the vehicle, moving in any direction concerning the LP recognizer's camera will be returned.
- Undefined – events of the vehicle, which direction could not be defined, will be returned.
- From the camera – events of the vehicle, moving away from the LP recognizer's camera will be returned.
- To the camera – events of the vehicle, moving towards the LP recognizer's camera will be returned.
- To the right – events of the vehicle, moving to the right of the LP recognizer's camera will be returned.
- To the left – events of the vehicle, moving to the left of the LP recognizer's camera will be returned.
In the Countries group set the checkbox for the country, which events should be returned while being searched.
Attention!
Only those countries are displayed, the license plate of which has already been recognized earlier, since this information is received from the database of recognized license plates.
In the Comment group:
1. From the Search operation list (1) select a logical construction, used for uniting several elements of the key phrase, corresponding to the comments, that are being searched:
  - AND – for searching by comments, containing all the elements of the key phrase;
  - OR – for searching by comments, containing at least one element of the key phrase.
2. In the field (2) enter the key phrase, containing one or several comma separated elements, corresponding to the comments to the events, which are being searched, and which were specified in the Online monitor window (see Adding comments to the events).
3. Set the Empty comment checkbox (3) to include the uncommented events in the search.
  Note
  This parameter is available if the OR logical construction is selected in the Search operation drop-down list.
4. Set the Non-empty comment checkbox (4) to include only the commented events in the search.
From the Validity list select the required validity filter and then enter the threshold of validity values in percent. The following validity filters are available:
- <not important> – events of the vehicle, which numbers have been recognized with any validity.
- More – events of the vehicle, which numbers have been recognized with validity, exceeding the entered threshold value in percent.
- Less – events of the vehicle, which numbers have been recognized with validity, not exceeding the entered threshold value in percent.
- Interval – events of the vehicle, which numbers have been recognized with validity, belonging to the entered threshold value in percent.
In the Recognition cameras field set the checkboxes for the cameras, which events should be returned while being searched.

To clear the Search by vehicles tab from the entered search, click the Reset button.

Creating the search query by alarms

To create the search query by alarms, do the following:

Go to the Search by alarms tab.
Repeat steps 2-8 of the Creating the search query by recognized vehicles section as applied to interface elements of the tab Search by alarms.
From the Permitted speed list select the required speed filter, permitted on the controlled road area and then enter the threshold speed values in km/h. The following filters of the permitted speed are available:
- <not important> – events of the vehicle, registered on the road area with any permitted speed will be returned.
- More – events of the vehicle, registered on the road area with any permitted speed, exceeding the entered threshold value will be returned.
- Less – events of the vehicle, registered on the road area with any permitted speed, not exceeding the entered threshold value will be returned.
- Interval – events of the vehicle, registered on the road area with any permitted speed, that belong to the entered threshold value range will be returned.
From the list Alarm handling delay, sec select the required filter according to the alarm handling delay and then in the activated field(s) enter the threshold value(s) of delay time in seconds. The following filters of alarm handling delay are available:
- <not important> – alarms, accepted in any time after being registered or unaccepted at all.
- More – alarms will be returned, accepted with a delay, exceeding the entered threshold value.
- Less – alarms will be returned, accepted with a delay, not exceeding the entered threshold value.
- Interval – alarms will be returned, accepted with a delay, belonging to the entered threshold value.
From the list Alarm processed select the required filter according to the alarm processing factor:
- <not important> — both processed and unprocessed events will be returned.
- Alarm is not processed — only unprocessed events will be returned.
- Alarm processed — only processed events will be returned.
In the Alarm accepted by group, set the checkboxes for the operators who received the alarm events to display these events in the search query.
Note
This parameter is available if the <not important> or Alarm processed value is selected in the Alarm processed list (see above).
In the Alarm type group, set the checkboxes for the alarms, which should be returned in results of search query:
- Stop over stop line — events will be returned for which stopping over the stop line at the stoplight has been registered.
- Entered the oncoming lane — events will be returned for which entering the oncoming lane has been registered.
- Parking violation — events will be returned for which the violation of parking rules has been registered.
- Marking rules violation — events will be returned for which the violation of marking rules has been registered.
- LP found in database — events will be returned which plates have been found in the external database.
- Stop over crosswalk line - events will be returned for which stopping over the crosswalk line at the stoplight has been registered.
- Overspeeding — events will be returned for which overspeeding has been registered.
- Running a red light — events will be returned for which running a red light has been registered.
- Running a red light at crossroads — events will be returned for which running a red light at crossroads has been registered.
- Alarm is set by operator — manually triggered alarms will be returned.
In the Comment from external DB group:
1. From the Search operation list (1), select the logical construct which is used to combine several elements of the key phrase, that correspond to the comments to the events to be searched in external databases:
  - AND - to search for comments that contain all the elements of the key phrase;
  - OR - to search for comments that contain at least one element of the key phrase.
2. In the field (2), enter a key phrase consisting of one or more elements, separated by commas, that correspond to the comments to the events to be searched in external databases that are specified in the External DB group (see Creating the Active tracking database).
From the Speeding list select the required speeding filter and then enter the threshold values of speeding in km/h. The following filters of the speeding are available:
- <not important> – events of the vehicle, moving with any overspeeding or with the absence of it will be returned.
- More – events of the vehicle, moving with overspeeding, exceeding the entered threshold value will be returned.
- Less – events of the vehicle, moving with overspeeding, less than the entered threshold value will be returned.
- Interval – events of the vehicle, moving with overspeeding, in the entered range of threshold values, will be returned.
  Note.
  - This parameter is available if the checkbox Speeding is set in the Alarm type group.
  - The value of speeding is calculated as a difference between the fixed vehicle speed and the speed, permitted on the controlled area of the road.
From the Red light shows at, sec list select the required filter for red light start and then in the activated field(s) enter the threshold value(s) in seconds. The following filters of the running a red light are available:
- <not important> – events of the vehicle, which violated a red light, will be returned.
- More – events of the vehicle, which violated a red light after the entered threshold value will be returned.
- Less – events of the vehicle, which violated a red light before the entered threshold value will be returned.
- Interval – events of the vehicle, which violated a red light within the entered range of threshold values, will be returned.
  Note
  This parameter is available if the Running a red light checkbox is set in the Alarm type group.
In the Alarm initiated by field select the required operators who initiated the alarm. The corresponding alarms will be shown in the search results.
Note
This parameter is available if the Alarm is set by operator checkbox is set in the Alarm type group.

To clear the Search by alarms tab from the entered search, click the Reset button.

Query launching

After forming the search query by vehicles or by alarms, launch its processing by clicking the Find button.

As a result, a table of search results will be displayed that match the entered conditions:

If the Escort vehicles report type was selected, the search results table will look like this:

Page tree

Documentation for Auto PSIM 1.0.1.

Creating the search query by recognized vehicles

Creating the search query by alarms