Layers:

Layer: Addresses (0)

Name: Addresses

Display Field: C3GISR.SDE.ADDRESS.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: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

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: [0, 128, 72, 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: false
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: null

Fields:
• C3GISR.SDE.ADDRESS.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• C3GISR.SDE.ADDRESS.ADDR_HN ( type: esriFieldTypeSmallInteger, alias: Address House Number )
• C3GISR.SDE.ADDRESS.ADDR_HNS ( type: esriFieldTypeString, alias: House Number Suffix, length: 4 )
• C3GISR.SDE.ADDRESS.COMPLETE_ST_NAME ( type: esriFieldTypeString, alias: Complete Street Name, length: 50 )
• C3GISR.SDE.ADDRESS.COMPLETE_ADDR ( type: esriFieldTypeString, alias: Complete Address, length: 60 )
• C3GISR.SDE.ADDRESS.COMPLETE_SUBADDR ( type: esriFieldTypeString, alias: Complete Subaddress, length: 30 )
• C3GISR.SDE.ADDRESS.DELIVERY_ADDR ( type: esriFieldTypeString, alias: Delivery Address, length: 90 )
• C3GISR.SDE.ADDRESS.BLDG_NUMBER ( type: esriFieldTypeString, alias: Building Number, length: 10 )
• C3GISR.SDE.ADDRESS.ADDR_CITY ( type: esriFieldTypeString, alias: City (Address), length: 15 , Coded Values: [AURORA: AURORA] , [BRIGHTON: BRIGHTON] , [COMMERCE CITY: COMMERCE CITY] , ...3 more... )
• C3GISR.SDE.ADDRESS.COUNTY ( type: esriFieldTypeString, alias: County, length: 10 , Coded Values: [ADAMS: ADAMS COUNTY] , [DENVER: CITY AND COUNTY OF DENVER] )
• C3GISR.SDE.ADDRESS.STATE ( type: esriFieldTypeString, alias: State, length: 15 , Coded Values: [CO: COLORADO] )
• C3GISR.SDE.ADDRESS.ZIP_CODE ( type: esriFieldTypeString, alias: Zip Code, length: 5 , Coded Values: [80019: 80019] , [80022: 80022] , [80216: 80216] , ...9 more... )
• C3GISR.SDE.ADDRESS.COUNTRY ( type: esriFieldTypeString, alias: Country, length: 3 , Coded Values: [USA: United States] )
• C3GISR.SDE.ADDRESS.CITY_STATE_ZIP ( type: esriFieldTypeString, alias: City, State, Zip, length: 50 )
• C3GISR.SDE.ADDRESS.LOCATION_NAME ( type: esriFieldTypeString, alias: Location Name, length: 50 )
• C3GISR.SDE.ADDRESS.ADDR_AUTHORITY ( type: esriFieldTypeString, alias: Addressing Authority, length: 20 , Coded Values: [Commerce City: City of Commerce City] , [Adams: Adams County] , [Aurora: City of Aurora] , ...5 more... )
• C3GISR.SDE.ADDRESS.LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecyle Status, length: 16 , Coded Values: [Active: Active (issued and is in use)] , [Pending: Pending (pending use; i.e. CO)] , [Proposed: Proposed (in planning stage)] , ...2 more... )
• C3GISR.SDE.ADDRESS.ADDR_CLASS ( type: esriFieldTypeString, alias: Address Feature Classification, length: 16 , Coded Values: [Landscape: Landscape Tract] , [Sign: Sign] , [Agricultural: Agricultural / Farm] , ...8 more... )
• C3GISR.SDE.ADDRESS.ADDR_FEATURE_TYPE ( type: esriFieldTypeString, alias: Address Feature Type, length: 20 , Coded Values: [Building: Building (Structure)] , [Complex: Campus (Bus, Educ, or Res Campus with multiple bldgs)] , [Corner: Alternate Corner Address] , ...7 more... )
• C3GISR.SDE.ADDRESS.ADDR_USE_TYPE ( type: esriFieldTypeString, alias: Address Use Type, length: 25 , Coded Values: [Agricultural: Agricultural / Farm] , [Athletic Field: Athletic Field] , [Cemetery: Cemetery] , ...51 more... )
• C3GISR.SDE.ADDRESS.CITY_FLG ( type: esriFieldTypeString, alias: City Flag (Y/N), length: 3 , Coded Values: [NO: NO] , [YES: YES] )
• C3GISR.SDE.ADDRESS.ENCLAVE_FLG ( type: esriFieldTypeString, alias: Enclave Flag (Y/N), length: 3 , Coded Values: [NO: NO] , [YES: YES] )
• C3GISR.SDE.ADDRESS.MAILABLE_FLG ( type: esriFieldTypeString, alias: Mailable (Y/N), length: 3 , Coded Values: [NO: NO (RECEPTICAL)] , [UNK: UNKNOWN] , [YES: YES] )
• C3GISR.SDE.ADDRESS.ADDR_NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• C3GISR.SDE.ADDRESS.PARCEL_ADDR ( type: esriFieldTypeString, alias: Parcel Address (Y/N), length: 3 , Coded Values: [NO: NO] , [YES: YES] )
• C3GISR.SDE.ADDRESS.ADDR_CO_DATE ( type: esriFieldTypeDate, alias: CO Date for Address, length: 8 )
• C3GISR.SDE.ADDRESS.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• C3GISR.SDE.ADDRESS.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• C3GISR.SDE.ADDRESS.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• C3GISR.SDE.ADDRESS.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• C3GISR.SDE.ADDRESS.ADDR_DATE_ASSIGNED ( type: esriFieldTypeDate, alias: Date Assigned, length: 8 )
• C3GISR.SDE.ADDRESS.ADDR_DATE_RETIRED ( type: esriFieldTypeDate, alias: Date Retired, length: 8 )
• C3GISR.SDE.ADDRESS.GROUP_RESIDENCE_FLG ( type: esriFieldTypeString, alias: Group Residence (Y/N), length: 3 , Coded Values: [NO: NO] , [YES: YES] )
• C3GISR.SDE.ADDRESS.COMPLETE_HN ( type: esriFieldTypeString, alias: Complete House Number, length: 11 )
• C3GISR.SDE.ADDRESS.ADDR_ID ( type: esriFieldTypeInteger, alias: ADDR_ID_New )
• C3GISR.SDE.ADDRESS.Verified_Notes ( type: esriFieldTypeString, alias: Verified_Notes, length: 256 )
• C3GISR.SDE.ADDRESS.LOCATIONTYPE ( type: esriFieldTypeString, alias: Location Type, length: 50 )
• C3GISR.SDE.ADDRESS.PARCEL_PIN ( type: esriFieldTypeString, alias: PARCEL_PIN, length: 15 )
• C3GISR.SDE.ADDRESS.STREET_ID ( type: esriFieldTypeInteger, alias: STREET_ID )
• C3GISR.SDE.ADDRESS.LABEL_ANGLE ( type: esriFieldTypeDouble, alias: LABEL_ANGLE )
• C3GISR.SDE.ADDRESS.ADDRESS_ID ( type: esriFieldTypeString, alias: ADDRESS_ID, length: 15 )
• C3GISR.SDE.ADDRESS.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• C3GISR.SDE.ADDRESS.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• C3GISR.SDE.Restaurant_Information.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• C3GISR.SDE.Restaurant_Information.RESTAURANT_NAME ( type: esriFieldTypeString, alias: RESTAURANT_NAME, length: 50 )
• C3GISR.SDE.Restaurant_Information.LOCAL_OWNED ( type: esriFieldTypeString, alias: LOCAL_OWNED, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• C3GISR.SDE.Restaurant_Information.FAST_FOOD ( type: esriFieldTypeString, alias: FAST_FOOD, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• C3GISR.SDE.Restaurant_Information.LATE_NIGHT ( type: esriFieldTypeString, alias: LATE_NIGHT, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• C3GISR.SDE.Restaurant_Information.RESTAURANT_URL ( type: esriFieldTypeString, alias: RESTAURANT_URL, length: 500 )
• C3GISR.SDE.Restaurant_Information.GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• C3GISR.SDE.Restaurant_Information.ADDRESS_GID ( type: esriFieldTypeGUID, alias: ADDRESS_GID, length: 38 )
• C3GISR.SDE.Restaurant_Information.ADDRESS_ID ( type: esriFieldTypeString, alias: ADDRESS_ID, length: 15 )
• C3GISR.SDE.Restaurant_Information.ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• C3GISR.SDE.Restaurant_Information.created_user ( type: esriFieldTypeString, alias: created_user, length: 50 )
• C3GISR.SDE.Restaurant_Information.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• C3GISR.SDE.Restaurant_Information.last_edit_user ( type: esriFieldTypeString, alias: last_edit_user, length: 50 )
• C3GISR.SDE.Restaurant_Information.last_edit_date ( type: esriFieldTypeDate, alias: last_edit_date, length: 8 )

Tables:

Table: C3GISR.SDE.Restaurant_Information (1)

Name: C3GISR.SDE.Restaurant_Information

Display Field: RESTAURANT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RESTAURANT_NAME ( type: esriFieldTypeString, alias: RESTAURANT_NAME, length: 50 )
• LOCAL_OWNED ( type: esriFieldTypeString, alias: LOCAL_OWNED, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• FAST_FOOD ( type: esriFieldTypeString, alias: FAST_FOOD, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• LATE_NIGHT ( type: esriFieldTypeString, alias: LATE_NIGHT, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• RESTAURANT_URL ( type: esriFieldTypeString, alias: RESTAURANT_URL, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ADDRESS_GID ( type: esriFieldTypeGUID, alias: ADDRESS_GID, length: 38 )
• ADDRESS_ID ( type: esriFieldTypeString, alias: ADDRESS_ID, length: 15 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 50 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edit_user ( type: esriFieldTypeString, alias: last_edit_user, length: 50 )
• last_edit_date ( type: esriFieldTypeDate, alias: last_edit_date, length: 8 )