View In:   ArcGIS Online Map Viewer

Name: Address

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This dataset contains points which represent the fixed location of a municipal address located within the City of Guelph boundaries.</SPAN></P></DIV></DIV></DIV>

Service Item Id: af747982917245d3a8990bf2136aa00f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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: -8941864.702597264
YMin: 5384346.445817356
XMax: -8921266.939666916
YMax: 5401709.742602251
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• STREETNAME ( type: esriFieldTypeString, alias: Legacy Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETNAME )
• UNIT_NO ( type: esriFieldTypeString, alias: Unit Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNIT_NO )
• QUALIFIER ( type: esriFieldTypeString, alias: Qualifier, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QUALIFIER )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• GPID ( type: esriFieldTypeInteger, alias: Gpid, editable: true, nullable: true, defaultValue: null, modelName: GPID1 )
• PARITY ( type: esriFieldTypeString, alias: Parity, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PARITY , Coded Values: [Z: Address Range 0-0] , [B: Both] , [E: Even] , ...1 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: Pending, modelName: STATUS , Coded Values: [Active: Active] , [Draft: Draft] , [Historic: Historic] , ...1 more... )
• ADDID ( type: esriFieldTypeInteger, alias: Address Id, editable: true, nullable: true, defaultValue: null, modelName: ADDID )
• STREETNO ( type: esriFieldTypeString, alias: Street Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREETNO )
• ROLLNO ( type: esriFieldTypeString, alias: Roll Number, editable: true, nullable: true, length: 19, defaultValue: null, modelName: ROLLNO )
• POSTCODE ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: POSTCODE1 )
• PIN ( type: esriFieldTypeInteger, alias: Parcel Identifier, editable: true, nullable: true, defaultValue: null, modelName: PIN1 )
• NAME ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME )
• HAS_UNIT ( type: esriFieldTypeString, alias: Has Unit, editable: true, nullable: true, length: 1, defaultValue: N, modelName: HAS_UNIT , Coded Values: [Y: Yes] , [N: No] )
• AMAID ( type: esriFieldTypeInteger, alias: Amanda Id, editable: true, nullable: true, defaultValue: null, modelName: AMAID )
• LABEL ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LABEL )
• STREETID ( type: esriFieldTypeInteger, alias: Street Id, editable: true, nullable: true, defaultValue: null, modelName: STREETID , Coded Values: [1018: ABBEYWOOD CRES] , [1019: ABERDEEN ST] , [3410: ACKER ST] , ...1109 more... )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• STNAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STNAME )
• STSUF ( type: esriFieldTypeString, alias: Street Suffix, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STSUF )
• STDIR ( type: esriFieldTypeString, alias: Street Direction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STDIR )
• FULLNAME ( type: esriFieldTypeString, alias: Full Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FULLNAME )
• PLACETYPE ( type: esriFieldTypeString, alias: Placement Type, editable: true, nullable: true, length: 50, defaultValue: residence, modelName: PLACETYPE , Coded Values: [convention-center: Convention center or exhibition hall.] , [classroom: Academic classroom or lecture hall.] , [industrial: Industrial setting, such as a manufacturing floor or power plant.] , ...31 more... )
• PLACEMENT ( type: esriFieldTypeString, alias: Placement Method, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PLACEMENT , Coded Values: [Geocoding: Placement of an address point to represent an address along a road segment based on the high and low numbers assigned to the road segment using geocoding techniques.] , [Parcel: Placement of an address point to represent an address associated with a parcel.] , [Property Access: Placement of an address point to represent an address based on the location of the primary access to a given property.] , ...3 more... )
• MSAGCOMM ( type: esriFieldTypeString, alias: MSAG Community Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MSAGCOMM )
• POSTCOMM ( type: esriFieldTypeString, alias: Postal Community Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POSTCOMM )
• BUILDING ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUILDING )
• FLOOR ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: FLOOR )
• ROOM ( type: esriFieldTypeString, alias: Room, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ROOM )
• SEAT ( type: esriFieldTypeString, alias: Seat, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SEAT )
• ADDLOCINFO ( type: esriFieldTypeString, alias: Additional Location Information, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDLOCINFO )
• LANDMKNAME ( type: esriFieldTypeString, alias: Landmark Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LANDMKNAME )
• LONG ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONG )
• LAT ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LAT )
• ELEV ( type: esriFieldTypeSmallInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEV )
• ADDLEG ( type: esriFieldTypeString, alias: Legacy Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ADDLEG )
• ROLL_NO ( type: esriFieldTypeString, alias: ROLL_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ROLL_NO )
• ROLLNO_15 ( type: esriFieldTypeString, alias: ROLLNO_15, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ROLLNO_15 )
• SEGMENTID ( type: esriFieldTypeInteger, alias: Road Segment ID*, editable: true, nullable: true, defaultValue: null, modelName: SEGMENTID )
• PLACE ( type: esriFieldTypeString, alias: Place, editable: true, nullable: true, length: 75, defaultValue: Guelph, modelName: PLACE , Coded Values: [Aberfoyle: Aberfoyle] , [Alma: Alma] , [Ariss: Ariss] , ...51 more... )
• UTM_X ( type: esriFieldTypeDouble, alias: UTM_X, editable: true, nullable: true, defaultValue: null, modelName: UTM_X )
• UTM_Y ( type: esriFieldTypeDouble, alias: UTM_Y, editable: true, nullable: true, defaultValue: null, modelName: UTM_Y )
• ADDID_TEXT ( type: esriFieldTypeString, alias: ADDID_TEXT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDID_TEXT )
• STATION_RESPONSE_ORDER ( type: esriFieldTypeString, alias: Fire Stations Response, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATION_RESPONSE_ORDER )
• WARD ( type: esriFieldTypeSmallInteger, alias: Ward, editable: true, nullable: true, defaultValue: null, modelName: WARD )

Templates:

• Name: Address
  Description:
  Prototype:
  STATION_RESPONSE_ORDER: null
  STREETNAME: null
  UNIT_NO: null
  QUALIFIER: null
  ADDRESS: null
  GPID: null
  PARITY: null
  STATUS: Pending
  ADDID: null
  STREETNO: null
  ROLLNO: null
  POSTCODE: null
  PIN: null
  NAME: null
  HAS_UNIT: N
  AMAID: null
  LABEL: null
  STREETID: null
  ADDID_TEXT: null
  UTM_Y: null
  UTM_X: null
  PLACE: Guelph
  WARD: null
  STNAME: null
  STSUF: null
  STDIR: null
  FULLNAME: null
  PLACETYPE: residence
  PLACEMENT: null
  MSAGCOMM: null
  POSTCOMM: null
  BUILDING: null
  FLOOR: null
  ROOM: null
  SEAT: null
  ADDLOCINFO: null
  LANDMKNAME: null
  LONG: null
  LAT: null
  ELEV: null
  ADDLEG: null
  ROLL_NO: null
  ROLLNO_15: null
  SEGMENTID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata