Канал: Grant's Crime Lab

New Role - Update

New Role - Update

ArcGIS Pro: Layer to KML

ArcGIS Pro: Layer to KML

ArcGIS Pro: Custom Sort

ArcGIS Pro: Custom Sort

Excel: Date Creation from Day of Year Number

Excel: Date Creation from Day of Year Number

SPSS: Frequencies

SPSS: Frequencies

SPSS: Date and Time Wizard

SPSS: Date and Time Wizard

CrimeStat IV: Primary File and Spatial Descriptives

CrimeStat IV: Primary File and Spatial Descriptives

CrimeStat IV: Introduction & How to Download

CrimeStat IV: Introduction & How to Download

SPSS: Introduction & How to Open a Dataset

SPSS: Introduction & How to Open a Dataset

Excel: =SWITCH function to recode

Excel: =SWITCH function to recode

Excel: =UNIQUE function to generate list

Excel: =UNIQUE function to generate list

ArcGIS Pro: Multiple Spatial Joins for Counts to Identify Top Neighborhoods

ArcGIS Pro: Multiple Spatial Joins for Counts to Identify Top Neighborhoods

ArcGIS Pro: How to Dissolve Street Layer and then Planarize

ArcGIS Pro: How to Dissolve Street Layer and then Planarize

ArcGIS Pro: Generate Near Table to move offset crime points to street centerline

ArcGIS Pro: Generate Near Table to move offset crime points to street centerline

Beyond Crime Data: CDC PLACES Local Data for Better Health - Zip Code Example (ZCTA)

Beyond Crime Data: CDC PLACES Local Data for Better Health - Zip Code Example (ZCTA)

Sp23 In-Class: ArcGIS Pro - Adding Field to Calculate Block Group Crime Rates

Sp23 In-Class: ArcGIS Pro - Adding Field to Calculate Block Group Crime Rates

ArcGIS Pro: Using the 80-20 Tool for Law of Crime Concentration

ArcGIS Pro: Using the 80-20 Tool for Law of Crime Concentration

Sp23 In-Class: ArcGIS Pro Buffer & KDE (hotspot)

Sp23 In-Class: ArcGIS Pro Buffer & KDE (hotspot)

Sp23 In-Class Week 11: ArcGIS Pro - Tools and Average Nearest Neighbor

Sp23 In-Class Week 11: ArcGIS Pro - Tools and Average Nearest Neighbor

Sp23 Assignment 8: ArcGIS Pro Table & Spatial Join

Sp23 Assignment 8: ArcGIS Pro Table & Spatial Join

Sp23 Assignment #7: ArcGIS Pro Select by Attribute and Location

Sp23 Assignment #7: ArcGIS Pro Select by Attribute and Location

Google Scholar: Quick Searches, Saving, and Making Libraries

Google Scholar: Quick Searches, Saving, and Making Libraries

Sp23 In-Class Week10: Geocoding Crime Incidents and Calculating Crime Rates per Block Group

Sp23 In-Class Week10: Geocoding Crime Incidents and Calculating Crime Rates per Block Group

Sp23 In-Class Week9: ArcGIS Pro - Example - How to do a Table and Spatial Join

Sp23 In-Class Week9: ArcGIS Pro - Example - How to do a Table and Spatial Join

Excel: How to Rank Values

Excel: How to Rank Values

Sp23 In-Class Week 7: Select By Location & Attributes

Sp23 In-Class Week 7: Select By Location & Attributes

Sp23 Week 6: ArcGIS Pro Selecting by Attribute and Exporting Feature

Sp23 Week 6: ArcGIS Pro Selecting by Attribute and Exporting Feature

Sp23 In-Class Week 5: Excel to ArcGIS Pro

Sp23 In-Class Week 5: Excel to ArcGIS Pro

Sp23: Assignment 2 Walk-through

Sp23: Assignment 2 Walk-through

Sp23 In-Class Week 4: Mapping Social Data at State and County Levels in Excel

Sp23 In-Class Week 4: Mapping Social Data at State and County Levels in Excel

Sp23 In-Class Week 4: Custom Regions - Policing Districts

Sp23 In-Class Week 4: Custom Regions - Policing Districts

Sp23 In-Class Week 4: Point Map with 3D Mapping in Excel

Sp23 In-Class Week 4: Point Map with 3D Mapping in Excel

Calculating Crime Rates based on Agency/City for NIBRS

Calculating Crime Rates based on Agency/City for NIBRS

ChatGPT: Take 2 Potential Uses

ChatGPT: Take 2 Potential Uses

Sp23: Assignment1 Walk-Through

Sp23: Assignment1 Walk-Through

Sp23 In-Class Week 2: Temporal Data in Excel

Sp23 In-Class Week 2: Temporal Data in Excel

Sp23 In-Class Week 1: CSV to Workbook, Sorting, Filtering, Copy & Paste, and Snipping

Sp23 In-Class Week 1: CSV to Workbook, Sorting, Filtering, Copy & Paste, and Snipping

Excel: Merging Datasets with Power Queries

Excel: Merging Datasets with Power Queries

Excel: Index and Match to Join Data (alternative to VLOOKUP)

Excel: Index and Match to Join Data (alternative to VLOOKUP)

ArcPro: Zonal Statistics from Crime Kernel Density Estimation (Hotspot Map)

ArcPro: Zonal Statistics from Crime Kernel Density Estimation (Hotspot Map)

Excel: Statistic Formulas Available in Formulas Tab

Excel: Statistic Formulas Available in Formulas Tab

Excel: Selecting Blank Cells and Filling Down Values

Excel: Selecting Blank Cells and Filling Down Values

ArcPro: Creating a Kernel Density (hotspot) Map and Converting to Point

ArcPro: Creating a Kernel Density (hotspot) Map and Converting to Point

ArcGIS in Excel: Symbology & Multiple Layers

ArcGIS in Excel: Symbology & Multiple Layers

LEARCAT: Law Enforcement Agency Reported Crime Analysis Tool

LEARCAT: Law Enforcement Agency Reported Crime Analysis Tool

Excel 3D Map displaying the Movement of a Firearm in Chattanooga

Excel 3D Map displaying the Movement of a Firearm in Chattanooga

Philadelphia DAO Example - Monthly Counts of Incidents, Arrests, Charges

Philadelphia DAO Example - Monthly Counts of Incidents, Arrests, Charges

By Hand Example: Mean - Median - Standard Deviation - Z Score

By Hand Example: Mean - Median - Standard Deviation - Z Score

ArcGIS Pro: New Select based on a Selected Feature

ArcGIS Pro: New Select based on a Selected Feature

Blank Text Values in Excel - Conditional Formatting to Delete

Blank Text Values in Excel - Conditional Formatting to Delete

Textafter & Textbefore in Excel to Extract Cell Contents

Textafter & Textbefore in Excel to Extract Cell Contents

Standard Deviation & Range in Excel - Crime Counts - Social Data & Analysis F22 Week 3

Standard Deviation & Range in Excel - Crime Counts - Social Data & Analysis F22 Week 3

Mean & Median in Excel - Crime Counts - Social Data & Analysis F22 Week 2

Mean & Median in Excel - Crime Counts - Social Data & Analysis F22 Week 2

Excel Crime & Place: IACA Workshop Video

Excel Crime & Place: IACA Workshop Video

Using Excel VLOOKUP to Assign Latitude and Longitude

Using Excel VLOOKUP to Assign Latitude and Longitude

ArcGIS Add-In for Excel

ArcGIS Add-In for Excel

Significant Change in Crime in Little Rock

Significant Change in Crime in Little Rock

Identifying Significant Change Over Time with Crime Counts

Identifying Significant Change Over Time with Crime Counts

Spatial Joining Polygon Tract GEOID to Point Crime Data - Chattanooga

Spatial Joining Polygon Tract GEOID to Point Crime Data - Chattanooga

Crime Analysis with West Memphis - Introduction

Crime Analysis with West Memphis - Introduction

Introduction

Introduction

ArcGIS Pro Clipping, Table Join, Spatial Join, & Statistics

ArcGIS Pro Clipping, Table Join, Spatial Join, & Statistics

ArcGIS Pro Clip

ArcGIS Pro Clip

ArcGIS Pro Buffers and Multiple Ring Buffers

ArcGIS Pro Buffers and Multiple Ring Buffers

Google Street View - Systematic Social Observation with Google Forms

Google Street View - Systematic Social Observation with Google Forms

ArcGIS Pro Table Join and Spatial Join

ArcGIS Pro Table Join and Spatial Join

ArcGIS Pro Select by Location - Within and Within Distance

ArcGIS Pro Select by Location - Within and Within Distance

ArcPRO Select by Attribute - Export - Labels

ArcPRO Select by Attribute - Export - Labels

Excel Pivot Table - Percent Row Total & Column Total

Excel Pivot Table - Percent Row Total & Column Total

ArcPRO Select by Attribute & Export Feature

ArcPRO Select by Attribute & Export Feature

Creating a Final Map in ArcPRO with Crime Data

Creating a Final Map in ArcPRO with Crime Data

Excel Countif and Sumif Formulas

Excel Countif and Sumif Formulas

Pivot Tables with Time and Date Fields in Excel

Pivot Tables with Time and Date Fields in Excel

Mapping State and County Level Data in Excel

Mapping State and County Level Data in Excel

Percent Change - Crime Statistics in Excel

Percent Change - Crime Statistics in Excel

Introduction to Excel - Sorting & Filtering

Introduction to Excel - Sorting & Filtering

Chattanooga Police Department - Intelligence Analyst Presentation

Chattanooga Police Department - Intelligence Analyst Presentation

One Sample Z Test Example 2 from Class

One Sample Z Test Example 2 from Class

One Sample Z Test by Hand

One Sample Z Test by Hand

Local Law Enforcement Agencies in the United States - HIFLD

Local Law Enforcement Agencies in the United States - HIFLD

CASDAL Workshop Follow-Up Video: Little Rock Space and Time Examples

CASDAL Workshop Follow-Up Video: Little Rock Space and Time Examples

Creating a PIVOT Table - Temporal Heat Map - Day of Week & Time of Day

Creating a PIVOT Table - Temporal Heat Map - Day of Week & Time of Day

Calculate Z-Score by Hand

Calculate Z-Score by Hand

Excel Data Tools - Remove Duplicates - Consolidate - Text to Columns - Flash Fill

Excel Data Tools - Remove Duplicates - Consolidate - Text to Columns - Flash Fill

Excel XLOOKUP and COUNTIF with NCVS Exercise Data

Excel XLOOKUP and COUNTIF with NCVS Exercise Data

Calculating Mean & Median from 6 Arkansas Cities Census Quick Facts

Calculating Mean & Median from 6 Arkansas Cities Census Quick Facts

Introduction NIBRS - Crime Data Explorer

Introduction NIBRS - Crime Data Explorer

Uniform Crime Reports Data in Excel

Uniform Crime Reports Data in Excel

Block Groups in Excel - Chattanooga Example - Custom Region - Crime Data

Block Groups in Excel - Chattanooga Example - Custom Region - Crime Data

Excel - Sorting and Filtering - Crime Data - Violent Crime Rates in US Cities

Excel - Sorting and Filtering - Crime Data - Violent Crime Rates in US Cities

ArcGIS Pro - Fishnet & KDE

ArcGIS Pro - Fishnet & KDE

Dr. Valasik Guest Presentation on Spatial Research

Dr. Valasik Guest Presentation on Spatial Research

ArcGIS Pro: Multiple Ring Buffer - Average Nearest Neighbor - SDE and MC

ArcGIS Pro: Multiple Ring Buffer - Average Nearest Neighbor - SDE and MC

Excel - Treemap with CAD Data

Excel - Treemap with CAD Data

ArcGIS Pro Geocoding Examples - County & Address

ArcGIS Pro Geocoding Examples - County & Address

ArcGIS Pro - Crime Analysis Toolbox - Summarize Incident Counts

ArcGIS Pro - Crime Analysis Toolbox - Summarize Incident Counts

Far-Right Flashpoints: The Enduring Threat of Violent Extremism in America by Dr. Jeff Gruenewald

Far-Right Flashpoints: The Enduring Threat of Violent Extremism in America by Dr. Jeff Gruenewald

ArcGIS -Pro - Geoprocessing Select Location Clip Dissolve Buffer

ArcGIS -Pro - Geoprocessing Select Location Clip Dissolve Buffer

ArcGIS Pro - Law of Crime Concentration

ArcGIS Pro - Law of Crime Concentration

ArcGIS Pro - Table Join - Spatial Join - Summary Within - Clip

ArcGIS Pro - Table Join - Spatial Join - Summary Within - Clip

Exporting from ArcGIS Pro to Google Earth Web for Storytelling

Exporting from ArcGIS Pro to Google Earth Web for Storytelling

ArcGIS Pro - Create Chart

ArcGIS Pro - Create Chart

ArcGIS Pro Symbology Examples

ArcGIS Pro Symbology Examples

ArcGIS Pro - Legend - Converting to Graphics

ArcGIS Pro - Legend - Converting to Graphics

ArcGIS Pro - Day 1

ArcGIS Pro - Day 1

Introduction to Social Explorer

Introduction to Social Explorer

Google Trends Example

Google Trends Example

Google Geocoding

Google Geocoding

SSO Google Earth Walk-Through

SSO Google Earth Walk-Through

Neighborhoods in Excel - Custom Region Mapping

Neighborhoods in Excel - Custom Region Mapping

Law of Crime Concentration in Excel

Law of Crime Concentration in Excel

Mapping Different Spatial Levels in Excel

Mapping Different Spatial Levels in Excel

Excel Pareto - 80/20 Rule - Risky Facilities

Excel Pareto - 80/20 Rule - Risky Facilities

Excel VBA for Geocoding with Google

Excel VBA for Geocoding with Google

Excel Basics for Social Data

Excel Basics for Social Data

Excel: Regression

Excel: Regression

Spatial Research - Class Overview November 2020

Spatial Research - Class Overview November 2020

Excel: Correlation

Excel: Correlation

Excel ANOVA

Excel ANOVA

Excel: Pivot Table - Temporal Heat Map

Excel: Pivot Table - Temporal Heat Map

Excel: Chi-Square test

Excel: Chi-Square test

Excel: 3D Mapping Example

Excel: 3D Mapping Example

Excel: Descriptive Statistics

Excel: Descriptive Statistics

By-Hand: Independent Sample t-Test

By-Hand: Independent Sample t-Test

By-Hand: One Sample Z-Test

By-Hand: One Sample Z-Test

Excel: t-Test (Independent & Dependent)

Excel: t-Test (Independent & Dependent)

Excel: One Sample Z-Test

Excel: One Sample Z-Test

By-Hand: Z-Score Calculation

By-Hand: Z-Score Calculation

Excel: Calculating Z-Scores

Excel: Calculating Z-Scores

By-Hand: Calculating Standard Deviation

By-Hand: Calculating Standard Deviation

Excel: Range & Standard Deviation

Excel: Range & Standard Deviation

By-Hand: Mean, Median, and Mode - Assignment Score Example

By-Hand: Mean, Median, and Mode - Assignment Score Example

By-Hand: Mean, Median, and Mode - Residential Burglary Example

By-Hand: Mean, Median, and Mode - Residential Burglary Example

By-Hand: Mean, Median, and Mode - Stolen Auto Example

By-Hand: Mean, Median, and Mode - Stolen Auto Example

Excel: Mean, Median, & Mode - Measures of Central Tendency

Excel: Mean, Median, & Mode - Measures of Central Tendency

Excel: Data Analysis Add-In & How to Snip/Screenshot

Excel: Data Analysis Add-In & How to Snip/Screenshot

Excel: How to Merge Data

Excel: How to Merge Data

Excel: How to Filter

Excel: How to Filter