Coding Cont.

NEXT I wanted to determine the distance from home the crimes occurred.  The distance is measured in KM.

MIN .03 KM


AVG distance is 66.26 KM


Max distance 10632.72 KM



I also wanted to write a code to determine the distance for the fraudulent transactions made in person from the last location.  I did not include online transactions in this query because I wanted a clear picture of how hard criminals were willing to work, or how arrogant they were staying close.  I determined online transactions were not a good indication of this.

AVG 21.89 KM

MAX 1607.89 KM