{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 24, "name": "Chemical Inventory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ChemicalName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RecordId", "type": "esriFieldTypeString", "alias": "RecordId", "length": 1073741822, "domain": null }, { "name": "ParentRecordId", "type": "esriFieldTypeString", "alias": "ParentRecordId", "length": 1073741822, "domain": null }, { "name": "CasNumber", "type": "esriFieldTypeInteger", "alias": "CasNumber", "domain": null }, { "name": "Ehs", "type": "esriFieldTypeString", "alias": "Ehs", "length": 1073741822, "domain": null }, { "name": "ChemicalName", "type": "esriFieldTypeString", "alias": "ChemicalName", "length": 1073741822, "domain": null }, { "name": "TradeSecret", "type": "esriFieldTypeString", "alias": "TradeSecret", "length": 1073741822, "domain": null }, { "name": "SDS", "type": "esriFieldTypeString", "alias": "SDS", "length": 1073741822, "domain": null }, { "name": "Pure", "type": "esriFieldTypeString", "alias": "Pure", "length": 1073741822, "domain": null }, { "name": "Mixture", "type": "esriFieldTypeString", "alias": "Mixture", "length": 1073741822, "domain": null }, { "name": "Solid", "type": "esriFieldTypeString", "alias": "Solid", "length": 1073741822, "domain": null }, { "name": "Liquid", "type": "esriFieldTypeString", "alias": "Liquid", "length": 1073741822, "domain": null }, { "name": "Gas", "type": "esriFieldTypeString", "alias": "Gas", "length": 1073741822, "domain": null }, { "name": "MaxDailyAmount", "type": "esriFieldTypeInteger", "alias": "MaxDailyAmount", "domain": null }, { "name": "MaxDailyAmountCode", "type": "esriFieldTypeInteger", "alias": "MaxDailyAmountCode", "domain": null }, { "name": "AveDailyAmount", "type": "esriFieldTypeInteger", "alias": "AveDailyAmount", "domain": null }, { "name": "AveDailyAmountCode", "type": "esriFieldTypeInteger", "alias": "AveDailyAmountCode", "domain": null }, { "name": "MaxAmountLargestContainer", "type": "esriFieldTypeDouble", "alias": "MaxAmountLargestContainer", "domain": null }, { "name": "BelowReportingThresholds", "type": "esriFieldTypeString", "alias": "BelowReportingThresholds", "length": 1073741822, "domain": null }, { "name": "ConfidentialStorageLocations", "type": "esriFieldTypeString", "alias": "ConfidentialStorageLocations", "length": 1073741822, "domain": null }, { "name": "SameAsLastYear", "type": "esriFieldTypeString", "alias": "SameAsLastYear", "length": 1073741822, "domain": null }, { "name": "DaysOnSite", "type": "esriFieldTypeInteger", "alias": "DaysOnSite", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1073741822, "domain": null }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "HazardExplosive", "type": "esriFieldTypeString", "alias": "HazardExplosive", "length": 1073741822, "domain": null }, { "name": "HazardFlammable", "type": "esriFieldTypeString", "alias": "HazardFlammable", "length": 1073741822, "domain": null }, { "name": "HazardOxidizer", "type": "esriFieldTypeString", "alias": "HazardOxidizer", "length": 1073741822, "domain": null }, { "name": "HazardSelfReactive", "type": "esriFieldTypeString", "alias": "HazardSelfReactive", "length": 1073741822, "domain": null }, { "name": "HazardPyrophoricLiquidOrSolid", "type": "esriFieldTypeString", "alias": "HazardPyrophoricLiquidOrSolid", "length": 1073741822, "domain": null }, { "name": "HazardPyrophoricGas", "type": "esriFieldTypeString", "alias": "HazardPyrophoricGas", "length": 1073741822, "domain": null }, { "name": "HazardSelfHeating", "type": "esriFieldTypeString", "alias": "HazardSelfHeating", "length": 1073741822, "domain": null }, { "name": "HazardOrganicPeroxide", "type": "esriFieldTypeString", "alias": "HazardOrganicPeroxide", "length": 1073741822, "domain": null }, { "name": "HazardCorrosiveToMetal", "type": "esriFieldTypeString", "alias": "HazardCorrosiveToMetal", "length": 1073741822, "domain": null }, { "name": "HazardCompressedGas", "type": "esriFieldTypeString", "alias": "HazardCompressedGas", "length": 1073741822, "domain": null }, { "name": "HazardWaterContactEmitsFlammabl", "type": "esriFieldTypeString", "alias": "HazardWaterContactEmitsFlammableGas", "length": 1073741822, "domain": null }, { "name": "HazardCombustibleDust", "type": "esriFieldTypeString", "alias": "HazardCombustibleDust", "length": 1073741822, "domain": null }, { "name": "HazardAcuteToxicity", "type": "esriFieldTypeString", "alias": "HazardAcuteToxicity", "length": 1073741822, "domain": null }, { "name": "HazardSkinCorrosionOrIrritation", "type": "esriFieldTypeString", "alias": "HazardSkinCorrosionOrIrritation", "length": 1073741822, "domain": null }, { "name": "HazardSeriousEyeDamageOrIrritat", "type": "esriFieldTypeString", "alias": "HazardSeriousEyeDamageOrIrritation", "length": 1073741822, "domain": null }, { "name": "HazardRespiratoryOrSkinSensitiz", "type": "esriFieldTypeString", "alias": "HazardRespiratoryOrSkinSensitization", "length": 1073741822, "domain": null }, { "name": "HazardGermCellMutagenicity", "type": "esriFieldTypeString", "alias": "HazardGermCellMutagenicity", "length": 1073741822, "domain": null }, { "name": "HazardCarcinogenicity", "type": "esriFieldTypeString", "alias": "HazardCarcinogenicity", "length": 1073741822, "domain": null }, { "name": "HazardReproductiveToxicity", "type": "esriFieldTypeString", "alias": "HazardReproductiveToxicity", "length": 1073741822, "domain": null }, { "name": "HazardSpecificTargetOrganToxici", "type": "esriFieldTypeString", "alias": "HazardSpecificTargetOrganToxicity", "length": 1073741822, "domain": null }, { "name": "HazardAspirationHazard", "type": "esriFieldTypeString", "alias": "HazardAspirationHazard", "length": 1073741822, "domain": null }, { "name": "HazardSimpleAsphyxiant", "type": "esriFieldTypeString", "alias": "HazardSimpleAsphyxiant", "length": 1073741822, "domain": null }, { "name": "HazardNotOtherwiseClassified", "type": "esriFieldTypeString", "alias": "HazardNotOtherwiseClassified", "length": 1073741822, "domain": null }, { "name": "HazardFire", "type": "esriFieldTypeString", "alias": "HazardFire", "length": 1073741822, "domain": null }, { "name": "HazardPressure", "type": "esriFieldTypeString", "alias": "HazardPressure", "length": 1073741822, "domain": null }, { "name": "HazardReactive", "type": "esriFieldTypeString", "alias": "HazardReactive", "length": 1073741822, "domain": null }, { "name": "HazardAcute", "type": "esriFieldTypeString", "alias": "HazardAcute", "length": 1073741822, "domain": null }, { "name": "HazardChronic", "type": "esriFieldTypeString", "alias": "HazardChronic", "length": 1073741822, "domain": null }, { "name": "State01Text", "type": "esriFieldTypeString", "alias": "State01Text", "length": 1073741822, "domain": null }, { "name": "State02Text", "type": "esriFieldTypeString", "alias": "State02Text", "length": 1073741822, "domain": null }, { "name": "State03Text", "type": "esriFieldTypeString", "alias": "State03Text", "length": 1073741822, "domain": null }, { "name": "State04Text", "type": "esriFieldTypeString", "alias": "State04Text", "length": 1073741822, "domain": null }, { "name": "State05Text", "type": "esriFieldTypeString", "alias": "State05Text", "length": 1073741822, "domain": null }, { "name": "State06Text", "type": "esriFieldTypeString", "alias": "State06Text", "length": 1073741822, "domain": null }, { "name": "State07Text", "type": "esriFieldTypeString", "alias": "State07Text", "length": 1073741822, "domain": null }, { "name": "State08Text", "type": "esriFieldTypeString", "alias": "State08Text", "length": 1073741822, "domain": null }, { "name": "State01Checkbox", "type": "esriFieldTypeString", "alias": "State01Checkbox", "length": 1073741822, "domain": null }, { "name": "State02Checkbox", "type": "esriFieldTypeString", "alias": "State02Checkbox", "length": 1073741822, "domain": null }, { "name": "State03Checkbox", "type": "esriFieldTypeString", "alias": "State03Checkbox", "length": 1073741822, "domain": null }, { "name": "State04Checkbox", "type": "esriFieldTypeString", "alias": "State04Checkbox", "length": 1073741822, "domain": null }, { "name": "State05Checkbox", "type": "esriFieldTypeString", "alias": "State05Checkbox", "length": 1073741822, "domain": null }, { "name": "State06Checkbox", "type": "esriFieldTypeString", "alias": "State06Checkbox", "length": 1073741822, "domain": null }, { "name": "State07Checkbox", "type": "esriFieldTypeString", "alias": "State07Checkbox", "length": 1073741822, "domain": null }, { "name": "State08Checkbox", "type": "esriFieldTypeString", "alias": "State08Checkbox", "length": 1073741822, "domain": null }, { "name": "State09Checkbox", "type": "esriFieldTypeString", "alias": "State09Checkbox", "length": 1073741822, "domain": null }, { "name": "State01Number", "type": "esriFieldTypeString", "alias": "State01Number", "length": 1073741822, "domain": null }, { "name": "State02Number", "type": "esriFieldTypeString", "alias": "State02Number", "length": 1073741822, "domain": null }, { "name": "State03Number", "type": "esriFieldTypeString", "alias": "State03Number", "length": 1073741822, "domain": null }, { "name": "State04Number", "type": "esriFieldTypeString", "alias": "State04Number", "length": 1073741822, "domain": null }, { "name": "State01Date", "type": "esriFieldTypeString", "alias": "State01Date", "length": 1073741822, "domain": null }, { "name": "State02Date", "type": "esriFieldTypeString", "alias": "State02Date", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R537_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "gispub.HAZARD.Facility", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentRecordId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F11D7EF2-717C-43C2-8D7A-036C955D8925}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }