{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.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 }, "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": [ 212, 244, 252, 255 ], "toColor": [ 212, 244, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 182, 252, 255 ], "toColor": [ 251, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 252, 179, 255 ], "toColor": [ 251, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 189, 187, 255 ], "toColor": [ 252, 189, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 204, 255 ], "toColor": [ 182, 252, 204, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 185, 252, 255 ], "toColor": [ 179, 185, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 237, 215, 255 ], "toColor": [ 252, 237, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 243, 255 ], "toColor": [ 252, 212, 243, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 214, 252, 255 ], "toColor": [ 182, 214, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 228, 252, 215, 255 ], "toColor": [ 228, 252, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 216, 204, 252, 255 ], "toColor": [ 216, 204, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 214, 252, 187, 255 ], "toColor": [ 214, 252, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 252, 244, 255 ], "toColor": [ 194, 252, 244, 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, "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.3, "cimVersion": "3.3.0", "id": 1, "name": "MEDIA_SAND", "type": "Table", "description": null, "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.3, "cimVersion": "3.3.0", "id": 2, "name": "METADATA_SAND", "type": "Table", "description": null, "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.3, "cimVersion": "3.3.0", "id": 3, "name": "SandNeeds_BorrowAreas_SAND", "type": "Table", "description": null, "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" } ] }