OpenALPR Tool - Save and Query CSV Exports

Joined
Jul 13, 2019
Messages
12
Reaction score
1
Location
Pickerington, OH
I am getting the error when opening up the viewer.

1668127127374.png

It does open up but just getting this error.
 

VideoDad

Pulling my weight
Joined
Apr 13, 2022
Messages
157
Reaction score
208
Location
USA
I apologize if this is answered somewhere in this thread, but I'm wondering if this database and viewer can be used locally, independent of an OpenALPR / Rekor Scout subscription.

I was hoping there was someway to feed a BI plate recognition into this utility directly, check for repeats, etc. and then send alerts only if the plate is new, or if it is in a watch list, etc. without that recognition having to be done by OpenALPR.

In my case, I'm using PlateRecognizer since I see fewer than 2500 plates a month. Others are starting to use @MikeLud1 's ALPR module. In both cases, it would be nice to be able to decouple the recognition so that you could then feed the plate into this utility for storage, alerting, historical data, editing, notes, etc.

Anyone know if this is presently possible? Or if not, what might be involved in getting this capability in place? I just think it could be mighty helpful.
 

wittaj

IPCT Contributor
Joined
Apr 28, 2019
Messages
24,428
Reaction score
47,549
Location
USA
I apologize if this is answered somewhere in this thread, but I'm wondering if this database and viewer can be used locally, independent of an OpenALPR / Rekor Scout subscription.

I was hoping there was someway to feed a BI plate recognition into this utility directly, check for repeats, etc. and then send alerts only if the plate is new, or if it is in a watch list, etc. without that recognition having to be done by OpenALPR.

In my case, I'm using PlateRecognizer since I see fewer than 2500 plates a month. Others are starting to use @MikeLud1 's ALPR module. In both cases, it would be nice to be able to decouple the recognition so that you could then feed the plate into this utility for storage, alerting, historical data, editing, notes, etc.

Anyone know if this is presently possible? Or if not, what might be involved in getting this capability in place? I just think it could be mighty helpful.
No it does not. This was designed around scraping the OpenALPR data.

It would take the original creator to modify the code to be able to scrape the data from BI (which he really doesn't have an incentive to do unless he decides to use something different) or it would take someone with an understanding of code to be able to rewrite the relevant sections in order to be able to scrape that data from the BI log files.

Those of us that had a role in the development of this (my role was very little and I don't take credit LOL as my role simply involved finding a new place to get VIN info long after the code was written) have talked about it, but the success rate at the moment of the BI ALPR and problems folks are having has not put a priority on moving away from what works.

If you look in the CodeProject ALPR thread there are a few people starting to develop similar things for that application.
 
Last edited:

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
What I like about the Rekor ALPR is that it works really well capturing plates and identifying different state license plates. The PlateRecognizer misses almost half of the plates on my street, and I understand that to improve the capture rate it would require some adjustments on the BI camera's settings. The number of plates which ALPR captures each month is beyond the free tier of the PlateRecognizer, and the first price point would be $50 a month.
 

VideoDad

Pulling my weight
Joined
Apr 13, 2022
Messages
157
Reaction score
208
Location
USA
What I like about the Rekor ALPR is that it works really well capturing plates and identifying different state license plates. The PlateRecognizer misses almost half of the plates on my street, and I understand that to improve the capture rate it would require some adjustments on the BI camera's settings. The number of plates which ALPR captures each month is beyond the free tier of the PlateRecognizer, and the first price point would be $50 a month.
I'm not discounting the capabilities of Rekor and the additional information it provides. If I had more and diverse traffic, I might opt for it.

I was just looking to decouple the recognition step from the insertion in a local database and whatever processing before alerting, thinking it could be a general solution that way.

1. Recognition via whatever automated method desired.
2. Look up in the database for previous sightings, whitelisted or blacklisted plates, near misses (eg. misrecognition correction), etc.
3. For new plates, insert to the database, perhaps supplemented with an online plate/vin lookup.
4. Decide if an alert should be sent.
5. Allow database viewing, filtering, editing, adding notes, etc.
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
Considering the PlateRecognizer (PR), as I understand, it only inserts an entry into the BI log file. It would be an easy task to open the log file and parse for these plates, and enter them into the database. Or if the need was just to collect unique plates then to look up for the plate and insert if it is new. Part of the usefulness of the existing tool is to quantify plate hits to see trends.

Even so, with ALPR there's a photo which can easily be acquired, copied and referenced within the local database. With PR, I don't see an easy way to acquire an image. Is there?
 

VideoDad

Pulling my weight
Joined
Apr 13, 2022
Messages
157
Reaction score
208
Location
USA
Considering the PlateRecognizer (PR), as I understand, it only inserts an entry into the BI log file. It would be an easy task to open the log file and parse for these plates, and enter them into the database. Or if the need was just to collect unique plates then to look up for the plate and insert if it is new. Part of the usefulness of the existing tool is to quantify plate hits to see trends.

Even so, with ALPR there's a photo which can easily be acquired, copied and referenced within the local database. With PR, I don't see an easy way to acquire an image. Is there?
Yes there are alert images. The idea was to make a call to save that image, the plate number, etc. and then use the database for quantifying plate hits, check trends, etc.

It seems like they are building something like this for @MikeLud1 's ALPR module using Node Red and MQTT calls. I'm looking at that but maybe there's something in this implementation that could be useful?
 

sixes6462

n3wb
Joined
Nov 17, 2022
Messages
5
Reaction score
1
Location
Atlanta, GA
Question can I input a license plate number that has never been read by my system to a status group so I can be notified when it hits?
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Question can I input a license plate number that has never been read by my system to a status group so I can be notified when it hits?
No Currently, There is no way that I can think of to do it through the GUI. However, you can write that number on a piece of paper with a Sharpie and flash it in front of the LPR camera. That will likely do the trick.
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
Doesn't the viewer allow for editing of a plate? Maybe pick a commonly-seen plate and edit just the one occurrence. Once the target plate is in the database then can it be tagged for special alerts?
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Doesn't the viewer allow for editing of a plate? Maybe pick a commonly-seen plate and edit just the one occurrence. Once the target plate is in the database then can it be tagged for special alerts?
Nice, Yes this can work. I have plenty of Company name from vehicles, which gets registered as a plate every now and then, can use one of those and edit it to the plate number as needed. Thank you so much Dlong for that idea !!
 

sixes6462

n3wb
Joined
Nov 17, 2022
Messages
5
Reaction score
1
Location
Atlanta, GA
Anyone know the code location for the daily license plate report and the license plate alert email. I would like to change the format up
 

riluxg

Getting the hang of it
Joined
Aug 1, 2015
Messages
63
Reaction score
26
Location
UK
Anyone know the code location for the daily license plate report and the license plate alert email. I would like to change the format up
I asked a similar question July last year but got no reply I don't think anybody knows. I'm not even sure that Gymratz is still supporting this program
 

wittaj

IPCT Contributor
Joined
Apr 28, 2019
Messages
24,428
Reaction score
47,549
Location
USA
Your best bet is if you know the program it was written in, go in and find it or find someone that does. I don't think Gymratz visits here much anymore and the program simply works for his needs.
 

riluxg

Getting the hang of it
Joined
Aug 1, 2015
Messages
63
Reaction score
26
Location
UK
Anyone know the code location for the daily license plate report and the license plate alert email. I would like to change the format up
The code for the daily licence plate report

line 1351 to 1380



private void EmailDailyReport_CollectInfo(string ReportBy)

{

DataTable PlateList;

String str_PlateState = dgv_Plates.SelectedRows[0].Cells["Region"].Value.ToString();

String str_DistinctDays = dgv_Plates.SelectedRows[0].Cells["Distinct Days"].Value.ToString();



PlateList = new DataTable();

PlateList.Columns.Add("LocalTime");

PlateList.Columns.Add("Plate");

PlateList.Columns.Add("State");

PlateList.Columns.Add("DistinctDays");

PlateList.Columns.Add("Year");

PlateList.Columns.Add("Make");

PlateList.Columns.Add("Model");

PlateList.Columns.Add("VIN");



for (int i = 0; i < dgv_Plates.Rows.Count; i++)

{

DataRow dataRow = PlateList.NewRow();

dataRow["LocalTime"] = dgv_Plates.Rows.Cells["Local Time"].Value.ToString();

dataRow["Plate"] = dgv_Plates.Rows.Cells["Plate"].Value.ToString();

dataRow["State"] = dgv_Plates.Rows.Cells["Region"].Value.ToString();

dataRow["DistinctDays"] = dgv_Plates.Rows.Cells["Distinct Days"].Value.ToString();

dataRow["Year"] = dgv_Plates.Rows.Cells["Yr"].Value.ToString();

dataRow["Make"] = dgv_Plates.Rows.Cells["Car Make"].Value.ToString();

dataRow["Model"] = dgv_Plates.Rows.Cells["Car Model"].Value.ToString();

dataRow["VIN"] = dgv_Plates.Rows.Cells["VIN"].Value.ToString();

PlateList.Rows.Add(dataRow);

}

If the state column is not working in the email.

line 1373 the Cells["Region"] needs to be changed from Region to Status
 
Top