jbothma

{
  "namespace": "workers",
  "event": {
    "type": "stop",
    "data": "1d7080a6-31fc-46c6-90fa-6a3a8d31fd51"
  }
}

jbothma

{
  "namespace": "workers",
  "event": {
    "type": "start",
    "data": "1668a003-be2c-4cf4-b8b3-b046861cdbf6"
  }
}

jbothma

Keybase proof

I hereby claim:

• I am jbothma on github.
• I am jbothma (https://keybase.io/jbothma) on keybase.
• I have a public key whose fingerprint is 793E 0822 0C9B 523E 2665 FD00 1B1A 9C5B 35C5 C575

To claim this, I am signing this object:

jbothma

hello <b>world</b>

jbothma

Quick anonymised dump from https://code4africa.slack.com/messages/general/

I saw statsSA host a open data site of sorts, but there's no info about it that I could find, will keep digging

Also, it ain’t a policy as such, but X is helping drive digitalisation of municipal bylaws by local volunteers through the excellent http://openbylaws.org.za/ initiative. You might want to sign-up for some of the cities you mentioned above?

this is a good start: http://opendatahandbook.org/

ekhurleni has an open data portal

jbothma

municipal_finance=> select l.code, l.label, customer_group_code, l30_amount from aged_debtor_facts f, aged_debtor_items l where f.item_code = l.code and demarcation_code = 'CPT' and financial_year = 2016 and financial_period = 09 and amount_type_code = 'ACT' order by position_in_return_form limit 30;
 code |                                label                                 | customer_group_code | l30_amount 
------+----------------------------------------------------------------------+---------------------+------------
 1100 | Debtors Age Analysis By Income Source                                |                     |          0
 1100 | Debtors Age Analysis By Income Source                                | 2290                |          0
 1100 | Debtors Age Analysis By Income Source                                | 2301                |          0
 1100 | Debtors Age Analysis By Income Source                                | 2401                |          0
 1200 | Trade and Other Receivables from Exchang

jbothma

title
 - hello
 - who am I

code4sa
 - tech
 - informed decision making
 . for positive social change

codebridge

jbothma

How we built Open Gazettes

Government gazettes are valuable entities in and of themselves. They’ve been consumed, published and archived in this form for centuries. This is why before building the resource, we needed to have some of what additional value we could provide. The majority of poeple who use gazettes tend to be lawyers, librarians and special interest groups. So, we asked ourselves, “How can gazettes be made available to the general public in a way that helps them to participate in policy-making and governance?”

Currently, government gazettes still look like they’re produced on the printing presses of the 1800s. Their text flows neatly from page to page, and whether it’s a 50-word liquidation notice, or a 400-page green paper, it will be published in the same format as gazettes always have been.

Perhaps when we started publishing gazettes, even before the Union and the Republic of South Africa, the newspaper format made sense; but today people consume information in very different ways and a

jbothma

Capital Spending by Municipalities in South Africa

The SA36 tables from the MFMA website by the South African National Treasury contain geographic coordinates of locations of assets where the municipality is spending on capital.

These coordinates are supplied as free text. We're trying to parse them into Decimal Degrees and store them in dedicated Latitude and Longitude columns, as shown in parsed_coordinates.csv below.

Would you like to help?

The regexes used to parse these so far can be found in the script below:

jbothma

{
  "name": "GRO_DOH_Citizen_Survey",
  "title": "GRO - DOH Citizen Survey",
  "sms_keyword": "GRO_DOH_Citizen_Survey",
  "default_language": "default",
  "version": "1.0",
  "id_string": "GRO_DOH_Citizen_Survey",
  "type": "survey",
  "children": [
    {