{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "METADATA_SAND", "type": "Table", "description": "Lookup table that provides feature level metatdata attributes for projects within the SAND geodatabase. Attributes include source/originator of the data and general comments or notes about the project.", "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.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "metadataidpk", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "metadataidpk", "type": "esriFieldTypeString", "alias": "Primary Key Identifier", "length": 40, "domain": null }, { "name": "source", "type": "esriFieldTypeString", "alias": "Source of Data", "length": 150, "domain": null }, { "name": "datecreated", "type": "esriFieldTypeString", "alias": "Metadata Creation Date", "length": 12, "domain": null }, { "name": "datelastmod", "type": "esriFieldTypeString", "alias": "Date Last Modification", "length": 12, "domain": null }, { "name": "datacapturemethod", "type": "esriFieldTypeString", "alias": "Method of Data Creation", "length": 21, "domain": null }, { "name": "dataaccuracy", "type": "esriFieldTypeString", "alias": "Data Accuracy", "length": 12, "domain": null }, { "name": "originator", "type": "esriFieldTypeString", "alias": "Originator of Data", "length": 100, "domain": null }, { "name": "maintainer", "type": "esriFieldTypeString", "alias": "Maintainer of Data", "length": 100, "domain": null }, { "name": "maintainercontact", "type": "esriFieldTypeString", "alias": "Maintainer Contact Info", "length": 150, "domain": null }, { "name": "security", "type": "esriFieldTypeString", "alias": "Security Classification", "length": 12, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "i1861metadataidp", "fields": "metadataidpk", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r277_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "RSM_P", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "metadataIdpk", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{5DDD0EBC-85DD-460F-BDC1-1B7AFD678ED3}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "82c4efa116e6421ab45d69ab8ac39afc" }