{ "currentVersion": 10.81, "id": 1, "name": "GCD Details", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GCD_TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FSE_ID", "type": "esriFieldTypeString", "alias": "FSE_ID", "length": 4, "domain": null }, { "name": "GCD_TYPE", "type": "esriFieldTypeString", "alias": "GCD_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "gcdType_1", "description": "Grease Control Device Type", "codedValues": [ { "name": "Hydraulic Mechanical Grease Trap", "code": "Hydraulic Mechanical Grease Trap" }, { "name": "Gravity Grease Interceptor", "code": "Gravity Grease Interceptor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INT_EXT", "type": "esriFieldTypeString", "alias": "INT_EXT", "length": 10, "domain": { "type": "codedValue", "name": "gcdINT_EXT", "description": "", "codedValues": [ { "name": "Interior", "code": "Interior" }, { "name": "Exterior", "code": "Exterior" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ABOVE_BELOW", "type": "esriFieldTypeString", "alias": "ABOVE_BELOW", "length": 10, "domain": { "type": "codedValue", "name": "gcdAboveBelow", "description": "", "codedValues": [ { "name": "Above", "code": "Above" }, { "name": "Below", "code": "Below" }, { "name": "Unknown", "code": "ZZUnknown" }, { "name": "Not Applicable", "code": "ZZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeString", "alias": "SHAPE", "length": 12, "domain": { "type": "codedValue", "name": "fseSHAPE", "description": "", "codedValues": [ { "name": "Rectangle", "code": "Rectangle" }, { "name": "Cylinder", "code": "Cylinder" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINT_ACCESS", "type": "esriFieldTypeInteger", "alias": "MAINT_ACCESS", "domain": null }, { "name": "WASTE_GRINDER", "type": "esriFieldTypeInteger", "alias": "WASTE_GRINDER", "domain": { "type": "codedValue", "name": "fseYesNo", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SOLIDS_INTERCEPTOR", "type": "esriFieldTypeString", "alias": "SOLIDS_INTERCEPTOR", "length": 3, "domain": { "type": "codedValue", "name": "fesYes_No", "description": "Text Yes No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FOOD_SCREEN", "type": "esriFieldTypeInteger", "alias": "FOOD_SCREEN", "domain": { "type": "codedValue", "name": "fseYesNo", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "WIDTH_DIAM", "type": "esriFieldTypeDouble", "alias": "WIDTH_DIAM", "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "DEPTH", "domain": null }, { "name": "HYDRAULIC_CAPACITY", "type": "esriFieldTypeDouble", "alias": "HYDRAULIC_CAPACITY", "domain": null }, { "name": "RATED_CAPACITY", "type": "esriFieldTypeDouble", "alias": "RATED_CAPACITY", "domain": null }, { "name": "INLET_PIPE_VISIBLE", "type": "esriFieldTypeInteger", "alias": "INLET_PIPE_VISIBLE", "domain": { "type": "codedValue", "name": "fseYesNo", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INLET_PIPE_DEPTH", "type": "esriFieldTypeDouble", "alias": "INLET_PIPE_DEPTH", "domain": null }, { "name": "OUTLET_PIPE_VISIBLE", "type": "esriFieldTypeInteger", "alias": "OUTLET_PIPE_VISIBLE", "domain": { "type": "codedValue", "name": "fseYesNo", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTLET_PIPE_DEPTH", "type": "esriFieldTypeDouble", "alias": "OUTLET_PIPE_DEPTH", "domain": null }, { "name": "LOCATION_DESCRIP", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIP", "length": 100, "domain": null }, { "name": "FLOW_CONTROL_DEVICE", "type": "esriFieldTypeString", "alias": "FLOW_CONTROL_DEVICE", "length": 20, "domain": { "type": "codedValue", "name": "gcdFlowControlDevice", "description": "", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Missing", "code": "Missing" }, { "name": "Not Needed", "code": "Not Needed" }, { "name": "Not Visible Present", "code": "Not Visible" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AIR_VENT", "type": "esriFieldTypeInteger", "alias": "AIR_VENT", "domain": { "type": "codedValue", "name": "fseYesNo", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHARED", "type": "esriFieldTypeInteger", "alias": "SHARED", "domain": { "type": "codedValue", "name": "fseYesNo", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHER_FAC_SERVED", "type": "esriFieldTypeString", "alias": "OTHER_FAC_SERVED", "length": 100, "domain": null }, { "name": "RATED_CAPACITY_UNIT", "type": "esriFieldTypeString", "alias": "RATED_CAPACITY_UNIT", "length": 10, "domain": null }, { "name": "RATED_CAPACITY_SOURCE", "type": "esriFieldTypeString", "alias": "RATED_CAPACITY_SOURCE", "length": 20, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "gcdStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FSEGCD_Rel", "type": "esriFieldTypeGUID", "alias": "FSEGCD_Rel", "length": 38, "domain": null }, { "name": "GCD_ID", "type": "esriFieldTypeString", "alias": "GCD_ID", "length": 20, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "CONNECTED_DEVICES", "type": "esriFieldTypeString", "alias": "CONNECTED_DEVICES", "length": 250, "domain": null } ], "indexes": [ { "name": "R2095_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2095", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4862FSEGCD_Rel", "fields": "FSEGCD_Rel", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I4862FSE_ID", "fields": "FSE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "FSE", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FSEGCD_Rel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }