{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "SAND Borrow Areas", "type": "Feature Layer", "description": "

The features within this feature class are delineated to the extents of offshore borrow areas within the USACE SAD. This feature class includes a Borrow Area ID that is used as a primary key in a relationship class that links these features with the Sand Needs, and Regional Sediment Management point locations (both federal and non-federal). Other attributes include information about the borrow area name, USACE district, state, county/municipality, borrow area category, estimated volume, associated beach nourishment project, permit information, general sand information, general notes about the source, and, sand quality information.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 2.0E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "USACE, Bureau of Ocean Energy Management (BOEM), Florida Department of Environmental Protection's Regional Offshore Sand Source Inventory (ROSSI), Taylor Engineering.", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "category", "uniqueValueGroups": [ { "heading": "Borrow Area Category", "classes": [ { "label": "Potential", "description": "Potential", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "values": [ [ "potential" ] ] }, { "label": "Proven", "description": "Proven", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 85, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "values": [ [ "proven" ] ] }, { "label": "Unusable", "description": "Unusable", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "values": [ [ "unusable" ] ] }, { "label": "Unverified", "description": "Unverified", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 197, 0, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "values": [ [ "unverified" ] ] }, { "label": "Unverified Plus", "description": "Unverified Plus", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "values": [ [ "unverifiedPlus" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "potential", "label": "Potential" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 85, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "proven", "label": "Proven" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "unusable", "label": "Unusable" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 197, 0, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "unverified", "label": "Unverified" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "unverifiedPlus", "label": "Unverified Plus" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 215, 252, 255 ], "toColor": [ 238, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 185, 255 ], "toColor": [ 179, 252, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 224, 187, 255 ], "toColor": [ 252, 224, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 252, 252, 255 ], "toColor": [ 202, 252, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 190, 255 ], "toColor": [ 252, 182, 190, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 246, 179, 252, 255 ], "toColor": [ 246, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 185, 182, 252, 255 ], "toColor": [ 185, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 244, 252, 179, 255 ], "toColor": [ 244, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 217, 252, 255 ], "toColor": [ 182, 217, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 216, 252, 215, 255 ], "toColor": [ 216, 252, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 226, 255 ], "toColor": [ 252, 215, 226, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 231, 255 ], "toColor": [ 252, 184, 231, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 204, 192, 255 ], "toColor": [ 252, 204, 192, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -89.06300000101328, "ymin": 17.902899999171495, "xmax": -65.57229999825358, "ymax": 36.51080000028014, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 2.0E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "featurename", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "sdsid", "type": "esriFieldTypeGUID", "alias": "Globally Unique Identifier", "length": 38, "domain": null }, { "name": "featurename", "type": "esriFieldTypeString", "alias": "Feature Name", "length": 80, "domain": null }, { "name": "also_known_as", "type": "esriFieldTypeString", "alias": "Also Known As", "length": 100, "domain": null }, { "name": "district", "type": "esriFieldTypeString", "alias": "District", "length": 3, "domain": { "type": "codedValue", "name": "DistrictCode", "description": "The three character code for USACE Districts.", "codedValues": [ { "name": "LRB", "code": "lrb" }, { "name": "LRC", "code": "lrc" }, { "name": "LRE", "code": "lre" }, { "name": "LRH", "code": "lrh" }, { "name": "LRL", "code": "lrl" }, { "name": "LRN", "code": "lrn" }, { "name": "LRP", "code": "lrp" }, { "name": "MVK", "code": "mvk" }, { "name": "MVM", "code": "mvm" }, { "name": "MVN", "code": "mvn" }, { "name": "MVP", "code": "mvp" }, { "name": "MVR", "code": "mvr" }, { "name": "MVS", "code": "mvs" }, { "name": "NAB", "code": "nab" }, { "name": "NAE", "code": "nae" }, { "name": "NAN", "code": "nan" }, { "name": "NAO", "code": "nao" }, { "name": "NAP", "code": "nap" }, { "name": "NWK", "code": "nwk" }, { "name": "NWO", "code": "nwo" }, { "name": "NWP", "code": "nwp" }, { "name": "NWS", "code": "nws" }, { "name": "NWW", "code": "nww" }, { "name": "POA", "code": "poa" }, { "name": "POH", "code": "poh" }, { "name": "SAC", "code": "sac" }, { "name": "SAJ", "code": "saj" }, { "name": "SAM", "code": "sam" }, { "name": "SAS", "code": "sas" }, { "name": "SAW", "code": "saw" }, { "name": "SPA", "code": "spa" }, { "name": "SPK", "code": "spk" }, { "name": "SPL", "code": "spl" }, { "name": "SPN", "code": "spn" }, { "name": "SWF", "code": "swf" }, { "name": "SWG", "code": "swg" }, { "name": "SWL", "code": "swl" }, { "name": "SWT", "code": "swt" }, { "name": "To Be Determined", "code": "tbd" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "length": 25, "domain": null }, { "name": "county", "type": "esriFieldTypeString", "alias": "County or Municipality", "length": 50, "domain": null }, { "name": "category", "type": "esriFieldTypeString", "alias": "Borrow Area Category", "length": 14, "domain": { "type": "codedValue", "name": "BorrowAreaCategory", "description": "Category of borrow area. Categories include Proven, Potential, Unverified Plus, Unverified, Unusable.", "codedValues": [ { "name": "Potential", "code": "potential" }, { "name": "Proven", "code": "proven" }, { "name": "Unusable", "code": "unusable" }, { "name": "Unverified", "code": "unverified" }, { "name": "Unverified Plus", "code": "unverifiedPlus" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "est_volume", "type": "esriFieldTypeDouble", "alias": "Est Volume", "domain": null }, { "name": "est_volume_uom", "type": "esriFieldTypeString", "alias": "Est Volume UOM", "length": 15, "domain": { "type": "codedValue", "name": "GsipVolumeUom", "description": "The volume unit of measure mandated in DoD IT Standards Registry (DISR).", "codedValues": [ { "name": "Cubic Centimeter", "code": "cubicCentimetre" }, { "name": "Cubic Decimeter", "code": "cubicDecimetre" }, { "name": "Cubic Foot", "code": "cubicFoot" }, { "name": "Cubic Inch", "code": "cubicInch" }, { "name": "Cubic Meter", "code": "cubicMetre" }, { "name": "Cubic Millimeter", "code": "cubicMillimetre" }, { "name": "Cubic Yard", "code": "cubicYard" }, { "name": "Deciliter", "code": "decilitre" }, { "name": "Liter", "code": "litre" }, { "name": "Milliliter", "code": "millilitre" }, { "name": "To Be Determined", "code": "tbd" }, { "name": "U.S. Cup", "code": "usCup" }, { "name": "U.S. Fluid Ounce", "code": "usFluidOunce" }, { "name": "U.S. Gallon", "code": "usGallon" }, { "name": "U.S. Pint", "code": "usPint" }, { "name": "U.S. Quart", "code": "usQuart" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "project_beach", "type": "esriFieldTypeString", "alias": "Project Beach", "length": 300, "domain": null }, { "name": "lat", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "long", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "source_info", "type": "esriFieldTypeString", "alias": "Source Information", "length": 1000, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 2000, "domain": null }, { "name": "permit_num", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 50, "domain": null }, { "name": "nepa", "type": "esriFieldTypeString", "alias": "NEPA", "length": 3, "domain": { "type": "codedValue", "name": "sdsYesOrNo", "description": "An indication of a choice between yes or no.", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" }, { "name": "To Be Determined", "code": "tbd" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mean_grain_size", "type": "esriFieldTypeString", "alias": "Mean Grain Size (mm)", "length": 20, "domain": null }, { "name": "munsell_color", "type": "esriFieldTypeString", "alias": "Munsell Color", "length": 30, "domain": null }, { "name": "shell_content", "type": "esriFieldTypeDouble", "alias": "Shell Content (%)", "domain": null }, { "name": "silt_content_200", "type": "esriFieldTypeDouble", "alias": "Silt Content (% Passing #200 Sieve)", "domain": null }, { "name": "silt_content_230", "type": "esriFieldTypeDouble", "alias": "Silt Content (% Passing #230 Sieve)", "domain": null }, { "name": "depleted", "type": "esriFieldTypeString", "alias": "Depleted", "length": 3, "domain": { "type": "codedValue", "name": "sdsYesOrNo", "description": "An indication of a choice between yes or no.", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" }, { "name": "To Be Determined", "code": "tbd" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "last_used_date", "type": "esriFieldTypeInteger", "alias": "Last Used Date", "domain": null }, { "name": "rossi_id", "type": "esriFieldTypeInteger", "alias": "ROSSI ID", "domain": null }, { "name": "boem_global_id", "type": "esriFieldTypeGUID", "alias": "BOEM Global ID", "length": 38, "domain": null }, { "name": "project_date", "type": "esriFieldTypeDate", "alias": "Project Date", "length": 8, "domain": null }, { "name": "mediaid", "type": "esriFieldTypeString", "alias": "Media Identifier", "length": 40, "domain": null }, { "name": "metadataid", "type": "esriFieldTypeString", "alias": "Metadata Identifier", "length": 80, "domain": null }, { "name": "featuredescription", "type": "esriFieldTypeString", "alias": "Feature Description", "length": 2000, "domain": null }, { "name": "installationid", "type": "esriFieldTypeString", "alias": "Installation Identifier", "length": 11, "domain": null }, { "name": "sandsourceidpk", "type": "esriFieldTypeDouble", "alias": "Primary Key Identifier", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "st_area(shape)", "type": "esriFieldTypeDouble", "alias": "st_area(shape)", "domain": null }, { "name": "st_perimeter(shape)", "type": "esriFieldTypeDouble", "alias": "st_perimeter(shape)", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "i1856mediaid", "fields": "mediaid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "i1856metadataid", "fields": "metadataid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "i1856sandsourcei", "fields": "sandsourceidpk", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r272_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a238_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "METADATA_SAND", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "metadataID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{70924C1F-BA7B-4C93-B207-B6AC3DA4EB4E}" }, { "id": 2, "name": "SandNeeds_BorrowAreas_SAND", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "sandSourceIdpk", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DD9953F-3A4C-418D-8B72-1E5565954A85}" }, { "id": 1, "name": "MEDIA_SAND", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "mediaID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6EBF65B3-9FDC-4481-9FDD-DEC8A6C8932A}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "st_area(shape)", "shapeLengthFieldName": "st_perimeter(shape)", "units": "esriDecimalDegrees", "mapUnits": {"uwkid": 9102} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "48cf171bddda4776a7477a18398a650f" } ], "tables": [ { "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.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "mediaidpk", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "mediaidpk", "type": "esriFieldTypeString", "alias": "Primary Key Identifier", "length": 40, "domain": null }, { "name": "hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 250, "domain": null }, { "name": "title", "type": "esriFieldTypeString", "alias": "Media Title", "length": 150, "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "Media Type", "length": 7, "domain": null }, { "name": "datemedia", "type": "esriFieldTypeString", "alias": "Media Date", "length": 12, "domain": null }, { "name": "createdby", "type": "esriFieldTypeString", "alias": "Media Creator", "length": 100, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "i1859mediaidpk", "fields": "mediaidpk", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r275_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "BorrowAreas_A", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "mediaIdpk", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6EBF65B3-9FDC-4481-9FDD-DEC8A6C8932A}" } ], "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": "48cf171bddda4776a7477a18398a650f" }, { "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": 0, "name": "BorrowAreas_A", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "metadataIdpk", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{70924C1F-BA7B-4C93-B207-B6AC3DA4EB4E}" } ], "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": "48cf171bddda4776a7477a18398a650f" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "SandNeeds_BorrowAreas_SAND", "type": "Table", "description": "Lookup table to provide links between Borrow Area projects and Sand Needs projects. This table functions as a tool to facilitate the one-to-many relationship class between Borrow Area and Sand needs projects.", "copyrightText": "USACE; Taylor Engineering", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "borrowareaid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "borrowareaid", "type": "esriFieldTypeDouble", "alias": "Borrow Area ID", "domain": null }, { "name": "needsprojectid", "type": "esriFieldTypeDouble", "alias": "Needs Project ID", "domain": null } ], "indexes": [ { "name": "i1865borrowareai", "fields": "borrowareaid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "i1865needsprojec", "fields": "needsprojectid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r281_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "BorrowAreas_A", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BorrowAreaID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DD9953F-3A4C-418D-8B72-1E5565954A85}" } ], "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": "48cf171bddda4776a7477a18398a650f" } ] }