Versions Compared

Old Version 16

changes.mady.by.user Kim Stimpson

Saved on

compared with

New Version Current

changes.mady.by.user Kim Stimpson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

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

Image Modified

 


Code Block
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


Image Modified

Primary Schools

Image Modified

 

Code Block
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


Image Modified

Secondary Schools

Image Modified

 


Code Block
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


Image Modified

Higher Education

Image Modified

 

 


Code Block
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


Image Modified