Layer: T_Completions_GIS_XY

View In: Map Viewer

Name: T_Completions_GIS_XY_ALL

Display Field: APPNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"78d3750abf5d36188a99505f907fc10d","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAOZJREFUKJGd0i9LBEEYB+DnPU4WTGc2WrRqOfQr2ESTzXBY/CQGxarNIhwGQQWLSYz6BbQZTFYnnGPYdTk8dl18YcL8efi9M0zfP6v/eyEzwGYuimVMIqVn3AafjTCzh0MMIqXprbfMKLiegZkDHDd0toirzHZwWcPMUpXUVj2cZu6DjxIWxShSmvsDwgJ2cdKHSGnYAam6G9YQ811hVGd/7vgSrHVKLIpXKZUwGGOnY+K4TlROHrDRmsZFL6XHGgY5s4UbrDa4uyg/iOlEwXtmHfvKJ1/BBE84w3nwNQMrnHBUjdb6BpTbPKSzy8vGAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
REFVAL (type: esriFieldTypeString, alias: REFVAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SATYPE (type: esriFieldTypeString, alias: SATYPE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
APPNAME (type: esriFieldTypeString, alias: APPNAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
App_Count (type: esriFieldTypeInteger, alias: App_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
DSCRPN (type: esriFieldTypeString, alias: DSCRPN, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
EASTING (type: esriFieldTypeInteger, alias: EASTING, SQL Type: sqlTypeOther, nullable: true, editable: true)
NORTHING (type: esriFieldTypeInteger, alias: NORTHING, SQL Type: sqlTypeOther, nullable: true, editable: true)
No_of_Plots (type: esriFieldTypeInteger, alias: No_of_Plots, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNI_WARD (type: esriFieldTypeString, alias: UNI_WARD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
APPTYP (type: esriFieldTypeString, alias: APPTYP, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
NonEffectHousing (type: esriFieldTypeString, alias: NonEffectHousing, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
NonEffectCount (type: esriFieldTypeSmallInteger, alias: NonEffectCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
ApplicationType (type: esriFieldTypeString, alias: ApplicationType, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SBAREATM (type: esriFieldTypeString, alias: SBAREATM, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
VALWORK (type: esriFieldTypeDouble, alias: VALWORK, SQL Type: sqlTypeOther, nullable: true, editable: true)
OFFICR (type: esriFieldTypeString, alias: OFFICR, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
PRKEYVAL (type: esriFieldTypeString, alias: PRKEYVAL, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
UNI_WARD_NAME (type: esriFieldTypeString, alias: UNI_WARD_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
AFFORDABLE (type: esriFieldTypeString, alias: AFFORDABLE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
MONTH_ (type: esriFieldTypeString, alias: MONTH_, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
YEAR_ (type: esriFieldTypeString, alias: YEAR_, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
QUARTER (type: esriFieldTypeSmallInteger, alias: QUARTER, SQL Type: sqlTypeOther, nullable: true, editable: true)
FINANCIAL_YEAR (type: esriFieldTypeString, alias: FINANCIAL_YEAR, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
COMPLETION_DATE (type: esriFieldTypeDate, alias: COMPLETION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PLOTNO (type: esriFieldTypeDouble, alias: PLOTNO, SQL Type: sqlTypeOther, nullable: true, editable: true)
WARD_NO_1999 (type: esriFieldTypeSmallInteger, alias: WARD_NO_1999, SQL Type: sqlTypeOther, nullable: true, editable: true)
WARD_NAME_1999 (type: esriFieldTypeString, alias: WARD_NAME_1999, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
WARD_NO_1996 (type: esriFieldTypeInteger, alias: WARD_NO_1996, SQL Type: sqlTypeOther, nullable: true, editable: true)
WARD_NAME_1996 (type: esriFieldTypeString, alias: WARD_NAME_1996, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
HCAREA_1996 (type: esriFieldTypeString, alias: HCAREA_1996, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
HCAREA_NAME_1996 (type: esriFieldTypeString, alias: HCAREA_NAME_1996, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HCAREA_NAME_1999 (type: esriFieldTypeString, alias: HCAREA_NAME_1999, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
HCAREA_1999 (type: esriFieldTypeString, alias: HCAREA_1999, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
HCAREA_2007 (type: esriFieldTypeString, alias: HCAREA_2007, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
DZ_ZONECODE (type: esriFieldTypeString, alias: DZ_ZONECODE, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
DZ_NAME (type: esriFieldTypeString, alias: DZ_NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
DZ_SEQUENCE (type: esriFieldTypeDouble, alias: DZ_SEQUENCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SZ (type: esriFieldTypeString, alias: SZ, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
SZ_NAME (type: esriFieldTypeString, alias: SZ_NAME, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
SZ_REF (type: esriFieldTypeString, alias: SZ_REF, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
FORMERLP_NAME (type: esriFieldTypeString, alias: FORMERLP_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
CURRENTLP_NAME (type: esriFieldTypeString, alias: CURRENTLP_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
DEVLP_NAME (type: esriFieldTypeString, alias: DEVLP_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
LP_HINTERLAND_ID (type: esriFieldTypeInteger, alias: LP_HINTERLAND_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
LP_HINTERLAND_LP (type: esriFieldTypeString, alias: LP_HINTERLAND_LP, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
LP_HINTERLAND_LOCATION (type: esriFieldTypeString, alias: LP_HINTERLAND_LOCATION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
HLA_SETTLEMENT (type: esriFieldTypeString, alias: HLA_SETTLEMENT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
HLA_ALLOUNIQUE (type: esriFieldTypeString, alias: HLA_ALLOUNIQUE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HLA_PLAN (type: esriFieldTypeString, alias: HLA_PLAN, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
HLA_DRAFT (type: esriFieldTypeString, alias: HLA_DRAFT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
HLA_DATE (type: esriFieldTypeString, alias: HLA_DATE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SETDEVAREA_SETTLEMENT (type: esriFieldTypeString, alias: SETDEVAREA_SETTLEMENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MAJORDEVAREA (type: esriFieldTypeString, alias: MAJORDEVAREA, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
CAIRNGORMSNP (type: esriFieldTypeString, alias: CAIRNGORMSNP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HMA_AREA (type: esriFieldTypeString, alias: HMA_AREA, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
HMA_IN_AREA (type: esriFieldTypeString, alias: HMA_IN_AREA, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
WFMASTERREFVAL (type: esriFieldTypeString, alias: WFMASTERREFVAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
WFPART (type: esriFieldTypeString, alias: WFPART, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
HLA2010LPSiteCode (type: esriFieldTypeString, alias: HLA2010LPSiteCode, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HLA2010LPSERIALNUMBER (type: esriFieldTypeSmallInteger, alias: HLA2010LPSERIALNUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
HLA2010LPALLOCATION (type: esriFieldTypeSmallInteger, alias: HLA2010LPALLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
HWLPALLOCATION (type: esriFieldTypeString, alias: HWLPALLOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HWLPLOCATION (type: esriFieldTypeString, alias: HWLPLOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HWLPMAJORTYPE (type: esriFieldTypeString, alias: HWLPMAJORTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HWLPMAJORNAME (type: esriFieldTypeString, alias: HWLPMAJORNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HWLPMAJORPHASE (type: esriFieldTypeString, alias: HWLPMAJORPHASE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SDASOURCETHM (type: esriFieldTypeString, alias: SDASOURCETHM, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
IMF_LOCALPLAN (type: esriFieldTypeString, alias: IMF_LOCALPLAN, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
IMF_Hinterland (type: esriFieldTypeString, alias: IMF_Hinterland, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
WARD_NO (type: esriFieldTypeString, alias: WARD_NO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
WARD_NAME (type: esriFieldTypeString, alias: WARD_NAME, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
HC_Ward_Name_2017 (type: esriFieldTypeString, alias: HC_Ward_Name_2017, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
HC_Ward_No_2017 (type: esriFieldTypeDouble, alias: HC_Ward_No_2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
Combo (type: esriFieldTypeString, alias: Combo, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
Conc_Address (type: esriFieldTypeString, alias: Conc_Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
POSTCODE (type: esriFieldTypeString, alias: POSTCODE, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
UPRN_From_CAG (type: esriFieldTypeString, alias: UPRN_From_CAG, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
Planning_Ref (type: esriFieldTypeString, alias: Planning_Ref, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
Ho_Type (type: esriFieldTypeString, alias: Ho_Type, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
Heating (type: esriFieldTypeString, alias: Heating, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Aff_Ho (type: esriFieldTypeSmallInteger, alias: Aff_Ho, SQL Type: sqlTypeOther, nullable: true, editable: true)
Bedrooms (type: esriFieldTypeSingle, alias: Bedrooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
Storeys (type: esriFieldTypeSingle, alias: Storeys, SQL Type: sqlTypeOther, nullable: true, editable: true)
Ent_Level (type: esriFieldTypeSmallInteger, alias: Ent_Level, SQL Type: sqlTypeOther, nullable: true, editable: true)
UPRN (type: esriFieldTypeString, alias: UPRN, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
CAG_EASTING (type: esriFieldTypeInteger, alias: CAG_EASTING, SQL Type: sqlTypeOther, nullable: true, editable: true)
CAG_NORTHING (type: esriFieldTypeInteger, alias: CAG_NORTHING, SQL Type: sqlTypeOther, nullable: true, editable: true)
CAG_ADDRESS (type: esriFieldTypeString, alias: CAG_ADDRESS, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
CAG_POSTCODE (type: esriFieldTypeString, alias: CAG_POSTCODE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
BLPU_CLASS (type: esriFieldTypeString, alias: BLPU_CLASS, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
BLPU_STATE (type: esriFieldTypeString, alias: BLPU_STATE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
END_D (type: esriFieldTypeDate, alias: END_D, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LPI_KEY (type: esriFieldTypeString, alias: LPI_KEY, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/28/2026 1:14:24 PM

Schema Last Edit Date: 4/28/2026 1:14:24 PM

Data Last Edit Date: 4/28/2026 1:14:24 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: T_Completions_GIS_XY_ALL (ID:0)