Skip to content

Instantly share code, notes, and snippets.

@raykendo
raykendo / mssql_connect.py
Created September 17, 2020 19:55
Connecting To SQL Server using Python 3
#!/usr/bin/env python3
# an example of connecting to a SQL Server database using Python 3
# automatically closes the db connection after use
import pyodbc
from contextlib import contextmanager
# pyodbc wiki: https://github.com/mkleehammer/pyodbc/wiki
# example based on https://docs.microsoft.com/en-us/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-ver15
@raykendo
raykendo / viewGoogleMaps.py
Created February 19, 2020 05:54
A Python Script for automating looking up addresses on Google Maps
#!/usr/bin/python
# viewGoogleMaps.py
# author: Ken Doman (github.com/raykendo)
# purpose: Looking up addresses through Google Maps automagically
# requirements: python 2 or 3, selenium for python
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
@raykendo
raykendo / file.js
Last active March 14, 2018 21:02
Throttle Ajax Requests
(function () {
// ajax function from https://gist.github.com/Xeoncross/7663273
function ajax(url, callback, data, x) {
try {
x = new (this.XMLHttpRequest || ActiveXObject)("MSXML2.XMLHTTP.3.0");
x.open(data ? "POST" : "GET", url, 1);
x.setRequestHeader("X-Requested-With", "XMLHttpRequest");
x.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
x.onreadystatechange = function () {
@raykendo
raykendo / file.js
Last active January 15, 2018 20:39
Get URL query or hash parameter
(function () {
//source: https://stackoverflow.com/questions/901115/how-can-i-get-query-string-values-in-javascript
// modified to also check hash
function getParameterByName(name, url) {
if (!url) url = window.location.href;
name = name.replace(/[\[\]]/g, "\\$&");
var regex = new RegExp("[?#&]" + name + "(=([^&#]*)|&|#|$)"),
results = regex.exec(url);
if (!results) return null;
if (!results[2]) return '';
@raykendo
raykendo / delete-stuff2.py
Last active August 16, 2017 17:00
Removing junk files from a folder recursively (Python)
#!/usr/bin/env python
#
# delete-stuff2.py: delete specific files and folders within subdirectories of a folder.
# by raykendo
# Python 2.7+
#
import os
import stat
import sys
@raykendo
raykendo / example.js
Created February 16, 2017 23:29
Getting max distance between a shape and a reference point
(function () {
"use strict";
//...
/**
* defining {object} point
* @property {number} x - x coordinate for the point.
* @property {number} y - y coordinate for the point.
*/
@raykendo
raykendo / CleanWebMapRequest.js
Created February 10, 2017 17:01
Cleaning Export Web Map request plugin
/**
* Some people just need a paper map. ArcGIS Server provides a service to turn a web map into an image, pdf, or other file
* The process to generate these documents can be long and intensive (in relative web terms), taking up to 2 minutes to generate
* a document.
*/
/* globals: define*/
define([
"dojo/_base/lang",
"dojo/_base/array",
"dojo/json",
@raykendo
raykendo / index.html
Last active September 23, 2016 15:48
Mapillary JS + ArcGIS JavaScript API 4.x Example
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Mapillary-JS + ArcGIS JSAPI 4.x example</title>
<link rel="stylesheet" href="https://unpkg.com/mapillary-js@1.7.1/dist/mapillary-js.min.css">
<link rel="stylesheet" href="https://js.arcgis.com/4.0/esri/css/main.css">
<script type="text/javascript">
dojoConfig = {
async: true,
@raykendo
raykendo / index.html
Last active September 23, 2016 15:47
Mapillary JS + ArcGIS JavaScript API 3.x
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Mapillary-JS + ArcGIS JSAPI 3.x example</title>
<link rel="stylesheet" href="https://unpkg.com/mapillary-js@1.7.1/dist/mapillary-js.min.css">
<link rel="stylesheet" href="https://js.arcgis.com/3.17/esri/css/esri.css">
<script type="text/javascript">
dojoConfig = {
async: true,
@raykendo
raykendo / swt_linkedin1.md
Last active August 23, 2016 21:40
Saving you some embarrassment on LinkedIn with this console tip

Browser console tips

LinkedIn - People I don't know

Current date: 2016-08-23

I'm one of those people who still holds on to the hope that LinkedIn is a good idea. I check in daily and check all the areas I've been trained to look at on most social media sites.

The thing that annoys me about LinkedIn is the "People you may know" page. That long list of your contacts' third cousins, college buddies, and other total strangers. They've designed the page so that you'll accidentally click on one of those strangers, causing an embarrasing incident.

"I'm not really interested in hiring a life-coach at my company right now. Sorry to get your hopes up."