View In:   ArcGIS Online Map Viewer

Name: ReferenceData.DBO.MidvaleSchools

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: These data represent point locations of schools in the State of Utah. Data sources include information provided by the Utah State Office of Education (USOE) and the Utah Education Network (UEN). A combination of geocoding and manual placement (digitizing) was used to identify the geographic location of each school. For use at 1:24,000 scale.The following are source codes for the SCHOOL_TYPE field:CLOSE = Closed DIST = DistrictELEM = ElementaryHIGHED = Higher EducationHIGH = High SchoolJRHI = Junior HighK12 = K-12MID = Middle SchoolNONE = NonePREK = Preschool - KindergartenPVELM - Private ElementaryPVSEC = Private SecondarySPECED = Special EducationSPELM = Special Education - ElementarySPSEC = Special Education - SecondarySRHI = Senior High SchoolSUPP = SupplementaryUpdated: January 2015Updated: July 7, 2015 (updated Mt. Jordan Middle School and Midvale Middle School in the Canyon's School District)

Copyright Text: USOE, UEN, AGRC

Default Visibility: true

MaxRecordCount: 2000

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: 423632.3700000001
YMin: 4494490.199999999
XMax: 427128.9000000004
YMax: 4497503.0
Spatial Reference: 26912  (26912)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIPCODE )
• SCHOOL_TYPE ( type: esriFieldTypeString, alias: SCHOOL_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SCHOOL_TYPE )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DISTRICT )
• DIST_TYPE ( type: esriFieldTypeString, alias: DIST_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DIST_TYPE )
• DISTRICT_ID ( type: esriFieldTypeString, alias: DISTRICT_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DISTRICT_ID )
• DISTRICT_NBR ( type: esriFieldTypeString, alias: DISTRICT_NBR, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DISTRICT_NBR )
• SCHOOL_ID ( type: esriFieldTypeString, alias: SCHOOL_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SCHOOL_ID )
• SCHOOL_NBR ( type: esriFieldTypeString, alias: SCHOOL_NBR, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SCHOOL_NBR )
• NCES_AG_ID ( type: esriFieldTypeString, alias: NCES_AG_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NCES_AG_ID )
• NCES_SCH_ID ( type: esriFieldTypeString, alias: NCES_SCH_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NCES_SCH_ID )
• DATE_OPEN ( type: esriFieldTypeDate, alias: DATE_OPEN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_OPEN )
• DATE_CLOSED ( type: esriFieldTypeDate, alias: DATE_CLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_CLOSED )
• GRADE_LOW ( type: esriFieldTypeString, alias: GRADE_LOW, editable: true, nullable: true, length: 2, defaultValue: null, modelName: GRADE_LOW )
• GRADE_HIGH ( type: esriFieldTypeString, alias: GRADE_HIGH, editable: true, nullable: true, length: 2, defaultValue: null, modelName: GRADE_HIGH )
• JoinKey ( type: esriFieldTypeString, alias: JoinKey, editable: true, nullable: true, length: 200, defaultValue: null, modelName: JoinKey )
• USOE_ID ( type: esriFieldTypeString, alias: USOE_ID, editable: true, nullable: true, length: 200, defaultValue: null, modelName: USOE_ID )
• ADDRESS1 ( type: esriFieldTypeString, alias: ADDRESS1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS1 )
• CITY1 ( type: esriFieldTypeString, alias: CITY1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CITY1 )
• STATE1 ( type: esriFieldTypeString, alias: STATE1, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE1 )
• ZIPCODE1 ( type: esriFieldTypeString, alias: ZIPCODE1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIPCODE1 )
• AGRC_MDATE ( type: esriFieldTypeDate, alias: AGRC_MDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AGRC_MDATE )
• DIST_OFFICE ( type: esriFieldTypeString, alias: DIST_OFFICE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DIST_OFFICE )
• NATID ( type: esriFieldTypeString, alias: NATID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NATID )
• USOE_JoinKey ( type: esriFieldTypeString, alias: USOE_JoinKey, editable: true, nullable: true, length: 200, defaultValue: null, modelName: USOE_JoinKey )
• HOUSE_DIST ( type: esriFieldTypeSmallInteger, alias: HOUSE_DIST, editable: true, nullable: true, defaultValue: null, modelName: HOUSE_DIST )
• SENATE_DIST ( type: esriFieldTypeSmallInteger, alias: SENATE_DIST, editable: true, nullable: true, defaultValue: null, modelName: SENATE_DIST )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• INSTITUTION_NAME ( type: esriFieldTypeString, alias: INSTITUTION_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INSTITUTION_NAME )
• JoinKey2 ( type: esriFieldTypeString, alias: JoinKey2, editable: true, nullable: true, length: 200, defaultValue: null, modelName: JoinKey2 )
• 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 )

Templates:

• Name: ReferenceData.DBO.MidvaleSchools
  Description:
  Prototype:
  JoinKey2: null
  NAME: null
  ADDRESS: null
  CITY: null
  STATE: null
  ZIPCODE: null
  SCHOOL_TYPE: null
  DISTRICT: null
  DIST_TYPE: null
  DISTRICT_ID: null
  DISTRICT_NBR: null
  SCHOOL_ID: null
  SCHOOL_NBR: null
  NCES_AG_ID: null
  NCES_SCH_ID: null
  DATE_OPEN: null
  DATE_CLOSED: null
  GRADE_LOW: null
  GRADE_HIGH: null
  JoinKey: null
  USOE_ID: null
  ADDRESS1: null
  CITY1: null
  STATE1: null
  ZIPCODE1: null
  AGRC_MDATE: null
  DIST_OFFICE: null
  NATID: null
  USOE_JoinKey: null
  HOUSE_DIST: null
  SENATE_DIST: null
  X: null
  Y: null
  INSTITUTION_NAME: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

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

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata