View In:   ArcGIS Online Map Viewer

Name: NWT Civic Address Point

Display Field: fullname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset represents points where address site data has been collected. These points are an amalgamation of different origin point data translated into a NG911-compliant schema using ESRI's Address Management Solution as a reference for compliance and data integrity.*This dataset requires extensive QA/QC and should not be used as an authoritative, source only for application-testing purposes*

Copyright Text: NWTCG, NWT Stats, City of Yellowknife, ESRI, NWT Community Address Bylaws

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 35000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1560087.9393999986
YMin: 2338079.525800001
XMax: -741708.1093999967
YMax: 3782210.3409
Spatial Reference: 102002  (102002)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: pointtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ;
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Building
  Label: Building
  Description: N/A
  Symbol:
  
• Value: Base
  Label: Multi-Unit Building
  Description: N/A
  Symbol:
  
• Value: Unit, Condo, Office or Suite
  Label: Unit, Condo, Office or Suite
  Description: N/A
  Symbol:
  
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: pointtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• siteaddid ( type: esriFieldTypeInteger, alias: siteaddid, editable: false, nullable: true, defaultValue: null, modelName: siteaddid )
• centerlineid ( type: esriFieldTypeInteger, alias: centerlineid, editable: false, nullable: true, defaultValue: null, modelName: centerlineid )
• addressptid ( type: esriFieldTypeString, alias: addressptid, editable: false, nullable: true, length: 20, defaultValue: null, modelName: addressptid )
• rclnguid ( type: esriFieldTypeString, alias: rclnguid, editable: false, nullable: true, length: 254, defaultValue: null, modelName: rclnguid )
• discrpagid ( type: esriFieldTypeString, alias: discrpagid, editable: false, nullable: true, length: 75, defaultValue: null, modelName: discrpagid )
• roadnameid ( type: esriFieldTypeInteger, alias: roadnameid, editable: false, nullable: true, defaultValue: null, modelName: roadnameid )
• preaddrnum ( type: esriFieldTypeString, alias: preaddrnum, editable: false, nullable: true, length: 5, defaultValue: null, modelName: preaddrnum )
• addrnumsuf ( type: esriFieldTypeString, alias: addrnumsuf, editable: false, nullable: true, length: 5, defaultValue: null, modelName: addrnumsuf )
• addrnum ( type: esriFieldTypeString, alias: addrnum, editable: false, nullable: true, length: 20, defaultValue: null, modelName: addrnum )
• addrrange ( type: esriFieldTypeString, alias: addrrange, editable: false, nullable: true, length: 50, defaultValue: null, modelName: addrrange )
• unittype ( type: esriFieldTypeString, alias: unittype, editable: false, nullable: true, length: 25, defaultValue: null, modelName: unittype , Coded Values: [Apartment: Apartment] , [Basement: Basement] , [Building: Building] , ...24 more... )
• unitid ( type: esriFieldTypeString, alias: unitid, editable: false, nullable: true, length: 10, defaultValue: null, modelName: unitid )
• altunittype ( type: esriFieldTypeString, alias: altunittype, editable: false, nullable: true, length: 25, defaultValue: null, modelName: altunittype , Coded Values: [Apartment: Apartment] , [Basement: Basement] , [Building: Building] , ...24 more... )
• altunitid ( type: esriFieldTypeString, alias: altunitid, editable: false, nullable: true, length: 10, defaultValue: null, modelName: altunitid )
• secondaltunittype ( type: esriFieldTypeString, alias: secondaltunittype, editable: false, nullable: true, length: 25, defaultValue: null, modelName: secondaltunittype , Coded Values: [Apartment: Apartment] , [Basement: Basement] , [Building: Building] , ...24 more... )
• secondaltunitid ( type: esriFieldTypeString, alias: secondaltunitid, editable: false, nullable: true, length: 10, defaultValue: null, modelName: secondaltunitid )
• thirdaltunittype ( type: esriFieldTypeString, alias: thirdaltunittype, editable: false, nullable: true, length: 25, defaultValue: null, modelName: thirdaltunittype , Coded Values: [Apartment: Apartment] , [Basement: Basement] , [Building: Building] , ...24 more... )
• thirdaltunitid ( type: esriFieldTypeString, alias: thirdaltunitid, editable: false, nullable: true, length: 10, defaultValue: null, modelName: thirdaltunitid )
• fourthaltunittype ( type: esriFieldTypeString, alias: fourthaltunittype, editable: false, nullable: true, length: 25, defaultValue: null, modelName: fourthaltunittype , Coded Values: [Apartment: Apartment] , [Basement: Basement] , [Building: Building] , ...24 more... )
• fourthaltunitid ( type: esriFieldTypeString, alias: fourthaltunitid, editable: false, nullable: true, length: 10, defaultValue: null, modelName: fourthaltunitid )
• fullname ( type: esriFieldTypeString, alias: fullname, editable: false, nullable: true, length: 300, defaultValue: null, modelName: fullname )
• fulladdr ( type: esriFieldTypeString, alias: fulladdr, editable: false, nullable: true, length: 500, defaultValue: null, modelName: fulladdr )
• placename ( type: esriFieldTypeString, alias: placename, editable: false, nullable: true, length: 250, defaultValue: null, modelName: placename )
• country ( type: esriFieldTypeString, alias: country, editable: false, nullable: true, length: 2, defaultValue: CA, modelName: country )
• provterrabbreviation ( type: esriFieldTypeString, alias: provterrabbreviation, editable: false, nullable: true, length: 2, defaultValue: NT, modelName: provterrabbreviation , Coded Values: [AB: AB] , [BC: BC] , [MB: MB] , ...10 more... )
• municipality ( type: esriFieldTypeString, alias: municipality, editable: false, nullable: true, length: 100, defaultValue: null, modelName: municipality )
• communityid ( type: esriFieldTypeSmallInteger, alias: communityid, editable: false, nullable: true, defaultValue: null, modelName: communityid )
• esn ( type: esriFieldTypeString, alias: esn, editable: false, nullable: true, length: 5, defaultValue: null, modelName: esn )
• msag ( type: esriFieldTypeString, alias: msag, editable: false, nullable: true, length: 35, defaultValue: null, modelName: msag )
• usngcoord ( type: esriFieldTypeString, alias: usngcoord, editable: false, nullable: true, length: 50, defaultValue: null, modelName: usngcoord )
• addrclass ( type: esriFieldTypeInteger, alias: addrclass, editable: false, nullable: true, defaultValue: null, modelName: addrclass )
• pointtype ( type: esriFieldTypeString, alias: pointtype, editable: false, nullable: true, length: 30, defaultValue: null, modelName: pointtype , Coded Values: [Base: Base] , [Building: Building] , [Mile Post: Mile Post] , ...9 more... )
• capturemeth ( type: esriFieldTypeString, alias: capturemeth, editable: false, nullable: true, length: 30, defaultValue: null, modelName: capturemeth , Coded Values: [Community Contribution: Community Contribution] , [Other: Other] , [Plan or Drawing: Plan or Drawing] , ...1 more... )
• status ( type: esriFieldTypeString, alias: status, editable: false, nullable: true, length: 30, defaultValue: null, modelName: status , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• lotnum ( type: esriFieldTypeString, alias: lotnum, editable: false, nullable: true, length: 10, defaultValue: null, modelName: lotnum )
• blocknum ( type: esriFieldTypeString, alias: blocknum, editable: false, nullable: true, length: 10, defaultValue: null, modelName: blocknum )
• plannum ( type: esriFieldTypeString, alias: plannum, editable: false, nullable: true, length: 10, defaultValue: null, modelName: plannum )
• postalcode ( type: esriFieldTypeString, alias: postalcode, editable: false, nullable: true, length: 7, defaultValue: null, modelName: postalcode )
• validated ( type: esriFieldTypeString, alias: validated, editable: false, nullable: true, length: 3, defaultValue: null, modelName: validated )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: Building
Name: Building
Domains:
• unittype:
  Inherited
• altunittype:
  Inherited
• secondaltunittype:
  Inherited
• thirdaltunittype:
  Inherited
• fourthaltunittype:
  Inherited
• provterrabbreviation:
  Inherited
• pointtype:
  Inherited
• capturemeth:
  Inherited
• status:
  Inherited
Templates:
• Name: Building
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Base
Name: Multi-Unit Building
Domains:
• unittype:
  Inherited
• altunittype:
  Inherited
• secondaltunittype:
  Inherited
• thirdaltunittype:
  Inherited
• fourthaltunittype:
  Inherited
• provterrabbreviation:
  Inherited
• pointtype:
  Inherited
• capturemeth:
  Inherited
• status:
  Inherited
Templates:
• Name: Multi-Unit Building
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Unit, Condo, Office or Suite
Name: Unit, Condo, Office or Suite
Domains:
• unittype:
  Inherited
• altunittype:
  Inherited
• secondaltunittype:
  Inherited
• thirdaltunittype:
  Inherited
• fourthaltunittype:
  Inherited
• provterrabbreviation:
  Inherited
• pointtype:
  Inherited
• capturemeth:
  Inherited
• status:
  Inherited
Templates:
• Name: Unit, Condo, Office or Suite
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• sd.DBO.LOC_MACA_CA_AliasRoadName_OPS (0) -- Related To: Alias Road Name Table (33)
• sd.DBO.LOC_MACA_CA_RoadCenterLine_OPS (1) -- Related To: Road (30)
• sd.DBO.LOC_MACA_CA_MasterRoadName_OPS (2) -- Related To: Master Road Name Table (34)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata