Skip to content

Instantly share code, notes, and snippets.

View mikepaszkiewicz's full-sized avatar

Mike Paszkiewicz mikepaszkiewicz

6 followers · 13 following
View GitHub Profile
@mikepaszkiewicz
mikepaszkiewicz / drivetimes.html
Created June 8, 2020 19:46
Drive time map
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8' />
<title>Get started with the Isochrone API</title>
<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
<!-- Import Mapbox GL JS -->
<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v1.6.1/mapbox-gl.js'></script>
<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v1.6.1/mapbox-gl.css' rel='stylesheet' />
@mikepaszkiewicz
mikepaszkiewicz / .sql
Last active May 6, 2020 15:14
PostgreSQL Cheat Sheet
--CONNECTIONS
--check all active connections
SELECT * FROM pg_stat_activity;
--kill all other active connections
SELECT
pg_terminate_backend(pg_stat_activity.pid)
FROM
pg_stat_activity
@mikepaszkiewicz
mikepaszkiewicz / geocoder_comparison.ts
Created January 31, 2020 17:35
Pelias vs Google Maps
import axios from 'axios'
interface GeocodeFeature {
"type": "Feature",
"geometry": {
"type": string,
"coordinates": number[]
},
"properties": {
@mikepaszkiewicz
mikepaszkiewicz / .sh
Created October 23, 2019 20:41
DevOps Cheat Sheet
##HEROKU
#view running processes
heroku ps -a habitat-api-express
#kill running pid/stuck release
heroku ps:kill release.6104 -a habitat-api-express-staging
@mikepaszkiewicz
mikepaszkiewicz / gist:30c2aacbf6f583a3ddee0c8a54f3a98c
Created October 1, 2019 20:07
installing metabase via docker zip
https://s3.amazonaws.com/downloads.metabase.com/v0.33.3/metabase-aws-eb.zip
@mikepaszkiewicz
mikepaszkiewicz / olo.md
Created April 9, 2018 15:23
Olo integration steps

Docs: https://dispatch-dsp.readme.io/docs Sandbox: https://vanilla.olosandbox.com/menu/dispatch-tryhabitat/

  • Make sure 26 Broadway New York, NY 10004 is in your coverage area to be able to accept orders.

OLO will test the following before turning on integration:

@mikepaszkiewicz
mikepaszkiewicz / gist:69d4556172c2d8aa2a3b5e90f677eb39
Created April 6, 2018 20:19
Docs: https://dispatch-dsp.readme.io/docs
Sandbox: https://vanilla.olosandbox.com/menu/dispatch-tryhabitat/
- _Make sure 26 Broadway New York, NY 10004 is in your coverage area to be able to accept orders._
OLO will test the following before turning on integration:
- [x] Get quote by pickup time (https://dispatch-dsp.readme.io/v1.0/reference#request-quote)
- [x] Get quote by dropoff time (https://dispatch-dsp.readme.io/v1.0/reference#request-quote)
- [x] Make sure a delivery goes all the way through to completion
- [x] Ensure we get all required status updates (https://dispatch.dsp.readme.io/v1.0/reference#status-updates)
@mikepaszkiewicz
mikepaszkiewicz / example.geojson
Created March 12, 2018 13:58
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@mikepaszkiewicz
mikepaszkiewicz / gist:1531fc6cec601c4faa5cda94fc6cc0af
Created March 9, 2018 18:49
staging response
{
"deliveryAreas": [
{
"features": [
{
"geometry": {
"coordinates": [
[
[
-73.685302734375,
@mikepaszkiewicz
mikepaszkiewicz / gist:13fcfb104ba6f52ec0c6e16b35b1c80a
Created January 24, 2018 21:44
get uniq runner ids that don't exist
with x as (select users.id, transactions.runner_id, transactions.runner_obj, transactions.created_at from transactions
left outer join users
on users.id = transactions.runner_id
where transactions.runner_id is not null
and users.id is null)
select distinct runner_id from x