{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 178, "name": "PRODUCT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "COMMENTS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 255, "domain": null }, { "name": "FROM_DATE", "type": "esriFieldTypeDate", "alias": "FROM_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 50, "domain": null }, { "name": "PRESERVE_RELATE_IDENTIFIER", "type": "esriFieldTypeGUID", "alias": "PRESERVE_RELATE_IDENTIFIER", "length": 38, "domain": null }, { "name": "PRODUCT_SUB_TYPE", "type": "esriFieldTypeString", "alias": "PRODUCT_SUB_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_PRODUCT_SUB_TYPE_CL", "description": "A sample listing of PRODUCT sub-types.", "codedValues": [ { "name": "CRD-CRD, Crude Oil", "code": "CRD-CRD, Crude Oil" }, { "name": "CRD-CRR, Sour Crude Oil", "code": "CRD-CRR, Sour Crude Oil" }, { "name": "CRD-CRW, Sweet Crude Oil", "code": "CRD-CRW, Sweet Crude Oil" }, { "name": "HVL-CHM, Chemical", "code": "HVL-CHM, Chemical" }, { "name": "HVL-HVL, Highly Volatile Liquid", "code": "HVL-HVL, Highly Volatile Liquid" }, { "name": "HVL-OHV, Other Highly Volatile Liquid", "code": "HVL-OHV, Other Highly Volatile Liquid" }, { "name": "NG-EPG, Abandoned or Empty Gas Pipeline", "code": "NG-EPG, Abandoned or Empty Gas Pipeline" }, { "name": "NG-HG, Hydrogen Gas", "code": "NG-HG, Hydrogen Gas" }, { "name": "NG-MG, Methane Gas", "code": "NG-MG, Methane Gas" }, { "name": "NG-NG1, Pipeline or tariff quality natural gas", "code": "NG-NG1, Pipeline or tariff quality natural gas" }, { "name": "NG-NG2. Wet but non-sour natural gas", "code": "NG-NG2. Wet but non-sour natural gas" }, { "name": "NG-NG3. Sour but non-wet natural gas", "code": "NG-NG3. Sour but non-wet natural gas" }, { "name": "NG-NG4. Wet, sour natural gas", "code": "NG-NG4. Wet, sour natural gas" }, { "name": "NG-OTG, Other Gas", "code": "NG-OTG, Other Gas" }, { "name": "NG-PG, Propane Gas", "code": "NG-PG, Propane Gas" }, { "name": "NG-SG, Synthetic Gas", "code": "NG-SG, Synthetic Gas" }, { "name": "PRD-AA, Anhydrous Ammonia", "code": "PRD-AA, Anhydrous Ammonia" }, { "name": "PRD-BDB, Biodiesel blend", "code": "PRD-BDB, Biodiesel blend" }, { "name": "PRD-CO2, Carbon Dioxide", "code": "PRD-CO2, Carbon Dioxide" }, { "name": "PRD-EPL, Abandoned Liquid Pipeline", "code": "PRD-EPL, Abandoned Liquid Pipeline" }, { "name": "PRD-ETB, Ethanol blended gasoline", "code": "PRD-ETB, Ethanol blended gasoline" }, { "name": "PRD-ETH, Fuel Grade Ethanol", "code": "PRD-ETH, Fuel Grade Ethanol" }, { "name": "PRD-LPG, Liquefied Petroleum Gas", "code": "PRD-LPG, Liquefied Petroleum Gas" }, { "name": "PRD-NGL, Natural Gas Liquids", "code": "PRD-NGL, Natural Gas Liquids" }, { "name": "PRD-OBJ, Other biofuels", "code": "PRD-OBJ, Other biofuels" }, { "name": "PRD-OTR, Other refined and/or non-HVL petroleum", "code": "PRD-OTR, Other refined and/or non-HVL petroleum" }, { "name": "PRD-RFD, Refined fuel oil, diesel", "code": "PRD-RFD, Refined fuel oil, diesel" }, { "name": "PRD-RGS, Refined non-ethanol blended gasoline", "code": "PRD-RGS, Refined non-ethanol blended gasoline" }, { "name": "PRD-RKJ, Refined kerosene, jet fuel", "code": "PRD-RKJ, Refined kerosene, jet fuel" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRODUCT_TYPE", "type": "esriFieldTypeString", "alias": "PRODUCT_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_PRODUCT_TYPE_CL", "description": "A code listing of PRODUCT types.", "codedValues": [ { "name": "CRD, Crude Oil", "code": "CRD, Crude Oil" }, { "name": "HVL, Highly Volatile Liquid", "code": "HVL, Highly Volatile Liquid" }, { "name": "NG, Natural Gas", "code": "NG, Natural Gas" }, { "name": "PRD, Non High Volatile Liquid Product", "code": "PRD, Non High Volatile Liquid Product" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" }, { "name": "W, Water", "code": "W, Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "WS2_HISTORIC_STATE_CL", "description": "Indicates if the record is the most recent version a feature or event representation. Modern GIS systems support the notion of in-line history where current and historic versions of records are managed in a single table. As these features are updated, the attributes defined by including the HISTORY data type are modified for those features. The FROM_DATE and TO_DATE fields show a life-span of each version of the record. The historical records have both the FROM_DATE and TO_DATE fields set and the STATUS field set to Historic. The current record has the FROM_DATE set, but the TO_DATE field is NULL. The STATUS field is set to Current. As new versions of records are added, the previous version TO_DATE is set to the FROM_DATE of the most recent record. \nA good example of this is changing pipe records to reflect a pipe replacement. This example also brings into play how the LAYER_METADATA table can be used to manage gap and overlap situations. A section of pipeline is removed. In the GIS, the existing pipe segment is split into three pieces and the middle PIPE_SEGMENT record attributes are set as follows: TO_DATE is set to Now and STATUS is set to Historic. For the PIPE_SEGMENT table there is a LAYER_METADATA record set with the following attributes: DEFINITION_QUERY= STATUS=Current, ALLOW_GAP=No, ALLOW_OVERLAP=Yes. If a QA routine is run against the PIPE_SEGMENT layer it will return a gap violation because there is a gap between two active PIPE_SEGMENT records (since the middle record has been set to Historic. A new PIPE_SEGMENT record is inserted with different business attributes (wall thickness, grade etc.) and it fills in the gap between the two active records. The FROM_DATE for this new record is set to Now, and the STATUS is set to Current. There are now four PIPE_SEGMENT records for this pipeline. One is Historic, three are Current. Two are completely coincident with each other but one is the Current record and the other is the Historic record. Now when the QA process is re-run looking for errors in the PIPE_SEGMENT table and neither the gap or overlap situations occur because there are now gaps in Current records and there are no overlaps in Current records.", "codedValues": [ { "name": "Current", "code": "Current" }, { "name": "Historic", "code": "Historic" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TO_DATE", "type": "esriFieldTypeDate", "alias": "TO_DATE", "length": 8, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeGUID", "alias": "UNIQUE_ID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G200UNIQUE_ID", "fields": "UNIQUE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 50, "name": "pipelineProduct", "relatedTableId": 179, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "0b6ea39373374d868246e69ee986e7a0" }