{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Placement_Areas", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 3194504.689660549, "ymin": 1.3734869503424391E7, "xmax": 3217848.3224351406, "ymax": 1.3760595139637053E7, "spatialReference": { "wkid": 103161, "latestWkid": 6588, "vcsWkid": 5866, "latestVcsWkid": 5866, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "MLLW_Depth", "heightUnit": "meter" }, "sourceSpatialReference": { "wkid": 103161, "latestWkid": 6588, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126689900, "falseY": -90947100, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 190, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PlacementAreaID", "type": "esriFieldTypeInteger", "alias": "PlacementAreaID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PlacementAreaID" }, { "name": "ExternalID", "type": "esriFieldTypeString", "alias": "ExternalID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "ExternalID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "PlacementStatus", "description": "PlacementStatus", "codedValues": [ { "name": "Operational", "code": "Operational" }, { "name": "Restricted", "code": "Restricted" }, { "name": "Closed", "code": "Closed" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Decommissioned", "code": "Decommissioned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "Status" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": { "type": "codedValue", "name": "Owner", "description": "Owning agency.", "codedValues": [ { "name": "USACE", "code": "USACE" }, { "name": "PHA", "code": "PHA" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Owner" }, { "name": "PlacementType", "type": "esriFieldTypeString", "alias": "PlacementType", "domain": { "type": "codedValue", "name": "PlacementType", "description": "High-level placement category", "codedValues": [ { "name": "Open Bay", "code": "Open Bay" }, { "name": "Marsh Creation", "code": "Marsh Creation" }, { "name": "Confined (DMPA)", "code": "Confined (DMPA)" }, { "name": "Beach Nourishment", "code": "Beach Nourishment" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "PlacementType" }, { "name": "ActivityType", "type": "esriFieldTypeString", "alias": "ActivityType", "domain": { "type": "codedValue", "name": "ActivityType", "description": "Activity classification used by USACE datasets", "codedValues": [ { "name": "Interim", "code": "Interim" }, { "name": "Final", "code": "Final" }, { "name": "Stockpile", "code": "Stockpile" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "ActivityType" }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "PermitType", "domain": { "type": "codedValue", "name": "PermitType", "description": "USACE permit type grouping", "codedValues": [ { "name": "Individual", "code": "Individual" }, { "name": "General", "code": "General" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "PermitType" }, { "name": "ConfinementType", "type": "esriFieldTypeString", "alias": "ConfinementType", "domain": { "type": "codedValue", "name": "ConfinementType", "description": "ConfinementType", "codedValues": [ { "name": "Confined", "code": "Confined" }, { "name": "Semi-Confined", "code": "Semi-Confined" }, { "name": "Unconfined", "code": "Unconfined" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "ConfinementType" }, { "name": "OperationStatus", "type": "esriFieldTypeString", "alias": "OperationStatus", "domain": { "type": "codedValue", "name": "OperationStatus", "description": "Operational status of placement area", "codedValues": [ { "name": "Operational", "code": "Operational" }, { "name": "Restricted", "code": "Restricted" }, { "name": "Closed", "code": "Closed" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "OperationStatus" }, { "name": "CapacityVolume", "type": "esriFieldTypeDouble", "alias": "CapacityVolume", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CapacityVolume" }, { "name": "RemainingCapacityVolume", "type": "esriFieldTypeDouble", "alias": "RemainingCapacityVolume", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RemainingCapacityVolume" }, { "name": "VolumeUOM", "type": "esriFieldTypeString", "alias": "VolumeUOM", "domain": { "type": "codedValue", "name": "VolumeUOM", "description": "Capacity/quantity units.", "codedValues": [ { "name": "CY", "code": "CY" }, { "name": "m3", "code": "m3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "VolumeUOM" }, { "name": "AreaAcre", "type": "esriFieldTypeDouble", "alias": "AreaAcre", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AreaAcre" }, { "name": "Freeboard", "type": "esriFieldTypeDouble", "alias": "Freeboard", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Freeboard" }, { "name": "FreeboardUOM", "type": "esriFieldTypeString", "alias": "FreeboardUOM", "domain": { "type": "codedValue", "name": "HeightUOM", "description": "Height unit of measure", "codedValues": [ { "name": "ft", "code": "ft" }, { "name": "m", "code": "m" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FreeboardUOM" }, { "name": "DikeHeight", "type": "esriFieldTypeDouble", "alias": "DikeHeight", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DikeHeight" }, { "name": "HeightUOM", "type": "esriFieldTypeString", "alias": "HeightUOM", "domain": { "type": "codedValue", "name": "HeightUOM", "description": "Height unit of measure", "codedValues": [ { "name": "ft", "code": "ft" }, { "name": "m", "code": "m" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HeightUOM" }, { "name": "MinDepthFT", "type": "esriFieldTypeDouble", "alias": "MinDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MinDepthFT" }, { "name": "VerticalDatum", "type": "esriFieldTypeString", "alias": "VerticalDatum", "domain": { "type": "codedValue", "name": "VerticalDatum", "description": "Datum for depths/elevations.", "codedValues": [ { "name": "NAVD88", "code": "NAVD88" }, { "name": "NGVD29", "code": "NGVD29" }, { "name": "MLLW", "code": "MLLW" }, { "name": "MHW", "code": "MHW" }, { "name": "LocalTidal", "code": "LocalTidal" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "VerticalDatum" }, { "name": "Channel", "type": "esriFieldTypeString", "alias": "Channel", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Channel" }, { "name": "Reach", "type": "esriFieldTypeString", "alias": "Reach", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Reach" }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "State" }, { "name": "USACEDistrict", "type": "esriFieldTypeString", "alias": "USACEDistrict", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "USACEDistrict" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LastEditor" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "DesignDate", "type": "esriFieldTypeDate", "alias": "DesignDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DesignDate" }, { "name": "BuildDate", "type": "esriFieldTypeDate", "alias": "BuildDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BuildDate" }, { "name": "DateOfCapacity", "type": "esriFieldTypeDate", "alias": "DateOfCapacity", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateOfCapacity" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1128_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1128", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1114_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Placement_Areas", "description": "", "prototype": { "attributes": { "DateOfCapacity": null, "PlacementAreaID": null, "ExternalID": null, "Name": null, "Status": null, "Owner": null, "PlacementType": null, "ActivityType": null, "PermitType": null, "ConfinementType": null, "OperationStatus": null, "CapacityVolume": null, "RemainingCapacityVolume": null, "VolumeUOM": null, "AreaAcre": null, "Freeboard": null, "FreeboardUOM": null, "DikeHeight": null, "HeightUOM": null, "MinDepthFT": null, "VerticalDatum": null, "Channel": null, "Reach": null, "State": null, "USACEDistrict": null, "DataSource": null, "Comments": null, "BuildDate": null, "LastEditor": null, "LastUpdate": null, "DesignDate": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "ChannelBoundaries", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "PHA_USER1.TB_Documents", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "channelareaidfk", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 3128493.01997865, "ymin": 1.3604146268224595E7, "xmax": 3450294.730104608, "ymax": 1.3857470648167145E7, "spatialReference": { "wkid": 103161, "latestWkid": 6588, "vcsWkid": 5866, "latestVcsWkid": 5866, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "MLLW_Depth", "heightUnit": "meter" }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 190, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ChannelName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "channelreachidpk", "type": "esriFieldTypeString", "alias": "Reach ID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "channelreachidpk" }, { "name": "channelareaidfk", "type": "esriFieldTypeString", "alias": "Channel ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "channelareaidfk" }, { "name": "sdsfeaturedescription", "type": "esriFieldTypeString", "alias": "Reach Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "TOE extents of a Project or Sub-Project Channel Reach", "modelName": "sdsfeaturedescription" }, { "name": "mileagestart", "type": "esriFieldTypeDouble", "alias": "Station Start", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mileagestart" }, { "name": "mileageend", "type": "esriFieldTypeDouble", "alias": "Station End", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mileageend" }, { "name": "reportedlength", "type": "esriFieldTypeDouble", "alias": "Implied Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reportedlength" }, { "name": "depthmaintained", "type": "esriFieldTypeDouble", "alias": "Depth Maintained", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "depthmaintained" }, { "name": "depthauthorized", "type": "esriFieldTypeDouble", "alias": "Depth Authorized", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "depthauthorized" }, { "name": "widthfrom", "type": "esriFieldTypeDouble", "alias": "Min Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "widthfrom" }, { "name": "widthto", "type": "esriFieldTypeDouble", "alias": "Max Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "widthto" }, { "name": "sdsfeaturename", "type": "esriFieldTypeString", "alias": "USACE feature name", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "sdsfeaturename" }, { "name": "sourceagency", "type": "esriFieldTypeString", "alias": "USACE district", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sourceagency" }, { "name": "usacedistrictcode", "type": "esriFieldTypeString", "alias": "District code", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "usacedistrictcode" }, { "name": "projectedarea", "type": "esriFieldTypeDouble", "alias": "Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "projectedarea" }, { "name": "areasizeuom", "type": "esriFieldTypeString", "alias": "Area units", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "areasizeuom" }, { "name": "channelreachcategory", "type": "esriFieldTypeString", "alias": "Channel Reach Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "National Channel Framework category", "modelName": "channelreachcategory" }, { "name": "channelreachtype", "type": "esriFieldTypeString", "alias": "Reach type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "channelreachtype" }, { "name": "epsg", "type": "esriFieldTypeString", "alias": "Spatial ref", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "epsg" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1139_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1119_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "ChannelBoundaries", "description": "", "prototype": { "attributes": { "DataSource": null, "channelreachidpk": null, "channelareaidfk": null, "sdsfeaturedescription": null, "mileagestart": null, "mileageend": null, "reportedlength": null, "depthmaintained": null, "depthauthorized": null, "widthfrom": null, "widthto": null, "sdsfeaturename": null, "sourceagency": null, "usacedistrictcode": null, "projectedarea": null, "areasizeuom": null, "channelreachcategory": null, "channelreachtype": null, "epsg": null, "Comments": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "BathymetryPolygons", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "editDateField": "LastUpdate", "editorField": "LastEditor" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 3158157.0464767218, "ymin": 1.3669665769986972E7, "xmax": 3380057.510155216, "ymax": 1.3846583654995635E7, "spatialReference": { "wkid": 103161, "latestWkid": 6588, "vcsWkid": 5866, "latestVcsWkid": 5866, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "MLLW_Depth", "heightUnit": "meter" }, "sourceSpatialReference": { "wkid": 103161, "latestWkid": 6588, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126689900, "falseY": -90947100, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 191, 243, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "SurveyHeaderID", "type": "esriFieldTypeGUID", "alias": "SurveyHeaderID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SurveyHeaderID" }, { "name": "PolyType", "type": "esriFieldTypeString", "alias": "PolyType", "domain": { "type": "codedValue", "name": "PolyType", "description": "Type of bathy polygon.", "codedValues": [ { "name": "Coverage", "code": "Coverage" }, { "name": "Shoal", "code": "Shoal" }, { "name": "Extent", "code": "Extent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "PolyType" }, { "name": "MinDepthFT", "type": "esriFieldTypeDouble", "alias": "MinDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MinDepthFT" }, { "name": "MaxDepthFT", "type": "esriFieldTypeDouble", "alias": "MaxDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaxDepthFT" }, { "name": "MeanDepthFT", "type": "esriFieldTypeDouble", "alias": "MeanDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MeanDepthFT" }, { "name": "AreaAcre", "type": "esriFieldTypeDouble", "alias": "AreaAcre", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AreaAcre" }, { "name": "SurveyYear", "type": "esriFieldTypeSmallInteger", "alias": "SurveyYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurveyYear" }, { "name": "SurveyQuarter", "type": "esriFieldTypeString", "alias": "SurveyQuarter", "domain": { "type": "codedValue", "name": "SurveyQuarter", "description": "SurveyQuarter", "codedValues": [ { "name": "Q1", "code": "Q1" }, { "name": "Q2", "code": "Q2" }, { "name": "Q3", "code": "Q3" }, { "name": "Q4", "code": "Q4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "SurveyQuarter" }, { "name": "Channel", "type": "esriFieldTypeString", "alias": "Channel", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Channel" }, { "name": "Reach", "type": "esriFieldTypeString", "alias": "Reach", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Reach" }, { "name": "FacilityName", "type": "esriFieldTypeString", "alias": "FacilityName", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "FacilityName" }, { "name": "VerticalDatum", "type": "esriFieldTypeString", "alias": "VerticalDatum", "domain": { "type": "codedValue", "name": "VerticalDatum", "description": "Datum for depths/elevations.", "codedValues": [ { "name": "NAVD88", "code": "NAVD88" }, { "name": "NGVD29", "code": "NGVD29" }, { "name": "MLLW", "code": "MLLW" }, { "name": "MHW", "code": "MHW" }, { "name": "LocalTidal", "code": "LocalTidal" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "VerticalDatum" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LastEditor" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "SourceFC", "type": "esriFieldTypeString", "alias": "SourceFC", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "SourceFC" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1123_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1123", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I2333SurveyHeade", "fields": "SurveyHeaderID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2333SourceFC", "fields": "SourceFC", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1110_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "BathymetryPolygons", "description": "", "prototype": { "attributes": { "DataSource": null, "SourceFC": null, "Comments": null, "SurveyHeaderID": null, "PolyType": null, "MinDepthFT": null, "MaxDepthFT": null, "MeanDepthFT": null, "AreaAcre": null, "SurveyYear": null, "SurveyQuarter": null, "Channel": null, "Reach": null, "FacilityName": null, "VerticalDatum": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "SurveyHeader", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "editDateField": "LastUpdate", "editorField": "LastEditor" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SurveyName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SurveyID", "type": "esriFieldTypeInteger", "alias": "SurveyID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurveyID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "UniqueID", "type": "esriFieldTypeString", "alias": "UniqueID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "UniqueID" }, { "name": "DredgingProjectID", "type": "esriFieldTypeString", "alias": "DredgingProjectID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "DredgingProjectID" }, { "name": "SurveyName", "type": "esriFieldTypeString", "alias": "SurveyName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SurveyName" }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "SurveyDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SurveyDate" }, { "name": "SurveyYear", "type": "esriFieldTypeSmallInteger", "alias": "SurveyYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurveyYear" }, { "name": "SurveyQuarter", "type": "esriFieldTypeString", "alias": "SurveyQuarter", "domain": { "type": "codedValue", "name": "SurveyQuarter", "description": "SurveyQuarter", "codedValues": [ { "name": "Q1", "code": "Q1" }, { "name": "Q2", "code": "Q2" }, { "name": "Q3", "code": "Q3" }, { "name": "Q4", "code": "Q4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "SurveyQuarter" }, { "name": "SurveyType", "type": "esriFieldTypeString", "alias": "SurveyType", "domain": { "type": "codedValue", "name": "SurveyType", "description": "Conditional/Monitoring; After Dredge; Before Dredge; Hazard; Post Storm", "codedValues": [ { "name": "Conditional/Monitoring", "code": "CM" }, { "name": "After Dredge", "code": "AD" }, { "name": "Before Dredge", "code": "BD" }, { "name": "Hazard", "code": "HZ" }, { "name": "Post Storm", "code": "PS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "SurveyType" }, { "name": "DataProvider", "type": "esriFieldTypeString", "alias": "DataProvider", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "DataProvider" }, { "name": "Channel", "type": "esriFieldTypeString", "alias": "Channel", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Channel" }, { "name": "Reach", "type": "esriFieldTypeString", "alias": "Reach", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Reach" }, { "name": "FacilityName", "type": "esriFieldTypeString", "alias": "FacilityName", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "FacilityName" }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LocationDescription" }, { "name": "SurveyEquipmentType", "type": "esriFieldTypeString", "alias": "SurveyEquipmentType", "domain": { "type": "codedValue", "name": "SurveyEquipmentType", "description": "Multi-beam; High frequency; Low frequency", "codedValues": [ { "name": "Multi-beam", "code": "MB" }, { "name": "High frequency", "code": "Hi" }, { "name": "Low frequency", "code": "Lo" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "SurveyEquipmentType" }, { "name": "VerticalDatum", "type": "esriFieldTypeString", "alias": "VerticalDatum", "domain": { "type": "codedValue", "name": "VerticalDatum", "description": "Datum for depths/elevations.", "codedValues": [ { "name": "NAVD88", "code": "NAVD88" }, { "name": "NGVD29", "code": "NGVD29" }, { "name": "MLLW", "code": "MLLW" }, { "name": "MHW", "code": "MHW" }, { "name": "LocalTidal", "code": "LocalTidal" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "VerticalDatum" }, { "name": "Contracted", "type": "esriFieldTypeSmallInteger", "alias": "Contracted", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Contracted" }, { "name": "ContractID", "type": "esriFieldTypeString", "alias": "ContractID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "ContractID" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "FileType", "type": "esriFieldTypeString", "alias": "FileType", "domain": { "type": "codedValue", "name": "FileFormat", "description": "Primary source file type", "codedValues": [ { "name": "CSV", "code": "CSV" }, { "name": "XYZ", "code": "XYZ" }, { "name": "OTHER", "code": "OTHER" }, { "name": "FGDB", "code": "FGDB" }, { "name": "EFILE", "code": "EFILE" }, { "name": "PDF", "code": "PDF" }, { "name": "IMAGE", "code": "IMAGE" }, { "name": "SHP", "code": "SHP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "FileType" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "Hyperlink" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LastEditor" } ], "indexes": [ { "name": "R1120_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1120", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IDX_SH_DATE", "fields": "SurveyDate", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SurveyHeader", "description": "", "prototype": { "attributes": { "Comments": null, "Hyperlink": null, "SurveyID": null, "FileType": null, "UniqueID": null, "DredgingProjectID": null, "SurveyName": null, "SurveyDate": null, "SurveyYear": null, "SurveyQuarter": null, "SurveyType": null, "DataProvider": null, "Channel": null, "Reach": null, "FacilityName": null, "LocationDescription": null, "SurveyEquipmentType": null, "VerticalDatum": null, "Contracted": null, "ContractID": null, "DataSource": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "TB_Associations", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "AssocType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssocID", "type": "esriFieldTypeInteger", "alias": "AssocID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssocID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "ProjectID", "type": "esriFieldTypeInteger", "alias": "Project ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProjectID" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Notes" }, { "name": "TargetClass", "type": "esriFieldTypeString", "alias": "TargetClass", "domain": { "type": "codedValue", "name": "PA_TargetClass", "description": "Allowed targets for ProjectAssociations (documents excluded).", "codedValues": [ { "name": "SurveyHeader", "code": "SurveyHeader" }, { "name": "BathymetryPolygons", "code": "BathymetryPolygons" }, { "name": "ChannelBoundaries", "code": "ChannelBoundaries" }, { "name": "PermitsUSACE", "code": "PermitsUSACE" }, { "name": "PlacementAreas", "code": "PlacementAreas" }, { "name": "DredgePlacement", "code": "DredgePlacement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "TargetClass" }, { "name": "TargetGlobalID", "type": "esriFieldTypeGUID", "alias": "TargetGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "TargetGlobalID" }, { "name": "AssocRole", "type": "esriFieldTypeString", "alias": "AssocRole", "domain": { "type": "codedValue", "name": "AssocRole", "description": "Optional qualifier describing the association purpose/context.", "codedValues": [ { "name": "OccursAt", "code": "OccursAt" }, { "name": "Affects", "code": "Affects" }, { "name": "Uses", "code": "Uses" }, { "name": "References", "code": "References" }, { "name": "Related", "code": "Related" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "AssocRole" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1134_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_Associations", "description": "", "prototype": { "attributes": { "AssocRole": null, "TargetGlobalID": null, "AssocID": null, "GlobalID": null, "ProjectID": null, "Notes": null, "TargetClass": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "TB_Documents", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "PHA_USER1.ChannelBoundaries", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ChannelID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "DocName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DocumentID", "type": "esriFieldTypeInteger", "alias": "Document ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DocumentID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "LegacyDocumentID", "type": "esriFieldTypeString", "alias": "LegacyDocumentID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "LegacyDocumentID" }, { "name": "FileNumber", "type": "esriFieldTypeString", "alias": "FileNumber", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FileNumber" }, { "name": "Title", "type": "esriFieldTypeString", "alias": "Title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Title" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Description" }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "Hyperlink" }, { "name": "StorageType", "type": "esriFieldTypeString", "alias": "StorageType", "domain": { "type": "codedValue", "name": "StorageType", "description": "Where file lives (https/web vs network share).", "codedValues": [ { "name": "Link", "code": "Link" }, { "name": "UNC", "code": "UNC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "StorageType" }, { "name": "StoragePathOrURL", "type": "esriFieldTypeString", "alias": "StoragePathOrURL", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "StoragePathOrURL" }, { "name": "FileHash", "type": "esriFieldTypeString", "alias": "FileHash", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FileHash" }, { "name": "SourceSystem", "type": "esriFieldTypeString", "alias": "SourceSystem", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SourceSystem" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "EffectiveDate", "type": "esriFieldTypeDate", "alias": "EffectiveDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EffectiveDate" }, { "name": "ExpirationDate", "type": "esriFieldTypeDate", "alias": "ExpirationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ExpirationDate" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "LastEditor" }, { "name": "DocType", "type": "esriFieldTypeString", "alias": "DocType", "domain": { "type": "codedValue", "name": "DocType", "description": "High-level document classification", "codedValues": [ { "name": "Contract", "code": "Contract" }, { "name": "Permit", "code": "Permit" }, { "name": "Spec", "code": "Spec" }, { "name": "Memo", "code": "Memo" }, { "name": "Report", "code": "Report" }, { "name": "Drawing", "code": "Drawing" }, { "name": "Photo", "code": "Photo" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Diagram", "code": "Diagram" }, { "name": "Map", "code": "Map" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "DocType" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DMPANames", "type": "esriFieldTypeString", "alias": "DMPANames", "domain": { "type": "codedValue", "name": "DMPA Names", "description": "Placement Area Names", "codedValues": [ { "name": "Alexander Island PA", "code": "Alexander_Island_PA" }, { "name": "Bolivar Marsh", "code": "Bolivar" }, { "name": "Atikinson M12", "code": "Atikinson_M12" }, { "name": "Atkinson Is. Marsh", "code": "Atkinson_Is_Marsh" }, { "name": "Atkinson M10", "code": "Atkinson_M10" }, { "name": "Atkinson M11", "code": "Atkinson_M11" }, { "name": "Atkinson M5/M6", "code": "Atkinson_M5_M6" }, { "name": "Atkinson M7/8/9", "code": "Atkinson_M7_8_9" }, { "name": "Beltway 8 PA", "code": "Beltway_8_PA" }, { "name": "E2 Clinton PA", "code": "E2_Clinton_PA" }, { "name": "East Clinton PA", "code": "East_Clinton_PA" }, { "name": "Filter Bed", "code": "Filter_Bed" }, { "name": "Glendale PA", "code": "Glendale_PA" }, { "name": "Greens Bayou PA", "code": "Greens_Bayou_PA" }, { "name": "House Tract PA", "code": "House_Tract_PA" }, { "name": "Lost Lake PA", "code": "Lost_Lake_PA" }, { "name": "Mid Bay PA", "code": "Mid_Bay_PA" }, { "name": "Peggy Lake PA", "code": "Peggy_Lake_PA" }, { "name": "PA 13", "code": "PA_13" }, { "name": "PA 14", "code": "PA_14" }, { "name": "PA 15", "code": "PA_15" }, { "name": "PA 16", "code": "PA_16" }, { "name": "Rosa Allen PA", "code": "Rosa_Allen_PA" }, { "name": "Spilman Island PA", "code": "Spilman_Island_PA" }, { "name": "West Clinton PA", "code": "West_Clinton_PA" }, { "name": "Long Bird Island", "code": "Long_Bird_Island" }, { "name": "Three Bird Island", "code": "Three_Bird_Island" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DMPANames" }, { "name": "ChannelID", "type": "esriFieldTypeString", "alias": "ChannelID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ChannelID" } ], "indexes": [ { "name": "R1133_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_Documents", "description": "", "prototype": { "attributes": { "DMPANames": null, "ChannelID": null, "DocumentID": null, "GlobalID": null, "LegacyDocumentID": null, "FileNumber": null, "Title": null, "Description": null, "Hyperlink": null, "StorageType": null, "StoragePathOrURL": null, "FileHash": null, "SourceSystem": null, "DataSource": null, "EffectiveDate": null, "ExpirationDate": null, "Comments": null, "LastUpdate": null, "LastEditor": null, "DocType": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "TB_DredgePlacement", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PlacementMoveID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PlacementMoveID", "type": "esriFieldTypeInteger", "alias": "Placement Move ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PlacementMoveID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "ProjectID", "type": "esriFieldTypeInteger", "alias": "Project ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProjectID" }, { "name": "SurveyHeaderID", "type": "esriFieldTypeGUID", "alias": "Survey Header ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SurveyHeaderID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LastEditor" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "SourceChannelID", "type": "esriFieldTypeGUID", "alias": "SourceChannelID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SourceChannelID" }, { "name": "SourceChannelName", "type": "esriFieldTypeString", "alias": "SourceChannelName", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "SourceChannelName" }, { "name": "SourceBathyPolyID", "type": "esriFieldTypeGUID", "alias": "SourceBathyPolyID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SourceBathyPolyID" }, { "name": "DestPlacementAreaID", "type": "esriFieldTypeGUID", "alias": "DestPlacementAreaID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "DestPlacementAreaID" }, { "name": "DestPlacementExternalID", "type": "esriFieldTypeString", "alias": "DestPlacementExternalID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "DestPlacementExternalID" }, { "name": "QuantityCY", "type": "esriFieldTypeDouble", "alias": "QuantityCY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "QuantityCY" }, { "name": "QuantityType", "type": "esriFieldTypeString", "alias": "QuantityType", "domain": { "type": "codedValue", "name": "QuantityType", "description": "Indicates whether the quantity is measured or estimated", "codedValues": [ { "name": "Actual", "code": "Actual" }, { "name": "Estimated", "code": "Estimated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "QuantityType" }, { "name": "MaterialType", "type": "esriFieldTypeString", "alias": "MaterialType", "domain": { "type": "codedValue", "name": "MaterialType", "description": "Generalized material classification", "codedValues": [ { "name": "Sand", "code": "Sand" }, { "name": "Silt", "code": "Silt" }, { "name": "Clay", "code": "Clay" }, { "name": "Mixed", "code": "Mixed" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "MaterialType" }, { "name": "PlacementMethod", "type": "esriFieldTypeString", "alias": "PlacementMethod", "domain": { "type": "codedValue", "name": "PlacementMethod", "description": "Method used to place material", "codedValues": [ { "name": "Hydraulic (Pipeline)", "code": "Hydraulic (Pipeline)" }, { "name": "Mechanical", "code": "Mechanical" }, { "name": "Hopper Pump-Out", "code": "Hopper Pump-Out" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "PlacementMethod" }, { "name": "MoveStartDate", "type": "esriFieldTypeDate", "alias": "MoveStartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MoveStartDate" }, { "name": "MoveEndDate", "type": "esriFieldTypeDate", "alias": "MoveEndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MoveEndDate" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Contractor" }, { "name": "PrimaryDocURL", "type": "esriFieldTypeString", "alias": "PrimaryDocURL", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "PrimaryDocURL" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Notes" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1131_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_DredgePlacement", "description": "", "prototype": { "attributes": { "Notes": null, "DataSource": null, "PlacementMoveID": null, "GlobalID": null, "ProjectID": null, "SurveyHeaderID": null, "Comments": null, "LastEditor": null, "LastUpdate": null, "SourceChannelID": null, "SourceChannelName": null, "SourceBathyPolyID": null, "DestPlacementAreaID": null, "DestPlacementExternalID": null, "QuantityCY": null, "QuantityType": null, "MaterialType": null, "PlacementMethod": null, "MoveStartDate": null, "MoveEndDate": null, "Contractor": null, "PrimaryDocURL": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 7, "name": "TB_PermitsUSACE", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PermitType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "Permit Type", "domain": { "type": "codedValue", "name": "PermitType", "description": "USACE permit type grouping", "codedValues": [ { "name": "Individual", "code": "Individual" }, { "name": "General", "code": "General" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "PermitType" }, { "name": "IssuedDate", "type": "esriFieldTypeDate", "alias": "Issued Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "IssuedDate" }, { "name": "ExpireDateWork", "type": "esriFieldTypeDate", "alias": "ExpireDateWork", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ExpireDateWork" }, { "name": "PermitStatus", "type": "esriFieldTypeString", "alias": "Permit Status", "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Operational status of the permit", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "PermitStatus" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "PermitID", "type": "esriFieldTypeString", "alias": "Permit ID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "PermitID" }, { "name": "FileNumber", "type": "esriFieldTypeString", "alias": "FileNumber", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FileNumber" }, { "name": "PermitSubtype", "type": "esriFieldTypeString", "alias": "PermitSubtype", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "PermitSubtype" }, { "name": "ExpireDateMaintenance", "type": "esriFieldTypeDate", "alias": "ExpireDateMaintenance", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ExpireDateMaintenance" }, { "name": "FacilityName", "type": "esriFieldTypeString", "alias": "FacilityName", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "FacilityName" }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LocationDescription" }, { "name": "PermittedDepthFT", "type": "esriFieldTypeDouble", "alias": "PermittedDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PermittedDepthFT" }, { "name": "MaintainedDepthFT", "type": "esriFieldTypeDouble", "alias": "MaintainedDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintainedDepthFT" }, { "name": "VerticalDatum", "type": "esriFieldTypeString", "alias": "VerticalDatum", "domain": { "type": "codedValue", "name": "VerticalDatum", "description": "Datum for depths/elevations.", "codedValues": [ { "name": "NAVD88", "code": "NAVD88" }, { "name": "NGVD29", "code": "NGVD29" }, { "name": "MLLW", "code": "MLLW" }, { "name": "MHW", "code": "MHW" }, { "name": "LocalTidal", "code": "LocalTidal" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "VerticalDatum" }, { "name": "PermittedDMPAs", "type": "esriFieldTypeString", "alias": "PermittedDMPAs", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PermittedDMPAs" }, { "name": "PrimaryDocURL", "type": "esriFieldTypeString", "alias": "PrimaryDocURL", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "PrimaryDocURL" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "DataSource" }, { "name": "SourceSystem", "type": "esriFieldTypeString", "alias": "SourceSystem", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SourceSystem" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdate" }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "LastEditor" }, { "name": "PermitRowID", "type": "esriFieldTypeInteger", "alias": "PermitRowID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PermitRowID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1132_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_PermitsUSACE", "description": "", "prototype": { "attributes": { "PermitRowID": null, "LastEditor": null, "GlobalID": null, "PermitType": null, "IssuedDate": null, "ExpireDateWork": null, "PermitStatus": null, "Notes": null, "PermitID": null, "FileNumber": null, "PermitSubtype": null, "ExpireDateMaintenance": null, "FacilityName": null, "LocationDescription": null, "PermittedDepthFT": null, "MaintainedDepthFT": null, "VerticalDatum": null, "PermittedDMPAs": null, "PrimaryDocURL": null, "DataSource": null, "SourceSystem": null, "Comments": null, "LastUpdate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 8, "name": "TB_Projects", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ProjectName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ProjectID", "type": "esriFieldTypeInteger", "alias": "Project ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProjectID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectName" }, { "name": "ProjectType", "type": "esriFieldTypeString", "alias": "Project Type", "domain": { "type": "codedValue", "name": "ProjectType", "description": "Top-level project classification.", "codedValues": [ { "name": "Dredging", "code": "Dredging" }, { "name": "PlacementArea", "code": "PlacementArea" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectType" }, { "name": "FY_AnchorDate", "type": "esriFieldTypeDate", "alias": "FY_AnchorDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FY_AnchorDate" }, { "name": "IssueSolicitationDate", "type": "esriFieldTypeDate", "alias": "IssueSolicitationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "IssueSolicitationDate" }, { "name": "ProjectStatus", "type": "esriFieldTypeString", "alias": "Project Status", "domain": { "type": "codedValue", "name": "ProjectStatus", "description": "Procurement/construction state.", "codedValues": [ { "name": "Advertised", "code": "Advertised" }, { "name": "Awarded", "code": "Awarded" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" }, { "name": "On Hold", "code": "On Hold" }, { "name": "Cancelled", "code": "Cancelled" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ProjectStatus" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Project Owner", "domain": { "type": "codedValue", "name": "Owner", "description": "Owning agency.", "codedValues": [ { "name": "USACE", "code": "USACE" }, { "name": "PHA", "code": "PHA" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Owner" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "ProjectSubtype", "type": "esriFieldTypeString", "alias": "ProjectSubtype", "domain": { "type": "codedValue", "name": "ProjectType", "description": "Top-level project classification.", "codedValues": [ { "name": "Dredging", "code": "Dredging" }, { "name": "PlacementArea", "code": "PlacementArea" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectSubtype" }, { "name": "FiscalYear", "type": "esriFieldTypeSmallInteger", "alias": "FiscalYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FiscalYear" }, { "name": "FileNumber", "type": "esriFieldTypeString", "alias": "FileNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FileNumber" }, { "name": "PONumber", "type": "esriFieldTypeString", "alias": "PONumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PONumber" }, { "name": "ContractName", "type": "esriFieldTypeString", "alias": "ContractName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ContractName" }, { "name": "ProjectReach", "type": "esriFieldTypeString", "alias": "ProjectReach", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectReach" }, { "name": "ProjectAOIStation", "type": "esriFieldTypeString", "alias": "ProjectAOIStation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectAOIStation" }, { "name": "DredgeName", "type": "esriFieldTypeString", "alias": "DredgeName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DredgeName" }, { "name": "DredgeType", "type": "esriFieldTypeString", "alias": "DredgeType", "domain": { "type": "codedValue", "name": "DredgeType", "description": "Primary dredge equipment type.", "codedValues": [ { "name": "CSD", "code": "CSD" }, { "name": "TSHD", "code": "TSHD" }, { "name": "Mechanical", "code": "Mechanical" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DredgeType" }, { "name": "CTRequiredDepthFT", "type": "esriFieldTypeDouble", "alias": "CTRequiredDepthFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CTRequiredDepthFT" }, { "name": "BidOpeningDate", "type": "esriFieldTypeDate", "alias": "BidOpeningDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BidOpeningDate" }, { "name": "AwardDate", "type": "esriFieldTypeDate", "alias": "AwardDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AwardDate" }, { "name": "RequiredCompletionDate", "type": "esriFieldTypeDate", "alias": "RequiredCompletionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RequiredCompletionDate" }, { "name": "ActualCompletionDate", "type": "esriFieldTypeDate", "alias": "ActualCompletionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ActualCompletionDate" }, { "name": "SolicitationNumber", "type": "esriFieldTypeString", "alias": "SolicitationNumber", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SolicitationNumber" }, { "name": "ContractNumber", "type": "esriFieldTypeString", "alias": "ContractNumber", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "ContractNumber" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Contractor" }, { "name": "ActiveConstruction", "type": "esriFieldTypeString", "alias": "ActiveConstruction", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ActiveConstruction" }, { "name": "PlacementAreaName", "type": "esriFieldTypeString", "alias": "PlacementAreaName", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "PlacementAreaName" }, { "name": "FacilityName", "type": "esriFieldTypeString", "alias": "FacilityName", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "FacilityName" }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LocationDescription" }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DataSource" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "PrimaryDocURL", "type": "esriFieldTypeString", "alias": "PrimaryDocURL", "domain": null, "editable": true, "nullable": true, "length": 1024, "defaultValue": null, "modelName": "PrimaryDocURL" }, { "name": "SourceJobID", "type": "esriFieldTypeString", "alias": "SourceJobID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SourceJobID" }, { "name": "SourceSystem", "type": "esriFieldTypeString", "alias": "SourceSystem", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SourceSystem" }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDate" }, { "name": "EstimatedQuantityCY", "type": "esriFieldTypeDouble", "alias": "EstimatedQuantityCY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedQuantityCY" }, { "name": "CTAwardAmountUSD", "type": "esriFieldTypeDouble", "alias": "CTAwardAmountUSD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CTAwardAmountUSD" }, { "name": "CTFinalAmountUSD", "type": "esriFieldTypeDouble", "alias": "CTFinalAmountUSD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CTFinalAmountUSD" }, { "name": "ContractQuantityCY", "type": "esriFieldTypeDouble", "alias": "ContractQuantityCY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ContractQuantityCY" }, { "name": "FinalQuantityCY", "type": "esriFieldTypeDouble", "alias": "FinalQuantityCY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FinalQuantityCY" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DMPANames", "type": "esriFieldTypeString", "alias": "DMPANames", "domain": { "type": "codedValue", "name": "DMPA Names", "description": "Placement Area Names", "codedValues": [ { "name": "Alexander Island PA", "code": "Alexander_Island_PA" }, { "name": "Bolivar Marsh", "code": "Bolivar" }, { "name": "Atikinson M12", "code": "Atikinson_M12" }, { "name": "Atkinson Is. Marsh", "code": "Atkinson_Is_Marsh" }, { "name": "Atkinson M10", "code": "Atkinson_M10" }, { "name": "Atkinson M11", "code": "Atkinson_M11" }, { "name": "Atkinson M5/M6", "code": "Atkinson_M5_M6" }, { "name": "Atkinson M7/8/9", "code": "Atkinson_M7_8_9" }, { "name": "Beltway 8 PA", "code": "Beltway_8_PA" }, { "name": "E2 Clinton PA", "code": "E2_Clinton_PA" }, { "name": "East Clinton PA", "code": "East_Clinton_PA" }, { "name": "Filter Bed", "code": "Filter_Bed" }, { "name": "Glendale PA", "code": "Glendale_PA" }, { "name": "Greens Bayou PA", "code": "Greens_Bayou_PA" }, { "name": "House Tract PA", "code": "House_Tract_PA" }, { "name": "Lost Lake PA", "code": "Lost_Lake_PA" }, { "name": "Mid Bay PA", "code": "Mid_Bay_PA" }, { "name": "Peggy Lake PA", "code": "Peggy_Lake_PA" }, { "name": "PA 13", "code": "PA_13" }, { "name": "PA 14", "code": "PA_14" }, { "name": "PA 15", "code": "PA_15" }, { "name": "PA 16", "code": "PA_16" }, { "name": "Rosa Allen PA", "code": "Rosa_Allen_PA" }, { "name": "Spilman Island PA", "code": "Spilman_Island_PA" }, { "name": "West Clinton PA", "code": "West_Clinton_PA" }, { "name": "Long Bird Island", "code": "Long_Bird_Island" }, { "name": "Three Bird Island", "code": "Three_Bird_Island" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DMPANames" } ], "indexes": [ { "name": "R1130_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_Projects", "description": "", "prototype": { "attributes": { "FinalQuantityCY": null, "DMPANames": null, "ProjectID": null, "GlobalID": null, "ProjectName": null, "ProjectType": null, "FY_AnchorDate": null, "IssueSolicitationDate": null, "ProjectStatus": null, "Owner": null, "Notes": null, "ProjectSubtype": null, "FiscalYear": null, "FileNumber": null, "PONumber": null, "ContractName": null, "ProjectReach": null, "ProjectAOIStation": null, "DredgeName": null, "DredgeType": null, "CTRequiredDepthFT": null, "BidOpeningDate": null, "AwardDate": null, "RequiredCompletionDate": null, "ActualCompletionDate": null, "SolicitationNumber": null, "ContractNumber": null, "Contractor": null, "ActiveConstruction": null, "PlacementAreaName": null, "FacilityName": null, "LocationDescription": null, "DataSource": null, "Comments": null, "PrimaryDocURL": null, "SourceJobID": null, "SourceSystem": null, "StartDate": null, "EstimatedQuantityCY": null, "CTAwardAmountUSD": null, "CTFinalAmountUSD": null, "ContractQuantityCY": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 9, "name": "TB_REST_ServiceRegistry", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ServiceName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ServiceID", "type": "esriFieldTypeInteger", "alias": "Service ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceID" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "ServiceType", "type": "esriFieldTypeString", "alias": "Service Type", "domain": { "type": "codedValue", "name": "ServiceType", "description": "Type of remote service", "codedValues": [ { "name": "FeatureServer", "code": "FeatureServer" }, { "name": "MapServer", "code": "MapServer" }, { "name": "ImageServer", "code": "ImageServer" }, { "name": "WMS", "code": "WMS" }, { "name": "WFS", "code": "WFS" }, { "name": "OtherREST", "code": "OtherREST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServiceType" }, { "name": "URL", "type": "esriFieldTypeString", "alias": "Service URL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "URL" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Service Owner", "domain": { "type": "codedValue", "name": "Owner", "description": "Owning agency.", "codedValues": [ { "name": "USACE", "code": "USACE" }, { "name": "PHA", "code": "PHA" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Owner" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "PollFrequencyDays", "type": "esriFieldTypeSmallInteger", "alias": "PollFrequencyDays", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PollFrequencyDays" }, { "name": "SourceSystem", "type": "esriFieldTypeString", "alias": "SourceSystem", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SourceSystem" }, { "name": "AuthType", "type": "esriFieldTypeString", "alias": "AuthType", "domain": { "type": "codedValue", "name": "AuthType", "description": "Authentication required", "codedValues": [ { "name": "Public", "code": "Public" }, { "name": "Token", "code": "Token" }, { "name": "OAuth2", "code": "OAuth2" }, { "name": "APIKey", "code": "APIKey" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AuthType" }, { "name": "LastVerified", "type": "esriFieldTypeDate", "alias": "LastVerified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastVerified" }, { "name": "LastStatus", "type": "esriFieldTypeString", "alias": "LastStatus", "domain": { "type": "codedValue", "name": "ServiceStatus", "description": "Status of last check", "codedValues": [ { "name": "OK", "code": "OK" }, { "name": "Warning", "code": "Warning" }, { "name": "Error", "code": "Error" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LastStatus" }, { "name": "LastStatusMessage", "type": "esriFieldTypeString", "alias": "LastStatusMessage", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "LastStatusMessage" }, { "name": "License", "type": "esriFieldTypeString", "alias": "License", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "License" }, { "name": "Tags", "type": "esriFieldTypeString", "alias": "Tags", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Tags" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1135_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_REST_ServiceRegistry", "description": "", "prototype": { "attributes": { "Tags": null, "License": null, "ServiceID": null, "GlobalID": null, "ServiceType": null, "URL": null, "Owner": null, "Comments": null, "Name": null, "PollFrequencyDays": null, "SourceSystem": null, "AuthType": null, "LastVerified": null, "LastStatus": null, "LastStatusMessage": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }