{ "currentVersion": 10.81, "id": 1, "name": "GCD Details", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "FSE", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FSEGCD_Rel", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "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": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "GCD_TYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FSE_ID", "type": "esriFieldTypeString", "alias": "FSE_ID", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "FSE_ID" }, { "name": "GCD_TYPE", "type": "esriFieldTypeString", "alias": "GCD_TYPE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GCD_TYPE" }, { "name": "INT_EXT", "type": "esriFieldTypeString", "alias": "INT_EXT", "domain": { "type": "codedValue", "name": "gcdINT_EXT", "description": "", "codedValues": [ { "name": "Interior", "code": "Interior" }, { "name": "Exterior", "code": "Exterior" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INT_EXT" }, { "name": "ABOVE_BELOW", "type": "esriFieldTypeString", "alias": "ABOVE_BELOW", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ABOVE_BELOW" }, { "name": "SHAPE", "type": "esriFieldTypeString", "alias": "SHAPE", "domain": { "type": "codedValue", "name": "fseSHAPE", "description": "", "codedValues": [ { "name": "Rectangle", "code": "Rectangle" }, { "name": "Cylinder", "code": "Cylinder" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SHAPE" }, { "name": "MAINT_ACCESS", "type": "esriFieldTypeInteger", "alias": "MAINT_ACCESS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAINT_ACCESS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WASTE_GRINDER" }, { "name": "SOLIDS_INTERCEPTOR", "type": "esriFieldTypeString", "alias": "SOLIDS_INTERCEPTOR", "domain": { "type": "codedValue", "name": "fesYes_No", "description": "Text Yes No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "SOLIDS_INTERCEPTOR" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FOOD_SCREEN" }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH" }, { "name": "WIDTH_DIAM", "type": "esriFieldTypeDouble", "alias": "WIDTH_DIAM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WIDTH_DIAM" }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH" }, { "name": "HYDRAULIC_CAPACITY", "type": "esriFieldTypeDouble", "alias": "HYDRAULIC_CAPACITY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDRAULIC_CAPACITY" }, { "name": "RATED_CAPACITY", "type": "esriFieldTypeDouble", "alias": "RATED_CAPACITY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATED_CAPACITY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INLET_PIPE_VISIBLE" }, { "name": "INLET_PIPE_DEPTH", "type": "esriFieldTypeDouble", "alias": "INLET_PIPE_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INLET_PIPE_DEPTH" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTLET_PIPE_VISIBLE" }, { "name": "OUTLET_PIPE_DEPTH", "type": "esriFieldTypeDouble", "alias": "OUTLET_PIPE_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTLET_PIPE_DEPTH" }, { "name": "LOCATION_DESCRIP", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIP", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LOCATION_DESCRIP" }, { "name": "FLOW_CONTROL_DEVICE", "type": "esriFieldTypeString", "alias": "FLOW_CONTROL_DEVICE", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FLOW_CONTROL_DEVICE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AIR_VENT" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHARED" }, { "name": "OTHER_FAC_SERVED", "type": "esriFieldTypeString", "alias": "OTHER_FAC_SERVED", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "OTHER_FAC_SERVED" }, { "name": "RATED_CAPACITY_UNIT", "type": "esriFieldTypeString", "alias": "RATED_CAPACITY_UNIT", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "RATED_CAPACITY_UNIT" }, { "name": "RATED_CAPACITY_SOURCE", "type": "esriFieldTypeString", "alias": "RATED_CAPACITY_SOURCE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RATED_CAPACITY_SOURCE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "gcdStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATUS" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FSEGCD_Rel", "type": "esriFieldTypeGUID", "alias": "FSEGCD_Rel", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "FSEGCD_Rel" }, { "name": "GCD_ID", "type": "esriFieldTypeString", "alias": "GCD_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "GCD_ID" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LOCATION" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "CONNECTED_DEVICES", "type": "esriFieldTypeString", "alias": "CONNECTED_DEVICES", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "CONNECTED_DEVICES" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "GCD Details", "description": "", "prototype": { "attributes": { "COMMENTS": null, "LOCATION": null, "FSE_ID": null, "GCD_TYPE": null, "INT_EXT": null, "ABOVE_BELOW": null, "SHAPE": null, "MAINT_ACCESS": null, "WASTE_GRINDER": null, "SOLIDS_INTERCEPTOR": null, "FOOD_SCREEN": null, "LENGTH": null, "WIDTH_DIAM": null, "DEPTH": null, "HYDRAULIC_CAPACITY": null, "RATED_CAPACITY": null, "INLET_PIPE_VISIBLE": null, "INLET_PIPE_DEPTH": null, "OUTLET_PIPE_VISIBLE": null, "OUTLET_PIPE_DEPTH": null, "LOCATION_DESCRIP": null, "FLOW_CONTROL_DEVICE": null, "AIR_VENT": null, "SHARED": null, "OTHER_FAC_SERVED": null, "RATED_CAPACITY_UNIT": null, "RATED_CAPACITY_SOURCE": null, "STATUS": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "CONNECTED_DEVICES": null, "FSEGCD_Rel": null, "GCD_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }