Join_Features_Test1
None
nan
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'actualType': 'int', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeInteger', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'GEOID10', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'GEOID10', 'sqlType': 'sqlTypeNVarchar', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CTBG10', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'CTBG10', 'sqlType': 'sqlTypeNVarchar', 'length': 7, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CT10', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'CT10', 'sqlType': 'sqlTypeNVarchar', 'length': 6, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'AreaSqMil', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'AreaSqMil', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'LABEL', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'LABEL', 'sqlType': 'sqlTypeNVarchar', 'length': 4, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FIP10', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'FIP10', 'sqlType': 'sqlTypeNVarchar', 'length': 5, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FIP10RV', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'FIP10RV', 'sqlType': 'sqlTypeNVarchar', 'length': 5, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CDP_NAME', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'CDP_NAME', 'sqlType': 'sqlTypeNVarchar', 'length': 30, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CITYNAME', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'CITYNAME', 'sqlType': 'sqlTypeNVarchar', 'length': 30, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'COMMNAME', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'COMMNAME', 'sqlType': 'sqlTypeNVarchar', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Accommodation_and_Food_Services', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Accommodation and Food Services', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Administrative_and_Support_and_', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Administrative and Support and Waste Management and Remediation Services', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Agriculture__Forestry__Fishing_', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Agriculture, Forestry, Fishing and Hunting', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Arts__Entertainment__and_Recrea', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Arts, Entertainment, and Recreation', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Construction', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Construction', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Educational_Services', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Educational Services', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Finance_and_Insurance', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Finance and Insurance', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Health_Care_and_Social_Assistan', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Health Care and Social Assistance', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Information', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Information', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Manufacturing', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Manufacturing', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Medical_Marijuana_Collective', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Medical Marijuana Collective', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Mining', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Mining', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Not_Classified', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Not Classified', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Other_Services__except_Public_A', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Other Services (except Public Administration)', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Professional__Scientific__and_T', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Professional, Scientific, and Technical Services', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Real_Estate_Rental_and_Leasing', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Real Estate Rental and Leasing', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Retail_Trade', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Retail Trade', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Transportation_and_Warehousing', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Transportation and Warehousing', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Utilities', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Utilities', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Wholesale_Trade', 'type': 'esriFieldTypeDouble', 'actualType': 'decimal', 'alias': 'Wholesale Trade', 'sqlType': 'sqlTypeDecimal', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__JA28BFBE__F4B70D854D81F77C', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'USER_30549.JA28BFBE8D0734211A4FFC21CA2A02C54_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}, {'name': 'undefined_Index', 'fields': '', 'isAscending': False, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'Accommodation_and_Food_Services_Index', 'fields': 'Accommodation_and_Food_Services', 'isAscending': True, 'isUnique': False, 'description': 'Accommodation_and_Food_Services_Index', 'indexType': 'Attribute'}, {'name': 'Administrative_and_Support_and__Index', 'fields': 'Administrative_and_Support_and_', 'isAscending': True, 'isUnique': False, 'description': 'Administrative_and_Support_and__Index', 'indexType': 'Attribute'}, {'name': 'Arts__Entertainment__and_Recrea_Index', 'fields': 'Arts__Entertainment__and_Recrea', 'isAscending': True, 'isUnique': False, 'description': 'Arts__Entertainment__and_Recrea_Index', 'indexType': 'Attribute'}, {'name': 'Construction_Index', 'fields': 'Construction', 'isAscending': True, 'isUnique': False, 'description': 'Construction_Index', 'indexType': 'Attribute'}, {'name': 'Agriculture__Forestry__Fishing__Index', 'fields': 'Agriculture__Forestry__Fishing_', 'isAscending': True, 'isUnique': False, 'description': 'Agriculture__Forestry__Fishing__Index', 'indexType': 'Attribute'}, {'name': 'Manufacturing_Index', 'fields': 'Manufacturing', 'isAscending': True, 'isUnique': False, 'description': 'Manufacturing_Index', 'indexType': 'Attribute'}, {'name': 'Professional__Scientific__and_T_Index', 'fields': 'Professional__Scientific__and_T', 'isAscending': True, 'isUnique': False, 'description': 'Professional__Scientific__and_T_Index', 'indexType': 'Attribute'}, {'name': 'Health_Care_and_Social_Assistan_Index', 'fields': 'Health_Care_and_Social_Assistan', 'isAscending': True, 'isUnique': False, 'description': 'Health_Care_and_Social_Assistan_Index', 'indexType': 'Attribute'}, {'name': 'Real_Estate_Rental_and_Leasing_Index', 'fields': 'Real_Estate_Rental_and_Leasing', 'isAscending': True, 'isUnique': False, 'description': 'Real_Estate_Rental_and_Leasing_Index', 'indexType': 'Attribute'}, {'name': 'Retail_Trade_Index', 'fields': 'Retail_Trade', 'isAscending': True, 'isUnique': False, 'description': 'Retail_Trade_Index', 'indexType': 'Attribute'}, {'name': 'Other_Services__except_Public_A_Index', 'fields': 'Other_Services__except_Public_A', 'isAscending': True, 'isUnique': False, 'description': 'Other_Services__except_Public_A_Index', 'indexType': 'Attribute'}, {'name': 'Medical_Marijuana_Collective_Index', 'fields': 'Medical_Marijuana_Collective', 'isAscending': True, 'isUnique': False, 'description': 'Medical_Marijuana_Collective_Index', 'indexType': 'Attribute'}, {'name': 'Educational_Services_Index', 'fields': 'Educational_Services', 'isAscending': True, 'isUnique': False, 'description': 'Educational_Services_Index', 'indexType': 'Attribute'}]
nan
{'renderer': {'authoringInfo': {'visualVariables': [{'type': 'transparencyInfo', 'minSliderValue': 0, 'maxSliderValue': 4274}]}, 'type': 'uniqueValue', 'field1': None, 'valueExpression': '// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\nvar Accomodation = $feature["Accommodation_and_Food_Services"];\nvar AdministrativeSupport = $feature["Administrative_and_Support_and_"];\nvar Agriculture = $feature["Agriculture__Forestry__Fishing_"];\nvar Arts = $feature["Arts__Entertainment__and_Recrea"];\nvar Construction = $feature.Construction;\nvar Finance = $feature["Finance_and_Insurance"];\nvar Information = $feature.Information;\nvar Manufacturing = $feature.Manufacturing;\nvar Mining = $feature.Mining;\nvar RealEstate = $feature["Real_Estate_Rental_and_Leasing"];\nvar Retail = $feature["Retail_Trade"];\nvar Utilities = $feature.Utilities;\nvar EducaitonalServices = $feature["Educational_Services"];\nvar HealthCare = $feature["Health_Care_and_Social_Assistan"];\nvar MedMarijuana = $feature["Medical_Marijuana_Collective"];\nvar Transportation = $feature["Transportation_and_Warehousing"];\nvar Wholesale = $feature["Wholesale_Trade"];\nvar businesses = [Accomodation, AdministrativeSupport, Agriculture,\nArts, Construction, Finance, Information, Manufacturing, Mining, RealEstate,\nRetail, Utilities, EducaitonalServices, HealthCare, MedMarijuana,\n Transportation, Wholesale];\n\n      // Match the maximum value with the label\n      // of the respective field and return it for\n      // use in a UniqueValueRenderer\n\n      return Decode( Max(businesses),\n        Accomodation, \'Accomodation\',\n        AdministrativeSupport, \'AdministrativeSupport\',\n        Agriculture, \'Agriculture\',\n        Arts, \'Arts\',\n        Construction, \'Construction\',\n        Finance, \'Finance\',\n        Information, \'Information\',\n        Manufacturing, \'Manufacturing\',\n        Mining, \'Mining\',\n        RealEstate, \'RealEstate\',\n        Retail, \'Retail\',\n        Utilities, \'Utilities\',\n        EducaitonalServices, \'EducaitonalServices\',\n        HealthCare, \'HealthCare\',\n        MedMarijuana, \'MedMarijuana\',\n        Transportation, \'Transportation\',\n        Wholesale, \'Wholesale\',\n        \'n/a\')\n', 'valueExpressionTitle': 'Predominant Category', 'defaultSymbol': {'color': [170, 170, 170, 255], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'defaultLabel': 'Other', 'uniqueValueInfos': [{'value': 'RealEstate', 'symbol': {'color': [237, 81, 81, 255], 'outline': {'color': [212, 72, 72, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'RealEstate'}, {'value': 'Retail', 'symbol': {'color': [48, 252, 205, 255], 'outline': {'color': [43, 227, 184, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Retail'}, {'value': 'Construction', 'symbol': {'color': [167, 198, 54, 255], 'outline': {'color': [146, 173, 47, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Construction'}, {'value': 'AdministrativeSupport', 'symbol': {'color': [158, 85, 156, 255], 'outline': {'color': [133, 72, 131, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'AdministrativeSupport'}, {'value': 'Arts', 'symbol': {'color': [252, 146, 31, 255], 'outline': {'color': [227, 130, 27, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Arts'}, {'value': 'Accomodation', 'symbol': {'color': [255, 222, 62, 255], 'outline': {'color': [230, 201, 55, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Accomodation'}, {'value': 'HealthCare', 'symbol': {'color': [247, 137, 216, 255], 'outline': {'color': [222, 122, 194, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'HealthCare'}, {'value': 'Wholesale', 'symbol': {'color': [183, 129, 74, 255], 'outline': {'color': [158, 110, 63, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Wholesale'}, {'value': 'Manufacturing', 'symbol': {'color': [60, 175, 153, 255], 'outline': {'color': [51, 150, 132, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Manufacturing'}, {'value': 'Finance', 'symbol': {'color': [107, 107, 214, 255], 'outline': {'color': [94, 94, 189, 255], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}, 'label': 'Finance'}], 'backgroundFillSymbol': {'color': [0, 0, 0, 0], 'outline': {'color': [153, 153, 153, 64], 'width': 0.75, 'type': 'esriSLS', 'style': 'esriSLSSolid'}, 'type': 'esriSFS', 'style': 'esriSFSSolid'}}, 'transparency': 13}
[]
[{'name': 'New Feature', 'description': '', 'drawingTool': 'esriFeatureEditToolNone', 'prototype': {'attributes': {'GEOID10': None, 'CTBG10': None, 'CT10': None, 'AreaSqMil': None, 'LABEL': None, 'FIP10': None, 'FIP10RV': None, 'CDP_NAME': None, 'CITYNAME': None, 'COMMNAME': None, 'Accommodation_and_Food_Services': None, 'Administrative_and_Support_and_': None, 'Agriculture__Forestry__Fishing_': None, 'Arts__Entertainment__and_Recrea': None, 'Construction': None, 'Educational_Services': None, 'Finance_and_Insurance': None, 'Health_Care_and_Social_Assistan': None, 'Information': None, 'Manufacturing': None, 'Medical_Marijuana_Collective': None, 'Mining': None, 'Not_Classified': None, 'Other_Services__except_Public_A': None, 'Professional__Scientific__and_T': None, 'Real_Estate_Rental_and_Leasing': None, 'Retail_Trade': None, 'Transportation_and_Warehousing': None, 'Utilities': None, 'Wholesale_Trade': None}}}]