{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 59, "name": "RBM_FRM.DBO.FHRM_TypeIEDInstallations", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "META_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "META_ID", "type": "esriFieldTypeString", "alias": "META ID", "length": 64, "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "Country Code", "length": 3, "domain": { "type": "codedValue", "name": "ISO3166_CD", "description": "", "codedValues": [ { "name": "Albania", "code": "AL" }, { "name": "Austria", "code": "AT" }, { "name": "Bosnia and Herzegovina", "code": "BA" }, { "name": "Bulgaria", "code": "BG" }, { "name": "Croatia", "code": "HR" }, { "name": "Czech Republic", "code": "CZ" }, { "name": "Germany", "code": "DE" }, { "name": "Hungary", "code": "HU" }, { "name": "Italy", "code": "IT" }, { "name": "Moldova, Republic of", "code": "MD" }, { "name": "Montenegro", "code": "ME" }, { "name": "Poland", "code": "PL" }, { "name": "Romania", "code": "RO" }, { "name": "Serbia", "code": "RS" }, { "name": "Slovakia", "code": "SK" }, { "name": "Slovenia", "code": "SI" }, { "name": "Switzerland", "code": "CH" }, { "name": "Ukarine", "code": "UA" }, { "name": "North Macedonia", "code": "MK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BIHENTITY", "type": "esriFieldTypeString", "alias": "B&H Entity", "length": 4, "domain": { "type": "codedValue", "name": "BIHEntity", "description": "", "codedValues": [ { "name": "Federation of BIH", "code": "FBIH" }, { "name": "Republic of Srpska", "code": "RS" }, { "name": "BrĨko District", "code": "BD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RBMP_YEAR", "type": "esriFieldTypeInteger", "alias": "RBMP Year", "domain": { "type": "codedValue", "name": "RBMP_Year", "description": "", "codedValues": [ { "name": "RBMP 2016-2021.", "code": 2015 }, { "name": "RBMP 2022-2027.", "code": 2021 }, { "name": "RBMP 2028-2033.", "code": 2027 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRMP_YEAR", "type": "esriFieldTypeInteger", "alias": "FRMP Year", "domain": { "type": "codedValue", "name": "FRMP_Year", "description": "", "codedValues": [ { "name": "FRMP 2022-2027.", "code": 2021 }, { "name": "FRMP 2028-2033.", "code": 2027 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WORK_STAT", "type": "esriFieldTypeInteger", "alias": "Working Status", "domain": { "type": "codedValue", "name": "WorkStatus", "description": "", "codedValues": [ { "name": "Active", "code": 0 }, { "name": "Working", "code": 1 }, { "name": "Passive", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACT_STAT", "type": "esriFieldTypeInteger", "alias": "Active Status", "domain": null }, { "name": "DATA_DATE", "type": "esriFieldTypeDate", "alias": "Date of data", "length": 8, "domain": null }, { "name": "INS_WHEN", "type": "esriFieldTypeDate", "alias": "Insert date", "length": 8, "domain": null }, { "name": "INS_BY", "type": "esriFieldTypeString", "alias": "Inserted by", "length": 30, "domain": null }, { "name": "IEDI_TYP_ID", "type": "esriFieldTypeDouble", "alias": "Row ID", "domain": null }, { "name": "IED_INST_ID", "type": "esriFieldTypeDouble", "alias": "IED Installations ID", "domain": null }, { "name": "TypeIEDInstallation", "type": "esriFieldTypeString", "alias": "Type IED Installation", "length": 50, "domain": { "type": "codedValue", "name": "IED", "description": "", "codedValues": [ { "name": "Energy industries", "code": "1" }, { "name": "Combustion of fuels", "code": "1.1" }, { "name": "Refining of mineral oil and gas", "code": "1.2" }, { "name": "Production of coke", "code": "1.3" }, { "name": "Gasification or liquefaction of coal", "code": "1.4.a" }, { "name": "Gasification or liquefaction of other fuels", "code": "1.4.b" }, { "name": "Production and processing of metals", "code": "2" }, { "name": "Metal ore roasting or sintering", "code": "2.1" }, { "name": "Production of pig iron or steel", "code": "2.2" }, { "name": "Processing of ferrous metals - operation of hot-rolling mills", "code": "2.3.a" }, { "name": "Processing of ferrous metals - operation of smitheries", "code": "2.3.b" }, { "name": "Processing of ferrous metals - application of protective fused metal coats", "code": "2.3.c" }, { "name": "Operation of ferrous metal foundries", "code": "2.4" }, { "name": "Processing of non-ferrous metals - production of non-ferrous crude metals", "code": "2.5.a" }, { "name": "Surface treatment of metals or plastic materials", "code": "2.6" }, { "name": "Mineral industry", "code": "3" }, { "name": "Production of cement, lime and magnesium oxide -", "code": "3.1.a" }, { "name": "Production of cement, lime and magnesium oxide -", "code": "3.1.b" }, { "name": "Production of cement, lime and magnesium oxide -", "code": "3.1.c" }, { "name": "Production of asbestos or the manufacture of asbestos-based products", "code": "3.2" }, { "name": "Manufacture of glass including glass fibre", "code": "3.3" }, { "name": "Melting mineral substances including the production of mineral fibres", "code": "3.4" }, { "name": "Manufacture of ceramic products", "code": "3.5" }, { "name": "Chemical industry", "code": "4" }, { "name": "Production of organic chemicals - simple hydrocarbons", "code": "4.1.a" }, { "name": "Production of organic chemicals - oxygen-containing hydrocarbons", "code": "4.1.b" }, { "name": "Production of organic chemicals - sulphurous hydrocarbons", "code": "4.1.c" }, { "name": "Production of organic chemicals - nitrogenous hydrocarbons", "code": "4.1.d" }, { "name": "Production of organic chemicals - phosphorus-containing hydrocarbons", "code": "4.1.e" }, { "name": "Production of organic chemicals - halogenic hydrocarbons", "code": "4.1.f" }, { "name": "Production of organic chemicals - organometallic compounds", "code": "4.1.g" }, { "name": "Production of organic chemicals - plastic materials", "code": "4.1.h" }, { "name": "Production of organic chemicals - synthetic rubbers", "code": "4.1.i" }, { "name": "Production of organic chemicals - dyes and pigments", "code": "4.1.j" }, { "name": "Production of organic chemicals - surface-active agents and surfactants", "code": "4.1.k" }, { "name": "Production of inorganic chemicals - gases", "code": "4.2.a" }, { "name": "Production of inorganic chemicals - acids", "code": "4.2.b" }, { "name": "Production of inorganic chemicals - bases", "code": "4.2.c" }, { "name": "Production of inorganic chemicals - salts", "code": "4.2.d" }, { "name": "Production of inorganic chemicals - non-metals", "code": "4.2.e" }, { "name": "Production of phosphorous-, nitrogen- or potassium-based fertilisers", "code": "4.3" }, { "name": "Production of plant protection products or of biocides", "code": "4.4" }, { "name": "Production of pharmaceutical products including intermediates", "code": "4.5" }, { "name": "Production of explosives", "code": "4.6" }, { "name": "Waste management", "code": "5" }, { "name": "Disposal or recovery of hazardous waste - biological treatment", "code": "5.1.a" }, { "name": "Disposal or recovery of hazardous waste - physico-chemical treatment", "code": "5.1.b" }, { "name": "Disposal or recovery of hazardous waste - blending or mixing different waste", "code": "5.1.c" }, { "name": "Disposal or recovery of hazardous waste - repackaging prior to submission waste", "code": "5.1.d" }, { "name": "Disposal or recovery of hazardous waste - solvent reclamation/regeneration", "code": "5.1.e" }, { "name": "Disposal or recovery of hazardous waste - recycling/reclamation of inorganic materials", "code": "5.1.f" }, { "name": "Disposal or recovery of hazardous waste - regeneration of acids or bases", "code": "5.1.g" }, { "name": "Disposal or recovery of hazardous waste - recovery of components used for pollution abatement", "code": "5.1.h" }, { "name": "Disposal or recovery of hazardous waste - recovery of components from catalysts", "code": "5.1.i" }, { "name": "Disposal or recovery of hazardous waste - oil re-refining or other reuses of oil", "code": "5.1.j" }, { "name": "Disposal or recovery of hazardous waste - surface impoundment", "code": "5.1.k" }, { "name": "Disposal or recovery of waste - non-hazardous waste", "code": "5.2.a" }, { "name": "Disposal or recovery of waste - hazardous waste", "code": "5.2.b" }, { "name": "Disposal of non-hazardous waste - biological treatment", "code": "5.3.a.i" }, { "name": "Disposal of non-hazardous waste - physico-chemical treatment", "code": "5.3.a.ii" }, { "name": "Disposal of non-hazardous waste - pre-treatment of waste for incineration or co-incineration", "code": "5.3.a.iii" }, { "name": "Disposal of non-hazardous waste - treatment of slags and ashes", "code": "5.3.a.iv" }, { "name": "Disposal of non-hazardous waste - treatment in shredders of metal waste", "code": "5.3.a.v" }, { "name": "Recovery, or a mix of recovery and disposal, of non-hazardous waste - biological treatment", "code": "5.3.b.i" }, { "name": "Recovery, or a mix of recovery and disposal, of non-hazardous waste - pre-treatment of waste", "code": "5.3.b.ii" }, { "name": "Recovery, or a mix of recovery and disposal, of non-hazardous waste - treatment of slags and ashes", "code": "5.3.b.iii" }, { "name": "Recovery, or a mix of recovery and disposal, of non-hazardous waste - treatment in shredders of metal waste", "code": "5.3.b.iv" }, { "name": "Landfills", "code": "5.4" }, { "name": "Temporary storage of hazardous waste", "code": "5.5" }, { "name": "Underground storage of hazardous waste", "code": "5.6" }, { "name": "Other activities", "code": "6" }, { "name": "Production in industrial installations - pulp from timber or other fibrous materials", "code": "6.1.a" }, { "name": "Production in industrial installations - paper or card board", "code": "6.1.b" }, { "name": "Production in industrial installations - wood-based panels", "code": "6.1.c" }, { "name": "Pre-treatment (operations such as washing, bleaching, mercerisation)", "code": "6.2" }, { "name": "Tanning of hides and skins", "code": "6.3" }, { "name": "Operating slaughterhouses", "code": "6.4.a" }, { "name": "Treatment and processing - animal raw materials", "code": "6.4.b.i" }, { "name": "Treatment and processing - vegetable raw materials", "code": "6.4.b.ii" }, { "name": "Treatment and processing - animal and vegetable raw materials", "code": "6.4.b.iii" }, { "name": "Treatment and processing of milk", "code": "6.4.c" }, { "name": "Disposal or recycling of animal carcases or animal waste", "code": "6.5" }, { "name": "Intensive rearing of poultry or pigs - 40 000 places", "code": "6.6.a" }, { "name": "Intensive rearing of poultry or pigs - 2000 places", "code": "6.6.b" }, { "name": "Intensive rearing of poultry or pigs - 750 places for sows", "code": "6.6.c" }, { "name": "Surface treatment of substances, objects or products using organic solvents", "code": "6.7" }, { "name": "Production of carbon", "code": "6.8" }, { "name": "Capture of CO2 streams from installations", "code": "6.9" }, { "name": "Preservation of wood and wood products with chemicals", "code": "6.10" }, { "name": "Independently operated treatment of waste water", "code": "6.11" }, { "name": "Processing of non-ferrous metals - melting", "code": "2.5.b" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NaceCode", "type": "esriFieldTypeString", "alias": "NACE Code", "length": 250, "domain": null } ], "indexes": [ { "name": "R34_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G127IED_INST_ID", "fields": "IED_INST_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 60, "name": "IED Installations", "relatedTableId": 36, "role": "esriRelRoleDestination", "keyField": "IED_INST_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "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": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "779d9faf75b94bd08ceb6e6f31de7a6b" }