{ "currentVersion": 10.81, "id": 1, "name": "GSCriticalSurvey", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "GSValvesCritical", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentValveID", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1706155951000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "RoadwayBoxCond", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RoadwayBoxCond", "type": "esriFieldTypeString", "alias": "Roadway Box Condition", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "RoadwayBoxCond" }, { "name": "GlandCond", "type": "esriFieldTypeString", "alias": "Gland/Lube Condition", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "GlandCond" }, { "name": "ValveStemCond", "type": "esriFieldTypeString", "alias": "Valve Stem Condition", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ValveStemCond" }, { "name": "ValveStatusFound", "type": "esriFieldTypeString", "alias": "Valve Status Found", "domain": { "type": "codedValue", "name": "gCritValveStatus", "description": "", "codedValues": [ { "name": "On", "code": "On" }, { "name": "Off", "code": "Off" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ValveStatusFound" }, { "name": "ValveStatusLeft", "type": "esriFieldTypeString", "alias": "Valve Status Left", "domain": { "type": "codedValue", "name": "gCritValveStatus", "description": "", "codedValues": [ { "name": "On", "code": "On" }, { "name": "Off", "code": "Off" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ValveStatusLeft" }, { "name": "TestReason", "type": "esriFieldTypeString", "alias": "Reason for Test", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TestReason" }, { "name": "LeakTest", "type": "esriFieldTypeString", "alias": "Is There a Leak?", "domain": { "type": "codedValue", "name": "gYesNo", "description": "Regulator Inspection Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LeakTest" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspector" }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInspected" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Pressure", "type": "esriFieldTypeString", "alias": "Pressure", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Pressure" }, { "name": "LeakSheet", "type": "esriFieldTypeString", "alias": "Was a Leak Sheet Created?", "domain": { "type": "codedValue", "name": "gYesNo", "description": "Regulator Inspection Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LeakSheet" }, { "name": "ValveOperated", "type": "esriFieldTypeString", "alias": "Valve Operated?", "domain": { "type": "codedValue", "name": "gYesNo", "description": "Regulator Inspection Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ValveOperated" }, { "name": "ReasonNotOperated", "type": "esriFieldTypeString", "alias": "Reason Not Operated:", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReasonNotOperated" }, { "name": "EMAILSENT", "type": "esriFieldTypeSmallInteger", "alias": "EMAILSENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EMAILSENT" }, { "name": "ReportLink", "type": "esriFieldTypeString", "alias": "Report Link", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ReportLink" }, { "name": "InspectorOther", "type": "esriFieldTypeString", "alias": "Inspector Other", "domain": null, "editable": true, "nullable": true, "length": 99, "defaultValue": null, "modelName": "InspectorOther" }, { "name": "ParentValveID", "type": "esriFieldTypeString", "alias": "ParentValveID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParentValveID" }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Street" }, { "name": "School", "type": "esriFieldTypeString", "alias": "School", "domain": null, "editable": true, "nullable": true, "length": 99, "defaultValue": null, "modelName": "School" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Size" }, { "name": "Depth", "type": "esriFieldTypeString", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Depth" }, { "name": "Year", "type": "esriFieldTypeString", "alias": "Year", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Year" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "GSCriticalSurvey", "description": "", "prototype": { "attributes": { "Depth": null, "Size": null, "RoadwayBoxCond": null, "GlandCond": null, "ValveStemCond": null, "ValveStatusFound": null, "ValveStatusLeft": null, "TestReason": null, "LeakTest": null, "Inspector": null, "DateInspected": null, "Comments": null, "Year": null, "School": null, "Street": null, "ParentValveID": null, "InspectorOther": null, "Pressure": null, "LeakSheet": null, "ValveOperated": null, "ReasonNotOperated": null, "EMAILSENT": null, "ReportLink": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "1390c62b464046959a95615d71937be5" }