View In:   ArcGIS Online Map Viewer

Name: DPW.DBO.SWNETG

Display Field: NTG_USMAN

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 3ee05d26c7e248e2a5eff266ea4ec50c

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: -115860600
YMin: -93269500
XMax: 6193576.72481972
YMax: 1884303.12344356
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 98, 143, 255]
Width: 1
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

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 )
• NTG_FTYP_CD ( type: esriFieldTypeInteger, alias: From End Type, editable: true, nullable: true, defaultValue: null, modelName: NTG_FTYP_CD , Coded Values: [1: Structure] , [2: Pump Station] , [3: Node] , ...2 more... )
• NTG_TTYP_CD ( type: esriFieldTypeInteger, alias: To End Type, editable: true, nullable: true, defaultValue: null, modelName: NTG_TTYP_CD , Coded Values: [1: Structure] , [2: Pump Station] , [3: Node] , ...2 more... )
• NTG_USMAN ( type: esriFieldTypeString, alias: US Manhole, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NTG_USMAN )
• NTG_DSMAN ( type: esriFieldTypeString, alias: DS Manhole, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NTG_DSMAN )
• NTG_STAT_CD ( type: esriFieldTypeSmallInteger, alias: Pipe Status, editable: true, nullable: true, defaultValue: null, modelName: NTG_STAT_CD , Coded Values: [0: N/A] , [1: Abandoned] , [2: Approved] , ...3 more... )
• NTG_LINE_CD ( type: esriFieldTypeInteger, alias: Line Type, editable: true, nullable: true, defaultValue: null, modelName: NTG_LINE_CD , Coded Values: [1: Force Main] , [2: Gravity Main] , [3: Recycled Water Main] , ...1 more... )
• NTG_FLOW_CD ( type: esriFieldTypeInteger, alias: Flow Type (-1), editable: true, nullable: true, defaultValue: null, modelName: NTG_FLOW_CD )
• NTG_DIA ( type: esriFieldTypeSmallInteger, alias: Pipe Diameter, editable: true, nullable: true, defaultValue: null, modelName: NTG_DIA )
• NTG_MAT_CD ( type: esriFieldTypeInteger, alias: Pipe Material, editable: true, nullable: true, defaultValue: null, modelName: NTG_MAT_CD , Coded Values: [1: XXX-Not Known] , [2: AC-Asbestos Cement] , [3: DIP-Ductile Iron] , ...16 more... )
• NTG_USINV ( type: esriFieldTypeDouble, alias: NTG_USINV, editable: true, nullable: true, defaultValue: null, modelName: NTG_USINV )
• NTG_DSINV ( type: esriFieldTypeDouble, alias: NTG_DSINV, editable: true, nullable: true, defaultValue: null, modelName: NTG_DSINV )
• NTG_SLOPE ( type: esriFieldTypeDouble, alias: Pipe Slope %, editable: true, nullable: true, defaultValue: null, modelName: NTG_SLOPE )
• NTG_SHAP_CD ( type: esriFieldTypeSmallInteger, alias: Pipe Shape, editable: true, nullable: true, defaultValue: null, modelName: NTG_SHAP_CD , Coded Values: [0: Unknown] , [1: Round] , [2: Elliptical] , ...11 more... )
• NTG_NUMBER ( type: esriFieldTypeString, alias: Alt Pipe ID, editable: true, nullable: true, length: 75, defaultValue: null, modelName: NTG_NUMBER )
• NTG_OWN_CD ( type: esriFieldTypeInteger, alias: District, editable: true, nullable: true, defaultValue: null, modelName: NTG_OWN_CD , Coded Values: [1: BOULDER CREEK] , [2: DAVENPORT] , [3: FREEDOM] , ...9 more... )
• NTG_ID ( type: esriFieldTypeInteger, alias: Pipe Rec ID, editable: true, nullable: true, defaultValue: null, modelName: NTG_ID )
• NTG_BASIN ( type: esriFieldTypeString, alias: Basin, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NTG_BASIN )
• NTG_SEQNO ( type: esriFieldTypeDouble, alias: Pipe Seq Num, editable: true, nullable: true, defaultValue: null, modelName: NTG_SEQNO )
• NTG_USER1CD ( type: esriFieldTypeSmallInteger, alias: Flush Schedule, editable: true, nullable: true, defaultValue: null, modelName: NTG_USER1CD , Coded Values: [30: Every 30] , [60: Every 60] , [90: Every 90] , ...3 more... )
• GNET_TVINSP ( type: esriFieldTypeString, alias: GNET_TVINSP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GNET_TVINSP )
• GNET_SHAPE ( type: esriFieldTypeString, alias: GNET_SHAPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GNET_SHAPE , Coded Values: [A: Arched w/ Flate Bottom] , [B: Barrel] , [C: Circular] , ...8 more... )
• GNET_MATRL ( type: esriFieldTypeString, alias: GNET_MATRL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GNET_MATRL , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...23 more... )
• GNET_LOCATION ( type: esriFieldTypeString, alias: GNET_LOCATION, editable: true, nullable: true, length: 75, defaultValue: null, modelName: GNET_LOCATION )
• GENT_OWNER ( type: esriFieldTypeString, alias: GENT_OWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GENT_OWNER )
• ZERO_VAL ( type: esriFieldTypeDouble, alias: ZERO_VAL, editable: true, nullable: true, defaultValue: 0, modelName: ZERO_VAL )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• NTG_LINEYR ( type: esriFieldTypeDate, alias: NTG_LINEYR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NTG_LINEYR )
• NTG_PROJ_NO ( type: esriFieldTypeString, alias: NTG_PROJ_NO, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NTG_PROJ_NO )
• NTG_INSP_DT ( type: esriFieldTypeDate, alias: NTG_INSP_DT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NTG_INSP_DT )

Templates:

• Name: DPW.DBO.SWNETG
  Description:
  Prototype:
  NTG_PROJ_NO: null
  NTG_INSP_DT: null
  NTG_FTYP_CD: null
  NTG_TTYP_CD: null
  NTG_USMAN: null
  NTG_DSMAN: null
  NTG_STAT_CD: null
  NTG_LINE_CD: null
  NTG_FLOW_CD: null
  NTG_DIA: null
  NTG_MAT_CD: null
  NTG_USINV: null
  NTG_DSINV: null
  NTG_SLOPE: null
  NTG_SHAP_CD: null
  NTG_NUMBER: null
  NTG_OWN_CD: null
  NTG_ID: null
  NTG_BASIN: null
  NTG_SEQNO: null
  NTG_USER1CD: null
  GNET_TVINSP: null
  GNET_SHAPE: null
  GNET_MATRL: null
  GNET_LOCATION: null
  GENT_OWNER: null
  ZERO_VAL: 0
  NTG_LINEYR: null
  Notes: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

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