mdiener21

def round_to_nearest_quarter_hour(minutes, base=15):
    """
    Input: A value in minutes.
    Return: An integer rounded to the nearest quarter-hour (0, 15, 30, 45) based on the base interval,
    with special handling to ensure rounding from 0 up to 7 goes to 0 and 8 to 15 round to 15
    
    Example  round_to_nearest_quarter_hour(0) rounds to 0
             round_to_nearest_quarter_hour(7) rounds to 0
             round_to_nearest_quarter_hour(8) rounds to 15
             round_to_nearest_quarter_hour(22) rounds to 15

mdiener21

#* original post here http://blog.mikeasoft.com/2010/09/24/local-map-rendering-and-route-finding-with-libchamplain-spatialite-and-open-street-map/

Importing OSM data into spatialite

spatialite_osm -o mydownloadeddata.osm -d myNewDB.sqlite -T roads -m

Generating a routing table

spatialite_network -d myNewDB.sqlite -T roads -g geometry -c cost -t node_to -f node_from -n name --oneway-fromto oneway_fromto --oneway-tofrom oneway_tofrom -o roads_net_data

mdiener21

Make the daisy Create the white cross Solve the first layer Solve the second layer Create the yellow cross: F U R U' R' F' Solve the yellow face: R U R' U R U2 R' Move yellow stickers upper right-hand corner of left-face Orient "fish" down and to the left relative to your perspective

mdiener21

import requests

def delete_layer(layer_name):
    s = requests.Session()
    GEOSERVER_USER = 'someusername'
    GEOSERVER_PASS = 'asecretthingy'
    s.auth = (GEOSERVER_USER, GEOSERVER_PASS)
    headers_json = {'Content-type': 'application/json', }
    del_url = "https:/yourgeoserver.com/workspaces/SsmeWorkspaceName/datastores/someDataStoreName/featuretypes/" + layer_name + "?recurse=true"
    r = s.delete(del_url, headers=headers_json, data={})

mdiener21

# git commits per developer
git shortlog -sn --no-merges --since "01 January 2019"

# a clearer better git log view of commits
git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit

mdiener21

#!/bin/bash -e
set -o pipefail

# Any arguments are incorrect.  Note that git intercepts --help and tries to
# open the man page.
if [ $# -gt 0 ]; then
   echo 'Usage: git merge-stats'
   exit 1
fi

mdiener21

- hosts: all
  become: yes
  gather_facts: false
  tasks:
  - name: Install docker packages
    remote_user: ubuntu
    apt:
      name: "{{ item }}"
      state: present
      update_cache: yes

mdiener21

sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main"
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

sudo apt-get install postgresql-9.6-postgis-2.3
sudo apt-get install postgresql-9.6-pgrouting

sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
sudo apt-get update

mdiener21

UPDATE multipoly_table_with_rings AS myrings
SET geom = noring.geom
FROM (
    SELECT id, ST_Collect(ST_MakePolygon(geom)) AS geom
    FROM (
        SELECT id, ST_NRings(geom) AS nrings, 
            ST_ExteriorRing((ST_Dump(geom)).geom) AS geom
        FROM multipoly_table_with_rings
        WHERE ST_NRings(geom) > 1
        ) AS foo

mdiener21

# source: https://dev.to/mariamxl
# https://dev.to/mariamxl/dijkstras-algorithm-in-python-algorithms-for-beginners-dkc

from collections import deque, namedtuple


# we'll use infinity as a default distance to nodes.
inf = float('inf')
Edge = namedtuple('Edge', 'start, end, cost')