Monthly Archives: May 2017

LCB dumps BioTrackTHC for Franwell for state Traceability System

Published / by bde / Leave a Comment

Nah nah nah nah,

nah nah nah nah,

hey hey hey,

goodbye…. BiotrackTHC

The day could not come fast enough. Today, the WSLCB announced the selection of technology company Franwell as the Apparent Successful Vendor (ASV) to replace the existing Biotrack seed-to-sale traceability system in Washington State.

I can’t believe they plan to migrate to an entirely new system/framework by October 2017. I don’t see how this can be done given my background and experience working in the enterprise software space, especially when dealing with government agencies and projects. I hope Franwell has some ninjas on their team because they are going to need some serious SQL coders to port from the underlying Biotrack data model. Unless they already have a migration tool/util already built.

Need to go check into these guys ASAP. I really hope they are better. I have a ton of questions on how deep they are going to go to rip Biotrack out. Could potentially affect ALL of my data mining stuff. #buhbye#biocrapthc #goodriddance#worstdatabaseever #lcb #slcb #i502

NEW RULES! 314-55-045 – aka “How to get permanently banned from i502”

Published / by bde / Leave a Comment

New rules under consideration for i502 announced today. 314-55-045 has been expanded to include terms that define what rule, law, or violation history might prevent an applicant from receiving or renewing their marijuana license.

What timing – someone was just asking about this on one of my other posts. Gotta go back and tag em here.

#rulemaking #policy #legislation #i502 #lcb#wslcb #recreationalmarijuana #legalweed#olympia #wa

Full Range of Consulting, Sales, Brokering, Outreach, and Networking services for Recreational Cannabis (i502) in WA State

Published / by bde / Leave a Comment

I have a new role and opportunity in i502 helping manage, broker, and sell to licensed Producer/Processors and Retailers. I have an inventory and price sheet I can forward and am happy to assist with any type of inventory transfer desired, whether you are looking for wholesale b2b or retail transactions.

Have access to full range and spectrum of wholesale/retail products. Also buy in bulk and always looking for quality product, starting material, and trim.

DM, email, txt, or call for more details and pricing.

@eisenetics [Instagram, snapchat, twitter]
eisenetics@gmail.com
2062948205 mobile
facebook.com/eisenetics

i502 Compliance Violations by License

Published / by bde / Leave a Comment

Because Biotrack is stupid and their database tables suck, this table doesn’t display the actual name of the Licensee that had the violation. Until I figure out a better way, here’s a nifty URL that you can use and just cut and paste the license number and add to the end of the URL to see who committed the violation.

https://502data.com/license/[paste license number here]

For example, https://502data.com/license/414841

[TODO: add links to table for license name lookup and WAC code and case # linkage]

Powered by Socrata

New WSLCB Dashboard built on Socrata Framework

Published / by bde / Leave a Comment

Today the WSLCB released a new Monthly Dashboard for access to the public data for i502. I started poking around and they are using a cloud based data provider based in Seattle named Socrata (http://socrata.com). I just started poking around and while the framework has a STEEP learning curve, luckily I spent almost 2 decades banging my head against the wall trying to learn and use the vast majority of these kinds of frameworks when I worked in the Enterprise Software space. I’m going to use this post as a test bed to see if the “embed” features actually work. To be continued… BDE

PS – had a great meeting today with Cannasol Farms right across the valley in Riverside. More on that later.

Hello World… should display Extract Conversions table

Powered by Socrata