Name: x_MowingAreaCurrentBid_INSPECTION

Display Field: Status

Type: Table

Geometry Type: N/A

Description: This data is entered and edited through the Mowing Inspection Dashboard. Information from this table is joined with the x_MowingAreaCurrentBid feature class and x_MowingAreaCurrentBid_ContractorCompletion_vw to create the x_MowingAreaCurrentBid_Contractor_Inspection_vw. Inspections are joined to the mowing area polygon based on FacilityID and to the contractor completion entries based on GlobalID/ParentGUID.

Service Item Id: 288eddca4ba44a68873af9cbe1a49567

Copyright Text: City of Johnson City, TN Peggi Ward (Public Works GIS) Ellen Lester (IT GIS)

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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 Result Pagination Token: false
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: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• Status ( nullable: true, length: 255, alias: Status, type: esriFieldTypeString , Coded Values: [Passed: Passed] , [Failed: Failed] , [Pending: Pending] )
• Comments ( nullable: true, length: 255, alias: Comments, type: esriFieldTypeString )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• ParentGUID ( nullable: true, length: 38, alias: ParentGUID, type: esriFieldTypeGUID )
• AttachmentGUID ( nullable: true, length: 38, alias: AttachmentGUID, type: esriFieldTypeGUID )
• MowingZone ( nullable: true, length: 10, alias: MowingZone, type: esriFieldTypeString )
• FacilityID ( nullable: true, length: 20, alias: FacilityID, type: esriFieldTypeString )
• GeneralLocation ( nullable: true, length: 255, alias: General Location, type: esriFieldTypeString )
• Category ( nullable: true, length: 20, alias: Category, type: esriFieldTypeString )
• DetailedLocation ( nullable: true, length: 255, alias: Detailed Location, type: esriFieldTypeString )
• WorkDescription ( nullable: true, length: 255, alias: WorkDescription, type: esriFieldTypeString )
• MowedArea ( nullable: true, length: 20, alias: Mowed Area (Acres), type: esriFieldTypeString )
• PenaltyFee ( nullable: true, length: 20, alias: PenaltyFee, type: esriFieldTypeString )
• ContractorCompletionDate ( nullable: true, length: 8, alias: Contractor Completion Date, type: esriFieldTypeDate )
• DateInspected ( nullable: true, length: 8, alias: Date Inspected, type: esriFieldTypeDate )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata