{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 9, "name": "Link Documents", "type": "Table", "description": "The Link Documents table contains links to scientific reports associated with study-related features within the MMIS geodatabase. The studies are fully or partially funded by the Bureau of Ocean Energy Management (BOEM), an agency within the U.S. Department of the Interior, and consist of sand resource reconnaissance surveys, sand placement surveys, research on baseline benthic ecological conditions, and environmental impact investigations, in relation to dredging operations on various aspects of the physical, chemical, and biological environments. This dataset will be updated regularly as new and existing reports are added to the database.", "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ReportTitle", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "ReportTitle", "type": "esriFieldTypeString", "alias": "Report Title", "length": 250, "domain": null }, { "name": "Year", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null }, { "name": "Year_text", "type": "esriFieldTypeString", "alias": "Year_text", "length": 4, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 30, "domain": null }, { "name": "GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "Constraints", "type": "esriFieldTypeString", "alias": "Access Constraints", "length": 15, "domain": null }, { "name": "Public_Report", "type": "esriFieldTypeString", "alias": "Public Report", "length": 500, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R18_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G39GlobalLinkID", "fields": "GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "SandResources", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D84EFA4C-67A1-4D93-9F45-970743D8B0DB}" }, { "id": 4, "name": "ShoreStudyAreas", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF703E85-30C0-4B79-BBB6-B66E0491C434}" }, { "id": 0, "name": "OffshoreStudyAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CE805DB2-4751-47F8-A75F-1E5FAAF521DC}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "6308daaffcd2473da6104623e81e18d1" }