collect data from public/government crime map websites

Hello,

I’m looking to hire a developer to build an automated data extraction system from government-provided crime maps.

Project scope:

Automatically collect data from public/government crime map websites (Canada-focused, but scalable)

Extract structured data including:

Crime location (address, coordinates, or map pin)

Associated business name (when available)

Crime type and date (if accessible)

Output data into a usable format (CSV, Excel, Google Sheets, or database)

Prefer a solution using APIs where available; otherwise ethical web scraping + GIS parsing

Ability to rerun on a schedule (daily / weekly) or on demand

Technical considerations (open to suggestions):

Python, JavaScript, or similar

GIS / map data handling (ArcGIS, Leaflet, Mapbox, etc.)

CAPTCHA / rate-limit safe approach (no black-hat methods)

Clean, maintainable code with documentation

Please provide:

Estimated cost

Timeline

Relevant past experience or examples

Any assumptions or limitations (data availability, map restrictions, etc.)

This is for legitimate research and business intelligence purposes using publicly available data.


• api first data collection from official government sources wherever available
• for maps without APIs, compliant data extraction + gis parsing (arcgis/mapbox formats)
• python handles data fetching + normalization
• google sheets will be the master output with a clean, unified schema
• apps script will manage scheduling (daily/weekly) and on demand runs
• structured export available as csv/excel/google sheets
• clean, documented code so sources can be added later

this keeps infrastructure cost minimal while staying within access policies and rate limits.

assumptions
• depends on public data availability per city
• some sources may provide partial fields only
• captcha protected sources will rely on official endpoints only



Thank you,
Jugpal Saran