Go to documentation repository

Page tree

Documentation for Auto Intellect 5.5. Documentation for other versions of Intellect is available too.

Previous page Setting up replication on the subscriber server  Appendix 5. Setting up the External plates database in «dbf» format. Next page

Skip to end of metadata
Go to start of metadata

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 –Intellect database and this software interaction follow the procedures:

  1. 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_idintType 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_timedatetimeTime of red light switching on
    red_light_on_periodintTime from begin of red phase to fixing violation on the image.Time  is specified in seconds.
  2. 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.

  3. 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

    IduniqueidentifierSecondary frame ID
    Frames_iduniqueidentifierPrimary frame ID
    frameimageSecondary frame
    timedatetimeTime of the secondary frame recording on UTC scale
  4. 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

    platenvarchar(50)Vehicle license plate
    regionintRegion of license plate
    validityintQuality of recognized LP, 0-100%
    timedatetimeTime of license plate recording on UTC scale
  5. 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, // время по (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 Intellect software.

    Fields described in the table will be returned in result of the spGetRegisteredPlatesFull procedure performing.

    Name

    Type

    Description

    platenvarchar(50)Vehicle license plate
    regionintRegion of license plate
    validityintQuality of recognized LP, 0-100%
    plate_leftintLP coordinates
    plate_topintLP coordinates
    plate_rightintLP coordinates
    plate_bottomintLP coordinates
    preview_frameimageFrame for preview
    frameimageFrame
    plate_imageimageImage of cut license plate
    detector_external_idnvarchar(max)Recognizer ID in the Intellect tree
    detector_namenvarchar(50)Name of recognizer
    detector_addressnvarchar(max)Address of recognizer
    camera_external_idnvarchar(max)Camera ID in the Intellect tree
    camera_namenvarchar(50)Name of camera
    timedatetimeTime of license plate recording on UTC scale