Update .MAP file for EduBase Classic Layers

Owned by Kim Stimpson
Last updated: 16 Feb, 2017

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