View In:
ArcGIS Online Map Viewer
Parent Layer:
Address
Name: Site Addresses with Owners
Display Field: GIS_CMDM_Prod.DBO.SiteAddress.STREETNAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: 5b37d90d8dd74d8d82ed27a81c9b406a
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 3000
Max Scale: 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: -5120900
YMin: -9998100
XMax: 466017.6955000004
YMax: 5586923.8412999995
Spatial Reference: 2151
(2957)
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: false
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: false
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: true
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
)
-
CIVICID
(
type: esriFieldTypeString, alias: Civic ID Number, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CIVICID
)
-
POINTTYPE
(
type: esriFieldTypeString, alias: Address Point Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POINTTYPE
, Coded Values:
[Driveway Entrance: Driveway Entrance]
, [Building Entrance: Building Entrance]
, [Walkway Entrance: Walkway Entrance]
, ...4 more...
)
-
PARCELID
(
type: esriFieldTypeString, alias: Valuation ID Number, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PARCELID
)
-
FACILITYID
(
type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID
)
-
ADDPTKEY
(
type: esriFieldTypeString, alias: Address Point ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ADDPTKEY
)
-
FULLADDRESS
(
type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULLADDRESS
)
-
STNUMPRE
(
type: esriFieldTypeString, alias: Street Number Prefix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STNUMPRE
)
-
STREETNUM
(
type: esriFieldTypeString, alias: Street Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREETNUM
)
-
STNUMSUFF
(
type: esriFieldTypeString, alias: Street Number Suffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STNUMSUFF
)
-
STNUMRANGE
(
type: esriFieldTypeString, alias: Street Number Range, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STNUMRANGE
)
-
STMODPRE
(
type: esriFieldTypeString, alias: Street Modifier Prefix, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STMODPRE
)
-
STDIRPRE
(
type: esriFieldTypeString, alias: Street Direction Prefix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STDIRPRE
, Coded Values:
[N: North]
, [S: South]
, [E: East]
, ...9 more...
)
-
STREETTYPEPRE
(
type: esriFieldTypeString, alias: Street Type Prefix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREETTYPEPRE
, Coded Values:
[ABBEY: Abbey]
, [ACRES: Acres]
, [ALLÉE: Allée]
, ...135 more...
)
-
STREETNAME
(
type: esriFieldTypeString, alias: Street Name, editable: true, 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]
, ...135 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...
)
-
STMODSUFF
(
type: esriFieldTypeString, alias: Street Modifier Suffix, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STMODSUFF
)
-
ST_ARTICLE
(
type: esriFieldTypeString, alias: Street Name Article, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ST_ARTICLE
)
-
MUNINAME
(
type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUNINAME
)
-
MUNIALIAS
(
type: esriFieldTypeString, alias: Municipality Alias, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUNIALIAS
)
-
MUNIID
(
type: esriFieldTypeString, alias: Municipal ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MUNIID
)
-
MUNITYPE
(
type: esriFieldTypeString, alias: Municipal Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUNITYPE
, Coded Values:
[Région administrative: Région administrative]
, [Charter Community: Charter Community]
, [City: City]
, ...23 more...
)
-
REGIONAL_DISTRICT
(
type: esriFieldTypeString, alias: Regional District, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REGIONAL_DISTRICT
)
-
COMMUNITY
(
type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMUNITY
)
-
ALTNAME1
(
type: esriFieldTypeString, alias: Alternate Name 1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ALTNAME1
)
-
ALTNAME2
(
type: esriFieldTypeString, alias: Alternate Name 2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ALTNAME2
)
-
ALTERNATEACCESS
(
type: esriFieldTypeString, alias: Alternate Access, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ALTERNATEACCESS
)
-
ADDRESSNOTES
(
type: esriFieldTypeString, alias: Address Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESSNOTES
)
-
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: null, modelName: PROVINCE
, Coded Values:
[AB: Alberta]
, [BC: British Columbia]
, [MB: Manitoba]
, ...10 more...
)
-
MGRS_COORD
(
type: esriFieldTypeString, alias: MGRS Coordinate, editable: true, nullable: true, length: 14, defaultValue: null, modelName: MGRS_COORD
)
-
POSTALCODE
(
type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: POSTALCODE
)
-
AGENCY
(
type: esriFieldTypeString, alias: Addressing Agency, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AGENCY
)
-
RETIREDDATE
(
type: esriFieldTypeDate, alias: Address Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETIREDDATE
)
-
LASTUPDATE
(
type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE
)
-
LASTEDITOR
(
type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR
)
-
CREATEDDATE
(
type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATEDDATE
)
-
CREATEDBY
(
type: esriFieldTypeString, alias: Creation Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATEDBY
)
-
ACQU_TECH
(
type: esriFieldTypeSmallInteger, alias: Acquisition Technique, editable: true, nullable: true, defaultValue: null, modelName: ACQU_TECH
, Coded Values:
[-1: Unknown]
, [0: None]
, [1: Other]
, ...12 more...
)
-
ACCURACY_M
(
type: esriFieldTypeDouble, alias: Planimetric Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ACCURACY_M
)
-
SCALE_LRG
(
type: esriFieldTypeInteger, alias: Largest Scale, editable: true, nullable: true, defaultValue: null, modelName: SCALE_LRG
, Coded Values:
[0: None]
, [1250: 1:1 250 (Building)]
, [2500: 1:2 500 (Buildings)]
, ...16 more...
)
-
SCALE_SM
(
type: esriFieldTypeInteger, alias: Smallest Scale, editable: true, nullable: true, defaultValue: null, modelName: SCALE_SM
, Coded Values:
[0: None]
, [1250: 1:1 250 (Building)]
, [2500: 1:2 500 (Buildings)]
, ...16 more...
)
-
STATUS
(
type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS
, Coded Values:
[Current: Current]
, [Pending: Pending]
, [Retired: Retired]
, ...3 more...
)
-
FULLSTREETNAME
(
type: esriFieldTypeString, alias: Full Street Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FULLSTREETNAME
)
-
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: Site Addresses with Owners
Description:
Prototype:
FULLSTREETNAME: null
STATUS: null
CIVICID: null
POINTTYPE: null
PARCELID: null
FACILITYID: null
ADDPTKEY: null
FULLADDRESS: null
STNUMPRE: null
STREETNUM: null
STNUMSUFF: null
STNUMRANGE: null
STMODPRE: null
STDIRPRE: null
STREETTYPEPRE: null
STREETNAME: null
STREETTYPE: null
STDIRSUFF: null
STMODSUFF: null
ST_ARTICLE: null
MUNINAME: null
MUNIALIAS: null
MUNIID: null
MUNITYPE: null
REGIONAL_DISTRICT: null
COMMUNITY: null
ALTNAME1: null
ALTNAME2: null
ALTERNATEACCESS: null
ADDRESSNOTES: null
BUILDINGNAME: null
BUILDINGCLASS: null
BUILDINGTYPE: null
PROVINCE: null
MGRS_COORD: null
POSTALCODE: null
AGENCY: null
RETIREDDATE: null
LASTUPDATE: null
LASTEDITOR: null
CREATEDDATE: null
CREATEDBY: null
ACQU_TECH: null
ACCURACY_M: null
SCALE_LRG: null
SCALE_SM: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports ApplyEdits By Upload Id: 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
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Attachments
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata