Versions Compared

Version Old Version 1 New Version 2
Changes made by

Inna Kabanova (Unlicensed)

Inna Kabanova (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To obtain meta data from VIT LPR database, use the following functions: itv_plate_attr_get_ex() and itv_plate_attr_get().

Table of Contents

itv_plate_attr_get_ex()

Searches records by the specified time range. Does not change the records being exported. 

Syntax

SELECT * FROM dbo.itv_plate_attr_get_ex (
@plate NVARCHAR(16),
@from_ts DATETIME,
@to_ts DATETIME,
@image nvarchar(8)
);

Input arguments

ParameterDescription
platelicense number ( * is for "any" number)
from_ts"from" date&time; NULL can be used to not specify the "from" date&time
to_ts"to" date&time; NULL can be used to not specify the "to" date&time
image

image type:

  • "FRAME" —
  • "AUTO" —
  • "PLATE" —
  • NULL —

Returned data

ParameterDescription
[GUID] UNIQUEIDENTIFIER 
[TIME] DATETIME 
[LPR_ID] NVARCHAR(50) 
[PLATE] NVARCHAR(50)

 

[frame] NVARCHAR(450) 
[auto_img] NVARCHAR(450) 
[plate_img] NVARCHAR(450) 
[framedata] VARBINARY(MAX) 
[hash] XML 

Example

 

 

 

 

 

 

 

 

 

 

 

 

Info
titleNote

This article implies that the reader has the basic SQL knowledge.