Skip to content

Instantly share code, notes, and snippets.

@talllguy
Last active August 29, 2015 14:01
Show Gist options
  • Save talllguy/148e322aee68febbaa91 to your computer and use it in GitHub Desktop.
Save talllguy/148e322aee68febbaa91 to your computer and use it in GitHub Desktop.
Expands fields in Md DNR data
CASE WHEN name = 'SF' THEN 'State Forest'
WHEN name = 'FMA' THEN 'Fish Management Area'
WHEN name = 'FT' THEN 'Fire Tower'
WHEN name = 'SP' THEN 'State Park'
WHEN name = 'CFL' THEN 'Chesapeake Forest Lands'
WHEN name = 'NRMA' THEN 'Natural Resource Management Area'
WHEN name = 'NEA' THEN 'Natural Environment Area'
WHEN name = 'WMA' THEN 'Wildlife Management Area'
WHEN name = 'HCF' THEN 'Heritage Conservation Fund Site'
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment