Update database format and the database dump
Closed this issue · 1 comments
henrinormak commented
Include postcode stuff from http://www.opendoorlogistics.com/downloads/, end result will be two tables - incidents and neighbourhoods.
Incidents will consist of point data - incidents and their coordinates.
Neighbourhoods will have polygons that represent the postcode areas.
henrinormak commented
Should be done as of 486f03a, database has been updated to include two tables - incidents and neighbourhoods.
Incidents has the following columns
| crime | force | date | weight | geom |
|---|---|---|---|---|
| Type of crime, constant string | Force responsible, UI suitable string | date, down to month (all days are 01) | Arbitrarily assigned weight, based on the crime type | Point geometry with the location |
And neighbourhoods has the following columns
| name | geom |
|---|---|
| Name of the postcode sector, for example "YO10 3" | Multipolygon geometry |
Also updated the README to include better installation instructions, this time using the original SQL commands.