Name: School_Childcare_Sampling

Display Field: facilitytype

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 291214be306845659144c5edd0cd08bf

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• facilitytype ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: facilitytype, alias: Facility Type , Coded Values: [School: School] , [Childcare: Childcare] , [Both School and Childcare: Both School and Childcare] )
• sampledby ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: sampledby, alias: Sampled By , Coded Values: [School Childcare Staff: School Childcare Staff] , [Utility: Utility] , [Other: Other] )
• sampledate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: sampledate, alias: Sampling Date )
• resultdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resultdate, alias: Result Received Date )
• leadssite1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite1, alias: Lead - School Site 1 (mg/L) )
• leadssite2 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite2, alias: Lead - School Site 2 (mg/L) )
• leadssite3 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite3, alias: Lead - School Site 3 (mg/L) )
• leadssite4 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite4, alias: Lead - School Site 4 (mg/L) )
• leadssite5 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadssite5, alias: Lead - School Site 5 (mg/L) )
• labids1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids1, alias: Lab Sample ID - School Site 1 )
• labids2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids2, alias: Lab Sample ID - School Site 2 )
• labids3 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids3, alias: Lab Sample ID - School Site 3 )
• labids4 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids4, alias: Lab Sample ID - School Site 4 )
• labids5 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labids5, alias: Lab Sample ID - School Site 5 )
• ssite1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite1, alias: School Site 1 Description )
• ssite2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite2, alias: School Site 2 Description )
• ssite3 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite3, alias: School Site 3 Description )
• ssite4 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite4, alias: School Site 4 Description )
• ssite5 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ssite5, alias: School Site 5 Description )
• leadccsite1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadccsite1, alias: Lead - CC Site 1 (mg/L) )
• leadccsite2 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: leadccsite2, alias: Lead - CC Site 2 (mg/L) )
• labidcc1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labidcc1, alias: Lab Sample ID - CC Site 1 )
• labidcc2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: labidcc2, alias: Lab Sample ID - CC Site 2 )
• ccsite1 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ccsite1, alias: CC Site 1 Description )
• ccsite2 ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: ccsite2, alias: CC Site 2 Description )
• notes ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: notes, alias: Notes )
• assetguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: assetguid, alias: Asset Guid )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• waiver ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: waiver, alias: Waiver Granted for Previous Sampling , Coded Values: [Yes: Yes] , [No: No] )
• resultnotifieddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resultnotifieddate, alias: Sample Result Notification Date )
• sampledeliverdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: sampledeliverdate, alias: Sample Kit Delivered Date )
• scheduledate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: scheduledate, alias: Sample Schedule Date )
• address ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: address, alias: Address )
• schoolpriorityrank ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: schoolpriorityrank, alias: School Priority Rank )
• ccpriorityrank ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: ccpriorityrank, alias: Childcare Priority Rank )
• location ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: location, alias: Other Location Identifier )

Templates:

• Name: School_Childcare_Sampling
  Description:
  Prototype:
  notes: null
  labidcc1: null
  sampledby: null
  labidcc2: null
  scheduledate: null
  leadssite1: null
  leadssite2: null
  ccsite1: null
  leadssite3: null
  ccsite2: null
  leadssite4: null
  sampledate: null
  leadssite5: null
  assetguid: null
  leadccsite2: null
  leadccsite1: null
  ccpriorityrank: null
  address: null
  resultnotifieddate: null
  schoolpriorityrank: null
  labids4: null
  ssite1: null
  sampledeliverdate: null
  labids3: null
  labids5: null
  ssite5: null
  ssite4: null
  resultdate: null
  labids2: null
  ssite3: null
  location: null
  facilitytype: null
  labids1: null
  ssite2: null
  waiver: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• (2) -- Related To: ServiceLine (0)

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