Name: CommodityByCounty_WebTable

Display Field: Mine_Name

Type: Table

Description: Tabular data showing historical mineral commodity production by county and year in California.  The tabular data is part of County Commodity Production feature layer that contains a polygon layer of California counties which provides geographic reference and a table with the commodities produced by each county as the main data source. <div><div><span style="font-size:15px;"><br /></span></div><div><span style="font-size:15px;">The feature layer was created to power a dashboard. The table should be linked to the county polygons using Arcade code in a web map and from inside the dashboard. This approach allows the table to be updated as needed while maintaining a constant geometry of the mapped area.</span></div></div><div><br /></div>

Copyright Text: California Geological Survey, Mineral Resources Program. California Department of Conservation.

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Commodity_ID (type: esriFieldTypeString, alias: Commodity ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Commodity (type: esriFieldTypeString, alias: Commodity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Year (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Nearest_Town (type: esriFieldTypeString, alias: Nearest Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Operator (type: esriFieldTypeString, alias: Operator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mine_Name (type: esriFieldTypeString, alias: Mine Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CO_FIPS (type: esriFieldTypeString, alias: CO_FIPS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: CommodityByCounty_WebTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/23/2024 8:31:35 PM

Schema Last Edit Date: 5/23/2024 8:31:35 PM

Data Last Edit Date: 5/23/2024 8:31:35 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat