Name: sdStructure

Display Field: FacilityName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: In 2010 the City of Richland Public Works used esri data models to create four unique file geodatabases, water, sewer, storm, and irrigation, to move its data from AutoCAD to esri. After choosing esri data models changes were made with input from the different departments within public works. When the four Geodatabase were satafactory, vector data from AutoCAD was imported into the respective database and cleaned up. Then the geodatabases were put in an ArcSDE database each database creating two datasets, one for Networked features classes and one for nonNetworked feature classes. Since the Conversion there are five different degrees of accuracy that are stored in a field "DataCollection". 'LEGACY' means data came from an unknown origin 'OTHER' means data came from hand drawings or construction drawings 'ASBUILT' means data came from either a georefernced tif with a RMS no more than 0.5 or a CAD drawing'HANDHELD' means data came from a GNSS RTK handheld 'SURVEYED' means the data came from the City Of Richland Survey Department

Service Item Id: 2b0fe3705e6b41b79dcbb82ffa9ada05

Copyright Text: Conversion from AutoCAD to ESRI was done by richard allen and todd locati

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1932176.0625
YMin: 317537.63787841797
XMax: 1965391.0747070312
YMax: 373551.62829589844
Spatial Reference: 102749  (2286)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Subtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [218, 198, 245, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Default Label:
UniqueValueInfos:
• Value: 3
  Label: BiofilterArea
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [201, 242, 208, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 4
  Label: CheckDam
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [205, 233, 247, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 1
  Label: Ditch
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [238, 205, 247, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 7
  Label: Oil/Water Separator
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [206, 191, 242, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 2
  Label: Pond
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [247, 242, 210, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 6
  Label: RipRapPad
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [252, 214, 197, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 5
  Label: Swale
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [203, 210, 247, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 9
  Label: Infiltration Trench
  Description: N/A
  Symbol:
  Style: esriSFSDiagonalCross
  Color: [255, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 0
• Value: 10
  Label: Underdrain
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 92, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 689.4984780237937
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: 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: Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, length: 255 )
• Subtype ( type: esriFieldTypeInteger, alias: Subtype )
• BasinID ( type: esriFieldTypeString, alias: BasinID, length: 7 , Coded Values: [AA: AA] , [AB: AB] , [AC: AC] , ...51 more... )
• DataCollection ( type: esriFieldTypeString, alias: How was the Data Collected, length: 10 , Coded Values: [ASBUILT: As-Builts] , [OTHER: Construction Drawings/Field Notes] , [LEGACY: Data from AutoCAD Conversion (2011 & Older)] , ...4 more... )
• Maintenance ( type: esriFieldTypeSmallInteger, alias: Maintenance , Coded Values: [0: City] , [1: Private] , [2: County] , ...1 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 10 , Coded Values: [COR: City Of Richland] , [COE: Corps Of Engineers] , [POB: Port Of Benton] , ...12 more... )
• Project ( type: esriFieldTypeString, alias: Project, length: 255 , Coded Values: [87: 1020 Battelle Blvd - Cannon Hill (I3-017)] , [66: 1020 GW WAY (D4-230)] , [150: 1038 Columbia Park Trail Ben Franklin Transit (A6-087)] , ...803 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• AsBuilt1 ( type: esriFieldTypeString, alias: AsBuilt1, length: 6 )
• AsBuilt2 ( type: esriFieldTypeString, alias: AsBuilt2, length: 6 )
• PW_GIS_Notes ( type: esriFieldTypeString, alias: PW GIS Notes, length: 255 )
• Status ( type: esriFieldTypeSmallInteger, alias: QA Status , Coded Values: [0: NoDraw] , [1: Draw] , [2: Checked 4 Ownership] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• weather ( type: esriFieldTypeSmallInteger, alias: weather )
• Jetted ( type: esriFieldTypeDate, alias: Jetted, length: 8 )
• user_ ( type: esriFieldTypeString, alias: user_, length: 50 )
• WorkType ( type: esriFieldTypeString, alias: WorkType, length: 50 , Coded Values: [Scheduled PM: Scheduled PM] , [Unscheduled PM: Unscheduled PM] , [Sewer Call: Sewer Call] )
• WorkOrder ( type: esriFieldTypeString, alias: WorkOrder, length: 25 )
• WorkNotes ( type: esriFieldTypeString, alias: WorkNotes, length: 254 )
• ProjectType ( type: esriFieldTypeString, alias: ProjectType, length: 25 , Coded Values: [Regular Nozzle: Regular Nozzle] , [WartHog: WartHog] , [Portable TV: Portable TV] , ...30 more... )
• recnum ( type: esriFieldTypeInteger, alias: recnum )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...2 more... )
• Edit_User ( type: esriFieldTypeString, alias: Last Person to Edit Feature, length: 255 )
• Create_User ( type: esriFieldTypeString, alias: Person who Created Feature, length: 255 )
• Edit_Date ( type: esriFieldTypeDate, alias: Last Date the Feature was Edited, length: 8 )
• Create_Date ( type: esriFieldTypeDate, alias: Date the Feature was Created, length: 8 )

Types:

ID: 4
Name: CheckDam
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 3
Name: BiofilterArea
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 6
Name: RipRapPad
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 1
Name: Ditch
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 5
Name: Swale
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 2
Name: Pond
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 7
Name: Oil/Water Separator
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 8
Name: Storm Water Treatment Unit
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 9
Name: Infiltration Trench
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• LifecycleStatus:
  Inherited

---

ID: 10
Name: Underdrain
Domains:
• BasinID:
  Inherited
• DataCollection:
  Inherited
• Maintenance:
  Inherited
• Owner:
  Inherited
• Project:
  Inherited
• Status:
  Inherited
• WorkType:
  Inherited
• ProjectType:
  Inherited
• LifecycleStatus:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata