Introduction
The provided source material contains information about two distinct topics: an online Geometry course offered by Apex Learning and technical details regarding spatial data types and map layers within the Oracle APEX (Application Express) environment. There is no information in the provided source data regarding free samples, promotional offers, no-cost product trials, brand freebies, or mail-in sample programmes. Consequently, an article focused on consumer free samples cannot be written based on the available material. Instead, this article will provide a factual summary of the information found in the source data concerning the Geometry course and Oracle APEX spatial data types, adhering strictly to the system prompt's requirement for factual accuracy and source-based content.
Geometry Course Overview
The source data references two platforms, Edmentum and Apex Learning VS, that offer an online Geometry course. The course description is consistent across both sources, indicating a shared curriculum structure.
Course Content and Objectives
The Geometry course is designed to build upon students' existing knowledge of geometric relationships and their ability to formulate mathematical arguments. The course emphasises learning through discovery and application, aiming to equip students with the skills to deconstruct complex challenges and demonstrate their knowledge in new contexts.
Key topics covered in the course include: * Reasoning, proofs, and the creation of sound mathematical arguments * Points, lines, and angles * Triangles and trigonometry * Quadrilaterals and other polygons * Circles * Congruence, similarity, transformations, and constructions * Coordinate geometry * Three-dimensional solids * Applications of probability
The course is structured to support all students in developing computational fluency and deepening their conceptual understanding. The learning methodology involves students discovering new concepts through guided instruction at the beginning of each lesson, followed by confirmation of their understanding in an interactive, feedback-rich environment. The curriculum also includes modelling activities to analyse real-world scenarios and mathematical ideas, as well as journaling activities to encourage abstract and quantitative reasoning, argument construction, and precise communication.
Course Logistics and Pricing
The Apex Learning VS source provides specific logistical and financial details for the Geometry course. The course is priced at $700.00 for a full-year term. Alternatively, it can be purchased for a single semester at $380.00 for either Semester 1 or Semester 2. Students have the flexibility to start a course on any day and learn at their own pace. A withdrawal option is available within 14 days of starting the course.
Oracle APEX Spatial Data Types and Map Layers
The technical portion of the source material, derived from a blog post on Apex Applab Dev, focuses on the use of spatial data within Oracle APEX Map Regions. It explains the different data types available for representing geometries and the types of map layers that can be created.
Map Region Layer Types
The APEX Map Region supports several types of visual layers, each suited for different kinds of geographical data:
- Points: Represented as markers, these are used for features like customer or supplier locations. The marker shape and colour are configurable.
- Lines: Used to represent features such as roads or paths. The stroke style and colour are configurable.
- Polygons: Represent areas like parcels, states, or countries. Both the stroke and fill style and colour are configurable.
- Heat Map: This layer type visualises the density of point features. The colour intensity increases where points are clustered together, making it useful for visualising the spatial distribution of population or incidents.
- Extruded Polygons: Similar to standard polygons but displayed as three-dimensional, "extruded" objects. The height of the 3D object visualises a column value.
Geometry Column Data Types in APEX
APEX allows the use of three different data types to represent objects in a Map Layer, which are selected in the "Column Mapping" section. The choice of data type influences the available options for selecting geometry columns.
- Longitude/Latitude: Described as the most popular and easy-to-understand data type, it represents the 2D coordinates of a point on the map. It is familiar to most users, and many data sources provide these two coordinates. It can be used to represent a points layer.
- GeoJSON: This is a geographical data format represented in JSON, following a global standard. It is easy to read and Oracle has a special data type to store and index this information. It is particularly useful when working with Javascript and for modifying information on the map. It can represent all types of geometries (points, polygons, lines, etc.).
- SDO_GEOMETRY: This is a special Oracle Object type used by Oracle Spatial. It contains comprehensive information, including the coordinate system used, geometry type, dimensions, and data points as an array. It is suitable for all kinds of map layers, supported in APEX, and is especially useful for solving more complex tasks. It is utilised by the
SDO_UTILandSDO_SAMpackages for calculations like determining distances between points on the map.
Data Conversion and Functionality
The source material provides specific examples of converting between SDO_GEOMETRY and GeoJSON formats using Oracle SQL functions.
Converting SDO_GEOMETRY to GeoJSON:
Three methods are presented, all yielding the same result for a given LineString geometry:
1. Using apex_json.stringify() on an SDO_GEOMETRY object.
2. Using the Get_GeoJson() method on an SDO_GEOMETRY object.
3. Using the SDO_UTIL.TO_GEOJSON() function.
Converting GeoJSON to SDO_GEOMETRY:
Two functions are shown to perform this conversion, both providing the same result:
1. SDO_UTIL.FROM_JSON()
2. SDO_UTIL.FROM_GEOJSON()
The source confirms that for both conversion directions, the alternative functions produce identical outputs.
Conclusion
The provided source material offers detailed information on two separate subjects. Firstly, it outlines the structure, content, and pricing of an online Geometry course available through platforms like Edmentum and Apex Learning VS. The course focuses on geometric reasoning, proof, and application, with a flexible, self-paced learning model. Secondly, it delves into the technical aspects of using spatial data within Oracle APEX, detailing the available map layer types (Points, Lines, Polygons, Heat Maps, Extruded Polygons) and the three primary data types for storing geometry information (Longitude/Latitude, GeoJSON, SDOGEOMETRY). It also includes practical examples of converting between SDOGEOMETRY and GeoJSON formats. No information regarding consumer free samples, promotional offers, or related programmes is present in the source data.