OpenALPR Tool - Save and Query CSV Exports

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
I wonder how hard will it be to Say Fingerprint these Car pics .. and than a system will automatically start tagging say if the plate was changed.. Like say take Those wheel, color of the car and than that bit of dent under tail light into account ..

A software which can do that lol that be Epic :p
 

IReallyLikePizza2

Known around here
Joined
May 14, 2019
Messages
1,852
Reaction score
4,441
Location
Houston
I wonder how hard will it be to Say Fingerprint these Car pics .. and than a system will automatically start tagging say if the plate was changed.. Like say take Those wheel, color of the car and than that bit of dent under tail light into account ..

A software which can do that lol that be Epic :p
Yeah, that would be AWESOME
 

icpilot

Getting comfortable
Joined
Feb 1, 2018
Messages
293
Reaction score
394
Yes, I remember that!

Now is it possible you could send me some of the images day/night that you have?
Everyone has a different position on where the camera is and I just wanna see what I can work on.
I thought it might be useful to have some short clips of the captures and some which were missed. All clips are short, no more than 13 seconds and usually less than 10.

Here are a few successful captures:

View attachment NLPR.20211205_010000_1.mp4
View attachment NLPR.20211205_010000_2.mp4
View attachment NLPR.20211205_020014_1.mp4
View attachment NLPR.20211205_040000_1.mp4
View attachment NLPR.20211205_060000_1.mp4
View attachment NLPR.20211205_070000_1.mp4




















































And here are some clips showing missed captures:

View attachment NLPR.20211205_094438_1.mp4
View attachment NLPR.20211205_100000_1.mp4
View attachment NLPR.20211205_100000_2.mp4
View attachment NLPR.20211205_100000_3.mp4
View attachment NLPR.20211205_040000_1.mp4
View attachment NLPR.20211205_040000_2.mp4



















































And finally, some pics showing different angles of good captures:

7BRB302.jpeg

75NLHBWYCPQ3CKLP6H87RJ52P8RQ850IJV4PHAPQ-2088548415-1638727508549.jpg

75NLHBWYCPQ3CKLP6H87RJ52P8RQ850IJV4PHAPQ-2088548415-1638727521828.jpg

BDZ6300.jpeg

BNP4603.jpeg

CRN5360.jpeg

DAVES.jpeg

FITCPA.jpeg

G8A4JE.jpeg

GINOV.jpeg

STDP33.jpeg




I hope these help. Lots more if you want them.
 
Joined
Sep 24, 2021
Messages
10
Reaction score
6
Location
New Jersey
I thought it might be useful to have some short clips of the captures and some which were missed. All clips are short, no more than 13 seconds and usually less than 10.

Here are a few successful captures:

View attachment 110919
View attachment 110920
View attachment 110921
View attachment 110922
View attachment 110923
View attachment 110924




















































And here are some clips showing missed captures:

View attachment 110927
View attachment 110928
View attachment 110929
View attachment 110930
View attachment 110925
View attachment 110926



















































And finally, some pics showing different angles of good captures:

View attachment 110932

View attachment 110933

View attachment 110934

View attachment 110935

View attachment 110936

View attachment 110937

View attachment 110938

View attachment 110939

View attachment 110940

View attachment 110941

View attachment 110942




I hope these help. Lots more if you want them.
Awesome, this is perfect!

Now the question is, do I look more into a application you tie in your camera too? or am I just working to capture the license plate from images/videos?
 

wittaj

IPCT Contributor
Joined
Apr 28, 2019
Messages
24,438
Reaction score
47,562
Location
USA
Awesome, this is perfect!

Now the question is, do I look more into a application you tie in your camera too? or am I just working to capture the license plate from images/videos?
I guess at this point folks would be just looking for something that works and is cheaper than Rekor or Plate Recognizer.

I was thinking that between Deepstack and some program to read text, it might be doable. Folks here have created a custom deepstack model based on their field of view to take a picture when the plate is in view and draw a box around the plate. Once that image is taken and not trying to be analyzed real time going 45mph, maybe a text reader could read the plates if the picture is provided to it with the plate delineated in a box?

In addition to all the attempts at LPR out on GitHub, I believe that Amazon's Recognition has this ability to read plates as well, so maybe your purchasing power could make that cost-effective?
 

riluxg

Getting the hang of it
Joined
Aug 1, 2015
Messages
63
Reaction score
26
Location
UK
when I run view master I get unhandled exception has occurred in your application
procedure or function sp_LPR_AllPlates has too many arguments specified

i have done a new install on a different computer and still get the same error as above, also the downloader is not working i think it has something to do with the times line 505 and 509 in the downloader code

str_UTC_Offset = "%2b" + str_UTC_Offset;
}


string _url = "" + str_StartDate + "T" + str_StartHours + "%3A" + str_StartMinutes + "%3A00" + str_UTC_Offset + "%3A00&end=" + str_EndDate + "T" + str_EndHours + "%3A" + str_EndMinutes + "%3A59" + str_UTC_Offset + "%3A00&order=desc&format=csv";
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
when I run view master I get unhandled exception has occurred in your application
procedure or function sp_LPR_AllPlates has too many arguments specified

i have done a new install on a different computer and still get the same error as above, also the downloader is not working i think it has something to do with the times line 505 and 509 in the downloader code

str_UTC_Offset = "%2b" + str_UTC_Offset;
}


string _url = "" + str_StartDate + "T" + str_StartHours + "%3A" + str_StartMinutes + "%3A00" + str_UTC_Offset + "%3A00&end=" + str_EndDate + "T" + str_EndHours + "%3A" + str_EndMinutes + "%3A59" + str_UTC_Offset + "%3A00&order=desc&format=csv";
Curious what time zone you are in, or if your PC has an unusual date and time format?
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
i am in the uk
Within your OpenALPR CSV files, each record's row has two time stamps. This is how mine looks:

epoch_time_end
2021-12-26T11:56:11.920Z

Yours should be similarly structured. Being in the UK, each of your records should be showing the true time, as epoch time is based on GMT. In my case, the epoch time is ahead of me by 8 hours, and Gym's code has to do a conversion based on the PC's local time.

Your CSV's epoch time is structured the same and shows the true local time already?
 

riluxg

Getting the hang of it
Joined
Aug 1, 2015
Messages
63
Reaction score
26
Location
UK
Within your OpenALPR CSV files, each record's row has two time stamps. This is how mine looks:

epoch_time_end
2021-12-26T11:56:11.920Z

Yours should be similarly structured. Being in the UK, each of your records should be showing the true time, as epoch time is based on GMT. In my case, the epoch time is ahead of me by 8 hours, and Gym's code has to do a conversion based on the PC's local time.

Your CSV's epoch time is structured the same and shows the true local time already?
The epoch time on the csv file is good
but download manager will not down load
If i change time on computer to utc -01.00 download manager works
 

archedraft

Getting the hang of it
Joined
Sep 11, 2018
Messages
138
Reaction score
91
Location
USA
Looking for some guidance on the Pushover notifications. I created an account and then downloaded the iOS app. I created an API key for the LPR Downloader and put that key in the Token section in settings. I put my pushover user key in the User section in settings. If I make up a fake license plate number and click test, the application fails. If I put in a real one from a car that just passed my house and click test, nothing happens. I don't get a pop up on my phone. Am I doing something wrong with the test box? Do I have to install the pushover desktop app in order for the notification to get sent? I tested sending a notification from the pushover webpage to my phone and the notification went off, so I think that piece is setup correctly.

EDIT:
Apparently, I have push setup correctly, the test button just doesn't do anything (at least on my machine) or I don't understand what I am supposed to enter in the text box before I click test... I set my car to alert me via push and it did today.
 
Last edited:

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
Apparently, I have push setup correctly, the test button just doesn't do anything (at least on my machine) or I don't understand what I am supposed to enter in the text box before I click test... I set my car to alert me via push and it did today.
Hmmm. Does the Push notifications work okay from their pushover.net website? I believe they have a way to test the feature there. Also, you don't need to install their app on the local machine in order to leverage PushOver.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Looking for some guidance on the Pushover notifications. I created an account and then downloaded the iOS app. I created an API key for the LPR Downloader and put that key in the Token section in settings. I put my pushover user key in the User section in settings. If I make up a fake license plate number and click test, the application fails. If I put in a real one from a car that just passed my house and click test, nothing happens. I don't get a pop up on my phone. Am I doing something wrong with the test box? Do I have to install the pushover desktop app in order for the notification to get sent? I tested sending a notification from the pushover webpage to my phone and the notification went off, so I think that piece is setup correctly.

EDIT:
Apparently, I have push setup correctly, the test button just doesn't do anything (at least on my machine) or I don't understand what I am supposed to enter in the text box before I click test... I set my car to alert me via push and it did today.
I have Just now added the guide on the PDF walk thru post on how to configure the Pushover with this tool.

 

riluxg

Getting the hang of it
Joined
Aug 1, 2015
Messages
63
Reaction score
26
Location
UK
I tried fix entry and it changed all my 29,595 plates to the reg i tryed to fix any idea how to get my plate info back
 

Attachments

Top