SAQA All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source.
SOUTH AFRICAN QUALIFICATIONS AUTHORITY 
REGISTERED UNIT STANDARD THAT HAS PASSED THE END DATE: 

Demonstrate knowledge of the principles of spatial data in database 
SAQA US ID UNIT STANDARD TITLE
258759  Demonstrate knowledge of the principles of spatial data in database 
ORIGINATOR
SGB Geographical Information Sciences 
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY
-  
FIELD SUBFIELD
Field 12 - Physical Planning and Construction Physical Planning, Design and Management 
ABET BAND UNIT STANDARD TYPE PRE-2009 NQF LEVEL NQF LEVEL CREDITS
Undefined  Regular  Level 6  Level TBA: Pre-2009 was L6 
REGISTRATION STATUS REGISTRATION START DATE REGISTRATION END DATE SAQA DECISION NUMBER
Passed the End Date -
Status was "Reregistered" 
2018-07-01  2023-06-30  SAQA 06120/18 
LAST DATE FOR ENROLMENT LAST DATE FOR ACHIEVEMENT
2024-06-30   2027-06-30  

In all of the tables in this document, both the pre-2009 NQF Level and the NQF Level is shown. In the text (purpose statements, qualification rules, etc), any references to NQF Levels are to the pre-2009 levels unless specifically stated otherwise.  

This unit standard does not replace any other unit standard and is not replaced by any other unit standard. 

PURPOSE OF THE UNIT STANDARD 
This unit standard has been developed for the GIS occupational area and is intended for persons who aim to achieve career advancement by gaining GIS skills leading to qualification based on unit standards. A person who has successfully completed this unit standard will have an understanding of principles of spatial data in databases.

A person credited with this unit standard is able to:
  • Demonstrate an understanding of unique identifiers.
  • Demonstrate an understanding of label properties.
  • Demonstrate an understanding of Spatial Data Types and the representation thereof.
  • Demonstrate an understanding of Spatial Data Indexes.
  • Demonstrate an understanding of location and spatial reference identification. 

  • LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING 
    The credit calculation is based on the assumption that learners are already competent in terms of the following outcomes or areas of learning when starting to learn towards this unit standard:
  • Database design.
  • All Spatial awareness unit standards.
  • Communication at NQF Level 5.
  • Mathematical Literacy at NQF Level 5. 

  • UNIT STANDARD RANGE 
    The following scope and context applies to the whole unit standard:
  • Including but not limited to unique identifiers, label properties, spatial data types, spatial data indexes, symbology, location, spatial reference identifiers (SRID), exchange issues.
  • Specific range statements are provided in the body of the unit standard where they apply to particular specific outcomes or assessment criteria. 

  • Specific Outcomes and Assessment Criteria: 

    SPECIFIC OUTCOME 1 
    Demonstrate an understanding of unique identifiers. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    Unique identifiers are understood and explained in relation to spatial databases. 

    ASSESSMENT CRITERION 2 
    Random identifiers are explained and understood in relation to spatial databases. 

    ASSESSMENT CRITERION 3 
    Unique sequential Identifiers' dependence on spatial relationships is explained and understood in the context of spatial databases. 

    SPECIFIC OUTCOME 2 
    Demonstrate an understanding of label properties. 
    OUTCOME RANGE 
    Rotation, position, style, scale, links, value. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    Label properties are explained and understood in relation to the principles of spatial data. 

    ASSESSMENT CRITERION 2 
    Placement issues are explained and understood in relation to the principles of spatial data. 
    ASSESSMENT CRITERION RANGE 
    Duplication, rotation, position.
     

    ASSESSMENT CRITERION 3 
    The mechanism to populate the default label value is understood and explained in relation to the principles of spatial data. 
    ASSESSMENT CRITERION RANGE 
    Specific, concatenated or calculated field value.
     

    SPECIFIC OUTCOME 3 
    Demonstrate an understanding of Spatial Data Types and the representation thereof. 
    OUTCOME RANGE 
    Point, line, polygon, surface, network, raster, vector, symbology, topology, islands, compound features, dynamic segmentations. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    Spatial Data Types and the representation thereof are explained and understood in relation to the principles of spatial data. 
    ASSESSMENT CRITERION RANGE 
    Point, line, polygon, raster, surface, symbology, networks, islands, compound features, dynamic segmentations.
     

    ASSESSMENT CRITERION 2 
    Spatial Data Types storage is explained and understood according to open GIS standard. 
    ASSESSMENT CRITERION RANGE 
    Simple feature classification, behaviour, topology.
     

    SPECIFIC OUTCOME 4 
    Demonstrate an understanding of Spatial Data Indexes. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The effect of indexing spatial data is understood and explained in relation to the principles of spatial data. 
    ASSESSMENT CRITERION RANGE 
    Indexed vs. non-indexed.
     

    ASSESSMENT CRITERION 2 
    Index methods for raster data are listed according to principles of spatial data. 
    ASSESSMENT CRITERION RANGE 
    Including but not limited to:
  • Run length encoding, Quad tree, Chain coding, Block Coding.
     

  • ASSESSMENT CRITERION 3 
    Index methods for vector data are listed according to principles of spatial data. 
    ASSESSMENT CRITERION RANGE 
    Including but not limited to:
  • B-tree, R-tree, Quad tree, Direct and inverted index files.
     

  • SPECIFIC OUTCOME 5 
    Demonstrate an understanding of location and spatial reference identification. 
    OUTCOME RANGE 
    Spatial reference, datums, projections, coordinate systems, topology, spatial relationships. 

    ASSESSMENT CRITERIA
     

    ASSESSMENT CRITERION 1 
    The relationship between coordinate data and the spatial reference system is understood and explained in relation to principles of spatial data. 

    ASSESSMENT CRITERION 2 
    Provision for the storage of spatial reference system information in a spatial database is understood and explained according to principles of spatial data. 

    ASSESSMENT CRITERION 3 
    Provision for the storage of location information is understood and explained within a spatial database. 


    UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS 
  • Anyone assessing a learner against this unit standard must be registered as an assessor with the relevant ETQA.
  • Any institution offering learning that will enable achievement of this unit standard must be accredited as a provider through the relevant ETQA by SAQA.
  • Moderation of assessment will be overseen by the relevant ETQA according to the moderation guidelines and the agreed ETQA procedures. 

  • UNIT STANDARD ESSENTIAL EMBEDDED KNOWLEDGE 
  • Essential embedded knowledge will be assessed through assessment of the specific outcomes in terms of the stipulated assessment criteria. Candidates are unlikely to achieve all the specific outcomes, to the standards described in the assessment criteria, without knowledge of the listed embedded knowledge. This means that for the most part, the possession or lack of the knowledge can be directly inferred from the quality of the candidate's performance. Where direct assessment of knowledge is required, assessment criteria have been included in the body of the unit standard. 

  • UNIT STANDARD DEVELOPMENTAL OUTCOME 
    N/A 

    UNIT STANDARD LINKAGES 
    N/A 


    Critical Cross-field Outcomes (CCFO): 

    UNIT STANDARD CCFO IDENTIFYING 
    Solve problems. 

    UNIT STANDARD CCFO WORKING 
    Work effectively with others as a member of a team/group/organisation or community. 

    UNIT STANDARD CCFO ORGANISING 
    Organise and manage oneself and one`s activities responsibly and effectively. 

    UNIT STANDARD CCFO COLLECTING 
    Collect, organise and critically evaluate information. 

    UNIT STANDARD CCFO COMMUNICATING 
    Communicate effectively using visual, mathematics and language skills in the modes of oral and written presentations. 

    UNIT STANDARD CCFO SCIENCE 
    Use science and technology effectively and critically (showing responsibility towards the environment and health of others). 

    UNIT STANDARD CCFO DEMONSTRATING 
    Display an understanding of the world as a set of related systems. 

    UNIT STANDARD CCFO CONTRIBUTING 
    Contribute to the full development of each learner and the social and economic development of society at large. 

    UNIT STANDARD ASSESSOR CRITERIA 
    N/A 

    REREGISTRATION HISTORY 
    As per the SAQA Board decision/s at that time, this unit standard was Reregistered in 2012; 2015. 

    UNIT STANDARD NOTES 
    Terminology:
  • Location: A point or extent in space.
  • SRID: Spatial Reference Identifiers. 

  • QUALIFICATIONS UTILISING THIS UNIT STANDARD: 
      ID QUALIFICATION TITLE PRE-2009 NQF LEVEL NQF LEVEL STATUS END DATE PRIMARY OR DELEGATED QA FUNCTIONARY
    Elective  63689   Bachelor of Arts: Geographical Information Science  Level 6  Level TBA: Pre-2009 was L6  Passed the End Date -
    Status was "Reregistered" 
    2018-06-30   


    PROVIDERS CURRENTLY ACCREDITED TO OFFER THIS UNIT STANDARD: 
    This information shows the current accreditations (i.e. those not past their accreditation end dates), and is the most complete record available to SAQA as of today. Some Primary or Delegated Quality Assurance Functionaries have a lag in their recording systems for provider accreditation, in turn leading to a lag in notifying SAQA of all the providers that they have accredited to offer qualifications and unit standards, as well as any extensions to accreditation end dates. The relevant Primary or Delegated Quality Assurance Functionary should be notified if a record appears to be missing from here.
     
    NONE 



    All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source.