Category Archives: Data Analysis

Franwell pulls bid to replace Biotrack for WA State i502 Recreational Cannabis Traceability System

Published / by bde / Leave a Comment

Well, it looks like enough people spoke up to the LCB and they listened. I received the following Email from LCB yesterday regarding Franwell and their decision to pull the bid for the contract to replace Biotrack.

This is only a SMALL win. WE STILL DESPERATELY NEED A BETTER SYSTEM THAN BIOTRACK. MY NEW CONCERN: DOING THIS BY OCTOBER!!!

After spending 15 years in the Enterprise software space, I was involved in a number of large scale integration, migration, upgrade, and “rip and replace” style software development projects. These projects are costly, messy, and never go according to plan.

Why is LCB in such a rush to implement a new system by October? If this mandate stands, there is ABSOLUTELY NO WAY TO IMPLEMENT A ROBUST SOLUTION for a project at this scale. Especially one that aspires to do a full rip and replace with a standard, dev/test/release cycle in between. These types of projects take 18-24 months at best, let alone 4 months.

4 month dev cycle. With a government project?
ARE YOU FUCKING KIDDING ME?
##

Text from letter from LCB:

===

Attention Licensees: The below message was sent yesterday by Deputy Director Peter Antolin to licensees who had written to the Board and staff regarding the marijuana traceability Apparent Successful Vendor and RFID tags.

June 7, 2017

On behalf of the Liquor and Cannabis Board, thank you for writing recently to express your concerns about the change in vendors for the state traceability system and specifically RFID tags.

RFID Not Required
The WSLCB will not require RFID as part of the marijuana traceability project. Our Request for Proposal (RFP) was clear that the marijuana seed-to-sale traceability system must support a variety of tagging methodologies such as bar codes, RFID, etc. The RFP requirements did not allow a vendor to make any assumptions regarding use of a single tagging methodology or allow vendors to include any such costs affecting the state or our licensees in their proposal. In addition, unique plant and inventory identification numbers will be centrally created, maintained, and made available to third-party software systems via the API. Licensees will also be able to print their own labels.

Traceability Advisory Group
As the WSLCB prepared the RFP, we engaged representatives of the major industry trade organizations. We held several meetings together to gather input and clearly communicate our intentions. At the most recent meeting held June 6, we again asked that the representatives of the Traceability Advisory Group communicate with their members about this important point.

Change in Apparent Successful Vendor
As we have indicated, the Apparent Successful Vendor (ASV) was not final until contract negotiations were complete and a contract was signed. Earlier today, the initial ASV, Franwell, withdrew its proposal for Washington State. An ASV is the procurement term used for the highest scoring, responsive vendor.

We are pleased to notify you that the second place bidder also submitted a strong bid and has accepted our choice to be the new ASV. MJ Freeway is the new ASV. We will soon schedule a product demonstration with our Traceability Advisory Group and begin contract negotiations quickly to get this project implemented.

Timeline
This project is on a tight timeline. The new traceability system must be in place Oct. 31, 2017. We are taking the necessary steps now to ensure a smooth transition from the current system to the new one.

Thank you again for writing the Washington State Liquor and Cannabis Board.

Brian E. Smith
Communications Director
Washington State Liquor and Cannabis Board
360-664-1774

===

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

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

i502 Competitive Analysis and Intelligence Briefs

Published / by bde / 2 Comments on i502 Competitive Analysis and Intelligence Briefs

As I transition my i502 data mining project from my laptop to the cloud, I’m working on a conceptual framework for offering competitive briefs, reports, charts, and drill-down maps on i502 Producers, Processors, and Retailers. This will include insight, commentary, and a sizeable chunk of data factoids about your closest competitors.

Here are some of my initial thoughts:

  • For Producer/Processors
    • Production/Processing
      • Products made
      • Products sold
      • Products destroyed
      • Products failed testing
    • Heat maps with layers for:
      • Retailers by location
      • Products by retailer
      • Wholesale Sales by product type, product, temporal (daily, weekly, monthly, yearly)
      • Retailer markups
        • By retailer
        • By product type
        • By Product SKU
  • For Retailers
    • Wholesale cost
      • By product type
      • By product
      • By producer/processor
      • By region/geography
    • Retail Sales
      • By product type (flower, oil, edibles)
      • By SKU (e.g. Skord Nightmare Cookies Live Resin)
      • By Producer/Processor
    • Top 10 Producer/processor sales drill down
    • Top 10 closest retailers (region/geography)
    • Top 10 closest retailers (aggregate sales)

Goals:

  1. Learn who your competition is.
  2. Understand the range of products your competitors produce/offer/sell.
  3. Understand the range of products that you or your competitors DON’T SELL (products sitting on shelf).
  4. Understand how much and when your customers sell.
  5. Understand where and to whom your competitors sell. ]

That’s all I can think of off the top of my head for now. Will update/edit post as I iterate and refine this conceptual framework.

If you made it this far, thanks for taking the time to read through this post. As a reward, here’s a pic of some Chem Dawg I grew back in the MMJ days.

BDE -∞+

December i502 Report

Published / by bde / Leave a Comment

Hi guys. I’m working on a detailed analyst report on the i502 traceability data from December 2016.

Until I have it ready to publish, here are a few teaser factoids:

  • Largest concentrate wholesale sale: GreenRush sold 4000 grams of GreenRush Gold Standard Concentrate (Marijuana extract for inhalation) to Clutch Cannabis (in a processor to processor wholesale deal) for $48000 or $12/g.
  • Total concentrates sold (wholesale) to date: 8,688,860 grams
  • Total concentrate wholesale sales to date: $92,958,449
  • Average wholesale price per unit: $8.97

Much more to come. Tables, charts, commentary, analysis.

-BDE