{ "currentVersion": 10.81, "id": 1, "name": "GSCriticalSurvey", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RoadwayBoxCond", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RoadwayBoxCond", "type": "esriFieldTypeString", "alias": "Roadway Box Condition", "length": 25, "domain": { "type": "codedValue", "name": "gPipeExp_Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlandCond", "type": "esriFieldTypeString", "alias": "Gland/Lube Condition", "length": 25, "domain": { "type": "codedValue", "name": "gPipeExp_Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ValveStemCond", "type": "esriFieldTypeString", "alias": "Valve Stem Condition", "length": 25, "domain": { "type": "codedValue", "name": "gPipeExp_Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ValveStatusFound", "type": "esriFieldTypeString", "alias": "Valve Status Found", "length": 10, "domain": { "type": "codedValue", "name": "gCritValveStatus", "description": "", "codedValues": [ { "name": "On", "code": "On" }, { "name": "Off", "code": "Off" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ValveStatusLeft", "type": "esriFieldTypeString", "alias": "Valve Status Left", "length": 10, "domain": { "type": "codedValue", "name": "gCritValveStatus", "description": "", "codedValues": [ { "name": "On", "code": "On" }, { "name": "Off", "code": "Off" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TestReason", "type": "esriFieldTypeString", "alias": "Reason for Test", "length": 25, "domain": { "type": "codedValue", "name": "gCritValveReason", "description": "", "codedValues": [ { "name": "Scheduled", "code": "Scheduled" }, { "name": "Minor Trouble", "code": "Minor" }, { "name": "Major Trouble", "code": "Major" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeakTest", "type": "esriFieldTypeString", "alias": "Is There a Leak?", "length": 10, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Regulator Inspection Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": { "type": "codedValue", "name": "CritValveInspector", "description": "", "codedValues": [ { "name": "Brian Short", "code": "BShort" }, { "name": "Floyd Napier", "code": "FNapier" }, { "name": "Chad Merz", "code": "CMerz" }, { "name": "John Novak", "code": "JNovak" }, { "name": "Darren Royer", "code": "DRoyer" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "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": "Pressure", "type": "esriFieldTypeString", "alias": "Pressure", "length": 50, "domain": { "type": "codedValue", "name": "GasDeliveryPressure", "description": "Gas Delivery Pressure", "codedValues": [ { "name": "Distribution Pressure", "code": "DP" }, { "name": "Intermediate Pressure", "code": "IP" }, { "name": "Medium Pressure", "code": "MP" }, { "name": "High Pressure", "code": "HP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeakSheet", "type": "esriFieldTypeString", "alias": "Was a Leak Sheet Created?", "length": 10, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Regulator Inspection Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ValveOperated", "type": "esriFieldTypeString", "alias": "Valve Operated?", "length": 10, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Regulator Inspection Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ReasonNotOperated", "type": "esriFieldTypeString", "alias": "Reason Not Operated:", "length": 255, "domain": null }, { "name": "EMAILSENT", "type": "esriFieldTypeSmallInteger", "alias": "EMAILSENT", "domain": null }, { "name": "ReportLink", "type": "esriFieldTypeString", "alias": "Report Link", "length": 250, "domain": null }, { "name": "InspectorOther", "type": "esriFieldTypeString", "alias": "Inspector Other", "length": 99, "domain": null }, { "name": "ParentValveID", "type": "esriFieldTypeString", "alias": "ParentValveID", "length": 50, "domain": null }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "length": 255, "domain": null }, { "name": "School", "type": "esriFieldTypeString", "alias": "School", "length": 99, "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 25, "domain": { "type": "codedValue", "name": "ValveSize", "description": "", "codedValues": [ { "name": "1/2\"", "code": "0.5" }, { "name": "3/4\"", "code": "0.75" }, { "name": "1\"", "code": "1" }, { "name": "1 1/8\"", "code": "1.125" }, { "name": "1 1/4\"", "code": "1.25" }, { "name": "1 1/2\"", "code": "1.5" }, { "name": "2\"", "code": "2" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" }, { "name": "12\"", "code": "12" }, { "name": "14\"", "code": "14" }, { "name": "Unknown", "code": "Unknown" }, { "name": "16\"", "code": "16" }, { "name": "24\"", "code": "24" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Depth", "type": "esriFieldTypeString", "alias": "Depth", "length": 25, "domain": null }, { "name": "Year", "type": "esriFieldTypeString", "alias": "Year", "length": 4, "domain": null } ], "indexes": [ { "name": "UUID_516", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1260ParentValve", "fields": "ParentValveID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_516", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GSValvesCritical", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentValveID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "9a13aaee06f840f98f8260e344bbef1d" }