Name: query_append_PI

Display Field: ODS_School_Flat_File_FID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ODS_School_Flat_File_FID (type: esriFieldTypeString, alias: ODS School Flat File.FID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• School_Nam (type: esriFieldTypeString, alias: School_Nam, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ESD (type: esriFieldTypeString, alias: ESD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SD (type: esriFieldTypeString, alias: SD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• senate_geoid (type: esriFieldTypeInteger, alias: senate_geoid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• senate_district (type: esriFieldTypeString, alias: senate_district, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ods_coordinator (type: esriFieldTypeString, alias: ods_coordinator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ods_region (type: esriFieldTypeString, alias: ods_region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ods_contact (type: esriFieldTypeString, alias: ods_contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• house_geoid (type: esriFieldTypeInteger, alias: house_geoid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• house_district (type: esriFieldTypeString, alias: house_district, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RS_ODS_Explorer_20172018_PI_FID (type: esriFieldTypeString, alias: RS_ODS_Explorer_20172018_PI.FID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Participated (type: esriFieldTypeString, alias: Participated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number_Attending (type: esriFieldTypeInteger, alias: Number Attending, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontext_Soil (type: esriFieldTypeInteger, alias: Lcontext_Soil, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontext_Timber (type: esriFieldTypeInteger, alias: Lcontext_Timber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontext_Nature (type: esriFieldTypeInteger, alias: Lcontext_Nature, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontext_OR_NR (type: esriFieldTypeInteger, alias: Lcontext_OR_NR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontext_Student (type: esriFieldTypeInteger, alias: Lcontext_Student, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_STEM (type: esriFieldTypeInteger, alias: Lcontent_STEM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_Food (type: esriFieldTypeInteger, alias: Lcontent_Food, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_Sustainability (type: esriFieldTypeInteger, alias: Lcontent_Sustainability, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_SocialStudies (type: esriFieldTypeInteger, alias: Lcontent_SocialStudies, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_Art (type: esriFieldTypeInteger, alias: Lcontent_Art, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_PhysEd (type: esriFieldTypeInteger, alias: Lcontent_PhysEd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_SocioEmotional (type: esriFieldTypeInteger, alias: Lcontent_SocioEmotional, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_Careers (type: esriFieldTypeInteger, alias: Lcontent_Careers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lcontent_ORStudies (type: esriFieldTypeInteger, alias: Lcontent_ORStudies, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_Multimodal (type: esriFieldTypeInteger, alias: InsStrat_Multimodal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_Collab (type: esriFieldTypeInteger, alias: InsStrat_Collab, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_LearnerCntrd (type: esriFieldTypeInteger, alias: InsStrat_LearnerCntrd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_Investigative (type: esriFieldTypeInteger, alias: InsStrat_Investigative, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_Reflective (type: esriFieldTypeInteger, alias: InsStrat_Reflective, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_Relevance (type: esriFieldTypeInteger, alias: InsStrat_Relevance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsStrat_Interdisc (type: esriFieldTypeInteger, alias: InsStrat_Interdisc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_HS (type: esriFieldTypeInteger, alias: Support Parter High School Volunteer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_Trained (type: esriFieldTypeInteger, alias: Support Parter Trained Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_NR (type: esriFieldTypeInteger, alias: Support Parter Natural Resource Specialist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_CommOrg (type: esriFieldTypeInteger, alias: Support Parter Community Based Org., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_HS (type: esriFieldTypeInteger, alias: Instruction Partner High School Volunteer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_Trained (type: esriFieldTypeInteger, alias: Instruction Partner Trained Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_NR (type: esriFieldTypeInteger, alias: Instruction Parter Natural Resource Specialist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_CommOrg (type: esriFieldTypeInteger, alias: Instruction Parter Community Based Org., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_Range (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Partic_1718 (type: esriFieldTypeInteger, alias: 2017-2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partic_1819 (type: esriFieldTypeInteger, alias: 2018-2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partic_1920 (type: esriFieldTypeInteger, alias: 2019-2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partic_2021 (type: esriFieldTypeInteger, alias: 2020-2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partic_2122 (type: esriFieldTypeInteger, alias: 2021-2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partic_2223 (type: esriFieldTypeInteger, alias: 2022-2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partic_2324 (type: esriFieldTypeInteger, alias: 2023-2024, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_Not_HS (type: esriFieldTypeInteger, alias: Support Parter Not High School Volunteer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_Not_Trained (type: esriFieldTypeInteger, alias: Support Parter Not Trained Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_Not_NR (type: esriFieldTypeInteger, alias: Support Parter Not Natural Resource Specialist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Support_Not_CommOrg (type: esriFieldTypeInteger, alias: Support Parter Not Community Based Org., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_Not_HS (type: esriFieldTypeInteger, alias: Instruction Partner Not High School Volunteer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_Not_Trained (type: esriFieldTypeInteger, alias: Instruction Partner Trained Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_Not_NR (type: esriFieldTypeInteger, alias: Instruction Parter Not Natural Resource Specialist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Instruction_Not_CommOrg (type: esriFieldTypeInteger, alias: Instruction Parter Not Community Based Org., SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: query_append_PI
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/30/2025 7:55:12 PM

Schema Last Edit Date: 3/30/2025 7:55:12 PM

Data Last Edit Date: 3/30/2025 7:55:12 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat