ksheng-

# move missing tmp files into correct partition
{if[not "tick" in system "ls ",dst:1_string .Q.par[`$":db/cago_ny4";"D"$-10#x;`];show " " sv ("cp";"-r";x,"/tick";dst,"/tick")]} each system "ls -d /data/kdb/01/cago_ny4/tmp/*"

ksheng-

find . -type f -mtime +7 -ls
find . -type f -mtime +7 -delete

ksheng-

 ffmpeg -i smash.mp4 -ss 47 -to 60 -c:v libvpx-vp9 -crf 30 -b:v 0 scopetv.webm
 ffmpeg -i smash.mp4 -ss 47 -to 60 -c:v libaom-av1 scopetv.webm 

ksheng-

$sl-color--hopbush:       #c69    !default;
$sl-color--bouquet:       #b37399 !default;
$sl-color--venus:         #998099 !default;
$sl-color--patina:        #699    !default;
$sl-color--nebula:        #d2e1dd !default;
$sl-color--white:         #fff    !default;
$sl-color--dawn-pink:     #f2ece4 !default;
$sl-color--wafer:         #e1d7d2 !default;
$sl-color--iron:          #dadbdf !default;
$sl-color--regent-grey:   #808c99 !default;

ksheng-

SELECT
 *
FROM (
SELECT
	row_number() over() as cartodb_id,
    the_geom,
    the_geom_webmercator,
    bbl,
  	numbldgs,
    property_tax,

ksheng-

xsv frequency rawdata.csv -s activityThrough
field,value,count
activityThrough,2017-06-02,28584244
activityThrough,2018-06-01,15532988
activityThrough,2015-06-05,15509053
activityThrough,2009-06-06,13890098
activityThrough,2016-06-03,11455436
activityThrough,2010-06-11,2429943
activityThrough,2009-11-20,2422271
activityThrough,2011-06-10,2416519

ksheng-

2019-06-23 WSL Ubuntu 18.04

sudo apt update
sudo apt upgrade

sudo apt install build-essential
sudo apt install make cmake
sudo apt install python3-pip

ksheng-

times:();do[10;times,:system "t select count i by sym from tob where date = 2019.03.28"];show `runs`min`max`avg!(count times; min times; max times; avg times)

ksheng-

SELECT
 *
FROM (
SELECT
	row_number() over() as cartodb_id,
    the_geom,
    the_geom_webmercator,
    bbl,
  	numbldgs,
    property_tax,

ksheng-

https://common-data.carto.com:443/api/v2/sql?q=select cartodb_id, the_geom, address, bbl, bldgarea, assessland, assesstot, exemptland, exempttot, numbldgs, numfloors, ownername, comarea, officearea, resarea, retailarea, unitsres, unitstotal, yearbuilt, zipcode from public.qnmappluto
https://common-data.carto.com/api/v2/sql?format=csv&q=select%20cartodb_id,%20the_geom,%20address,%20bbl,%20bldgarea,%20numbldgs,%20numfloors,%20ownername,%20unitsres,%20unitstotal,%20yearbuilt,%20zipcode%20from%20public.bkmappluto