Giter VIP home page Giter VIP logo

txdmv-denied-plates's Introduction

TxDMV Denied Plates

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.

Reason Codes

As defined in Title 43, part 10, chapter 217, subchapter B, rule 217.27 ("Vehicle Registration Insignia"), specialty license plates may be rejected if:

  1. The alphanumeric pattern conflicts with the department's current or proposed regular license plate numbering system.
  2. 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:
    1. 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;
    2. B) vulgar, directly or indirectly (defined as profane, swear, or curse words);
    3. 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);
    4. D) a direct or indirect negative instruction or command directed at another individual related to the operation of a motor vehicle;
    5. 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;
    6. 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;
    7. G) a direct representation of law enforcement or other governmental entities, including any reference to a public office or position exclusive to government; or
    8. H) a pattern that could be misread by law enforcement.
  3. The alphanumeric pattern is currently on a license plate issued to another owner.

Generation

(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).

License

From my understanding, this is public domain information. I'm most certainly not a lawyer. Good luck!

Usages

Conclusions

  • 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.

txdmv-denied-plates's People

Contributors

spotlightishere avatar

Stargazers

 avatar  avatar  avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.