51% lookup now available online @ TABC website!

CHL discussions that do not fit into more specific topics

Moderators: carlson1, Charles L. Cotton


artx
Senior Member
Posts in topic: 1
Posts: 220
Joined: Sun Oct 14, 2007 8:14 pm
Location: SATX

Re: 51% lookup now available online @ TABC website!

#16

Post by artx »

Thanks! I've verified 2 places that had the 51% sign were not (as I thought) really 51% locations!!! This is great!

Topic author
RHenriksen
Senior Member
Posts in topic: 13
Posts: 2058
Joined: Sun Mar 01, 2009 1:59 pm
Location: Houston

Re: 51% lookup now available online @ TABC website!

#17

Post by RHenriksen »

artx wrote:Thanks! I've verified 2 places that had the 51% sign were not (as I thought) really 51% locations!!! This is great!
Very cool. What's the appropriate process to get those businesses' signage reviewed/corrected?
I'll quit carrying a gun when they make murder and armed robbery illegal

Houston Technology Consulting
soup-to-nuts IT infrastructure design, deployment, and support for SMBs
User avatar

tbrown
Senior Member
Posts in topic: 2
Posts: 1685
Joined: Thu Mar 17, 2011 4:47 pm

Re: 51% lookup now available online @ TABC website!

#18

Post by tbrown »

If you know/like the management (or a staff member) you can point it out in a friendly way to save them any hassles.

If not, there's a form on the TABC website to report so they can investigate. http://www.tabc.state.tx.us/forms/enforcement/4-65.pdf
sent to you from my safe space in the hill country

joelamosobadiah
Senior Member
Posts in topic: 3
Posts: 243
Joined: Fri Feb 06, 2009 12:03 am

Re: 51% lookup now available online @ TABC website!

#19

Post by joelamosobadiah »

Another use for this feature is to list all 51%+ establishments in a particular area (to see if there's any "surprises" in your area):

Go to the TABC website and click on Public inquiry, then click on the option for, "Create a list of licenses or permits".
Select the options you want listed. I listed the two counties of the city I live in (Potter and Randall), and left the dates blank.
Select Excel as the output format.
Open the downloaded Excel file.
Click on the data tab on the toolbar at the top.
Click on the Filter Button
Click on the down arrow on the far right column and make sure only the "Red" checkbox is checked.

Image

Now you'll have a list of all the 51%+ businesses in the area.
User avatar

sugar land dave
Senior Member
Posts in topic: 1
Posts: 1396
Joined: Mon Jan 24, 2011 12:03 am
Location: Sugar Land, TX

Re: 51% lookup now available online @ TABC website!

#20

Post by sugar land dave »

Works well. Thanks to all involved! :thumbs2:
DPS Received Forms- 1/18/11 Online Status - 1/27/11 My Mailbox - 2/12/11
NRA Life Member

pedalman
Senior Member
Posts in topic: 1
Posts: 464
Joined: Fri Mar 21, 2008 9:18 am
Location: New Braunfels, Texas
Contact:

Re: 51% lookup now available online @ TABC website!

#21

Post by pedalman »

This is great! Now we don't have to bother the TABC for this information. I'm sure they have more important things to do. Hopefully, this will free up some time for them.
User avatar

The Mad Moderate
Senior Member
Posts in topic: 1
Posts: 872
Joined: Tue Nov 23, 2010 11:31 am
Location: Marble Falls

Re: 51% lookup now available online @ TABC website!

#22

Post by The Mad Moderate »

could this data be culled and used in a iOS or Android app.
American by birth Texan by the grace of God

Not to be a republican at twenty is proof of want of heart; to be one at thirty is proof of want of head.
-Francois Guisot

Topic author
RHenriksen
Senior Member
Posts in topic: 13
Posts: 2058
Joined: Sun Mar 01, 2009 1:59 pm
Location: Houston

Re: 51% lookup now available online @ TABC website!

#23

Post by RHenriksen »

loadedliberal wrote:could this data be culled and used in a iOS or Android app.
Well, for starters the Android CHL app will get a link to the TABC search page.
I'll quit carrying a gun when they make murder and armed robbery illegal

Houston Technology Consulting
soup-to-nuts IT infrastructure design, deployment, and support for SMBs
User avatar

A-R
Senior Member
Posts in topic: 1
Posts: 5776
Joined: Sun Apr 12, 2009 5:01 pm
Location: Austin area

Re: 51% lookup now available online @ TABC website!

#24

Post by A-R »

RHenrikson this truly is a tremendous achievement you've made for all us CHLs. Thank you! And I'll be sending my thanks to Ms. Beck as well.

:clapping:
:tiphat:
:txflag:

:cheers2:

Topic author
RHenriksen
Senior Member
Posts in topic: 13
Posts: 2058
Joined: Sun Mar 01, 2009 1:59 pm
Location: Houston

Re: 51% lookup now available online @ TABC website!

#25

Post by RHenriksen »

Thanks, AR, but she really deserves most of the credit :tiphat:
I'll quit carrying a gun when they make murder and armed robbery illegal

Houston Technology Consulting
soup-to-nuts IT infrastructure design, deployment, and support for SMBs

Mach1
Junior Member
Posts in topic: 1
Posts: 20
Joined: Thu Jul 03, 2008 10:44 am

Re: 51% lookup now available online @ TABC website!

#26

Post by Mach1 »

My thanks, also! Good job, RHenriksen.. And thanks also to Joel...iah for the spreadsheet tips.

joelamosobadiah
Senior Member
Posts in topic: 3
Posts: 243
Joined: Fri Feb 06, 2009 12:03 am

Re: 51% lookup now available online @ TABC website!

#27

Post by joelamosobadiah »

Theoretically (I'm not a programmer) couldn't this info be parsed into an Excel or csv format and put into an Android or iPhone app that would use location services to search for 51+% locations near your current address? Wouldn't think it would be too difficult...

Topic author
RHenriksen
Senior Member
Posts in topic: 13
Posts: 2058
Joined: Sun Mar 01, 2009 1:59 pm
Location: Houston

Re: 51% lookup now available online @ TABC website!

#28

Post by RHenriksen »

joelamosobadiah wrote:Theoretically (I'm not a programmer) couldn't this info be parsed into an Excel or csv format and put into an Android or iPhone app that would use location services to search for 51+% locations near your current address? Wouldn't think it would be too difficult...
I know just enough about programming to have a lot of respect for the people do ;-)
I'll quit carrying a gun when they make murder and armed robbery illegal

Houston Technology Consulting
soup-to-nuts IT infrastructure design, deployment, and support for SMBs

boba

Re: 51% lookup now available online @ TABC website!

#29

Post by boba »

joelamosobadiah wrote:Theoretically (I'm not a programmer) couldn't this info be parsed into an Excel or csv format and put into an Android or iPhone app that would use location services to search for 51+% locations near your current address? Wouldn't think it would be too difficult...
It could, but if you have an Android or iPhone you probably have a data plan and can go to the website and check for a 51% license at the place your family or friends want to go. That way it's up to date.
User avatar

5thGenTexan
Senior Member
Posts in topic: 1
Posts: 434
Joined: Thu Sep 24, 2009 11:04 pm
Location: Weatherford

Re: 51% lookup now available online @ TABC website!

#30

Post by 5thGenTexan »

Man that is great, just verified one bad 51% sign that had miffed me for years just never thought call on.
5th Generation Texan
"Republicrats and Demicans, it ain't no surprise,
Got their hands full of gimme, they got their mouths full of lies."
Post Reply

Return to “General Texas CHL Discussion”