{ "title": "Marketing insights - Ticket sales by show", "oid": "5d8bfc1205de7d1d006d81fd", "desc": "", "source": null, "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "instanceid": "E5F46-27D9-93", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": "744px", "defaultWidth": 512, "widgetid": "5d8bfc1d05de7d1d006d820d" } ], "width": 100, "stretchable": false, "pxlWidth": 1430, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "5d8bfd1b05de7d1d006d8244" } ], "width": 50.02638522427441, "stretchable": false, "pxlWidth": 948, "index": 0 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d8bfd2105de7d1d006d8248", "height": 384 } ], "width": 49.97361477572559, "stretchable": false, "pxlWidth": 947, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": 512, "defaultWidth": 512, "widgetid": "5d8d074505de7d1d006e15c7" } ] } ] } ], "pxlWidth": 1430, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets" }, "editing": true, "filters": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Year", "dim": "[PERFORMANCE DATE.Fiscal Year]", "datatype": "numeric", "title": "Fiscal Year", "collapsed": false, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "filter": { "explicit": false, "multiSelection": "true", "exclude": { "members": [ "2018" ] } } }, "isCascading": false, "disabled": false, "instanceid": "9EB30-05D2-F6" }, { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category", "collapsed": false, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false, "instanceid": "C1C17-5EE1-6D" }, { "isCascading": false, "disabled": false, "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Hawaiian Vacay Raffle Ticket", "Our MISSION: PARTY!", "Donation Voucher", "Voucher Performance", "South African Songbook" ] } } }, "instanceid": "B6A59-836E-12" }, { "jaql": { "datatype": "text", "dim": "[PERFORMANCE DETAIL.Production Season]", "title": "Production Season", "column": "Production Season", "table": "PERFORMANCE DETAIL", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false, "instanceid": "D9F69-3DB0-72" }, { "jaql": { "datatype": "text", "dim": "[CONSTITUENT.Primary Address City]", "title": "Primary Address City", "column": "Primary Address City", "table": "CONSTITUENT", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false, "instanceid": "0E975-6947-D9" } ], "filterToDatasourceMapping": {}, "defaultFilters": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Year", "dim": "[PERFORMANCE DATE.Fiscal Year]", "datatype": "numeric", "title": "Fiscal Year", "collapsed": false, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "filter": { "explicit": false, "multiSelection": "true", "exclude": { "members": [ "2018" ] } } }, "isCascading": false, "disabled": false }, { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category", "collapsed": false, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false }, { "isCascading": false, "disabled": false, "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Hawaiian Vacay Raffle Ticket", "Our MISSION: PARTY!", "Donation Voucher", "Voucher Performance", "South African Songbook" ] } } } }, { "jaql": { "datatype": "text", "dim": "[PERFORMANCE DETAIL.Production Season]", "title": "Production Season", "column": "Production Season", "table": "PERFORMANCE DETAIL", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false }, { "jaql": { "datatype": "text", "dim": "[CONSTITUENT.Primary Address City]", "title": "Primary Address City", "column": "Primary Address City", "table": "CONSTITUENT", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false } ], "widgets": [ { "title": "Revenue by Production Season and Price Type Category", "subtype": "bar/stacked", "oid": "5d8bfc1d05de7d1d006d820d", "desc": null, "source": "5cbe67ac87d1001f140514be", "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "drillHistory": [ { "jaql": { "table": "CONSTITUENT", "column": "Primary Address City", "dim": "[CONSTITUENT.Primary Address City]", "datatype": "text", "merged": true, "title": "Primary Address City" }, "parent": { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "activeHierarchy": { "_id": "5a4e6f6d72fa5c9cb522b894", "title": "Production Season to Performance" } }, "through": { "jaql": { "datatype": "text", "dim": "[PERFORMANCE DETAIL.Production Season]", "title": "Production Season", "column": "Production Season", "table": "PERFORMANCE DETAIL", "filter": { "explicit": true, "multiSelection": true, "members": [ "VIVA Momix" ] } } }, "activeHierarchy": { "_id": "5a4e6f6d72fa5c9cb522b894", "title": "Production Season to Performance" } } ], "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "activeHierarchy": { "_id": "5a4e6f6d72fa5c9cb522b894", "title": "Production Season to Performance" } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "title": "Budget Amount" }, "format": { "mask": { "decimals": "auto", "percent": true } } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET.Ticket Paid Amount1]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color_bkp": { "color": "#EF5740", "type": "color" } }, "field": { "id": "[SEAT & TICKET.Ticket Paid Amount1]_sum", "index": 1 }, "regressionType": "none" } ] }, { "name": "break by", "items": [ { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category" }, "format": { "members": { "Standard": { "color": "#6d9cbb", "title": "Standard", "sortData": "Standard", "inResultset": true }, "Subscription": { "color": "#ff851b", "title": "Subscription", "sortData": "Subscription", "inResultset": true }, "Comp": { "color": "#ffff01", "title": "Comp", "sortData": "Comp", "inResultset": true }, "Discount": { "color": "#00C850", "title": "Discount", "sortData": "Discount", "inResultset": true }, "Adult": { "color": "#FB7805", "title": "Adult", "sortData": "Adult" }, "Child": { "color": "#BEBEBE", "title": "Child", "sortData": "Child" }, "Other": { "color": "#EFF792", "title": "Other", "sortData": "Other" }, "FREE": { "color": "#fc543d", "title": "FREE", "sortData": "FREE" } } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category", "filter": { "doesntContain": "none" }, "collapsed": false } } ] } ] }, "type": "chart/bar", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": true }, "x2Title": { "enabled": true, "text": "% to Goal" }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" }, { "id": "budget_amount", "title": "Budget Amount", "singular": "Budget Amount", "plural": "Budget Amount" }, { "id": "price_type_category", "title": "Price Type Category", "singular": "Price Type Category", "plural": "Price Type Category" } ] } }, "instanceid": "2803F-1F84-04", "queryStartTime": "2019-09-26T14:13:09", "disableSelctor": false, "widgetTimingLoged": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "canEditFilters": true, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "chart": { "0": {}, "context": {}, "length": 1 }, "continuousDates": false, "nullAsZero": false, "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "maxCharsPerLabelXAxis": 19, "selectorLocked": false, "previousScrollerLocation": { "min": null, "max": null } }, "dashboardid": "5d8bfc1205de7d1d006d81fd", "drawing": true }, { "title": "Paid Ticket Count by City", "subtype": "pie/classic", "oid": "5d8bfd1b05de7d1d006d8244", "desc": null, "source": null, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Primary Address City", "dim": "[CONSTITUENT.Primary Address City]", "datatype": "text", "merged": true, "title": "Primary Address City" }, "field": { "id": "[CONSTITUENT.Primary Address City]", "index": 0 }, "format": { "members": { "(none)": { "color": "#547A94", "title": "(none)", "sortData": "(none)", "inResultset": true }, "Alameda": { "color": "#F48E06", "title": "Alameda", "sortData": "Alameda", "inResultset": true }, "Albany": { "color": "#DB4935", "title": "Albany", "sortData": "Albany", "inResultset": true }, "Alberta ": { "color": "#333333", "title": "Alberta ", "sortData": "Alberta ", "inResultset": true }, "Albuquerque": { "color": "#008775", "title": "Albuquerque", "sortData": "Albuquerque", "inResultset": true }, "Alexandria": { "color": "#618caa", "title": "Alexandria", "sortData": "Alexandria", "inResultset": true }, "Altadena": { "color": "#ff9b16", "title": "Altadena", "sortData": "Altadena", "inResultset": true }, "Anacortes": { "color": "#fc543d", "title": "Anacortes", "sortData": "Anacortes", "inResultset": true }, "APTOS": { "color": "#3b3b3b", "title": "APTOS", "sortData": "APTOS", "inResultset": true }, "Aptos": { "color": "#009b87", "title": "Aptos", "sortData": "Aptos", "inResultset": true }, "aptos": { "color": "#6897b7", "title": "aptos", "sortData": "aptos", "inResultset": true }, "Aptos ": { "color": "#ffa022", "title": "Aptos ", "sortData": "Aptos ", "inResultset": true }, "Aromas": { "color": "#ff5d47", "title": "Aromas", "sortData": "Aromas", "inResultset": true }, "Aromas ": { "color": "#3f3f3f", "title": "Aromas ", "sortData": "Aromas ", "inResultset": true }, "Arundel": { "color": "#00a790", "title": "Arundel", "sortData": "Arundel", "inResultset": true }, "ASHLAND": { "color": "#6fa1c3", "title": "ASHLAND", "sortData": "ASHLAND", "inResultset": true }, "Atherton": { "color": "#ffa62e", "title": "Atherton", "sortData": "Atherton", "inResultset": true }, "Atlanta": { "color": "#ff6752", "title": "Atlanta", "sortData": "Atlanta", "inResultset": true }, "Austin": { "color": "#434343", "title": "Austin", "sortData": "Austin", "inResultset": true }, "Bainbridge Island": { "color": "#00b29a", "title": "Bainbridge Island", "sortData": "Bainbridge Island", "inResultset": true }, "Bellaire": { "color": "#74a9cd", "title": "Bellaire", "sortData": "Bellaire", "inResultset": true }, "BELLEVUE": { "color": "#ffaa38", "title": "BELLEVUE", "sortData": "BELLEVUE", "inResultset": true }, "Bellingham": { "color": "#ff6f5b", "title": "Bellingham", "sortData": "Bellingham", "inResultset": true }, "Belmont": { "color": "#474747", "title": "Belmont", "sortData": "Belmont", "inResultset": true }, "Belvedere": { "color": "#00bba2", "title": "Belvedere", "sortData": "Belvedere", "inResultset": true }, "Ben Lomond": { "color": "#79afd5", "title": "Ben Lomond", "sortData": "Ben Lomond", "inResultset": true }, "ben lomond": { "color": "#ffad3f", "title": "ben lomond", "sortData": "ben lomond", "inResultset": true }, "Benici": { "color": "#ff7461", "title": "Benici", "sortData": "Benici", "inResultset": true }, "Benicia": { "color": "#494949", "title": "Benicia", "sortData": "Benicia", "inResultset": true }, "BERKELEY": { "color": "#00c2a8", "title": "BERKELEY", "sortData": "BERKELEY", "inResultset": true }, "Berkeley": { "color": "#7cb4db", "title": "Berkeley", "sortData": "Berkeley", "inResultset": true }, "beverly hills": { "color": "#ffaf45", "title": "beverly hills", "sortData": "beverly hills", "inResultset": true }, "Big Sur": { "color": "#ff7966", "title": "Big Sur", "sortData": "Big Sur", "inResultset": true }, "Bloomfield Hills": { "color": "#4b4b4b", "title": "Bloomfield Hills", "sortData": "Bloomfield Hills", "inResultset": true }, "Blue lake": { "color": "#00c7ad", "title": "Blue lake", "sortData": "Blue lake", "inResultset": true }, "Boise": { "color": "#7fb8df", "title": "Boise", "sortData": "Boise", "inResultset": true }, "Boulder": { "color": "#ffb14a", "title": "Boulder", "sortData": "Boulder", "inResultset": true }, "BOULDER CREEK": { "color": "#ff7d6b", "title": "BOULDER CREEK", "sortData": "BOULDER CREEK", "inResultset": true }, "Boulder Creek": { "color": "#4d4d4d", "title": "Boulder Creek", "sortData": "Boulder Creek", "inResultset": true }, "Brentwood": { "color": "#00ccb1", "title": "Brentwood", "sortData": "Brentwood", "inResultset": true }, "Brooklyn": { "color": "#81bce4", "title": "Brooklyn", "sortData": "Brooklyn", "inResultset": true }, "Buellton": { "color": "#ffb34e", "title": "Buellton", "sortData": "Buellton", "inResultset": true }, "Burlington": { "color": "#ff806f", "title": "Burlington", "sortData": "Burlington", "inResultset": true }, "Cambria": { "color": "#4e4e4e", "title": "Cambria", "sortData": "Cambria", "inResultset": true }, "Campbell": { "color": "#00d0b4", "title": "Campbell", "sortData": "Campbell", "inResultset": true }, "Campbell ": { "color": "#83bfe7", "title": "Campbell ", "sortData": "Campbell ", "inResultset": true }, "Capistrano Beach ": { "color": "#ffb552", "title": "Capistrano Beach ", "sortData": "Capistrano Beach ", "inResultset": true }, "Capitola": { "color": "#ff8372", "title": "Capitola", "sortData": "Capitola", "inResultset": true }, "Capitola ": { "color": "#505050", "title": "Capitola ", "sortData": "Capitola ", "inResultset": true }, "Carlsbad": { "color": "#00d3b7", "title": "Carlsbad", "sortData": "Carlsbad", "inResultset": true }, "CARMEL": { "color": "#85c1eb", "title": "CARMEL", "sortData": "CARMEL", "inResultset": true }, "Carmel": { "color": "#ffb655", "title": "Carmel", "sortData": "Carmel", "inResultset": true }, "carmel": { "color": "#ff8575", "title": "carmel", "sortData": "carmel", "inResultset": true }, "Carmel ": { "color": "#515151", "title": "Carmel ", "sortData": "Carmel ", "inResultset": true }, "Carmel By The Sea": { "color": "#00d6ba", "title": "Carmel By The Sea", "sortData": "Carmel By The Sea", "inResultset": true }, "Carmel by the Sea": { "color": "#ffb655", "title": "Carmel by the Sea", "sortData": "Carmel by the Sea", "inResultset": true }, "Carmel Highlands": { "color": "#ff8575", "title": "Carmel Highlands", "sortData": "Carmel Highlands", "inResultset": true }, "Carmel Valley": { "color": "#515151", "title": "Carmel Valley", "sortData": "Carmel Valley", "inResultset": true }, "carmel valley": { "color": "#00d6ba", "title": "carmel valley", "sortData": "carmel valley", "inResultset": true }, "Carmel Valley ": { "color": "#85c1eb", "title": "Carmel Valley ", "sortData": "Carmel Valley ", "inResultset": true }, "Carmel Valley Village": { "color": "#ffb655", "title": "Carmel Valley Village", "sortData": "Carmel Valley Village", "inResultset": true }, "Carmel, CA": { "color": "#ff8575", "title": "Carmel, CA", "sortData": "Carmel, CA", "inResultset": true }, "Carmel-by-the-Sea": { "color": "#515151", "title": "Carmel-by-the-Sea", "sortData": "Carmel-by-the-Sea", "inResultset": true }, "Carmichael": { "color": "#00d6ba", "title": "Carmichael", "sortData": "Carmichael", "inResultset": true }, "CARPINTERIA": { "color": "#85c1eb", "title": "CARPINTERIA", "sortData": "CARPINTERIA", "inResultset": true }, "Carpinteria ": { "color": "#ffb655", "title": "Carpinteria ", "sortData": "Carpinteria ", "inResultset": true }, "Carson City": { "color": "#ff8575", "title": "Carson City", "sortData": "Carson City", "inResultset": true }, "Castle Rock": { "color": "#515151", "title": "Castle Rock", "sortData": "Castle Rock", "inResultset": true }, "Castro valley": { "color": "#00d6ba", "title": "Castro valley", "sortData": "Castro valley", "inResultset": true }, "Cayucos": { "color": "#85c1eb", "title": "Cayucos", "sortData": "Cayucos", "inResultset": true }, "Cazadero": { "color": "#ffb655", "title": "Cazadero", "sortData": "Cazadero", "inResultset": true }, "Chagrin Falls": { "color": "#ff8575", "title": "Chagrin Falls", "sortData": "Chagrin Falls", "inResultset": true }, "Chandler": { "color": "#515151", "title": "Chandler", "sortData": "Chandler", "inResultset": true }, "Chicago": { "color": "#00d6ba", "title": "Chicago", "sortData": "Chicago", "inResultset": true }, "Chico": { "color": "#85c1eb", "title": "Chico", "sortData": "Chico", "inResultset": true }, "Chico ": { "color": "#ffb655", "title": "Chico ", "sortData": "Chico ", "inResultset": true }, "Cincinnati": { "color": "#ff8575", "title": "Cincinnati", "sortData": "Cincinnati", "inResultset": true }, "Clayton": { "color": "#515151", "title": "Clayton", "sortData": "Clayton", "inResultset": true }, "Cloverdale": { "color": "#00d6ba", "title": "Cloverdale", "sortData": "Cloverdale", "inResultset": true }, "Columbus": { "color": "#85c1eb", "title": "Columbus", "sortData": "Columbus", "inResultset": true }, "Concord": { "color": "#ffb655", "title": "Concord", "sortData": "Concord", "inResultset": true }, "Corona Del Mar": { "color": "#ff8575", "title": "Corona Del Mar", "sortData": "Corona Del Mar", "inResultset": true }, "Corral De Tierra": { "color": "#515151", "title": "Corral De Tierra", "sortData": "Corral De Tierra", "inResultset": true }, "Corral de Tierra": { "color": "#00d6ba", "title": "Corral de Tierra", "sortData": "Corral de Tierra", "inResultset": true }, "Corral de Tierra ": { "color": "#85c1eb", "title": "Corral de Tierra ", "sortData": "Corral de Tierra ", "inResultset": true }, "Corvallis ": { "color": "#ffb655", "title": "Corvallis ", "sortData": "Corvallis ", "inResultset": true }, "Costa Mesa ": { "color": "#ff8575", "title": "Costa Mesa ", "sortData": "Costa Mesa ", "inResultset": true }, "Cupertino": { "color": "#515151", "title": "Cupertino", "sortData": "Cupertino", "inResultset": true }, "DALLAS": { "color": "#00d6ba", "title": "DALLAS", "sortData": "DALLAS", "inResultset": true }, "Dallas": { "color": "#85c1eb", "title": "Dallas", "sortData": "Dallas", "inResultset": true }, "dallas": { "color": "#ffb655", "title": "dallas", "sortData": "dallas", "inResultset": true }, "Dana Point": { "color": "#ff8575", "title": "Dana Point", "sortData": "Dana Point", "inResultset": true }, "DANVILLE": { "color": "#515151", "title": "DANVILLE", "sortData": "DANVILLE", "inResultset": true }, "Danville": { "color": "#00d6ba", "title": "Danville", "sortData": "Danville", "inResultset": true }, "Davenport": { "color": "#85c1eb", "title": "Davenport", "sortData": "Davenport", "inResultset": true }, "Davis": { "color": "#ffb655", "title": "Davis", "sortData": "Davis", "inResultset": true }, "Del Rey Oaks": { "color": "#ff8575", "title": "Del Rey Oaks", "sortData": "Del Rey Oaks", "inResultset": true }, "Denver": { "color": "#515151", "title": "Denver", "sortData": "Denver", "inResultset": true }, "Discovery Bay ": { "color": "#00d6ba", "title": "Discovery Bay ", "sortData": "Discovery Bay ", "inResultset": true }, "Douglas": { "color": "#85c1eb", "title": "Douglas", "sortData": "Douglas", "inResultset": true }, "E%46 Brunswick": { "color": "#ffb655", "title": "E. Brunswick", "sortData": "E. Brunswick", "inResultset": true }, "East Garrison": { "color": "#ff8575", "title": "East Garrison", "sortData": "East Garrison", "inResultset": true }, "Eden Prairie": { "color": "#515151", "title": "Eden Prairie", "sortData": "Eden Prairie", "inResultset": true }, "El Cerrito": { "color": "#00d6ba", "title": "El Cerrito", "sortData": "El Cerrito", "inResultset": true }, "El Dorado Hills": { "color": "#85c1eb", "title": "El Dorado Hills", "sortData": "El Dorado Hills", "inResultset": true }, "El Paso": { "color": "#ffb655", "title": "El Paso", "sortData": "El Paso", "inResultset": true }, "Elk Grove": { "color": "#ff8575", "title": "Elk Grove", "sortData": "Elk Grove", "inResultset": true }, "Elverta": { "color": "#515151", "title": "Elverta", "sortData": "Elverta", "inResultset": true }, "Encinitas": { "color": "#00d6ba", "title": "Encinitas", "sortData": "Encinitas", "inResultset": true }, "Fair Oaks": { "color": "#85c1eb", "title": "Fair Oaks", "sortData": "Fair Oaks", "inResultset": true }, "Fallbrook": { "color": "#ffb655", "title": "Fallbrook", "sortData": "Fallbrook", "inResultset": true }, "Farmington": { "color": "#ff8575", "title": "Farmington", "sortData": "Farmington", "inResultset": true }, "Felton": { "color": "#515151", "title": "Felton", "sortData": "Felton", "inResultset": true }, "Folsom": { "color": "#00d6ba", "title": "Folsom", "sortData": "Folsom", "inResultset": true }, "Fonthill, Ontario": { "color": "#85c1eb", "title": "Fonthill, Ontario", "sortData": "Fonthill, Ontario", "inResultset": true }, "Forest Grove": { "color": "#ffb655", "title": "Forest Grove", "sortData": "Forest Grove", "inResultset": true }, "Fort collins": { "color": "#ff8575", "title": "Fort collins", "sortData": "Fort collins", "inResultset": true }, "Fortville": { "color": "#515151", "title": "Fortville", "sortData": "Fortville", "inResultset": true }, "Freedom": { "color": "#00d6ba", "title": "Freedom", "sortData": "Freedom", "inResultset": true }, "Fremont": { "color": "#85c1eb", "title": "Fremont", "sortData": "Fremont", "inResultset": true }, "FRESNO": { "color": "#ffb655", "title": "FRESNO", "sortData": "FRESNO", "inResultset": true }, "Fresno": { "color": "#ff8575", "title": "Fresno", "sortData": "Fresno", "inResultset": true }, "Frisco": { "color": "#515151", "title": "Frisco", "sortData": "Frisco", "inResultset": true }, "Gardnerville": { "color": "#00d6ba", "title": "Gardnerville", "sortData": "Gardnerville", "inResultset": true }, "Georgetown": { "color": "#85c1eb", "title": "Georgetown", "sortData": "Georgetown", "inResultset": true }, "Gilroy": { "color": "#ffb655", "title": "Gilroy", "sortData": "Gilroy", "inResultset": true }, "Gilroy ": { "color": "#ff8575", "title": "Gilroy ", "sortData": "Gilroy ", "inResultset": true }, "Glendale ": { "color": "#515151", "title": "Glendale ", "sortData": "Glendale ", "inResultset": true }, "Gold River": { "color": "#00d6ba", "title": "Gold River", "sortData": "Gold River", "inResultset": true }, "Gonzales": { "color": "#85c1eb", "title": "Gonzales", "sortData": "Gonzales", "inResultset": true }, "Grand Rapids": { "color": "#ffb655", "title": "Grand Rapids", "sortData": "Grand Rapids", "inResultset": true }, "Grand Ronde": { "color": "#ff8575", "title": "Grand Ronde", "sortData": "Grand Ronde", "inResultset": true }, "Grass Valley": { "color": "#515151", "title": "Grass Valley", "sortData": "Grass Valley", "inResultset": true }, "Greenbank": { "color": "#00d6ba", "title": "Greenbank", "sortData": "Greenbank", "inResultset": true }, "Greenbrae ": { "color": "#85c1eb", "title": "Greenbrae ", "sortData": "Greenbrae ", "inResultset": true }, "Greenfield": { "color": "#ffb655", "title": "Greenfield", "sortData": "Greenfield", "inResultset": true }, "Greenwich": { "color": "#ff8575", "title": "Greenwich", "sortData": "Greenwich", "inResultset": true }, "Half Moon Bay": { "color": "#515151", "title": "Half Moon Bay", "sortData": "Half Moon Bay", "inResultset": true }, "Hayward": { "color": "#00d6ba", "title": "Hayward", "sortData": "Hayward", "inResultset": true }, "Healdsburg": { "color": "#85c1eb", "title": "Healdsburg", "sortData": "Healdsburg", "inResultset": true }, "Hercules": { "color": "#ffb655", "title": "Hercules", "sortData": "Hercules", "inResultset": true }, "Hillsborough": { "color": "#ff8575", "title": "Hillsborough", "sortData": "Hillsborough", "inResultset": true }, "Hollister": { "color": "#515151", "title": "Hollister", "sortData": "Hollister", "inResultset": true }, "Hollister ": { "color": "#00d6ba", "title": "Hollister ", "sortData": "Hollister ", "inResultset": true }, "Hollywood": { "color": "#85c1eb", "title": "Hollywood", "sortData": "Hollywood", "inResultset": true }, "Honolulu": { "color": "#ffb655", "title": "Honolulu", "sortData": "Honolulu", "inResultset": true }, "Houston": { "color": "#ff8575", "title": "Houston", "sortData": "Houston", "inResultset": true }, "Huntington Beach": { "color": "#515151", "title": "Huntington Beach", "sortData": "Huntington Beach", "inResultset": true }, "Iaasquah": { "color": "#00d6ba", "title": "Iaasquah", "sortData": "Iaasquah", "inResultset": true }, "Incline Village": { "color": "#85c1eb", "title": "Incline Village", "sortData": "Incline Village", "inResultset": true }, "Juneau": { "color": "#ffb655", "title": "Juneau", "sortData": "Juneau", "inResultset": true }, "Jupiter": { "color": "#ff8575", "title": "Jupiter", "sortData": "Jupiter", "inResultset": true }, "Kapaa": { "color": "#515151", "title": "Kapaa", "sortData": "Kapaa", "inResultset": true }, "Kenwood": { "color": "#00d6ba", "title": "Kenwood", "sortData": "Kenwood", "inResultset": true }, "Kerman": { "color": "#85c1eb", "title": "Kerman", "sortData": "Kerman", "inResultset": true }, "King City": { "color": "#ffb655", "title": "King City", "sortData": "King City", "inResultset": true }, "LA": { "color": "#ff8575", "title": "LA", "sortData": "LA", "inResultset": true }, "La Canada": { "color": "#515151", "title": "La Canada", "sortData": "La Canada", "inResultset": true }, "La Mesa": { "color": "#00d6ba", "title": "La Mesa", "sortData": "La Mesa", "inResultset": true }, "La Porte": { "color": "#85c1eb", "title": "La Porte", "sortData": "La Porte", "inResultset": true }, "La Quinta": { "color": "#ffb655", "title": "La Quinta", "sortData": "La Quinta", "inResultset": true }, "La Selva Beach": { "color": "#ff8575", "title": "La Selva Beach", "sortData": "La Selva Beach", "inResultset": true }, "Ladera Ranch": { "color": "#515151", "title": "Ladera Ranch", "sortData": "Ladera Ranch", "inResultset": true }, "LAFAYETTE": { "color": "#00d6ba", "title": "LAFAYETTE", "sortData": "LAFAYETTE", "inResultset": true }, "Lafayette ": { "color": "#85c1eb", "title": "Lafayette ", "sortData": "Lafayette ", "inResultset": true }, "Lahaina": { "color": "#ffb655", "title": "Lahaina", "sortData": "Lahaina", "inResultset": true }, "Lake Elsinore": { "color": "#ff8575", "title": "Lake Elsinore", "sortData": "Lake Elsinore", "inResultset": true }, "Lake Oswego": { "color": "#515151", "title": "Lake Oswego", "sortData": "Lake Oswego", "inResultset": true }, "Lakeport": { "color": "#00d6ba", "title": "Lakeport", "sortData": "Lakeport", "inResultset": true }, "Lakewood": { "color": "#85c1eb", "title": "Lakewood", "sortData": "Lakewood", "inResultset": true }, "lakewood": { "color": "#ffb655", "title": "lakewood", "sortData": "lakewood", "inResultset": true }, "Las Vegas": { "color": "#ff8575", "title": "Las Vegas", "sortData": "Las Vegas", "inResultset": true }, "Lee Vining": { "color": "#515151", "title": "Lee Vining", "sortData": "Lee Vining", "inResultset": true }, "Lincoln": { "color": "#00d6ba", "title": "Lincoln", "sortData": "Lincoln", "inResultset": true }, "Livermore": { "color": "#85c1eb", "title": "Livermore", "sortData": "Livermore", "inResultset": true }, "Livermore ": { "color": "#ffb655", "title": "Livermore ", "sortData": "Livermore ", "inResultset": true }, "Loma Linda ": { "color": "#ff8575", "title": "Loma Linda ", "sortData": "Loma Linda ", "inResultset": true }, "London": { "color": "#515151", "title": "London", "sortData": "London", "inResultset": true }, "Long beach": { "color": "#00d6ba", "title": "Long beach", "sortData": "Long beach", "inResultset": true }, "Longmont ": { "color": "#85c1eb", "title": "Longmont ", "sortData": "Longmont ", "inResultset": true }, "Longview": { "color": "#ffb655", "title": "Longview", "sortData": "Longview", "inResultset": true }, "Los Altos": { "color": "#ff8575", "title": "Los Altos", "sortData": "Los Altos", "inResultset": true }, "Los Altos Hills": { "color": "#515151", "title": "Los Altos Hills", "sortData": "Los Altos Hills", "inResultset": true }, "Los Angeles": { "color": "#00d6ba", "title": "Los Angeles", "sortData": "Los Angeles", "inResultset": true }, "Los angeles": { "color": "#85c1eb", "title": "Los angeles", "sortData": "Los angeles", "inResultset": true }, "Los Banos": { "color": "#ffb655", "title": "Los Banos", "sortData": "Los Banos", "inResultset": true }, "Los Gatos": { "color": "#ff8575", "title": "Los Gatos", "sortData": "Los Gatos", "inResultset": true }, "Los Gatos ": { "color": "#515151", "title": "Los Gatos ", "sortData": "Los Gatos ", "inResultset": true }, "louisville": { "color": "#00d6ba", "title": "louisville", "sortData": "louisville", "inResultset": true }, "Marana": { "color": "#85c1eb", "title": "Marana", "sortData": "Marana", "inResultset": true }, "Marina": { "color": "#ffb655", "title": "Marina", "sortData": "Marina", "inResultset": true }, "marina": { "color": "#ff8575", "title": "marina", "sortData": "marina", "inResultset": true }, "Marina ": { "color": "#515151", "title": "Marina ", "sortData": "Marina ", "inResultset": true }, "Mariposa": { "color": "#00d6ba", "title": "Mariposa", "sortData": "Mariposa", "inResultset": true }, "Mars Hill": { "color": "#85c1eb", "title": "Mars Hill", "sortData": "Mars Hill", "inResultset": true }, "Martinez": { "color": "#ffb655", "title": "Martinez", "sortData": "Martinez", "inResultset": true }, "Marysville": { "color": "#ff8575", "title": "Marysville", "sortData": "Marysville", "inResultset": true }, "Menlo Park": { "color": "#515151", "title": "Menlo Park", "sortData": "Menlo Park", "inResultset": true }, "Metaire": { "color": "#00d6ba", "title": "Metaire", "sortData": "Metaire", "inResultset": true }, "Miami": { "color": "#85c1eb", "title": "Miami", "sortData": "Miami", "inResultset": true }, "Mill Valley": { "color": "#ffb655", "title": "Mill Valley", "sortData": "Mill Valley", "inResultset": true }, "Milpitas": { "color": "#ff8575", "title": "Milpitas", "sortData": "Milpitas", "inResultset": true }, "Missouri Valley": { "color": "#515151", "title": "Missouri Valley", "sortData": "Missouri Valley", "inResultset": true }, "Modesto": { "color": "#00d6ba", "title": "Modesto", "sortData": "Modesto", "inResultset": true }, "Monte Sereno": { "color": "#85c1eb", "title": "Monte Sereno", "sortData": "Monte Sereno", "inResultset": true }, "MONTEREY": { "color": "#ffb655", "title": "MONTEREY", "sortData": "MONTEREY", "inResultset": true }, "Monterey": { "color": "#ff8575", "title": "Monterey", "sortData": "Monterey", "inResultset": true }, "monterey": { "color": "#515151", "title": "monterey", "sortData": "monterey", "inResultset": true }, "Monterey ": { "color": "#00d6ba", "title": "Monterey ", "sortData": "Monterey ", "inResultset": true }, "Morgan Hill": { "color": "#85c1eb", "title": "Morgan Hill", "sortData": "Morgan Hill", "inResultset": true }, "Morgan Hill ": { "color": "#ffb655", "title": "Morgan Hill ", "sortData": "Morgan Hill ", "inResultset": true }, "Morro Bay": { "color": "#ff8575", "title": "Morro Bay", "sortData": "Morro Bay", "inResultset": true }, "Moss Landing": { "color": "#515151", "title": "Moss Landing", "sortData": "Moss Landing", "inResultset": true }, "Mountain View": { "color": "#00d6ba", "title": "Mountain View", "sortData": "Mountain View", "inResultset": true }, "Muir Beach": { "color": "#85c1eb", "title": "Muir Beach", "sortData": "Muir Beach", "inResultset": true }, "Napa": { "color": "#ffb655", "title": "Napa", "sortData": "Napa", "inResultset": true }, "Nevada City": { "color": "#ff8575", "title": "Nevada City", "sortData": "Nevada City", "inResultset": true }, "new market": { "color": "#515151", "title": "new market", "sortData": "new market", "inResultset": true }, "New York": { "color": "#00d6ba", "title": "New York", "sortData": "New York", "inResultset": true }, "New York ": { "color": "#85c1eb", "title": "New York ", "sortData": "New York ", "inResultset": true }, "Newbury Park": { "color": "#ffb655", "title": "Newbury Park", "sortData": "Newbury Park", "inResultset": true }, "Newbury Park ": { "color": "#ff8575", "title": "Newbury Park ", "sortData": "Newbury Park ", "inResultset": true }, "Newcastle": { "color": "#515151", "title": "Newcastle", "sortData": "Newcastle", "inResultset": true }, "Newport Beach": { "color": "#00d6ba", "title": "Newport Beach", "sortData": "Newport Beach", "inResultset": true }, "Nichols Hills": { "color": "#85c1eb", "title": "Nichols Hills", "sortData": "Nichols Hills", "inResultset": true }, "Nipomo": { "color": "#ffb655", "title": "Nipomo", "sortData": "Nipomo", "inResultset": true }, "Novato": { "color": "#ff8575", "title": "Novato", "sortData": "Novato", "inResultset": true }, "Oak Park": { "color": "#515151", "title": "Oak Park", "sortData": "Oak Park", "inResultset": true }, "oak park": { "color": "#00d6ba", "title": "oak park", "sortData": "oak park", "inResultset": true }, "OAKLAND": { "color": "#85c1eb", "title": "OAKLAND", "sortData": "OAKLAND", "inResultset": true }, "Oakland": { "color": "#ffb655", "title": "Oakland", "sortData": "Oakland", "inResultset": true }, "Oakland ": { "color": "#ff8575", "title": "Oakland ", "sortData": "Oakland ", "inResultset": true }, "Oaklnd": { "color": "#515151", "title": "Oaklnd", "sortData": "Oaklnd", "inResultset": true }, "Oceanside ": { "color": "#00d6ba", "title": "Oceanside ", "sortData": "Oceanside ", "inResultset": true }, "Olympia": { "color": "#85c1eb", "title": "Olympia", "sortData": "Olympia", "inResultset": true }, "orange park": { "color": "#ffb655", "title": "orange park", "sortData": "orange park", "inResultset": true }, "Orangevale": { "color": "#ff8575", "title": "Orangevale", "sortData": "Orangevale", "inResultset": true }, "Orinda": { "color": "#515151", "title": "Orinda", "sortData": "Orinda", "inResultset": true }, "Orinda ": { "color": "#00d6ba", "title": "Orinda ", "sortData": "Orinda ", "inResultset": true }, "Orlando": { "color": "#85c1eb", "title": "Orlando", "sortData": "Orlando", "inResultset": true }, "Overland Park": { "color": "#ffb655", "title": "Overland Park", "sortData": "Overland Park", "inResultset": true }, "Oxford": { "color": "#ff8575", "title": "Oxford", "sortData": "Oxford", "inResultset": true }, "Oxnard": { "color": "#515151", "title": "Oxnard", "sortData": "Oxnard", "inResultset": true }, "PACIFIC GROVE": { "color": "#00d6ba", "title": "PACIFIC GROVE", "sortData": "PACIFIC GROVE", "inResultset": true }, "Pacific Grove": { "color": "#85c1eb", "title": "Pacific Grove", "sortData": "Pacific Grove", "inResultset": true }, "pacific grove": { "color": "#ffb655", "title": "pacific grove", "sortData": "pacific grove", "inResultset": true }, "Pacific Grove ": { "color": "#ff8575", "title": "Pacific Grove ", "sortData": "Pacific Grove ", "inResultset": true }, "Pacific grove ": { "color": "#515151", "title": "Pacific grove ", "sortData": "Pacific grove ", "inResultset": true }, "Pacific Palisades": { "color": "#00d6ba", "title": "Pacific Palisades", "sortData": "Pacific Palisades", "inResultset": true }, "Pahoa": { "color": "#85c1eb", "title": "Pahoa", "sortData": "Pahoa", "inResultset": true }, "Palo Alto": { "color": "#ffb655", "title": "Palo Alto", "sortData": "Palo Alto", "inResultset": true }, "Paradise Valley": { "color": "#ff8575", "title": "Paradise Valley", "sortData": "Paradise Valley", "inResultset": true }, "Park City": { "color": "#515151", "title": "Park City", "sortData": "Park City", "inResultset": true }, "Pasadena": { "color": "#00d6ba", "title": "Pasadena", "sortData": "Pasadena", "inResultset": true }, "pasadena": { "color": "#85c1eb", "title": "pasadena", "sortData": "pasadena", "inResultset": true }, "Paso Robles": { "color": "#ffb655", "title": "Paso Robles", "sortData": "Paso Robles", "inResultset": true }, "paso robles": { "color": "#ff8575", "title": "paso robles", "sortData": "paso robles", "inResultset": true }, "Pebble Beach": { "color": "#515151", "title": "Pebble Beach", "sortData": "Pebble Beach", "inResultset": true }, "Pebble beach": { "color": "#00d6ba", "title": "Pebble beach", "sortData": "Pebble beach", "inResultset": true }, "pebble beach": { "color": "#85c1eb", "title": "pebble beach", "sortData": "pebble beach", "inResultset": true }, "Pebble Beach ": { "color": "#ffb655", "title": "Pebble Beach ", "sortData": "Pebble Beach ", "inResultset": true }, "Pebble beach ": { "color": "#ff8575", "title": "Pebble beach ", "sortData": "Pebble beach ", "inResultset": true }, "Penngrove": { "color": "#515151", "title": "Penngrove", "sortData": "Penngrove", "inResultset": true }, "Pescadero": { "color": "#00d6ba", "title": "Pescadero", "sortData": "Pescadero", "inResultset": true }, "Petaluma ": { "color": "#85c1eb", "title": "Petaluma ", "sortData": "Petaluma ", "inResultset": true }, "Piedmont": { "color": "#ffb655", "title": "Piedmont", "sortData": "Piedmont", "inResultset": true }, "Piedmont ": { "color": "#ff8575", "title": "Piedmont ", "sortData": "Piedmont ", "inResultset": true }, "Pinole": { "color": "#515151", "title": "Pinole", "sortData": "Pinole", "inResultset": true }, "Pismo Beach": { "color": "#00d6ba", "title": "Pismo Beach", "sortData": "Pismo Beach", "inResultset": true }, "Pittsburg ": { "color": "#85c1eb", "title": "Pittsburg ", "sortData": "Pittsburg ", "inResultset": true }, "Placerville": { "color": "#ffb655", "title": "Placerville", "sortData": "Placerville", "inResultset": true }, "Plainview": { "color": "#ff8575", "title": "Plainview", "sortData": "Plainview", "inResultset": true }, "Pleasant Hill": { "color": "#515151", "title": "Pleasant Hill", "sortData": "Pleasant Hill", "inResultset": true }, "Pleasant Hill ": { "color": "#00d6ba", "title": "Pleasant Hill ", "sortData": "Pleasant Hill ", "inResultset": true }, "Pleasanton": { "color": "#85c1eb", "title": "Pleasanton", "sortData": "Pleasanton", "inResultset": true }, "Plymouth": { "color": "#ffb655", "title": "Plymouth", "sortData": "Plymouth", "inResultset": true }, "Porter Ranch": { "color": "#ff8575", "title": "Porter Ranch", "sortData": "Porter Ranch", "inResultset": true }, "Portland": { "color": "#515151", "title": "Portland", "sortData": "Portland", "inResultset": true }, "Portola Valley": { "color": "#00d6ba", "title": "Portola Valley", "sortData": "Portola Valley", "inResultset": true }, "Prairie Village": { "color": "#85c1eb", "title": "Prairie Village", "sortData": "Prairie Village", "inResultset": true }, "PRUNEDALE": { "color": "#ffb655", "title": "PRUNEDALE", "sortData": "PRUNEDALE", "inResultset": true }, "Prunedale": { "color": "#ff8575", "title": "Prunedale", "sortData": "Prunedale", "inResultset": true }, "Redwood City": { "color": "#515151", "title": "Redwood City", "sortData": "Redwood City", "inResultset": true }, "Reno": { "color": "#00d6ba", "title": "Reno", "sortData": "Reno", "inResultset": true }, "Richmond": { "color": "#85c1eb", "title": "Richmond", "sortData": "Richmond", "inResultset": true }, "Rio Rancho": { "color": "#ffb655", "title": "Rio Rancho", "sortData": "Rio Rancho", "inResultset": true }, "Riverside": { "color": "#ff8575", "title": "Riverside", "sortData": "Riverside", "inResultset": true }, "ROSEBURG": { "color": "#515151", "title": "ROSEBURG", "sortData": "ROSEBURG", "inResultset": true }, "Roseville": { "color": "#00d6ba", "title": "Roseville", "sortData": "Roseville", "inResultset": true }, "Royal Oaks": { "color": "#85c1eb", "title": "Royal Oaks", "sortData": "Royal Oaks", "inResultset": true }, "Sacramento": { "color": "#ffb655", "title": "Sacramento", "sortData": "Sacramento", "inResultset": true }, "Sacramento ": { "color": "#ff8575", "title": "Sacramento ", "sortData": "Sacramento ", "inResultset": true }, "Sacrmento": { "color": "#515151", "title": "Sacrmento", "sortData": "Sacrmento", "inResultset": true }, "SALEM": { "color": "#00d6ba", "title": "SALEM", "sortData": "SALEM", "inResultset": true }, "SALINAS": { "color": "#85c1eb", "title": "SALINAS", "sortData": "SALINAS", "inResultset": true }, "Salinas": { "color": "#ffb655", "title": "Salinas", "sortData": "Salinas", "inResultset": true }, "salinas": { "color": "#ff8575", "title": "salinas", "sortData": "salinas", "inResultset": true }, "Salinas ": { "color": "#515151", "title": "Salinas ", "sortData": "Salinas ", "inResultset": true }, "Sammamish": { "color": "#00d6ba", "title": "Sammamish", "sortData": "Sammamish", "inResultset": true }, "San Anselmo": { "color": "#85c1eb", "title": "San Anselmo", "sortData": "San Anselmo", "inResultset": true }, "San Antonio ": { "color": "#ffb655", "title": "San Antonio ", "sortData": "San Antonio ", "inResultset": true }, "San Bernardino": { "color": "#ff8575", "title": "San Bernardino", "sortData": "San Bernardino", "inResultset": true }, "San Bruno": { "color": "#515151", "title": "San Bruno", "sortData": "San Bruno", "inResultset": true }, "San Carlos": { "color": "#00d6ba", "title": "San Carlos", "sortData": "San Carlos", "inResultset": true }, "San carlos": { "color": "#85c1eb", "title": "San carlos", "sortData": "San carlos", "inResultset": true }, "San Diego": { "color": "#ffb655", "title": "San Diego", "sortData": "San Diego", "inResultset": true }, "San Dimas": { "color": "#ff8575", "title": "San Dimas", "sortData": "San Dimas", "inResultset": true }, "SAN FRANCISCO": { "color": "#515151", "title": "SAN FRANCISCO", "sortData": "SAN FRANCISCO", "inResultset": true }, "San Francisco": { "color": "#00d6ba", "title": "San Francisco", "sortData": "San Francisco", "inResultset": true }, "san francisco": { "color": "#85c1eb", "title": "san francisco", "sortData": "san francisco", "inResultset": true }, "San Francisco ": { "color": "#ffb655", "title": "San Francisco ", "sortData": "San Francisco ", "inResultset": true }, "San Francisco, Calif%46": { "color": "#ff8575", "title": "San Francisco, Calif.", "sortData": "San Francisco, Calif.", "inResultset": true }, "San Jose": { "color": "#515151", "title": "San Jose", "sortData": "San Jose", "inResultset": true }, "San jose": { "color": "#00d6ba", "title": "San jose", "sortData": "San jose", "inResultset": true }, "san jose": { "color": "#85c1eb", "title": "san jose", "sortData": "san jose", "inResultset": true }, "San Jose ": { "color": "#ffb655", "title": "San Jose ", "sortData": "San Jose ", "inResultset": true }, "San Leandro": { "color": "#ff8575", "title": "San Leandro", "sortData": "San Leandro", "inResultset": true }, "San Luis Obispo": { "color": "#515151", "title": "San Luis Obispo", "sortData": "San Luis Obispo", "inResultset": true }, "San Luis Obispo ": { "color": "#00d6ba", "title": "San Luis Obispo ", "sortData": "San Luis Obispo ", "inResultset": true }, "San Martin": { "color": "#85c1eb", "title": "San Martin", "sortData": "San Martin", "inResultset": true }, "San Mateo": { "color": "#ffb655", "title": "San Mateo", "sortData": "San Mateo", "inResultset": true }, "San Mateo ": { "color": "#ff8575", "title": "San Mateo ", "sortData": "San Mateo ", "inResultset": true }, "San Rafael": { "color": "#515151", "title": "San Rafael", "sortData": "San Rafael", "inResultset": true }, "Sand City": { "color": "#00d6ba", "title": "Sand City", "sortData": "Sand City", "inResultset": true }, "Sand city": { "color": "#85c1eb", "title": "Sand city", "sortData": "Sand city", "inResultset": true }, "Sanford": { "color": "#ffb655", "title": "Sanford", "sortData": "Sanford", "inResultset": true }, "Santa Ana": { "color": "#ff8575", "title": "Santa Ana", "sortData": "Santa Ana", "inResultset": true }, "SANTA BARBARA": { "color": "#515151", "title": "SANTA BARBARA", "sortData": "SANTA BARBARA", "inResultset": true }, "Santa Barbara": { "color": "#00d6ba", "title": "Santa Barbara", "sortData": "Santa Barbara", "inResultset": true }, "Santa Barbara ": { "color": "#85c1eb", "title": "Santa Barbara ", "sortData": "Santa Barbara ", "inResultset": true }, "Santa Clara": { "color": "#ffb655", "title": "Santa Clara", "sortData": "Santa Clara", "inResultset": true }, "SANTA CRUZ": { "color": "#ff8575", "title": "SANTA CRUZ", "sortData": "SANTA CRUZ", "inResultset": true }, "Santa Cruz": { "color": "#515151", "title": "Santa Cruz", "sortData": "Santa Cruz", "inResultset": true }, "Santa cruz": { "color": "#00d6ba", "title": "Santa cruz", "sortData": "Santa cruz", "inResultset": true }, "santa cruz": { "color": "#85c1eb", "title": "santa cruz", "sortData": "santa cruz", "inResultset": true }, "Santa Cruz ": { "color": "#ffb655", "title": "Santa Cruz ", "sortData": "Santa Cruz ", "inResultset": true }, "Santa Fe": { "color": "#ff8575", "title": "Santa Fe", "sortData": "Santa Fe", "inResultset": true }, "Santa Fe Springs": { "color": "#515151", "title": "Santa Fe Springs", "sortData": "Santa Fe Springs", "inResultset": true }, "Santa Maria": { "color": "#00d6ba", "title": "Santa Maria", "sortData": "Santa Maria", "inResultset": true }, "Santa Maria ": { "color": "#85c1eb", "title": "Santa Maria ", "sortData": "Santa Maria ", "inResultset": true }, "Santa Monica": { "color": "#ffb655", "title": "Santa Monica", "sortData": "Santa Monica", "inResultset": true }, "Santa Rosa": { "color": "#ff8575", "title": "Santa Rosa", "sortData": "Santa Rosa", "inResultset": true }, "Santa Ynez": { "color": "#515151", "title": "Santa Ynez", "sortData": "Santa Ynez", "inResultset": true }, "Saratoga": { "color": "#00d6ba", "title": "Saratoga", "sortData": "Saratoga", "inResultset": true }, "Sarnia": { "color": "#85c1eb", "title": "Sarnia", "sortData": "Sarnia", "inResultset": true }, "SCOTTS VALLEY": { "color": "#ffb655", "title": "SCOTTS VALLEY", "sortData": "SCOTTS VALLEY", "inResultset": true }, "Scotts Valley": { "color": "#ff8575", "title": "Scotts Valley", "sortData": "Scotts Valley", "inResultset": true }, "SEASIDE": { "color": "#515151", "title": "SEASIDE", "sortData": "SEASIDE", "inResultset": true }, "Seaside": { "color": "#00d6ba", "title": "Seaside", "sortData": "Seaside", "inResultset": true }, "Seaside ": { "color": "#85c1eb", "title": "Seaside ", "sortData": "Seaside ", "inResultset": true }, "Seattle": { "color": "#ffb655", "title": "Seattle", "sortData": "Seattle", "inResultset": true }, "seattle": { "color": "#ff8575", "title": "seattle", "sortData": "seattle", "inResultset": true }, "Sherman Oaks": { "color": "#515151", "title": "Sherman Oaks", "sortData": "Sherman Oaks", "inResultset": true }, "Shingle Springs": { "color": "#00d6ba", "title": "Shingle Springs", "sortData": "Shingle Springs", "inResultset": true }, "Shorewood": { "color": "#85c1eb", "title": "Shorewood", "sortData": "Shorewood", "inResultset": true }, "Shrewsbury": { "color": "#ffb655", "title": "Shrewsbury", "sortData": "Shrewsbury", "inResultset": true }, "Sisters": { "color": "#ff8575", "title": "Sisters", "sortData": "Sisters", "inResultset": true }, "Smithfield": { "color": "#515151", "title": "Smithfield", "sortData": "Smithfield", "inResultset": true }, "Soledad": { "color": "#00d6ba", "title": "Soledad", "sortData": "Soledad", "inResultset": true }, "Solvang": { "color": "#85c1eb", "title": "Solvang", "sortData": "Solvang", "inResultset": true }, "SONOMA": { "color": "#ffb655", "title": "SONOMA", "sortData": "SONOMA", "inResultset": true }, "Sonoma": { "color": "#ff8575", "title": "Sonoma", "sortData": "Sonoma", "inResultset": true }, "Soquel": { "color": "#515151", "title": "Soquel", "sortData": "Soquel", "inResultset": true }, "Soquel ": { "color": "#00d6ba", "title": "Soquel ", "sortData": "Soquel ", "inResultset": true }, "South San Francisco": { "color": "#85c1eb", "title": "South San Francisco", "sortData": "South San Francisco", "inResultset": true }, "Spreckels": { "color": "#ffb655", "title": "Spreckels", "sortData": "Spreckels", "inResultset": true }, "Spreckels ": { "color": "#ff8575", "title": "Spreckels ", "sortData": "Spreckels ", "inResultset": true }, "Spring Branch": { "color": "#515151", "title": "Spring Branch", "sortData": "Spring Branch", "inResultset": true }, "Spring City": { "color": "#00d6ba", "title": "Spring City", "sortData": "Spring City", "inResultset": true }, "Stanford": { "color": "#85c1eb", "title": "Stanford", "sortData": "Stanford", "inResultset": true }, "Stayton": { "color": "#ffb655", "title": "Stayton", "sortData": "Stayton", "inResultset": true }, "Stockton": { "color": "#ff8575", "title": "Stockton", "sortData": "Stockton", "inResultset": true }, "Studio City": { "color": "#515151", "title": "Studio City", "sortData": "Studio City", "inResultset": true }, "Sun City ": { "color": "#00d6ba", "title": "Sun City ", "sortData": "Sun City ", "inResultset": true }, "Sunnyvale": { "color": "#85c1eb", "title": "Sunnyvale", "sortData": "Sunnyvale", "inResultset": true }, "Sunnyvale ": { "color": "#ffb655", "title": "Sunnyvale ", "sortData": "Sunnyvale ", "inResultset": true }, "Tacoma": { "color": "#ff8575", "title": "Tacoma", "sortData": "Tacoma", "inResultset": true }, "Tallahassee": { "color": "#515151", "title": "Tallahassee", "sortData": "Tallahassee", "inResultset": true }, "Tampa": { "color": "#00d6ba", "title": "Tampa", "sortData": "Tampa", "inResultset": true }, "Tarzana": { "color": "#85c1eb", "title": "Tarzana", "sortData": "Tarzana", "inResultset": true }, "Templeton": { "color": "#ffb655", "title": "Templeton", "sortData": "Templeton", "inResultset": true }, "Tenafly": { "color": "#ff8575", "title": "Tenafly", "sortData": "Tenafly", "inResultset": true }, "Three Rivers": { "color": "#515151", "title": "Three Rivers", "sortData": "Three Rivers", "inResultset": true }, "Tiburon": { "color": "#00d6ba", "title": "Tiburon", "sortData": "Tiburon", "inResultset": true }, "Toronto": { "color": "#85c1eb", "title": "Toronto", "sortData": "Toronto", "inResultset": true }, "Tres Pinos": { "color": "#ffb655", "title": "Tres Pinos", "sortData": "Tres Pinos", "inResultset": true }, "trinidad": { "color": "#ff8575", "title": "trinidad", "sortData": "trinidad", "inResultset": true }, "Truckee ": { "color": "#515151", "title": "Truckee ", "sortData": "Truckee ", "inResultset": true }, "Tucson ": { "color": "#00d6ba", "title": "Tucson ", "sortData": "Tucson ", "inResultset": true }, "Turlock": { "color": "#85c1eb", "title": "Turlock", "sortData": "Turlock", "inResultset": true }, "Union City": { "color": "#ffb655", "title": "Union City", "sortData": "Union City", "inResultset": true }, "Urbandale": { "color": "#ff8575", "title": "Urbandale", "sortData": "Urbandale", "inResultset": true }, "Vacaville": { "color": "#515151", "title": "Vacaville", "sortData": "Vacaville", "inResultset": true }, "Vacaville ": { "color": "#00d6ba", "title": "Vacaville ", "sortData": "Vacaville ", "inResultset": true }, "Vallejo": { "color": "#85c1eb", "title": "Vallejo", "sortData": "Vallejo", "inResultset": true }, "Vallejo ": { "color": "#ffb655", "title": "Vallejo ", "sortData": "Vallejo ", "inResultset": true }, "Vista": { "color": "#ff8575", "title": "Vista", "sortData": "Vista", "inResultset": true }, "Walnut Creek": { "color": "#515151", "title": "Walnut Creek", "sortData": "Walnut Creek", "inResultset": true }, "WATSONVILLE": { "color": "#00d6ba", "title": "WATSONVILLE", "sortData": "WATSONVILLE", "inResultset": true }, "Watsonville": { "color": "#85c1eb", "title": "Watsonville", "sortData": "Watsonville", "inResultset": true }, "Watsonville ": { "color": "#ffb655", "title": "Watsonville ", "sortData": "Watsonville ", "inResultset": true }, "Wellesley Hills": { "color": "#ff8575", "title": "Wellesley Hills", "sortData": "Wellesley Hills", "inResultset": true }, "Wellington": { "color": "#515151", "title": "Wellington", "sortData": "Wellington", "inResultset": true }, "West Jordan ": { "color": "#00d6ba", "title": "West Jordan ", "sortData": "West Jordan ", "inResultset": true }, "West Park": { "color": "#85c1eb", "title": "West Park", "sortData": "West Park", "inResultset": true }, "Wheatland": { "color": "#ffb655", "title": "Wheatland", "sortData": "Wheatland", "inResultset": true }, "Wheaton": { "color": "#ff8575", "title": "Wheaton", "sortData": "Wheaton", "inResultset": true }, "White Bear Lake": { "color": "#515151", "title": "White Bear Lake", "sortData": "White Bear Lake", "inResultset": true }, "Woodside": { "color": "#00d6ba", "title": "Woodside", "sortData": "Woodside", "inResultset": true }, "Yuba City ": { "color": "#85c1eb", "title": "Yuba City ", "sortData": "Yuba City ", "inResultset": true } } } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "filters", "items": [] } ] }, "type": "chart/pie", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": false, "position": "left" }, "labels": { "enabled": true, "categories": true, "value": false, "percent": true, "decimals": false }, "dataLimits": { "seriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "primary_address_city", "title": "Primary Address City", "singular": "Primary Address City", "plural": "Primary Address City" } ] } }, "instanceid": "AB1D8-A771-DF", "queryStartTime": "2019-09-25T16:49:01", "drawing": true, "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "dashboardid": "5d8bfc1205de7d1d006d81fd", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true } }, { "title": "Paid Ticket Income by City", "subtype": "pie/classic", "oid": "5d8bfd2105de7d1d006d8248", "desc": null, "source": null, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-24T22:18:58" }, "selection": null, "metadata": { "drillHistory": [ { "jaql": { "table": "CONSTITUENT", "column": "Primary Address Postcode Short", "dim": "[CONSTITUENT.Primary Address Postcode Short]", "datatype": "text", "merged": true, "title": "Primary Address Postcode Short" }, "parent": { "jaql": { "table": "CONSTITUENT", "column": "Primary Address City", "dim": "[CONSTITUENT.Primary Address City]", "datatype": "text", "merged": true, "title": "Primary Address City" }, "field": { "id": "[CONSTITUENT.Primary Address City]", "index": 0 }, "format": { "members": { "(none)": { "color": "#547A94", "title": "(none)", "sortData": "(none)", "inResultset": true }, "Alameda": { "color": "#F48E06", "title": "Alameda", "sortData": "Alameda" }, "Albany": { "color": "#DB4935", "title": "Albany", "sortData": "Albany", "inResultset": true }, "Alberta ": { "color": "#333333", "title": "Alberta ", "sortData": "Alberta " }, "Albuquerque": { "color": "#008775", "title": "Albuquerque", "sortData": "Albuquerque", "inResultset": true }, "Alexandria": { "color": "#618caa", "title": "Alexandria", "sortData": "Alexandria" }, "Altadena": { "color": "#ff9b16", "title": "Altadena", "sortData": "Altadena", "inResultset": true }, "Anacortes": { "color": "#fc543d", "title": "Anacortes", "sortData": "Anacortes" }, "APTOS": { "color": "#3b3b3b", "title": "APTOS", "sortData": "APTOS" }, "Aptos": { "color": "#009b87", "title": "Aptos", "sortData": "Aptos", "inResultset": true }, "aptos": { "color": "#6897b7", "title": "aptos", "sortData": "aptos" }, "Aptos ": { "color": "#ffa022", "title": "Aptos ", "sortData": "Aptos " }, "Aromas": { "color": "#ff5d47", "title": "Aromas", "sortData": "Aromas" }, "Aromas ": { "color": "#3f3f3f", "title": "Aromas ", "sortData": "Aromas " }, "Arundel": { "color": "#00a790", "title": "Arundel", "sortData": "Arundel", "inResultset": true }, "ASHLAND": { "color": "#6fa1c3", "title": "ASHLAND", "sortData": "ASHLAND" }, "Atherton": { "color": "#ffa62e", "title": "Atherton", "sortData": "Atherton" }, "Atlanta": { "color": "#ff6752", "title": "Atlanta", "sortData": "Atlanta", "inResultset": true }, "Austin": { "color": "#434343", "title": "Austin", "sortData": "Austin" }, "Bainbridge Island": { "color": "#00b29a", "title": "Bainbridge Island", "sortData": "Bainbridge Island" }, "Bellaire": { "color": "#74a9cd", "title": "Bellaire", "sortData": "Bellaire" }, "BELLEVUE": { "color": "#ffaa38", "title": "BELLEVUE", "sortData": "BELLEVUE", "inResultset": true }, "Bellingham": { "color": "#ff6f5b", "title": "Bellingham", "sortData": "Bellingham" }, "Belmont": { "color": "#474747", "title": "Belmont", "sortData": "Belmont" }, "Belvedere": { "color": "#00bba2", "title": "Belvedere", "sortData": "Belvedere" }, "Ben Lomond": { "color": "#79afd5", "title": "Ben Lomond", "sortData": "Ben Lomond" }, "ben lomond": { "color": "#ffad3f", "title": "ben lomond", "sortData": "ben lomond" }, "Benici": { "color": "#ff7461", "title": "Benici", "sortData": "Benici" }, "Benicia": { "color": "#494949", "title": "Benicia", "sortData": "Benicia" }, "BERKELEY": { "color": "#00c2a8", "title": "BERKELEY", "sortData": "BERKELEY", "inResultset": true }, "Berkeley": { "color": "#7cb4db", "title": "Berkeley", "sortData": "Berkeley", "inResultset": true }, "beverly hills": { "color": "#ffaf45", "title": "beverly hills", "sortData": "beverly hills" }, "Big Sur": { "color": "#ff7966", "title": "Big Sur", "sortData": "Big Sur", "inResultset": true }, "Bloomfield Hills": { "color": "#4b4b4b", "title": "Bloomfield Hills", "sortData": "Bloomfield Hills" }, "Blue lake": { "color": "#00c7ad", "title": "Blue lake", "sortData": "Blue lake", "inResultset": true }, "Boise": { "color": "#7fb8df", "title": "Boise", "sortData": "Boise" }, "Boulder": { "color": "#ffb14a", "title": "Boulder", "sortData": "Boulder" }, "BOULDER CREEK": { "color": "#ff7d6b", "title": "BOULDER CREEK", "sortData": "BOULDER CREEK" }, "Boulder Creek": { "color": "#4d4d4d", "title": "Boulder Creek", "sortData": "Boulder Creek" }, "Brentwood": { "color": "#00ccb1", "title": "Brentwood", "sortData": "Brentwood" }, "Brooklyn": { "color": "#81bce4", "title": "Brooklyn", "sortData": "Brooklyn", "inResultset": true }, "Buellton": { "color": "#ffb34e", "title": "Buellton", "sortData": "Buellton" }, "Burlington": { "color": "#ff806f", "title": "Burlington", "sortData": "Burlington" }, "Cambria": { "color": "#4e4e4e", "title": "Cambria", "sortData": "Cambria" }, "Campbell": { "color": "#00d0b4", "title": "Campbell", "sortData": "Campbell", "inResultset": true }, "Campbell ": { "color": "#83bfe7", "title": "Campbell ", "sortData": "Campbell " }, "Capistrano Beach ": { "color": "#ffb552", "title": "Capistrano Beach ", "sortData": "Capistrano Beach " }, "Capitola": { "color": "#ff8372", "title": "Capitola", "sortData": "Capitola", "inResultset": true }, "Capitola ": { "color": "#505050", "title": "Capitola ", "sortData": "Capitola " }, "Carlsbad": { "color": "#00d3b7", "title": "Carlsbad", "sortData": "Carlsbad" }, "CARMEL": { "color": "#85c1eb", "title": "CARMEL", "sortData": "CARMEL" }, "Carmel": { "color": "#ffb655", "title": "Carmel", "sortData": "Carmel", "inResultset": true }, "carmel": { "color": "#ff8575", "title": "carmel", "sortData": "carmel" }, "Carmel ": { "color": "#515151", "title": "Carmel ", "sortData": "Carmel " }, "Carmel By The Sea": { "color": "#00d6ba", "title": "Carmel By The Sea", "sortData": "Carmel By The Sea" }, "Carmel by the Sea": { "color": "#ffb655", "title": "Carmel by the Sea", "sortData": "Carmel by the Sea" }, "Carmel Highlands": { "color": "#ff8575", "title": "Carmel Highlands", "sortData": "Carmel Highlands", "inResultset": true }, "Carmel Valley": { "color": "#515151", "title": "Carmel Valley", "sortData": "Carmel Valley" }, "carmel valley": { "color": "#00d6ba", "title": "carmel valley", "sortData": "carmel valley" }, "Carmel Valley ": { "color": "#85c1eb", "title": "Carmel Valley ", "sortData": "Carmel Valley " }, "Carmel Valley Village": { "color": "#ffb655", "title": "Carmel Valley Village", "sortData": "Carmel Valley Village" }, "Carmel, CA": { "color": "#ff8575", "title": "Carmel, CA", "sortData": "Carmel, CA" }, "Carmel-by-the-Sea": { "color": "#515151", "title": "Carmel-by-the-Sea", "sortData": "Carmel-by-the-Sea" }, "Carmichael": { "color": "#00d6ba", "title": "Carmichael", "sortData": "Carmichael" }, "CARPINTERIA": { "color": "#85c1eb", "title": "CARPINTERIA", "sortData": "CARPINTERIA" }, "Carpinteria ": { "color": "#ffb655", "title": "Carpinteria ", "sortData": "Carpinteria " }, "Carson City": { "color": "#ff8575", "title": "Carson City", "sortData": "Carson City", "inResultset": true }, "Castle Rock": { "color": "#515151", "title": "Castle Rock", "sortData": "Castle Rock", "inResultset": true }, "Castro valley": { "color": "#00d6ba", "title": "Castro valley", "sortData": "Castro valley" }, "Cayucos": { "color": "#85c1eb", "title": "Cayucos", "sortData": "Cayucos" }, "Cazadero": { "color": "#ffb655", "title": "Cazadero", "sortData": "Cazadero" }, "Chagrin Falls": { "color": "#ff8575", "title": "Chagrin Falls", "sortData": "Chagrin Falls" }, "Chandler": { "color": "#515151", "title": "Chandler", "sortData": "Chandler", "inResultset": true }, "Chicago": { "color": "#00d6ba", "title": "Chicago", "sortData": "Chicago" }, "Chico": { "color": "#85c1eb", "title": "Chico", "sortData": "Chico" }, "Chico ": { "color": "#ffb655", "title": "Chico ", "sortData": "Chico " }, "Cincinnati": { "color": "#ff8575", "title": "Cincinnati", "sortData": "Cincinnati" }, "Clayton": { "color": "#515151", "title": "Clayton", "sortData": "Clayton" }, "Cloverdale": { "color": "#00d6ba", "title": "Cloverdale", "sortData": "Cloverdale", "inResultset": true }, "Columbus": { "color": "#85c1eb", "title": "Columbus", "sortData": "Columbus" }, "Concord": { "color": "#ffb655", "title": "Concord", "sortData": "Concord" }, "Corona Del Mar": { "color": "#ff8575", "title": "Corona Del Mar", "sortData": "Corona Del Mar" }, "Corral De Tierra": { "color": "#515151", "title": "Corral De Tierra", "sortData": "Corral De Tierra" }, "Corral de Tierra": { "color": "#00d6ba", "title": "Corral de Tierra", "sortData": "Corral de Tierra" }, "Corral de Tierra ": { "color": "#85c1eb", "title": "Corral de Tierra ", "sortData": "Corral de Tierra " }, "Corvallis ": { "color": "#ffb655", "title": "Corvallis ", "sortData": "Corvallis ", "inResultset": true }, "Costa Mesa ": { "color": "#ff8575", "title": "Costa Mesa ", "sortData": "Costa Mesa " }, "Cupertino": { "color": "#515151", "title": "Cupertino", "sortData": "Cupertino" }, "DALLAS": { "color": "#00d6ba", "title": "DALLAS", "sortData": "DALLAS" }, "Dallas": { "color": "#85c1eb", "title": "Dallas", "sortData": "Dallas", "inResultset": true }, "dallas": { "color": "#ffb655", "title": "dallas", "sortData": "dallas" }, "Dana Point": { "color": "#ff8575", "title": "Dana Point", "sortData": "Dana Point" }, "DANVILLE": { "color": "#515151", "title": "DANVILLE", "sortData": "DANVILLE" }, "Danville": { "color": "#00d6ba", "title": "Danville", "sortData": "Danville", "inResultset": true }, "Davenport": { "color": "#85c1eb", "title": "Davenport", "sortData": "Davenport" }, "Davis": { "color": "#ffb655", "title": "Davis", "sortData": "Davis", "inResultset": true }, "Del Rey Oaks": { "color": "#ff8575", "title": "Del Rey Oaks", "sortData": "Del Rey Oaks" }, "Denver": { "color": "#515151", "title": "Denver", "sortData": "Denver" }, "Discovery Bay ": { "color": "#00d6ba", "title": "Discovery Bay ", "sortData": "Discovery Bay " }, "Douglas": { "color": "#85c1eb", "title": "Douglas", "sortData": "Douglas" }, "E%46 Brunswick": { "color": "#ffb655", "title": "E. Brunswick", "sortData": "E. Brunswick", "inResultset": true }, "East Garrison": { "color": "#ff8575", "title": "East Garrison", "sortData": "East Garrison" }, "Eden Prairie": { "color": "#515151", "title": "Eden Prairie", "sortData": "Eden Prairie" }, "El Cerrito": { "color": "#00d6ba", "title": "El Cerrito", "sortData": "El Cerrito", "inResultset": true }, "El Dorado Hills": { "color": "#85c1eb", "title": "El Dorado Hills", "sortData": "El Dorado Hills" }, "El Paso": { "color": "#ffb655", "title": "El Paso", "sortData": "El Paso" }, "Elk Grove": { "color": "#ff8575", "title": "Elk Grove", "sortData": "Elk Grove" }, "Elverta": { "color": "#515151", "title": "Elverta", "sortData": "Elverta", "inResultset": true }, "Encinitas": { "color": "#00d6ba", "title": "Encinitas", "sortData": "Encinitas" }, "Fair Oaks": { "color": "#85c1eb", "title": "Fair Oaks", "sortData": "Fair Oaks", "inResultset": true }, "Fallbrook": { "color": "#ffb655", "title": "Fallbrook", "sortData": "Fallbrook" }, "Farmington": { "color": "#ff8575", "title": "Farmington", "sortData": "Farmington" }, "Felton": { "color": "#515151", "title": "Felton", "sortData": "Felton", "inResultset": true }, "Folsom": { "color": "#00d6ba", "title": "Folsom", "sortData": "Folsom" }, "Fonthill, Ontario": { "color": "#85c1eb", "title": "Fonthill, Ontario", "sortData": "Fonthill, Ontario" }, "Forest Grove": { "color": "#ffb655", "title": "Forest Grove", "sortData": "Forest Grove", "inResultset": true }, "Fort collins": { "color": "#ff8575", "title": "Fort collins", "sortData": "Fort collins", "inResultset": true }, "Fortville": { "color": "#515151", "title": "Fortville", "sortData": "Fortville" }, "Freedom": { "color": "#00d6ba", "title": "Freedom", "sortData": "Freedom" }, "Fremont": { "color": "#85c1eb", "title": "Fremont", "sortData": "Fremont", "inResultset": true }, "FRESNO": { "color": "#ffb655", "title": "FRESNO", "sortData": "FRESNO" }, "Fresno": { "color": "#ff8575", "title": "Fresno", "sortData": "Fresno" }, "Frisco": { "color": "#515151", "title": "Frisco", "sortData": "Frisco" }, "Gardnerville": { "color": "#00d6ba", "title": "Gardnerville", "sortData": "Gardnerville" }, "Georgetown": { "color": "#85c1eb", "title": "Georgetown", "sortData": "Georgetown" }, "Gilroy": { "color": "#ffb655", "title": "Gilroy", "sortData": "Gilroy", "inResultset": true }, "Gilroy ": { "color": "#ff8575", "title": "Gilroy ", "sortData": "Gilroy " }, "Glendale ": { "color": "#515151", "title": "Glendale ", "sortData": "Glendale ", "inResultset": true }, "Gold River": { "color": "#00d6ba", "title": "Gold River", "sortData": "Gold River" }, "Gonzales": { "color": "#85c1eb", "title": "Gonzales", "sortData": "Gonzales" }, "Grand Rapids": { "color": "#ffb655", "title": "Grand Rapids", "sortData": "Grand Rapids" }, "Grand Ronde": { "color": "#ff8575", "title": "Grand Ronde", "sortData": "Grand Ronde" }, "Grass Valley": { "color": "#515151", "title": "Grass Valley", "sortData": "Grass Valley", "inResultset": true }, "Greenbank": { "color": "#00d6ba", "title": "Greenbank", "sortData": "Greenbank" }, "Greenbrae ": { "color": "#85c1eb", "title": "Greenbrae ", "sortData": "Greenbrae " }, "Greenfield": { "color": "#ffb655", "title": "Greenfield", "sortData": "Greenfield" }, "Greenwich": { "color": "#ff8575", "title": "Greenwich", "sortData": "Greenwich" }, "Half Moon Bay": { "color": "#515151", "title": "Half Moon Bay", "sortData": "Half Moon Bay" }, "Hayward": { "color": "#00d6ba", "title": "Hayward", "sortData": "Hayward" }, "Healdsburg": { "color": "#85c1eb", "title": "Healdsburg", "sortData": "Healdsburg" }, "Hercules": { "color": "#ffb655", "title": "Hercules", "sortData": "Hercules" }, "Hillsborough": { "color": "#ff8575", "title": "Hillsborough", "sortData": "Hillsborough" }, "Hollister": { "color": "#515151", "title": "Hollister", "sortData": "Hollister" }, "Hollister ": { "color": "#00d6ba", "title": "Hollister ", "sortData": "Hollister " }, "Hollywood": { "color": "#85c1eb", "title": "Hollywood", "sortData": "Hollywood" }, "Honolulu": { "color": "#ffb655", "title": "Honolulu", "sortData": "Honolulu" }, "Houston": { "color": "#ff8575", "title": "Houston", "sortData": "Houston", "inResultset": true }, "Huntington Beach": { "color": "#515151", "title": "Huntington Beach", "sortData": "Huntington Beach" }, "Iaasquah": { "color": "#00d6ba", "title": "Iaasquah", "sortData": "Iaasquah" }, "Incline Village": { "color": "#85c1eb", "title": "Incline Village", "sortData": "Incline Village" }, "Juneau": { "color": "#ffb655", "title": "Juneau", "sortData": "Juneau" }, "Jupiter": { "color": "#ff8575", "title": "Jupiter", "sortData": "Jupiter" }, "Kapaa": { "color": "#515151", "title": "Kapaa", "sortData": "Kapaa" }, "Kenwood": { "color": "#00d6ba", "title": "Kenwood", "sortData": "Kenwood" }, "Kerman": { "color": "#85c1eb", "title": "Kerman", "sortData": "Kerman" }, "King City": { "color": "#ffb655", "title": "King City", "sortData": "King City", "inResultset": true }, "LA": { "color": "#ff8575", "title": "LA", "sortData": "LA" }, "La Canada": { "color": "#515151", "title": "La Canada", "sortData": "La Canada" }, "La Mesa": { "color": "#00d6ba", "title": "La Mesa", "sortData": "La Mesa", "inResultset": true }, "La Porte": { "color": "#85c1eb", "title": "La Porte", "sortData": "La Porte" }, "La Quinta": { "color": "#ffb655", "title": "La Quinta", "sortData": "La Quinta" }, "La Selva Beach": { "color": "#ff8575", "title": "La Selva Beach", "sortData": "La Selva Beach" }, "Ladera Ranch": { "color": "#515151", "title": "Ladera Ranch", "sortData": "Ladera Ranch" }, "LAFAYETTE": { "color": "#00d6ba", "title": "LAFAYETTE", "sortData": "LAFAYETTE" }, "Lafayette ": { "color": "#85c1eb", "title": "Lafayette ", "sortData": "Lafayette " }, "Lahaina": { "color": "#ffb655", "title": "Lahaina", "sortData": "Lahaina" }, "Lake Elsinore": { "color": "#ff8575", "title": "Lake Elsinore", "sortData": "Lake Elsinore" }, "Lake Oswego": { "color": "#515151", "title": "Lake Oswego", "sortData": "Lake Oswego", "inResultset": true }, "Lakeport": { "color": "#00d6ba", "title": "Lakeport", "sortData": "Lakeport" }, "Lakewood": { "color": "#85c1eb", "title": "Lakewood", "sortData": "Lakewood" }, "lakewood": { "color": "#ffb655", "title": "lakewood", "sortData": "lakewood" }, "Las Vegas": { "color": "#ff8575", "title": "Las Vegas", "sortData": "Las Vegas", "inResultset": true }, "Lee Vining": { "color": "#515151", "title": "Lee Vining", "sortData": "Lee Vining", "inResultset": true }, "Lincoln": { "color": "#00d6ba", "title": "Lincoln", "sortData": "Lincoln" }, "Livermore": { "color": "#85c1eb", "title": "Livermore", "sortData": "Livermore" }, "Livermore ": { "color": "#ffb655", "title": "Livermore ", "sortData": "Livermore " }, "Loma Linda ": { "color": "#ff8575", "title": "Loma Linda ", "sortData": "Loma Linda " }, "London": { "color": "#515151", "title": "London", "sortData": "London" }, "Long beach": { "color": "#00d6ba", "title": "Long beach", "sortData": "Long beach" }, "Longmont ": { "color": "#85c1eb", "title": "Longmont ", "sortData": "Longmont " }, "Longview": { "color": "#ffb655", "title": "Longview", "sortData": "Longview" }, "Los Altos": { "color": "#ff8575", "title": "Los Altos", "sortData": "Los Altos" }, "Los Altos Hills": { "color": "#515151", "title": "Los Altos Hills", "sortData": "Los Altos Hills" }, "Los Angeles": { "color": "#00d6ba", "title": "Los Angeles", "sortData": "Los Angeles", "inResultset": true }, "Los angeles": { "color": "#85c1eb", "title": "Los angeles", "sortData": "Los angeles", "inResultset": true }, "Los Banos": { "color": "#ffb655", "title": "Los Banos", "sortData": "Los Banos" }, "Los Gatos": { "color": "#ff8575", "title": "Los Gatos", "sortData": "Los Gatos" }, "Los Gatos ": { "color": "#515151", "title": "Los Gatos ", "sortData": "Los Gatos " }, "louisville": { "color": "#00d6ba", "title": "louisville", "sortData": "louisville" }, "Marana": { "color": "#85c1eb", "title": "Marana", "sortData": "Marana" }, "Marina": { "color": "#ffb655", "title": "Marina", "sortData": "Marina" }, "marina": { "color": "#ff8575", "title": "marina", "sortData": "marina" }, "Marina ": { "color": "#515151", "title": "Marina ", "sortData": "Marina " }, "Mariposa": { "color": "#00d6ba", "title": "Mariposa", "sortData": "Mariposa" }, "Mars Hill": { "color": "#85c1eb", "title": "Mars Hill", "sortData": "Mars Hill" }, "Martinez": { "color": "#ffb655", "title": "Martinez", "sortData": "Martinez", "inResultset": true }, "Marysville": { "color": "#ff8575", "title": "Marysville", "sortData": "Marysville" }, "Menlo Park": { "color": "#515151", "title": "Menlo Park", "sortData": "Menlo Park" }, "Metaire": { "color": "#00d6ba", "title": "Metaire", "sortData": "Metaire" }, "Miami": { "color": "#85c1eb", "title": "Miami", "sortData": "Miami" }, "Mill Valley": { "color": "#ffb655", "title": "Mill Valley", "sortData": "Mill Valley" }, "Milpitas": { "color": "#ff8575", "title": "Milpitas", "sortData": "Milpitas" }, "Missouri Valley": { "color": "#515151", "title": "Missouri Valley", "sortData": "Missouri Valley", "inResultset": true }, "Modesto": { "color": "#00d6ba", "title": "Modesto", "sortData": "Modesto" }, "Monte Sereno": { "color": "#85c1eb", "title": "Monte Sereno", "sortData": "Monte Sereno" }, "MONTEREY": { "color": "#ffb655", "title": "MONTEREY", "sortData": "MONTEREY", "inResultset": true }, "Monterey": { "color": "#ff8575", "title": "Monterey", "sortData": "Monterey", "inResultset": true }, "monterey": { "color": "#515151", "title": "monterey", "sortData": "monterey" }, "Monterey ": { "color": "#00d6ba", "title": "Monterey ", "sortData": "Monterey ", "inResultset": true }, "Morgan Hill": { "color": "#85c1eb", "title": "Morgan Hill", "sortData": "Morgan Hill" }, "Morgan Hill ": { "color": "#ffb655", "title": "Morgan Hill ", "sortData": "Morgan Hill " }, "Morro Bay": { "color": "#ff8575", "title": "Morro Bay", "sortData": "Morro Bay" }, "Moss Landing": { "color": "#515151", "title": "Moss Landing", "sortData": "Moss Landing" }, "Mountain View": { "color": "#00d6ba", "title": "Mountain View", "sortData": "Mountain View", "inResultset": true }, "Muir Beach": { "color": "#85c1eb", "title": "Muir Beach", "sortData": "Muir Beach" }, "Napa": { "color": "#ffb655", "title": "Napa", "sortData": "Napa" }, "Nevada City": { "color": "#ff8575", "title": "Nevada City", "sortData": "Nevada City" }, "new market": { "color": "#515151", "title": "new market", "sortData": "new market" }, "New York": { "color": "#00d6ba", "title": "New York", "sortData": "New York", "inResultset": true }, "New York ": { "color": "#85c1eb", "title": "New York ", "sortData": "New York ", "inResultset": true }, "Newbury Park": { "color": "#ffb655", "title": "Newbury Park", "sortData": "Newbury Park", "inResultset": true }, "Newbury Park ": { "color": "#ff8575", "title": "Newbury Park ", "sortData": "Newbury Park " }, "Newcastle": { "color": "#515151", "title": "Newcastle", "sortData": "Newcastle", "inResultset": true }, "Newport Beach": { "color": "#00d6ba", "title": "Newport Beach", "sortData": "Newport Beach" }, "Nichols Hills": { "color": "#85c1eb", "title": "Nichols Hills", "sortData": "Nichols Hills" }, "Nipomo": { "color": "#ffb655", "title": "Nipomo", "sortData": "Nipomo" }, "Novato": { "color": "#ff8575", "title": "Novato", "sortData": "Novato" }, "Oak Park": { "color": "#515151", "title": "Oak Park", "sortData": "Oak Park" }, "oak park": { "color": "#00d6ba", "title": "oak park", "sortData": "oak park" }, "OAKLAND": { "color": "#85c1eb", "title": "OAKLAND", "sortData": "OAKLAND", "inResultset": true }, "Oakland": { "color": "#ffb655", "title": "Oakland", "sortData": "Oakland", "inResultset": true }, "Oakland ": { "color": "#ff8575", "title": "Oakland ", "sortData": "Oakland ", "inResultset": true }, "Oaklnd": { "color": "#515151", "title": "Oaklnd", "sortData": "Oaklnd", "inResultset": true }, "Oceanside ": { "color": "#00d6ba", "title": "Oceanside ", "sortData": "Oceanside " }, "Olympia": { "color": "#85c1eb", "title": "Olympia", "sortData": "Olympia", "inResultset": true }, "orange park": { "color": "#ffb655", "title": "orange park", "sortData": "orange park" }, "Orangevale": { "color": "#ff8575", "title": "Orangevale", "sortData": "Orangevale" }, "Orinda": { "color": "#515151", "title": "Orinda", "sortData": "Orinda" }, "Orinda ": { "color": "#00d6ba", "title": "Orinda ", "sortData": "Orinda " }, "Orlando": { "color": "#85c1eb", "title": "Orlando", "sortData": "Orlando", "inResultset": true }, "Overland Park": { "color": "#ffb655", "title": "Overland Park", "sortData": "Overland Park" }, "Oxford": { "color": "#ff8575", "title": "Oxford", "sortData": "Oxford", "inResultset": true }, "Oxnard": { "color": "#515151", "title": "Oxnard", "sortData": "Oxnard" }, "PACIFIC GROVE": { "color": "#00d6ba", "title": "PACIFIC GROVE", "sortData": "PACIFIC GROVE" }, "Pacific Grove": { "color": "#85c1eb", "title": "Pacific Grove", "sortData": "Pacific Grove", "inResultset": true }, "pacific grove": { "color": "#ffb655", "title": "pacific grove", "sortData": "pacific grove" }, "Pacific Grove ": { "color": "#ff8575", "title": "Pacific Grove ", "sortData": "Pacific Grove " }, "Pacific grove ": { "color": "#515151", "title": "Pacific grove ", "sortData": "Pacific grove " }, "Pacific Palisades": { "color": "#00d6ba", "title": "Pacific Palisades", "sortData": "Pacific Palisades" }, "Pahoa": { "color": "#85c1eb", "title": "Pahoa", "sortData": "Pahoa" }, "Palo Alto": { "color": "#ffb655", "title": "Palo Alto", "sortData": "Palo Alto", "inResultset": true }, "Paradise Valley": { "color": "#ff8575", "title": "Paradise Valley", "sortData": "Paradise Valley" }, "Park City": { "color": "#515151", "title": "Park City", "sortData": "Park City" }, "Pasadena": { "color": "#00d6ba", "title": "Pasadena", "sortData": "Pasadena" }, "pasadena": { "color": "#85c1eb", "title": "pasadena", "sortData": "pasadena", "inResultset": true }, "Paso Robles": { "color": "#ffb655", "title": "Paso Robles", "sortData": "Paso Robles" }, "paso robles": { "color": "#ff8575", "title": "paso robles", "sortData": "paso robles" }, "Pebble Beach": { "color": "#515151", "title": "Pebble Beach", "sortData": "Pebble Beach", "inResultset": true }, "Pebble beach": { "color": "#00d6ba", "title": "Pebble beach", "sortData": "Pebble beach" }, "pebble beach": { "color": "#85c1eb", "title": "pebble beach", "sortData": "pebble beach" }, "Pebble Beach ": { "color": "#ffb655", "title": "Pebble Beach ", "sortData": "Pebble Beach " }, "Pebble beach ": { "color": "#ff8575", "title": "Pebble beach ", "sortData": "Pebble beach " }, "Penngrove": { "color": "#515151", "title": "Penngrove", "sortData": "Penngrove" }, "Pescadero": { "color": "#00d6ba", "title": "Pescadero", "sortData": "Pescadero" }, "Petaluma ": { "color": "#85c1eb", "title": "Petaluma ", "sortData": "Petaluma ", "inResultset": true }, "Piedmont": { "color": "#ffb655", "title": "Piedmont", "sortData": "Piedmont" }, "Piedmont ": { "color": "#ff8575", "title": "Piedmont ", "sortData": "Piedmont " }, "Pinole": { "color": "#515151", "title": "Pinole", "sortData": "Pinole" }, "Pismo Beach": { "color": "#00d6ba", "title": "Pismo Beach", "sortData": "Pismo Beach" }, "Pittsburg ": { "color": "#85c1eb", "title": "Pittsburg ", "sortData": "Pittsburg " }, "Placerville": { "color": "#ffb655", "title": "Placerville", "sortData": "Placerville" }, "Plainview": { "color": "#ff8575", "title": "Plainview", "sortData": "Plainview" }, "Pleasant Hill": { "color": "#515151", "title": "Pleasant Hill", "sortData": "Pleasant Hill" }, "Pleasant Hill ": { "color": "#00d6ba", "title": "Pleasant Hill ", "sortData": "Pleasant Hill " }, "Pleasanton": { "color": "#85c1eb", "title": "Pleasanton", "sortData": "Pleasanton" }, "Plymouth": { "color": "#ffb655", "title": "Plymouth", "sortData": "Plymouth" }, "Porter Ranch": { "color": "#ff8575", "title": "Porter Ranch", "sortData": "Porter Ranch", "inResultset": true }, "Portland": { "color": "#515151", "title": "Portland", "sortData": "Portland", "inResultset": true }, "Portola Valley": { "color": "#00d6ba", "title": "Portola Valley", "sortData": "Portola Valley" }, "Prairie Village": { "color": "#85c1eb", "title": "Prairie Village", "sortData": "Prairie Village" }, "PRUNEDALE": { "color": "#ffb655", "title": "PRUNEDALE", "sortData": "PRUNEDALE" }, "Prunedale": { "color": "#ff8575", "title": "Prunedale", "sortData": "Prunedale" }, "Redwood City": { "color": "#515151", "title": "Redwood City", "sortData": "Redwood City" }, "Reno": { "color": "#00d6ba", "title": "Reno", "sortData": "Reno", "inResultset": true }, "Richmond": { "color": "#85c1eb", "title": "Richmond", "sortData": "Richmond" }, "Rio Rancho": { "color": "#ffb655", "title": "Rio Rancho", "sortData": "Rio Rancho" }, "Riverside": { "color": "#ff8575", "title": "Riverside", "sortData": "Riverside" }, "ROSEBURG": { "color": "#515151", "title": "ROSEBURG", "sortData": "ROSEBURG" }, "Roseville": { "color": "#00d6ba", "title": "Roseville", "sortData": "Roseville" }, "Royal Oaks": { "color": "#85c1eb", "title": "Royal Oaks", "sortData": "Royal Oaks" }, "Sacramento": { "color": "#ffb655", "title": "Sacramento", "sortData": "Sacramento", "inResultset": true }, "Sacramento ": { "color": "#ff8575", "title": "Sacramento ", "sortData": "Sacramento " }, "Sacrmento": { "color": "#515151", "title": "Sacrmento", "sortData": "Sacrmento" }, "SALEM": { "color": "#00d6ba", "title": "SALEM", "sortData": "SALEM" }, "SALINAS": { "color": "#85c1eb", "title": "SALINAS", "sortData": "SALINAS" }, "Salinas": { "color": "#ffb655", "title": "Salinas", "sortData": "Salinas", "inResultset": true }, "salinas": { "color": "#ff8575", "title": "salinas", "sortData": "salinas" }, "Salinas ": { "color": "#515151", "title": "Salinas ", "sortData": "Salinas " }, "Sammamish": { "color": "#00d6ba", "title": "Sammamish", "sortData": "Sammamish" }, "San Anselmo": { "color": "#85c1eb", "title": "San Anselmo", "sortData": "San Anselmo", "inResultset": true }, "San Antonio ": { "color": "#ffb655", "title": "San Antonio ", "sortData": "San Antonio " }, "San Bernardino": { "color": "#ff8575", "title": "San Bernardino", "sortData": "San Bernardino", "inResultset": true }, "San Bruno": { "color": "#515151", "title": "San Bruno", "sortData": "San Bruno" }, "San Carlos": { "color": "#00d6ba", "title": "San Carlos", "sortData": "San Carlos" }, "San carlos": { "color": "#85c1eb", "title": "San carlos", "sortData": "San carlos" }, "San Diego": { "color": "#ffb655", "title": "San Diego", "sortData": "San Diego", "inResultset": true }, "San Dimas": { "color": "#ff8575", "title": "San Dimas", "sortData": "San Dimas" }, "SAN FRANCISCO": { "color": "#515151", "title": "SAN FRANCISCO", "sortData": "SAN FRANCISCO" }, "San Francisco": { "color": "#00d6ba", "title": "San Francisco", "sortData": "San Francisco", "inResultset": true }, "san francisco": { "color": "#85c1eb", "title": "san francisco", "sortData": "san francisco" }, "San Francisco ": { "color": "#ffb655", "title": "San Francisco ", "sortData": "San Francisco ", "inResultset": true }, "San Francisco, Calif%46": { "color": "#ff8575", "title": "San Francisco, Calif.", "sortData": "San Francisco, Calif." }, "San Jose": { "color": "#515151", "title": "San Jose", "sortData": "San Jose", "inResultset": true }, "San jose": { "color": "#00d6ba", "title": "San jose", "sortData": "San jose", "inResultset": true }, "san jose": { "color": "#85c1eb", "title": "san jose", "sortData": "san jose", "inResultset": true }, "San Jose ": { "color": "#ffb655", "title": "San Jose ", "sortData": "San Jose " }, "San Leandro": { "color": "#ff8575", "title": "San Leandro", "sortData": "San Leandro" }, "San Luis Obispo": { "color": "#515151", "title": "San Luis Obispo", "sortData": "San Luis Obispo" }, "San Luis Obispo ": { "color": "#00d6ba", "title": "San Luis Obispo ", "sortData": "San Luis Obispo " }, "San Martin": { "color": "#85c1eb", "title": "San Martin", "sortData": "San Martin" }, "San Mateo": { "color": "#ffb655", "title": "San Mateo", "sortData": "San Mateo", "inResultset": true }, "San Mateo ": { "color": "#ff8575", "title": "San Mateo ", "sortData": "San Mateo " }, "San Rafael": { "color": "#515151", "title": "San Rafael", "sortData": "San Rafael" }, "Sand City": { "color": "#00d6ba", "title": "Sand City", "sortData": "Sand City" }, "Sand city": { "color": "#85c1eb", "title": "Sand city", "sortData": "Sand city" }, "Sanford": { "color": "#ffb655", "title": "Sanford", "sortData": "Sanford" }, "Santa Ana": { "color": "#ff8575", "title": "Santa Ana", "sortData": "Santa Ana" }, "SANTA BARBARA": { "color": "#515151", "title": "SANTA BARBARA", "sortData": "SANTA BARBARA", "inResultset": true }, "Santa Barbara": { "color": "#00d6ba", "title": "Santa Barbara", "sortData": "Santa Barbara" }, "Santa Barbara ": { "color": "#85c1eb", "title": "Santa Barbara ", "sortData": "Santa Barbara " }, "Santa Clara": { "color": "#ffb655", "title": "Santa Clara", "sortData": "Santa Clara" }, "SANTA CRUZ": { "color": "#ff8575", "title": "SANTA CRUZ", "sortData": "SANTA CRUZ" }, "Santa Cruz": { "color": "#515151", "title": "Santa Cruz", "sortData": "Santa Cruz", "inResultset": true }, "Santa cruz": { "color": "#00d6ba", "title": "Santa cruz", "sortData": "Santa cruz", "inResultset": true }, "santa cruz": { "color": "#85c1eb", "title": "santa cruz", "sortData": "santa cruz" }, "Santa Cruz ": { "color": "#ffb655", "title": "Santa Cruz ", "sortData": "Santa Cruz " }, "Santa Fe": { "color": "#ff8575", "title": "Santa Fe", "sortData": "Santa Fe" }, "Santa Fe Springs": { "color": "#515151", "title": "Santa Fe Springs", "sortData": "Santa Fe Springs" }, "Santa Maria": { "color": "#00d6ba", "title": "Santa Maria", "sortData": "Santa Maria" }, "Santa Maria ": { "color": "#85c1eb", "title": "Santa Maria ", "sortData": "Santa Maria " }, "Santa Monica": { "color": "#ffb655", "title": "Santa Monica", "sortData": "Santa Monica" }, "Santa Rosa": { "color": "#ff8575", "title": "Santa Rosa", "sortData": "Santa Rosa" }, "Santa Ynez": { "color": "#515151", "title": "Santa Ynez", "sortData": "Santa Ynez" }, "Saratoga": { "color": "#00d6ba", "title": "Saratoga", "sortData": "Saratoga" }, "Sarnia": { "color": "#85c1eb", "title": "Sarnia", "sortData": "Sarnia" }, "SCOTTS VALLEY": { "color": "#ffb655", "title": "SCOTTS VALLEY", "sortData": "SCOTTS VALLEY" }, "Scotts Valley": { "color": "#ff8575", "title": "Scotts Valley", "sortData": "Scotts Valley" }, "SEASIDE": { "color": "#515151", "title": "SEASIDE", "sortData": "SEASIDE" }, "Seaside": { "color": "#00d6ba", "title": "Seaside", "sortData": "Seaside" }, "Seaside ": { "color": "#85c1eb", "title": "Seaside ", "sortData": "Seaside " }, "Seattle": { "color": "#ffb655", "title": "Seattle", "sortData": "Seattle", "inResultset": true }, "seattle": { "color": "#ff8575", "title": "seattle", "sortData": "seattle", "inResultset": true }, "Sherman Oaks": { "color": "#515151", "title": "Sherman Oaks", "sortData": "Sherman Oaks" }, "Shingle Springs": { "color": "#00d6ba", "title": "Shingle Springs", "sortData": "Shingle Springs" }, "Shorewood": { "color": "#85c1eb", "title": "Shorewood", "sortData": "Shorewood" }, "Shrewsbury": { "color": "#ffb655", "title": "Shrewsbury", "sortData": "Shrewsbury", "inResultset": true }, "Sisters": { "color": "#ff8575", "title": "Sisters", "sortData": "Sisters" }, "Smithfield": { "color": "#515151", "title": "Smithfield", "sortData": "Smithfield", "inResultset": true }, "Soledad": { "color": "#00d6ba", "title": "Soledad", "sortData": "Soledad" }, "Solvang": { "color": "#85c1eb", "title": "Solvang", "sortData": "Solvang" }, "SONOMA": { "color": "#ffb655", "title": "SONOMA", "sortData": "SONOMA" }, "Sonoma": { "color": "#ff8575", "title": "Sonoma", "sortData": "Sonoma" }, "Soquel": { "color": "#515151", "title": "Soquel", "sortData": "Soquel", "inResultset": true }, "Soquel ": { "color": "#00d6ba", "title": "Soquel ", "sortData": "Soquel " }, "South San Francisco": { "color": "#85c1eb", "title": "South San Francisco", "sortData": "South San Francisco" }, "Spreckels": { "color": "#ffb655", "title": "Spreckels", "sortData": "Spreckels" }, "Spreckels ": { "color": "#ff8575", "title": "Spreckels ", "sortData": "Spreckels " }, "Spring Branch": { "color": "#515151", "title": "Spring Branch", "sortData": "Spring Branch" }, "Spring City": { "color": "#00d6ba", "title": "Spring City", "sortData": "Spring City" }, "Stanford": { "color": "#85c1eb", "title": "Stanford", "sortData": "Stanford", "inResultset": true }, "Stayton": { "color": "#ffb655", "title": "Stayton", "sortData": "Stayton" }, "Stockton": { "color": "#ff8575", "title": "Stockton", "sortData": "Stockton" }, "Studio City": { "color": "#515151", "title": "Studio City", "sortData": "Studio City" }, "Sun City ": { "color": "#00d6ba", "title": "Sun City ", "sortData": "Sun City " }, "Sunnyvale": { "color": "#85c1eb", "title": "Sunnyvale", "sortData": "Sunnyvale", "inResultset": true }, "Sunnyvale ": { "color": "#ffb655", "title": "Sunnyvale ", "sortData": "Sunnyvale " }, "Tacoma": { "color": "#ff8575", "title": "Tacoma", "sortData": "Tacoma", "inResultset": true }, "Tallahassee": { "color": "#515151", "title": "Tallahassee", "sortData": "Tallahassee" }, "Tampa": { "color": "#00d6ba", "title": "Tampa", "sortData": "Tampa" }, "Tarzana": { "color": "#85c1eb", "title": "Tarzana", "sortData": "Tarzana" }, "Templeton": { "color": "#ffb655", "title": "Templeton", "sortData": "Templeton" }, "Tenafly": { "color": "#ff8575", "title": "Tenafly", "sortData": "Tenafly" }, "Three Rivers": { "color": "#515151", "title": "Three Rivers", "sortData": "Three Rivers", "inResultset": true }, "Tiburon": { "color": "#00d6ba", "title": "Tiburon", "sortData": "Tiburon" }, "Toronto": { "color": "#85c1eb", "title": "Toronto", "sortData": "Toronto", "inResultset": true }, "Tres Pinos": { "color": "#ffb655", "title": "Tres Pinos", "sortData": "Tres Pinos" }, "trinidad": { "color": "#ff8575", "title": "trinidad", "sortData": "trinidad", "inResultset": true }, "Truckee ": { "color": "#515151", "title": "Truckee ", "sortData": "Truckee " }, "Tucson ": { "color": "#00d6ba", "title": "Tucson ", "sortData": "Tucson ", "inResultset": true }, "Turlock": { "color": "#85c1eb", "title": "Turlock", "sortData": "Turlock" }, "Union City": { "color": "#ffb655", "title": "Union City", "sortData": "Union City" }, "Urbandale": { "color": "#ff8575", "title": "Urbandale", "sortData": "Urbandale" }, "Vacaville": { "color": "#515151", "title": "Vacaville", "sortData": "Vacaville" }, "Vacaville ": { "color": "#00d6ba", "title": "Vacaville ", "sortData": "Vacaville " }, "Vallejo": { "color": "#85c1eb", "title": "Vallejo", "sortData": "Vallejo" }, "Vallejo ": { "color": "#ffb655", "title": "Vallejo ", "sortData": "Vallejo " }, "Vista": { "color": "#ff8575", "title": "Vista", "sortData": "Vista", "inResultset": true }, "Walnut Creek": { "color": "#515151", "title": "Walnut Creek", "sortData": "Walnut Creek" }, "WATSONVILLE": { "color": "#00d6ba", "title": "WATSONVILLE", "sortData": "WATSONVILLE" }, "Watsonville": { "color": "#85c1eb", "title": "Watsonville", "sortData": "Watsonville", "inResultset": true }, "Watsonville ": { "color": "#ffb655", "title": "Watsonville ", "sortData": "Watsonville " }, "Wellesley Hills": { "color": "#ff8575", "title": "Wellesley Hills", "sortData": "Wellesley Hills" }, "Wellington": { "color": "#515151", "title": "Wellington", "sortData": "Wellington" }, "West Jordan ": { "color": "#00d6ba", "title": "West Jordan ", "sortData": "West Jordan " }, "West Park": { "color": "#85c1eb", "title": "West Park", "sortData": "West Park" }, "Wheatland": { "color": "#ffb655", "title": "Wheatland", "sortData": "Wheatland" }, "Wheaton": { "color": "#ff8575", "title": "Wheaton", "sortData": "Wheaton" }, "White Bear Lake": { "color": "#515151", "title": "White Bear Lake", "sortData": "White Bear Lake" }, "Woodside": { "color": "#00d6ba", "title": "Woodside", "sortData": "Woodside" }, "Yuba City ": { "color": "#85c1eb", "title": "Yuba City ", "sortData": "Yuba City " } } } }, "through": { "jaql": { "datatype": "text", "dim": "[CONSTITUENT.Primary Address City]", "title": "Primary Address City", "column": "Primary Address City", "table": "CONSTITUENT", "filter": { "explicit": true, "multiSelection": true, "members": [ "Oakland" ] } } } } ], "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Primary Address City", "dim": "[CONSTITUENT.Primary Address City]", "datatype": "text", "merged": true, "title": "Primary Address City" }, "field": { "id": "[CONSTITUENT.Primary Address City]", "index": 0 }, "format": { "members": { "(none)": { "color": "#547A94", "title": "(none)", "sortData": "(none)", "inResultset": true }, "Alameda": { "color": "#F48E06", "title": "Alameda", "sortData": "Alameda" }, "Albany": { "color": "#DB4935", "title": "Albany", "sortData": "Albany", "inResultset": true }, "Alberta ": { "color": "#333333", "title": "Alberta ", "sortData": "Alberta " }, "Albuquerque": { "color": "#008775", "title": "Albuquerque", "sortData": "Albuquerque", "inResultset": true }, "Alexandria": { "color": "#618caa", "title": "Alexandria", "sortData": "Alexandria" }, "Altadena": { "color": "#ff9b16", "title": "Altadena", "sortData": "Altadena", "inResultset": true }, "Anacortes": { "color": "#fc543d", "title": "Anacortes", "sortData": "Anacortes" }, "APTOS": { "color": "#3b3b3b", "title": "APTOS", "sortData": "APTOS" }, "Aptos": { "color": "#009b87", "title": "Aptos", "sortData": "Aptos", "inResultset": true }, "aptos": { "color": "#6897b7", "title": "aptos", "sortData": "aptos" }, "Aptos ": { "color": "#ffa022", "title": "Aptos ", "sortData": "Aptos " }, "Aromas": { "color": "#ff5d47", "title": "Aromas", "sortData": "Aromas" }, "Aromas ": { "color": "#3f3f3f", "title": "Aromas ", "sortData": "Aromas " }, "Arundel": { "color": "#00a790", "title": "Arundel", "sortData": "Arundel", "inResultset": true }, "ASHLAND": { "color": "#6fa1c3", "title": "ASHLAND", "sortData": "ASHLAND" }, "Atherton": { "color": "#ffa62e", "title": "Atherton", "sortData": "Atherton" }, "Atlanta": { "color": "#ff6752", "title": "Atlanta", "sortData": "Atlanta", "inResultset": true }, "Austin": { "color": "#434343", "title": "Austin", "sortData": "Austin" }, "Bainbridge Island": { "color": "#00b29a", "title": "Bainbridge Island", "sortData": "Bainbridge Island" }, "Bellaire": { "color": "#74a9cd", "title": "Bellaire", "sortData": "Bellaire" }, "BELLEVUE": { "color": "#ffaa38", "title": "BELLEVUE", "sortData": "BELLEVUE", "inResultset": true }, "Bellingham": { "color": "#ff6f5b", "title": "Bellingham", "sortData": "Bellingham" }, "Belmont": { "color": "#474747", "title": "Belmont", "sortData": "Belmont" }, "Belvedere": { "color": "#00bba2", "title": "Belvedere", "sortData": "Belvedere" }, "Ben Lomond": { "color": "#79afd5", "title": "Ben Lomond", "sortData": "Ben Lomond" }, "ben lomond": { "color": "#ffad3f", "title": "ben lomond", "sortData": "ben lomond" }, "Benici": { "color": "#ff7461", "title": "Benici", "sortData": "Benici" }, "Benicia": { "color": "#494949", "title": "Benicia", "sortData": "Benicia" }, "BERKELEY": { "color": "#00c2a8", "title": "BERKELEY", "sortData": "BERKELEY", "inResultset": true }, "Berkeley": { "color": "#7cb4db", "title": "Berkeley", "sortData": "Berkeley", "inResultset": true }, "beverly hills": { "color": "#ffaf45", "title": "beverly hills", "sortData": "beverly hills" }, "Big Sur": { "color": "#ff7966", "title": "Big Sur", "sortData": "Big Sur", "inResultset": true }, "Bloomfield Hills": { "color": "#4b4b4b", "title": "Bloomfield Hills", "sortData": "Bloomfield Hills" }, "Blue lake": { "color": "#00c7ad", "title": "Blue lake", "sortData": "Blue lake", "inResultset": true }, "Boise": { "color": "#7fb8df", "title": "Boise", "sortData": "Boise" }, "Boulder": { "color": "#ffb14a", "title": "Boulder", "sortData": "Boulder" }, "BOULDER CREEK": { "color": "#ff7d6b", "title": "BOULDER CREEK", "sortData": "BOULDER CREEK" }, "Boulder Creek": { "color": "#4d4d4d", "title": "Boulder Creek", "sortData": "Boulder Creek" }, "Brentwood": { "color": "#00ccb1", "title": "Brentwood", "sortData": "Brentwood" }, "Brooklyn": { "color": "#81bce4", "title": "Brooklyn", "sortData": "Brooklyn", "inResultset": true }, "Buellton": { "color": "#ffb34e", "title": "Buellton", "sortData": "Buellton" }, "Burlington": { "color": "#ff806f", "title": "Burlington", "sortData": "Burlington" }, "Cambria": { "color": "#4e4e4e", "title": "Cambria", "sortData": "Cambria" }, "Campbell": { "color": "#00d0b4", "title": "Campbell", "sortData": "Campbell", "inResultset": true }, "Campbell ": { "color": "#83bfe7", "title": "Campbell ", "sortData": "Campbell " }, "Capistrano Beach ": { "color": "#ffb552", "title": "Capistrano Beach ", "sortData": "Capistrano Beach " }, "Capitola": { "color": "#ff8372", "title": "Capitola", "sortData": "Capitola", "inResultset": true }, "Capitola ": { "color": "#505050", "title": "Capitola ", "sortData": "Capitola " }, "Carlsbad": { "color": "#00d3b7", "title": "Carlsbad", "sortData": "Carlsbad" }, "CARMEL": { "color": "#85c1eb", "title": "CARMEL", "sortData": "CARMEL" }, "Carmel": { "color": "#ffb655", "title": "Carmel", "sortData": "Carmel", "inResultset": true }, "carmel": { "color": "#ff8575", "title": "carmel", "sortData": "carmel" }, "Carmel ": { "color": "#515151", "title": "Carmel ", "sortData": "Carmel " }, "Carmel By The Sea": { "color": "#00d6ba", "title": "Carmel By The Sea", "sortData": "Carmel By The Sea" }, "Carmel by the Sea": { "color": "#ffb655", "title": "Carmel by the Sea", "sortData": "Carmel by the Sea" }, "Carmel Highlands": { "color": "#ff8575", "title": "Carmel Highlands", "sortData": "Carmel Highlands", "inResultset": true }, "Carmel Valley": { "color": "#515151", "title": "Carmel Valley", "sortData": "Carmel Valley" }, "carmel valley": { "color": "#00d6ba", "title": "carmel valley", "sortData": "carmel valley" }, "Carmel Valley ": { "color": "#85c1eb", "title": "Carmel Valley ", "sortData": "Carmel Valley " }, "Carmel Valley Village": { "color": "#ffb655", "title": "Carmel Valley Village", "sortData": "Carmel Valley Village" }, "Carmel, CA": { "color": "#ff8575", "title": "Carmel, CA", "sortData": "Carmel, CA" }, "Carmel-by-the-Sea": { "color": "#515151", "title": "Carmel-by-the-Sea", "sortData": "Carmel-by-the-Sea" }, "Carmichael": { "color": "#00d6ba", "title": "Carmichael", "sortData": "Carmichael" }, "CARPINTERIA": { "color": "#85c1eb", "title": "CARPINTERIA", "sortData": "CARPINTERIA" }, "Carpinteria ": { "color": "#ffb655", "title": "Carpinteria ", "sortData": "Carpinteria " }, "Carson City": { "color": "#ff8575", "title": "Carson City", "sortData": "Carson City", "inResultset": true }, "Castle Rock": { "color": "#515151", "title": "Castle Rock", "sortData": "Castle Rock", "inResultset": true }, "Castro valley": { "color": "#00d6ba", "title": "Castro valley", "sortData": "Castro valley" }, "Cayucos": { "color": "#85c1eb", "title": "Cayucos", "sortData": "Cayucos" }, "Cazadero": { "color": "#ffb655", "title": "Cazadero", "sortData": "Cazadero" }, "Chagrin Falls": { "color": "#ff8575", "title": "Chagrin Falls", "sortData": "Chagrin Falls" }, "Chandler": { "color": "#515151", "title": "Chandler", "sortData": "Chandler", "inResultset": true }, "Chicago": { "color": "#00d6ba", "title": "Chicago", "sortData": "Chicago" }, "Chico": { "color": "#85c1eb", "title": "Chico", "sortData": "Chico" }, "Chico ": { "color": "#ffb655", "title": "Chico ", "sortData": "Chico " }, "Cincinnati": { "color": "#ff8575", "title": "Cincinnati", "sortData": "Cincinnati" }, "Clayton": { "color": "#515151", "title": "Clayton", "sortData": "Clayton" }, "Cloverdale": { "color": "#00d6ba", "title": "Cloverdale", "sortData": "Cloverdale", "inResultset": true }, "Columbus": { "color": "#85c1eb", "title": "Columbus", "sortData": "Columbus" }, "Concord": { "color": "#ffb655", "title": "Concord", "sortData": "Concord" }, "Corona Del Mar": { "color": "#ff8575", "title": "Corona Del Mar", "sortData": "Corona Del Mar" }, "Corral De Tierra": { "color": "#515151", "title": "Corral De Tierra", "sortData": "Corral De Tierra" }, "Corral de Tierra": { "color": "#00d6ba", "title": "Corral de Tierra", "sortData": "Corral de Tierra" }, "Corral de Tierra ": { "color": "#85c1eb", "title": "Corral de Tierra ", "sortData": "Corral de Tierra " }, "Corvallis ": { "color": "#ffb655", "title": "Corvallis ", "sortData": "Corvallis ", "inResultset": true }, "Costa Mesa ": { "color": "#ff8575", "title": "Costa Mesa ", "sortData": "Costa Mesa " }, "Cupertino": { "color": "#515151", "title": "Cupertino", "sortData": "Cupertino" }, "DALLAS": { "color": "#00d6ba", "title": "DALLAS", "sortData": "DALLAS" }, "Dallas": { "color": "#85c1eb", "title": "Dallas", "sortData": "Dallas", "inResultset": true }, "dallas": { "color": "#ffb655", "title": "dallas", "sortData": "dallas" }, "Dana Point": { "color": "#ff8575", "title": "Dana Point", "sortData": "Dana Point" }, "DANVILLE": { "color": "#515151", "title": "DANVILLE", "sortData": "DANVILLE" }, "Danville": { "color": "#00d6ba", "title": "Danville", "sortData": "Danville", "inResultset": true }, "Davenport": { "color": "#85c1eb", "title": "Davenport", "sortData": "Davenport" }, "Davis": { "color": "#ffb655", "title": "Davis", "sortData": "Davis", "inResultset": true }, "Del Rey Oaks": { "color": "#ff8575", "title": "Del Rey Oaks", "sortData": "Del Rey Oaks" }, "Denver": { "color": "#515151", "title": "Denver", "sortData": "Denver" }, "Discovery Bay ": { "color": "#00d6ba", "title": "Discovery Bay ", "sortData": "Discovery Bay " }, "Douglas": { "color": "#85c1eb", "title": "Douglas", "sortData": "Douglas" }, "E%46 Brunswick": { "color": "#ffb655", "title": "E. Brunswick", "sortData": "E. Brunswick", "inResultset": true }, "East Garrison": { "color": "#ff8575", "title": "East Garrison", "sortData": "East Garrison" }, "Eden Prairie": { "color": "#515151", "title": "Eden Prairie", "sortData": "Eden Prairie" }, "El Cerrito": { "color": "#00d6ba", "title": "El Cerrito", "sortData": "El Cerrito", "inResultset": true }, "El Dorado Hills": { "color": "#85c1eb", "title": "El Dorado Hills", "sortData": "El Dorado Hills" }, "El Paso": { "color": "#ffb655", "title": "El Paso", "sortData": "El Paso" }, "Elk Grove": { "color": "#ff8575", "title": "Elk Grove", "sortData": "Elk Grove" }, "Elverta": { "color": "#515151", "title": "Elverta", "sortData": "Elverta", "inResultset": true }, "Encinitas": { "color": "#00d6ba", "title": "Encinitas", "sortData": "Encinitas" }, "Fair Oaks": { "color": "#85c1eb", "title": "Fair Oaks", "sortData": "Fair Oaks", "inResultset": true }, "Fallbrook": { "color": "#ffb655", "title": "Fallbrook", "sortData": "Fallbrook" }, "Farmington": { "color": "#ff8575", "title": "Farmington", "sortData": "Farmington" }, "Felton": { "color": "#515151", "title": "Felton", "sortData": "Felton", "inResultset": true }, "Folsom": { "color": "#00d6ba", "title": "Folsom", "sortData": "Folsom" }, "Fonthill, Ontario": { "color": "#85c1eb", "title": "Fonthill, Ontario", "sortData": "Fonthill, Ontario" }, "Forest Grove": { "color": "#ffb655", "title": "Forest Grove", "sortData": "Forest Grove", "inResultset": true }, "Fort collins": { "color": "#ff8575", "title": "Fort collins", "sortData": "Fort collins", "inResultset": true }, "Fortville": { "color": "#515151", "title": "Fortville", "sortData": "Fortville" }, "Freedom": { "color": "#00d6ba", "title": "Freedom", "sortData": "Freedom" }, "Fremont": { "color": "#85c1eb", "title": "Fremont", "sortData": "Fremont", "inResultset": true }, "FRESNO": { "color": "#ffb655", "title": "FRESNO", "sortData": "FRESNO" }, "Fresno": { "color": "#ff8575", "title": "Fresno", "sortData": "Fresno" }, "Frisco": { "color": "#515151", "title": "Frisco", "sortData": "Frisco" }, "Gardnerville": { "color": "#00d6ba", "title": "Gardnerville", "sortData": "Gardnerville" }, "Georgetown": { "color": "#85c1eb", "title": "Georgetown", "sortData": "Georgetown" }, "Gilroy": { "color": "#ffb655", "title": "Gilroy", "sortData": "Gilroy", "inResultset": true }, "Gilroy ": { "color": "#ff8575", "title": "Gilroy ", "sortData": "Gilroy " }, "Glendale ": { "color": "#515151", "title": "Glendale ", "sortData": "Glendale ", "inResultset": true }, "Gold River": { "color": "#00d6ba", "title": "Gold River", "sortData": "Gold River" }, "Gonzales": { "color": "#85c1eb", "title": "Gonzales", "sortData": "Gonzales" }, "Grand Rapids": { "color": "#ffb655", "title": "Grand Rapids", "sortData": "Grand Rapids" }, "Grand Ronde": { "color": "#ff8575", "title": "Grand Ronde", "sortData": "Grand Ronde" }, "Grass Valley": { "color": "#515151", "title": "Grass Valley", "sortData": "Grass Valley", "inResultset": true }, "Greenbank": { "color": "#00d6ba", "title": "Greenbank", "sortData": "Greenbank" }, "Greenbrae ": { "color": "#85c1eb", "title": "Greenbrae ", "sortData": "Greenbrae " }, "Greenfield": { "color": "#ffb655", "title": "Greenfield", "sortData": "Greenfield" }, "Greenwich": { "color": "#ff8575", "title": "Greenwich", "sortData": "Greenwich" }, "Half Moon Bay": { "color": "#515151", "title": "Half Moon Bay", "sortData": "Half Moon Bay" }, "Hayward": { "color": "#00d6ba", "title": "Hayward", "sortData": "Hayward" }, "Healdsburg": { "color": "#85c1eb", "title": "Healdsburg", "sortData": "Healdsburg" }, "Hercules": { "color": "#ffb655", "title": "Hercules", "sortData": "Hercules" }, "Hillsborough": { "color": "#ff8575", "title": "Hillsborough", "sortData": "Hillsborough" }, "Hollister": { "color": "#515151", "title": "Hollister", "sortData": "Hollister" }, "Hollister ": { "color": "#00d6ba", "title": "Hollister ", "sortData": "Hollister " }, "Hollywood": { "color": "#85c1eb", "title": "Hollywood", "sortData": "Hollywood" }, "Honolulu": { "color": "#ffb655", "title": "Honolulu", "sortData": "Honolulu" }, "Houston": { "color": "#ff8575", "title": "Houston", "sortData": "Houston", "inResultset": true }, "Huntington Beach": { "color": "#515151", "title": "Huntington Beach", "sortData": "Huntington Beach" }, "Iaasquah": { "color": "#00d6ba", "title": "Iaasquah", "sortData": "Iaasquah" }, "Incline Village": { "color": "#85c1eb", "title": "Incline Village", "sortData": "Incline Village" }, "Juneau": { "color": "#ffb655", "title": "Juneau", "sortData": "Juneau" }, "Jupiter": { "color": "#ff8575", "title": "Jupiter", "sortData": "Jupiter" }, "Kapaa": { "color": "#515151", "title": "Kapaa", "sortData": "Kapaa" }, "Kenwood": { "color": "#00d6ba", "title": "Kenwood", "sortData": "Kenwood" }, "Kerman": { "color": "#85c1eb", "title": "Kerman", "sortData": "Kerman" }, "King City": { "color": "#ffb655", "title": "King City", "sortData": "King City", "inResultset": true }, "LA": { "color": "#ff8575", "title": "LA", "sortData": "LA" }, "La Canada": { "color": "#515151", "title": "La Canada", "sortData": "La Canada" }, "La Mesa": { "color": "#00d6ba", "title": "La Mesa", "sortData": "La Mesa", "inResultset": true }, "La Porte": { "color": "#85c1eb", "title": "La Porte", "sortData": "La Porte" }, "La Quinta": { "color": "#ffb655", "title": "La Quinta", "sortData": "La Quinta" }, "La Selva Beach": { "color": "#ff8575", "title": "La Selva Beach", "sortData": "La Selva Beach" }, "Ladera Ranch": { "color": "#515151", "title": "Ladera Ranch", "sortData": "Ladera Ranch" }, "LAFAYETTE": { "color": "#00d6ba", "title": "LAFAYETTE", "sortData": "LAFAYETTE" }, "Lafayette ": { "color": "#85c1eb", "title": "Lafayette ", "sortData": "Lafayette " }, "Lahaina": { "color": "#ffb655", "title": "Lahaina", "sortData": "Lahaina" }, "Lake Elsinore": { "color": "#ff8575", "title": "Lake Elsinore", "sortData": "Lake Elsinore" }, "Lake Oswego": { "color": "#515151", "title": "Lake Oswego", "sortData": "Lake Oswego", "inResultset": true }, "Lakeport": { "color": "#00d6ba", "title": "Lakeport", "sortData": "Lakeport" }, "Lakewood": { "color": "#85c1eb", "title": "Lakewood", "sortData": "Lakewood" }, "lakewood": { "color": "#ffb655", "title": "lakewood", "sortData": "lakewood" }, "Las Vegas": { "color": "#ff8575", "title": "Las Vegas", "sortData": "Las Vegas", "inResultset": true }, "Lee Vining": { "color": "#515151", "title": "Lee Vining", "sortData": "Lee Vining", "inResultset": true }, "Lincoln": { "color": "#00d6ba", "title": "Lincoln", "sortData": "Lincoln" }, "Livermore": { "color": "#85c1eb", "title": "Livermore", "sortData": "Livermore" }, "Livermore ": { "color": "#ffb655", "title": "Livermore ", "sortData": "Livermore " }, "Loma Linda ": { "color": "#ff8575", "title": "Loma Linda ", "sortData": "Loma Linda " }, "London": { "color": "#515151", "title": "London", "sortData": "London" }, "Long beach": { "color": "#00d6ba", "title": "Long beach", "sortData": "Long beach" }, "Longmont ": { "color": "#85c1eb", "title": "Longmont ", "sortData": "Longmont " }, "Longview": { "color": "#ffb655", "title": "Longview", "sortData": "Longview" }, "Los Altos": { "color": "#ff8575", "title": "Los Altos", "sortData": "Los Altos" }, "Los Altos Hills": { "color": "#515151", "title": "Los Altos Hills", "sortData": "Los Altos Hills" }, "Los Angeles": { "color": "#00d6ba", "title": "Los Angeles", "sortData": "Los Angeles", "inResultset": true }, "Los angeles": { "color": "#85c1eb", "title": "Los angeles", "sortData": "Los angeles", "inResultset": true }, "Los Banos": { "color": "#ffb655", "title": "Los Banos", "sortData": "Los Banos" }, "Los Gatos": { "color": "#ff8575", "title": "Los Gatos", "sortData": "Los Gatos" }, "Los Gatos ": { "color": "#515151", "title": "Los Gatos ", "sortData": "Los Gatos " }, "louisville": { "color": "#00d6ba", "title": "louisville", "sortData": "louisville" }, "Marana": { "color": "#85c1eb", "title": "Marana", "sortData": "Marana" }, "Marina": { "color": "#ffb655", "title": "Marina", "sortData": "Marina" }, "marina": { "color": "#ff8575", "title": "marina", "sortData": "marina" }, "Marina ": { "color": "#515151", "title": "Marina ", "sortData": "Marina " }, "Mariposa": { "color": "#00d6ba", "title": "Mariposa", "sortData": "Mariposa" }, "Mars Hill": { "color": "#85c1eb", "title": "Mars Hill", "sortData": "Mars Hill" }, "Martinez": { "color": "#ffb655", "title": "Martinez", "sortData": "Martinez", "inResultset": true }, "Marysville": { "color": "#ff8575", "title": "Marysville", "sortData": "Marysville" }, "Menlo Park": { "color": "#515151", "title": "Menlo Park", "sortData": "Menlo Park" }, "Metaire": { "color": "#00d6ba", "title": "Metaire", "sortData": "Metaire" }, "Miami": { "color": "#85c1eb", "title": "Miami", "sortData": "Miami" }, "Mill Valley": { "color": "#ffb655", "title": "Mill Valley", "sortData": "Mill Valley" }, "Milpitas": { "color": "#ff8575", "title": "Milpitas", "sortData": "Milpitas" }, "Missouri Valley": { "color": "#515151", "title": "Missouri Valley", "sortData": "Missouri Valley", "inResultset": true }, "Modesto": { "color": "#00d6ba", "title": "Modesto", "sortData": "Modesto" }, "Monte Sereno": { "color": "#85c1eb", "title": "Monte Sereno", "sortData": "Monte Sereno" }, "MONTEREY": { "color": "#ffb655", "title": "MONTEREY", "sortData": "MONTEREY", "inResultset": true }, "Monterey": { "color": "#ff8575", "title": "Monterey", "sortData": "Monterey", "inResultset": true }, "monterey": { "color": "#515151", "title": "monterey", "sortData": "monterey" }, "Monterey ": { "color": "#00d6ba", "title": "Monterey ", "sortData": "Monterey ", "inResultset": true }, "Morgan Hill": { "color": "#85c1eb", "title": "Morgan Hill", "sortData": "Morgan Hill" }, "Morgan Hill ": { "color": "#ffb655", "title": "Morgan Hill ", "sortData": "Morgan Hill " }, "Morro Bay": { "color": "#ff8575", "title": "Morro Bay", "sortData": "Morro Bay" }, "Moss Landing": { "color": "#515151", "title": "Moss Landing", "sortData": "Moss Landing" }, "Mountain View": { "color": "#00d6ba", "title": "Mountain View", "sortData": "Mountain View", "inResultset": true }, "Muir Beach": { "color": "#85c1eb", "title": "Muir Beach", "sortData": "Muir Beach" }, "Napa": { "color": "#ffb655", "title": "Napa", "sortData": "Napa" }, "Nevada City": { "color": "#ff8575", "title": "Nevada City", "sortData": "Nevada City" }, "new market": { "color": "#515151", "title": "new market", "sortData": "new market" }, "New York": { "color": "#00d6ba", "title": "New York", "sortData": "New York", "inResultset": true }, "New York ": { "color": "#85c1eb", "title": "New York ", "sortData": "New York ", "inResultset": true }, "Newbury Park": { "color": "#ffb655", "title": "Newbury Park", "sortData": "Newbury Park", "inResultset": true }, "Newbury Park ": { "color": "#ff8575", "title": "Newbury Park ", "sortData": "Newbury Park " }, "Newcastle": { "color": "#515151", "title": "Newcastle", "sortData": "Newcastle", "inResultset": true }, "Newport Beach": { "color": "#00d6ba", "title": "Newport Beach", "sortData": "Newport Beach" }, "Nichols Hills": { "color": "#85c1eb", "title": "Nichols Hills", "sortData": "Nichols Hills" }, "Nipomo": { "color": "#ffb655", "title": "Nipomo", "sortData": "Nipomo" }, "Novato": { "color": "#ff8575", "title": "Novato", "sortData": "Novato" }, "Oak Park": { "color": "#515151", "title": "Oak Park", "sortData": "Oak Park" }, "oak park": { "color": "#00d6ba", "title": "oak park", "sortData": "oak park" }, "OAKLAND": { "color": "#85c1eb", "title": "OAKLAND", "sortData": "OAKLAND", "inResultset": true }, "Oakland": { "color": "#ffb655", "title": "Oakland", "sortData": "Oakland", "inResultset": true }, "Oakland ": { "color": "#ff8575", "title": "Oakland ", "sortData": "Oakland ", "inResultset": true }, "Oaklnd": { "color": "#515151", "title": "Oaklnd", "sortData": "Oaklnd", "inResultset": true }, "Oceanside ": { "color": "#00d6ba", "title": "Oceanside ", "sortData": "Oceanside " }, "Olympia": { "color": "#85c1eb", "title": "Olympia", "sortData": "Olympia", "inResultset": true }, "orange park": { "color": "#ffb655", "title": "orange park", "sortData": "orange park" }, "Orangevale": { "color": "#ff8575", "title": "Orangevale", "sortData": "Orangevale" }, "Orinda": { "color": "#515151", "title": "Orinda", "sortData": "Orinda" }, "Orinda ": { "color": "#00d6ba", "title": "Orinda ", "sortData": "Orinda " }, "Orlando": { "color": "#85c1eb", "title": "Orlando", "sortData": "Orlando", "inResultset": true }, "Overland Park": { "color": "#ffb655", "title": "Overland Park", "sortData": "Overland Park" }, "Oxford": { "color": "#ff8575", "title": "Oxford", "sortData": "Oxford", "inResultset": true }, "Oxnard": { "color": "#515151", "title": "Oxnard", "sortData": "Oxnard" }, "PACIFIC GROVE": { "color": "#00d6ba", "title": "PACIFIC GROVE", "sortData": "PACIFIC GROVE" }, "Pacific Grove": { "color": "#85c1eb", "title": "Pacific Grove", "sortData": "Pacific Grove", "inResultset": true }, "pacific grove": { "color": "#ffb655", "title": "pacific grove", "sortData": "pacific grove" }, "Pacific Grove ": { "color": "#ff8575", "title": "Pacific Grove ", "sortData": "Pacific Grove " }, "Pacific grove ": { "color": "#515151", "title": "Pacific grove ", "sortData": "Pacific grove " }, "Pacific Palisades": { "color": "#00d6ba", "title": "Pacific Palisades", "sortData": "Pacific Palisades" }, "Pahoa": { "color": "#85c1eb", "title": "Pahoa", "sortData": "Pahoa" }, "Palo Alto": { "color": "#ffb655", "title": "Palo Alto", "sortData": "Palo Alto", "inResultset": true }, "Paradise Valley": { "color": "#ff8575", "title": "Paradise Valley", "sortData": "Paradise Valley" }, "Park City": { "color": "#515151", "title": "Park City", "sortData": "Park City" }, "Pasadena": { "color": "#00d6ba", "title": "Pasadena", "sortData": "Pasadena" }, "pasadena": { "color": "#85c1eb", "title": "pasadena", "sortData": "pasadena", "inResultset": true }, "Paso Robles": { "color": "#ffb655", "title": "Paso Robles", "sortData": "Paso Robles" }, "paso robles": { "color": "#ff8575", "title": "paso robles", "sortData": "paso robles" }, "Pebble Beach": { "color": "#515151", "title": "Pebble Beach", "sortData": "Pebble Beach", "inResultset": true }, "Pebble beach": { "color": "#00d6ba", "title": "Pebble beach", "sortData": "Pebble beach" }, "pebble beach": { "color": "#85c1eb", "title": "pebble beach", "sortData": "pebble beach" }, "Pebble Beach ": { "color": "#ffb655", "title": "Pebble Beach ", "sortData": "Pebble Beach " }, "Pebble beach ": { "color": "#ff8575", "title": "Pebble beach ", "sortData": "Pebble beach " }, "Penngrove": { "color": "#515151", "title": "Penngrove", "sortData": "Penngrove" }, "Pescadero": { "color": "#00d6ba", "title": "Pescadero", "sortData": "Pescadero" }, "Petaluma ": { "color": "#85c1eb", "title": "Petaluma ", "sortData": "Petaluma ", "inResultset": true }, "Piedmont": { "color": "#ffb655", "title": "Piedmont", "sortData": "Piedmont" }, "Piedmont ": { "color": "#ff8575", "title": "Piedmont ", "sortData": "Piedmont " }, "Pinole": { "color": "#515151", "title": "Pinole", "sortData": "Pinole" }, "Pismo Beach": { "color": "#00d6ba", "title": "Pismo Beach", "sortData": "Pismo Beach" }, "Pittsburg ": { "color": "#85c1eb", "title": "Pittsburg ", "sortData": "Pittsburg " }, "Placerville": { "color": "#ffb655", "title": "Placerville", "sortData": "Placerville" }, "Plainview": { "color": "#ff8575", "title": "Plainview", "sortData": "Plainview" }, "Pleasant Hill": { "color": "#515151", "title": "Pleasant Hill", "sortData": "Pleasant Hill" }, "Pleasant Hill ": { "color": "#00d6ba", "title": "Pleasant Hill ", "sortData": "Pleasant Hill " }, "Pleasanton": { "color": "#85c1eb", "title": "Pleasanton", "sortData": "Pleasanton" }, "Plymouth": { "color": "#ffb655", "title": "Plymouth", "sortData": "Plymouth" }, "Porter Ranch": { "color": "#ff8575", "title": "Porter Ranch", "sortData": "Porter Ranch", "inResultset": true }, "Portland": { "color": "#515151", "title": "Portland", "sortData": "Portland", "inResultset": true }, "Portola Valley": { "color": "#00d6ba", "title": "Portola Valley", "sortData": "Portola Valley" }, "Prairie Village": { "color": "#85c1eb", "title": "Prairie Village", "sortData": "Prairie Village" }, "PRUNEDALE": { "color": "#ffb655", "title": "PRUNEDALE", "sortData": "PRUNEDALE" }, "Prunedale": { "color": "#ff8575", "title": "Prunedale", "sortData": "Prunedale" }, "Redwood City": { "color": "#515151", "title": "Redwood City", "sortData": "Redwood City" }, "Reno": { "color": "#00d6ba", "title": "Reno", "sortData": "Reno", "inResultset": true }, "Richmond": { "color": "#85c1eb", "title": "Richmond", "sortData": "Richmond" }, "Rio Rancho": { "color": "#ffb655", "title": "Rio Rancho", "sortData": "Rio Rancho" }, "Riverside": { "color": "#ff8575", "title": "Riverside", "sortData": "Riverside" }, "ROSEBURG": { "color": "#515151", "title": "ROSEBURG", "sortData": "ROSEBURG" }, "Roseville": { "color": "#00d6ba", "title": "Roseville", "sortData": "Roseville" }, "Royal Oaks": { "color": "#85c1eb", "title": "Royal Oaks", "sortData": "Royal Oaks" }, "Sacramento": { "color": "#ffb655", "title": "Sacramento", "sortData": "Sacramento", "inResultset": true }, "Sacramento ": { "color": "#ff8575", "title": "Sacramento ", "sortData": "Sacramento " }, "Sacrmento": { "color": "#515151", "title": "Sacrmento", "sortData": "Sacrmento" }, "SALEM": { "color": "#00d6ba", "title": "SALEM", "sortData": "SALEM" }, "SALINAS": { "color": "#85c1eb", "title": "SALINAS", "sortData": "SALINAS" }, "Salinas": { "color": "#ffb655", "title": "Salinas", "sortData": "Salinas", "inResultset": true }, "salinas": { "color": "#ff8575", "title": "salinas", "sortData": "salinas" }, "Salinas ": { "color": "#515151", "title": "Salinas ", "sortData": "Salinas " }, "Sammamish": { "color": "#00d6ba", "title": "Sammamish", "sortData": "Sammamish" }, "San Anselmo": { "color": "#85c1eb", "title": "San Anselmo", "sortData": "San Anselmo", "inResultset": true }, "San Antonio ": { "color": "#ffb655", "title": "San Antonio ", "sortData": "San Antonio " }, "San Bernardino": { "color": "#ff8575", "title": "San Bernardino", "sortData": "San Bernardino", "inResultset": true }, "San Bruno": { "color": "#515151", "title": "San Bruno", "sortData": "San Bruno" }, "San Carlos": { "color": "#00d6ba", "title": "San Carlos", "sortData": "San Carlos" }, "San carlos": { "color": "#85c1eb", "title": "San carlos", "sortData": "San carlos" }, "San Diego": { "color": "#ffb655", "title": "San Diego", "sortData": "San Diego", "inResultset": true }, "San Dimas": { "color": "#ff8575", "title": "San Dimas", "sortData": "San Dimas" }, "SAN FRANCISCO": { "color": "#515151", "title": "SAN FRANCISCO", "sortData": "SAN FRANCISCO" }, "San Francisco": { "color": "#00d6ba", "title": "San Francisco", "sortData": "San Francisco", "inResultset": true }, "san francisco": { "color": "#85c1eb", "title": "san francisco", "sortData": "san francisco" }, "San Francisco ": { "color": "#ffb655", "title": "San Francisco ", "sortData": "San Francisco ", "inResultset": true }, "San Francisco, Calif%46": { "color": "#ff8575", "title": "San Francisco, Calif.", "sortData": "San Francisco, Calif." }, "San Jose": { "color": "#515151", "title": "San Jose", "sortData": "San Jose", "inResultset": true }, "San jose": { "color": "#00d6ba", "title": "San jose", "sortData": "San jose", "inResultset": true }, "san jose": { "color": "#85c1eb", "title": "san jose", "sortData": "san jose", "inResultset": true }, "San Jose ": { "color": "#ffb655", "title": "San Jose ", "sortData": "San Jose " }, "San Leandro": { "color": "#ff8575", "title": "San Leandro", "sortData": "San Leandro" }, "San Luis Obispo": { "color": "#515151", "title": "San Luis Obispo", "sortData": "San Luis Obispo" }, "San Luis Obispo ": { "color": "#00d6ba", "title": "San Luis Obispo ", "sortData": "San Luis Obispo " }, "San Martin": { "color": "#85c1eb", "title": "San Martin", "sortData": "San Martin" }, "San Mateo": { "color": "#ffb655", "title": "San Mateo", "sortData": "San Mateo", "inResultset": true }, "San Mateo ": { "color": "#ff8575", "title": "San Mateo ", "sortData": "San Mateo " }, "San Rafael": { "color": "#515151", "title": "San Rafael", "sortData": "San Rafael" }, "Sand City": { "color": "#00d6ba", "title": "Sand City", "sortData": "Sand City" }, "Sand city": { "color": "#85c1eb", "title": "Sand city", "sortData": "Sand city" }, "Sanford": { "color": "#ffb655", "title": "Sanford", "sortData": "Sanford" }, "Santa Ana": { "color": "#ff8575", "title": "Santa Ana", "sortData": "Santa Ana" }, "SANTA BARBARA": { "color": "#515151", "title": "SANTA BARBARA", "sortData": "SANTA BARBARA", "inResultset": true }, "Santa Barbara": { "color": "#00d6ba", "title": "Santa Barbara", "sortData": "Santa Barbara" }, "Santa Barbara ": { "color": "#85c1eb", "title": "Santa Barbara ", "sortData": "Santa Barbara " }, "Santa Clara": { "color": "#ffb655", "title": "Santa Clara", "sortData": "Santa Clara" }, "SANTA CRUZ": { "color": "#ff8575", "title": "SANTA CRUZ", "sortData": "SANTA CRUZ" }, "Santa Cruz": { "color": "#515151", "title": "Santa Cruz", "sortData": "Santa Cruz", "inResultset": true }, "Santa cruz": { "color": "#00d6ba", "title": "Santa cruz", "sortData": "Santa cruz", "inResultset": true }, "santa cruz": { "color": "#85c1eb", "title": "santa cruz", "sortData": "santa cruz" }, "Santa Cruz ": { "color": "#ffb655", "title": "Santa Cruz ", "sortData": "Santa Cruz " }, "Santa Fe": { "color": "#ff8575", "title": "Santa Fe", "sortData": "Santa Fe" }, "Santa Fe Springs": { "color": "#515151", "title": "Santa Fe Springs", "sortData": "Santa Fe Springs" }, "Santa Maria": { "color": "#00d6ba", "title": "Santa Maria", "sortData": "Santa Maria" }, "Santa Maria ": { "color": "#85c1eb", "title": "Santa Maria ", "sortData": "Santa Maria " }, "Santa Monica": { "color": "#ffb655", "title": "Santa Monica", "sortData": "Santa Monica" }, "Santa Rosa": { "color": "#ff8575", "title": "Santa Rosa", "sortData": "Santa Rosa" }, "Santa Ynez": { "color": "#515151", "title": "Santa Ynez", "sortData": "Santa Ynez" }, "Saratoga": { "color": "#00d6ba", "title": "Saratoga", "sortData": "Saratoga" }, "Sarnia": { "color": "#85c1eb", "title": "Sarnia", "sortData": "Sarnia" }, "SCOTTS VALLEY": { "color": "#ffb655", "title": "SCOTTS VALLEY", "sortData": "SCOTTS VALLEY" }, "Scotts Valley": { "color": "#ff8575", "title": "Scotts Valley", "sortData": "Scotts Valley" }, "SEASIDE": { "color": "#515151", "title": "SEASIDE", "sortData": "SEASIDE" }, "Seaside": { "color": "#00d6ba", "title": "Seaside", "sortData": "Seaside" }, "Seaside ": { "color": "#85c1eb", "title": "Seaside ", "sortData": "Seaside " }, "Seattle": { "color": "#ffb655", "title": "Seattle", "sortData": "Seattle", "inResultset": true }, "seattle": { "color": "#ff8575", "title": "seattle", "sortData": "seattle", "inResultset": true }, "Sherman Oaks": { "color": "#515151", "title": "Sherman Oaks", "sortData": "Sherman Oaks" }, "Shingle Springs": { "color": "#00d6ba", "title": "Shingle Springs", "sortData": "Shingle Springs" }, "Shorewood": { "color": "#85c1eb", "title": "Shorewood", "sortData": "Shorewood" }, "Shrewsbury": { "color": "#ffb655", "title": "Shrewsbury", "sortData": "Shrewsbury", "inResultset": true }, "Sisters": { "color": "#ff8575", "title": "Sisters", "sortData": "Sisters" }, "Smithfield": { "color": "#515151", "title": "Smithfield", "sortData": "Smithfield", "inResultset": true }, "Soledad": { "color": "#00d6ba", "title": "Soledad", "sortData": "Soledad" }, "Solvang": { "color": "#85c1eb", "title": "Solvang", "sortData": "Solvang" }, "SONOMA": { "color": "#ffb655", "title": "SONOMA", "sortData": "SONOMA" }, "Sonoma": { "color": "#ff8575", "title": "Sonoma", "sortData": "Sonoma" }, "Soquel": { "color": "#515151", "title": "Soquel", "sortData": "Soquel", "inResultset": true }, "Soquel ": { "color": "#00d6ba", "title": "Soquel ", "sortData": "Soquel " }, "South San Francisco": { "color": "#85c1eb", "title": "South San Francisco", "sortData": "South San Francisco" }, "Spreckels": { "color": "#ffb655", "title": "Spreckels", "sortData": "Spreckels" }, "Spreckels ": { "color": "#ff8575", "title": "Spreckels ", "sortData": "Spreckels " }, "Spring Branch": { "color": "#515151", "title": "Spring Branch", "sortData": "Spring Branch" }, "Spring City": { "color": "#00d6ba", "title": "Spring City", "sortData": "Spring City" }, "Stanford": { "color": "#85c1eb", "title": "Stanford", "sortData": "Stanford", "inResultset": true }, "Stayton": { "color": "#ffb655", "title": "Stayton", "sortData": "Stayton" }, "Stockton": { "color": "#ff8575", "title": "Stockton", "sortData": "Stockton" }, "Studio City": { "color": "#515151", "title": "Studio City", "sortData": "Studio City" }, "Sun City ": { "color": "#00d6ba", "title": "Sun City ", "sortData": "Sun City " }, "Sunnyvale": { "color": "#85c1eb", "title": "Sunnyvale", "sortData": "Sunnyvale", "inResultset": true }, "Sunnyvale ": { "color": "#ffb655", "title": "Sunnyvale ", "sortData": "Sunnyvale " }, "Tacoma": { "color": "#ff8575", "title": "Tacoma", "sortData": "Tacoma", "inResultset": true }, "Tallahassee": { "color": "#515151", "title": "Tallahassee", "sortData": "Tallahassee" }, "Tampa": { "color": "#00d6ba", "title": "Tampa", "sortData": "Tampa" }, "Tarzana": { "color": "#85c1eb", "title": "Tarzana", "sortData": "Tarzana" }, "Templeton": { "color": "#ffb655", "title": "Templeton", "sortData": "Templeton" }, "Tenafly": { "color": "#ff8575", "title": "Tenafly", "sortData": "Tenafly" }, "Three Rivers": { "color": "#515151", "title": "Three Rivers", "sortData": "Three Rivers", "inResultset": true }, "Tiburon": { "color": "#00d6ba", "title": "Tiburon", "sortData": "Tiburon" }, "Toronto": { "color": "#85c1eb", "title": "Toronto", "sortData": "Toronto", "inResultset": true }, "Tres Pinos": { "color": "#ffb655", "title": "Tres Pinos", "sortData": "Tres Pinos" }, "trinidad": { "color": "#ff8575", "title": "trinidad", "sortData": "trinidad", "inResultset": true }, "Truckee ": { "color": "#515151", "title": "Truckee ", "sortData": "Truckee " }, "Tucson ": { "color": "#00d6ba", "title": "Tucson ", "sortData": "Tucson ", "inResultset": true }, "Turlock": { "color": "#85c1eb", "title": "Turlock", "sortData": "Turlock" }, "Union City": { "color": "#ffb655", "title": "Union City", "sortData": "Union City" }, "Urbandale": { "color": "#ff8575", "title": "Urbandale", "sortData": "Urbandale" }, "Vacaville": { "color": "#515151", "title": "Vacaville", "sortData": "Vacaville" }, "Vacaville ": { "color": "#00d6ba", "title": "Vacaville ", "sortData": "Vacaville " }, "Vallejo": { "color": "#85c1eb", "title": "Vallejo", "sortData": "Vallejo" }, "Vallejo ": { "color": "#ffb655", "title": "Vallejo ", "sortData": "Vallejo " }, "Vista": { "color": "#ff8575", "title": "Vista", "sortData": "Vista", "inResultset": true }, "Walnut Creek": { "color": "#515151", "title": "Walnut Creek", "sortData": "Walnut Creek" }, "WATSONVILLE": { "color": "#00d6ba", "title": "WATSONVILLE", "sortData": "WATSONVILLE" }, "Watsonville": { "color": "#85c1eb", "title": "Watsonville", "sortData": "Watsonville", "inResultset": true }, "Watsonville ": { "color": "#ffb655", "title": "Watsonville ", "sortData": "Watsonville " }, "Wellesley Hills": { "color": "#ff8575", "title": "Wellesley Hills", "sortData": "Wellesley Hills" }, "Wellington": { "color": "#515151", "title": "Wellington", "sortData": "Wellington" }, "West Jordan ": { "color": "#00d6ba", "title": "West Jordan ", "sortData": "West Jordan " }, "West Park": { "color": "#85c1eb", "title": "West Park", "sortData": "West Park" }, "Wheatland": { "color": "#ffb655", "title": "Wheatland", "sortData": "Wheatland" }, "Wheaton": { "color": "#ff8575", "title": "Wheaton", "sortData": "Wheaton" }, "White Bear Lake": { "color": "#515151", "title": "White Bear Lake", "sortData": "White Bear Lake" }, "Woodside": { "color": "#00d6ba", "title": "Woodside", "sortData": "Woodside" }, "Yuba City ": { "color": "#85c1eb", "title": "Yuba City ", "sortData": "Yuba City " } } } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "filters", "items": [] } ] }, "type": "chart/pie", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": false, "position": "left" }, "labels": { "enabled": true, "categories": true, "value": false, "percent": true, "decimals": false }, "dataLimits": { "seriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "primary_address_city", "title": "Primary Address City", "singular": "Primary Address City", "plural": "Primary Address City" } ] } }, "instanceid": "AB1D8-A771-DF", "queryStartTime": "2019-09-25T16:50:25", "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "dashboardid": "5d8bfc1205de7d1d006d81fd", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true }, "drawing": true }, { "title": "Ticket Counts by Zone per Production", "subtype": "bar/stacked", "oid": "5d8d074505de7d1d006e15c7", "desc": null, "source": null, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[PERFORMANCE DETAIL.Production Season]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "field": { "id": "[PERFORMANCE DETAIL.Production Season]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#A3D6AC", "type": "color" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 1 }, "disabled": true }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "break by", "items": [ { "jaql": { "table": "ZONE", "column": "Zone", "dim": "[ZONE.Zone]", "datatype": "text", "merged": true, "title": "Zone" }, "format": { "members": { "Bronze Front Center": { "color": "#A3D6AC", "title": "Bronze Front Center", "sortData": "Bronze Front Center" }, "Bronze Front Sides": { "color": "#DFE47B", "title": "Bronze Front Sides", "sortData": "Bronze Front Sides" }, "Savers Front Sides": { "color": "#99C75C", "title": "Savers Front Sides", "sortData": "Savers Front Sides" }, "Sec 2 Front Sides": { "color": "#359575", "title": "Sec 2 Front Sides", "sortData": "Sec 2 Front Sides" }, "Sec 3 Front Sides": { "color": "#008066", "title": "Sec 3 Front Sides", "sortData": "Sec 3 Front Sides" }, "Sec 3 Rear Sides": { "color": "#4189A5", "title": "Sec 3 Rear Sides", "sortData": "Sec 3 Rear Sides" }, "Silver Front Sides": { "color": "#76BDD0", "title": "Silver Front Sides", "sortData": "Silver Front Sides" }, "Gold Front Center": { "color": "#A1CFD5", "title": "Gold Front Center", "sortData": "Gold Front Center" }, "Sec 2 Rear Center": { "color": "#889BA3", "title": "Sec 2 Rear Center", "sortData": "Sec 2 Rear Center" }, "Silver Front Center": { "color": "#EE6F5C", "title": "Silver Front Center", "sortData": "Silver Front Center" }, "Table Seats": { "color": "#EE995C", "title": "Table Seats", "sortData": "Table Seats" }, "Bronze Balcony": { "color": "#EED75C", "title": "Bronze Balcony", "sortData": "Bronze Balcony" }, "Bronze Loge": { "color": "#B9D7B6", "title": "Bronze Loge", "sortData": "Bronze Loge" }, "Sec 2 Balcony": { "color": "#bbf6c6", "title": "Sec 2 Balcony", "sortData": "Sec 2 Balcony" }, "Premium": { "color": "#faff8e", "title": "Premium", "sortData": "Premium" }, "Regular": { "color": "#693b83", "title": "Regular", "sortData": "Regular", "inResultset": true }, "Level 1": { "color": "#693B83", "title": "Level 1", "sortData": "Level 1", "inResultset": true }, "Level 2": { "color": "#BB8A44", "title": "Level 2", "sortData": "Level 2", "inResultset": true }, "Level 3": { "color": "#9FB541", "title": "Level 3", "sortData": "Level 3", "inResultset": true }, "Priority General Admission": { "color": "#88d9ef", "title": "Priority General Admission", "sortData": "Priority General Admission" }, "Regular General Admission": { "color": "#b9eef5", "title": "Regular General Admission", "sortData": "Regular General Admission" }, "VIP with Reception": { "color": "#9cb2bb", "title": "VIP with Reception", "sortData": "VIP with Reception", "inResultset": true }, "VIP": { "color": "#ff816e", "title": "VIP", "sortData": "VIP" }, "General Admission": { "color": "#ffaa6e", "title": "General Admission", "sortData": "General Admission" }, "Priority GA": { "color": "#3dab87", "title": "Priority GA", "sortData": "Priority GA", "inResultset": true }, "Regular GA": { "color": "#395365", "title": "Regular GA", "sortData": "Regular GA", "inResultset": true }, "GA FT House": { "color": "#c8ffd2", "title": "GA FT House", "sortData": "GA FT House" }, "GALA": { "color": "#faff99", "title": "GALA", "sortData": "GALA" }, "Sugar Plum": { "color": "#bdf672", "title": "Sugar Plum", "sortData": "Sugar Plum" }, "GA House": { "color": "#41b890", "title": "GA House", "sortData": "GA House" }, "GA": { "color": "#009e7e", "title": "GA", "sortData": "GA" }, "Big Island Bash": { "color": "#50a9cc", "title": "Big Island Bash", "sortData": "Big Island Bash" }, "Concert Ticket Experience": { "color": "#92e8ff", "title": "Concert Ticket Experience", "sortData": "Concert Ticket Experience" }, "Maui Mixer": { "color": "#c6f8ff", "title": "Maui Mixer", "sortData": "Maui Mixer" }, "Level I": { "color": "#a8bfc9", "title": "Level I", "sortData": "Level I" }, "Level II": { "color": "#ff8b7a", "title": "Level II", "sortData": "Level II" }, "Level 1 General Admission": { "color": "#953224", "title": "Level 1 General Admission", "sortData": "Level 1 General Admission", "inResultset": true }, "Level 2 General Admission": { "color": "#ff6752", "title": "Level 2 General Admission", "sortData": "Level 2 General Admission", "inResultset": true }, "VIP Reception @ 6:30PM": { "color": "#e1ffde", "title": "VIP Reception @ 6:30PM", "sortData": "VIP Reception @ 6:30PM" }, "Gala": { "color": "#00ccb1", "title": "Gala", "sortData": "Gala" }, "Dance Floor(Standing Only)": { "color": "#81bce4", "title": "Dance Floor(Standing Only)", "sortData": "Dance Floor(Standing Only)" } } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Year", "dim": "[PERFORMANCE DATE.Fiscal Year]", "datatype": "numeric", "title": "Fiscal Year", "filter": { "explicit": true, "multiSelection": "true", "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "SUNS-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSUNSLQAaSeatsIAAaandIAAaTickets" } } } ] } ] }, "type": "chart/bar", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": false, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" }, { "id": "zone", "title": "Zone", "singular": "Zone", "plural": "Zone" }, { "id": "fiscal_year", "title": "Fiscal Year", "singular": "Fiscal Year", "plural": "Fiscal Year" } ] } }, "instanceid": "D23EE-31C9-C0", "queryStartTime": "2019-09-26T14:13:43", "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null }, "selectorLocked": false }, "dashboardid": "5d8bfc1205de7d1d006d81fd", "drawing": true, "viewState": { "activeTab": "filters" }, "canEditFilters": true } ], "hierarchies": [] }