View In:   ArcGIS Online Map Viewer

Name: sw_Pipes

Display Field: CONVEYANCEID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 8b3c2ed99fda471a962b3c519efe9fb7

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: -2854101.5908792615
YMin: 724218.6650262475
XMax: 2113627.345800519
YMax: 1098235.8284120709
Spatial Reference: 2273  (2273)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AssessmentComplete
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: No
  Label: No
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 3
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [156, 156, 156, 255]
  Width: 2
• Value: N/A
  Label: N/A
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [156, 156, 156, 255]
  Width: 2
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: AssessmentComplete

Fields:

• COLLECTDATE ( type: esriFieldTypeDate, alias: COLLECTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COLLECTDATE )
• DATASOURCE ( type: esriFieldTypeString, alias: DATASOURCE, editable: true, nullable: true, length: 254, defaultValue: MappingGrade, modelName: DATASOURCE , Coded Values: [As-Builts: As-Builts] , [Manual: Manually placed to Imagery] , [MappingGrade: GPS-Mapping Grade] , ...4 more... )
• PIPETYPE ( type: esriFieldTypeString, alias: PIPETYPE, editable: true, nullable: true, length: 100, defaultValue: Gravity, modelName: PIPETYPE , Coded Values: [Gravity: Gravity] , [Force: Force] , [Culvert: Culvert] )
• PIPEMATERIAL ( type: esriFieldTypeString, alias: PIPEMATERIAL, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PIPEMATERIAL , Coded Values: [RCP: RCP] , [CMP: CMP] , [BCCMP: BCCMP] , ...6 more... )
• PIPEDIAMETER ( type: esriFieldTypeInteger, alias: PIPEDIAMETER, editable: true, nullable: true, defaultValue: null, modelName: PIPEDIAMETER , Coded Values: [6: 6"] , [8: 8"] , [10: 10"] , ...28 more... )
• PIPEWIDTH ( type: esriFieldTypeInteger, alias: PIPEWIDTH, editable: true, nullable: true, defaultValue: null, modelName: PIPEWIDTH )
• PIPEHEIGHT ( type: esriFieldTypeInteger, alias: PIPEHEIGHT, editable: true, nullable: true, defaultValue: null, modelName: PIPEHEIGHT )
• UP_INVERT_ ( type: esriFieldTypeString, alias: UP INVERT UNRELIABLE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: UP_INVERT_ )
• DOWN_INVER ( type: esriFieldTypeString, alias: DOWN INVERT UNRELIABLE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DOWN_INVER )
• UP_SV_PT_LOC ( type: esriFieldTypeString, alias: UPEND SURVEY PT LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: UP_SV_PT_LOC , Coded Values: [Center of Ditch: Center of Ditch] , [Grate: Grate] , [Invert: Invert] , ...8 more... )
• DN_SV_PT_LOC ( type: esriFieldTypeString, alias: DOWNEND SURVEY PT LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DN_SV_PT_LOC , Coded Values: [Center of Ditch: Center of Ditch] , [Grate: Grate] , [Invert: Invert] , ...8 more... )
• UPINVERTOFFSET ( type: esriFieldTypeDouble, alias: UPINVERTOFFSET, editable: true, nullable: true, defaultValue: null, modelName: UPINVERTOFFSET )
• DOWNINVERTOFFSET ( type: esriFieldTypeDouble, alias: DOWNINVERTOFFSET, editable: true, nullable: true, defaultValue: null, modelName: DOWNINVERTOFFSET )
• PIPESHAPE ( type: esriFieldTypeString, alias: PIPESHAPE, editable: true, nullable: true, length: 100, defaultValue: Circular, modelName: PIPESHAPE , Coded Values: [Circular: Circular] , [Rectangular: Rectangular] , [Elliptical: Elliptical] , ...2 more... )
• USSTNDRDCOMM ( type: esriFieldTypeString, alias: USSTNDRDCOMM, editable: true, nullable: false, length: 255, defaultValue: US No Comments, modelName: USSTNDRDCOMM , Coded Values: [US Virtual Junction: Virtual Junction] , [US Under Construction: Under Construction] , [US Unable to Open: Unable to Open] , ...24 more... )
• DSSTNDRDCOMM ( type: esriFieldTypeString, alias: DSSTNDRDCOMM, editable: true, nullable: false, length: 255, defaultValue: DS No Comments, modelName: DSSTNDRDCOMM , Coded Values: [DS Abandoned: Abandoned] , [DS Access Issue: Access Issue] , [DS Blind Junction: Blind Junction] , ...24 more... )
• AssessmentComplete ( type: esriFieldTypeString, alias: AssessmentComplete, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AssessmentComplete , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CONVEYANCEID ( type: esriFieldTypeInteger, alias: CONVEYANCEID, editable: true, nullable: true, defaultValue: null, modelName: CONVEYANCEID )
• UPNODEID ( type: esriFieldTypeInteger, alias: UPNODEID, editable: true, nullable: true, defaultValue: null, modelName: UPNODEID )
• DOWNNODEID ( type: esriFieldTypeInteger, alias: DOWNNODEID, editable: true, nullable: true, defaultValue: null, modelName: DOWNNODEID )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NOTES )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 100, defaultValue: County, modelName: OWNER , Coded Values: [State: State] , [Private: Private] , [County: County] , ...1 more... )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, editable: true, nullable: true, length: 50, defaultValue: Secondary, modelName: CATEGORY , Coded Values: [Primary: Primary] , [Secondary: Secondary] )
• UPELEV ( type: esriFieldTypeDouble, alias: UPELEV, editable: true, nullable: true, defaultValue: -9999, modelName: UPELEV )
• DOWNELEV ( type: esriFieldTypeDouble, alias: DOWNELEV, editable: true, nullable: true, defaultValue: -9999, modelName: DOWNELEV )
• UPINVERTELEV ( type: esriFieldTypeDouble, alias: UPINVERTELEV, editable: true, nullable: true, defaultValue: -9999, modelName: UPINVERTELEV )
• DOWNINVERTELEV ( type: esriFieldTypeDouble, alias: DOWNINVERTELEV, editable: true, nullable: true, defaultValue: -9999, modelName: DOWNINVERTELEV )
• LINERYEAR ( type: esriFieldTypeInteger, alias: LINERYEAR, editable: true, nullable: true, defaultValue: null, modelName: LINERYEAR )
• LINERTYPE ( type: esriFieldTypeString, alias: LINERTYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LINERTYPE , Coded Values: [CIPP: CIPP] , [CCCP: CCCP] , [Spiral PVC: Spiral PVC] , ...3 more... )
• INSTALLYEAR ( type: esriFieldTypeInteger, alias: INSTALLYEAR, editable: true, nullable: true, defaultValue: null, modelName: INSTALLYEAR )
• PUD ( type: esriFieldTypeString, alias: PUD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUD )
• UP_NORTHING ( type: esriFieldTypeDouble, alias: UPSTREAM END NORTHING, editable: true, nullable: true, defaultValue: null, modelName: UP_NORTHING )
• UP_EASTING ( type: esriFieldTypeDouble, alias: UPSTREAM END EASTING, editable: true, nullable: true, defaultValue: null, modelName: UP_EASTING )
• DN_NORTHING ( type: esriFieldTypeDouble, alias: DOWNSTREAM END NORTHING, editable: true, nullable: true, defaultValue: null, modelName: DN_NORTHING )
• DN_EASTING ( type: esriFieldTypeDouble, alias: DOWNSTREAM END EASTING, editable: true, nullable: true, defaultValue: null, modelName: DN_EASTING )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERSHIP )
• LEGACYID ( type: esriFieldTypeInteger, alias: LEGACYID, editable: true, nullable: true, defaultValue: null, modelName: LEGACYID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• CONVEYANCETYPE ( type: esriFieldTypeString, alias: CONVEYANCETYPE, editable: true, nullable: true, length: 50, defaultValue: PIPE, modelName: CONVEYANCETYPE )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, required: true, nullable: true, defaultValue: null, modelName: Shape.STLength() )

Types:

ID: No
Name: No
Domains:
• DATASOURCE:
  Inherited
• PIPETYPE:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPEDIAMETER:
  Inherited
• UP_SV_PT_LOC:
  Inherited
• DN_SV_PT_LOC:
  Inherited
• PIPESHAPE:
  Inherited
• USSTNDRDCOMM:
  Inherited
• DSSTNDRDCOMM:
  Inherited
• AssessmentComplete:
  Inherited
• OWNER:
  Inherited
• CATEGORY:
  Inherited
• LINERTYPE:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  COMMENTS: null
  DSSTNDRDCOMM: DS No Comments
  OWNER: County
  COLLECTDATE: null
  DOWNINVERTOFFSET: null
  DATASOURCE: MappingGrade
  DN_EASTING: null
  LEGACYID: null
  PIPESHAPE: Circular
  USSTNDRDCOMM: US No Comments
  CONVEYANCETYPE: PIPE
  PIPETYPE: Gravity
  PIPEMATERIAL: null
  PIPEDIAMETER: null
  PIPEWIDTH: null
  PIPEHEIGHT: null
  UP_INVERT_: null
  DOWN_INVER: null
  UP_SV_PT_LOC: null
  DN_SV_PT_LOC: null
  UPINVERTOFFSET: null
  AssessmentComplete: No
  CONVEYANCEID: null
  UPNODEID: null
  DOWNNODEID: null
  CATEGORY: Secondary
  UPELEV: -9999
  DOWNELEV: -9999
  UPINVERTELEV: -9999
  DOWNINVERTELEV: -9999
  LINERYEAR: null
  LINERTYPE: null
  INSTALLYEAR: null
  PUD: null
  UP_NORTHING: null
  UP_EASTING: null
  DN_NORTHING: null
  Enabled: 1
  OWNERSHIP: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Yes
Name: Yes
Domains:
• DATASOURCE:
  Inherited
• PIPETYPE:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPEDIAMETER:
  Inherited
• UP_SV_PT_LOC:
  Inherited
• DN_SV_PT_LOC:
  Inherited
• PIPESHAPE:
  Inherited
• USSTNDRDCOMM:
  Inherited
• DSSTNDRDCOMM:
  Inherited
• AssessmentComplete:
  Inherited
• OWNER:
  Inherited
• CATEGORY:
  Inherited
• LINERTYPE:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  COMMENTS: null
  DSSTNDRDCOMM: DS No Comments
  OWNER: County
  COLLECTDATE: null
  DOWNINVERTOFFSET: null
  DATASOURCE: MappingGrade
  DN_EASTING: null
  LEGACYID: null
  PIPESHAPE: Circular
  USSTNDRDCOMM: US No Comments
  CONVEYANCETYPE: PIPE
  PIPETYPE: Gravity
  PIPEMATERIAL: null
  PIPEDIAMETER: null
  PIPEWIDTH: null
  PIPEHEIGHT: null
  UP_INVERT_: null
  DOWN_INVER: null
  UP_SV_PT_LOC: null
  DN_SV_PT_LOC: null
  UPINVERTOFFSET: null
  AssessmentComplete: Yes
  CONVEYANCEID: null
  UPNODEID: null
  DOWNNODEID: null
  CATEGORY: Secondary
  UPELEV: -9999
  DOWNELEV: -9999
  UPINVERTELEV: -9999
  DOWNINVERTELEV: -9999
  LINERYEAR: null
  LINERTYPE: null
  INSTALLYEAR: null
  PUD: null
  UP_NORTHING: null
  UP_EASTING: null
  DN_NORTHING: null
  Enabled: 1
  OWNERSHIP: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: N/A
Name: N/A
Domains:
• DATASOURCE:
  Inherited
• PIPETYPE:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPEDIAMETER:
  Inherited
• UP_SV_PT_LOC:
  Inherited
• DN_SV_PT_LOC:
  Inherited
• PIPESHAPE:
  Inherited
• USSTNDRDCOMM:
  Inherited
• DSSTNDRDCOMM:
  Inherited
• AssessmentComplete:
  Inherited
• OWNER:
  Inherited
• CATEGORY:
  Inherited
• LINERTYPE:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: N/A
  Description:
  Prototype:
  COMMENTS: null
  DSSTNDRDCOMM: DS No Comments
  OWNER: County
  COLLECTDATE: null
  DOWNINVERTOFFSET: null
  DATASOURCE: MappingGrade
  DN_EASTING: null
  LEGACYID: null
  PIPESHAPE: Circular
  USSTNDRDCOMM: US No Comments
  CONVEYANCETYPE: PIPE
  PIPETYPE: Gravity
  PIPEMATERIAL: null
  PIPEDIAMETER: null
  PIPEWIDTH: null
  PIPEHEIGHT: null
  UP_INVERT_: null
  DOWN_INVER: null
  UP_SV_PT_LOC: null
  DN_SV_PT_LOC: null
  UPINVERTOFFSET: null
  AssessmentComplete: N/A
  CONVEYANCEID: null
  UPNODEID: null
  DOWNNODEID: null
  CATEGORY: Secondary
  UPELEV: -9999
  DOWNELEV: -9999
  UPINVERTELEV: -9999
  DOWNINVERTELEV: -9999
  LINERYEAR: null
  LINERTYPE: null
  INSTALLYEAR: null
  PUD: null
  UP_NORTHING: null
  UP_EASTING: null
  DN_NORTHING: null
  Enabled: 1
  OWNERSHIP: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• sw_Pipes_ConditionAssessment (8) -- Related To: sw_Pipes_ConditionAssessment (17)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata