{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "CPSS Field Data", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID (CP Testing Station)", "length": 255, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "Temperature", "type": "esriFieldTypeDouble", "alias": "Temperature", "domain": null }, { "name": "Weather", "type": "esriFieldTypeString", "alias": "Weather", "length": 255, "domain": { "type": "codedValue", "name": "rwDomainCPTS_Weather", "description": "Weather while conducting cathodic protection testing station read", "codedValues": [ { "name": "Sunny", "code": "Sunny" }, { "name": "Partly Cloudy", "code": "Partly Cloudy" }, { "name": "Cloudy", "code": "Cloudy" }, { "name": "Rain", "code": "Rain" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Stationing", "type": "esriFieldTypeString", "alias": "Stationing", "length": 255, "domain": null }, { "name": "TS_Style", "type": "esriFieldTypeString", "alias": "TS Style", "length": 255, "domain": { "type": "codedValue", "name": "rwDomainCPTS_Style", "description": "Type of cathodic protection testing station", "codedValues": [ { "name": "Flush", "code": "Flush" }, { "name": "Post", "code": "Post" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TS_Status", "type": "esriFieldTypeString", "alias": "TS Status", "length": 255, "domain": { "type": "codedValue", "name": "rwDomainCPTS_Status", "description": "Status of cathodic protection testing station", "codedValues": [ { "name": "Complete", "code": "Complete" }, { "name": "Broken", "code": "Broken" }, { "name": "Unable to Locate", "code": "Unable to Locate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TC_Required", "type": "esriFieldTypeString", "alias": "Traffic Control Req'd", "length": 255, "domain": { "type": "codedValue", "name": "rwDomainYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Access_Required", "type": "esriFieldTypeString", "alias": "Access Required", "length": 255, "domain": { "type": "codedValue", "name": "rwDomainYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConnectionWire_AWG_1", "type": "esriFieldTypeSmallInteger", "alias": "Connection/Wire: AWG - 1", "domain": null }, { "name": "ConnectionWire_Color_1", "type": "esriFieldTypeString", "alias": "Connection/Wire: Color - 1", "length": 255, "domain": null }, { "name": "Structure_1", "type": "esriFieldTypeString", "alias": "Structure - 1", "length": 255, "domain": null }, { "name": "PipelineNative_1", "type": "esriFieldTypeSmallInteger", "alias": "Pipeline Native (mV) - 1", "domain": null }, { "name": "CouponNative_1", "type": "esriFieldTypeSmallInteger", "alias": "Coupon Native (mV) - 1", "domain": null }, { "name": "PortRef_On_1", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): On - 1", "domain": null }, { "name": "PortRef_InstantOff_1", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Instant Off - 1", "domain": null }, { "name": "PortRef_CouponOn_1", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon On - 1", "domain": null }, { "name": "PortRef_CouponInstantOff_1", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon Instant Off - 1", "domain": null }, { "name": "PortRef_Polarization_1", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Polarization - 1", "domain": null }, { "name": "PermRef_On_1", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): On - 1", "domain": null }, { "name": "PermRef_InstantOff_1", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Instant Off - 1", "domain": null }, { "name": "PermRef_CouponOn_1", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon On - 1", "domain": null }, { "name": "PermRef_CouponInstantOff_1", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon Instant Off - 1", "domain": null }, { "name": "PermRef_Polarization_1", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Polarization - 1", "domain": null }, { "name": "AnodeOCP_1", "type": "esriFieldTypeSmallInteger", "alias": "Anode OCP (mV) - 1", "domain": null }, { "name": "AnodeCurrent_1", "type": "esriFieldTypeSmallInteger", "alias": "Anode Current (mA) - 1", "domain": null }, { "name": "ConnectionWire_AWG_2", "type": "esriFieldTypeSmallInteger", "alias": "Connection/Wire: AWG - 2", "domain": null }, { "name": "ConnectionWire_Color_2", "type": "esriFieldTypeString", "alias": "Connection/Wire: Color - 2", "length": 255, "domain": null }, { "name": "Structure_2", "type": "esriFieldTypeString", "alias": "Structure - 2", "length": 255, "domain": null }, { "name": "PipelineNative_2", "type": "esriFieldTypeSmallInteger", "alias": "Pipeline Native (mV) - 2", "domain": null }, { "name": "CouponNative_2", "type": "esriFieldTypeSmallInteger", "alias": "Coupon Native (mV) - 2", "domain": null }, { "name": "PortRef_On_2", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): On - 2", "domain": null }, { "name": "PortRef_InstantOff_2", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Instant Off - 2", "domain": null }, { "name": "PortRef_CouponOn_2", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon On - 2", "domain": null }, { "name": "PortRef_CouponInstantOff_2", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon Instant Off - 2", "domain": null }, { "name": "PortRef_Polarization_2", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Polarization - 2", "domain": null }, { "name": "PermRef_On_2", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): On - 2", "domain": null }, { "name": "PermRef_InstantOff_2", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Instant Off - 2", "domain": null }, { "name": "PermRef_CouponOn_2", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon On - 2", "domain": null }, { "name": "PermRef_CouponInstantOff_2", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon Instant Off - 2", "domain": null }, { "name": "PermRef_Polarization_2", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Polarization - 2", "domain": null }, { "name": "AnodeOCP_2", "type": "esriFieldTypeSmallInteger", "alias": "Anode OCP (mV) - 2", "domain": null }, { "name": "AnodeCurrent_2", "type": "esriFieldTypeSmallInteger", "alias": "Anode Current (mA) - 2", "domain": null }, { "name": "ConnectionWire_AWG_3", "type": "esriFieldTypeSmallInteger", "alias": "Connection/Wire: AWG - 3", "domain": null }, { "name": "ConnectionWire_Color_3", "type": "esriFieldTypeString", "alias": "Connection/Wire: Color - 3", "length": 255, "domain": null }, { "name": "Structure_3", "type": "esriFieldTypeString", "alias": "Structure - 3", "length": 255, "domain": null }, { "name": "PipelineNative_3", "type": "esriFieldTypeSmallInteger", "alias": "Pipeline Native (mV) - 3", "domain": null }, { "name": "CouponNative_3", "type": "esriFieldTypeSmallInteger", "alias": "Coupon Native (mV) - 3", "domain": null }, { "name": "PortRef_On_3", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): On - 3", "domain": null }, { "name": "PortRef_InstantOff_3", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Instant Off - 3", "domain": null }, { "name": "PortRef_CouponOn_3", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon On - 3", "domain": null }, { "name": "PortRef_CouponInstantOff_3", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon Instant Off - 3", "domain": null }, { "name": "PortRef_Polarization_3", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Polarization - 3", "domain": null }, { "name": "PermRef_On_3", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): On - 3", "domain": null }, { "name": "PermRef_InstantOff_3", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Instant Off - 3", "domain": null }, { "name": "PermRef_CouponOn_3", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon On - 3", "domain": null }, { "name": "PermRef_CouponInstantOff_3", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon Instant Off - 3", "domain": null }, { "name": "PermRef_Polarization_3", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Polarization - 3", "domain": null }, { "name": "AnodeOCP_3", "type": "esriFieldTypeSmallInteger", "alias": "Anode OCP (mV) - 3", "domain": null }, { "name": "AnodeCurrent_3", "type": "esriFieldTypeSmallInteger", "alias": "Anode Current (mA) - 3", "domain": null }, { "name": "ConnectionWire_AWG_4", "type": "esriFieldTypeSmallInteger", "alias": "Connection/Wire: AWG - 4", "domain": null }, { "name": "ConnectionWire_Color_4", "type": "esriFieldTypeString", "alias": "Connection/Wire: Color - 4", "length": 255, "domain": null }, { "name": "Structure_4", "type": "esriFieldTypeString", "alias": "Structure - 4", "length": 255, "domain": null }, { "name": "PipelineNative_4", "type": "esriFieldTypeSmallInteger", "alias": "Pipeline Native (mV) - 4", "domain": null }, { "name": "CouponNative_4", "type": "esriFieldTypeSmallInteger", "alias": "Coupon Native (mV) - 4", "domain": null }, { "name": "PortRef_On_4", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): On - 4", "domain": null }, { "name": "PortRef_InstantOff_4", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Instant Off - 4", "domain": null }, { "name": "PortRef_CouponOn_4", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon On - 4", "domain": null }, { "name": "PortRef_CouponInstantOff_4", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon Instant Off - 4", "domain": null }, { "name": "PortRef_Polarization_4", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Polarization - 4", "domain": null }, { "name": "PermRef_On_4", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): On - 4", "domain": null }, { "name": "PermRef_InstantOff_4", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Instant Off - 4", "domain": null }, { "name": "PermRef_CouponOn_4", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon On - 4", "domain": null }, { "name": "PermRef_CouponInstantOff_4", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon Instant Off - 4", "domain": null }, { "name": "PermRef_Polarization_4", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Polarization - 4", "domain": null }, { "name": "AnodeOCP_4", "type": "esriFieldTypeSmallInteger", "alias": "Anode OCP (mV) - 4", "domain": null }, { "name": "AnodeCurrent_4", "type": "esriFieldTypeSmallInteger", "alias": "Anode Current (mA) - 4", "domain": null }, { "name": "ConnectionWire_AWG_5", "type": "esriFieldTypeSmallInteger", "alias": "Connection/Wire: AWG - 5", "domain": null }, { "name": "ConnectionWire_Color_5", "type": "esriFieldTypeString", "alias": "Connection/Wire: Color - 5", "length": 255, "domain": null }, { "name": "Structure_5", "type": "esriFieldTypeString", "alias": "Structure - 5", "length": 255, "domain": null }, { "name": "PipelineNative_5", "type": "esriFieldTypeSmallInteger", "alias": "Pipeline Native (mV) - 5", "domain": null }, { "name": "CouponNative_5", "type": "esriFieldTypeSmallInteger", "alias": "Coupon Native (mV) - 5", "domain": null }, { "name": "PortRef_On_5", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): On - 5", "domain": null }, { "name": "PortRef_InstantOff_5", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Instant Off - 5", "domain": null }, { "name": "PortRef_CouponOn_5", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon On - 5", "domain": null }, { "name": "PortRef_CouponInstantOff_5", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon Instant Off - 5", "domain": null }, { "name": "PortRef_Polarization_5", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Polarization - 5", "domain": null }, { "name": "PermRef_On_5", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): On - 5", "domain": null }, { "name": "PermRef_InstantOff_5", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Instant Off - 5", "domain": null }, { "name": "PermRef_CouponOn_5", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon On - 5", "domain": null }, { "name": "PermRef_CouponInstantOff_5", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon Instant Off - 5", "domain": null }, { "name": "PermRef_Polarization_5", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Polarization - 5", "domain": null }, { "name": "AnodeOCP_5", "type": "esriFieldTypeSmallInteger", "alias": "Anode OCP (mV) - 5", "domain": null }, { "name": "AnodeCurrent_5", "type": "esriFieldTypeSmallInteger", "alias": "Anode Current (mA) - 5", "domain": null }, { "name": "ConnectionWire_AWG_6", "type": "esriFieldTypeSmallInteger", "alias": "Connection/Wire: AWG - 6", "domain": null }, { "name": "ConnectionWire_Color_6", "type": "esriFieldTypeString", "alias": "Connection/Wire: Color - 6", "length": 255, "domain": null }, { "name": "Structure_6", "type": "esriFieldTypeString", "alias": "Structure - 6", "length": 255, "domain": null }, { "name": "PipelineNative_6", "type": "esriFieldTypeSmallInteger", "alias": "Pipeline Native (mV) - 6", "domain": null }, { "name": "CouponNative_6", "type": "esriFieldTypeSmallInteger", "alias": "Coupon Native (mV) - 6", "domain": null }, { "name": "PortRef_On_6", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): On - 6", "domain": null }, { "name": "PortRef_InstantOff_6", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Instant Off - 6", "domain": null }, { "name": "PortRef_CouponOn_6", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon On - 6", "domain": null }, { "name": "PortRef_CouponInstantOff_6", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Coupon Instant Off - 6", "domain": null }, { "name": "PortRef_Polarization_6", "type": "esriFieldTypeSmallInteger", "alias": "Portable Reference (mV): Polarization - 6", "domain": null }, { "name": "PermRef_On_6", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): On - 6", "domain": null }, { "name": "PermRef_InstantOff_6", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Instant Off - 6", "domain": null }, { "name": "PermRef_CouponOn_6", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon On - 6", "domain": null }, { "name": "PermRef_CouponInstantOff_6", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Coupon Instant Off - 6", "domain": null }, { "name": "PermRef_Polarization_6", "type": "esriFieldTypeSmallInteger", "alias": "Permenant Reference (mV): Polarization - 6", "domain": null }, { "name": "AnodeOCP_6", "type": "esriFieldTypeSmallInteger", "alias": "Anode OCP (mV) - 6", "domain": null }, { "name": "AnodeCurrent_6", "type": "esriFieldTypeSmallInteger", "alias": "Anode Current (mA) - 6", "domain": null }, { "name": "Damage", "type": "esriFieldTypeString", "alias": "Damage Description", "length": 255, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shunt1", "type": "esriFieldTypeDouble", "alias": "Shunt (mV) - 1", "domain": null }, { "name": "Shunt2", "type": "esriFieldTypeDouble", "alias": "Shunt (mV) - 2", "domain": null }, { "name": "Shunt3", "type": "esriFieldTypeDouble", "alias": "Shunt (mV) - 3", "domain": null }, { "name": "Shunt4", "type": "esriFieldTypeDouble", "alias": "Shunt (mV) - 4", "domain": null }, { "name": "Shunt5", "type": "esriFieldTypeDouble", "alias": "Shunt (mV) - 5", "domain": null }, { "name": "Shunt6", "type": "esriFieldTypeDouble", "alias": "Shunt (mV) - 6", "domain": null }, { "name": "ShuntRating1", "type": "esriFieldTypeDouble", "alias": "Shunt Rating - 1", "domain": null }, { "name": "ShuntRating2", "type": "esriFieldTypeDouble", "alias": "Shunt Rating - 2", "domain": null }, { "name": "ShuntRating3", "type": "esriFieldTypeDouble", "alias": "Shunt Rating - 3", "domain": null }, { "name": "ShuntRating4", "type": "esriFieldTypeDouble", "alias": "Shunt Rating - 4", "domain": null }, { "name": "ShuntRating5", "type": "esriFieldTypeDouble", "alias": "Shunt Rating - 5", "domain": null }, { "name": "ShuntRating6", "type": "esriFieldTypeDouble", "alias": "Shunt Rating - 6", "domain": null }, { "name": "ACPotential1", "type": "esriFieldTypeDouble", "alias": "AC Potential (VAC) - 1", "domain": null }, { "name": "ACPotential2", "type": "esriFieldTypeDouble", "alias": "AC Potential (VAC) - 2", "domain": null }, { "name": "ACPotential3", "type": "esriFieldTypeDouble", "alias": "AC Potential (VAC) - 3", "domain": null }, { "name": "ACPotential4", "type": "esriFieldTypeDouble", "alias": "AC Potential (VAC) - 4", "domain": null }, { "name": "ACPotential5", "type": "esriFieldTypeDouble", "alias": "AC Potential (VAC) - 5", "domain": null }, { "name": "ACPotential6", "type": "esriFieldTypeDouble", "alias": "AC Potential (VAC) - 6", "domain": null } ], "indexes": [ { "name": "R789_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_789", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_789", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3635_Facilit", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISTESTUSER.CP_Testing_Station", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DD1C903E-3EA6-4D36-8F29-06E6F37C577D}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9725cbaef52049bbaa04230f87c7cc58" }