View In:   ArcGIS Online Map Viewer

Name: ADDRESS

Display Field: COMPLETE_ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Commerce City's Address Point file is a digital, geospatial file containing all address points within the city as well as points that are contained in enclaves. This dataset has been compiled from multiple jurisdictions and agencies to ensure the most complete set of addresses possible.

Copyright Text: Commerce City Engineering Division (original city address data), Commerce City Public Works (trash customer list), Corona Research, Inc. (Commerce City Census), Adams County Clerk & Recorder (voter registration list), South Adams County Water & Sanitation District (customer list), Commerce City Building Division (building permits)

Default Visibility: true

MaxRecordCount: 1500

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -118767900
YMin: -94525500
XMax: 3246718.09557766
YMax: 1769316.9040288166
Spatial Reference: 2877  (2877)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [130, 93, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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 )
• ADDR_HN ( type: esriFieldTypeSmallInteger, alias: Address House Number, editable: true, nullable: true, defaultValue: null, modelName: ADDR_HN )
• ADDR_HNS ( type: esriFieldTypeString, alias: House Number Suffix, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ADDR_HNS )
• COMPLETE_ST_NAME ( type: esriFieldTypeString, alias: Complete Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMPLETE_STREETNAME )
• COMPLETE_ADDR ( type: esriFieldTypeString, alias: Complete Address, editable: true, nullable: true, length: 60, defaultValue: null, modelName: COMPLETE_STREETADDR )
• COMPLETE_SUBADDR ( type: esriFieldTypeString, alias: Complete Subaddress, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPLETE_SUBADDR )
• DELIVERY_ADDR ( type: esriFieldTypeString, alias: Delivery Address, editable: true, nullable: true, length: 90, defaultValue: null, modelName: DELIVERY_ADDR )
• BLDG_NUMBER ( type: esriFieldTypeString, alias: Building Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDGNUMBER )
• ADDR_CITY ( type: esriFieldTypeString, alias: City (Address), editable: true, nullable: true, length: 15, defaultValue: COMMERCE CITY, modelName: PLACE , Coded Values: [AURORA: AURORA] , [BRIGHTON: BRIGHTON] , [COMMERCE CITY: COMMERCE CITY] , ...3 more... )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 10, defaultValue: ADAMS, modelName: COUNTY , Coded Values: [ADAMS: ADAMS COUNTY] , [DENVER: CITY AND COUNTY OF DENVER] )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 15, defaultValue: CO, modelName: STATE , Coded Values: [CO: COLORADO] )
• ZIP_CODE ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 5, defaultValue: 80022, modelName: ZIPCODE , Coded Values: [80019: 80019] , [80022: 80022] , [80216: 80216] , ...9 more... )
• COUNTRY ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 3, defaultValue: USA, modelName: COUNTRY , Coded Values: [USA: United States] )
• CITY_STATE_ZIP ( type: esriFieldTypeString, alias: City, State, Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMPLETE_PLACE_STATE_ZIP )
• LOCATION_NAME ( type: esriFieldTypeString, alias: Location Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATIONNAME )
• ADDR_AUTHORITY ( type: esriFieldTypeString, alias: Addressing Authority, editable: true, nullable: true, length: 20, defaultValue: Commerce City, modelName: ADDR_AUTHORITY , Coded Values: [Commerce City: City of Commerce City] , [Adams: Adams County] , [Aurora: City of Aurora] , ...5 more... )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecyle Status, editable: true, nullable: true, length: 16, defaultValue: Pending, modelName: ADDR_LIFECYCLE , Coded Values: [Active: Active (issued and is in use)] , [Pending: Pending (pending use; i.e. CO)] , [Proposed: Proposed (in planning stage)] , ...2 more... )
• ADDR_CLASS ( type: esriFieldTypeString, alias: Address Feature Classification, editable: true, nullable: true, length: 16, defaultValue: Residential, modelName: ADDR_CLASS , Coded Values: [Landscape: Landscape Tract] , [Sign: Sign] , [Agricultural: Agricultural / Farm] , ...8 more... )
• ADDR_FEATURE_TYPE ( type: esriFieldTypeString, alias: Address Feature Type, editable: true, nullable: true, length: 20, defaultValue: Building, modelName: ADDR_FEATURE_TYPE , Coded Values: [Building: Building (Structure)] , [Complex: Campus (Bus, Educ, or Res Campus with multiple bldgs)] , [Corner: Alternate Corner Address] , ...7 more... )
• ADDR_USE_TYPE ( type: esriFieldTypeString, alias: Address Use Type, editable: true, nullable: true, length: 25, defaultValue: Single Family, modelName: ADDR_USE_TYPE , Coded Values: [Agricultural: Agricultural / Farm] , [Athletic Field: Athletic Field] , [Cemetery: Cemetery] , ...51 more... )
• CITY_FLG ( type: esriFieldTypeString, alias: City Flag (Y/N), editable: true, nullable: true, length: 3, defaultValue: YES, modelName: CITY_FLG , Coded Values: [NO: NO] , [YES: YES] )
• ENCLAVE_FLG ( type: esriFieldTypeString, alias: Enclave Flag (Y/N), editable: true, nullable: true, length: 3, defaultValue: NO, modelName: ENCLAVE_FLG , Coded Values: [NO: NO] , [YES: YES] )
• MAILABLE_FLG ( type: esriFieldTypeString, alias: Mailable (Y/N), editable: true, nullable: true, length: 3, defaultValue: NO, modelName: MAILABLE_FLG , Coded Values: [NO: NO (RECEPTICAL)] , [UNK: UNKNOWN] , [YES: YES] )
• ADDR_NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDR_NOTES )
• PARCEL_ADDR ( type: esriFieldTypeString, alias: Parcel Address (Y/N), editable: true, nullable: true, length: 3, defaultValue: YES, modelName: PARCEL_ADDR , Coded Values: [NO: NO] , [YES: YES] )
• ADDR_CO_DATE ( type: esriFieldTypeDate, alias: CO Date for Address, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDR_CO_DATE )
• 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 )
• ADDR_DATE_ASSIGNED ( type: esriFieldTypeDate, alias: Date Assigned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDR_DATE_ASSIGNED )
• ADDR_DATE_RETIRED ( type: esriFieldTypeDate, alias: Date Retired, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDR_DATE_RETIRED )
• GROUP_RESIDENCE_FLG ( type: esriFieldTypeString, alias: Group Residence (Y/N), editable: true, nullable: true, length: 3, defaultValue: null, modelName: GROUP_RESIDENCE_FLG , Coded Values: [NO: NO] , [YES: YES] )
• COMPLETE_HN ( type: esriFieldTypeString, alias: Complete House Number, editable: true, nullable: true, length: 11, defaultValue: null, modelName: COMPLETE_HN )
• ADDR_ID ( type: esriFieldTypeInteger, alias: ADDR_ID_New, editable: true, nullable: true, defaultValue: null, modelName: ADDR_ID_New )
• Verified_Notes ( type: esriFieldTypeString, alias: Verified_Notes, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Verified_Notes )
• LOCATIONTYPE ( type: esriFieldTypeString, alias: Location Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATIONTYPE )
• PARCEL_PIN ( type: esriFieldTypeString, alias: PARCEL_PIN, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PARCEL_PIN )
• STREET_ID ( type: esriFieldTypeInteger, alias: STREET_ID, editable: true, nullable: true, defaultValue: null, modelName: STREET_ID )
• LABEL_ANGLE ( type: esriFieldTypeDouble, alias: LABEL_ANGLE, editable: true, nullable: true, defaultValue: null, modelName: LABEL_ANGLE )
• ADDRESS_ID ( type: esriFieldTypeString, alias: ADDRESS_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ADDRESS_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: ADDRESS
  Description:
  Prototype:
  ADDRESS_ID: null
  LABEL_ANGLE: null
  ADDR_HN: null
  ADDR_HNS: null
  COMPLETE_ST_NAME: null
  COMPLETE_ADDR: null
  COMPLETE_SUBADDR: null
  DELIVERY_ADDR: null
  BLDG_NUMBER: null
  ADDR_CITY: COMMERCE CITY
  COUNTY: ADAMS
  STATE: CO
  ZIP_CODE: 80022
  COUNTRY: USA
  CITY_STATE_ZIP: null
  LOCATION_NAME: null
  ADDR_AUTHORITY: Commerce City
  LIFECYCLE_STATUS: Pending
  ADDR_CLASS: Residential
  ADDR_FEATURE_TYPE: Building
  ADDR_USE_TYPE: Single Family
  CITY_FLG: YES
  ENCLAVE_FLG: NO
  MAILABLE_FLG: NO
  ADDR_NOTES: null
  PARCEL_ADDR: YES
  ADDR_CO_DATE: null
  STREET_ID: null
  PARCEL_PIN: null
  LOCATIONTYPE: null
  Verified_Notes: null
  ADDR_DATE_ASSIGNED: null
  ADDR_DATE_RETIRED: null
  GROUP_RESIDENCE_FLG: null
  COMPLETE_HN: null
  ADDR_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

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