Pinned Loading

1. Find any raspberry pi on a network. Find any raspberry pi on a network.

   1

   2

   ## Find all OUI's owned by vendor

   3

   curl -sS "https://standards-oui.ieee.org/oui/oui.txt" | grep "Raspberry Pi" | grep "(hex)"

   4

   5

   Returns something like...

2. Articles about raster compression Articles about raster compression

   1

   https://blog.cleverelephant.ca/2015/02/geotiff-compression-for-dummies.html

   2

   3

   https://kokoalberti.com/articles/geotiff-compression-optimization-guide/

3. mapbox_bits.md mapbox_bits.md

   1

   ## Blank mapbox sytle

   2

   3

   ```

   4

   style: {

   5

           version: 8,

4. aus_airports.geojson aus_airports.geojson

   1

   {

   2

   "type": "FeatureCollection",

   3

   "name": "airports_aus",

   4

   "crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },

   5

   "features": [

5. Forward a port over ssh Forward a port over ssh

   1

   # Forward a port over SSH

   2

   3

   Handy for connecting to a remote postgres db

   4

   5

   ssh -i ./[key.pem]  -L [local_port]:127.0.0.1:[remote_port] [email protected]

6. find timestamp islands in potgres find timestamp islands in potgres

   1

   SELECT *, count(*) FILTER (WHERE step) OVER (ORDER BY timestamp) AS grp

   2

   FROM  (

   3

      SELECT *

   4

          , (lag(timestamp) OVER (ORDER BY timestamp) <= timestamp - interval '60 min') AS step

   5

      FROM   tracker