{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "MEDIA_SAND", "type": "Table", "description": "Lookup table that provides links to media associated with SAND geodatabase projects. Included in this table are primary key lookup and hyperlink fields. Media includes Adobe PDF documents and Microsoft Excel documents. Note: media links are not provided for L_SandNeeds or T_RSM projects.", "copyrightText": "USACE, Bureau of Ocean Energy Management (BOEM), Florida Department of Environmental Protection's Regional Offshore Sand Source Inventory (ROSSI), American Shore and Beach Preservation Association (ASBPA), Florida Shore and Beach Preservation Association (FSBPA), Taylor Engineering.", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "BorrowAreas_A", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "mediaIdpk", "composite": false, "catalogID": "{6EBF65B3-9FDC-4481-9FDD-DEC8A6C8932A}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "mediaidpk", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "mediaidpk", "type": "esriFieldTypeString", "alias": "Primary Key Identifier", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "mediaIdpk" }, { "name": "hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "hyperlink" }, { "name": "title", "type": "esriFieldTypeString", "alias": "Media Title", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "title" }, { "name": "type", "type": "esriFieldTypeString", "alias": "Media Type", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "type" }, { "name": "datemedia", "type": "esriFieldTypeString", "alias": "Media Date", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "dateMedia" }, { "name": "createdby", "type": "esriFieldTypeString", "alias": "Media Creator", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "createdBy" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "comments" } ], "indexes": [ { "name": "i1859mediaidpk", "isAscending": true, "isUnique": false, "description": "", "fields": "mediaidpk" }, { "name": "r275_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MEDIA_SAND", "description": "", "prototype": { "attributes": { "createdby": null, "comments": null, "mediaidpk": null, "hyperlink": null, "title": null, "type": null, "datemedia": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "3bebf52310b247baa8c0a351593f1699" }