Parent Layer: Blocks (SPG)

Name: Blocks History (SPG)

Display Field: BLOCK_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Polygon layer with all blocks in the E/P Contracts database (both valid and invalid, all block types). The business table contains the majority of columns in the ADM Block Header table (excluding the codes, qualifiers and id columns). The layer is 'stacked', that is, it contains multiple features per block with each feature describing the stages and events of a contract or other block types.

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -2.0037507067161843E7
YMin: -7716607.550987867
XMax: 2.0037507067161843E7
YMax: 1.5705214557325345E7
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 0, 0, 0]
Outline:
Style: esriSLSSolid
Color: [0, 0, 192, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GA_ID ( type: esriFieldTypeDouble, alias: GA_ID )
• BLOCK_NAME ( type: esriFieldTypeString, alias: BLOCK_NAME, length: 50 )
• CONTRACT_BLOCK_NAME ( type: esriFieldTypeString, alias: CON_BLK_NM, length: 101 )
• OPERATOR_NAME ( type: esriFieldTypeString, alias: OPERATOR, length: 50 )
• OPERATOR_ACRONYM ( type: esriFieldTypeString, alias: OP_ACRONYM, length: 10 )
• AWARD_DATE ( type: esriFieldTypeDate, alias: AWARD, length: 8 )
• AWARD_DATE_YEAR ( type: esriFieldTypeSmallInteger, alias: AWARD_Y )
• EXPIRY_DATE ( type: esriFieldTypeDate, alias: EXP_DATE, length: 8 )
• EXPIRY_DATE_YEAR ( type: esriFieldTypeSmallInteger, alias: EXP_DAT_Y )
• BLOCK_STATUS ( type: esriFieldTypeString, alias: BLOCK_STAT, length: 20 )
• LICENSING_ROUND_DESIGNATION ( type: esriFieldTypeString, alias: LIC_RND_DS, length: 50 )
• COUNTRY_NAME ( type: esriFieldTypeString, alias: COUNTRY, length: 50 )
• COUNTRY_ID ( type: esriFieldTypeString, alias: COUNTRY_ID, length: 12 )
• REGION_NAME ( type: esriFieldTypeString, alias: REGION_NM, length: 50 )
• REGION_ID ( type: esriFieldTypeString, alias: REGION_ID, length: 12 )
• MAIN_POLITICAL_PROVINCE ( type: esriFieldTypeString, alias: POL_PROV, length: 50 )
• BASIN_NAMES ( type: esriFieldTypeString, alias: BAS_NAMES, length: 2000 )
• GENERAL_CLASS ( type: esriFieldTypeString, alias: GN_CLASS, length: 20 )
• GENERAL_CONTRACT_TYPE ( type: esriFieldTypeString, alias: GN_CON_TYP, length: 20 )
• CONTRACT_TYPE ( type: esriFieldTypeString, alias: CON_TYPE, length: 20 )
• CONTRACT_NAME ( type: esriFieldTypeString, alias: CONTRACT, length: 50 )
• STAGE_NUMB ( type: esriFieldTypeSmallInteger, alias: STAGE_NUMB )
• CONTRACT_STATUS ( type: esriFieldTypeString, alias: CON_STATUS, length: 20 )
• CONTRACT_STAGE_EVENTS ( type: esriFieldTypeString, alias: CON_ST_EVT, length: 2000 )
• START_DATE ( type: esriFieldTypeDate, alias: START_DATE, length: 8 )
• END_DATE ( type: esriFieldTypeDate, alias: END_DATE, length: 8 )
• APPLICATION_DATE ( type: esriFieldTypeDate, alias: APPL_DATE, length: 8 )
• APPLICATION_DATE_YEAR ( type: esriFieldTypeSmallInteger, alias: APPL_DAT_Y )
• RIGHTS_TYPE ( type: esriFieldTypeString, alias: RT_TYPE, length: 20 )
• RIGHTS_BELOW_METER ( type: esriFieldTypeDouble, alias: RGT_BLW_M )
• RIGHTS_ABOVE_METER ( type: esriFieldTypeDouble, alias: RGT_ABV_M )
• RIGHTS_BELOW_FEET ( type: esriFieldTypeDouble, alias: RGT_BLW_FT )
• RIGHTS_ABOVE_FEET ( type: esriFieldTypeDouble, alias: RGT_ABV_FT )
• GROUP_NAME ( type: esriFieldTypeString, alias: GRP_NAME, length: 50 )
• CONTRACT_OPERATOR_NAME ( type: esriFieldTypeString, alias: CON_OP_NM, length: 50 )
• CONTRACT_GROUP_NAME ( type: esriFieldTypeString, alias: CON_GRP_NM, length: 50 )
• ONS_OFFSHORE ( type: esriFieldTypeString, alias: ONS_OFF, length: 20 )
• TERRAINS ( type: esriFieldTypeString, alias: TERRAINS, length: 200 )
• BLOCK_SQKM ( type: esriFieldTypeDouble, alias: BLOCK_SQKM )
• ONSHORE_SQKM ( type: esriFieldTypeDouble, alias: ONS_SQKM )
• SHELF_SQKM ( type: esriFieldTypeDouble, alias: SHELF_SQKM )
• DEEP_WATER_SQKM ( type: esriFieldTypeDouble, alias: DEEPW_SQKM )
• CONTRACT_SQKM ( type: esriFieldTypeDouble, alias: CON_SQKM )
• PCT_OF_ORIGINAL_AREA_REMAINING ( type: esriFieldTypeDouble, alias: PCT_ORIG_A )
• CONTRACT_ONSHORE_SQKM ( type: esriFieldTypeDouble, alias: CON_ONS_SK )
• CONTRACT_SHELF_SQKM ( type: esriFieldTypeDouble, alias: CON_SHF_SK )
• CONTRACT_DEEP_WATER_SQKM ( type: esriFieldTypeDouble, alias: CON_DPW_SK )
• MIN_WATER_DEPTH_METER ( type: esriFieldTypeDouble, alias: MIN_WD_M )
• MEDIAN_WATER_DEPTH_METER ( type: esriFieldTypeDouble, alias: MED_WD_M )
• MAX_WATER_DEPTH_METER ( type: esriFieldTypeDouble, alias: MAX_WD_M )
• MIN_WATER_DEPTH_FEET ( type: esriFieldTypeDouble, alias: MIN_WD_FT )
• MEDIAN_WATER_DEPTH_FEET ( type: esriFieldTypeDouble, alias: MED_WD_FT )
• MAX_WATER_DEPTH_FEET ( type: esriFieldTypeDouble, alias: MAX_WD_FT )
• RENEWAL_SCH_DATES ( type: esriFieldTypeString, alias: REN_SC_DAT, length: 2000 )
• REDUCTION_SCH_DATES ( type: esriFieldTypeString, alias: RED_SC_DAT, length: 2000 )
• EXP_EXPIRY_SCH_DATE ( type: esriFieldTypeDate, alias: EEX_SC_DAT, length: 8 )
• PROD_EXPIRY_SCH_DATE ( type: esriFieldTypeDate, alias: PRD_SC_DAT, length: 8 )
• EXPIRY_SCH_DATE ( type: esriFieldTypeDate, alias: EXP_SC_DAT, length: 8 )
• PREVIOUS_BLOCK_NAME ( type: esriFieldTypeString, alias: PRV_BLK_NM, length: 50 )
• DATUM_NAME ( type: esriFieldTypeString, alias: DATUM, length: 50 )
• DATA_OWNER ( type: esriFieldTypeString, alias: DATA_OWNER, length: 50 )
• EPCSTG_ID ( type: esriFieldTypeDouble, alias: EPCSTG_ID )
• EPC_ID ( type: esriFieldTypeDouble, alias: EPC_ID )
• OPERATOR_PUH_ID ( type: esriFieldTypeDouble, alias: OP_PUH_ID )
• PAR_ID ( type: esriFieldTypeDouble, alias: PAR_ID )
• BLOCK_VALIDITY_FLAG ( type: esriFieldTypeString, alias: BLK_VALID, length: 1 )
• CONTRACT_VALIDITY_FLAG ( type: esriFieldTypeString, alias: CON_VALID, length: 1 )
• FARM_OUT_FLAG ( type: esriFieldTypeString, alias: FARMED_OUT, length: 1 )
• LAST_STAGE_FLAG ( type: esriFieldTypeString, alias: LAST_STAGE, length: 1 )
• DATE_OF_LAST_DB_UPDATE ( type: esriFieldTypeDate, alias: DB_UPDATE, length: 8 )
• DATE_OF_ENTRY ( type: esriFieldTypeDate, alias: DATE_OF_ENTRY, length: 8 )
• DATE_OF_LAST_LOAD ( type: esriFieldTypeDate, alias: DATE_OF_LAST_LOAD, length: 8 )
• DATE_OF_LAST_REFRESH ( type: esriFieldTypeDate, alias: DATE_OF_LAST_REFRESH, length: 8 )
• CURRENT_FDU_ID ( type: esriFieldTypeDouble, alias: CURRENT_FDU_ID )
• UNLICENSED_BLOCK_STATUS ( type: esriFieldTypeString, alias: UN_BLK_STA, length: 20 )
• BLOCK_AVAIL_IND ( type: esriFieldTypeString, alias: BLK_AVL_IN, length: 20 )
• FARM_IN_AVAILABILITY_FLAG ( type: esriFieldTypeString, alias: FAR_AVA_FG, length: 1 )
• FARM_IN_TOTAL_PCT_AVAILABLE ( type: esriFieldTypeDouble, alias: FAR_TOT_AV )
• FARM_IN_OPP_OFFERS ( type: esriFieldTypeString, alias: FAR_OPP_OF, length: 2000 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata