View In:   ArcGIS Online Map Viewer

Name: Valid Addresses

Display Field: STATUS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A point data file of all existing addresses in Delta County, Colorado This data is continually updated and maintained in a SDE database.

Service Item Id: b31cbbf5263b4724a36d5da72ae23e30

Copyright Text: Delta County Colorado GIS

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 2181698.0120655596
YMin: 1232915.9142155647
XMax: 2500665.2379749715
YMax: 1484810.846776396
Spatial Reference: 102654  (2232)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [168, 0, 0, 255]
Size: 2.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 0] Width: 0
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: true
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: true
Supports Query With Current User: true

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 )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVE_STA , Coded Values: [AC: Active or Current] , [AR: Active Readdressed] , [AU: Active Utility] , ...6 more... )
• SOD ( type: esriFieldTypeString, alias: Source of Data, editable: true, nullable: false, length: 6, defaultValue: DELTCO, modelName: SOD )
• SID ( type: esriFieldTypeString, alias: Site ID, editable: true, nullable: false, length: 20, defaultValue: DELTCO, modelName: SID )
• Create_Date ( type: esriFieldTypeDate, alias: Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDT )
• SAN ( type: esriFieldTypeInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: SAN )
• SNS ( type: esriFieldTypeString, alias: Suffix Number Site, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SNS )
• PRD ( type: esriFieldTypeString, alias: Prefix Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PRD , Coded Values: [N: N] , [E: E] , [S: S] , ...5 more... )
• RD ( type: esriFieldTypeString, alias: RD Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: RD , Coded Values: [10TH: 10TH] , [11TH: 11TH] , [1200: 1200] , ...911 more... )
• ASN ( type: esriFieldTypeString, alias: Alisa Street Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: BLD_ALIAS )
• STS ( type: esriFieldTypeString, alias: ST Type Suffix, editable: true, nullable: true, length: 4, defaultValue: null, modelName: STS , Coded Values: [HL: Hill] , [RD: Road] , [ST: Street] , ...13 more... )
• POD ( type: esriFieldTypeString, alias: ST Postal Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: POD , Coded Values: [N: N] , [E: E] , [S: S] , ...5 more... )
• FSN ( type: esriFieldTypeString, alias: Full Street Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FSN )
• UTY ( type: esriFieldTypeString, alias: Unit Type, editable: true, nullable: true, length: 35, defaultValue: null, modelName: UTY , Coded Values: [Unit: Unit] , [Suite: Suite] , [Apt: Apartment] , ...4 more... )
• UNIT ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 5, defaultValue: null, modelName: UNIT )
• FSA ( type: esriFieldTypeString, alias: Full Street Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FSA )
• FSA_unit ( type: esriFieldTypeString, alias: Full St Address w Unit, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address_unit )
• PCN ( type: esriFieldTypeString, alias: Postal Community Name, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PCN , Coded Values: [CRAWFORD: CRAWFORD] , [ECKERT: ECKERT] , [HOTCHKISS: HOTCHKISS] , ...7 more... )
• CITY_COUNTY ( type: esriFieldTypeString, alias: City County, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY_COUNTY , Coded Values: [City Of Delta: City Of Delta] , [Cedaredge: Cedaredge] , [Orchard City: Orchard City] , ...4 more... )
• CityCD ( type: esriFieldTypeString, alias: CityCD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CityCD )
• MCN ( type: esriFieldTypeString, alias: MSAG Community Name, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MCN , Coded Values: [AUSTIN: AUSTIN] , [CEDAREDGE: CEDAREDGE] , [CITY OF DELTA: CITY OF DELTA] , ...13 more... )
• ESN ( type: esriFieldTypeSmallInteger, alias: Emergency Service Number, editable: true, nullable: true, defaultValue: null, modelName: ESN , Coded Values: [105: 105] , [106: 106] , [108: 108] , ...18 more... )
• BLD ( type: esriFieldTypeString, alias: Building Name, editable: true, nullable: true, length: 35, defaultValue: null, modelName: BLD )
• LOC ( type: esriFieldTypeString, alias: Location Informaion, editable: true, nullable: true, length: 35, defaultValue: null, modelName: LOC )
• PLC ( type: esriFieldTypeString, alias: Place Type, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PLC )
• ADD_TYP ( type: esriFieldTypeString, alias: Address Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADD_TYP , Coded Values: [Utillity: Utillity Address] , [1st Residence: 1st Address] , [2nd Residence: 2nd Address] , ...2 more... )
• SIGN_PHASE ( type: esriFieldTypeString, alias: Sign Phase, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SIGN_PHASE )
• DRT_NUM ( type: esriFieldTypeString, alias: DRT Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PARCEL_NUM )
• MH_NUB ( type: esriFieldTypeString, alias: Manufacture Home #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MH_NUB )
• CONTROL_NUM ( type: esriFieldTypeString, alias: Control Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONTROL_NUM )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NOTE )
• COMMENT_2 ( type: esriFieldTypeString, alias: Comment 2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTE_2 )
• COMMENT_3 ( type: esriFieldTypeString, alias: Comment 3, editable: true, nullable: true, length: 200, defaultValue: null, modelName: COMMENT_3 )
• DATE_CREATED ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATE_CREATED )
• EDT_BY ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EDT_BY )
• LAT ( type: esriFieldTypeDouble, alias: LAT_Y, editable: true, nullable: true, defaultValue: null, modelName: LAT )
• LON ( type: esriFieldTypeDouble, alias: LON_X, editable: true, nullable: true, defaultValue: null, modelName: LON )
• DOC_LINK ( type: esriFieldTypeString, alias: Address Documents Link, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DOC_LINK )
• CREAT_BY ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREAT_BY )
• old_adress ( type: esriFieldTypeString, alias: Old Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: old_adress )
• FSAN ( type: esriFieldTypeString, alias: Full Street Address Number Suffix, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FSAN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Zip ( type: esriFieldTypeInteger, alias: Zip, editable: true, nullable: true, defaultValue: null, modelName: Zip , Coded Values: [81415: 81415] , [81416: 81416] , [81418: 81418] , ...10 more... )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: State , Coded Values: [CO: Colorado] )
• AKA ( type: esriFieldTypeString, alias: AKA, editable: true, nullable: true, length: 60, defaultValue: null, modelName: AKA )
• AKA2 ( type: esriFieldTypeString, alias: AKA2, editable: true, nullable: true, length: 60, defaultValue: null, modelName: AKA2 )
• AKA3 ( type: esriFieldTypeString, alias: AKA3, editable: true, nullable: true, length: 60, defaultValue: null, modelName: AKA3 )
• AKA4 ( type: esriFieldTypeString, alias: AKA4, editable: true, nullable: true, length: 60, defaultValue: null, modelName: AKA4 )
• EffectiveDate ( type: esriFieldTypeDate, alias: Effective date of address, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EffectiveDate )
• CriticalInfrastructure ( type: esriFieldTypeString, alias: Critical Infrasturcture for Hazard, editable: true, nullable: true, length: 3, defaultValue: N, modelName: CriticalInfrastructure , Coded Values: [Y: Yes] , [N: No] )

Templates:

• Name: Valid Addresses
  Description:
  Prototype:
  EffectiveDate: null
  AKA4: null
  STATUS: null
  SOD: DELTCO
  SID: DELTCO
  AKA3: null
  SAN: null
  SNS: null
  PRD: null
  RD: null
  ASN: null
  STS: null
  POD: null
  FSN: null
  UTY: null
  UNIT: null
  FSA: null
  FSA_unit: null
  PCN: null
  CITY_COUNTY: null
  CityCD: null
  MCN: null
  ESN: null
  BLD: null
  LOC: null
  PLC: null
  ADD_TYP: null
  SIGN_PHASE: null
  DRT_NUM: null
  MH_NUB: null
  CONTROL_NUM: null
  COMMENT: null
  COMMENT_2: null
  COMMENT_3: null
  AKA2: null
  AKA: null
  LAT: null
  LON: null
  DOC_LINK: null
  State: null
  old_adress: null
  FSAN: null
  CriticalInfrastructure: N
  Zip: 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: Create_Date
• Creator Field: CREAT_BY
• Edit Date Field: DATE_CREATED
• Editor Field: EDT_BY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata