Provide geographic attribute files as hosted parquet, including pre-2006 censuses

Aperta
  • Qualcosa non va?
#233 2 commenti 0 reazioni 0 assegnatari Vedi su GitHub

Nessuno ha ancora preso questa issue.

Valutazione

Difficoltà
5/5
Tempo stimato
Più di una settimana
Idoneità per principianti
38/100
Tipo di issue
Funzionalità
Chiarezza
Abbastanza chiara
Stato di attività
Attiva
Stack tecnologico
r
Ambito
backend, data

Direzione di ricerca

Start by checking the R implementation of get_statcan_geographic_attributes() and the hosted storage status described in the issue; then inspect the listed source files and layouts for the older censuses. The work also requires deciding how to expose differing census fields and documenting provenance. Done means the missing parquet files are hosted with source and licence metadata, and the function can read them across the intended census years.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Descrizione

enhancement

The geographic attribute files are useful well beyond TongFen: they link the lowest census geography to the higher levels, with population, dwellings and representative points. get_statcan_geographic_attributes() only covers 2006 to 2021 and downloads from StatCan, which now puts at least the 2021 file behind a browser check (#228).

This proposes serving the attribute files as hosted parquet, written with r2parquet, and adding the older censuses.

Files

Census Source Base geography Records
2021, 2016, 2011, 2006 92-151 attribute files DB Not counted here
2001 GeoSuite 2001 geosuite2001.mdb, tables CB and DA Block, DA 478,707 blocks, 52,993 DAs
1996 GAF1996.txt EA 49,361
1991 gaf91.txt EA 45,995
1986 GAF1986.txt EA 44,042
1981 GAF1981.txt EA 41,197

I haven't found a separate 2001 attribute file. The GeoSuite CB table has similar content: population, dwellings, representative points, and the codes for higher levels. If StatCan did release a 2001 attribute file, it should replace this.

Hosting status

I found no attribute files in the public mountainmath S3 bucket under the tongfen, cancensus, statcan, census, gaf or attribute prefixes, and the existing mirror holds only correspondence files. R2 still needs checking, as I couldn't list its buckets.

What needs doing

  • Confirm what's already hosted on R2, then convert and upload what's missing, with the source and the Statistics Canada Open Data licence in the parquet footer.
  • Extend get_statcan_geographic_attributes() to the older years and read from the hosted files. Keep the provenance visible, since re-hosting is the concern raised in #228.
  • Parse the older fixed-width layouts, which have a different structure for each census.
  • Decide whether to return columns as released or harmonised across years. As released is simpler and closer to the source, but the older EA-based files have quite different fields from the DB-based ones.
  • Decide on the function's scope. The existing name still fits, but pre-2006 results are at EA level.
  • Consider the same treatment for get_statcan_geo_suite(). Its 2001 download URL returned a Cloudflare challenge (HTTP 403) when tested from a script.

Related: mountainMath/tongfen#22, which covers the correspondence files for the same censuses.

Lingua principale
HTML
Stelle
90
Fork
14
Nessuna PR unita negli ultimi 30g

Preparare l'ambiente

Questo progetto non fornisce container di sviluppo, Dockerfile né guida per i contributori, quindi l'ambiente è a tuo carico: parti dal suo README e consulta la nostra guida al primo contributo per i passaggi generali.

Come iniziare

  1. Leggi tutta la issue e poi la guida ai contributi del progetto.
  2. Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
  3. Fai un fork del repository e lavora su un branch.
  4. Apri una pull request che faccia riferimento al numero della issue.

Altre issue di mountainMath/cancensus

Tutte le issue di mountainMath/cancensus

Issue simili

Altre issue su Backend & API Design

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.