"meta": {
"view": {
"id": "i4ke-p6yq"
"name": "Citywide LED Streetlight Savings"
"averageRating": 0
"category": "A Livable and Sustainable City"
"createdAt": 1399934330
"description": "The LED Streetlight Replacement Program has replaced over 180
000 existing streetlight fixtures in the city
resulting in substantial energy and carbon emissions savings."
"displayType": "table"
"downloadCount": 1236
"hideFromCatalog": false
"hideFromDataJson": false
"iconUrl": "fileId:chDGQ4HdaP8hCFbvVLeXIKhKI_hj1u54rAuLIls1KM4"
"indexUpdatedAt": 1528495845
"licenseId": "CC0_10"
"newBackend": false
"numberOfComments": 0
"oid": 28995773
"provenance": "official"
"publicationAppendEnabled": false
"publicationDate": 1528493248
"publicationGroup": 1579014
"publicationStage": "published"
"rowClass": ""
"rowsUpdatedAt": 1528493213
"rowsUpdatedBy": "kmuv-58sk"
"tableId": 15260021
"totalTimesRated": 0
"viewCount": 486
"viewLastModified": 1528493345
"viewType": "tabular"
"columns": [
{
"id": -1
"name": "sid"
"dataTypeName": "meta_data"
"fieldName": ":sid"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "id"
"dataTypeName": "meta_data"
"fieldName": ":id"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "position"
"dataTypeName": "meta_data"
"fieldName": ":position"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "created_at"
"dataTypeName": "meta_data"
"fieldName": ":created_at"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "created_meta"
"dataTypeName": "meta_data"
"fieldName": ":created_meta"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "updated_at"
"dataTypeName": "meta_data"
"fieldName": ":updated_at"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "updated_meta"
"dataTypeName": "meta_data"
"fieldName": ":updated_meta"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": -1
"name": "meta"
"dataTypeName": "meta_data"
"fieldName": ":meta"
"position": 0
"renderTypeName": "meta_data"
"format": {}
"flags": [
"hidden"
]
}
{
"id": 362769085
"name": "Council District"
"dataTypeName": "number"
"description": "City council district"
"fieldName": "council_district"
"position": 1
"renderTypeName": "number"
"tableColumnId": 19693290
"width": 96
"cachedContents": {
"largest": "15"
"non_null": 15
"average": "8"
"null": 0
"top": [
{
"item": "1"
"count": 20
}
{
"item": "2"
"count": 19
}
{
"item": "3"
"count": 18
}
{
"item": "4"
"count": 17
}
{
"item": "5"
"count": 16
}
{
"item": "6"
"count": 15
}
{
"item": "7"
"count": 14
}
{
"item": "8"
"count": 13
}
{
"item": "9"
"count": 12
}
{
"item": "10"
"count": 11
}
{
"item": "11"
"count": 10
}
{
"item": "12"
"count": 9
}
{
"item": "13"
"count": 8
}
{
"item": "14"
"count": 7
}
{
"item": "15"
"count": 6
}
]
"smallest": "1"
"sum": "120"
}
"format": {
"precisionStyle": "standard"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769086
"name": "Total Units"
"dataTypeName": "number"
"description": "Total number of LED fixtures replaced"
"fieldName": "total_units"
"position": 2
"renderTypeName": "number"
"tableColumnId": 19693291
"width": 145
"cachedContents": {
"largest": "25314"
"non_null": 15
"average": "12305.13333333333"
"null": 0
"top": [
{
"item": "7616"
"count": 20
}
{
"item": "5681"
"count": 19
}
{
"item": "14421"
"count": 18
}
{
"item": "9787"
"count": 17
}
{
"item": "11737"
"count": 16
}
{
"item": "9176"
"count": 15
}
{
"item": "9465"
"count": 14
}
{
"item": "17029"
"count": 13
}
{
"item": "12749"
"count": 12
}
{
"item": "11084"
"count": 11
}
{
"item": "25314"
"count": 10
}
{
"item": "9442"
"count": 9
}
{
"item": "14069"
"count": 8
}
{
"item": "15270"
"count": 7
}
]
"smallest": "5681"
"sum": "184577"
}
"format": {
"precisionStyle": "standard"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769087
"name": "Total Nom Watts Before (kW)"
"dataTypeName": "number"
"description": "Total nominal watts before conversion (in kilowatts)"
"fieldName": "total_nom_watts_before_kw"
"position": 3
"renderTypeName": "number"
"tableColumnId": 19693292
"width": 256
"cachedContents": {
"largest": "5071.20"
"non_null": 15
"average": "2820.14"
"null": 0
"top": [
{
"item": "1808.70"
"count": 20
}
{
"item": "1386.10"
"count": 19
}
{
"item": "3182.40"
"count": 18
}
{
"item": "2224.90"
"count": 17
}
{
"item": "2956.30"
"count": 16
}
{
"item": "2218.90"
"count": 15
}
{
"item": "2211.40"
"count": 14
}
{
"item": "3684.10"
"count": 13
}
{
"item": "2742.20"
"count": 12
}
{
"item": "2834.50"
"count": 11
}
{
"item": "2812.30"
"count": 10
}
{
"item": "5071.20"
"count": 9
}
{
"item": "2223.30"
"count": 8
}
{
"item": "3553.70"
"count": 7
}
{
"item": "3392.10"
"count": 6
}
]
"smallest": "1386.10"
"sum": "42302.10"
}
"format": {
"precisionStyle": "standard"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769088
"name": "Total Nom Watts After (kW)"
"dataTypeName": "number"
"description": "Total nominal watts after conversion (in kilowatts)"
"fieldName": "total_nom_wats_tafter_kw"
"position": 4
"renderTypeName": "number"
"tableColumnId": 19693293
"width": 232
"cachedContents": {
"largest": "1814.40"
"non_null": 15
"average": "1015.386666666667"
"null": 0
"top": [
{
"item": "703.2"
"count": 20
}
{
"item": "444.9"
"count": 19
}
{
"item": "1060.00"
"count": 18
}
{
"item": "782.8"
"count": 17
}
{
"item": "964.1"
"count": 16
}
{
"item": "793.4"
"count": 15
}
{
"item": "786.8"
"count": 14
}
{
"item": "1453.60"
"count": 13
}
{
"item": "1013.00"
"count": 12
}
{
"item": "1088.60"
"count": 11
}
{
"item": "973.5"
"count": 10
}
{
"item": "1814.40"
"count": 9
}
{
"item": "838.2"
"count": 8
}
{
"item": "1274.80"
"count": 7
}
{
"item": "1239.50"
"count": 6
}
]
"smallest": "444.9"
"sum": "15230.80"
}
"format": {
"precisionStyle": "standard"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769089
"name": "% Energy Savings"
"dataTypeName": "percent"
"description": "Percent of energy savings"
"fieldName": "energy_savings"
"position": 5
"renderTypeName": "percent"
"tableColumnId": 19693294
"width": 292
"cachedContents": {
"largest": "67.90"
"non_null": 15
"average": "64.08"
"null": 0
"top": [
{
"item": "61.10"
"count": 20
}
{
"item": "67.90"
"count": 19
}
{
"item": "66.70"
"count": 18
}
{
"item": "64.80"
"count": 17
}
{
"item": "67.40"
"count": 16
}
{
"item": "64.20"
"count": 15
}
{
"item": "64.40"
"count": 14
}
{
"item": "60.50"
"count": 13
}
{
"item": "63.10"
"count": 12
}
{
"item": "61.60"
"count": 11
}
{
"item": "65.40"
"count": 10
}
{
"item": "62.30"
"count": 9
}
{
"item": "64.10"
"count": 8
}
{
"item": "63.50"
"count": 7
}
]
"smallest": "60.50"
"sum": "961.20"
}
"format": {
"view": "percent_bar_and_text"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769090
"name": "Annual C02 Reduction (Metric Tons)"
"dataTypeName": "number"
"description": "Annual reduction in carbon dioxide (in metric tons)"
"fieldName": "annual_c02_reduction_metric_tons"
"position": 6
"renderTypeName": "number"
"tableColumnId": 19693295
"width": 292
"cachedContents": {
"largest": "7857.10"
"non_null": 15
"average": "4357.166666666667"
"null": 0
"top": [
{
"item": "2666.90"
"count": 20
}
{
"item": "2270.60"
"count": 19
}
{
"item": "5120.20"
"count": 18
}
{
"item": "3479.00"
"count": 17
}
{
"item": "4818.00"
"count": 16
}
{
"item": "3439.00"
"count": 15
}
{
"item": "3436.80"
"count": 14
}
{
"item": "5381.20"
"count": 13
}
{
"item": "4171.70"
"count": 12
}
{
"item": "4212.10"
"count": 11
}
{
"item": "4436.00"
"count": 10
}
{
"item": "7857.10"
"count": 9
}
{
"item": "3378.10"
"count": 8
}
{
"item": "5497.80"
"count": 7
}
{
"item": "5193.00"
"count": 6
}
]
"smallest": "2270.60"
"sum": "65357.50"
}
"format": {
"precisionStyle": "standard"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769091
"name": "Annual Energy Savings (GWh)"
"dataTypeName": "number"
"description": "Annual energy savings (in gigawatt hours)"
"fieldName": "annual_energy_savings_gwh"
"position": 7
"renderTypeName": "number"
"tableColumnId": 19693296
"width": 257
"cachedContents": {
"largest": "13.288"
"non_null": 15
"average": "7.363333333333333"
"null": 0
"top": [
{
"item": "4.51"
"count": 20
}
{
"item": "3.84"
"count": 19
}
{
"item": "8.659"
"count": 18
}
{
"item": "5.884"
"count": 17
}
{
"item": "8.128"
"count": 16
}
{
"item": "5.816"
"count": 15
}
{
"item": "5.812"
"count": 14
}
{
"item": "9.101"
"count": 13
}
{
"item": "7.055"
"count": 12
}
{
"item": "7.123"
"count": 11
}
{
"item": "7.502"
"count": 10
}
{
"item": "13.288"
"count": 9
}
{
"item": "5.652"
"count": 8
}
{
"item": "9.298"
"count": 7
}
{
"item": "8.782"
"count": 6
}
]
"smallest": "3.84"
"sum": "110.450"
}
"format": {
"precisionStyle": "standard"
"noCommas": "false"
"align": "right"
}
}
{
"id": 362769092
"name": "Annual Energy Savings"
"dataTypeName": "number"
"description": "Annual energy savings (in dollars)"
"fieldName": "annual_energy_savings"
"position": 8
"renderTypeName": "number"
"tableColumnId": 19693297
"width": 219
"cachedContents": {
"largest": "1187143.77"
"non_null": 15
"average": "654443.2553333333"
"null": 0
"top": [
{
"item": "399395.06"
"count": 20
}
{
"item": "339601.01"
"count": 19
}
{
"item": "772858.96"
"count": 18
}
{
"item": "520113.91"
"count": 17
}
{
"item": "718515.25"
"count": 16
}
{
"item": "521940.09"
"count": 15
}
{
"item": "518672.48"
"count": 14
}
{
"item": "804834.69"
"count": 13
}
{
"item": "634594.91"
"count": 12
}
{
"item": "629708.79"
"count": 11
}
{
"item": "671390.56"
"count": 10
}
{
"item": "1187143.77"
"count": 9
}
{
"item": "499593.48"
"count": 8
}
{
"item": "821921.72"
"count": 7
}
{
"item": "776364.15"
"count": 6
}
]
"smallest": "339601.01"
"sum": "9816648.83"
}
"format": {
"precisionStyle": "currency"
"humane": "false"
"currencyStyle": "USD"
"precision": "2"
"align": "right"
}
}
]
"grants": [
{
"inherited": false
"type": "viewer"
"flags": [
"public"
]
}
]
"license": {
"name": "Creative Commons 1.0 Universal (Public Domain Dedication)"
"logoUrl": "images/licenses/ccZero.png"
"termsLink": "http://creativecommons.org/publicdomain/zero/1.0/legalcode"
}
"metadata": {
"rdfSubject": "0"
"rdfClass": ""
"custom_fields": {
"Committed Update Frequency": {
"Refresh rate": "Monthly"
}
"Location Specified": {
"Does this data have a Location column? (Yes or No)": "Yes"
"What geographic unit is the data collected?": "Other"
}
"Data Owner": {
"Department": "Bureau of Street Lighting"
}
}
"rowIdentifier": "0"
"rowLabel": "Row"
}
"owner": {
"id": "kmuv-58sk"
"displayName": "Public Works: Street Lighting OpenData"
"profileImageUrlLarge": "/api/users/kmuv-58sk/profile_images/LARGE"
"profileImageUrlMedium": "/api/users/kmuv-58sk/profile_images/THUMB"
"profileImageUrlSmall": "/api/users/kmuv-58sk/profile_images/TINY"
"screenName": "Public Works: Street Lighting OpenData"
"type": "interactive"
}
"query": {}
"rights": [
"read"
]
"tableAuthor": {
"id": "kmuv-58sk"
"displayName": "Public Works: Street Lighting OpenData"
"profileImageUrlLarge": "/api/users/kmuv-58sk/profile_images/LARGE"
"profileImageUrlMedium": "/api/users/kmuv-58sk/profile_images/THUMB"
"profileImageUrlSmall": "/api/users/kmuv-58sk/profile_images/TINY"
"screenName": "Public Works: Street Lighting OpenData"
"type": "interactive"
}
"tags": [
"streetlight"
"led"
"energy"
"savings"
"pollution"
]
"flags": [
"default"
"restorable"
"restorePossibleForType"
]
}
}
"data": [
[
1
"F8FF9D43-F3AE-4E37-BA6D-4DD12D78E701"
1
1528493212
"883854"
1528493212
"883854"
null
"1"
"7616"
"1808.70"
"703.2"
"61.10"
"2666.90"
"4.51"
"399395.06"
]
[
2
"C70930B1-4554-44B7-A830-F9C27AF47DB8"
2
1528493212
"883854"
1528493212
"883854"
null
"2"
"5681"
"1386.10"
"444.9"
"67.90"
"2270.60"
"3.84"
"339601.01"
]
[
3
"188169B5-9F4E-43DE-A6ED-6AEA081BDF3F"
3
1528493212
"883854"
1528493212
"883854"
null
"3"
"14421"
"3182.40"
"1060.00"
"66.70"
"5120.20"
"8.659"
"772858.96"
]
[
4
"1465048F-9051-4C06-939A-7F3B66D4140E"
4
1528493212
"883854"
1528493212
"883854"
null
"4"
"9787"
"2224.90"
"782.8"
"64.80"
"3479.00"
"5.884"
"520113.91"
]
[
5
"D91A0A5F-6010-46CC-A59F-CC3CF78D0DB4"
5
1528493212
"883854"
1528493212
"883854"
null
"5"
"11737"
"2956.30"
"964.1"
"67.40"
"4818.00"
"8.128"
"718515.25"
]
[
6
"5A914111-5541-48A4-81EF-DE3F74286CA0"
6
1528493212
"883854"
1528493212
"883854"
null
"6"
"9176"
"2218.90"
"793.4"
"64.20"
"3439.00"
"5.816"
"521940.09"
]
[
7
"3328525F-5245-4852-87C8-70F985CFE1B0"
7
1528493212
"883854"
1528493212
"883854"
null
"7"
"9465"
"2211.40"
"786.8"
"64.40"
"3436.80"
"5.812"
"518672.48"
]
[
8
"FAA5C865-DCE8-496F-8D25-094859C4E749"
8
1528493212
"883854"
1528493212
"883854"
null
"8"
"17029"
"3684.10"
"1453.60"
"60.50"
"5381.20"
"9.101"
"804834.69"
]
[
9
"96A7A2F1-1F51-43C6-B9FD-F1222BF6FFD3"
9
1528493212
"883854"
1528493212
"883854"
null
"9"
"11737"
"2742.20"
"1013.00"
"63.10"
"4171.70"
"7.055"
"634594.91"
]
[
10
"9928E187-ECAC-4DB1-8A43-A7478A95C87E"
10
1528493212
"883854"
1528493212
"883854"
null
"10"
"12749"
"2834.50"
"1088.60"
"61.60"
"4212.10"
"7.123"
"629708.79"
]
[
11
"28BD3582-E1DC-44DF-BDC5-01B1073D433F"
11
1528493212
"883854"
1528493212
"883854"
null
"11"
"11084"
"2812.30"
"973.5"
"65.40"
"4436.00"
"7.502"
"671390.56"
]
[
12
"C1F97EB1-BDA2-429C-AAED-06899B1B2412"
12
1528493212
"883854"
1528493212
"883854"
null
"12"
"25314"
"5071.20"
"1814.40"
"64.20"
"7857.10"
"13.288"
"1187143.77"
]
[
13
"3A50F6FD-3DBC-43A3-BD5D-5E0773191979"
13
1528493212
"883854"
1528493212
"883854"
null
"13"
"9442"
"2223.30"
"838.2"
"62.30"
"3378.10"
"5.652"
"499593.48"
]
[
14
"FEEA9336-D8A1-472C-97AD-CCB134B55B93"
14
1528493212
"883854"
1528493212
"883854"
null
"14"
"14069"
"3553.70"
"1274.80"
"64.10"
"5497.80"
"9.298"
"821921.72"
]
[
15
"3AA0C008-E20B-4239-AC66-2A9D031B06E6"
15
1528493212
"883854"
1528493212
"883854"
null
"15"
"15270"
"3392.10"
"1239.50"
"63.50"
"5193.00"
"8.782"
"776364.15"
]
]