simonw

How I got darkflow working on my OS X Laptop

Darkflow is a Python 3 tool that makes the Darknet open source neural networks available in Python using Tensorflow.

Here's how I got it working on my laptop:

cd /tmp
git clone https://github.com/thtrieu/darkflow
cd darkflow

virtualenv --python=python3 .venv

simonw

How to compile and run a Pony program using Docker

Create a /tmp/helloworld directory and put the following in main.pony:

actor Main
  new create(env: Env) =>
    env.out.print("Hello, world!")

Now compile it like this (the Docker image will be downloaded if necessary):

simonw

select spatialite_version(), spatialite_target_cpu( ), proj4_version( ), geos_version( ), lwgeom_version( ), libxml2_version( ), HasIconv( ), HasMathSQL( ), HasGeoCallbacks( ), HasProj( ), HasGeos( ), HasGeosAdvanced( ), HasGeosTrunk( ), HasLwGeom( ), HasLibXML2( ), HasEpsg( ), HasFreeXL( ), HasGeoPackage( );

e.g. https://timezones-api.now.sh/timezones-4fbc08f?sql=select+spatialite_version%28%29%2C+spatialite_target_cpu%28+%29%2C+proj4_version%28+%29%2C+geos_version%28+%29%2C+lwgeom_version%28+%29%2C+libxml2_version%28+%29%2C+HasIconv%28+%29%2C+HasMathSQL%28+%29%2C+HasGeoCallbacks%28+%29%2C+HasProj%28+%29%2C+HasGeos%28+%29%2C+HasGeosAdvanced%28+%29%2C+HasGeosTrunk%28+%29%2C+HasLwGeom%28+%29%2C+HasLibXML2%28+%29%2C+HasEpsg%28+%29%2C+HasFreeXL%28+%29%2C+HasGeoPackage%28+%29%3B

simonw

Running in Datasette at https://vice-police-shootings.now.sh/vice-bc7c892/ViceNews_FullOISData

Here's what I did:

First, I exported as CSV the data from https://docs.google.com/spreadsheets/d/1CaOQ7FUYsGFCHEqGzA2hlfj69sx3GE9GoJ40OcqI9KY/edit#gid=1271324584

Then I converted it to a SQLite database using https://github.com/simonw/csvs-to-sqlite like so:

csvs-to-sqlite ~/Downloads/ViceNews_FullOISData.csv /tmp/vice.db \

-c Fatal -c SubjectArmed -c SubjectRace -c SubjectGender -c OfficerRace \

simonw

Not sure what these are:

datasette ~/Library/Suggestions/*.db

Safari stuff:

datasette ~/Library/Safari/*.db

Your desktop background:

simonw

Datasette for Polar Bears

I found an interesting looking dataset about Polar Bear ear tag tracking on a USGS website: https://alaska.usgs.gov/products/data.php?dataid=130

I deployed it as a datasette website and API here: https://polar-bears.now.sh/

Here's how I did it:

0. Install datasette and csvs-to-sqlite:

simonw

How to browse your volumes on Docker for Mac

Docker for Mac runs a virtual machine on your laptop. To view the volumes, you need to attach a terminal to that virtual machine. You can do that like this:

screen ~/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-linux/tty

Now the volumes can be found here:

cd /var/lib/docker/volumes

simonw

simonw

simonw

[
  {
    "TOTAL_POPULATION": 115, 
    "GENERAL_POPULATION": 115, 
    "ORG_POC_AFTER_HOURS_PHONE": null, 
    "PET_ACCOMMODATIONS_CODE": null, 
    "FACILITY_TYPE": "SHELTER", 
    "COUNTY_PARISH": "MARION", 
    "FIPS_CODE": null, 
    "INCIDENT_ID": null,