Name: ALL_Comparison_18to20
Display Field: NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: Data free to the public from https://www.ttb.gov/beer/statistics
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -179.148911757534
YMin: -14.5487090464525
XMax: 179.778483529987
YMax: 71.3651708117125
Spatial Reference: 4269 (4269)
Drawing Info:
{"renderer":{"authoringInfo":{"field1":{"field":"ALL2020","label":"2020 All Beer","classBreakInfos":[{"minValue":0,"maxValue":36418.710000000006},{"minValue":36418.710000000006,"maxValue":1223176.2899999998},{"minValue":1223176.2899999998,"maxValue":19104818.73}]},"field2":{"field":"ALL18to20","label":"Relative Change 2018 to 2020","classBreakInfos":[{"minValue":-3340708.1799999997,"maxValue":-16287.18},{"minValue":-16287.18,"maxValue":113.10999999999967},{"minValue":113.10999999999967,"maxValue":2847988.44}]},"classificationMethod":"esriClassifyQuantile","type":"relationship","numClasses":3},"type":"uniqueValue","fieldDelimiter":",","valueExpression":"var field1 = $feature['ALL2020'];\nvar field2 = $feature['ALL18to20'];\nvar hasNormField1 = false;\nvar hasNormField2 = false;\nvar normField1 = null;\nvar normField2 = null;\nif (\n IsEmpty(field1) || \n IsEmpty(field2) ||\n (hasNormField1 && (IsEmpty(normField1) || normField1 == 0)) ||\n (hasNormField2 && (IsEmpty(normField2) || normField2 == 0))\n) {\n return null; \n}\nvar value1 = IIf(hasNormField1, (field1 / normField1), field1);\nvar value2 = IIf(hasNormField2, (field2 / normField2), field2);\nvar breaks1 = [[0,36418.7100000000064028427],[36418.7100010000067413785,1223176.28999999980442226],[1223176.29000099981203675,19104818.7300000004470348]];\nvar breaks2 = [[-3340708.17999999970197678,-16287.1800000000002910383],[-16287.1799989999999525025,113.109999999999672581907],[113.11000099999967005715,2847988.43999999994412065]];\nvar classCodes = [\"L\", \"M\", \"H\"];\nfunction getClassCode(value, breaks) {\n var code = null;\n for (var i in breaks) {\n var info = breaks[i];\n if (value >= info[0] && value <= info[1]) {\n code = classCodes[i];\n break;\n }\n }\n return code;\n}\nvar code1 = getClassCode(value1, breaks1);\nvar code2 = getClassCode(value2, breaks2);\nvar classValue = IIf(IsEmpty(code1) || IsEmpty(code2), null, code1 + code2);\nreturn classValue;","valueExpressionTitle":"Relationship","uniqueValueInfos":[{"symbol":{"color":[128,77,54,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"HH","label":"High raw volume, most intense increase in production"},{"symbol":{"color":[151,107,130,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"HM","label":"High - Medium"},{"symbol":{"color":[153,114,175,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"HL","label":"High raw volume, most intense decrease in production"},{"symbol":{"color":[175,142,83,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"MH","label":"Medium - High"},{"symbol":{"color":[200,173,160,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"MM","label":"Medium - Medium"},{"symbol":{"color":[203,184,215,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"ML","label":"Medium - Low"},{"symbol":{"color":[200,179,90,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"LH","label":"Low raw volume, most intense increase in production"},{"symbol":{"color":[228,217,172,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"LM","label":"Low - Medium"},{"symbol":{"color":[232,232,232,255],"outline":{"color":[115,76,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"value":"LL","label":"Low raw volume, most intense decrease in production"}]},"transparency":18}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- STATEFP (type: esriFieldTypeString, alias: STATEFP, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- STATENS (type: esriFieldTypeString, alias: STATENS, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AFFGEOID (type: esriFieldTypeString, alias: AFFGEOID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
- GEOID (type: esriFieldTypeString, alias: GEOID, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- STUSPS (type: esriFieldTypeString, alias: STUSPS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- LSAD (type: esriFieldTypeString, alias: LSAD, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- ALAND (type: esriFieldTypeDouble, alias: ALAND, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AWATER (type: esriFieldTypeDouble, alias: AWATER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2008_BRLS (type: esriFieldTypeDouble, alias: F2008_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2009_BRLS (type: esriFieldTypeDouble, alias: F2009_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2010__BRLS (type: esriFieldTypeDouble, alias: F2010__BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2011_BRLS (type: esriFieldTypeDouble, alias: F2011_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2012__BRLS (type: esriFieldTypeDouble, alias: F2012__BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2013__BRLS (type: esriFieldTypeDouble, alias: F2013__BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2014_BRLS (type: esriFieldTypeDouble, alias: F2014_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2015__BRLS (type: esriFieldTypeDouble, alias: F2015__BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2016___BRL (type: esriFieldTypeDouble, alias: F2016___BRL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2017___BRL (type: esriFieldTypeDouble, alias: F2017___BRL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2018_BRLS (type: esriFieldTypeDouble, alias: F2018_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2019__BRLS (type: esriFieldTypeDouble, alias: F2019__BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2020___BRL (type: esriFieldTypeDouble, alias: F2020___BRL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2008_PKG (type: esriFieldTypeDouble, alias: F2008_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2009_PKG (type: esriFieldTypeDouble, alias: F2009_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2010_PKG (type: esriFieldTypeDouble, alias: F2010_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2011_PKG (type: esriFieldTypeDouble, alias: F2011_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2012_PKG (type: esriFieldTypeDouble, alias: F2012_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2013_PKG (type: esriFieldTypeDouble, alias: F2013_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2014_PKG (type: esriFieldTypeDouble, alias: F2014_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2015_PKG (type: esriFieldTypeDouble, alias: F2015_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2016_PKG (type: esriFieldTypeDouble, alias: F2016_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2017_PKG (type: esriFieldTypeDouble, alias: F2017_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2018_PKG (type: esriFieldTypeDouble, alias: F2018_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2019_PKG (type: esriFieldTypeDouble, alias: F2019_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2020_PKG (type: esriFieldTypeDouble, alias: F2020_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BRLS18to20 (type: esriFieldTypeInteger, alias: BRLS18to20, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PKG18to20 (type: esriFieldTypeInteger, alias: PKG18to20, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STUSPS_1 (type: esriFieldTypeString, alias: STUSPS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- F2008_BRLS_1 (type: esriFieldTypeDouble, alias: 2008_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2009_BRLS_1 (type: esriFieldTypeDouble, alias: 2009_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2010__BRLS_1 (type: esriFieldTypeDouble, alias: 2010_ BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2011_BRLS_1 (type: esriFieldTypeDouble, alias: 2011_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2012__BRLS_1 (type: esriFieldTypeDouble, alias: 2012 _BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2013__BRLS_1 (type: esriFieldTypeDouble, alias: 2013_ BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2014_BRLS_1 (type: esriFieldTypeDouble, alias: 2014_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2015__BRLS_1 (type: esriFieldTypeDouble, alias: 2015 _BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2016___BRLS (type: esriFieldTypeDouble, alias: 2016 _ BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2017___BRLS (type: esriFieldTypeDouble, alias: 2017 _ BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2018_BRLS_1 (type: esriFieldTypeDouble, alias: 2018_BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2019__BRLS_1 (type: esriFieldTypeDouble, alias: 2019 _BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2020___BRLS (type: esriFieldTypeDouble, alias: 2020 _ BRLS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STUSPS_12 (type: esriFieldTypeString, alias: STUSPS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- F2008_PKG_1 (type: esriFieldTypeDouble, alias: 2008_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2009_PKG_1 (type: esriFieldTypeDouble, alias: 2009_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2010_PKG_1 (type: esriFieldTypeDouble, alias: 2010_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2011_PKG_1 (type: esriFieldTypeDouble, alias: 2011_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2012_PKG_1 (type: esriFieldTypeDouble, alias: 2012_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2013_PKG_1 (type: esriFieldTypeDouble, alias: 2013_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2014_PKG_1 (type: esriFieldTypeDouble, alias: 2014_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2015_PKG_1 (type: esriFieldTypeDouble, alias: 2015_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2016_PKG_1 (type: esriFieldTypeDouble, alias: 2016_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2017_PKG_1 (type: esriFieldTypeDouble, alias: 2017_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2018_PKG_1 (type: esriFieldTypeDouble, alias: 2018_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2019_PKG_1 (type: esriFieldTypeDouble, alias: 2019_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- F2020_PKG_1 (type: esriFieldTypeDouble, alias: 2020_PKG, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ALL2020 (type: esriFieldTypeDouble, alias: ALL2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ALL2018 (type: esriFieldTypeDouble, alias: ALL2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ALL18to20 (type: esriFieldTypeDouble, alias: ALL18to20, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/27/2021 10:31:58 PM
Schema Last Edit Date: 5/27/2021 10:31:58 PM
Data Last Edit Date: 5/27/2021 10:31:58 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat