View In:   ArcGIS Online Map Viewer

Name: Stormwater Line

Display Field: creator

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 3fb56ee14b954fdd8e39168329c93b12

Copyright Text:

Default Visibility: false

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: 2411175.51506133
YMin: 1451963.4294360727
XMax: 2467190.9738963284
YMax: 1519175.138844408
Spatial Reference: 103038  (6457)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assetgroup
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: 4
  Label: Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: 5
  Label: Open Channel
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: 6
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: 7
  Label: Linear Drain
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: assetgroup

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: false, defaultValue: 0, modelName: assetgroup, required: true )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: 0, modelName: assettype, required: true )
• pipeshape ( type: esriFieldTypeSmallInteger, alias: Culvert Shape, Pipe Shape, editable: true, nullable: true, defaultValue: null, modelName: pipeshape )
• diameter ( type: esriFieldTypeDouble, alias: Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: diameter )
• width ( type: esriFieldTypeDouble, alias: Width (in), editable: true, nullable: true, defaultValue: null, modelName: width )
• height ( type: esriFieldTypeDouble, alias: Height (in), editable: true, nullable: true, defaultValue: null, modelName: height )
• material ( type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: material )
• us_structure ( type: esriFieldTypeString, alias: US Structure ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_structure )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: upelev )
• ds_structure ( type: esriFieldTypeString, alias: DS Structure ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_structure )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: downelev )
• slope ( type: esriFieldTypeDouble, alias: Slope (%), editable: true, nullable: true, defaultValue: null, modelName: slope )
• measuredlength ( type: esriFieldTypeDouble, alias: Measured Length (ft), editable: true, nullable: true, defaultValue: null, modelName: measuredlength )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• surveydate ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: surveydate )
• inspected ( type: esriFieldTypeSmallInteger, alias: inspected, editable: true, nullable: true, defaultValue: 0, modelName: inspected , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspectdate )
• pacp_score ( type: esriFieldTypeDouble, alias: PACP Score, editable: true, nullable: true, defaultValue: null, modelName: pacp_score )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: 0, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 8, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• lined ( type: esriFieldTypeSmallInteger, alias: Lined?, editable: true, nullable: true, defaultValue: null, modelName: lined )
• lineryear ( type: esriFieldTypeSmallInteger, alias: Liner Year, editable: true, nullable: true, defaultValue: null, modelName: lineryear )
• linermethod ( type: esriFieldTypeSmallInteger, alias: Liner Method, editable: true, nullable: true, defaultValue: null, modelName: linermethod )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• wall ( type: esriFieldTypeSmallInteger, alias: Wall (Y/N), editable: true, nullable: true, defaultValue: null, modelName: wall )
• CMT_CAD_GIS ( type: esriFieldTypeSmallInteger, alias: CMT_CAD_GIS, editable: true, nullable: true, defaultValue: null, modelName: CMT_CAD_GIS , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• derived_year ( type: esriFieldTypeString, alias: Derived Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: derived_year )
• sw_system ( type: esriFieldTypeSmallInteger, alias: SW System, editable: true, nullable: true, defaultValue: null, modelName: sw_system , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
• isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: true, nullable: false, defaultValue: 2, modelName: isconnected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: true, nullable: true, defaultValue: 6, modelName: validationstatus , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• globalid ( type: esriFieldTypeGUID, alias: Global ID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: globalid )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: creationdate )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: creator )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: lastupdate )
• updatedby ( type: esriFieldTypeString, alias: Updated by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: updatedby )
• Shape__Length ( type: esriFieldTypeDouble, alias: shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: shape.STLength(), required: true )
• LoFPACP ( type: esriFieldTypeSingle, alias: LoFPACP, editable: true, nullable: true, defaultValue: null, modelName: LoFPACP )
• InspectionID ( type: esriFieldTypeInteger, alias: InspectionID, editable: true, nullable: true, defaultValue: null, modelName: InspectionID )
• cmt_proxy_year ( type: esriFieldTypeDate, alias: CMT Proxy Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cmt_proxy_year )
• near_address ( type: esriFieldTypeString, alias: near_address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: near_address )
• StreetID ( type: esriFieldTypeString, alias: Street ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetID )
• FOTH_DRAC_GIS ( type: esriFieldTypeSmallInteger, alias: FOTH_DRAC_GIS, editable: true, nullable: true, defaultValue: null, modelName: FOTH_DRAC_GIS , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_WORST_H_RMS ( type: esriFieldTypeDouble, alias: Worst Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_WORST_H_RMS )
• ESRIGNSS_WORST_V_RMS ( type: esriFieldTypeDouble, alias: Worst Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_WORST_V_RMS )
• ESRIGNSS_WORST_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Worst Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_WORST_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_MANUAL_LOCATIONS ( type: esriFieldTypeInteger, alias: Number of Manual Locations, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_MANUAL_LOCATIONS )

Types:

ID: 0
Name: Unknown
Domains:
• assettype:
  Coded Values: [0: Unknown]
• inspected:
  Inherited
• CMT_CAD_GIS:
  Inherited
• sw_system:
  Inherited
• isconnected:
  Inherited
• validationstatus:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  assetid: null
  ESRIGNSS_WORST_FIXTYPE: null
  assetgroup: 0
  assettype: 0
  pipeshape: null
  diameter: null
  width: null
  height: null
  material: null
  us_structure: null
  upelev: null
  ds_structure: null
  downelev: null
  slope: null
  measuredlength: null
  installdate: null
  surveydate: null
  inspected: 0
  inspectdate: null
  pacp_score: null
  notes: null
  spatialsource: null
  lifecyclestatus: 0
  lined: null
  lineryear: null
  linermethod: null
  ownedby: null
  maintby: null
  wall: null
  CMT_CAD_GIS: null
  derived_year: null
  sw_system: null
  isconnected: 2
  validationstatus: 6
  ESRIGNSS_MANUAL_LOCATIONS: null
  globalid: {00000000-0000-0000-0000-000000000000}
  ESRIGNSS_WORST_H_RMS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_WORST_V_RMS: null
  LoFPACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  StreetID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Pipe
Domains:
• assettype:
  Coded Values: [0: Unknown] , [3: Gravity Pipe] , [4: Force Pipe] , ...2 more...
• pipeshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...32 more...
• material:
  Coded Values: [3: Asphalt - ASP] , [13: Galvanized Pipe - GP] , [14: Glass Reinforced Cement - GRC] , ...25 more...
• inspected:
  Inherited
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lineryear:
  Range: [1800, 2060]
• linermethod:
  Coded Values: [0: Not Known] , [1: Cured-In-Place Pipe] , [2: Fold and Form or Deform/Reform] , ...11 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• CMT_CAD_GIS:
  Inherited
• sw_system:
  Inherited
• isconnected:
  Inherited
• validationstatus:
  Inherited
Templates:
• Name: Pipe
  Description:
  Prototype:
  assetid: null
  ESRIGNSS_WORST_FIXTYPE: null
  assetgroup: 4
  assettype: 0
  pipeshape: 0
  diameter: 0
  width: null
  height: null
  material: 0
  us_structure: null
  upelev: null
  ds_structure: null
  downelev: null
  slope: null
  measuredlength: null
  installdate: null
  surveydate: null
  inspected: 0
  inspectdate: null
  pacp_score: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  lined: 0
  lineryear: null
  linermethod: 0
  ownedby: 1
  maintby: 1
  wall: null
  CMT_CAD_GIS: null
  derived_year: null
  sw_system: null
  isconnected: 2
  validationstatus: 6
  ESRIGNSS_MANUAL_LOCATIONS: null
  globalid: {00000000-0000-0000-0000-000000000000}
  ESRIGNSS_WORST_H_RMS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_WORST_V_RMS: null
  LoFPACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  StreetID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Open Channel
Domains:
• assettype:
  Coded Values: [0: Unknown] , [43: Aquaduct Channel] , [44: Spillway Channel] , ...3 more...
• material:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• inspected:
  Inherited
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• CMT_CAD_GIS:
  Inherited
• sw_system:
  Inherited
• isconnected:
  Inherited
• validationstatus:
  Inherited
Templates:
• Name: Open Channel
  Description:
  Prototype:
  assetid: null
  ESRIGNSS_WORST_FIXTYPE: null
  assetgroup: 5
  assettype: 0
  pipeshape: null
  diameter: null
  width: null
  height: null
  material: 0
  us_structure: null
  upelev: null
  ds_structure: null
  downelev: null
  slope: null
  measuredlength: null
  installdate: null
  surveydate: null
  inspected: 0
  inspectdate: null
  pacp_score: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  lined: null
  lineryear: null
  linermethod: null
  ownedby: 1
  maintby: 1
  wall: null
  CMT_CAD_GIS: null
  derived_year: null
  sw_system: null
  isconnected: 2
  validationstatus: 6
  ESRIGNSS_MANUAL_LOCATIONS: null
  globalid: {00000000-0000-0000-0000-000000000000}
  ESRIGNSS_WORST_H_RMS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_WORST_V_RMS: null
  LoFPACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  StreetID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: Culvert
Domains:
• assettype:
  Coded Values: [0: Unknown] , [81: Pipe Culvert] , [82: Pipe Arch] , ...3 more...
• pipeshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...32 more...
• material:
  Coded Values: [3: Asphalt - ASP] , [13: Galvanized Pipe - GP] , [14: Glass Reinforced Cement - GRC] , ...25 more...
• inspected:
  Inherited
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• lined:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lineryear:
  Range: [1800, 2060]
• linermethod:
  Coded Values: [0: Not Known] , [1: Cured-In-Place Pipe] , [2: Fold and Form or Deform/Reform] , ...11 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• wall:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• CMT_CAD_GIS:
  Inherited
• sw_system:
  Inherited
• isconnected:
  Inherited
• validationstatus:
  Inherited
Templates:
• Name: Culvert
  Description:
  Prototype:
  assetid: null
  ESRIGNSS_WORST_FIXTYPE: null
  assetgroup: 6
  assettype: 0
  pipeshape: 0
  diameter: null
  width: null
  height: null
  material: 0
  us_structure: null
  upelev: null
  ds_structure: null
  downelev: null
  slope: null
  measuredlength: null
  installdate: null
  surveydate: null
  inspected: 0
  inspectdate: null
  pacp_score: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  lined: null
  lineryear: null
  linermethod: null
  ownedby: 1
  maintby: 1
  wall: 0
  CMT_CAD_GIS: null
  derived_year: null
  sw_system: null
  isconnected: 2
  validationstatus: 6
  ESRIGNSS_MANUAL_LOCATIONS: null
  globalid: {00000000-0000-0000-0000-000000000000}
  ESRIGNSS_WORST_H_RMS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_WORST_V_RMS: null
  LoFPACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  StreetID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 7
Name: Linear Drain
Domains:
• assettype:
  Coded Values: [0: Unknown] , [121: Trench Drain] , [122: Slotted Drain]
• pipeshape:
  Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...32 more...
• material:
  Coded Values: [3: Asphalt - ASP] , [13: Galvanized Pipe - GP] , [14: Glass Reinforced Cement - GRC] , ...25 more...
• inspected:
  Inherited
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• ownedby:
  Inherited
• maintby:
  Inherited
• CMT_CAD_GIS:
  Inherited
• sw_system:
  Inherited
• isconnected:
  Inherited
• validationstatus:
  Inherited
Templates:
• Name: Linear Drain
  Description:
  Prototype:
  assetid: null
  ESRIGNSS_WORST_FIXTYPE: null
  assetgroup: 7
  assettype: 0
  pipeshape: null
  diameter: 0
  width: null
  height: null
  material: 0
  us_structure: null
  upelev: null
  ds_structure: null
  downelev: null
  slope: null
  measuredlength: null
  installdate: null
  surveydate: null
  inspected: 0
  inspectdate: null
  pacp_score: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  lined: null
  lineryear: null
  linermethod: null
  ownedby: 1
  maintby: 1
  wall: null
  CMT_CAD_GIS: null
  derived_year: null
  sw_system: null
  isconnected: 2
  validationstatus: 6
  ESRIGNSS_MANUAL_LOCATIONS: null
  globalid: {00000000-0000-0000-0000-000000000000}
  ESRIGNSS_WORST_H_RMS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_WORST_V_RMS: null
  LoFPACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  StreetID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• PACP Conditions (4) -- Related To: PACP_Conditions (36)
• SDE.PACP_InspectionRatingsCombined (5) -- Related To: PACP_InspectionRatingsCombined (33)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CREATIONDATE
• Creator Field: CREATOR
• Edit Date Field: LASTUPDATE
• Editor Field: UPDATEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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