View In:   ArcGIS Online Map Viewer

Name: No Contractor Out For Bid Maintenance

Display Field: IRNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7dfa882cf8954030951737b16dfdfebe

Copyright Text:

Default Visibility: true

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: -9602256.379300524
YMin: 5273939.293456238
XMax: -9548525.33075493
YMax: 5343188.786979515
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: 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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Address ( type: esriFieldTypeString, alias: Address Or General Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address )
• PIN ( type: esriFieldTypeString, alias: Parcel #, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PIN )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• GovernmentUnit ( type: esriFieldTypeString, alias: Government Unit, editable: true, nullable: true, length: 2, defaultValue: null, modelName: GovernmentUnit , Coded Values: [11: Allendale Twp] , [12: Blendon Twp] , [13: Chester Twp] , ...21 more... )
• DrainDistrict ( type: esriFieldTypeString, alias: Drain District, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DrainDistrict )
• IRNumber ( type: esriFieldTypeString, alias: IR Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IRNum )
• DrainCourse ( type: esriFieldTypeString, alias: DrainCourse, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DrainCourse )
• DrainType ( type: esriFieldTypeString, alias: DrainType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DrainType , Coded Values: [County Drain: County Drain] , [Subdivision Drain: Subdivision Drain] , [Intercounty Drain: Intercounty Drain] , ...3 more... )
• InitialInspectionDate ( type: esriFieldTypeDate, alias: Date of Initial Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• SiteCondition ( type: esriFieldTypeString, alias: Site Condition, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SiteCondition )
• Recommendations ( type: esriFieldTypeString, alias: Recommendations, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Recommendations )
• AssignedContractor ( type: esriFieldTypeString, alias: Contractor Assigned to Work , editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssignedTo )
• isCallReturned ( type: esriFieldTypeString, alias: Was Call Returned, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ReturnedCall , Coded Values: [Yes: Yes] , [No: No] )
• isFinalInspected ( type: esriFieldTypeString, alias: Has Final Inspection Occurred, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FinalInspected , Coded Values: [Yes: Yes] , [No: No] )
• FinalInspectionDate ( type: esriFieldTypeDate, alias: FinalInspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FinalInspectDate )
• Subdivision ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Subdivision )
• Lot ( type: esriFieldTypeString, alias: Lot, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lot )
• Township ( type: esriFieldTypeString, alias: Township, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Township , Coded Values: [Allendale Township: Allendale Township] , [Blendon Township: Blendon Township] , [Chester Township: Chester Township] , ...21 more... )
• Section ( type: esriFieldTypeString, alias: Section, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Section )
• drainAssessID ( type: esriFieldTypeSmallInteger, alias: drainAssessID, editable: true, nullable: true, defaultValue: null, modelName: drainAssessID )
• isInitialInpsected ( type: esriFieldTypeString, alias: drainInspected, editable: true, nullable: true, length: 4, defaultValue: No, modelName: drainInspected , Coded Values: [Yes: Yes] , [No: No] )
• Priority ( type: esriFieldTypeString, alias: Priority of Initial Inspection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Status , Coded Values: [High: High] , [Standard: Standard] )
• dAssessID ( type: esriFieldTypeInteger, alias: Drain Assessment ID, editable: true, nullable: true, defaultValue: null, modelName: dAssessID )
• DateOfContact ( type: esriFieldTypeDate, alias: Initial Date of Contact, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOfContact )
• OCWRCJurisdiction ( type: esriFieldTypeString, alias: OCWRC Jurisdiction, editable: true, nullable: true, length: 4, defaultValue: null, modelName: OCWRCJurisdiction , Coded Values: [Yes: Yes] , [No: No] )
• FirstName ( type: esriFieldTypeString, alias: Contact First Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FirstName )
• LastName ( type: esriFieldTypeString, alias: LastName , editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastName )
• HomeNumber ( type: esriFieldTypeString, alias: Contact Home Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: HomeNumber )
• WorkNumber ( type: esriFieldTypeString, alias: Contact Work Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WorkNumber )
• CellNumber ( type: esriFieldTypeString, alias: Contact Cell Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CellNumber )
• ContactEmail ( type: esriFieldTypeString, alias: Contact Email Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContactEmail )
• CallReceivedBy ( type: esriFieldTypeString, alias: Call Received By Initials, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CallReceivedBy )
• BusinessName ( type: esriFieldTypeString, alias: Business Name for Commercial Properties, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BusinessName )
• StreetName ( type: esriFieldTypeString, alias: Street Name of Issue, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName )
• CrossStreet ( type: esriFieldTypeString, alias: Cross Street of Issue, editable: true, nullable: true, length: 75, defaultValue: null, modelName: CrossStreet )
• DateAssigned ( type: esriFieldTypeDate, alias: Date Contractor Assigned to Work, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateAssigned )
• ReturnedCallDate ( type: esriFieldTypeDate, alias: Date Returned Call to Customer, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReturnedCallDate )
• NumCatchBasinsCleaned ( type: esriFieldTypeInteger, alias: Number of Catch Basins Cleaned, editable: true, nullable: true, defaultValue: null, modelName: NumCatchBasinsCleaned )
• AshTreesRemoved ( type: esriFieldTypeInteger, alias: Number of Ash Trees Removed, editable: true, nullable: true, defaultValue: null, modelName: AshTreesRemoved )
• InvoiceAmount ( type: esriFieldTypeDouble, alias: Contractor Invoice for Work, editable: true, nullable: true, defaultValue: null, modelName: InvoiceAmount )
• NoticeDrainMaintenance ( type: esriFieldTypeString, alias: Notice of Drain Maintenance Sent, editable: true, nullable: true, length: 4, defaultValue: null, modelName: NoticeDrainMaintenance , Coded Values: [Yes: Yes] , [No: No] )
• Inspector ( type: esriFieldTypeString, alias: Inspector , editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• InspectorTitle ( type: esriFieldTypeString, alias: Inspector of Title, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectorTitle )
• Hours ( type: esriFieldTypeDouble, alias: Hours, editable: true, nullable: true, defaultValue: null, modelName: Hours )
• Discrepancy ( type: esriFieldTypeString, alias: Discrepancy, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Discrepancy , Coded Values: [Yes: Yes] , [No: No] )
• SedimentRemoved ( type: esriFieldTypeInteger, alias: Linear Feet of Sediment Removed, editable: true, nullable: true, defaultValue: null, modelName: SedimentRemoved )
• Site_Condition ( type: esriFieldTypeString, alias: Site_Conditions, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: Site_Condition )
• Recommendations_ ( type: esriFieldTypeString, alias: Recommendations_, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: Recommendations_ )
• ProjectType ( type: esriFieldTypeString, alias: ProjectType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectType , Coded Values: [Animal: Animal Issue] , [Debris: Debris Issue] , [Ponding: Ponding] , ...6 more... )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ProjectStatus , Coded Values: [Active: Active] , [Completed: Completed] , [On Hold: On Hold] , ...1 more... )
• MaintenanceProject ( type: esriFieldTypeString, alias: Maintenance Project, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MaintenanceProject , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• CustomerPresent ( type: esriFieldTypeString, alias: Customer Present, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CustomerPresent , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )

Templates:

• Name: No Contractor Out For Bid Maintenance
  Description:
  Prototype:
  MaintenanceProject: null
  CustomerPresent: null
  ProjectType: null
  Recommendations_: null
  Site_Condition: null
  SedimentRemoved: null
  ProjectStatus: null
  Address: null
  PIN: null
  Latitude: null
  Longitude: null
  GovernmentUnit: null
  DrainDistrict: null
  IRNumber: null
  DrainCourse: null
  DrainType: null
  InitialInspectionDate: null
  SiteCondition: null
  Recommendations: null
  AssignedContractor: null
  isCallReturned: null
  isFinalInspected: null
  FinalInspectionDate: null
  Subdivision: null
  Lot: null
  Township: null
  Section: null
  drainAssessID: null
  isInitialInpsected: No
  Priority: null
  dAssessID: null
  DateOfContact: null
  OCWRCJurisdiction: null
  FirstName: null
  LastName: null
  HomeNumber: null
  WorkNumber: null
  CellNumber: null
  ContactEmail: null
  CallReceivedBy: null
  BusinessName: null
  StreetName: null
  CrossStreet: null
  DateAssigned: null
  ReturnedCallDate: null
  NumCatchBasinsCleaned: null
  AshTreesRemoved: null
  InvoiceAmount: null
  NoticeDrainMaintenance: null
  Inspector: null
  InspectorTitle: null
  Hours: null
  Discrepancy: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• DAInspectionPhotoLocation (21) -- Related To: Photo Locations (5)
• DAOtherInspectors (42) -- Related To: Other Inspectors (14)
• DAHistorical (43) -- Related To: Historical Table (13)
• WATERRESOURCES.DARelatedInspections (44) -- Related To: Related Inspections Table (24)

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

Sync Can Return Changes: true

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

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