#! /bin/bash
# Last edited on 2011-02-06 02:41:57 by stolfilocal

pre="ftp://ftp.ibge.gov.br/Censos/Censo_Demografico_2010/resultados/total_populacao_"

for cn in \
    AC.acre \
    AL.alagoas \
    AP.amapa \
    AM.amazonas \
    BA.bahia \
    CE.ceara \
    DF.distrito_federal \
    ES.espirito_santo \
    GO.goias \
    MA.maranhao \
    MT.mato_grosso \
    MS.mato_grosso_do_sul \
    MG.minas_gerais \
    PA.para \
    PB.paraiba \
    PR.parana \
    PE.pernambuco \
    PI.piaui \
    RJ.rio_de_janeiro \
    RN.rio_grande_do_norte \
    RS.rio_grande_do_sul \
    RO.rondonia \
    RR.roraima \
    SC.santa_catarina \
    SP.sao_paulo \
    SE.sergipe \
    TO.tocantins \
  ; do
  xx=( ${cn//[.]/ } )
  stcd="${xx[0]}"
  stname="${xx[1]}"
  
  echo "== ${stcd} ${stname} ============================"
  zipfile="${stcd}-mun-pop-IBGE-2010.zip"
  xlsfile="${stcd}-mun-pop-IBGE-2010.xls"
  csvfile="${stcd}-mun-pop-IBGE-2010.csv"
  tblfile="${stcd}-mun-pop-IBGE-2010.tbl"
  
  # Fetch zipfile:
  # wget -nv "${pre}${stname}.zip" -O "${stcd}-mun-pop.zip"
  # sleep 10
  
  # Unpack zipfile and rename the ".xls" file:
  # unzip "${stcd}-mun-pop.zip"
  # xlsfile-ibge="total_populacao_${stname}.xls"
  # if [[ -s ${xlsfile-ibge} ]]; then
  #   mv -vi ${xlsfile-ibge} ${xlsfile}
  # else
  #   echo "** ${xlsfile-ibge} not found" 1>&2
  # fi
  
  # Convert the ".xls" file to ".csv":
  # if [[ -s ${xlsfile} ]]; then
  #   xls2csv -x ${xlsfile} -b iso-8859-1 -t '|' -c ${csvfile}
  # else
  #   echo "** ${xlsfile} not found" 1>&2
  # fi
  
  # Extract population and urban ratio:
  locfile="../dados-por-urna/dados/${stcd}/localidades.tbl"
  ( export LANG=en_US.ISO8859-1; \
    extract-pop-from-ibge-csv.gawk \
        -v tblfile=${locfile} \
        ${csvfile} \
      > ${tblfile} \
  )
done