class SchoolVOBranch(MappingSchema):
    address = general_rules.Address()
    avg_education_hours_per_student = AverageEducationHours()
    avg_education_hours_per_student_url = SchemaNode(String(), validator=url)
    board = SchemaNode(String(), validator=Length(min=3, max=100))
    board_id = general_rules.board_id
    branch_id = general_rules.branch_id
    brin = general_rules.brin
    building_img_url = SchemaNode(String(), validator=url)
    costs = Costs()
    costs_url = SchemaNode(String(), validator=url)
    denomination = general_rules.denomination
    education_structures = general_rules.EducationStructures()
    email = SchemaNode(String(), validator=Email())
    logo_img_url = SchemaNode(String(), validator=url)
    municipality = general_rules.municipality
    municipality_id = general_rules.municipality_code
    name = general_rules.name
    parent_satisfaction = Satisfactions()
    parent_satisfaction_url = SchemaNode(String(), validator=url)
    phone = general_rules.phone
    profile = SchemaNode(String(), validator=Length(min=3, max=500))
    province = general_rules.province
    schoolkompas_status_id = SchemaNode(Int(), validator=Range(min=0,\
        max=1000))
    schoolvo_code = SchemaNode(String(), validator=Length(min=14, max=14))
    student_satisfaction = Satisfactions()
    student_satisfaction_url = SchemaNode(String(), validator=url)
    website = general_rules.website
class OnderwijsInspectieVoBranch(MappingSchema):
    """

.. table::

    ======================================================= =================================== ========================================================================================================
    Field                                                   Type                                Description
    ======================================================= =================================== ========================================================================================================
    advice_structure_third_year                             array of :ref:`advice_struct_3`     An array of :ref:`advice_struct_3`, representing the distribution of the primary school advices students have in the third year of their education.
    board_id                                                integer                             Identifier (assigned by :ref:`duodata`) of the board of this branch.
    branch_id                                               integer                             Identifier (assigned by :ref:`duodata`) of this branch.
    brin                                                    string                              "Basis Registratie Instellingen-nummer", identifier of the school this branch belongs to. Alphanumeric, four characters long.
    composition_first_year                                  :ref:`first_year_comp`              Composition of the first year of this school, distinguishing between *combined* (students from different education structures partaking in the same courses) and *categorical* (percentage of students from the same education structures).
    exam_average_grades                                     array of :ref:`exam_avg_grades`     Array of :ref:`exam_avg_grades`, showing the average exam grade per course group.
    exam_participation_per_profile                          array of :ref:`exam_part_prof`      Array of :ref:`exam_part_prof`, containing the distribution of sectors (VMBO) and profiles (HAVO/VWO) in students participating in exams.
    first_years_performance                                 :ref:`first_year_perf`              Description of the performance of the school's "onderbouw" (first years).
    meta                                                    :ref:`owinspmeta`                   Metadata, such as date of scrape and whether this item passed validation.
    performance_assessments                                 array of :ref:`perf_ass`            Array of :ref:`perf_ass`, indicating the "Opbrengstenoordeel", a rating given by the Inspectie to each school, based on the performance in the first years ("onderbouw"), final years ("bovenbouw"), grades of the central examinations and the three year average of the difference between "schoolexamens" and central examinations grades.
    reports                                                 array of :ref:`owinspreport`        Array of :ref:`owinspreport`, where each item represents a report of the Onderwijsinspectie [#owinsp]_ in PDF.
    students_from_third_year_to_graduation_without_retaking array of :ref:`straight_grad`       Array of :ref:`straight_grad`, showing the percentage of students that go on to graduation from their third year without retaking a year, per education structure.
    students_in_third_year_without_retaking                 array of :ref:`3yearnoretakes`      Array of :ref:`3yearnoretakes`, showing the percentage of students that reach their third year without retaking a year.
    ======================================================= =================================== ========================================================================================================

    """
    address = general_rules.Address(title="Address of this branch")
    board = general_rules.name(title="The name of the board of this school.")
    board_id = general_rules.board_id(
        title=
        "Identifier (assigned by :ref:`duodata`) of the board of this branch.")
    branch_id = general_rules.branch_id(
        title="Identifier (assigned by :ref:`duodata`) of this branch.")
    brin = general_rules.brin(
        title=
        "'Basis Registratie Instellingen-nummer', identifier of the school this branch belongs to. Alphanumeric, four characters long."
    )
    current_ratings = CurrentRatings(
        title=
        "Array of :ref:`owinspcurrat`, where each item represents the current rating of the Onderwijsinspectie [#owinsp]_."
    )
    denomination = general_rules.denomination(
        title=
        "In the Netherlands, schools can be based on a (religious [#denomination]_) conviction, which is denoted here."
    )
    education_structures = general_rules.EducationStructures(
        title=
        "An array of strings, where each string represents the level of education [#edu_in_holland]_ (education structure) that is offered at this school."
    )
    name = general_rules.name(title="Name of this branch.")
    rating_history = RatingHistory(
        title=
        "Array of :ref:`owinsprathist`, where each item represents a rating the Onderwijsinspectie [#owinsp]_ awarded to this branch."
    )
    reports = Reports(
        title=
        "Array of :ref:`owinspreport`, where each item represents a report of the Onderwijsinspectie [#owinsp]_ in PDF."
    )
    result_card_url = general_rules.url(
        title="URL to the result card ('opbrengstenkaart') of this branch.")
    website = general_rules.url(title="Website of this branch (optional).")
Exemple #3
0
class DuoPoBoard(MappingSchema):
    address = general_rules.Address()
    correspondence_address = general_rules.Address()
    board_id = general_rules.board_id

    name = general_rules.name
    phone = general_rules.phone
    municipality = general_rules.municipality
    municipality_code = general_rules.municipality_code
    administrative_office_id = SchemaNode(Int())
    denomination = general_rules.denomination
    # TODO:
    #financial_key_indicators_per_year = FinancialKeyIndicatorsPerYear()
    financial_key_indicators_per_year_reference_date = SchemaNode(Date(),
        missing=True)
    financial_key_indicators_per_year_url = general_rules.website
    reference_year = general_rules.reference_year
    website = general_rules.website
Exemple #4
0
class DuoVoBoard(MappingSchema):
    address = general_rules.Address()
    correspondence_address = general_rules.Address()
    board_id = general_rules.board_id
    name = general_rules.name
    phone = general_rules.phone
    municipality = general_rules.municipality
    municipality_code = general_rules.municipality_code
    administrative_office_id = SchemaNode(Int())
    denomination = general_rules.denomination
    financial_key_indicators_per_year_reference_date = SchemaNode(Date(),
        missing=True)
    reference_year = general_rules.reference_year
    website = general_rules.website

    vavo_students_reference_url = general_rules.website
    vavo_students_reference_date = SchemaNode(Date(), missing=True)
    vavo_students = VavoStudents()
Exemple #5
0
class DuoVoBranch(MappingSchema):
    address = general_rules.Address()
    correspondence_address = general_rules.Address()
    name = general_rules.name
    branch_id = general_rules.branch_id
    board_id = general_rules.board_id
    brin = general_rules.brin
    corop_area = general_rules.corop_area
    corop_area_code = general_rules.corop_area_code
    denomination = general_rules.denomination
    education_area = general_rules.education_area
    education_area_code = general_rules.education_area_code
    education_structures = general_rules.EducationStructures()
    graduations = Graduations()
    graduations_reference_date = SchemaNode(Date())
    graduations_reference_url = general_rules.reference_url
    student_residences = StudentResidences()
    student_residences_reference_date = SchemaNode(Date())
    student_residences_reference_url = general_rules.reference_url
    students_by_structure = StudentsByStructure()
    municipality = general_rules.municipality
    municipality_code = general_rules.municipality_code
    nodal_area = general_rules.nodal_area
    nodal_area_code = general_rules.nodal_area_code
    phone = general_rules.phone
    province = general_rules.province
    reference_year = general_rules.reference_year
    rmc_region = general_rules.rmc_region
    rmc_region_code = general_rules.rmc_region_code
    rpa_area = general_rules.rpa_area
    rpa_area_code = general_rules.rpa_area_code
    website = general_rules.url
    wgr_area = general_rules.wgr_area
    wgr_area_code = general_rules.wgr_area_code


    vavo_students_reference_url = general_rules.website
    vavo_students_reference_date = SchemaNode(Date(), missing=True)
    vavo_students = VavoStudents()

    students_by_finegrained_structure_reference_url = general_rules.website
    students_by_finegrained_structure_reference_date = SchemaNode(Date(), missing=True)
    students_by_finegrained_structure = FineGrainedStructureStudents()
Exemple #6
0
class OnderwijsInspectiePoBranch(MappingSchema):
    name = general_rules.name
    brin = general_rules.brin
    board_id = general_rules.board_id
    denomination = general_rules.denomination
    branch_id = general_rules.branch_id
    address = general_rules.Address()
    website = general_rules.url
    reports = Reports()
    rating_history = RatingHistory()
    current_rating = CurrentRating()
Exemple #7
0
class DuoVoSchool(MappingSchema):
    address = general_rules.Address()
    correspondence_address = general_rules.Address()
    board_id = general_rules.board_id
    brin = general_rules.brin
    denomination = general_rules.denomination
    corop_area = general_rules.corop_area
    corop_area_code = general_rules.corop_area
    dropouts = Dropouts(missing=True)
    dropouts_reference_date = SchemaNode(Date(), missing=True)
    dropouts_reference_url = general_rules.reference_url
    education_area = general_rules.education_area
    education_area_code = general_rules.education_area_code
    education_structures = general_rules.EducationStructures()
    municipality = general_rules.municipality
    municipality_code = general_rules.municipality_code
    nodal_area = general_rules.nodal_area
    nodal_area_code = general_rules.nodal_area_code
    phone = general_rules.phone
    province = general_rules.province
    reference_year = general_rules.reference_year
    rmc_region = general_rules.rmc_region
    rmc_region_code = general_rules.rmc_region_code
    rpa_area = general_rules.rpa_area
    rpa_area_code = general_rules.rpa_area_code
    website = general_rules.url
    wgr_area = general_rules.wgr_area
    wgr_area_code = general_rules.wgr_area_code

    # TODO:
    #students_prognosis = StudentPrognosis()
    students_prognosis_reference_date = SchemaNode(Date(), missing=True)
    students_prognosis_url = general_rules.website

    vo_lo_collaboration_reference_url = general_rules.website
    vo_lo_collaboration_reference_date = SchemaNode(Date(), missing=True)
    vo_lo_collaboration = general_rules.collaboration_id

    pao_collaboration_reference_url = general_rules.website
    pao_collaboration_reference_date = SchemaNode(Date(), missing=True)
    pao_collaboration = general_rules.collaboration_id
Exemple #8
0
class OnderwijsInspectieVoBranch(MappingSchema):
    name = general_rules.name
    brin = general_rules.brin
    denomination = general_rules.denomination
    education_structures = general_rules.EducationStructures()
    branch_id = general_rules.branch_id
    board_id = general_rules.board_id
    address = general_rules.Address()
    website = general_rules.url
    result_card_url = general_rules.url
    reports = Reports()
    rating_history = RatingHistory()
    current_ratings = CurrentRatings()
    board = general_rules.name
Exemple #9
0
class DuoPoSchool(MappingSchema):
    address = general_rules.Address()
    correspondence_address = general_rules.Address()
    board_id = general_rules.board_id
    brin = general_rules.brin
    denomination = general_rules.denomination
    corop_area = general_rules.corop_area
    corop_area_code = general_rules.corop_area
    education_area = general_rules.education_area
    education_area_code = general_rules.education_area_code
    municipality = general_rules.municipality
    municipality_code = general_rules.municipality_code
    name = general_rules.name
    nodal_area = general_rules.nodal_area
    nodal_area_code = general_rules.nodal_area_code
    phone = general_rules.phone
    province = general_rules.province
    reference_year = general_rules.reference_year
    rmc_region = general_rules.rmc_region
    rmc_region_code = general_rules.rmc_region_code
    rpa_area = general_rules.rpa_area
    rpa_area_code = general_rules.rpa_area_code
    website = general_rules.website
    wgr_area = general_rules.wgr_area
    wgr_area_code = general_rules.wgr_area_code

    spo_students_per_cluster = SPOStudentsPerCluster()
    spo_students_per_cluster_reference_date = SchemaNode(Date(), missing=True)
    spo_students_per_cluster_reference_url = general_rules.website

    po_lo_collaboration_reference_url = general_rules.website
    po_lo_collaboration_reference_date = SchemaNode(Date(), missing=True)
    po_lo_collaboration = general_rules.collaboration_id

    pao_collaboration_reference_url = general_rules.website
    pao_collaboration_reference_date = SchemaNode(Date(), missing=True)
    pao_collaboration = general_rules.collaboration_id
class OnderwijsInspectiePoBranch(MappingSchema):
    address = general_rules.Address(title="Address of this branch")
    board_id = general_rules.board_id()
    branch_id = general_rules.branch_id()
    brin = general_rules.brin(
        title=
        "'Basis Registratie Instellingen-nummer', identifier of the school this branch belongs to. Alphanumeric, four characters long."
    )
    current_rating = CurrentRating()
    denomination = general_rules.denomination(
        title=
        "In the Netherlands, schools can be based on a (religious [#denomination]_) conviction, which is denoted here."
    )
    name = general_rules.name(title="Name of this branch.")
    rating_history = RatingHistory(
        title=
        "Array of :ref:`owinsprathist`, where each item represents a rating the Onderwijsinspectie [#owinsp]_ awarded to this branch."
    )
    reports = Reports(
        title=
        "Array of :ref:`owinspreport`, where each item represents a report of the Onderwijsinspectie [#owinsp]_ in PDF."
    )
    website = general_rules.url(title="Website of this branch (optional).")
class SchoolVOBranch(MappingSchema):
    address = general_rules.Address(title="Address of the branch.")
    avg_education_hours_per_student = AverageEducationHours(
        title=
        "Array of :ref:`eduhours`, representing how many hours of education were planned for a year, and how many are actually realised."
    )
    avg_education_hours_per_student_url = SchemaNode(
        String(), validator=url, title="URL to the *Onderwijstijd* page.")
    board = SchemaNode(String(),
                       validator=Length(min=3, max=100),
                       title="The name of the board of this school.")
    board_id = general_rules.board_id(
        title=
        "Identifier (assigned by :ref:`duodata`) of the board of this branch.")
    branch_id = general_rules.branch_id(
        title="Identifier (assigned by :ref:`duodata`) of this branch.")
    brin = general_rules.brin(
        title=
        "'Basis Registratie Instellingen-nummer', identifier of the school this branch belongs to. Alphanumeric, four characters long."
    )
    building_img_url = SchemaNode(
        String(),
        validator=url,
        title="URL to a photo of the building of this branch.")
    costs = Costs(
        title=
        "Object representing the costs a parent can expect for this branch.")
    costs_url = SchemaNode(String(),
                           validator=url,
                           title="URL to the *Onderwijskosten* page.")
    denomination = general_rules.denomination(
        title=
        "In the Netherlands, schools can be based on a (religious [#denomination]_) conviction, which is denoted here."
    )
    education_structures = general_rules.EducationStructures(
        title=
        "An array of strings, where each string represents the level of education [#edu_in_holland]_ (education structure) that is offered at this school."
    )
    email = SchemaNode(String(),
                       validator=Email(),
                       title="Email address of this branch.")
    logo_img_url = SchemaNode(
        String(),
        validator=url,
        title="URL to a photo of the logo of the school of this branch.")
    municipality = general_rules.municipality(
        title="The name of the municipality this branch is located in.")
    municipality_id = general_rules.municipality_code()
    name = general_rules.name(title="Name of the branch of this school.")
    parent_satisfaction = Satisfactions(title="Satisfaction polls of parents.")
    parent_satisfaction_url = SchemaNode(
        String(),
        validator=url,
        title="URL to the *Tevredenheid ouders* page.")
    phone = general_rules.phone(
        title=
        "Unnormalised string representing the phone number of this branch.")
    profile = SchemaNode(
        String(),
        validator=Length(min=3, max=500),
        title="Short description of the motto of this branch.")
    province = general_rules.province(
        title="The province [#provinces]_ this branch is situated in.")
    schoolkompas_status_id = SchemaNode(
        Int(),
        validator=Range(min=0, max=1000),
        title="Identifier used at http://schoolkompas.nl. Use unknown.")
    schoolvo_code = SchemaNode(
        String(),
        validator=Length(min=14, max=14),
        title=
        "Identifier used at http://schoolvo.nl. Consists of the board_id, brin and branch_id, separated by dashes. A school page can be accessed at `http://schoolvo.nl/?p_schoolcode=`\ *<schoolvo_code>*."
    )
    student_satisfaction = Satisfactions(
        title="Satisfaction polls of students.")
    student_satisfaction_url = SchemaNode(
        String(),
        validator=url,
        title="URL to the *Tevredenheid leerlingen* page.")
    website = general_rules.website(title="URL of the website of the school.")
Exemple #12
0
class DuoPaoCollaboration(MappingSchema):
    address = general_rules.Address()
    correspondence_address = general_rules.Address()
    collaboration_id = general_rules.collaboration_id
    reference_year = general_rules.reference_year
Exemple #13
0
class DuoPoBranch(MappingSchema):
    address = general_rules.Address()
    # TODO:
    #ages_per_branch_by_student_weight = AgesPerBranchByStudentWeight()
    ages_per_branch_by_student_weight_reference_date = SchemaNode(Date(),
        missing=True)
    ages_per_branch_by_student_weight_reference_url = general_rules.website
    correspondence_address = general_rules.Address()
    name = general_rules.name
    branch_id = general_rules.branch_id
    board_id = general_rules.board_id
    brin = general_rules.brin
    corop_area = general_rules.corop_area
    corop_area_code = general_rules.corop_area_code
    denomination = general_rules.denomination
    education_area = general_rules.education_area
    education_area_code = general_rules.education_area_code
    municipality = general_rules.municipality
    municipality_code = general_rules.municipality_code
    nodal_area = general_rules.nodal_area
    nodal_area_code = general_rules.nodal_area_code
    phone = general_rules.phone
    province = general_rules.province
    # TODO:
    #pupils_by_origins = PupilsByOrigins()
    pupils_by_origins_reference_date = SchemaNode(Date(), missing=True)
    pupils_by_origins_reference_url = general_rules.website
    # TODO:
    #pupil_residences = PupilResidences()
    pupil_residences_reference_date = SchemaNode(Date(), missing=True)
    pupil_residences_reference_url = general_rules.website
    reference_year = general_rules.reference_year
    rmc_region = general_rules.rmc_region
    rmc_region_code = general_rules.rmc_region_code
    rpa_area = general_rules.rpa_area
    rpa_area_code = general_rules.rpa_area_code
    website = general_rules.url

    # TODO:
    #weights_per_school = WeightsPerSchool()
    weights_per_school_reference_date = SchemaNode(Date(), missing=True)
    weights_per_school_reference_url = general_rules.website
    
    wgr_area = general_rules.wgr_area
    wgr_area_code = general_rules.wgr_area_code

    # TODO:
    #student_year = StudentsByYear()
    student_year_reference_date = SchemaNode(Date(), missing=True)
    student_year_reference_url = general_rules.website
    
    spo_law = SchemaNode(String(), validator=Length(min=2, max=4))
    spo_edu_type = SchemaNode(String()) # possibly multiple with slash
    spo_cluster = SchemaNode(Int(), validator=Range(min=0, max=4))
    
    spo_students_by_birthyear_reference_url = general_rules.website
    spo_students_by_birthyear_reference_date = SchemaNode(Date(), missing=True)
    spo_students_by_birthyear = SPOStudentsByBirthyear()

    
    spo_students_by_edu_type_reference_url = general_rules.website
    spo_students_by_edu_type_reference_date = SchemaNode(Date(), missing=True)
    spo_students_by_edu_type = SPOStudentsByEduType()

    students_by_advice_reference_url = general_rules.website
    students_by_advice_reference_date = SchemaNode(Date(), missing=True)
    students_by_advice = StudentsByAdvice()