Nah nah nah nah,
nah nah nah nah,
hey hey hey,
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
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]
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
- 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)
- Learn who your competition is.
- Understand the range of products your competitors produce/offer/sell.
- Understand the range of products that you or your competitors DON’T SELL (products sitting on shelf).
- Understand how much and when your customers sell.
- 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.