Skip to content

Instantly share code, notes, and snippets.

@jakebathman
jakebathman / StateBoundaries.sql
Last active May 31, 2024 15:54
The approximate max/min latitude and longitude for all states and major territories
-- Create the table
CREATE TABLE IF NOT EXISTS `StateBoundaries` (
`State` varchar(10) DEFAULT NULL,
`Name` varchar(255) DEFAULT NULL,
`MinLat` varchar(50) DEFAULT NULL,
`MaxLat` varchar(50) DEFAULT NULL,
`MinLon` varchar(50) DEFAULT NULL,
`MaxLon` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@mobilemind
mobilemind / git-tag-delete-local-and-remote.sh
Last active June 11, 2024 11:25
how to delete a git tag locally and remote
# delete local tag '12345'
git tag -d 12345
# delete remote tag '12345' (eg, GitHub version too)
git push origin :refs/tags/12345
# alternative approach
git push --delete origin tagName
git tag -d tagName
@bradwilson
bradwilson / gist:2229275
Created March 28, 2012 18:41
Scorch PowerShell script for mixed Git/TFS environments
& taskkill /f /im msbuild.exe
if ((get-gitstatus) -ne $null) {
& git clean -xdf -e *.suo -e packages/*
} else {
& tfpt scorch . /recursive /deletes /diff /noprompt /exclude:"*.suo,.\packages"
}