Name: Basic_Stats

Display Field: null

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4b0cb187b5a64b02ba5eb0821f534adc

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: OBJECTID, type: esriFieldTypeOID )
• statusname ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Status, type: esriFieldTypeString )
• conrreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Consultant Region Review, type: esriFieldTypeInteger )
• rreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Region Review, type: esriFieldTypeInteger )
• precreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Pre-conformity Review, type: esriFieldTypeInteger )
• ccreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Central Conformity Review, type: esriFieldTypeInteger )
• concreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Consultant Conformity Review, type: esriFieldTypeInteger )
• pocreview ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Post-conformity Review, type: esriFieldTypeInteger )
• resubdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Resubmittal, type: esriFieldTypeInteger )
• turnarounddays ( nullable: true, editable: true, defaultValue: null, alias: Turnaround Time (Days), type: esriFieldTypeInteger )
• username ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Submitter or Reviewer Name, type: esriFieldTypeString )
• designerfirm ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Designer Firm, type: esriFieldTypeString )
• regionreview ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Region Review, type: esriFieldTypeString )
• consultrevfirmname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Enter Consultant Reviewer Firm Name, type: esriFieldTypeString )
• regionno ( nullable: true, editable: true, defaultValue: null, length: 1, alias: Region, type: esriFieldTypeString )
• conformityname ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Conformity Reviewer Name, type: esriFieldTypeString )
• conformitycompanyname ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Conformity Reviewer Company Name, type: esriFieldTypeString )
• numparcels ( nullable: true, editable: true, defaultValue: null, alias: Number of Parcels, type: esriFieldTypeInteger )
• numownerships ( nullable: true, editable: true, defaultValue: null, alias: Number of Ownerships, type: esriFieldTypeInteger )
• cyear ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Calendar Year, type: esriFieldTypeString )
• py ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Performance Year, type: esriFieldTypeString )
• fy ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Fiscal Year, type: esriFieldTypeString )
• pin ( nullable: true, editable: true, defaultValue: null, length: 6, alias: PIN, type: esriFieldTypeString )
• rejection ( nullable: true, editable: true, defaultValue: null, alias: Rejection Count, type: esriFieldTypeInteger )
• submittal ( nullable: true, editable: true, defaultValue: null, alias: Submittal Count, type: esriFieldTypeInteger )
• turnaroundorg ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Submitter/Reviewer Organization, type: esriFieldTypeString )
• rejectionpercyear ( nullable: true, editable: true, defaultValue: null, alias: Rejections Per Calendar Year, type: esriFieldTypeInteger )
• submittalpercyear ( nullable: true, editable: true, defaultValue: null, alias: Submittals Per Calendar Year, type: esriFieldTypeInteger )
• submittalperfy ( nullable: true, editable: true, defaultValue: null, alias: Submittals Per Fiscal Year, type: esriFieldTypeInteger )
• averejpersubfy ( nullable: true, editable: true, defaultValue: null, alias: Average Rejections Per Submittal by Fiscal Year, type: esriFieldTypeDouble )
• rejectionperpy ( nullable: true, editable: true, defaultValue: null, alias: Rejection Per Performance Year, type: esriFieldTypeInteger )
• submittalperpy ( nullable: true, editable: true, defaultValue: null, alias: Submittals Per Performance Year, type: esriFieldTypeInteger )
• averejpersubpy ( nullable: true, editable: true, defaultValue: null, alias: Average Rejections Per Submittal by Performance Year, type: esriFieldTypeDouble )
• averejpersubcyear ( nullable: true, editable: true, defaultValue: null, alias: Average Rejections Per Submittal by Calendar Year, type: esriFieldTypeDouble )
• rejectionperfy ( nullable: true, editable: true, defaultValue: null, alias: Rejections per Fiscal Year, type: esriFieldTypeInteger )
• originalsubmittaldatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Original Submittal Date and Time, type: esriFieldTypeDate )
• summaryno ( nullable: true, editable: true, defaultValue: null, alias: Summary Number, type: esriFieldTypeInteger )
• summarytype ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Summary Type, type: esriFieldTypeString )
• summarycategory ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Summary Category, type: esriFieldTypeString )
• irr_days ( nullable: true, editable: true, defaultValue: null, alias: 1 Initial Region Review Days, type: esriFieldTypeInteger )
• irr_resub ( nullable: true, editable: true, defaultValue: null, alias: 2 Days For Initial Region Review Resubmittal, type: esriFieldTypeInteger )
• rr_days ( nullable: true, editable: true, defaultValue: null, alias: 3 Region Review Days, type: esriFieldTypeInteger )
• rr_resub ( nullable: true, editable: true, defaultValue: null, alias: 4 Days for Region Review Resubmittal, type: esriFieldTypeInteger )
• precr_days ( nullable: true, editable: true, defaultValue: null, alias: 5 Preconformity Review Days, type: esriFieldTypeInteger )
• precr_resub ( nullable: true, editable: true, defaultValue: null, alias: 6 Days for Preconformity Resubmittal, type: esriFieldTypeInteger )
• allconr_days ( nullable: true, editable: true, defaultValue: null, alias: 7 Conformity Review Days, type: esriFieldTypeInteger )
• consultconr_days ( nullable: true, editable: true, defaultValue: null, alias: 8 Consultant Conformity Review Days, type: esriFieldTypeInteger )
• udotconr_days ( nullable: true, editable: true, defaultValue: null, alias: 9 UDOT Conformity Review Days, type: esriFieldTypeInteger )
• conr_resub ( nullable: true, editable: true, defaultValue: null, alias: 10 Days for Conformity Review Resubmittal, type: esriFieldTypeInteger )
• pocr_days ( nullable: true, editable: true, defaultValue: null, alias: 11 Postconformity Days, type: esriFieldTypeInteger )
• pocr_resub ( nullable: true, editable: true, defaultValue: null, alias: 12 Days for Postconformity Resubmittal , type: esriFieldTypeInteger )
• entiresubmittal_days ( nullable: true, editable: true, defaultValue: null, alias: Total Submittal Time (Days), type: esriFieldTypeInteger )
• days_perstatus ( nullable: true, editable: true, defaultValue: null, alias: Days Spent at Each Status, type: esriFieldTypeInteger )
• daysstaus ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Status for Day Count, type: esriFieldTypeString )
• graphdaysstatus ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Status for Days Count for Graph, type: esriFieldTypeString )
• statusdatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time of Review/Resubmittal, type: esriFieldTypeDate )
• previousstatus_datetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Previous Status Date, type: esriFieldTypeDate )
• cyearstatus ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Calendar Year for Status Change Date, type: esriFieldTypeString )
• pystatus ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Performance Year of Status Change, type: esriFieldTypeString )
• fystatus ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Fiscal Year of Status Change, type: esriFieldTypeString )
• 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 )
• pymonth ( nullable: true, editable: true, defaultValue: null, length: 2, alias: Month No (PY), type: esriFieldTypeString )

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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