Skip to content

Instantly share code, notes, and snippets.

@schnuerle
Last active May 8, 2017 18:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save schnuerle/2e265956b902749abe6bd7bb752b7790 to your computer and use it in GitHub Desktop.
Save schnuerle/2e265956b902749abe6bd7bb752b7790 to your computer and use it in GitHub Desktop.
Business Licenses Test
{
"version": "2",
"header": {
"title": "Crime in Louisville",
"description": "Crime reports in Louisville Metro from the LMPD. January 1, 2017 to present. Data is updated daily.",
"navigation": [
{
"label": "Download",
"url": "https://data.louisvilleky.gov/sites/default/files/Crime_Data_2017_7.csv"
}
]
},
"cards": [
{
"x": 0,
"y": 0,
"width": 6,
"height": 2,
"vizwit": {
"title": "Crime Reports",
"chartType": "callout",
"provider": "dkan",
"domain": "data.louisvilleky.gov",
"dataset": "a5ceefa5-092e-4ad2-8a4f-827576b271fe",
"groupBy": "date_trunc_y(date_issued)",
"valueFormat": "0,0",
"labelFormat": "[Calendar year] YYYY",
"order": "label desc",
"limit": 1,
"baseFilters": [
{
"field": "license_status",
"expression": {
"type": "=",
"value": "AAI"
}
},
{
"field": "application_type",
"expression": {
"type": "=",
"value": "ISSUE"
}
}
]
}
},
{
"x": 6,
"y": 0,
"width": 6,
"height": 2,
"vizwit": {
"title": "Licenses Renewed",
"chartType": "callout",
"provider": "socrata",
"domain": "data.cityofchicago.org",
"dataset": "xqx5-8hwx",
"groupBy": "date_trunc_y(date_issued)",
"valueFormat": "0a",
"labelFormat": "[Calendar year] YYYY",
"order": "label desc",
"limit": 1,
"baseFilters": [
{
"field": "license_status",
"expression": {
"type": "=",
"value": "AAI"
}
},
{
"field": "application_type",
"expression": {
"type": "=",
"value": "RENEW"
}
}
]
}
},
{
"x": 0,
"y": 2,
"width": 12,
"height": 5,
"vizwit": {
"title": "Crime Dates",
"description": "Date the crime occurred.",
"chartType": "datetime",
"provider": "dkan",
"domain": "data.louisvilleky.gov",
"dataset": "a5ceefa5-092e-4ad2-8a4f-827576b271fe",
"groupBy": "date_trunc_ym(DATE_OCCURED)",
"triggerField": "DATE_OCCURED"
}
},
{
"x": 0,
"y": 5,
"width": 4,
"height": 4,
"vizwit": {
"title": "License Status",
"description": "AAI means the license was issued. AAC means the license was cancelled",
"chartType": "pie",
"provider": "socrata",
"domain": "data.cityofchicago.org",
"dataset": "xqx5-8hwx",
"groupBy": "license_status"
}
},
{
"x": 4,
"y": 5,
"width": 4,
"height": 4,
"vizwit": {
"title": "Community Areas",
"chartType": "choropleth",
"provider": "socrata",
"domain": "data.cityofchicago.org",
"dataset": "xqx5-8hwx",
"groupBy": ":@computed_region_vrxf_vc4k",
"boundaries": "https://data.cityofchicago.org/resource/vrxf-vc4k.geojson?$limit=5000",
"boundariesLabel": "community",
"boundariesId": "_feature_id"
}
},
{
"x": 8,
"y": 5,
"width": 4,
"height": 4,
"vizwit": {
"title": "Application Type",
"description": "C_LOC indicates the business has moved",
"chartType": "pie",
"provider": "socrata",
"domain": "data.cityofchicago.org",
"dataset": "xqx5-8hwx",
"groupBy": "application_type"
}
},
{
"x": 0,
"y": 8,
"width": 12,
"height": 5,
"vizwit": {
"title": "License Description",
"chartType": "bar",
"provider": "socrata",
"domain": "data.cityofchicago.org",
"dataset": "xqx5-8hwx",
"groupBy": "license_description"
}
},
{
"x": 0,
"y": 11,
"width": 12,
"height": 7,
"vizwit": {
"title": "Business Licenses",
"chartType": "table",
"provider": "socrata",
"domain": "data.cityofchicago.org",
"dataset": "xqx5-8hwx"
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment