Name: Addresses

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)

Min. Scale: 5000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

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

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"903a6dedf7449d35fc944d06c1f68f28","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAbElEQVQYlYXOIQrDQBAF0EeyvibU9BQ9SWVdLhIRagq9Q13tnqQ6PiIQ3YrIlJokLGvyYeDDPJgJdhKyfsUREUMOIi5Lb3FGv4JTsoQDatxWMGFGmaBveuKDBncUeOOZ//DACxU6/HIA4zJb/jGUESDrSmVlAAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[DELIVERY_ADDR]","labelPlacement":"esriServerPointLabelPlacementAboveCenter","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"useCodedValues":true,"maxScale":0,"minScale":2400,"name":"Default","priority":2,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":6,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ADDR_HN (type: esriFieldTypeSmallInteger, alias: Address House Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDR_HNS (type: esriFieldTypeString, alias: House Number Suffix, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• COMPLETE_ST_NAME (type: esriFieldTypeString, alias: Complete Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMPLETE_ADDR (type: esriFieldTypeString, alias: Complete Address, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• COMPLETE_SUBADDR (type: esriFieldTypeString, alias: Complete Subaddress, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DELIVERY_ADDR (type: esriFieldTypeString, alias: Delivery Address, SQL Type: sqlTypeOther, length: 90, nullable: true, editable: true)
• BLDG_NUMBER (type: esriFieldTypeString, alias: Building Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADDR_CITY (type: esriFieldTypeString, alias: City (Address), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [AURORA: AURORA], [BRIGHTON: BRIGHTON], [COMMERCE CITY: COMMERCE CITY], ... 3 more ...)
• COUNTY (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ADAMS: ADAMS COUNTY], [DENVER: CITY AND COUNTY OF DENVER])
• STATE (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [CO: COLORADO])
• ZIP_CODE (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [80019: 80019], [80022: 80022], [80216: 80216], ... 9 more ...)
• COUNTRY (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [USA: United States])
• CITY_STATE_ZIP (type: esriFieldTypeString, alias: City, State, Zip, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION_NAME (type: esriFieldTypeString, alias: Location Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDR_AUTHORITY (type: esriFieldTypeString, alias: Addressing Authority, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Commerce City: City of Commerce City], [Adams: Adams County], [Aurora: City of Aurora], ... 5 more ...)
• LIFECYCLE_STATUS (type: esriFieldTypeString, alias: Lifecyle Status, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [Landscape: Landscape Tract], [Sign: Sign], [Agricultural: Agricultural / Farm], ... 8 more ...)
• ADDR_FEATURE_TYPE (type: esriFieldTypeString, alias: Address Feature Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Agricultural: Agricultural / Farm], [Athletic Field: Athletic Field], [Cemetery: Cemetery], ... 51 more ...)
• CITY_FLG (type: esriFieldTypeString, alias: City Flag (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES])
• ENCLAVE_FLG (type: esriFieldTypeString, alias: Enclave Flag (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES])
• MAILABLE_FLG (type: esriFieldTypeString, alias: Mailable (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: NO (RECEPTICAL)], [UNK: UNKNOWN], [YES: YES])
• ADDR_NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PARCEL_ADDR (type: esriFieldTypeString, alias: Parcel Address (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES])
• ADDR_CO_DATE (type: esriFieldTypeDate, alias: CO Date for Address, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ADDR_DATE_ASSIGNED (type: esriFieldTypeDate, alias: Date Assigned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADDR_DATE_RETIRED (type: esriFieldTypeDate, alias: Date Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GROUP_RESIDENCE_FLG (type: esriFieldTypeString, alias: Group Residence (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES])
• COMPLETE_HN (type: esriFieldTypeString, alias: Complete House Number, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• ADDR_ID (type: esriFieldTypeInteger, alias: ADDR_ID_New, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Verified_Notes (type: esriFieldTypeString, alias: Verified_Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• LOCATIONTYPE (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PARCEL_PIN (type: esriFieldTypeString, alias: PARCEL_PIN, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STREET_ID (type: esriFieldTypeInteger, alias: STREET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LABEL_ANGLE (type: esriFieldTypeDouble, alias: LABEL_ANGLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESS_ID (type: esriFieldTypeString, alias: ADDRESS_ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ADDR_CITY: COMMERCE CITY
• COUNTY: ADAMS
• STATE: CO
• ZIP_CODE: 80022
• COUNTRY: USA
• 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
• PARCEL_ADDR: YES

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/10/2025 5:12:57 PM

Schema Last Edit Date: 1/10/2025 5:12:57 PM

Data Last Edit Date: 1/10/2025 5:10:31 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat