This repository contains 14,599 denied license plates from TxDMV. Their denial reasons are not given, but should be interpreted per the reason codes.
I reached out about this information on January 3rd, 2023. On August 25, 2023, TxDMV reached out with the PDFs, citing a growing backlog for the delay. I'm just amazed they got back to me.
As defined in Title 43, part 10, chapter 217, subchapter B, rule 217.27 ("Vehicle Registration Insignia"), specialty license plates may be rejected if:
- The alphanumeric pattern conflicts with the department's current or proposed regular license plate numbering system.
- The director or the director's designee finds that the personalized alphanumeric pattern may be considered objectionable. An objectionable alphanumeric pattern may include words, [or] phrases, or slang in any language; phonetic, numeric, or reverse spelling; acronyms; patterns viewed in mirror image; or code that only a small segment of the community may be able to readily decipher. An objectionable pattern may be viewed as:
- A) indecent (defined as including a direct reference or connotation to a sexual act, sexual body parts, excreta, or sexual bodily fluids or functions. Additionally, the alphanumeric pattern "69" is prohibited unless used with the full year (1969) or in combination with a reference to a vehicle;
- B) vulgar, directly or indirectly (defined as profane, swear, or curse words);
- C) derogatory, directly or indirectly (defined as an expression that is demeaning to, belittles, or disparages any person, group, race, ethnicity, nationality, gender, or sexual orientation. "Derogatory" may also include a reference to an organization that advocates the expressions described in this subparagraph);
- D) a direct or indirect negative instruction or command directed at another individual related to the operation of a motor vehicle;
- E) a direct or indirect reference to gangs, illegal activities, implied threats of harm, or expressions that describe, advertise, advocate, promote, encourage, glorify, or condone violence, crime, or unlawful conduct;
- F) a direct or indirect reference to controlled substances or the physiological state produced by such substances, intoxicated states, or a direct or indirect reference that may express, describe, advertise, advocate, promote, encourage, or glorify such substances or states;
- G) a direct representation of law enforcement or other governmental entities, including any reference to a public office or position exclusive to government; or
- H) a pattern that could be misread by law enforcement.
- The alphanumeric pattern is currently on a license plate issued to another owner.
(I'm not a data scientist - I apologize! There are likely more procedural ways to do this, but I lack the knowledge.)
After struggling for several hours with a mixture of OCR/text parsing, regex, and hand-copying, I settled on using Excel as it supposedly could handle importing the PDFs and interpreting their tables directly. Unfortunately, I quickly found that it struggled with having multiple tables per page (as present within each PDF).
In order to correctly have Excel scrape data from the PDFs, the following command was utilized to split each page of the PDF into halves. Thank you to this Super User answer!
for current in *.pdf; do
mutool poster -x 2 $current $(basename $current .pdf)_split.pdf
done
Each split PDF was then manually imported into Excel via its PDF data connector. (Although mutool
supports merging PDFs, importing all split tables at once has Excel easily exhaust my 32 GB RAM.)
A few custom steps were applied within Power Query to all tables:
- In order to accommodate only the left-hand side of the page,the "Month" column was dropped.
- In some circumstances, "Column 3" was created due to erroneous handling of certain license plates containing spaces. This column was merged with "Plate Selection" using a space as a separator.
- The total amount of license plate numbers present at the end of "Plate Selection" were manually removed (i.e. where Request Date was null).
From my understanding, this is public domain information. I'm most certainly not a lawyer. Good luck!
- "funny texas denied license plates" on Telegram: @funnytexasdeniedlicenseplates
- Although my high-end gaming rig can handle Cyberpunk 2077 at highest graphics and build LLVM in about 20 minutes, it could not handle the full wrath of Excel.
- It's no wonder that Excel can do ray-tracing.
- We should all be wary of those who know how to use Excel.