Skip to content

Instantly share code, notes, and snippets.

View ronaldbradford's full-sized avatar

Ronald Bradford ronaldbradford

58 followers · 40 following
View GitHub Profile
@ronaldbradford
ronaldbradford / perschema.sql
Created November 18, 2022 19:12
MySQL Per Schema Table Stats
################################################################################
# Name : perschema.sql
# Purpose : List details of the specific schema
# Author : Ronald Bradford http://ronaldbradford.com
# Version : 2 03-June-2009
################################################################################
SELECT NOW(), VERSION();
# Per Schema Queries
@ronaldbradford
ronaldbradford / rds-kms-policy.json
Created November 15, 2022 15:59
AWS KMS Policy for RDS Access
{
"Version": "2012-10-17",
"Statement": {
"Effect": "Allow",
"Action": [
"kms:CreateKey",
"kms:TagResource",
"kms:CreateAlias"
],
"Resource": "*"
@ronaldbradford
ronaldbradford / INSTALL.md
Last active November 15, 2022 15:57
MacOS Installation

Commands

  chmod +x ./install.sh
  ./install.sh
  # Note some commands are interactive

Installed

@ronaldbradford
ronaldbradford / 30daymapchallenge-polygons.ipynb
Created November 6, 2022 14:29
30 Day Map Challenge - Polygons
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ronaldbradford
ronaldbradford / green-map.html
Last active November 6, 2022 03:36
30 Day Map Challenge - Color Day - Green
<!DOCTYPE html>
<html>
<head>
<title>30DayMapChallenge #Green</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<script src="https://cdn.jsdelivr.net/npm/svg-pan-zoom@3.6.1/dist/svg-pan-zoom.min.js"></script>
@ronaldbradford
ronaldbradford / 30daymapchallenge-lines.ipynb
Created November 3, 2022 15:30
30daymapchallenge-lines.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ronaldbradford
ronaldbradford / aws-region-locations.tsv
Created November 3, 2022 14:13
AWS Regions with locations and positions
provider region city country lat lng
AWS us-east-1 Richmond United States 37.5295 -77.4756
AWS us-east-2 Columbus United States 39.9862 -82.985
AWS us-west-1 Sacramento United States 38.5667 -121.4683
AWS us-west-2 Salem United States 44.9231 -123.0246
AWS us-gov-east-1 Richmond United States 37.5295 -77.4756
AWS us-gov-west-1 Sacramento United States 38.5667 -121.4683
AWS af-south-1 Cape Town South Africa -33.925 18.425
AWS ap-east-1 Hong Kong Hong Kong 22.3069 114.1831
AWS ap-southeast-3 Jakarta Indonesia -6.2146 106.8451
@ronaldbradford
ronaldbradford / 30daymapchallenge-points.ipynb
Last active November 2, 2022 15:13
30daymapchallenge-points.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ronaldbradford
ronaldbradford / au-city.csv
Created November 2, 2022 14:19
Australian City Locations - https://simplemaps.com/data/au-cities
city lat lng country iso2 admin_name capital population population_proper
Sydney -33.8650 151.2094 Australia AU New South Wales admin 5312163 4840600
Melbourne -37.8136 144.9631 Australia AU Victoria admin 5078193 4529500
Brisbane -27.4678 153.0281 Australia AU Queensland admin 2514184 2360241
Perth -31.9522 115.8589 Australia AU Western Australia admin 2059484 2039200
Adelaide -34.9289 138.6011 Australia AU South Australia admin 1345777 1295714
Gold Coast -28.0167 153.4000 Australia AU Queensland 679127 638090
Cranbourne -38.0996 145.2834 Australia AU Victoria 460491 39419
Canberra -35.2931 149.1269 Australia AU Australian Capital Territory primary 426704 381488
Newcastle -32.9167 151.7500 Australia AU New South Wales 322278 152984
@ronaldbradford
ronaldbradford / CT.geojson
Created October 11, 2022 17:08
Connecticut Map
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.