Geographic Output Files: These files are used in the platform’s mapping solution to build a complementary geographical view of service delivery activity. The information is loaded into the Local Insights mapping solutions to provide a visual representation of the distribution of service delivery across the county.
Submission of Files: Submitted as an Excel file. The content and preferred structure of the files are described in the table below.
Content and Structure: The data file should include the columns listed in this table, noting that:
Before submitting please ensure you data contains the mandatory content as described in the table below.
Â
Note your data file can contain additional data columns not listed here, but these will not necessarily be used in the analysis and dashboard.
| Column | Title | Size (no. of characters) | Format | Mandatory (yes/optional/desirbale) | Content Notes |
|---|---|---|---|---|---|
| 1 | Postcode | 8 | Text | Yes | |
| 2 | Value | Numeric | Yes | Count or sum value for this location in the period defined in this file | |
| 3 | Service_Description | 100 | Text | Yes | A short standard description of the service provided. |
| 4 | Provider | 50 | Text | Yes | Registered Organisation Name. |
| 5 | Date_From | dd/mm/yyyy | Yes | First day of the reporting period. | |
| 6 | Date_To | dd/mm/yyyy | Yes | Last day of the reporting period. |