Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

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

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

 

 

 

 

 

 

 

 

 

 

 

 

Note

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

 

 

  • No labels