View In:   ArcGIS Online Map Viewer

Name: ROW_Submittal_Master_v3

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0e2320903e624dffbe52810716aca1e9

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: ROW Submittal Master v3
Description: Survey Data Locations
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: false
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: true
Supports Query With LOD Spatial Reference: true
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• projname ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Project Name, type: esriFieldTypeString )
• projno ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Project Number, type: esriFieldTypeString )
• pin ( nullable: true, editable: true, defaultValue: null, length: 7, alias: PIN, type: esriFieldTypeString )
• summaryno ( nullable: true, editable: true, defaultValue: null, alias: Summary Number, type: esriFieldTypeInteger )
• summarytype ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Summary Type, type: esriFieldTypeString , Coded Values: [Partial: Partial] , [Final: Final] , [Supplemental: Supplemental] , ...1 more... )
• numparcels ( nullable: true, editable: true, defaultValue: null, alias: Number of Parcels, type: esriFieldTypeInteger )
• designerfirm ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Designer Firm, type: esriFieldTypeString )
• originatoremail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Your Email, type: esriFieldTypeString )
• originatorname ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Originator Name, type: esriFieldTypeString )
• regionno ( nullable: true, editable: true, defaultValue: null, length: 1, alias: Region, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• regionreview ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Region Review, type: esriFieldTypeString , Coded Values: [Region: Region] , [Consultant: Consultant] )
• consultrevfirmname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Enter Consultant Reviewer Firm Name, type: esriFieldTypeString )
• consultrevname ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Name of Consultant Reviewer, type: esriFieldTypeString )
• consultrevemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Email of Consultant Reviewer, type: esriFieldTypeString )
• carboncopy ( nullable: true, editable: true, defaultValue: null, length: 400, alias: Carbon Copy Emails, type: esriFieldTypeString )
• pmemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Project Manager Email, type: esriFieldTypeString )
• centralemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Central ROW Lead Agent Email, type: esriFieldTypeString )
• conformityemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Conformity Reviewer Email, type: esriFieldTypeString )
• pwlink ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Projectwise Link, type: esriFieldTypeString )
• subcommentsflat ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments for Submittal, type: esriFieldTypeString )
• origsubmittaldatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time of Original Submittal, type: esriFieldTypeDate )
• approvedrejectedflat ( nullable: true, editable: true, defaultValue: null, length: 8, alias: Approved or Rejected, type: esriFieldTypeString , Coded Values: [Approved: Approved] , [Upload: Upload] , [Rejected: Rejected] )
• approvcommentsflat ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Approval or Rejection Comments, type: esriFieldTypeString )
• resubcommentsflat ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments for Resubmission, type: esriFieldTypeString )
• status ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Status, type: esriFieldTypeString , Coded Values: [Acquisition: Acquisition] , [Consultant Submitted, Initial Region Review: Consultant Submitted, Initial Region Review] , [Consultant Re-submitted, Conformity Review: Consultant Re-submitted, Conformity Review] , ...18 more... )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• preconformityemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Pre-conformity Reviewer Email Address, type: esriFieldTypeString )
• postconformityemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Post-conformity Reviewer Email Address, type: esriFieldTypeString )
• reviewlink ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Link to Review Page, type: esriFieldTypeString )
• numownerships ( nullable: true, editable: true, defaultValue: null, alias: Number of Ownerships, type: esriFieldTypeInteger )
• daysincelaststatuschg ( nullable: true, editable: true, defaultValue: null, alias: Days Since Sent to You, type: esriFieldTypeInteger )
• lststatuschgdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Status Change Date, type: esriFieldTypeDate )
• completesumlink ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Link to Complete Summary in ProjectWise, type: esriFieldTypeString )
• conformrevlink ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Link to Assign Conformity Reviewer, type: esriFieldTypeString )
• rejectionreason ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Reason for Rejection, type: esriFieldTypeString )
• regionemail ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: Region Reviewer's Email Address, type: esriFieldTypeString )
• toemail ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: Receiver Email, type: esriFieldTypeString )
• resublink ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Resubmittal Link, type: esriFieldTypeString )

Templates:

• Name: New Feature
  Description:
  Prototype:
  daysincelaststatuschg: null
  rejectionreason: null
  numownerships: null
  reviewlink: null
  completesumlink: null
  regionemail: null
  preconformityemail: null
  conformrevlink: null
  postconformityemail: null
  lststatuschgdate: null
  toemail: null
  
  Drawing Tool: N/A

Relationships:

• ROW_Submittal_Master_v3_approvals (0) -- Related To: approvals (1)
• ROW_Submittal_Master_v3_resubmissions (1) -- Related To: resubmissions (2)
• ROW_Submittal_Master_v3_statustrack (2) -- Related To: statustrack (3)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata