Layers:

Layer: NWT Civic Address Point (25)

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)

Layer: Road (30)

Name: Road

Display Field: fullname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 500000.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: -1829134.3803000003
YMin: 2337845.193599999
XMax: -629868.4135999978
YMax: 3784884.671
Spatial Reference: 102002  (102002)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 2
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: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• centerlineid ( type: esriFieldTypeInteger, alias: Centerline ID, editable: true, nullable: true, defaultValue: null, modelName: centerlineid )
• rclnguid ( type: esriFieldTypeString, alias: NENA Global ID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: rclnguid )
• discrpagid ( type: esriFieldTypeString, alias: Discrepancy Agency ID, editable: true, nullable: true, length: 75, defaultValue: null, modelName: discrpagid )
• roadnameid ( type: esriFieldTypeInteger, alias: Road Name ID, editable: true, nullable: true, defaultValue: null, modelName: roadnameid )
• rangeprefixleft ( type: esriFieldTypeString, alias: Left Address Number Prefix, editable: true, nullable: true, length: 15, defaultValue: null, modelName: rangeprefixleft )
• fromleft ( type: esriFieldTypeInteger, alias: Left From Address, editable: true, nullable: true, defaultValue: null, modelName: fromleft )
• toleft ( type: esriFieldTypeInteger, alias: Left To Address, editable: true, nullable: true, defaultValue: null, modelName: toleft )
• parityleft ( type: esriFieldTypeString, alias: Parity Left, editable: true, nullable: true, length: 17, defaultValue: null, modelName: parityleft , Coded Values: [Odd: Odd] , [Even: Even] , [Both: Both] , ...1 more... )
• rangeprefixright ( type: esriFieldTypeString, alias: Right Address Number Prefix, editable: true, nullable: true, length: 15, defaultValue: null, modelName: rangeprefixright )
• fromright ( type: esriFieldTypeInteger, alias: Right From Address, editable: true, nullable: true, defaultValue: null, modelName: fromright )
• toright ( type: esriFieldTypeInteger, alias: Right To Address, editable: true, nullable: true, defaultValue: null, modelName: toright )
• parityright ( type: esriFieldTypeString, alias: Parity Right, editable: true, nullable: true, length: 17, defaultValue: null, modelName: parityright , Coded Values: [Odd: Odd] , [Even: Even] , [Both: Both] , ...1 more... )
• fullname ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 300, defaultValue: null, modelName: fullname )
• fedroute ( type: esriFieldTypeString, alias: Federal Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: fedroute )
• fedrtetype ( type: esriFieldTypeString, alias: Federal Route Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: fedrtetype , Coded Values: [Freeway: Freeway] , [Highway: Highway] , [Interstate: Interstate] , ...2 more... )
• afedrte ( type: esriFieldTypeString, alias: Alternate Federal Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: afedrte )
• afedrtetype ( type: esriFieldTypeString, alias: Alternate Federal Route Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: afedrtetype , Coded Values: [Freeway: Freeway] , [Highway: Highway] , [Interstate: Interstate] , ...2 more... )
• pvtrroute ( type: esriFieldTypeString, alias: Provincial/Territorial Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: pvtrroute )
• pvtrrtetype ( type: esriFieldTypeString, alias: Provincial/Territorial Route Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: pvtrrtetype , Coded Values: [Freeway: Freeway] , [Highway: Highway] , [Interstate: Interstate] , ...2 more... )
• apvtrrte ( type: esriFieldTypeString, alias: Alternate Provincial/Territorial Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: apvtrrte )
• apvtrrtetype ( type: esriFieldTypeString, alias: Alternate Provincial/Territorial Route Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: apvtrrtetype , Coded Values: [Freeway: Freeway] , [Highway: Highway] , [Interstate: Interstate] , ...2 more... )
• ctyroute ( type: esriFieldTypeString, alias: County Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ctyroute )
• onewaydir ( type: esriFieldTypeString, alias: One Way Indicator, editable: true, nullable: true, length: 10, defaultValue: null, modelName: onewaydir , Coded Values: [From-To: From-To] , [To-From: To-From] , [Unknown: Unknown] )
• roadlevel ( type: esriFieldTypeInteger, alias: Above or Below Grade, editable: true, nullable: true, defaultValue: null, modelName: roadlevel , Coded Values: [-2: Second Subsurface] , [-1: Subsurface] , [0: Ground Level] , ...4 more... )
• inwater ( type: esriFieldTypeString, alias: In Water, editable: true, nullable: true, length: 5, defaultValue: null, modelName: inwater , Coded Values: [Yes: Yes] , [No: No] )
• roadclass ( type: esriFieldTypeString, alias: Road Class, editable: true, nullable: true, length: 7, defaultValue: null, modelName: roadclass , Coded Values: [RARTLIN: RARTLIN] , [RBRGLIN: RBRGLIN] , [RFERLIN: RFERLIN] , ...8 more... )
• countryleft ( type: esriFieldTypeString, alias: Country on Left, editable: true, nullable: true, length: 2, defaultValue: null, modelName: countryleft )
• countryright ( type: esriFieldTypeString, alias: Country on Right, editable: true, nullable: true, length: 2, defaultValue: null, modelName: countryright )
• pvtrleft ( type: esriFieldTypeString, alias: Province/Territory on Left, editable: true, nullable: true, length: 2, defaultValue: null, modelName: pvtrleft , Coded Values: [AB: AB] , [BC: BC] , [MB: MB] , ...10 more... )
• pvtrright ( type: esriFieldTypeString, alias: Province/Territory on Right, editable: true, nullable: true, length: 2, defaultValue: null, modelName: pvtrright , Coded Values: [AB: AB] , [BC: BC] , [MB: MB] , ...10 more... )
• countyleft ( type: esriFieldTypeString, alias: County on Left, editable: true, nullable: true, length: 40, defaultValue: null, modelName: countyleft )
• countyright ( type: esriFieldTypeString, alias: County on Right, editable: true, nullable: true, length: 40, defaultValue: null, modelName: countyright )
• munileft ( type: esriFieldTypeString, alias: Municipality on Left, editable: true, nullable: true, length: 100, defaultValue: null, modelName: munileft )
• muniright ( type: esriFieldTypeString, alias: Municipality on Right, editable: true, nullable: true, length: 100, defaultValue: null, modelName: muniright )
• postleft ( type: esriFieldTypeString, alias: Postal Code on Left, editable: true, nullable: true, length: 6, defaultValue: null, modelName: postleft )
• postright ( type: esriFieldTypeString, alias: Postal Code on Right, editable: true, nullable: true, length: 6, defaultValue: null, modelName: postright )
• msagleft ( type: esriFieldTypeString, alias: MSAG on Left, editable: true, nullable: true, length: 35, defaultValue: null, modelName: msagleft )
• msagright ( type: esriFieldTypeString, alias: MSAG on Right, editable: true, nullable: true, length: 35, defaultValue: null, modelName: msagright )
• esnleft ( type: esriFieldTypeString, alias: ESN on Left, editable: true, nullable: true, length: 5, defaultValue: null, modelName: esnleft )
• esnright ( type: esriFieldTypeString, alias: ESN on Right, editable: true, nullable: true, length: 5, defaultValue: null, modelName: esnright )
• surface ( type: esriFieldTypeString, alias: Road Surface, editable: true, nullable: true, length: 50, defaultValue: null, modelName: surface )
• dataprovider ( type: esriFieldTypeString, alias: Data Provider, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dataprovider )
• accuracy ( type: esriFieldTypeSmallInteger, alias: Accuracy, editable: true, nullable: true, defaultValue: null, modelName: accuracy )
• capdate ( type: esriFieldTypeDate, alias: Capture Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: capdate )
• capyear ( type: esriFieldTypeSmallInteger, alias: Capture Year, editable: true, nullable: true, defaultValue: null, modelName: capyear )
• acqtech ( type: esriFieldTypeString, alias: Data Acquisition Technique, editable: true, nullable: true, length: 50, defaultValue: null, modelName: acqtech )
• dc_startdate ( type: esriFieldTypeDate, alias: Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dc_startdate )
• dc_enddate ( type: esriFieldTypeDate, alias: End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dc_enddate )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 254, defaultValue: null, modelName: notes )
• pha_roadname ( type: esriFieldTypeString, alias: Public Highways Act Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pha_roadname )
• pha_class ( type: esriFieldTypeString, alias: Public Highways Act Road Class, editable: true, nullable: true, length: 15, defaultValue: null, modelName: pha_class )
• pha_roww ( type: esriFieldTypeDouble, alias: Public Highways Act Right-Of-Way Width, editable: true, nullable: true, defaultValue: null, modelName: pha_roww )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
• Name: Road
  Description:
  Prototype:
  pha_roww: null
  centerlineid: null
  rclnguid: null
  discrpagid: null
  roadnameid: null
  rangeprefixleft: null
  fromleft: null
  toleft: null
  parityleft: null
  rangeprefixright: null
  fromright: null
  toright: null
  parityright: null
  fullname: null
  fedroute: null
  fedrtetype: null
  afedrte: null
  afedrtetype: null
  pvtrroute: null
  pvtrrtetype: null
  apvtrrte: null
  apvtrrtetype: null
  ctyroute: null
  onewaydir: null
  roadlevel: null
  inwater: null
  roadclass: null
  countryleft: null
  countryright: null
  pvtrleft: null
  pvtrright: null
  countyleft: null
  countyright: null
  munileft: null
  muniright: null
  postleft: null
  postright: null
  msagleft: null
  msagright: null
  esnleft: null
  esnright: null
  surface: null
  dataprovider: null
  accuracy: null
  capdate: null
  capyear: null
  acqtech: null
  dc_startdate: null
  dc_enddate: null
  notes: null
  pha_roadname: null
  pha_class: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• sd.DBO.LOC_MACA_CA_SiteAddressPoint_OPS (1) -- Related To: NWT Civic Address Point (25)
• sd.DBO.LOC_MACA_CA_AliasRoadName_OPS (3) -- Related To: Alias Road Name Table (33)
• sd.DBO.LOC_MACA_CA_MasterRoadName_OPS (4) -- Related To: Master Road Name Table (34)

Tables:

Table: Master Road Name Table (34)

Name: Master Road Name Table

Display Field: roadname

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• roadnameid ( type: esriFieldTypeInteger, alias: Road Name ID, editable: true, nullable: true, defaultValue: null, modelName: roadnameid )
• roadpremod ( type: esriFieldTypeString, alias: Road Pre Modifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: roadpremod )
• roadpredir ( type: esriFieldTypeString, alias: Road Pre Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: roadpredir , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• roadpretype ( type: esriFieldTypeString, alias: Road Pre Type, editable: true, nullable: true, length: 11, defaultValue: null, modelName: roadpretype , Coded Values: [Access Road: Access Road] , [Alley: Alley] , [Anex: Anex] , ...215 more... )
• roadpretypesep ( type: esriFieldTypeString, alias: Road Pre Type Separator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: roadpretypesep )
• roadname ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: roadname )
• roadtype ( type: esriFieldTypeString, alias: Road Type, editable: true, nullable: true, length: 11, defaultValue: null, modelName: roadtype , Coded Values: [Access Road: Access Road] , [Alley: Alley] , [Anex: Anex] , ...215 more... )
• roadpostdir ( type: esriFieldTypeString, alias: Post Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: roadpostdir , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• roadpostmod ( type: esriFieldTypeString, alias: Road Post Modifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: roadpostmod )
• fullname ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 300, defaultValue: null, modelName: fullname )
• municipality ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: municipality )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: status , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• 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 )
Templates:
• Name: Master Road Name Table
  Description:
  Prototype:
  status: null
  roadnameid: null
  roadpremod: null
  roadpredir: null
  roadpretype: null
  roadpretypesep: null
  roadname: null
  roadtype: null
  roadpostdir: null
  roadpostmod: null
  fullname: null
  municipality: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• sd.DBO.LOC_MACA_CA_SiteAddressPoint_OPS (2) -- Related To: NWT Civic Address Point (25)
• sd.DBO.LOC_MACA_CA_AliasRoadName_OPS (5) -- Related To: Alias Road Name Table (33)
• sd.DBO.LOC_MACA_CA_RoadCenterLine_OPS (4) -- Related To: Road (30)

Table: Alias Road Name Table (33)

Name: Alias Road Name Table

Display Field: roadname

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• siteaddid ( type: esriFieldTypeInteger, alias: Site Address ID, editable: true, nullable: true, defaultValue: null, modelName: siteaddid )
• centerlineid ( type: esriFieldTypeInteger, alias: Centerline ID, editable: true, nullable: true, defaultValue: null, modelName: centerlineid )
• roadnameid ( type: esriFieldTypeInteger, alias: Road Name ID, editable: true, nullable: true, defaultValue: null, modelName: roadnameid )
• roadpremod ( type: esriFieldTypeString, alias: Road Pre Modifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: roadpremod )
• roadpredir ( type: esriFieldTypeString, alias: Road Pre Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: roadpredir , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• roadpretype ( type: esriFieldTypeString, alias: Road Pre Type, editable: true, nullable: true, length: 11, defaultValue: null, modelName: roadpretype , Coded Values: [Access Road: Access Road] , [Alley: Alley] , [Anex: Anex] , ...215 more... )
• roadpretypesep ( type: esriFieldTypeString, alias: Road Pre Type Separator , editable: true, nullable: true, length: 20, defaultValue: null, modelName: roadpretypesep )
• roadname ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: roadname )
• roadtype ( type: esriFieldTypeString, alias: Road Type, editable: true, nullable: true, length: 11, defaultValue: null, modelName: roadtype , Coded Values: [Access Road: Access Road] , [Alley: Alley] , [Anex: Anex] , ...215 more... )
• roadpostdir ( type: esriFieldTypeString, alias: Post Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: roadpostdir , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• roadpostmod ( type: esriFieldTypeString, alias: Road Post Modifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: roadpostmod )
• fullname ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 300, defaultValue: null, modelName: fullname )
• municipality ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: municipality )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: status , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• 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 )
Templates:
• Name: Alias Road Name Table
  Description:
  Prototype:
  status: null
  siteaddid: null
  centerlineid: null
  roadnameid: null
  roadpremod: null
  roadpredir: null
  roadpretype: null
  roadpretypesep: null
  roadname: null
  roadtype: null
  roadpostdir: null
  roadpostmod: null
  fullname: null
  municipality: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• sd.DBO.LOC_MACA_CA_RoadCenterLine_OPS (3) -- Related To: Road (30)
• sd.DBO.LOC_MACA_CA_SiteAddressPoint_OPS (0) -- Related To: NWT Civic Address Point (25)
• sd.DBO.LOC_MACA_CA_MasterRoadName_OPS (5) -- Related To: Master Road Name Table (34)