{ "currentVersion": 10.61, "id": 1, "name": "lisleedit.GIS.T_Sewer_Jetting", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspectedBy", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "InspectedBy", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 30, "domain": null }, { "name": "CleanFlush", "type": "esriFieldTypeSmallInteger", "alias": "Clean Flush", "domain": { "type": "codedValue", "name": "YES OR NO", "description": "", "codedValues": [ { "name": "Y", "code": 1 }, { "name": "N", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection", "type": "esriFieldTypeSmallInteger", "alias": "Inspection", "domain": { "type": "codedValue", "name": "YES OR NO", "description": "", "codedValues": [ { "name": "Y", "code": 1 }, { "name": "N", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Repairs", "type": "esriFieldTypeSmallInteger", "alias": "Repairs", "domain": { "type": "codedValue", "name": "YES OR NO", "description": "", "codedValues": [ { "name": "Y", "code": 1 }, { "name": "N", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHFrom", "type": "esriFieldTypeString", "alias": "ManHoleFrom", "length": 6, "domain": null }, { "name": "MHTo", "type": "esriFieldTypeString", "alias": "ManHoleTo", "length": 6, "domain": null }, { "name": "InspctID1", "type": "esriFieldTypeSmallInteger", "alias": "Inspection1", "domain": { "type": "codedValue", "name": "SAN MAINT Inspect", "description": "Sanitary Maintenance Inspection Codes", "codedValues": [ { "name": "NO PROBLEMS", "code": 1 }, { "name": "ROOTS", "code": 2 }, { "name": "CRACKS", "code": 3 }, { "name": "CRUSHED", "code": 4 }, { "name": "OFFSET JOINTS", "code": 5 }, { "name": "GREASE", "code": 6 }, { "name": "SEDIMENT", "code": 7 }, { "name": "TUBERCULATION", "code": 8 }, { "name": "PROTRUDING LATERALS", "code": 9 }, { "name": "INFILTRATION", "code": 10 }, { "name": "DETERIORATED CHIMNEY", "code": 11 }, { "name": "DETERIORATED STRUCTURE", "code": 12 }, { "name": "BENCH PROBLEM", "code": 13 }, { "name": "FRAME PROBLEM", "code": 14 }, { "name": "LID PROBLEM", "code": 15 }, { "name": "BLOCKAGE", "code": 16 }, { "name": "GASKET PROBLEM", "code": 17 }, { "name": "RAISE / LOWER TO GRADE", "code": 18 }, { "name": "STEP PROBLEM", "code": 19 }, { "name": "SERVICE PROBLEMS", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspctID2", "type": "esriFieldTypeSmallInteger", "alias": "Inspection2", "domain": { "type": "codedValue", "name": "SAN MAINT Inspect", "description": "Sanitary Maintenance Inspection Codes", "codedValues": [ { "name": "NO PROBLEMS", "code": 1 }, { "name": "ROOTS", "code": 2 }, { "name": "CRACKS", "code": 3 }, { "name": "CRUSHED", "code": 4 }, { "name": "OFFSET JOINTS", "code": 5 }, { "name": "GREASE", "code": 6 }, { "name": "SEDIMENT", "code": 7 }, { "name": "TUBERCULATION", "code": 8 }, { "name": "PROTRUDING LATERALS", "code": 9 }, { "name": "INFILTRATION", "code": 10 }, { "name": "DETERIORATED CHIMNEY", "code": 11 }, { "name": "DETERIORATED STRUCTURE", "code": 12 }, { "name": "BENCH PROBLEM", "code": 13 }, { "name": "FRAME PROBLEM", "code": 14 }, { "name": "LID PROBLEM", "code": 15 }, { "name": "BLOCKAGE", "code": 16 }, { "name": "GASKET PROBLEM", "code": 17 }, { "name": "RAISE / LOWER TO GRADE", "code": 18 }, { "name": "STEP PROBLEM", "code": 19 }, { "name": "SERVICE PROBLEMS", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspctID3", "type": "esriFieldTypeSmallInteger", "alias": "Inspection3", "domain": { "type": "codedValue", "name": "SAN MAINT Inspect", "description": "Sanitary Maintenance Inspection Codes", "codedValues": [ { "name": "NO PROBLEMS", "code": 1 }, { "name": "ROOTS", "code": 2 }, { "name": "CRACKS", "code": 3 }, { "name": "CRUSHED", "code": 4 }, { "name": "OFFSET JOINTS", "code": 5 }, { "name": "GREASE", "code": 6 }, { "name": "SEDIMENT", "code": 7 }, { "name": "TUBERCULATION", "code": 8 }, { "name": "PROTRUDING LATERALS", "code": 9 }, { "name": "INFILTRATION", "code": 10 }, { "name": "DETERIORATED CHIMNEY", "code": 11 }, { "name": "DETERIORATED STRUCTURE", "code": 12 }, { "name": "BENCH PROBLEM", "code": 13 }, { "name": "FRAME PROBLEM", "code": 14 }, { "name": "LID PROBLEM", "code": 15 }, { "name": "BLOCKAGE", "code": 16 }, { "name": "GASKET PROBLEM", "code": 17 }, { "name": "RAISE / LOWER TO GRADE", "code": 18 }, { "name": "STEP PROBLEM", "code": 19 }, { "name": "SERVICE PROBLEMS", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspctID4", "type": "esriFieldTypeSmallInteger", "alias": "Inspection4", "domain": { "type": "codedValue", "name": "SAN MAINT Inspect", "description": "Sanitary Maintenance Inspection Codes", "codedValues": [ { "name": "NO PROBLEMS", "code": 1 }, { "name": "ROOTS", "code": 2 }, { "name": "CRACKS", "code": 3 }, { "name": "CRUSHED", "code": 4 }, { "name": "OFFSET JOINTS", "code": 5 }, { "name": "GREASE", "code": 6 }, { "name": "SEDIMENT", "code": 7 }, { "name": "TUBERCULATION", "code": 8 }, { "name": "PROTRUDING LATERALS", "code": 9 }, { "name": "INFILTRATION", "code": 10 }, { "name": "DETERIORATED CHIMNEY", "code": 11 }, { "name": "DETERIORATED STRUCTURE", "code": 12 }, { "name": "BENCH PROBLEM", "code": 13 }, { "name": "FRAME PROBLEM", "code": 14 }, { "name": "LID PROBLEM", "code": 15 }, { "name": "BLOCKAGE", "code": 16 }, { "name": "GASKET PROBLEM", "code": 17 }, { "name": "RAISE / LOWER TO GRADE", "code": 18 }, { "name": "STEP PROBLEM", "code": 19 }, { "name": "SERVICE PROBLEMS", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspctID5", "type": "esriFieldTypeSmallInteger", "alias": "Inspection5", "domain": { "type": "codedValue", "name": "SAN MAINT Inspect", "description": "Sanitary Maintenance Inspection Codes", "codedValues": [ { "name": "NO PROBLEMS", "code": 1 }, { "name": "ROOTS", "code": 2 }, { "name": "CRACKS", "code": 3 }, { "name": "CRUSHED", "code": 4 }, { "name": "OFFSET JOINTS", "code": 5 }, { "name": "GREASE", "code": 6 }, { "name": "SEDIMENT", "code": 7 }, { "name": "TUBERCULATION", "code": 8 }, { "name": "PROTRUDING LATERALS", "code": 9 }, { "name": "INFILTRATION", "code": 10 }, { "name": "DETERIORATED CHIMNEY", "code": 11 }, { "name": "DETERIORATED STRUCTURE", "code": 12 }, { "name": "BENCH PROBLEM", "code": 13 }, { "name": "FRAME PROBLEM", "code": 14 }, { "name": "LID PROBLEM", "code": 15 }, { "name": "BLOCKAGE", "code": 16 }, { "name": "GASKET PROBLEM", "code": 17 }, { "name": "RAISE / LOWER TO GRADE", "code": 18 }, { "name": "STEP PROBLEM", "code": 19 }, { "name": "SERVICE PROBLEMS", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspctID6", "type": "esriFieldTypeSmallInteger", "alias": "Inspection6", "domain": { "type": "codedValue", "name": "SAN MAINT Inspect", "description": "Sanitary Maintenance Inspection Codes", "codedValues": [ { "name": "NO PROBLEMS", "code": 1 }, { "name": "ROOTS", "code": 2 }, { "name": "CRACKS", "code": 3 }, { "name": "CRUSHED", "code": 4 }, { "name": "OFFSET JOINTS", "code": 5 }, { "name": "GREASE", "code": 6 }, { "name": "SEDIMENT", "code": 7 }, { "name": "TUBERCULATION", "code": 8 }, { "name": "PROTRUDING LATERALS", "code": 9 }, { "name": "INFILTRATION", "code": 10 }, { "name": "DETERIORATED CHIMNEY", "code": 11 }, { "name": "DETERIORATED STRUCTURE", "code": 12 }, { "name": "BENCH PROBLEM", "code": 13 }, { "name": "FRAME PROBLEM", "code": 14 }, { "name": "LID PROBLEM", "code": 15 }, { "name": "BLOCKAGE", "code": 16 }, { "name": "GASKET PROBLEM", "code": 17 }, { "name": "RAISE / LOWER TO GRADE", "code": 18 }, { "name": "STEP PROBLEM", "code": 19 }, { "name": "SERVICE PROBLEMS", "code": 20 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairID1", "type": "esriFieldTypeSmallInteger", "alias": "Repair", "domain": { "type": "codedValue", "name": "SAN MAINT Repair", "description": "Sanitary Maintenance Repair Codes", "codedValues": [ { "name": "REPLACE STEPS", "code": 1 }, { "name": "REPLACE FRAME", "code": 2 }, { "name": "REPLACE LID", "code": 3 }, { "name": "REPLACE GASKETS", "code": 4 }, { "name": "REPLACE RINGS", "code": 5 }, { "name": "SEAL RINGS - INSIDE", "code": 6 }, { "name": "SEAL RINGS - OUTSIDE", "code": 7 }, { "name": "REPAIR BENCH", "code": 8 }, { "name": "SEAL STRUCTURE - INSIDE", "code": 9 }, { "name": "SEAL STRUCTURE - OUTSIDE", "code": 10 }, { "name": "REPAIR STRUCTURE WALL", "code": 11 }, { "name": "REPAIR END SECTION", "code": 12 }, { "name": "REPLACE END SECTION", "code": 13 }, { "name": "REMOVE SEDIMENT / DEBRIS / GREASE", "code": 14 }, { "name": "RAISE TO GRADE", "code": 15 }, { "name": "LOWER TO GRADE", "code": 16 }, { "name": "REMOVE BLOCKAGE", "code": 17 }, { "name": "CUT ROOTS", "code": 18 }, { "name": "CHEMICALLY REMOVE ROOTS", "code": 19 }, { "name": "REPLACE PIPE SECTION", "code": 20 }, { "name": "CLAMP REPAIR", "code": 21 }, { "name": "SEAL PIPE JOINTS", "code": 22 }, { "name": "REMOVE PROTRUDING LATERAL", "code": 23 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairID2", "type": "esriFieldTypeSmallInteger", "alias": "Repair2", "domain": { "type": "codedValue", "name": "SAN MAINT Repair", "description": "Sanitary Maintenance Repair Codes", "codedValues": [ { "name": "REPLACE STEPS", "code": 1 }, { "name": "REPLACE FRAME", "code": 2 }, { "name": "REPLACE LID", "code": 3 }, { "name": "REPLACE GASKETS", "code": 4 }, { "name": "REPLACE RINGS", "code": 5 }, { "name": "SEAL RINGS - INSIDE", "code": 6 }, { "name": "SEAL RINGS - OUTSIDE", "code": 7 }, { "name": "REPAIR BENCH", "code": 8 }, { "name": "SEAL STRUCTURE - INSIDE", "code": 9 }, { "name": "SEAL STRUCTURE - OUTSIDE", "code": 10 }, { "name": "REPAIR STRUCTURE WALL", "code": 11 }, { "name": "REPAIR END SECTION", "code": 12 }, { "name": "REPLACE END SECTION", "code": 13 }, { "name": "REMOVE SEDIMENT / DEBRIS / GREASE", "code": 14 }, { "name": "RAISE TO GRADE", "code": 15 }, { "name": "LOWER TO GRADE", "code": 16 }, { "name": "REMOVE BLOCKAGE", "code": 17 }, { "name": "CUT ROOTS", "code": 18 }, { "name": "CHEMICALLY REMOVE ROOTS", "code": 19 }, { "name": "REPLACE PIPE SECTION", "code": 20 }, { "name": "CLAMP REPAIR", "code": 21 }, { "name": "SEAL PIPE JOINTS", "code": 22 }, { "name": "REMOVE PROTRUDING LATERAL", "code": 23 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairID3", "type": "esriFieldTypeSmallInteger", "alias": "Repair3", "domain": { "type": "codedValue", "name": "SAN MAINT Repair", "description": "Sanitary Maintenance Repair Codes", "codedValues": [ { "name": "REPLACE STEPS", "code": 1 }, { "name": "REPLACE FRAME", "code": 2 }, { "name": "REPLACE LID", "code": 3 }, { "name": "REPLACE GASKETS", "code": 4 }, { "name": "REPLACE RINGS", "code": 5 }, { "name": "SEAL RINGS - INSIDE", "code": 6 }, { "name": "SEAL RINGS - OUTSIDE", "code": 7 }, { "name": "REPAIR BENCH", "code": 8 }, { "name": "SEAL STRUCTURE - INSIDE", "code": 9 }, { "name": "SEAL STRUCTURE - OUTSIDE", "code": 10 }, { "name": "REPAIR STRUCTURE WALL", "code": 11 }, { "name": "REPAIR END SECTION", "code": 12 }, { "name": "REPLACE END SECTION", "code": 13 }, { "name": "REMOVE SEDIMENT / DEBRIS / GREASE", "code": 14 }, { "name": "RAISE TO GRADE", "code": 15 }, { "name": "LOWER TO GRADE", "code": 16 }, { "name": "REMOVE BLOCKAGE", "code": 17 }, { "name": "CUT ROOTS", "code": 18 }, { "name": "CHEMICALLY REMOVE ROOTS", "code": 19 }, { "name": "REPLACE PIPE SECTION", "code": 20 }, { "name": "CLAMP REPAIR", "code": 21 }, { "name": "SEAL PIPE JOINTS", "code": 22 }, { "name": "REMOVE PROTRUDING LATERAL", "code": 23 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairID4", "type": "esriFieldTypeSmallInteger", "alias": "Repair4", "domain": { "type": "codedValue", "name": "SAN MAINT Repair", "description": "Sanitary Maintenance Repair Codes", "codedValues": [ { "name": "REPLACE STEPS", "code": 1 }, { "name": "REPLACE FRAME", "code": 2 }, { "name": "REPLACE LID", "code": 3 }, { "name": "REPLACE GASKETS", "code": 4 }, { "name": "REPLACE RINGS", "code": 5 }, { "name": "SEAL RINGS - INSIDE", "code": 6 }, { "name": "SEAL RINGS - OUTSIDE", "code": 7 }, { "name": "REPAIR BENCH", "code": 8 }, { "name": "SEAL STRUCTURE - INSIDE", "code": 9 }, { "name": "SEAL STRUCTURE - OUTSIDE", "code": 10 }, { "name": "REPAIR STRUCTURE WALL", "code": 11 }, { "name": "REPAIR END SECTION", "code": 12 }, { "name": "REPLACE END SECTION", "code": 13 }, { "name": "REMOVE SEDIMENT / DEBRIS / GREASE", "code": 14 }, { "name": "RAISE TO GRADE", "code": 15 }, { "name": "LOWER TO GRADE", "code": 16 }, { "name": "REMOVE BLOCKAGE", "code": 17 }, { "name": "CUT ROOTS", "code": 18 }, { "name": "CHEMICALLY REMOVE ROOTS", "code": 19 }, { "name": "REPLACE PIPE SECTION", "code": 20 }, { "name": "CLAMP REPAIR", "code": 21 }, { "name": "SEAL PIPE JOINTS", "code": 22 }, { "name": "REMOVE PROTRUDING LATERAL", "code": 23 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairID5", "type": "esriFieldTypeSmallInteger", "alias": "Repair5", "domain": { "type": "codedValue", "name": "SAN MAINT Repair", "description": "Sanitary Maintenance Repair Codes", "codedValues": [ { "name": "REPLACE STEPS", "code": 1 }, { "name": "REPLACE FRAME", "code": 2 }, { "name": "REPLACE LID", "code": 3 }, { "name": "REPLACE GASKETS", "code": 4 }, { "name": "REPLACE RINGS", "code": 5 }, { "name": "SEAL RINGS - INSIDE", "code": 6 }, { "name": "SEAL RINGS - OUTSIDE", "code": 7 }, { "name": "REPAIR BENCH", "code": 8 }, { "name": "SEAL STRUCTURE - INSIDE", "code": 9 }, { "name": "SEAL STRUCTURE - OUTSIDE", "code": 10 }, { "name": "REPAIR STRUCTURE WALL", "code": 11 }, { "name": "REPAIR END SECTION", "code": 12 }, { "name": "REPLACE END SECTION", "code": 13 }, { "name": "REMOVE SEDIMENT / DEBRIS / GREASE", "code": 14 }, { "name": "RAISE TO GRADE", "code": 15 }, { "name": "LOWER TO GRADE", "code": 16 }, { "name": "REMOVE BLOCKAGE", "code": 17 }, { "name": "CUT ROOTS", "code": 18 }, { "name": "CHEMICALLY REMOVE ROOTS", "code": 19 }, { "name": "REPLACE PIPE SECTION", "code": 20 }, { "name": "CLAMP REPAIR", "code": 21 }, { "name": "SEAL PIPE JOINTS", "code": 22 }, { "name": "REMOVE PROTRUDING LATERAL", "code": 23 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairID6", "type": "esriFieldTypeSmallInteger", "alias": "Repair6", "domain": { "type": "codedValue", "name": "SAN MAINT Repair", "description": "Sanitary Maintenance Repair Codes", "codedValues": [ { "name": "REPLACE STEPS", "code": 1 }, { "name": "REPLACE FRAME", "code": 2 }, { "name": "REPLACE LID", "code": 3 }, { "name": "REPLACE GASKETS", "code": 4 }, { "name": "REPLACE RINGS", "code": 5 }, { "name": "SEAL RINGS - INSIDE", "code": 6 }, { "name": "SEAL RINGS - OUTSIDE", "code": 7 }, { "name": "REPAIR BENCH", "code": 8 }, { "name": "SEAL STRUCTURE - INSIDE", "code": 9 }, { "name": "SEAL STRUCTURE - OUTSIDE", "code": 10 }, { "name": "REPAIR STRUCTURE WALL", "code": 11 }, { "name": "REPAIR END SECTION", "code": 12 }, { "name": "REPLACE END SECTION", "code": 13 }, { "name": "REMOVE SEDIMENT / DEBRIS / GREASE", "code": 14 }, { "name": "RAISE TO GRADE", "code": 15 }, { "name": "LOWER TO GRADE", "code": 16 }, { "name": "REMOVE BLOCKAGE", "code": 17 }, { "name": "CUT ROOTS", "code": 18 }, { "name": "CHEMICALLY REMOVE ROOTS", "code": 19 }, { "name": "REPLACE PIPE SECTION", "code": 20 }, { "name": "CLAMP REPAIR", "code": 21 }, { "name": "SEAL PIPE JOINTS", "code": 22 }, { "name": "REMOVE PROTRUDING LATERAL", "code": 23 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Ndeidstrm", "type": "esriFieldTypeDouble", "alias": "Ndeidstrm", "domain": null }, { "name": "Strmpipid", "type": "esriFieldTypeDouble", "alias": "Strmpipid", "domain": null }, { "name": "JettingDate", "type": "esriFieldTypeDate", "alias": "Jetting Date", "length": 8, "domain": null }, { "name": "JettedBy", "type": "esriFieldTypeString", "alias": "JettedBy", "length": 50, "domain": { "type": "codedValue", "name": "JettedBy", "description": "Jetted By", "codedValues": [ { "name": "Lisle", "code": "Lisle" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProgramYear", "type": "esriFieldTypeDouble", "alias": "ProgramYear", "domain": null }, { "name": "Picture", "type": "esriFieldTypeRaster", "alias": "Picture", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1402_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "sde_rix_6", "fields": "Picture", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1402", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1402", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "lisleedit.GIS.storm_MAINS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Strmpipid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "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 }