TECHNICAL PORTFOLIO // ENGINEERING & MODELING

FieldCopilot: Field Research Logistics, Routing & Spatial Quota Engine

proprietary_sanitized

Field logistics engine and spatial analytics platform engineered to automate sampling planning, team routing, and quota compliance for publi...

[!NOTE] Sanitized Technical Specification (proprietary_sanitized): This technical sheet is an authorized public specification adhering to strict intellectual property compliance and Brazilian LGPD (Lei Geral de Proteção de Dados) compliance. Proprietary source code, production database instances, raw databases, confidential credentials, and client Personally Identifiable Information (PII) remain strictly protected and are not exposed.

Especificação Técnica Sanitizada (proprietary_sanitized): Ficha técnica pública autorizada em estrita conformidade com a Lei Geral de Proteção de Dados (LGPD) e diretrizes de propriedade intelectual. Código-fonte, instâncias de produção, credenciais confidenciais e dados pessoais identificáveis (PII) protegidos.

Ficha técnica pública autorizada sob diretriz proprietary_sanitized. Código-fonte, bancos de dados transacionais e telemetria de campo protegidos sob estrito sigilo institucional.

Organization / Context: Instituto de Pesquisa de Opinião e Inteligência de Mercado
Timeline: 2025 - 2026
Domain Category: Data Science
Technologies: FastAPI, Python, React 18, TypeScript, Leaflet, GeoParquet, Uber H3, PostgreSQL, Docker, OR-Tools

Executive Overview

Field logistics engine and spatial analytics platform engineered to automate sampling planning, team routing, and quota compliance for public opinion and market surveys. Integrates spatially constrained regionalization (n >= m), geodesic TSP 2-Opt routing, GeoParquet/H3 census tract ingestion, and real-time field productivity auditing.

Architecture & Data Flow

The diagram below illustrates the sanitized high-level component topology and data processing pipeline:

flowchart TD
  A[Dados Censitários IBGE / Malhas Vetoriais] --> B[Regionalização Espacial Restrita n >= m / H3]
  B --> C[Otimizador de Roteamento TSP 2-Opt]
  C --> D[PostgreSQL / PostGIS / SQLAlchemy]
  D --> E[Backend FastAPI / REST API]
  E --> F[Frontend React 18 / TypeScript / Leaflet]
  E --> G[Motor de Auditoria & Telemetria em Tempo Real]
  G --> H[Exportação de Rotas & Painel de Supervisão de Campo]

Key Engineering Highlights

  • Spatially Constrained Regionalization: Territorial clustering of census tracts with minimum quota thresholds (n >= m) and Uber H3 hexagonal cells (res 8) to eliminate unfeasible micro-stops.
  • Optimized Geodesic Routing: TSP 2-Opt heuristic with geodesic distance matrices and operational shift constraints (8h/day, buffer approach times, transit velocities).
  • Moral Hazard Mitigation: Decoupled auditing architecture combining real-time telemetry, speeder detection, and quota drift control.