View In:   ArcGIS Online Map Viewer

Name: Site Addresses

Display Field: FULLADDRESS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This feature class represents the civic addresses of all properties, including units and secondary suites, in the City of Spruce Grove. Features track census inclusion, and informaiton pertaining to the census map book map sheet and occupancy during census years.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 16f76abdf54849e5a46d5e36f40f040c

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 473.5744000002742
YMin: 5931079.0217
XMax: 10025.836500000209
YMax: 5937770.807
Spatial Reference: 102187  (3776)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [57, 137, 87, 255]
Size: 2.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: true

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: System-maintained ObjectID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PARCELID ( type: esriFieldTypeString, alias: Property ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PARCELID )
• ADDPTKEY ( type: esriFieldTypeString, alias: Address Point ID, editable: false, nullable: true, length: 38, defaultValue: null, modelName: ADDPTKEY )
• FULLADDRESS ( type: esriFieldTypeString, alias: Full Address, editable: false, nullable: true, length: 100, defaultValue: null, modelName: FULLADDRESS )
• STNUMPRE ( type: esriFieldTypeString, alias: Street Number Prefix, editable: false, nullable: true, length: 10, defaultValue: null, modelName: STNUMPRE )
• STREETNUM ( type: esriFieldTypeString, alias: Street Number, editable: false, nullable: true, length: 10, defaultValue: null, modelName: STREETNUM )
• STNUMSUFF ( type: esriFieldTypeString, alias: Street Number Suffix, editable: false, nullable: true, length: 10, defaultValue: null, modelName: STNUMSUFF )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, editable: false, nullable: true, length: 75, defaultValue: null, modelName: STREETNAME )
• STREETTYPE ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREETTYPE , Coded Values: [ABBEY: Abbey] , [ACRES: Acres] , [ALLÉE: Allée] , ...142 more... )
• STDIRSUFF ( type: esriFieldTypeString, alias: Street Direction Suffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STDIRSUFF , Coded Values: [N: North] , [S: South] , [E: East] , ...9 more... )
• MUNINAME ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 50, defaultValue: Spruce Grove, modelName: MUNINAME )
• MUNIID ( type: esriFieldTypeString, alias: Municipal ID, editable: true, nullable: true, length: 12, defaultValue: 291, modelName: MUNIID )
• COMMUNITY ( type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMUNITY )
• BUILDINGNAME ( type: esriFieldTypeString, alias: Building Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUILDINGNAME )
• BUILDINGCLASS ( type: esriFieldTypeSmallInteger, alias: Building Class, editable: true, nullable: true, defaultValue: null, modelName: BUILDINGCLASS , Coded Values: [1: General] , [2: Government] , [3: Medical] , ...17 more... )
• BUILDINGTYPE ( type: esriFieldTypeString, alias: Building Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BUILDINGTYPE )
• PROVINCE ( type: esriFieldTypeString, alias: Province or Territory, editable: true, nullable: true, length: 2, defaultValue: AB, modelName: PROVINCE , Coded Values: [AB: Alberta] , [BC: British Columbia] , [MB: Manitoba] , ...10 more... )
• POSTALCODE ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: POSTALCODE )
• ROTATION ( type: esriFieldTypeSmallInteger, alias: Label Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• ASSESS_DESC ( type: esriFieldTypeString, alias: Assessment Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ASSESS_DESC )
• STACKED ( type: esriFieldTypeSmallInteger, alias: Stacked (T/F), editable: true, nullable: true, defaultValue: null, modelName: STACKED , Coded Values: [0: False] , [1: True] , [999: Other] )
• EA_ZONE ( type: esriFieldTypeString, alias: Census Enumeration Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EA_ZONE )
• SUBDIVISION ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SUBDIVISION )
• OCCUPIED_2016 ( type: esriFieldTypeSmallInteger, alias: Occupied Census 2016, editable: true, nullable: true, defaultValue: null, modelName: OCCUPIED_2016 , Coded Values: [0: False] , [1: True] , [999: Other] )
• OCCUPIED_2015 ( type: esriFieldTypeSmallInteger, alias: Occupied Census 2015, editable: true, nullable: true, defaultValue: null, modelName: OCCUPIED_2015 , Coded Values: [0: False] , [1: True] , [999: Other] )
• LEGAL_SUITE ( type: esriFieldTypeSmallInteger, alias: Legal Suite?, editable: true, nullable: true, defaultValue: null, modelName: BASEMENT , Coded Values: [0: False] , [1: True] , [999: Other] )
• CENSUS_ADDRESS ( type: esriFieldTypeSmallInteger, alias: Census Address, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVE , Coded Values: [0: False] , [1: True] , [999: Other] )
• MAP_SWITCH ( type: esriFieldTypeSmallInteger, alias: On Map?, editable: true, nullable: true, defaultValue: 1, modelName: MAP_SWITCH , Coded Values: [0: False] , [1: True] , [999: Other] )
• IS_UNIT ( type: esriFieldTypeSmallInteger, alias: Unit?, editable: true, nullable: true, defaultValue: 0, modelName: IS_UNIT , Coded Values: [0: False] , [1: True] , [999: Other] )
• IS_SECONDARY ( type: esriFieldTypeSmallInteger, alias: Secondary Suite?, editable: true, nullable: true, defaultValue: null, modelName: IS_SECONDARY , Coded Values: [0: False] , [1: True] , [999: Other] )
• PID_NUM ( type: esriFieldTypeInteger, alias: Property ID (Numeric), editable: true, nullable: true, defaultValue: null, modelName: PID_NUM )
• PAGENAME ( type: esriFieldTypeString, alias: Census Page Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PAGENAME )
• 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 )
• ANGLE ( type: esriFieldTypeInteger, alias: ANGLE, editable: true, nullable: true, defaultValue: null, modelName: ANGLE )
• FULLSTREET ( type: esriFieldTypeString, alias: FULLSTREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FULLSTREET )
• POITNX ( type: esriFieldTypeDouble, alias: POITNX, editable: true, nullable: true, defaultValue: null, modelName: POITNX )
• POINTY ( type: esriFieldTypeDouble, alias: POINTY, editable: true, nullable: true, defaultValue: null, modelName: POINTY )
• OCCUPIED_2017 ( type: esriFieldTypeSmallInteger, alias: 2017 Census Occupied, editable: true, nullable: true, defaultValue: null, modelName: OCCUPIED_2017 , Coded Values: [0: False] , [1: True] , [999: Other] )
• PROVLINC ( type: esriFieldTypeString, alias: Linc Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROVLINC )
• GARBAGE_ZONE ( type: esriFieldTypeString, alias: Garbage Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GARBAGE_ZONE )
• AddressType ( type: esriFieldTypeString, alias: Address Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddressType , Coded Values: [Commercial Main: Commercial Main] , [Commercial Unit: Commercial Unit] , [Illegal Suite: Illegal Suite] , ...13 more... )
• CornerLot ( type: esriFieldTypeString, alias: Corner Lot, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CornerLot , Coded Values: [Yes: Yes] )

Templates:

• Name: Site Addresses
  Description:
  Prototype:
  AddressType: null
  CornerLot: null
  PARCELID: null
  GARBAGE_ZONE: null
  PROVLINC: null
  OCCUPIED_2017: null
  POINTY: null
  POITNX: null
  FULLSTREET: null
  STREETTYPE: null
  STDIRSUFF: null
  MUNINAME: Spruce Grove
  MUNIID: 291
  COMMUNITY: null
  BUILDINGNAME: null
  BUILDINGCLASS: null
  BUILDINGTYPE: null
  PROVINCE: AB
  POSTALCODE: null
  ROTATION: null
  ASSESS_DESC: null
  STACKED: null
  EA_ZONE: null
  SUBDIVISION: null
  OCCUPIED_2016: null
  OCCUPIED_2015: null
  LEGAL_SUITE: null
  CENSUS_ADDRESS: 1
  MAP_SWITCH: 1
  IS_UNIT: 0
  IS_SECONDARY: null
  PID_NUM: null
  PAGENAME: null
  ANGLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

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   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata