{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 140, "name": "PIPE_JURISDICTION", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 4269, "latestWkid": 4269, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 8.98315284119521E-9, "zTolerance": 0.001, "mTolerance": 0.00327716054648402, "falseX": -400, "falseY": -400, "xyUnits": 1.0000000005263556E9, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 2741.1390787164855 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 244, 142, 73, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -180, "ymin": -90, "xmax": 180, "ymax": 90, "spatialReference": { "wkid": 4269, "latestWkid": 4269, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "DERIVED_NETWORK_ROUTE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 255, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "COUNTRY", "length": 50, "domain": { "type": "codedValue", "name": "WS2_COUNTRY_CL", "description": "An enumeration of countries. This particular list is the ISO 3166-1 two-digit code list.", "codedValues": [ { "name": "Afghanistan", "code": "Afghanistan" }, { "name": "Åland Islands", "code": "Åland Islands" }, { "name": "Albania", "code": "Albania" }, { "name": "Algeria", "code": "Algeria" }, { "name": "American Samoa", "code": "American Samoa" }, { "name": "Andorra", "code": "Andorra" }, { "name": "Angola", "code": "Angola" }, { "name": "Anguilla", "code": "Anguilla" }, { "name": "Antarctica", "code": "Antarctica" }, { "name": "Antigua and Barbuda", "code": "Antigua and Barbuda" }, { "name": "Argentina", "code": "Argentina" }, { "name": "Armenia", "code": "Armenia" }, { "name": "Aruba", "code": "Aruba" }, { "name": "Australia", "code": "Australia" }, { "name": "Austria", "code": "Austria" }, { "name": "Azerbaijan", "code": "Azerbaijan" }, { "name": "Bahamas", "code": "Bahamas" }, { "name": "Bahrain", "code": "Bahrain" }, { "name": "Bangladesh", "code": "Bangladesh" }, { "name": "Barbados", "code": "Barbados" }, { "name": "Belarus", "code": "Belarus" }, { "name": "Belgium", "code": "Belgium" }, { "name": "Belize", "code": "Belize" }, { "name": "Benin", "code": "Benin" }, { "name": "Bermuda", "code": "Bermuda" }, { "name": "Bhutan", "code": "Bhutan" }, { "name": "Bolivia (Plurinational State of)", "code": "Bolivia (Plurinational State of)" }, { "name": "Bonaire, Sint Eustatius and Saba", "code": "Bonaire, Sint Eustatius and Saba" }, { "name": "Bosnia and Herzegovina", "code": "Bosnia and Herzegovina" }, { "name": "Botswana", "code": "Botswana" }, { "name": "Bouvet Island", "code": "Bouvet Island" }, { "name": "Brazil", "code": "Brazil" }, { "name": "British Indian Ocean Territory", "code": "British Indian Ocean Territory" }, { "name": "Brunei Darussalam", "code": "Brunei Darussalam" }, { "name": "Bulgaria", "code": "Bulgaria" }, { "name": "Burkina Faso", "code": "Burkina Faso" }, { "name": "Burundi", "code": "Burundi" }, { "name": "Cabo Verde", "code": "Cabo Verde" }, { "name": "Cambodia", "code": "Cambodia" }, { "name": "Cameroon", "code": "Cameroon" }, { "name": "Canada", "code": "Canada" }, { "name": "Cayman Islands", "code": "Cayman Islands" }, { "name": "Central African Republic", "code": "Central African Republic" }, { "name": "Chad", "code": "Chad" }, { "name": "Chile", "code": "Chile" }, { "name": "China", "code": "China" }, { "name": "Christmas Island", "code": "Christmas Island" }, { "name": "Cocos (Keeling) Islands", "code": "Cocos (Keeling) Islands" }, { "name": "Colombia", "code": "Colombia" }, { "name": "Comoros", "code": "Comoros" }, { "name": "Congo", "code": "Congo" }, { "name": "Congo (Democratic Republic of the)", "code": "Congo (Democratic Republic of the)" }, { "name": "Cook Islands", "code": "Cook Islands" }, { "name": "Costa Rica", "code": "Costa Rica" }, { "name": "Côte d''Ivoire", "code": "Côte d''Ivoire" }, { "name": "Croatia", "code": "Croatia" }, { "name": "Cuba", "code": "Cuba" }, { "name": "Curaçao", "code": "Curaçao" }, { "name": "Cyprus", "code": "Cyprus" }, { "name": "Czechia", "code": "Czechia" }, { "name": "Denmark", "code": "Denmark" }, { "name": "Djibouti", "code": "Djibouti" }, { "name": "Dominica", "code": "Dominica" }, { "name": "Dominican Republic", "code": "Dominican Republic" }, { "name": "Ecuador", "code": "Ecuador" }, { "name": "Egypt", "code": "Egypt" }, { "name": "El Salvador", "code": "El Salvador" }, { "name": "Equatorial Guinea", "code": "Equatorial Guinea" }, { "name": "Eritrea", "code": "Eritrea" }, { "name": "Estonia", "code": "Estonia" }, { "name": "Ethiopia", "code": "Ethiopia" }, { "name": "Falkland Islands (Malvinas)", "code": "Falkland Islands (Malvinas)" }, { "name": "Faroe Islands", "code": "Faroe Islands" }, { "name": "Fiji", "code": "Fiji" }, { "name": "Finland", "code": "Finland" }, { "name": "France", "code": "France" }, { "name": "French Guiana", "code": "French Guiana" }, { "name": "French Polynesia", "code": "French Polynesia" }, { "name": "French Southern Territories", "code": "French Southern Territories" }, { "name": "Gabon", "code": "Gabon" }, { "name": "Gambia", "code": "Gambia" }, { "name": "Georgia", "code": "Georgia" }, { "name": "Germany", "code": "Germany" }, { "name": "Ghana", "code": "Ghana" }, { "name": "Gibraltar", "code": "Gibraltar" }, { "name": "Greece", "code": "Greece" }, { "name": "Greenland", "code": "Greenland" }, { "name": "Grenada", "code": "Grenada" }, { "name": "Guadeloupe", "code": "Guadeloupe" }, { "name": "Guam", "code": "Guam" }, { "name": "Guatemala", "code": "Guatemala" }, { "name": "Guernsey", "code": "Guernsey" }, { "name": "Guinea", "code": "Guinea" }, { "name": "Guinea-Bissau", "code": "Guinea-Bissau" }, { "name": "Guyana", "code": "Guyana" }, { "name": "Haiti", "code": "Haiti" }, { "name": "Heard Island and McDonald Islands", "code": "Heard Island and McDonald Islands" }, { "name": "Holy See", "code": "Holy See" }, { "name": "Honduras", "code": "Honduras" }, { "name": "Hong Kong", "code": "Hong Kong" }, { "name": "Hungary", "code": "Hungary" }, { "name": "Iceland", "code": "Iceland" }, { "name": "India", "code": "India" }, { "name": "Indonesia", "code": "Indonesia" }, { "name": "Iran (Islamic Republic of)", "code": "Iran (Islamic Republic of)" }, { "name": "Iraq", "code": "Iraq" }, { "name": "Ireland", "code": "Ireland" }, { "name": "Isle of Man", "code": "Isle of Man" }, { "name": "Israel", "code": "Israel" }, { "name": "Italy", "code": "Italy" }, { "name": "Jamaica", "code": "Jamaica" }, { "name": "Japan", "code": "Japan" }, { "name": "Jersey", "code": "Jersey" }, { "name": "Jordan", "code": "Jordan" }, { "name": "Kazakhstan", "code": "Kazakhstan" }, { "name": "Kenya", "code": "Kenya" }, { "name": "Kiribati", "code": "Kiribati" }, { "name": "Korea (Democratic People''s Republic of)", "code": "Korea (Democratic People''s Republic of)" }, { "name": "Korea (Republic of)", "code": "Korea (Republic of)" }, { "name": "Kuwait", "code": "Kuwait" }, { "name": "Kyrgyzstan", "code": "Kyrgyzstan" }, { "name": "Lao People''s Democratic Republic", "code": "Lao People''s Democratic Republic" }, { "name": "Latvia", "code": "Latvia" }, { "name": "Lebanon", "code": "Lebanon" }, { "name": "Lesotho", "code": "Lesotho" }, { "name": "Liberia", "code": "Liberia" }, { "name": "Libya", "code": "Libya" }, { "name": "Liechtenstein", "code": "Liechtenstein" }, { "name": "Lithuania", "code": "Lithuania" }, { "name": "Luxembourg", "code": "Luxembourg" }, { "name": "Macao", "code": "Macao" }, { "name": "Macedonia (the former Yugoslav Republic of)", "code": "Macedonia (the former Yugoslav Republic of)" }, { "name": "Madagascar", "code": "Madagascar" }, { "name": "Malawi", "code": "Malawi" }, { "name": "Malaysia", "code": "Malaysia" }, { "name": "Maldives", "code": "Maldives" }, { "name": "Mali", "code": "Mali" }, { "name": "Malta", "code": "Malta" }, { "name": "Marshall Islands", "code": "Marshall Islands" }, { "name": "Martinique", "code": "Martinique" }, { "name": "Mauritania", "code": "Mauritania" }, { "name": "Mauritius", "code": "Mauritius" }, { "name": "Mayotte", "code": "Mayotte" }, { "name": "Mexico", "code": "Mexico" }, { "name": "Micronesia (Federated States of)", "code": "Micronesia (Federated States of)" }, { "name": "Moldova (Republic of)", "code": "Moldova (Republic of)" }, { "name": "Monaco", "code": "Monaco" }, { "name": "Mongolia", "code": "Mongolia" }, { "name": "Montenegro", "code": "Montenegro" }, { "name": "Montserrat", "code": "Montserrat" }, { "name": "Morocco", "code": "Morocco" }, { "name": "Mozambique", "code": "Mozambique" }, { "name": "Myanmar", "code": "Myanmar" }, { "name": "Namibia", "code": "Namibia" }, { "name": "Nauru", "code": "Nauru" }, { "name": "Nepal", "code": "Nepal" }, { "name": "Netherlands", "code": "Netherlands" }, { "name": "New Caledonia", "code": "New Caledonia" }, { "name": "New Zealand", "code": "New Zealand" }, { "name": "Nicaragua", "code": "Nicaragua" }, { "name": "Niger", "code": "Niger" }, { "name": "Nigeria", "code": "Nigeria" }, { "name": "Niue", "code": "Niue" }, { "name": "Norfolk Island", "code": "Norfolk Island" }, { "name": "Northern Mariana Islands", "code": "Northern Mariana Islands" }, { "name": "Norway", "code": "Norway" }, { "name": "Oman", "code": "Oman" }, { "name": "Pakistan", "code": "Pakistan" }, { "name": "Palau", "code": "Palau" }, { "name": "Palestine, State of", "code": "Palestine, State of" }, { "name": "Panama", "code": "Panama" }, { "name": "Papua New Guinea", "code": "Papua New Guinea" }, { "name": "Paraguay", "code": "Paraguay" }, { "name": "Peru", "code": "Peru" }, { "name": "Philippines", "code": "Philippines" }, { "name": "Pitcairn", "code": "Pitcairn" }, { "name": "Poland", "code": "Poland" }, { "name": "Portugal", "code": "Portugal" }, { "name": "Puerto Rico", "code": "Puerto Rico" }, { "name": "Qatar", "code": "Qatar" }, { "name": "Réunion", "code": "Réunion" }, { "name": "Romania", "code": "Romania" }, { "name": "Russian Federation", "code": "Russian Federation" }, { "name": "Rwanda", "code": "Rwanda" }, { "name": "Saint Barthélemy", "code": "Saint Barthélemy" }, { "name": "Saint Helena, Ascension and Tristan da Cunha", "code": "Saint Helena, Ascension and Tristan da Cunha" }, { "name": "Saint Kitts and Nevis", "code": "Saint Kitts and Nevis" }, { "name": "Saint Lucia", "code": "Saint Lucia" }, { "name": "Saint Martin (French part)", "code": "Saint Martin (French part)" }, { "name": "Saint Pierre and Miquelon", "code": "Saint Pierre and Miquelon" }, { "name": "Saint Vincent and the Grenadines", "code": "Saint Vincent and the Grenadines" }, { "name": "Samoa", "code": "Samoa" }, { "name": "San Marino", "code": "San Marino" }, { "name": "Sao Tome and Principe", "code": "Sao Tome and Principe" }, { "name": "Saudi Arabia", "code": "Saudi Arabia" }, { "name": "Senegal", "code": "Senegal" }, { "name": "Serbia", "code": "Serbia" }, { "name": "Seychelles", "code": "Seychelles" }, { "name": "Sierra Leone", "code": "Sierra Leone" }, { "name": "Singapore", "code": "Singapore" }, { "name": "Sint Maarten (Dutch part)", "code": "Sint Maarten (Dutch part)" }, { "name": "Slovakia", "code": "Slovakia" }, { "name": "Slovenia", "code": "Slovenia" }, { "name": "Solomon Islands", "code": "Solomon Islands" }, { "name": "Somalia", "code": "Somalia" }, { "name": "South Africa", "code": "South Africa" }, { "name": "South Georgia and the South Sandwich Islands", "code": "South Georgia and the South Sandwich Islands" }, { "name": "South Sudan", "code": "South Sudan" }, { "name": "Spain", "code": "Spain" }, { "name": "Sri Lanka", "code": "Sri Lanka" }, { "name": "Sudan", "code": "Sudan" }, { "name": "Suriname", "code": "Suriname" }, { "name": "Svalbard and Jan Mayen", "code": "Svalbard and Jan Mayen" }, { "name": "Swaziland", "code": "Swaziland" }, { "name": "Sweden", "code": "Sweden" }, { "name": "Switzerland", "code": "Switzerland" }, { "name": "Syrian Arab Republic", "code": "Syrian Arab Republic" }, { "name": "Taiwan, Province of China[a]", "code": "Taiwan, Province of China[a]" }, { "name": "Tajikistan", "code": "Tajikistan" }, { "name": "Tanzania, United Republic of", "code": "Tanzania, United Republic of" }, { "name": "Thailand", "code": "Thailand" }, { "name": "Timor-Leste", "code": "Timor-Leste" }, { "name": "Togo", "code": "Togo" }, { "name": "Tokelau", "code": "Tokelau" }, { "name": "Tonga", "code": "Tonga" }, { "name": "Trinidad and Tobago", "code": "Trinidad and Tobago" }, { "name": "Tunisia", "code": "Tunisia" }, { "name": "Turkey", "code": "Turkey" }, { "name": "Turkmenistan", "code": "Turkmenistan" }, { "name": "Turks and Caicos Islands", "code": "Turks and Caicos Islands" }, { "name": "Tuvalu", "code": "Tuvalu" }, { "name": "Uganda", "code": "Uganda" }, { "name": "Ukraine", "code": "Ukraine" }, { "name": "United Arab Emirates", "code": "United Arab Emirates" }, { "name": "United Kingdom", "code": "United Kingdom" }, { "name": "United States Minor Outlying Islands", "code": "United States Minor Outlying Islands" }, { "name": "United States of America", "code": "United States of America" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Uruguay", "code": "Uruguay" }, { "name": "Uzbekistan", "code": "Uzbekistan" }, { "name": "Vanuatu", "code": "Vanuatu" }, { "name": "Venezuela (Bolivarian Republic of)", "code": "Venezuela (Bolivarian Republic of)" }, { "name": "Viet Nam", "code": "Viet Nam" }, { "name": "Virgin Islands (British)", "code": "Virgin Islands (British)" }, { "name": "Virgin Islands (U.S.)", "code": "Virgin Islands (U.S.)" }, { "name": "Wallis and Futuna", "code": "Wallis and Futuna" }, { "name": "Western Sahara", "code": "Western Sahara" }, { "name": "Yemen", "code": "Yemen" }, { "name": "Zambia", "code": "Zambia" }, { "name": "Zimbabwe", "code": "Zimbabwe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "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": "DERIVED_CM_NETWORK_ID", "type": "esriFieldTypeGUID", "alias": "DERIVED_CM_NETWORK_ID", "length": 38, "domain": null }, { "name": "DERIVED_FROM_MEASURE", "type": "esriFieldTypeDouble", "alias": "DERIVED_FROM_MEASURE", "domain": null }, { "name": "DERIVED_NETWORK_ROUTE_NAME", "type": "esriFieldTypeString", "alias": "DERIVED_NETWORK_ROUTE_NAME", "length": 255, "domain": null }, { "name": "DERIVED_TO_MEASURE", "type": "esriFieldTypeDouble", "alias": "DERIVED_TO_MEASURE", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 255, "domain": null }, { "name": "DETERMINATION_DATE", "type": "esriFieldTypeDate", "alias": "DETERMINATION_DATE", "length": 8, "domain": null }, { "name": "EDIT_RESPONSE", "type": "esriFieldTypeString", "alias": "EDIT_RESPONSE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_EDIT_RESPONSE_CL", "description": "Domain used to describe how an online linear referenced event-driven record geometry responds to changes in the XYZ and Measure (M) updates to the NETWORK_ROUTE feature that the event is located on or near. The following values define the behavior for each of these records and their underlying geometry (either point or linear):\n\t- Relative - the event feature is located linear referencing. Any change in the underlying M values for a NETWORK_ROUTE feature could cause the position of the event feature to shift up or down the NETWORK_ROUTE.\n\t- Absolute - the event feature is located at a specific XYZ coordinate on or near the network route. Any change in the underlying XYZ or M values for a NETWORK_ROUTE feature will never cause the position of the event feature to shift up or down the NETWORK_ROUTE but will possibly allow the measure or the station value of the event feature to be altered.\n\t- Online - the event feature geometry is located coincident to the geometry of the NETWORK_ROUTE feature.\n\t- Offline - the event feature geometry is located off the geometry of the NETWORK_ROUTE feature.\n\t- Fixed LRS - the measure or station of the event feature does not change when the M values of the underlying or nearby NETWORK_ROUTE feature are altered\n\t- Update LRS - the measure or station of the event feature is updated when the M values of the underlying or nearby NETWORK_ROUTE feature are altered\n\t- Update LRS for Point - the measure or station of the event feature is updated when the M values of the underlying or nearby NETWORK_ROUTE feature are altered if the geometry of the event-feature is a point\n\t- No LRS - the record geometry is exclusively located by XYZ and any change in the feature geometry M or the nearby NETWORK_ROUTE geometry M values do not affect the location or any measure/station attributes for the record.", "codedValues": [ { "name": "Absolute - Offline - No LRS", "code": "Absolute - Offline - No LRS" }, { "name": "Absolute - Offline - Update LRS for Point", "code": "Absolute - Offline - Update LRS for Point" }, { "name": "Absolute - Online - Fixed LRS", "code": "Absolute - Online - Fixed LRS" }, { "name": "Absolute - Online - Update LRS", "code": "Absolute - Online - Update LRS" }, { "name": "Relative - Online - Fixed LRS", "code": "Relative - Online - Fixed LRS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FROM_DATE", "type": "esriFieldTypeDate", "alias": "FROM_DATE", "length": 8, "domain": null }, { "name": "FROM_MEASURE", "type": "esriFieldTypeDouble", "alias": "FROM_MEASURE", "domain": null }, { "name": "FROM_NETWORK_ROUTE_ID", "type": "esriFieldTypeGUID", "alias": "FROM_NETWORK_ROUTE_ID", "length": 38, "domain": null }, { "name": "FROM_NETWORK_ROUTE_NAME", "type": "esriFieldTypeString", "alias": "FROM_NETWORK_ROUTE_NAME", "length": 255, "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": "LOC_ERROR", "type": "esriFieldTypeString", "alias": "LOC_ERROR", "length": 50, "domain": null }, { "name": "MAINTAIN_LRS", "type": "esriFieldTypeString", "alias": "MAINTAIN_LRS", "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": "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": "PIPELINE_ID", "type": "esriFieldTypeGUID", "alias": "PIPELINE_ID", "length": 38, "domain": null }, { "name": "POSITION_SOURCE", "type": "esriFieldTypeString", "alias": "POSITION_SOURCE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_POSITION_SOURCE_CL", "description": "Indicates how the geometry for a record was initially located on or along the pipeline route.", "codedValues": [ { "name": "Coordinate Located", "code": "Coordinate Located" }, { "name": "LRS Located", "code": "LRS Located" }, { "name": "LRS Located with Offset", "code": "LRS Located with Offset" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Verified as unknown", "code": "Verified as unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRESERVE_RELATE_IDENTIFIER", "type": "esriFieldTypeGUID", "alias": "PRESERVE_RELATE_IDENTIFIER", "length": 38, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_STATE_CL", "description": "An enumeration of states/provinces from the US and Canada. This particular list is from ISO 3166-2.", "codedValues": [ { "name": "Alabama", "code": "Alabama" }, { "name": "Alaska", "code": "Alaska" }, { "name": "Alberta", "code": "Alberta" }, { "name": "American Samoa", "code": "American Samoa" }, { "name": "Arizona", "code": "Arizona" }, { "name": "Arkansas", "code": "Arkansas" }, { "name": "British Columbia", "code": "British Columbia" }, { "name": "California", "code": "California" }, { "name": "Colorado", "code": "Colorado" }, { "name": "Connecticut", "code": "Connecticut" }, { "name": "Delaware", "code": "Delaware" }, { "name": "District of Columbia", "code": "District of Columbia" }, { "name": "Florida", "code": "Florida" }, { "name": "Georgia", "code": "Georgia" }, { "name": "Guam", "code": "Guam" }, { "name": "Hawaii", "code": "Hawaii" }, { "name": "Idaho", "code": "Idaho" }, { "name": "Illinois", "code": "Illinois" }, { "name": "Indiana", "code": "Indiana" }, { "name": "Iowa", "code": "Iowa" }, { "name": "Kansas", "code": "Kansas" }, { "name": "Kentucky", "code": "Kentucky" }, { "name": "Louisiana", "code": "Louisiana" }, { "name": "Maine", "code": "Maine" }, { "name": "Manitoba", "code": "Manitoba" }, { "name": "Maryland", "code": "Maryland" }, { "name": "Massachusetts", "code": "Massachusetts" }, { "name": "Michigan", "code": "Michigan" }, { "name": "Minnesota", "code": "Minnesota" }, { "name": "Mississippi", "code": "Mississippi" }, { "name": "Missouri", "code": "Missouri" }, { "name": "Montana", "code": "Montana" }, { "name": "Nebraska", "code": "Nebraska" }, { "name": "Nevada", "code": "Nevada" }, { "name": "New Brunswick", "code": "New Brunswick" }, { "name": "New Hampshire", "code": "New Hampshire" }, { "name": "New Jersey", "code": "New Jersey" }, { "name": "New Mexico", "code": "New Mexico" }, { "name": "New York", "code": "New York" }, { "name": "Newfoundland and Labrador", "code": "Newfoundland and Labrador" }, { "name": "North Carolina", "code": "North Carolina" }, { "name": "North Dakota", "code": "North Dakota" }, { "name": "Northern Mariana Islands", "code": "Northern Mariana Islands" }, { "name": "Northwest Territories", "code": "Northwest Territories" }, { "name": "Nova Scotia", "code": "Nova Scotia" }, { "name": "Nunavut", "code": "Nunavut" }, { "name": "Ohio", "code": "Ohio" }, { "name": "Oklahoma", "code": "Oklahoma" }, { "name": "Ontario", "code": "Ontario" }, { "name": "Oregon", "code": "Oregon" }, { "name": "Pennsylvania", "code": "Pennsylvania" }, { "name": "Prince Edward Island", "code": "Prince Edward Island" }, { "name": "Puerto Rico", "code": "Puerto Rico" }, { "name": "Quebec", "code": "Quebec" }, { "name": "Rhode Island", "code": "Rhode Island" }, { "name": "Saskatchewan", "code": "Saskatchewan" }, { "name": "South Carolina", "code": "South Carolina" }, { "name": "South Dakota", "code": "South Dakota" }, { "name": "Tennessee", "code": "Tennessee" }, { "name": "Texas", "code": "Texas" }, { "name": "United States Minor Outlying Islands", "code": "United States Minor Outlying Islands" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Utah", "code": "Utah" }, { "name": "Vermont", "code": "Vermont" }, { "name": "Virgin Islands, U.S.", "code": "Virgin Islands, U.S." }, { "name": "Virginia", "code": "Virginia" }, { "name": "Washington", "code": "Washington" }, { "name": "West Virginia", "code": "West Virginia" }, { "name": "Wisconsin", "code": "Wisconsin" }, { "name": "Wyoming", "code": "Wyoming" }, { "name": "Yukon", "code": "Yukon" } ], "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": "TO_MEASURE", "type": "esriFieldTypeDouble", "alias": "TO_MEASURE", "domain": null }, { "name": "TO_NETWORK_ROUTE_ID", "type": "esriFieldTypeGUID", "alias": "TO_NETWORK_ROUTE_ID", "length": 38, "domain": null }, { "name": "TO_NETWORK_ROUTE_NAME", "type": "esriFieldTypeString", "alias": "TO_NETWORK_ROUTE_NAME", "length": 255, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeGUID", "alias": "UNIQUE_ID", "length": 38, "domain": null }, { "name": "VISUAL_OFFSET", "type": "esriFieldTypeDouble", "alias": "VISUAL_OFFSET", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape_Length", "type": "esriFieldTypeDouble", "alias": "Shape_Length", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I239TO_NETWORK_R", "fields": "TO_NETWORK_ROUTE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I239UNIQUE_ID", "fields": "UNIQUE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I239FROM_DATE3", "fields": "FROM_DATE,TO_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I239FROM_NETWORK", "fields": "FROM_NETWORK_ROUTE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G239PIPELINE_ID", "fields": "PIPELINE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "PIPELINE", "relatedTableId": 42, "role": "esriRelRoleDestination", "keyField": "PIPELINE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape_Length", "units": "esriDecimalDegrees" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "0b6ea39373374d868246e69ee986e7a0" }