bixb0012

#!python
# Reference: 1) https://pro.arcgis.com/en/pro-app/arcpy/functions/describe.htm
#            2) https://pro.arcgis.com/en/pro-app/tool-reference/data-management/add-field.htm
#            3) https://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field.htm

import arcpy

# Example 1: Adding path attribute for tables and feature classes in workspace (ArcMap and Pro compatible)
workspace = # Workspace containing feature classes

bixb0012

#!python
# Reference: 1) https://pro.arcgis.com/en/pro-app/arcpy/data-access/walk.htm
#            2) https://pro.arcgis.com/en/pro-app/arcpy/functions/describe.htm
#            3) https://docs.python.org/3/library/os.path.html

import arcpy
import os

gdb = # Path to geodatabase

bixb0012

bixb0012

#Requires -Version 5.1
# Reference: 1) https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_regular_expressions
# Reference: 2) https://docs.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference

$TestEmailFrom = @(
    "smokey.bear@usda.gov"
    "  smokey.bear@usda.gov    "
    "<smokey.bear@usda.gov>"
    " <  smokey.bear@usda.gov  > "
    "Smokey Bear <smokey.bear@usda.gov>"

bixb0012

#Requires -Version 5.1
# Reference: 1) https://docs.microsoft.com/en-us/dotnet/api/system.net.servicepointmanager
# Reference: 2) https://docs.microsoft.com/en-us/dotnet/api/system.net.security.remotecertificatevalidationcallback


# Example 1: Force TLS 1.2 connections from client
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

# Example 2: Ignore all SSL/TLS policy errors, e.g., ignore SSL/TLS secure channel errors 
#            from self-signed certificates

bixb0012

#Requires -Version 5.1
# Reference: 1) https://docs.microsoft.com/en-us/dotnet/api/system.security.principal

# Example 1: Retrieve security identifier value (SID) for an NT account
# Adapted from https://devblogs.microsoft.com/scripting/use-powershell-to-translate-a-users-sid-to-an-active-directory-account-name/
$DomainName = ""   # Domain of account, commonly $Env:USERDOMAIN
$AccountName = ""  # Name of account, commonly $Env:USERNAME

$NTAccount = [Security.Principal.NTAccount]::New($DomainName, $AccountName)
$Sid = ($NTAccount.Translate([Security.Principal.SecurityIdentifier])).Value

bixb0012

#!python3
# Reference: 1) https://docs.python.org/3/library/stdtypes.html#special-attributes

# Example 1:  Function to print base class or subclass hierarchies
def print_classtree(cls, bases=True, level=0):
    print(f"{'-'*2*level} {cls}")
    if bases:
        classes = cls.__bases__
    else:
        classes = cls.__subclasses__()

bixb0012

# Reference: 1) https://mkleehammer.github.io/pyodbc
#            2) https://docs.python.org/3/library/re.html#regular-expression-objects

import pyodbc
import re

driver_regexes = {
    "mssql": ("ODBC Driver.*SQL Server", "SQL Server Native Client.*"),
    "oracle": ("Oracle in.*")
}

bixb0012

#Requires -Version 5.1
# Reference: 1) https://docs.microsoft.com/en-us/dotnet/api/system.collections.arraylist
# Reference: 2) https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.stopwatch
# Reference: 3) https://docs.microsoft.com/en-us/dotnet/api/system.io.filestream

# Example 1: Copy file and measure combined (read & write) transfer rate over time
$FilePath = ""      # Path of the file to copy
$Destination= ""    # Path to the new directory or folder
$BufferSize = 64    # Buffer size, in KB, for copying file

bixb0012

#!python2
# Example 1a adapted from https://www.reddit.com/r/gis/comments/4rhvhh/map_automation_arcpymapping_make_lyr/
#
# Reference: 1) http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-mapping/layer-class.htm
#            2) https://docs.python.org/2/library/json.html

import arcpy
import json

lyr = # Layer object, typically from arcpy.mapping.ListLayers (arcpy._mapping.Layer)