View In:   ArcGIS Online Map Viewer

Name: v_address_Addresses

Display Field: SITE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 67b8b715170244a296cf88d8e408b311

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 481001.0267
YMin: 5454531.5054
XMax: 483401.691
YMax: 5457824.4375
Spatial Reference: 26910  (26910)  VCSWkid(115700)  LatestVCSWkid(115700)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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 )
• ADD_UID ( type: esriFieldTypeString, alias: ADD_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADD_UID )
• UNIT_DESIGNATOR ( type: esriFieldTypeString, alias: UNIT_DESIGNATOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNIT_DESIGNATOR )
• UNIT_NUMBER_PREFIX ( type: esriFieldTypeString, alias: UNIT_NUMBER_PREFIX, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNIT_NUMBER_PREFIX )
• UNIT_NUMBER ( type: esriFieldTypeString, alias: UNIT_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: UNIT_NUMBER )
• UNIT_NUMBER_SUFFIX ( type: esriFieldTypeString, alias: UNIT_NUMBER_SUFFIX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNIT_NUMBER_SUFFIX )
• SITE_NAME ( type: esriFieldTypeString, alias: SITE_NAME, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SITE_NAME )
• SUPER_FULL_SITE_DESCRIPTOR ( type: esriFieldTypeString, alias: SUPER_FULL_SITE_DESCRIPTOR, editable: true, nullable: true, length: 400, defaultValue: null, modelName: SUPER_FULL_SITE_DESCRIPTOR )
• CIVIC_NUMBER ( type: esriFieldTypeInteger, alias: CIVIC_NUMBER, editable: true, nullable: true, defaultValue: null, modelName: CIVIC_NUMBER )
• CIVIC_NUMBER_SUFFIX ( type: esriFieldTypeString, alias: CIVIC_NUMBER_SUFFIX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CIVIC_NUMBER_SUFFIX )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: STREET_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_TYPE )
• IS_STREET_TYPE_PREFIX ( type: esriFieldTypeSmallInteger, alias: IS_STREET_TYPE_PREFIX, editable: true, nullable: true, defaultValue: null, modelName: IS_STREET_TYPE_PREFIX , Coded Values: [1: True] , [0: False] )
• STREET_DIRECTION ( type: esriFieldTypeString, alias: STREET_DIRECTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_DIRECTION )
• IS_STREET_DIRECTION_PREFIX ( type: esriFieldTypeSmallInteger, alias: IS_STREET_DIRECTION_PREFIX, editable: true, nullable: true, defaultValue: null, modelName: IS_STREET_DIRECTION_PREFIX , Coded Values: [1: True] , [0: False] )
• LOCALITY ( type: esriFieldTypeString, alias: LOCALITY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCALITY )
• LOCALITY_DESCRIPTOR ( type: esriFieldTypeString, alias: LOCALITY_DESCRIPTOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCALITY_DESCRIPTOR )
• POSTAL_CODE ( type: esriFieldTypeString, alias: POSTAL_CODE, editable: true, nullable: true, length: 7, defaultValue: null, modelName: POSTAL_CODE )
• PROVINCE_CODE ( type: esriFieldTypeString, alias: PROVINCE_CODE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PROVINCE_CODE )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATUS , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• IS_OFFICIAL_ADDRESS ( type: esriFieldTypeSmallInteger, alias: IS_OFFICIAL_ADDRESS, editable: true, nullable: true, defaultValue: null, modelName: IS_OFFICIAL_ADDRESS , Coded Values: [1: True] , [0: False] )
• IS_PRIMARY ( type: esriFieldTypeSmallInteger, alias: IS_PRIMARY, editable: true, nullable: true, defaultValue: null, modelName: IS_PRIMARY , Coded Values: [1: True] , [0: False] )
• BLDG_UID ( type: esriFieldTypeString, alias: BLDG_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_UID )
• ADDRESS_DESCRIPTOR ( type: esriFieldTypeString, alias: ADDRESS_DESCRIPTOR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS_DESCRIPTOR , Coded Values: [CampusBuilding: CampusBuilding] , [Emergency: Emergency] , [Commercial: Commercial] , ...7 more... )
• SITE_POINT_DESCRIPTOR ( type: esriFieldTypeString, alias: SITE_POINT_DESCRIPTOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_POINT_DESCRIPTOR , Coded Values: [Parcel: Parcel] , [FrontDoor: FrontDoor] , [Rooftop: Rooftop] , ...4 more... )
• FOOTPRINT_DESCRIPTOR ( type: esriFieldTypeString, alias: FOOTPRINT_DESCRIPTOR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FOOTPRINT_DESCRIPTOR , Coded Values: [Building: Building] , [Complex: Complex] , [OutdoorArea: OutdoorArea] , ...3 more... )
• FOOTPRINT_ID ( type: esriFieldTypeString, alias: FOOTPRINT_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FOOTPRINT_ID )
• IS_NON_CIVIC_ADDRESS ( type: esriFieldTypeSmallInteger, alias: IS_NON_CIVIC_ADDRESS, editable: true, nullable: true, defaultValue: null, modelName: IS_NON_CIVIC_ADDRESS , Coded Values: [1: True] , [0: False] )
• NARRITIVE_LOCATION ( type: esriFieldTypeString, alias: NARRITIVE_LOCATION, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NARRITIVE_LOCATION )
• IS_MAILING_ADDRESS ( type: esriFieldTypeSmallInteger, alias: IS_MAILING_ADDRESS, editable: true, nullable: true, defaultValue: null, modelName: IS_MAILING_ADDRESS , Coded Values: [1: True] , [0: False] )
• MAIL_PROVIDER ( type: esriFieldTypeString, alias: MAIL_PROVIDER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAIL_PROVIDER , Coded Values: [CanadaPost: CanadaPost] , [CampusMail: CampusMail] )
• IS_ANNUNCIATOR ( type: esriFieldTypeSmallInteger, alias: IS_ANNUNCIATOR, editable: true, nullable: true, defaultValue: null, modelName: IS_ANNUNCIATOR , Coded Values: [1: True] , [0: False] )
• NUM_OF_UNITS ( type: esriFieldTypeInteger, alias: NUM_OF_UNITS, editable: true, nullable: true, defaultValue: null, modelName: NUM_OF_UNITS )
• NEIGHBOURHOOD ( type: esriFieldTypeString, alias: NEIGHBOURHOOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEIGHBOURHOOD )
• ADDRESS_NOTES ( type: esriFieldTypeString, alias: ADDRESS_NOTES, editable: true, nullable: true, length: 400, defaultValue: null, modelName: ADDRESS_NOTES )
• 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 )
• PARENT_UID ( type: esriFieldTypeString, alias: PARENT_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PARENT_UID )
• FULL_ADDRESS ( type: esriFieldTypeString, alias: FULL_ADDRESS, editable: true, nullable: true, length: 300, defaultValue: null, modelName: FULL_ADDRESS )
• ANNO_STREET_CHECK ( type: esriFieldTypeString, alias: ANNO_STREET_CHECK, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ANNO_STREET_CHECK )
• ANNO_STREET_DIST ( type: esriFieldTypeDouble, alias: ANNO_STREET_DIST, editable: true, nullable: true, defaultValue: null, modelName: ANNO_STREET_DIST )
• ANNO_STREET_ANGLE ( type: esriFieldTypeDouble, alias: ANNO_STREET_ANGLE, editable: true, nullable: true, defaultValue: null, modelName: ANNO_STREET_ANGLE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: v_address_Addresses
  Description:
  Prototype:
  ANNO_STREET_ANGLE: null
  ADD_UID: null
  UNIT_DESIGNATOR: null
  UNIT_NUMBER_PREFIX: null
  UNIT_NUMBER: null
  UNIT_NUMBER_SUFFIX: null
  SITE_NAME: null
  SUPER_FULL_SITE_DESCRIPTOR: null
  CIVIC_NUMBER: null
  CIVIC_NUMBER_SUFFIX: null
  STREET_NAME: null
  STREET_TYPE: null
  IS_STREET_TYPE_PREFIX: null
  STREET_DIRECTION: null
  IS_STREET_DIRECTION_PREFIX: null
  LOCALITY: null
  LOCALITY_DESCRIPTOR: null
  POSTAL_CODE: null
  PROVINCE_CODE: null
  STATUS: null
  IS_OFFICIAL_ADDRESS: null
  IS_PRIMARY: null
  BLDG_UID: null
  ADDRESS_DESCRIPTOR: null
  SITE_POINT_DESCRIPTOR: null
  FOOTPRINT_DESCRIPTOR: null
  FOOTPRINT_ID: null
  IS_NON_CIVIC_ADDRESS: null
  NARRITIVE_LOCATION: null
  IS_MAILING_ADDRESS: null
  MAIL_PROVIDER: null
  IS_ANNUNCIATOR: null
  NUM_OF_UNITS: null
  NEIGHBOURHOOD: null
  ADDRESS_NOTES: null
  ANNO_STREET_DIST: null
  ANNO_STREET_CHECK: null
  FULL_ADDRESS: null
  PARENT_UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• v_building_Buildings (0) -- Related To: v_building_Buildings (2)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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