OpenALPR Advice?

nhs128

Young grasshopper
Joined
Jul 8, 2017
Messages
91
Reaction score
21
When you say beanstalked data, are you just referring to the local db file? Or what specifically?
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
118
Reaction score
23
Location
92679
NM, apparently it requires a license key as well, it didn't say that in the application, it says it online.....seems the CSV is the work around for free....
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
Yes, I was in the same boat, having to manually pull the csv file every day, and it became tedious to do. With the help of a whizz here in the forum, now the whole process is automated for the download and import into a SQL database. I am hoping he will get the code shared soon.
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
118
Reaction score
23
Location
92679
I just use wget on a crontab , and pull the file, and have it with DATE and TIME stamp into a folder, that is where most of my "programing" ends, so I am hoping for the rest of pulling the CSV files into a workable DB and program lol
 

th182

BIT Beta Team
Joined
Sep 11, 2018
Messages
689
Reaction score
1,204
Location
Minnesota
NM, apparently it requires a license key as well, it didn't say that in the application, it says it online.....seems the CSV is the work around for free....
The open source version on github does exactly this. Granted it’s all Linux based. It has a script that scrapes the beanstalk data every minute and dumps to an SQL database. That’s what I am running. Then I have a PHP front-end that displays the plates.

I haven’t set up any alerting or anything yet.. that’s what I want to do but haven’t had time to tinker.


Sent from my iPhone using Tapatalk
 

nhs128

Young grasshopper
Joined
Jul 8, 2017
Messages
91
Reaction score
21
The open source version on github does exactly this. Granted it’s all Linux based. It has a script that scrapes the beanstalk data every minute and dumps to an SQL database. That’s what I am running. Then I have a PHP front-end that displays the plates.

I haven’t set up any alerting or anything yet.. that’s what I want to do but haven’t had time to tinker.


Sent from my iPhone using Tapatalk
Did it come with the php front end or is that something that you wrote? I haven't looked at the open source script yet.
 

usaf_pride

Pulling my weight
Joined
Mar 10, 2017
Messages
284
Reaction score
170
I just use wget on a crontab , and pull the file, and have it with DATE and TIME stamp into a folder, that is where most of my "programing" ends, so I am hoping for the rest of pulling the CSV files into a workable DB and program lol
If you are using sqlite3, check out the .import command :)
 

th182

BIT Beta Team
Joined
Sep 11, 2018
Messages
689
Reaction score
1,204
Location
Minnesota
Did it come with the php front end or is that something that you wrote? I haven't looked at the open source script yet.
If I remember correctly it came with a basic front-end but I rolled my own to incorporate a list of known plates and such. Still very much a work in progress.


Sent from my iPhone using Tapatalk
 

nhs128

Young grasshopper
Joined
Jul 8, 2017
Messages
91
Reaction score
21
I may look at this option as well, if anything just to play around. I haven't tried to set it up locally yet.
 

th182

BIT Beta Team
Joined
Sep 11, 2018
Messages
689
Reaction score
1,204
Location
Minnesota
I try to avoid cloud-based solutions so the open source option appealed to me. There is a setup guide on here that I believe someone linked to earlier.

Edit: note that you have to use Ubuntu 16.04 as specified in the guide. I did the upgrade to 18 and it broke a lot of things that I couldn’t get working so I wiped the computer and started over a couple weeks ago. Apparently a bunch of components are new/upgraded in 18 and the open source ALPR hasn’t been updated to work with them, at least that’s what my google searching was finding.


Sent from my iPhone using Tapatalk
 

nhs128

Young grasshopper
Joined
Jul 8, 2017
Messages
91
Reaction score
21
I will give that a try..probably just play with a VM for now and see if I can get it running. I'll look for the guide as well.
 

nhs128

Young grasshopper
Joined
Jul 8, 2017
Messages
91
Reaction score
21
Yes, I was in the same boat, having to manually pull the csv file every day, and it became tedious to do. With the help of a whizz here in the forum, now the whole process is automated for the download and import into a SQL database. I am hoping he will get the code shared soon.
Any updates on sharing the code for what you all have put together?
 

Gymratz

Pulling my weight
Joined
Jun 24, 2017
Messages
114
Reaction score
130
Sorry guys, delay here was on me. Got busy with life and then came back to some computer issues on the machine I used as my primary machine (the one that actually has monitors!)
New thread created with links to all of the code and hopefully enough instruction that someone familiar with coding can follow.
 

Fubduck

Getting the hang of it
Joined
Jul 10, 2018
Messages
109
Reaction score
72
Location
colorado
I just use wget on a crontab , and pull the file, and have it with DATE and TIME stamp into a folder, that is where most of my "programing" ends, so I am hoping for the rest of pulling the CSV files into a workable DB and program lol
Could you please share your wget command? I am trying to automate the download of the csv data from openalpr.com.
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
118
Reaction score
23
Location
92679
Could you please share your wget command? I am trying to automate the download of the csv data from openalpr.com.
The command has my cookie information in it. But when I get home Monday I can share what I used so you can imitate it
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
118
Reaction score
23
Location
92679
I used CLIGET in firefox to get the command, then tweaked it to add the "date/time" at the end, however, now that I am using OpenALPR/LPRDownloader/LPRViewer, etc, I do not download them anymore.
 

Fubduck

Getting the hang of it
Joined
Jul 10, 2018
Messages
109
Reaction score
72
Location
colorado
I used CLIGET in firefox to get the command, then tweaked it to add the "date/time" at the end, however, now that I am using OpenALPR/LPRDownloader/LPRViewer, etc, I do not download them anymore.
Thanks for the hint about CLIGET. I forgot I had that extension installed. I now have a functioning automated script for downloading the csv files and importing them into my database. I tried to install LPRDownloader/LPRViewer on my laptop before I installed it on my Blue Iris PC but I couldn't get it to work. So, I just rolled my own setup with mysql, php and apache on my media server. This also allows me to view the LPR info from any device with a web browser.
 

rbc1225

Getting the hang of it
Joined
Jan 11, 2023
Messages
108
Reaction score
29
Location
Lees Summit MO
@DLONG2 Have you tried running OpenALPR locally instead of using the cloud service?

The OpenALPR is open source and available on Github:
openalpr/openalpr

There is an older thread where people are running OpenALPR locally: LPR Walk Through / Tutorial

If you run it locally, there are no limits to data retention, plus, you are not sending data to an external cloud service.
Never ever trust any cloud service if you care about your privacy.
It is possible that any cloud service will misuse your data by accident (poor internal processes/management) or intentionally, and without your knowledge.

Example: Ring reportedly gave employees access to customer video feeds
Yes I know this is an old thread but I am thinking of trying to use the source on Github. I am also thinking of purchasing an NVR that is running Linux. Do you happen to know in general if I could run OpenALPR on a NVR running Linux or should I just setup a different machine?
 
Top