View In:   ArcGIS Online Map Viewer

Name: Culverts

Display Field: rcrdPln

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: -8181436.873558573
YMin: 5058992.539743266
XMax: -7785790.538411198
YMax: 5293246.694409004
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [39, 0, 148, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• culvShape ( type: esriFieldTypeDouble, alias: Culvert Shape, editable: true, nullable: true, defaultValue: null, modelName: culvShape , Coded Values: [1: Round Culvert] , [2: Pipe Arch/Elliptical Culvert] , [3: Open Bottom Arch Bridge/culvert] , ...5 more... )
• culvMtl ( type: esriFieldTypeDouble, alias: Culvert Material, editable: true, nullable: true, defaultValue: null, modelName: culvMtl , Coded Values: [1: Reinforced Concrete] , [2: Granite] , [3: Corrugated Metal] , ...10 more... )
• numBarrels ( type: esriFieldTypeDouble, alias: numBarrels, editable: true, nullable: true, defaultValue: 1, modelName: numBarrels )
• barrelSymtry ( type: esriFieldTypeDouble, alias: Are barrels symmetrical?, editable: true, nullable: true, defaultValue: 3, modelName: barrelSymtry , Coded Values: [1: Yes] , [2: No] , [3: N/A] )
• height ( type: esriFieldTypeDouble, alias: Culvert Height (IN), editable: true, nullable: true, defaultValue: null, modelName: height )
• width ( type: esriFieldTypeDouble, alias: Culvert Opening Width (IN), editable: true, nullable: true, defaultValue: null, modelName: width )
• length ( type: esriFieldTypeDouble, alias: Culvert Length Opening to Opening (FT), editable: true, nullable: true, defaultValue: 0, modelName: length )
• SSP ( type: esriFieldTypeDouble, alias: Specific Stream Power (W/m3), editable: true, nullable: true, defaultValue: null, modelName: upEl )
• BANKWIDTH ( type: esriFieldTypeDouble, alias: Channel Bankfull Width (IN), editable: true, nullable: true, defaultValue: null, modelName: downEL )
• dataSource ( type: esriFieldTypeDouble, alias: Status, editable: true, nullable: true, defaultValue: 3, modelName: dataSource , Coded Values: [3: Unconfirmed] , [1: Desktop Confirmed] , [2: Field Confirmed] , ...1 more... )
• rcrdPln ( type: esriFieldTypeString, alias: Hyperlink to latest record construction plan, editable: true, nullable: true, length: 250, defaultValue: not found, modelName: rcrdPln )
• installDate ( type: esriFieldTypeDate, alias: Construction Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installDate )
• lateUpdate ( type: esriFieldTypeDate, alias: Last Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lateUpdate )
• lastEditor ( type: esriFieldTypeString, alias: lastEditor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: lastEditor )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: notes )
• naaccNum ( type: esriFieldTypeString, alias: NAACC Number, editable: true, nullable: true, length: 120, defaultValue: null, modelName: naaccNum )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ATTACH ( type: esriFieldTypeString, alias: Attachments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ATTACH )
• PERCENTBKFL ( type: esriFieldTypeDouble, alias: % Bankfull Width, editable: true, nullable: true, defaultValue: null, modelName: PERCENTBKFL )
• DRAINAREA ( type: esriFieldTypeDouble, alias: Drainage Area, editable: true, nullable: true, defaultValue: null, modelName: DRAINAREA )
• AssetID ( type: esriFieldTypeString, alias: Culvert ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: AssetID )
• ServiceStatus ( type: esriFieldTypeSmallInteger, alias: ServiceStatus, editable: true, nullable: true, defaultValue: null, modelName: ServiceStatus, required: true , Coded Values: [0: In Service] , [1: Retired] , [2: Proposed Installation] , ...1 more... )
• Street ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Street )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Owner , Coded Values: [2: City or Town accepted road] , [6: State Park or Forest] , [7: State Institutional] , ...15 more... )
• District ( type: esriFieldTypeSmallInteger, alias: District, editable: true, nullable: true, defaultValue: null, modelName: District , Coded Values: [1: District 1] , [2: District 2] , [3: District 3] , ...3 more... )
• Town ( type: esriFieldTypeSmallInteger, alias: Town, editable: true, nullable: true, defaultValue: null, modelName: Town , Coded Values: [1: Abington] , [2: Acton] , [3: Acushnet] , ...348 more... )
• Route_ID ( type: esriFieldTypeString, alias: Route_ID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Route_ID )
• St_Name ( type: esriFieldTypeString, alias: St_Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: St_Name )

Templates:

• Name: DEV_MASSDOT.DBO.Culverts
  Description:
  Prototype:
  numBarrels: 1
  width: null
  dataSource: 3
  BANKWIDTH: null
  culvMtl: null
  Route_ID: null
  culvShape: null
  barrelSymtry: 3
  height: null
  length: 0
  SSP: null
  rcrdPln: not found
  installDate: null
  lateUpdate: null
  lastEditor: null
  notes: null
  naaccNum: null
  Town: null
  District: null
  Owner: null
  Street: null
  St_Name: null
  ATTACH: null
  PERCENTBKFL: null
  DRAINAREA: null
  ServiceStatus: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• CulvertInspectionForm (0) -- Related To: Inspections (1)

Capabilities: Query,ChangeTracking

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

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata