Skip to content

Instantly share code, notes, and snippets.

View ajar's full-sized avatar
❤️

Aaron Artille ajar

❤️
View GitHub Profile
@ajar
ajar / tz-iana-windows.sql
Created June 11, 2020 17:19
Time Zone Names: IANA to Windows (SQL)
--
-- CSV Version: https://gist.github.com/ajartille/edf12d78dce099a522df531c197eadf7
-- Data Source: https://github.com/mj1856/TimeZoneConverter
--
create table #temptable (
[IANA] varchar(100),
[Windows] varchar(100)
);
@ajar
ajar / tz-iana-windows.csv
Created June 11, 2020 17:11
Time Zone Names: IANA to Windows (CSV)
IANA Windows
Africa/Abidjan Greenwich Standard Time
Africa/Accra Greenwich Standard Time
Africa/Algiers W. Central Africa Standard Time
Africa/Bissau Greenwich Standard Time
Africa/Cairo Egypt Standard Time
Africa/Casablanca Morocco Standard Time
Africa/Ceuta Romance Standard Time
Africa/El_Aaiun Morocco Standard Time
Africa/Johannesburg South Africa Standard Time
@ajar
ajar / US Zip Code Geolocations from 2018 Government Data
Created April 23, 2020 15:55 — forked from abatko/US Zip Code Geolocations from 2018 Government Data
All US zip codes with their corresponding geolocations (latitude and longitude coordinates). Comma delimited for your database goodness. Source: https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html > ZIP Code Tabulation Areas > Download the ZIP Code Tabulation Areas Gazetteer File
This file has been truncated, but you can view the full file.
ZIP,LAT,LNG
00601,18.180555, -66.749961
00602,18.361945, -67.175597
00603,18.455183, -67.119887
00606,18.158327, -66.932928
00610,18.295366, -67.125135
00612,18.402253, -66.711397
00616,18.420412, -66.671979
00617,18.447538, -66.557681
00622,17.991245, -67.153993
@ajar
ajar / heck.xml
Created October 7, 2018 09:27
Report domain: ajar.org Submitter: google.com Report-ID: 12726966065438582950
<?xml version="1.0" encoding="UTF-8" ?>
<feedback>
<report_metadata>
<org_name>google.com</org_name>
<email>noreply-dmarc-support@google.com</email>
<extra_contact_info>https://support.google.com/a/answer/2466580</extra_contact_info>
<report_id>12726966065438582950</report_id>
<date_range>
<begin>1538784000</begin>
<end>1538870399</end>
@ajar
ajar / 1_Tiny_Content_Framework.md
Created September 22, 2018 15:56 — forked from nicoleslaw/1_Tiny_Content_Framework.md
Tiny Content Framework

Tiny Content Framework

About the project

This is a tiny content strategy framework focused on goals, messages, and branding. This is not a checklist. Use what you need and scrap the rest. Rewrite it or add to it. These topics should help you get to the bottom of things with clients and other people you work with.

Give me feedback on Twitter (@nicoleslaw) or by email (nicole@nicolefenton.com).

Contents

Keybase proof

I hereby claim:

  • I am ajartille on github.
  • I am ajar (https://keybase.io/ajar) on keybase.
  • I have a public key ASBgb07BRfJl071dUMCMYWqGt60Fwmx90qhh6YUC9tcRpAo

To claim this, I am signing this object:

@ajar
ajar / keybase.md
Created September 8, 2018 14:48
keybase.md

Keybase proof

I hereby claim:

  • I am ajartille on github.
  • I am ajar (https://keybase.io/ajar) on keybase.
  • I have a public key whose fingerprint is 0269 4BE4 FBA8 551B 5BB2 7928 F8F7 61A0 C280 80C1

To claim this, I am signing this object:

@ajar
ajar / keybase.md
Created January 26, 2017 01:23
keybase.md

Keybase proof

I hereby claim:

  • I am ajartille on github.
  • I am ajar (https://keybase.io/ajar) on keybase.
  • I have a public key ASBG6AOPCaVHLPDJfhBCNIzPdEtP2QfPVmW8aP9yCcriUAo

To claim this, I am signing this object:

@ajar
ajar / file1.txt
Created September 2, 2015 14:34
the description for this gist
String file contents
* File A is a versioned file. Each version is notated A[n].
* A[n] is a valid version of A if and only if ...
... A[n-1].next == ripemd160(sha256(A[n].uuid))
... or if A[n] is A[0]
* That is, the UUID of any A version A[n] must have the
RIPEMD160 hash sum OF the SHA256 hash sum that
is equal to the `next` value of the prior A version A[n-1].