Skip to content

Instantly share code, notes, and snippets.

@ianschuler
Created June 12, 2014 01:00
Show Gist options
  • Save ianschuler/e7ed3079f5f5e2f69c37 to your computer and use it in GitHub Desktop.
Save ianschuler/e7ed3079f5f5e2f69c37 to your computer and use it in GitHub Desktop.
[
{
"op": "core/transpose-rows-into-columns",
"description": "Transpose every 2 cells in column __anonymous__ - geometry - coordinates - __anonymous__ into separate columns",
"columnName": "__anonymous__ - geometry - coordinates - __anonymous__",
"rowCount": 2
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - pc_code to PC-number",
"oldColumnName": "__anonymous__ - properties - pc_code",
"newColumnName": "PC-number"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column PC-number using expression grel:\"0000000\"[0,7-value.length()] + value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "PC-number",
"expression": "grel:\"0000000\"[0,7-value.length()] + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - geometry - coordinates - __anonymous__ 1 to Long",
"oldColumnName": "__anonymous__ - geometry - coordinates - __anonymous__ 1",
"newColumnName": "Long"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - geometry - coordinates - __anonymous__ 2 to Lat",
"oldColumnName": "__anonymous__ - geometry - coordinates - __anonymous__ 2",
"newColumnName": "Lat"
},
{
"op": "core/column-removal",
"description": "Remove column __anonymous__ - type",
"columnName": "__anonymous__ - type"
},
{
"op": "core/column-removal",
"description": "Remove column __anonymous__ - geometry - type",
"columnName": "__anonymous__ - geometry - type"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - ps_male to ps_male",
"oldColumnName": "__anonymous__ - properties - ps_male",
"newColumnName": "ps_male"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - pc_name to pc_name",
"oldColumnName": "__anonymous__ - properties - pc_name",
"newColumnName": "pc_name"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - province to province",
"oldColumnName": "__anonymous__ - properties - province",
"newColumnName": "province"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - ps_total to ps_total",
"oldColumnName": "__anonymous__ - properties - ps_total",
"newColumnName": "ps_total"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - ps_female to ps_female",
"oldColumnName": "__anonymous__ - properties - ps_female",
"newColumnName": "ps_female"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - pc_location to pc_location",
"oldColumnName": "__anonymous__ - properties - pc_location",
"newColumnName": "pc_location"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - iec_prov_id to iec_prov_id",
"oldColumnName": "__anonymous__ - properties - iec_prov_id",
"newColumnName": "iec_prov_id"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - map_accuracy to map_accuracy",
"oldColumnName": "__anonymous__ - properties - map_accuracy",
"newColumnName": "map_accuracy"
},
{
"op": "core/column-rename",
"description": "Rename column __anonymous__ - properties - iec_district_id to iec_district_id",
"oldColumnName": "__anonymous__ - properties - iec_district_id",
"newColumnName": "iec_district_id"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment