{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "TB_Documents", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "PHA_USER1.ChannelBoundaries", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ChannelID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "DocName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DocumentID", "type": "esriFieldTypeInteger", "alias": "Document ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DocumentID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "LegacyDocumentID", "type": "esriFieldTypeString", "alias": "LegacyDocumentID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "LegacyDocumentID" }, { "name": "FileNumber", "type": "esriFieldTypeString", "alias": "FileNumber", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FileNumber" }, { "name": "Title", "type": "esriFieldTypeString", "alias": "Title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Title" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Description" }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "Hyperlink" }, { "name": "StorageType", "type": "esriFieldTypeString", "alias": "StorageType", "domain": { "type": "codedValue", "name": "StorageType", "description": "Where file lives (https/web vs network share).", "codedValues": [ { "name": "Link", "code": "Link" }, { "name": "UNC", "code": "UNC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "StorageType" }, { "name": "StoragePathOrURL", "type": "esriFieldTypeString", "alias": "StoragePathOrURL", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "StoragePathOrURL" }, { "name": "FileHash", "type": "esriFieldTypeString", "alias": "FileHash", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FileHash" }, { "name": "SourceSystem", "type": "esriFieldTypeString", "alias": "SourceSystem", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SourceSystem" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "EffectiveDate", "type": "esriFieldTypeDate", "alias": "EffectiveDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EffectiveDate" }, { "name": "ExpirationDate", "type": "esriFieldTypeDate", "alias": "ExpirationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ExpirationDate" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "LastEditor" }, { "name": "DocType", "type": "esriFieldTypeString", "alias": "DocType", "domain": { "type": "codedValue", "name": "DocType", "description": "High-level document classification", "codedValues": [ { "name": "Contract", "code": "Contract" }, { "name": "Permit", "code": "Permit" }, { "name": "Spec", "code": "Spec" }, { "name": "Memo", "code": "Memo" }, { "name": "Report", "code": "Report" }, { "name": "Drawing", "code": "Drawing" }, { "name": "Photo", "code": "Photo" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Diagram", "code": "Diagram" }, { "name": "Map", "code": "Map" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "DocType" }, { "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": "DMPANames", "type": "esriFieldTypeString", "alias": "DMPANames", "domain": { "type": "codedValue", "name": "DMPA Names", "description": "Placement Area Names", "codedValues": [ { "name": "Alexander Island PA", "code": "Alexander_Island_PA" }, { "name": "Bolivar Marsh", "code": "Bolivar" }, { "name": "Atikinson M12", "code": "Atikinson_M12" }, { "name": "Atkinson Is. Marsh", "code": "Atkinson_Is_Marsh" }, { "name": "Atkinson M10", "code": "Atkinson_M10" }, { "name": "Atkinson M11", "code": "Atkinson_M11" }, { "name": "Atkinson M5/M6", "code": "Atkinson_M5_M6" }, { "name": "Atkinson M7/8/9", "code": "Atkinson_M7_8_9" }, { "name": "Beltway 8 PA", "code": "Beltway_8_PA" }, { "name": "E2 Clinton PA", "code": "E2_Clinton_PA" }, { "name": "East Clinton PA", "code": "East_Clinton_PA" }, { "name": "Filter Bed", "code": "Filter_Bed" }, { "name": "Glendale PA", "code": "Glendale_PA" }, { "name": "Greens Bayou PA", "code": "Greens_Bayou_PA" }, { "name": "House Tract PA", "code": "House_Tract_PA" }, { "name": "Lost Lake PA", "code": "Lost_Lake_PA" }, { "name": "Mid Bay PA", "code": "Mid_Bay_PA" }, { "name": "Peggy Lake PA", "code": "Peggy_Lake_PA" }, { "name": "PA 13", "code": "PA_13" }, { "name": "PA 14", "code": "PA_14" }, { "name": "PA 15", "code": "PA_15" }, { "name": "PA 16", "code": "PA_16" }, { "name": "Rosa Allen PA", "code": "Rosa_Allen_PA" }, { "name": "Spilman Island PA", "code": "Spilman_Island_PA" }, { "name": "West Clinton PA", "code": "West_Clinton_PA" }, { "name": "Long Bird Island", "code": "Long_Bird_Island" }, { "name": "Three Bird Island", "code": "Three_Bird_Island" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DMPANames" }, { "name": "ChannelID", "type": "esriFieldTypeString", "alias": "ChannelID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ChannelID" } ], "indexes": [ { "name": "R1133_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_Documents", "description": "", "prototype": { "attributes": { "DMPANames": null, "ChannelID": null, "DocumentID": null, "GlobalID": null, "LegacyDocumentID": null, "FileNumber": null, "Title": null, "Description": null, "Hyperlink": null, "StorageType": null, "StoragePathOrURL": null, "FileHash": null, "SourceSystem": null, "DataSource": null, "EffectiveDate": null, "ExpirationDate": null, "Comments": null, "LastUpdate": null, "LastEditor": null, "DocType": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }