Importing police incidents

by josevnz 1 year ago

GNU/Linux ◆ xterm-256color ◆ bash 497 views

(InfluxDB) [josevnz@dmaf5 InfluxDBIntro]$ scripts/police_cases_importer.py –help usage: Import the Hartford police incidents. API: https://docs.influxdata.com/influxdb/v2.4/api-guide/client-libraries/python/ Geolocation helper: https://github.com/aaliddell/s2cell DATASET: https://data.hartford.gov/api/views/889t-nwfu/rows.csv?accessType=DOWNLOAD Author: Jose Vicente Nunez (kodegeek.com@protonmail.com)

We are expecting to handle 12 columns:

Description	Type	Column #
Case_Number	Number	1
Date	Date & Time	2
Time_24HR	Plain Text	3
Address	Plain Text	4
UCR_1_Category	Plain Text	5
UCR_1_Description	Plain Text	6
UCR_1_Code	Number	7
UCR_2_Category	Plain Text	8
UCR_2_Description	Plain Text	9
UCR_2_Code	Number	10
Neighborhood	Plain Text	11
geom	Location	12

   [-h] --data_file DATA_FILE config

positional arguments: config Path to the configuration file

optional arguments: -h, –help show this help message and exit –data_file DATA_FILE

                    File with the code

More by josevnz

Show netflow for given multicast group 01:10

by josevnz 2 years ago

Glances on a RaspberryPI 00:51

by josevnz 1 year ago

Mock demo for REST API to be queried using JSONPath 02:06

by josevnz 1 year ago

Importing Socrata HPD UCR Codes into Influxdb 02:09

by josevnz 1 year ago

See all

You can download this recording in asciicast v2 format, as a .cast file.

Download

Replay in terminal

You can replay the downloaded recording in your terminal using the asciinema play command:

asciinema play 528791.cast

If you don't have asciinema CLI installed then see installation instructions.

Use with stand-alone player on your website

Download asciinema player from the releases page (you only need .js and .css file), then use it like this:

<!DOCTYPE html>
<html>
<head>
  <link rel="stylesheet" type="text/css" href="asciinema-player.css" />
</head>
<body>
  <div id="player"></div>
  <script src="asciinema-player.min.js"></script>
  <script>
    AsciinemaPlayer.create(
      '/assets/528791.cast',
      document.getElementById('player'),
      { cols: 205, rows: 26 }
    );
  </script>
</body>
</html>

See asciinema player quick-start guide for full usage instructions.

While this site doesn't offer GIF conversion at the moment, you can still do it yourself with the help of asciinema GIF generator utility - agg.

Once you have it installed run the following command to create GIF file:

agg https://asciinema.org/a/528791 528791.gif

Or, if you already downloaded the recording file:

agg 528791.cast 528791.gif

Check agg --help for all available options. You can change font family and size, select color theme, adjust speed and more.

See agg manual for full usage instructions.