Go to documentation repository
Documentation for Auto PSIM 1.0.1.
Previous page
Next page
The software for fine imposing is designed for analyzing the stored Traffic enforcement, for checking and correcting the identified plates, imposing the fines.
For the Auto PSIM database and this software interaction follow the procedures:
- The procedure, returning the alarm list of the stated type for a stated period of time for the selected detector or for all the detectors (if NULL).
spGetDetectionEvents
@eventtype int, // alarm's type
@begindate DATETIME, // time «from»
@enddate DATETIME, // time «up to»
@detector uniqueidentifier = NULL //detector's ID
@speed_over INT=NULL, // speed exceeding (only for Speed exceeding alarms type). Ignored if it is not specified.
@secondFrameExistINT=1, // display events (only for Red light running alarms type), which have additional frame. Check for additional frame is not performed if 0 or NULL.
The following alarm types are singled out:
1 – Overspeeding,
2 – Found in the external database,
3 – Alarm, triggered by the operator,
4 – Running a red light,
5 – Entered the oncoming lane,
6 – Crossing a stop line,
7 – Stop a crosswalk,
8 – Running a red light traffic.
Fields described in the table will be returned in result of the spGetDetectionEvents procedure performing.
Name
Type
Description
event_time
datetime
Time of alarm
event_time_id int Type of alarm valid_speed
Int
Permitted speed
speed
Int
Speed
speed_over
int
Overspeeding
car_number
nvarchar(50)
Licence plate
address
nvarchar(max)
Address, where the detector is located
direction
bit
Direction
processing_time
datetime
Time of alarm's processing by the operator
comments
ntext
Comments
db_name
nvarchar(50)
External database name
db_info
ntext
Information from the external database (XML format)
operator
uniqueidentifier
Operator's ID
frame
image
Frame
event_id
uniqueidentifier
Unique alarm identifier (GUID)
red_light_on_time datetime Time of red light switching on red_light_on_period int Time from begin of red phase to fixing violation on the image.Time is specified in seconds Procedure, returning the list of speed alarms for a stated period for the selected detector or for all the detectors (if NULL).
spGetSpeedEvents
@begindate DATETIME, // time «from»
@enddate DATETIME, // time «up to»
@detector uniqueidentifier = NULL // detector's ID
@speed_overINT=NULL // speed exceeding. Ignored if it is not specified.
Fields described in the table will be returned in result of the spGetSpeedEvents procedure performing.
- Procedure, returning synchronous frames connected with event ID or all frames if parameter @event_id=NULL.
spGetFramesSecondary
@max_items int, // maximal number of output frames
@event_id uniqueidentifier // event ID. Event ID can be got using the spGetDetectionEvents or spGetSpeedEvents procedures.
Fields described in the table will be returned in result of the spGetSpeedEvents procedure performing.
Name
Type
Description
Id uniqueidentifier Secondary frame ID Frames_id uniqueidentifier Primary frame ID frame image Secondary frame time datetime Time of the secondary frame recording on UTC scale - Procedure returning all registered license plates for the specified period. Data will be displayed page-by-page with specifying the page number (@pagenumber) and page size (@pagesize).
spGetRegisteredPlates
@begindate datetime, // time "from" (on UTC scale)
@enddate datetime, // time "up to" (on UTC scale)
@pagenumber int, // page number to output
@pagesize int, // page size to output
@totalrows int OUTPUT, // total number of strings complying with query
Fields described in the table will be returned in result of the spGetRegisteredPlates procedure performing.
Name
Type
Description
plate nvarchar(50) Vehicle license plate region int Region of license plate validity int Quality of recognized LP, 0-100% time datetime Time of license plate recording on UTC scale Procedure returning all registered license plates for the specified period. Data will be displayed page-by-page with specifying the page number (@pagenumber) and page size (@pagesize).
spGetRegisteredPlatesFull
@begindate datetime, // time "from" (on UTC scale)
@enddate datetime, // time "until" (on UTC scale)
@pagenumber int, // page number to output
@pagesize int, // page size to output
@totalrows int OUTPUT, // total number of strings complying with query
@cameraIds nvarchar(max) NULL, // list of cameras ID separated by | symbol in the Axxon PSIM software.
Fields described in the table will be returned in result of the spGetRegisteredPlatesFull procedure performing.
Name
Type
Description
plate nvarchar(50) Vehicle license plate region int Region of license plate validity int Quality of recognized LP, 0-100% plate_left int LP coordinates plate_top int LP coordinates plate_right int LP coordinates plate_bottom int LP coordinates preview_frame image Frame for preview frame image Frame plate_image image Image of cut license plate detector_external_id nvarchar(max) Recognizer ID in the Axxon PSIM tree detector_name nvarchar(50) Name of recognizer detector_address nvarchar(max) Address of recognizer camera_external_id nvarchar(max) Camera ID in the Axxon PSIM tree camera_name nvarchar(50) Name of camera time datetime Time of license plate recording on UTC scale
Overview
Content Tools