Taipei Crime Data Standardization
Budget: $30 – $250 USD
Crime Data Standardization Specialist - Taipei Police Department Data
Project Overview
We need a data specialist to transform Taipei Police Department crime statistics into our standardized format. This project involves extracting data from yearly reports, standardizing crime categories, and ensuring geographic data alignment.
Data Source
Source: Taipei Police Department yearly crime statistics (警務統計年報)
https://police.gov.taipei/cp.aspx?n=41ACB3325FE2ACE3
Format:File multiple sheets (each sheet represents one year)
Source Type: Local Police (local_gov)
Geographic Level: District
Temporal Granularity: Annual
Project Tiers & Deliverables (Waterfall Pricing Structure)
Payment for each tier will only be released upon successful completion and acceptance of all previous tiers. Complete all tiers for maximum compensation and bonus.
Tier 1: Basic Data Extraction ($100)
Instructions:
Extract raw crime data and conform to dictated schema below
Deliverable: Standardized CSV file containing columns:
date: Year in YYYY-MM-DD format (use December 15th of each year if annual, 15h for date if monthly, otherwise daily will be YYYY-MM-DD or lat/long in separate columns)
description: Original crime description name (in English translation)
count: Number of incidents for that crime/district/year
location_name: District name (must be consistent across records)
geo_granularity: “city”, “district”, “lat_long”
source_type: "local_gov", “national_gov”
source_name : logical name of where you pulled data ie “taipei_police”
Acceptance Criteria (Tier 1):
CSV contains all required fields with exact column names as specified and values populated
All district names are consistent in spelling and format across the dataset
No missing values in any required fields
Row count matches expected number (districts × crime categories × years)
UTF-8 encoding properly handles any non-English characters
Example row matches format: 2022-12-31,Theft,145,Zhongzheng District,annually,local_gov,district
Tier 2: Crime Category Mapping ($50, requires Tier 1 completion)
Deliverable: Enhanced CSV with all Tier 1 fields plus:
description_mapped: Crime category mapped to our standardized ontology
Mapping Instructions:
Map each original crime category to one of our standard categories (list provided in specifications)
Provide a separate document explaining your mapping rationale
Acceptance Criteria (Tier 2):
All Tier 1 acceptance criteria are met
New column "description_mapped" contains only values from our standardized category list
Mapping is consistent (same original categories map to same standardized categories)
Mapping logic is documented and explained in a separate file
No original crime categories are left unmapped
Sample mapping documents your understanding (e.g., "竊盜案件 → Theft")
Tier 3: Geographic Data Integration ($50, requires Tier 1 & 2 completion)
Deliverable: All Tier 1 & 2 deliverables plus:
Required GeoJSON Structure
Your deliverable must be a valid GeoJSON file with the following characteristics:
Proper District Boundaries
Include all districts of Taipei that appear in the crime data CSV
Boundaries must accurately represent the official Taipei district borders
Required Properties for Each Feature
display_name: Must EXACTLY match the district names in the CSV (character-for-character, case-sensitive)
Technical Specifications
Coordinate system: EPSG:4326 (WGS 84)
Geometries must be valid Polygons or MultiPolygons
File must use UTF-8 encoding to properly handle
Map Coverage
Ensure map primarily covers land ie avoid oceans
Compare outline of map to Google Maps UI
Step-by-Step Process
Find Source Data
Option 1: Search for existing Taipei district GeoJSON/Shapefile from official sources
Taipei City Government GIS portal
Taiwan's national geographic information system
OpenStreetMap data for Taipei
https://haoliangyu.github.io/boundary.now/
Google “geojson file for Taipei”
Option 2: If official sources aren't available, you may need to:
Download individual district boundaries and merge them
Trace boundaries from map images using QGIS (last resort)
Process the Map File
Convert to GeoJSON format if in another format (like Shapefile)
Ensure coordinate system is EPSG:4326
Add the required properties to each feature
Verify District Names
Make sure each district's display_name property EXACTLY matches the corresponding location_name in the CSV (this is critical - even small differences will cause the district to display without data)
Validate the File
Use a GeoJSON validator to check for syntax errors [https://geojsonlint.com/]
Verify all required properties are present for each feature
Check that all geometries are valid (see ‘Required GeoJson Structure’)
Acceptance Criteria (Tier 3):
All Tier 1 and Tier 2 acceptance criteria are met
GeoJSON file passes validation with no errors
Every district in the CSV has a matching boundary in the GeoJSON
All "display_name" values in GeoJSON match corresponding "location_name" values in CSV exactly (character-for-character, case-sensitive)
Each feature has required properties (ie see example below)
Example Outputs
Tier 1 CSV Example:
date,description,count,location_name,geo_granularity,source_type,location_level
2022-12-31,Theft,145,Zhongzheng District,annually,local_gov,district
2022-12-31,Assault,32,Zhongzheng District,annually,local_gov,district
Tier 3 GeoJSON Feature Example (simplified):
json
json
{
"type": "FeatureCollection",
"name": "<location_name>",
"crs": {
"type": "name",
"properties": {
"name": "urn:ogc:def:crs:OGC:1.3:CRS84"
}
},
"features": [
{
"type": "Feature",
"properties": {
"display_name": "<district_name>"
},
"geometry": {
"type": "MultiPolygon",
"coordinates": [
[
[
[<longitude>, <latitude>],
// Additional coordinate pairs
]
]
]
}
}
]
}
Deliverable Format
CSV file(s) with all required fields
GeoJSON file (for Tier 3)
Brief documentation explaining your process and any decisions made (as needed)
Timeline
Tier 1: 2 days after contract start
Tier 2: 3 days after contract start
Tier 3: 4 days after contract start
Payment Structure
Individual Tier Pricing:
Tier 1 completion only: $100
Tier 2 completion (includes Tier 1): $150 total
Tier 3 completion (includes Tiers 1 & 2): $200 total
Project Overview
We need a data specialist to transform Taipei Police Department crime statistics into our standardized format. This project involves extracting data from yearly reports, standardizing crime categories, and ensuring geographic data alignment.
Data Source
Source: Taipei Police Department yearly crime statistics (警務統計年報)
https://police.gov.taipei/cp.aspx?n=41ACB3325FE2ACE3
Format:File multiple sheets (each sheet represents one year)
Source Type: Local Police (local_gov)
Geographic Level: District
Temporal Granularity: Annual
Project Tiers & Deliverables (Waterfall Pricing Structure)
Payment for each tier will only be released upon successful completion and acceptance of all previous tiers. Complete all tiers for maximum compensation and bonus.
Tier 1: Basic Data Extraction ($100)
Instructions:
Extract raw crime data and conform to dictated schema below
Deliverable: Standardized CSV file containing columns:
date: Year in YYYY-MM-DD format (use December 15th of each year if annual, 15h for date if monthly, otherwise daily will be YYYY-MM-DD or lat/long in separate columns)
description: Original crime description name (in English translation)
count: Number of incidents for that crime/district/year
location_name: District name (must be consistent across records)
geo_granularity: “city”, “district”, “lat_long”
source_type: "local_gov", “national_gov”
source_name : logical name of where you pulled data ie “taipei_police”
Acceptance Criteria (Tier 1):
CSV contains all required fields with exact column names as specified and values populated
All district names are consistent in spelling and format across the dataset
No missing values in any required fields
Row count matches expected number (districts × crime categories × years)
UTF-8 encoding properly handles any non-English characters
Example row matches format: 2022-12-31,Theft,145,Zhongzheng District,annually,local_gov,district
Tier 2: Crime Category Mapping ($50, requires Tier 1 completion)
Deliverable: Enhanced CSV with all Tier 1 fields plus:
description_mapped: Crime category mapped to our standardized ontology
Mapping Instructions:
Map each original crime category to one of our standard categories (list provided in specifications)
Provide a separate document explaining your mapping rationale
Acceptance Criteria (Tier 2):
All Tier 1 acceptance criteria are met
New column "description_mapped" contains only values from our standardized category list
Mapping is consistent (same original categories map to same standardized categories)
Mapping logic is documented and explained in a separate file
No original crime categories are left unmapped
Sample mapping documents your understanding (e.g., "竊盜案件 → Theft")
Tier 3: Geographic Data Integration ($50, requires Tier 1 & 2 completion)
Deliverable: All Tier 1 & 2 deliverables plus:
Required GeoJSON Structure
Your deliverable must be a valid GeoJSON file with the following characteristics:
Proper District Boundaries
Include all districts of Taipei that appear in the crime data CSV
Boundaries must accurately represent the official Taipei district borders
Required Properties for Each Feature
display_name: Must EXACTLY match the district names in the CSV (character-for-character, case-sensitive)
Technical Specifications
Coordinate system: EPSG:4326 (WGS 84)
Geometries must be valid Polygons or MultiPolygons
File must use UTF-8 encoding to properly handle
Map Coverage
Ensure map primarily covers land ie avoid oceans
Compare outline of map to Google Maps UI
Step-by-Step Process
Find Source Data
Option 1: Search for existing Taipei district GeoJSON/Shapefile from official sources
Taipei City Government GIS portal
Taiwan's national geographic information system
OpenStreetMap data for Taipei
https://haoliangyu.github.io/boundary.now/
Google “geojson file for Taipei”
Option 2: If official sources aren't available, you may need to:
Download individual district boundaries and merge them
Trace boundaries from map images using QGIS (last resort)
Process the Map File
Convert to GeoJSON format if in another format (like Shapefile)
Ensure coordinate system is EPSG:4326
Add the required properties to each feature
Verify District Names
Make sure each district's display_name property EXACTLY matches the corresponding location_name in the CSV (this is critical - even small differences will cause the district to display without data)
Validate the File
Use a GeoJSON validator to check for syntax errors [https://geojsonlint.com/]
Verify all required properties are present for each feature
Check that all geometries are valid (see ‘Required GeoJson Structure’)
Acceptance Criteria (Tier 3):
All Tier 1 and Tier 2 acceptance criteria are met
GeoJSON file passes validation with no errors
Every district in the CSV has a matching boundary in the GeoJSON
All "display_name" values in GeoJSON match corresponding "location_name" values in CSV exactly (character-for-character, case-sensitive)
Each feature has required properties (ie see example below)
Example Outputs
Tier 1 CSV Example:
date,description,count,location_name,geo_granularity,source_type,location_level
2022-12-31,Theft,145,Zhongzheng District,annually,local_gov,district
2022-12-31,Assault,32,Zhongzheng District,annually,local_gov,district
Tier 3 GeoJSON Feature Example (simplified):
json
json
{
"type": "FeatureCollection",
"name": "<location_name>",
"crs": {
"type": "name",
"properties": {
"name": "urn:ogc:def:crs:OGC:1.3:CRS84"
}
},
"features": [
{
"type": "Feature",
"properties": {
"display_name": "<district_name>"
},
"geometry": {
"type": "MultiPolygon",
"coordinates": [
[
[
[<longitude>, <latitude>],
// Additional coordinate pairs
]
]
]
}
}
]
}
Deliverable Format
CSV file(s) with all required fields
GeoJSON file (for Tier 3)
Brief documentation explaining your process and any decisions made (as needed)
Timeline
Tier 1: 2 days after contract start
Tier 2: 3 days after contract start
Tier 3: 4 days after contract start
Payment Structure
Individual Tier Pricing:
Tier 1 completion only: $100
Tier 2 completion (includes Tier 1): $150 total
Tier 3 completion (includes Tiers 1 & 2): $200 total