{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "NourishmentProjects_SAND", "type": "Table", "description": "Lookup table that provides information about beach nourishment projects within the USACE South Atlantic District. Attributes in this lookup table provide information about the name of the project, year the project was constructed, extents of the project, length of the project measured in feet, approximate sand fill of the project in cubic yards, the source of sand used for the project, the name of the sand source, general notes about the project, and whether or not the project was used for 50 year sand need calculations. Additionally, the project ID of the Sand Needs project is included to participate in a relationship class with Sand Needs 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.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "projectname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "nourishment_id", "type": "esriFieldTypeDouble", "alias": "Nourishment ID", "domain": null }, { "name": "project_id", "type": "esriFieldTypeDouble", "alias": "Project ID", "domain": null }, { "name": "projectname", "type": "esriFieldTypeString", "alias": "Project Name", "length": 255, "domain": null }, { "name": "constructionyear", "type": "esriFieldTypeDouble", "alias": "Construction Year", "domain": null }, { "name": "projectextent", "type": "esriFieldTypeString", "alias": "Project Extent", "length": 255, "domain": null }, { "name": "projectlengthft", "type": "esriFieldTypeDouble", "alias": "Project Length (ft)", "domain": null }, { "name": "approximatefillcy", "type": "esriFieldTypeDouble", "alias": "Approximate Fill (cy)", "domain": null }, { "name": "sandsourcetype", "type": "esriFieldTypeString", "alias": "Sand Source Type", "length": 255, "domain": null }, { "name": "sandsourcename", "type": "esriFieldTypeString", "alias": "Sand Source Name", "length": 255, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "includedin50yrcalcs", "type": "esriFieldTypeString", "alias": "Included in 50 year calculations", "length": 255, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "i1862project_id", "fields": "project_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r278_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_278", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SandNeeds_L", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Project_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9FB760FB-FDE7-48F7-AF73-6F20D1EF366A}" } ], "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": "d362d3502633440a94941395092e5d2a" }