Skip to content

Tech Skills & Beyond ‐ Analytics Group Weekly Meeting

Bill Hereth edited this page Mar 26, 2024 · 9 revisions

Purpose

We will broaden our expertise in the technology and skills necessary to more efficiently and effectively wield data and tools in support of the Wasatch Front Regional Council mission & BEYOND!!!

Meeting Format

  • Passion Points (5-10 minutes) - open forum for quick informal discussion of any exciting new knowledge nuggets from the past week
  • Topic Brainstorming and Prioritization (5 minutes)
  • Discussion (20-30 minutes) - pre-assigned to individual attendee

Passion/Pain Points

Training Topics

Planned Topics (listed in order of planned chronology)

Accordion-style scheduling will expand or contract timing and duration of topic discussion based on input from meeting attendees. If you are not an Analytics Group member and would like to receive notification of the scheduling of a specific topic, please indicate by typing your initials following the topic title.

Topic Presenter Date/Condition
ESRI Dev Summit Follow-up Josh Mar 26, 2024
Chad
ChatGPT v4 vs v3.5 video Bill
Arcpy to Geopandas Review Chris & Chad after CW review
ArcGIS Easter Eggs Sarah
All about the base-ics of Volume and Congestion Forecasting Bill
Discrete Math Bert
Discrete Choice Model Estimation Overview Andy
Cube 2023 (CubePy, Geodatabases, Format Conversion) Chad
Big Query to JSON google script Bill

Potential Topics (no specific order)

  • Pivot Tables—Excel, R, Python
  • Google Sheets Python API
  • Javascript/HTML
  • Web Server
  • ArcGIS Javascript API
  • ArcGIS Online Python API
  • Debugging
  • GitHub
  • Statistics
  • Voyager
  • Python objects
  • pandas
  • arcpy
  • Shiny
  • Setting up REMM
  • BigQuery Python API
  • Google Cloud Console Intro
  • JSON
  • MySQL on Web Server
  • MatSim
  • MS Access
  • PHP
  • iGraph
  • Web accessibility (Sarah)
  • Tile caching in Web Maps
  • PandaNAs
  • …and more

Branding

When effectively using the following branding techniques, we can increase interest and hype of the mission of the Tech Skills & Beyond meetings.

Say It with Style

When saying the name Tech Skills & Beyond, keep in mind that it resembles that of retailer Bed Bath & Beyond. (The logo further emphasizes this similarity.) Just as Bed does not modify Bath, Tech does not modify Skills, but rather is a shortened version of the noun Technology. Additionally, further embellishment of & Beyond is only natural given Toy Story’s pop culturalization of these words. With these in mind, when saying Tech Skills & Beyond, please utilize the following vocal techniques:

  1. Despite the lack of a comma after Tech, a slight pause should be taken before proceeding to Skills. At a minimum, the pause can be about as long as a typical comma. However for additional emphasis, the pause should be significantly lengthened. This length should be also applied to the pause after the word Skills resulting in the following cadence: Tech… Skills… & Beyond. The longer the duration of the pause, the greater the need for technique #2.

  2. In an effort to utilize pop culture as an effective branding technique, increased emphasis should be applied to the words & Beyond. As a guide, follow the cadence and intonation of Buzz Lightyear as presented in Pixar’s Toy Story movies when he emphatically states his iconic catchphrase: To infinity and beyond! Remember, the increased emphasis of & Beyond necessitates elongation of the pauses described in technique #1. When combined with technique #1, you can easily sound dope like a millennial wannabe.

Express It Cross-Lingually

Besides being fun for technical polyglots, dropping an occasional non-English version of Tech Skills & Beyond can demonstrate our desire to seek learning from the breadth of human technical experience.

Pending confirmation by native speakers, here are the official meeting names in various languages:

Programming/Scripting/Markup Languages

  • C: #include <stdio.h> ...
  • Java: import java.io.*; ...
  • JavaScript: console.log("Tech Skills & Beyond");
  • HTML: <!DOCTYPE html> ...
  • MATLAB: disp("Tech Skills & Beyond");
  • PHP: echo("Tech Skills & Beyond");
  • Python: print("Tech Skills & Beyond")
  • R: cat('Tech Skills & Beyond')
  • Scala: object TechSkillsBeyond extends App { ...
  • VBA: Private Sub Document_Open() ...

Foreign languages

  • Chinese: 技术技能等
  • German: Technologie Fähigkeiten und noch viel weiter
  • Guarani: Tembiporu pyahu Katupyrykuéra ha hetave mba’e
  • Hawaiian: ʻenehana akamai a oi aku
  • Japanese: 技術力など
  • Korean: 기술적 능력과 그 너머
  • Maori: Hangarau Pukenga me etahi atu
  • Portuguese: Tecnologia Habilidades e mais além
  • Spanish: Tecnología Habilidades y más allá
  • Swahili: Teknolojia Ujuzi na zaidi

Passion/Pain Points Archive

  • Suzie: Save mtx to csv within Cube
  • Bill: TDM.py function to get value from control center
  • Suzie: Customizing Cube link and node attribute display
  • Josh: Let them eat Pickles!
  • Chris: Function collection for python https://www.acgeospatial.co.uk/running-functions-juypter/
  • Bill: code block in Google Chat: [paste as plain text]
  • Bill: Plotly multi-select widget quick demo!!! (youtube tutorial)
  • Chris: Getting around Windows file path max length in python
  • Chris: Getting around Windows file path max length in git
  • Josh: Bankers Rounding
  • Chris: Leaflet interactive
  • Bill: Non Repeating widgets
  • Josh: NaN
  • Josh: QGIS geospatial functions & pyscript
  • Sarah: Bias in mapping
  • Bill: vs code spell checker: Spell Right
  • Bill: quarto iframe
  • Chris: Github TDM Model Development Workflow
  • Sarah: AI generated images, Adobe AI generative fill, license to Canva
  • Chris: Scenario Name cannot begin with “T” “t” “N” or “n”. \t and \n escape characters
  • Bill: ref chatgpt https://chat.openai.com/share/d127492a-ad78-4f45-afd0-50e29069db1a
  • Bill: Relative path copy from File Explorer to VS Code jupyter notebook!
  • Josh: Visual Studio Code CTRL+D to multiselect
  • Bill: Compare two GitHub releases
  • Chris: www.utahmug.org
  • Bill: Access webmap renderer for layer (example) and JSON formatter
  • Chris: Should Chris Day get a PE? – responses from TMIP
  • Chris: pip freeze –> requirements.txt – creates a text file listing all version numbers
  • Andy: pandas read_html to read in
  • Chris: Send email via python
  • Chris: Create “contained” html map with photo popups
  • Andy: Geopandas Code
  • Sarah: Mars Settlement Activity
  • Bert: Toggle to switch from Web Mercator to UTM 12 in ArcGisPro
  • Bill: Explode dataframe
  • Bill: exclude variable from variable list with “_” in python
  • Bill: http://geojson.io/
  • Sarah: GIS Galaxy Quest
  • Bill: Google Chat upgrading spaces organized by topics to inline threaded spaces
  • Chris: Decrease load time by simplifying geographies
  • Chris: Simplifying Polygons
  • Josh: Visual Studio Code - Jump to matching “(“, “{“, “[“ Hotkey - (Ctrl + Shift + )
  • Bill: ArcGIS Pro Transfer attributes
  • Josh/Sarah: Color Blindness Simulator in Pro
  • Chris: Saving to a File Geodatabase in R
  • Chris: Simply Features in R
  • Bill: Javascript spread operator (Spread Operator in JS | Simplified in 5 minutes)
  • Bill: Live Server in vsCode
  • Bert: SLUG Presentation
  • Josh: ESRI Dev Summit (Ask a developer)
  • Josh: Call for new TSB logo ideas
  • Sarah: AGOL Clean-up update
  • Bill: Beware the rename-file commits!
  • Bill: Cube Voyager Tips and Tricks Wiki!!
  • Bill: geopandas shapefile read include_fields
  • Sarah: https://cartography-playground.gitlab.io/playgrounds/cartographic-generalization/

Training Topics Archive

Topic Presenter Date
Setting up a Python Environment Josh Nov 22, 2022
Setting up a Visual Studio Code IDE Josh Nov 29, 2022
ArcGIS Pro Tips & Tricks Matthew Dec 6, 2022
ArcGIS Web AppBuilder Intro (doc) Bill Dec 13-20, 2022
Plotter FAQ Matthew Dec 20, 2022
TDM Folder Structure Suzie January 17, 2023
Setting Up a TDM Scenario Suzie January 24, 2023
Google O/D Speed API Andy February 7, 2023
RStudio Intro Chris February 14, 2023
Python lambda Bill/Chris February 21, 2023
Python list comprehensions & Python Index Josh February 28, 2023
Google App Scripts Bert March 7, 2023
Quarto Chris April 4, 2023
geopandas vs arcpy Josh April 18, 2023
Symbology and Colors Sarah April 25, 2023
geopandas vs sf Chris May 9, 2023
Observable JS Bill May 16, 2023
Intro to Real Estate Market Model (REMM) Andy May 23, 2023
Traffic Volume Bill June 6 & 27, 2023
Popsim in REMM (popgen?) Andy July 18, 2023
Adobe AI Generative Fill Sarah July 25, 2023
Managing ArcGIS Online content with Python Josh July 25, 2023
Web AppBuilder Bill August 1, 2023
GitHub Pages Website with jekyll Bill August 15, 2023
Owned-Unit Grouping Toolbox Lilah August 22, 2023
Behind the Scenes: Wasatch Choice Bert September 19, 2023
Passion Points Andy/Chris September 26, 2023
TDM Documentation Chad October 10, 2023
UTC Practice Presentation Bill/Chris/Josh October 17, 2023
ArcGIS Jupyter Notebook Segment Shapefile Processing Chris October 31, 2023
Housing Data Update Josh November 14, 2023
Household Travel Survey Shiny Interface Chris November 28, 2023
Plotting (by invitation only, Hugh, Josh, Chris, Andy, Jordon) Sarah December 12, 2023
Housing App Demo Josh December 19, 2023
Part 1: TRB Report Chris January 16, 2024
Part 2: Request Tracker… Goodbye wishes! Hello Results! Bert/Bill January 16, 2024
ArcGIS Online Cleanup Sarah February 6, 2024
Passion Point Potpourri All February 13, 2024
Mentimeter Survey Test Bill February 20, 2024