Layer: gis_prod.SDE.Address (ID:2)

View In: Map Viewer

Name: gis_prod.SDE.Address

Display Field: COMPLETE_STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[133,0,11,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":[{"labelPlacement":"esriServerPointLabelPlacementAboveRight","where":null,"labelExpression":"[DELIVERY_ADDR]","useCodedValues":true,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":8,"style":"normal","weight":"normal","decoration":"none"}},"minScale":0,"maxScale":0}]}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ADDR_HNUM (type: esriFieldTypeSmallInteger, alias: House Number (numeric), SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_HN (type: esriFieldTypeString, alias: House Number (text), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
ADDR_HNS (type: esriFieldTypeString, alias: House Number Suffix, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
COMPLETE_HN (type: esriFieldTypeString, alias: Complete House Number, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
ADDR_PD (type: esriFieldTypeString, alias: Pre-Direction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N (North)], [S: S (South)], [W: W (West)], ... 1 more ...)
ADDR_PT (type: esriFieldTypeString, alias: Pre-Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [E: E (Extension; E-470 Authority)], [I: I (Interstate)], [SH: SH (State Highway)], ... 3 more ...)
ADDR_SN (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [-H-: --- HIGHWAYS ---], [2: 2], [6: 6], ... 392 more ...)
ADDR_ST (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [AVE: AVE (Avenue)], [AVE DR: AVE DR (Avenue Drive)], [BLVD: BLVD (Boulevard)], ... 23 more ...)
ADDR_SD (type: esriFieldTypeString, alias: Sufix Direction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N (North)], [S: S (South)], [W: W (West)], ... 1 more ...)
ADDR_SM (type: esriFieldTypeString, alias: Sufix Modifier, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
COMPLETE_STREETNAME (type: esriFieldTypeString, alias: Complete Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABILENE ST: ABILENE ST], [ADAMS ST: ADAMS ST], [ADDISH ST: ADDISH ST], ... 744 more ...)
COMPLETE_ADDRRESS (type: esriFieldTypeString, alias: Complete Address, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
BLDG_IDENTIFIER (type: esriFieldTypeString, alias: Bldg Identifier, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
FLOOR_DESIGNATOR (type: esriFieldTypeString, alias: FLOOR_DESIGNATOR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
FLOOR (type: esriFieldTypeString, alias: FLOOR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
SUBADDR_TYPE (type: esriFieldTypeString, alias: Subaddress Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [APT: APT (Apartment)], [STE: STE (Suite)], [RM: RM (Room)], ... 14 more ...)
SUBADDR_UNIT (type: esriFieldTypeString, alias: Subaddress Unit, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
SUBADDR_COMPONENT_ORDER (type: esriFieldTypeSmallInteger, alias: Subaddress Component Order, SQL Type: sqlTypeOther, 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)
PLACE (type: esriFieldTypeString, alias: Place (City), 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: 2, nullable: true, editable: true, Coded Values: [CO: COLORADO])
ZIPCODE (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [80022: 80022 (Commerce City)], [80229: 80229 (Denver -Welby / South Thornton)], [80249: 80249 (Denver - DIA)], ... 9 more ...)
ZIP_PLUS4 (type: esriFieldTypeString, alias: ZIP Plus 4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
COUNTRY (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [USA: United States])
COMPLETE_PLACE_STATE_ZIP (type: esriFieldTypeString, alias: Complete Place, State Zip, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ADDR_ID (type: esriFieldTypeInteger, alias: ADDR_ID_New, SQL Type: sqlTypeOther, 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 ...)
SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [C3 Authority: C3 Official Address Authority (PW)], [C3 Bldg Permit: C3 Building Permit], [C3 Bus Lic: C3 Business License (FD/ED)], ... 22 more ...)
LIFECYCLE_STATUS (type: esriFieldTypeString, alias: Lifecyle Status, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [Potential: Potential (falls within a theoretical range)], [Proposed: Proposed (in planning stage)], [Pending: Pending (pending use; i.e. CO)], ... 3 more ...)
OFFICIAL_STATUS (type: esriFieldTypeString, alias: OFfical Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Official: Official address by Address Authority], [Official Alternate: Official Alt. Est. by Address Authority], [Official Vanity: Official Vanity Established by Address Authority], ... 7 more ...)
ADDR_CLASS (type: esriFieldTypeString, alias: Address Feature Classification, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [Agricultural: 1Agricultural / Farm], [Residential: 2Residential], [Business: 3Business (commercial / industrial)], ... 6 more ...)
ADDR_FEATURE_TYPE (type: esriFieldTypeString, alias: Address Feature Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Vacant: 1Vacant Parcel - No MAIN structure], [Corner: 2Alternate Corner Address], [Building: 3Building (Structure)], ... 6 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], ... 48 more ...)
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)
CITY_FLG (type: esriFieldTypeString, alias: City Flag (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ENCLAVE_FLG (type: esriFieldTypeString, alias: Enclave Flag (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
GROUP_RESIDENCE_FLG (type: esriFieldTypeString, alias: Group Residence (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes - Is a group residence], [No: No - Is not a group residence], [Unk: Unknown / Undefined])
MAILABLE_FLG (type: esriFieldTypeString, alias: Mailable (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [Unk: Unknown], [No: No (receptical)])
DELIVERY_ADDR_TYPE (type: esriFieldTypeString, alias: Delivery Address Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Subaddress Included: Subaddress Included], [Subaddress Excluded: Subaddress Excluded], [Unstated: Not stated/no information])
USPS_ROUTE (type: esriFieldTypeString, alias: USPS Route, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
USPS_DPV (type: esriFieldTypeString, alias: USPS DPV Code, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
DELIVERY_ERRORCODE (type: esriFieldTypeString, alias: Delivery Error Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [I101: Sub-Address number missing], [I102: Sub-Address invalid or unavailable], [I103: Missing company name], ... 30 more ...)
ADDR_STREET_SIDE (type: esriFieldTypeString, alias: Address Street Side, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Left: Left (side of Street)], [Right: Right (side of Street)], [Both: Both (sides of Street) (typically not used)], ... 2 more ...)
ADDR_PARITY (type: esriFieldTypeString, alias: Address Parity, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Even: Even (house number)], [Odd: Odd (house number)])
ADDR_ZLEVEL (type: esriFieldTypeSmallInteger, alias: Address Z-Level, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_DIRECT_SRC (type: esriFieldTypeString, alias: Address Direct Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [C3 Authority: C3 Official Address Authority (PW)], [C3 Bldg Permit: C3 Building Permit], [C3 Bus Lic: C3 Business License (FD/ED)], ... 22 more ...)
LOCATION_DESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
ADDR_NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RELATED_ADDR_ID (type: esriFieldTypeInteger, alias: Related Address ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_RELATION_TYPE (type: esriFieldTypeString, alias: Address Relationship Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
ADDR_PARCEL_ID (type: esriFieldTypeString, alias: Address Parcel ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
ADDR_PARCEL_SRC (type: esriFieldTypeString, alias: Source of Parcel Address, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Adams: Adams Co. Assessor's Office], [Denver: City and Co. of Denver Assessor's Office])
CC_PARCEL_ID (type: esriFieldTypeInteger, alias: CC Parcel Bus. ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARCEL_ADDR (type: esriFieldTypeString, alias: Parcel Address (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BLDG_ID (type: esriFieldTypeInteger, alias: Related Building Bus. ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET_ID (type: esriFieldTypeSmallInteger, alias: Related Street Bus. ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET_DIST (type: esriFieldTypeDouble, alias: Address Distance to Street, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_CO_DATE (type: esriFieldTypeDate, alias: CO Date for Address, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ADDR_ANOMALY_STATUS (type: esriFieldTypeString, alias: Anomaly Status, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
ADDR_QA_VAL_FLGS (type: esriFieldTypeInteger, alias: QA Validation Flags, SQL Type: sqlTypeOther, nullable: true, editable: true)
ANOMALLY_FLGS (type: esriFieldTypeInteger, alias: Anomally Flags, SQL Type: sqlTypeOther, nullable: true, editable: true)
EXCEPTION_FLGS (type: esriFieldTypeInteger, alias: Anomally Exception Flags, SQL Type: sqlTypeOther, nullable: true, editable: true)
VAL_EXCEPTION_NOTE (type: esriFieldTypeString, alias: Note for Validation Exception, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
PW_TEXTSTRING (type: esriFieldTypeString, alias: Original PW Textstring, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PW_UNIT (type: esriFieldTypeString, alias: PW Unit, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PW_ORG_X_COORD (type: esriFieldTypeDouble, alias: PW_ORG_X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
PW_ORG_Y_COORD (type: esriFieldTypeDouble, alias: PW_ORG_Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_X_COORD (type: esriFieldTypeDouble, alias: ADDR_X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_Y_COORD (type: esriFieldTypeDouble, alias: ADDR_Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_ELEVATION (type: esriFieldTypeDouble, alias: ADDR_ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_LONG (type: esriFieldTypeDouble, alias: ADDR_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDR_LAT (type: esriFieldTypeDouble, alias: ADDR_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
US_NATL_GRID (type: esriFieldTypeString, alias: US_NATL_GRID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
DPV_Postal_Notes (type: esriFieldTypeString, alias: Note- DPV Postal Errors, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
PW_TEXTSTRING_CUR (type: esriFieldTypeString, alias: Current PW Textstring, SQL Type: sqlTypeOther, length: 50, 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)
VALIDATION_FLGS (type: esriFieldTypeInteger, alias: Validation Flags for CAMS Tools, SQL Type: sqlTypeOther, nullable: true, editable: true)
Verified (type: esriFieldTypeString, alias: Verified, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Verified_Date (type: esriFieldTypeDate, alias: Verified_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Verified_Notes (type: esriFieldTypeString, alias: Verified_Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Verification_Abbrv (type: esriFieldTypeString, alias: Verification_Abbrv, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

ANOMALLY_FLGS: 0
EXCEPTION_FLGS: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/22/2019 8:49:59 PM

Schema Last Edit Date: 2/22/2019 8:49:59 PM

Data Last Edit Date: 2/22/2019 8:49:59 PM

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