{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 177,
 "name": "REFERENCE_MODE",
 "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": "IS_PRM",
   "type": "esriFieldTypeString",
   "alias": "IS_PRM",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WS2_YES_NO_NA_CL",
    "description": "A domain used to store logical answers to Boolean attributes. In some situations a Yes/No answer is not appropriate and two other options are provided - Not Applicable and Unknown. This effectively negates the boolean aspect of the field but there are always situations where the answer is not known (Unknown) and there are occasionally situations where a yes/no answer is not appropriate. Utilizing this domain prevents the addition of fields to account for these situations.",
    "codedValues": [
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "Yes",
      "code": "Yes"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "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": "NETWORK_ID",
   "type": "esriFieldTypeSmallInteger",
   "alias": "NETWORK_ID",
   "domain": {
    "type": "codedValue",
    "name": "WS2_dLRSNetworks",
    "description": "An enumeration that defines the types of measure networks utilized in a standard PODS 7.0 data model. If Linear Referencing is not utilized for locating features then this domain will never be deployed in the data model. If Linear referencing is utilized for locating assets and conditions on or along a pipeline system then each network of routes used to locate features is itemized here. The default deployment of PODS 7.0 includes the traditional measure location systems of PODS 7.0 Relational and PODS 7.0 Spatial.",
    "codedValues": [
     {
      "name": "ENGINEERING_STA_NETWORK",
      "code": 1
     },
     {
      "name": "CONTINUOUS_MEAS_NETWORK",
      "code": 2
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "PARENT_REF_MODE_RFX",
   "type": "esriFieldTypeGUID",
   "alias": "PARENT_REF_MODE_RFX",
   "length": 38,
   "domain": null
  },
  {
   "name": "PRESERVE_RELATE_IDENTIFIER",
   "type": "esriFieldTypeGUID",
   "alias": "PRESERVE_RELATE_IDENTIFIER",
   "length": 38,
   "domain": null
  },
  {
   "name": "REF_MODE_BASIS",
   "type": "esriFieldTypeString",
   "alias": "REF_MODE_BASIS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WS2_REF_MODE_BASIS_CL",
    "description": "Describes the basis for which measured length is calculated. Length can be calculated in a variety of ways given the coordinate information that is available. The most common form of length calculation is 2 dimensional distance between two points that have an X and Y coordinate. Distance calculations become more complicated with taking into account distance over a projected map surface or take into account the curvature of the earth's surface.",
    "codedValues": [
     {
      "name": "2D Projected",
      "code": "2D Projected"
     },
     {
      "name": "3D Geoid",
      "code": "3D Geoid"
     },
     {
      "name": "3D Projected",
      "code": "3D Projected"
     },
     {
      "name": "3D Slack Chain",
      "code": "3D Slack Chain"
     },
     {
      "name": "Arbitrary",
      "code": "Arbitrary"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "Verified as Unknown",
      "code": "Verified as Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "REF_MODE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "REF_MODE_TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WS2_REF_MODE_TYPE_CL",
    "description": "Describes the behavior of measurement or stationing for given route or set of routes for given pipeline. Interrupted means that a pipeline can be comprised of multiple routes connected end to end. Each route has a set of stationing or measures that describe that route alone. Uninterrupted means that only a single route exists for the pipeline without gaps. All the measure values for that route are monotonically increasing or decreasing along the entire length of the route. Adjustable means that if a new section of pipe were added to the pipeline (at the beginning, in the middle or at the end) then all subsequent measure values downstream from where the new pipe was inserted will be updated to account for the new length of the pipe that was added. Not adjustable means that regardless of the pipe length being added to a pipeline, no measure values are updated for that route.",
    "codedValues": [
     {
      "name": "Interrupted and Adjustable (Re-route + Offset)",
      "code": "Interrupted and Adjustable (Re-route + Offset)"
     },
     {
      "name": "Interrupted and Not Adjustable (Engineering)",
      "code": "Interrupted and Not Adjustable (Engineering)"
     },
     {
      "name": "Uninterrupted and Adjustable (Continuous)",
      "code": "Uninterrupted and Adjustable (Continuous)"
     },
     {
      "name": "Uninterrupted and Not Adjustable (Mile Post)",
      "code": "Uninterrupted and Not Adjustable (Mile Post)"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "Verified as Unknown",
      "code": "Verified as Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "REF_MODE_UNITS",
   "type": "esriFieldTypeString",
   "alias": "REF_MODE_UNITS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WS2_REF_MODE_UNITS_CL",
    "description": "Using ESRI reference codes, this value is used to define the units of measurement or stationing for network routes.",
    "codedValues": [
     {
      "name": "Foot",
      "code": "Foot"
     },
     {
      "name": "Kilometer",
      "code": "Kilometer"
     },
     {
      "name": "Meter",
      "code": "Meter"
     },
     {
      "name": "Nautical Mile",
      "code": "Nautical Mile"
     },
     {
      "name": "Survey Chain",
      "code": "Survey Chain"
     },
     {
      "name": "Survey Foot",
      "code": "Survey Foot"
     },
     {
      "name": "Survey Link",
      "code": "Survey Link"
     },
     {
      "name": "Survey Mile",
      "code": "Survey Mile"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "Verified as unknown",
      "code": "Verified as unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "START_MEASURE",
   "type": "esriFieldTypeDouble",
   "alias": "START_MEASURE",
   "domain": null
  },
  {
   "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": "G178UNIQUE_ID",
   "fields": "UNIQUE_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 30,
   "name": "networkRoute-ESNET",
   "relatedTableId": 16,
   "role": "esriRelRoleOrigin",
   "keyField": "UNIQUE_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 33,
   "name": "networkRoute-CMNET",
   "relatedTableId": 15,
   "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"
}