rikkit / bath-hacked-2k15 Goto Github PK

Here you can find the map created

https://cyy.cartodb.com/api/v2/viz/a74eeeb4-2249-11e5-8aa0-0e853d047bba/viz.json

Categories

possession-of-weapons [10]
public-disorder-weapons [10]
criminal-damage-arson [10]
violent-crime [10]
robbery [9]
burglary [8]
drugs [7]
theft-from-the-person [6]
vehicle-crime [5]
other-crime [5]
anti-social-behaviour [4]
public-order [3]
bicycle-theft [3]
other-theft [2]
shoplifting [1]

Outcome
Investigation complete
Under investigation
Unable to prosecute suspect
Offender otherwise dealt with
Offender given community sentence
Offender given a caution
Court result unavailable
Suspect charged as part of another case
Offender fined
Local resolution
Awaiting court outcome
Court case unable to proceed
Crime reported
Offender sent to prison
Offender given suspended prison sentence
Defendant found not guilty
Formal action is not in the public interest
Offender given conditional discharge
Defendant sent to Crown Court
Offender given penalty notice
Offender ordered to pay compensation
Offender given a drugs possession warning
Offender deprived of property
Offender given absolute discharge

We need an algorithm to rank severity and also taking into account resolution details?

We need a publicly accessible URL

This repository is empty

Crime data:

PUT bath-hacked
POST bath-hacked/_mapping/crime
{
  "crime": {
    "dynamic_templates": [
      {
        "string_template": {
          "mapping": {
            "type": "multi_field",
            "path": "full",
            "fields": {
              "#analyzed#": {
                "type": "string"
              },
              "{name}": {
                "index": "not_analyzed",
                "type": "string",
                "doc_values": true
              }
            }
          },
          "match_mapping_type": "string",
          "match_pattern": "regex",
          "path_match": ".*"
        }
      }
    ],
    "properties": {
      "date": {
        "type": "date"
      },
      "location": {
        "type": "geo_point",
        "lat_lon": "true"
      }
    }
  }
}

For the crime dataset they are only available on a street level. This creates an issue in associating the crimes with pubs, clubs, bars etc. where there is more than one on the same street. Do we distribute the crime level among all of them or do we apply it to the general area and display the premises included?@ryubidragonfire looking into this.

Street level crime 2010-2015
https://data.bathhacked.org/Government-and-Society/-Live-BANES-Street-Level-Crime/e46f-mhfs

Weather data 2010-2014
https://data.bathhacked.org/Environment/weather/3jiu-nb4x

Bath climate 1981-2010
https://data.bathhacked.org/Government-and-Society/-Live-BANES-Street-Level-Crime/e46f-mhfs

Premises license
https://data.bathhacked.org/Government-and-Society/Premises-License-17-09-14/qmrw-fvff

Bath bar & pub closing times
https://data.bathhacked.org/Economy/Bath-Bar-Pub-closing-times/2pme-edif