Pinned Loading
-
Find any raspberry pi on a network.
Find any raspberry pi on a network. 12## Find all OUI's owned by vendor
3curl -sS "https://standards-oui.ieee.org/oui/oui.txt" | grep "Raspberry Pi" | grep "(hex)"
45Returns something like...
-
Articles about raster compression
Articles about raster compression 1https://blog.cleverelephant.ca/2015/02/geotiff-compression-for-dummies.html
23https://kokoalberti.com/articles/geotiff-compression-optimization-guide/
-
mapbox_bits.md
mapbox_bits.md 1## Blank mapbox sytle
23```
4style: {
5version: 8,
-
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": [
-
Forward a port over ssh
Forward a port over ssh 1# Forward a port over SSH
23Handy for connecting to a remote postgres db
45ssh -i ./[key.pem] -L [local_port]:127.0.0.1:[remote_port] [email protected]
-
find timestamp islands in potgres
find timestamp islands in potgres 1SELECT *, count(*) FILTER (WHERE step) OVER (ORDER BY timestamp) AS grp
2FROM (
3SELECT *
4, (lag(timestamp) OVER (ORDER BY timestamp) <= timestamp - interval '60 min') AS step
5FROM tracker
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.