Update .MAP file for EduBase Classic Layers
This is only required if you are using the old Classic Layers.
For each EduBase layer you wish to display you will need to add a LAYER entry into the .MAP file.
You may copy the following Snippets into your .MAP file using the Map Editor in Studio and modify them to meet your requirements.
In Version 2 there are columns for open_date and close_date which may be useful as well as establishment_status, so you could use establishment_status = 'Open' as part of your select statement.
EduBase
Description | Snippet | Thumb |
|---|---|---|
Nursery Schools 
| LAYER
NAME nurseryschools
STATUS off
TYPE POINT
INCLUDE "datashare.inc"
DATA "wkb_geometry from (select * from edubase where phase_of_education_name = 'Nursery') as foo using unique ogc_fid using srid=27700"
TOLERANCEUNITS METERS
METADATA
"qstring_validation_pattern" "."
ows_title "Nursery Schools"
END
CLASS
NAME ""
STYLE
SYMBOL "nurseries2"
END
END
END | |
Primary Schools |
LAYER
NAME primaryschools
STATUS off
TYPE POINT
INCLUDE "datashare.inc"
DATA "wkb_geometry from (select * from edubase where (phase_of_education_name = 'Primary' or phase_of_education_name = 'Middle deemed Primary')) as foo using unique ogc_fid using srid=27700"
TOLERANCEUNITS METERS
METADATA
"qstring_validation_pattern" "."
ows_title "Primary Schools"
END
CLASS
NAME ""
STYLE
SYMBOL "primary3"
END
END
END
| |
Secondary Schools
| LAYER
NAME secondaryschools
STATUS off
TYPE POINT
INCLUDE "datashare.inc"
DATA "wkb_geometry from (select * from edubase where (phase_of_education_name = 'Secondary' or phase_of_education_name = 'Middle deemed Secondary')) as foo using unique ogc_fid using srid=27700"
TOLERANCEUNITS METERS
METADATA
"qstring_validation_pattern" "."
ows_title "Secondary Schools"
END
CLASS
NAME ""
STYLE
SYMBOL "secondary2"
END
END
END | |
Higher Education
| LAYER
NAME highereducation
STATUS off
TYPE POINT
INCLUDE "datashare.inc"
DATA "wkb_geometry from (select * from edubase where phase_of_education_name = '16 Plus') as foo using unique ogc_fid using srid=27700"
TOLERANCEUNITS METERS
METADATA
"qstring_validation_pattern" "."
ows_title "Higher Education"
END
CLASS
NAME ""
STYLE
SYMBOL "highereducation2"
END
END
END | |