We needed testdata to develop the functions, so we made a simple ADF pipeline that inserts “actions” every x sec (if we want to).. We also need a lot of data, since we are planning to run reports and AI, with this test-data function we can start develop.

The ADF-pipeline takes a few params so we can controll how many runs we get.

Source data:

• SQL server
  • Table with first Names
  • Table with last names
  • Table with IncidentTypes
  • View generating random:
    • name: mixing firstname and lastname
    • incident types (as we make more incident types)
    • longitude: Random – 59.9000 – 59.9999
    • latitude: Random – 10.1000 – 10.9999

Assaults

Planned Work

TBC

Completed Work

TBC