View In:   ArcGIS Online Map Viewer

Name: Addresses

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: ColumbiaGis.dbo.Addresses

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3988.327044546687

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.25938627483313E8
YMin: -9.145296284683143E7
XMax: 1.29875627483313E8
YMax: 3.7469186082798615E7
Spatial Reference: 102660  (2238)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AddressClassCodeDesc
Field 2: N/A
Field 3: N/A
Field Delimiter: ;
Default Symbol:
Style: esriSMSCircle
Color: [0, 92, 230, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: Agriculture, Food, and Livestock
  Label: Agriculture, Food, and Livestock
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Building General
  Label: Building General
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Commercial and Retail
  Label: Commercial and Retail
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Health and Medical
  Label: Health and Medical
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Information and Communication
  Label: Information and Communication
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [225, 225, 225, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Power Pole
  Label: Power Pole
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [215, 194, 158, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Public Attractions and Landmark Buildings
  Label: Public Attractions and Landmark Buildings
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Transporation Facilities
  Label: Transporation Facilities
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: -12
YOffset: 4
Size: 12
Font Family: Corbel
Font Style: italic
Font Weight: bold
Font Decoration: none

Min. Scale: 5163.0419988427375
Max. Scale: 0.0

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: AddressClassCodeDesc

Fields:

• Id ( type: esriFieldTypeOID, alias: Id, editable: false, nullable: false, defaultValue: null, modelName: Id )
• ObjectID ( type: esriFieldTypeInteger, alias: ObjectID, editable: true, nullable: true, defaultValue: null, modelName: ObjectID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Address )
• HouseNo ( type: esriFieldTypeString, alias: HouseNo, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HouseNo )
• UnitType ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UnitType )
• UnitID ( type: esriFieldTypeString, alias: UnitID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UnitID )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 125, defaultValue: null, modelName: RoadName )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 35, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: State )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ZipCode )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Status )
• ParcelNo ( type: esriFieldTypeString, alias: ParcelNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ParcelNo )
• ProposedParcelNo ( type: esriFieldTypeString, alias: ProposedParcelNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProposedParcelNo )
• AddressClassCode ( type: esriFieldTypeInteger, alias: Class Code, editable: true, nullable: true, defaultValue: null, modelName: AddressClassCode )
• AddressClassCodeDesc ( type: esriFieldTypeString, alias: Class Code Description, editable: true, nullable: true, length: 500, defaultValue: null, modelName: AddressClassCodeDesc )
• OldAddress ( type: esriFieldTypeString, alias: Prior Address (Retired), editable: true, nullable: true, length: 500, defaultValue: null, modelName: OldAddress )

Types:

ID: Agriculture, Food, and Livestock
Name: Agriculture, Food, and Livestock
Domains:
Templates:
• Name: Agriculture, Food, and Livestock
  Description:
  Prototype:
  AddressClassCodeDesc: Agriculture, Food, and Livestock
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Building General
Name: Building General
Domains:
Templates:
• Name: Building General
  Description:
  Prototype:
  AddressClassCodeDesc: Building General
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Commercial and Retail
Name: Commercial and Retail
Domains:
Templates:
• Name: Commercial and Retail
  Description:
  Prototype:
  AddressClassCodeDesc: Commercial and Retail
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Health and Medical
Name: Health and Medical
Domains:
Templates:
• Name: Health and Medical
  Description:
  Prototype:
  AddressClassCodeDesc: Health and Medical
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Information and Communication
Name: Information and Communication
Domains:
Templates:
• Name: Information and Communication
  Description:
  Prototype:
  AddressClassCodeDesc: Information and Communication
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Power Pole
Name: Power Pole
Domains:
Templates:
• Name: Power Pole
  Description:
  Prototype:
  AddressClassCodeDesc: Power Pole
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Public Attractions and Landmark Buildings
Name: Public Attractions and Landmark Buildings
Domains:
Templates:
• Name: Public Attractions and Landmark Buildings
  Description:
  Prototype:
  AddressClassCodeDesc: Public Attractions and Landmark Buildings
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Transporation Facilities
Name: Transporation Facilities
Domains:
Templates:
• Name: Transporation Facilities
  Description:
  Prototype:
  AddressClassCodeDesc: Transporation Facilities
  OldAddress: null
  ObjectID: null
  Address: null
  HouseNo: null
  UnitType: null
  UnitID: null
  RoadName: null
  City: null
  State: null
  ZipCode: null
  Status: null
  ParcelNo: null
  ProposedParcelNo: null
  AddressClassCode: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata