Update .MAP file for Police layers

	LAYER
		METADATA
			 WMS_TITLE "Street Crime Crosstab"
			 WFS_TITLE "Street Crime Crosstab"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "All crimes reported at street level in the given month with one record per location"
			 "wms_abstract" "All crimes reported at street level in the given month with one record per location"
		END
		NAME "StreetCrimeCrosstab"
		GROUP Police
		DUMP TRUE
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA 'wkb_geometry FROM streetcrime_crosstab USING UNIQUE ogc_fid  USING SRID=27700'
		TYPE POINT
		CLASS
			STYLE
				SYMBOL "circle"
				COLOR 255 0 0
				SIZE 8
			END
		END
	END

LAYER
		# Optional layer for displaying street crimes as a cluster with size proportional to the number of crimes, for display purposes only
		METADATA
			 WMS_TITLE "Street Crime Cluster"
			 WFS_TITLE "Street Crime Cluster"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "All crimes reported at street level in the given month with one record per location, clustered"
			 "wms_abstract" "All crimes reported at street level in the given month with one record per location, clustered"
		END
		NAME "StreetCrimeCluster"
		GROUP Police
		REQUIRES "[StreetCrime]" # will only display when street crimes layer is activated
		DUMP TRUE
		STATUS DEFAULT
		INCLUDE "pg_police.inc"
		DATA 'wkb_geometry FROM street_crimes USING UNIQUE ogc_fid  USING SRID=27700'
		TYPE POINT
		CLUSTER
			MAXDISTANCE 50
			REGION "ellipse"
		END
		LABELITEM "Cluster:FeatureCount"
		CLASS
			NAME "Street Crime Clusters"
			STYLE
				SYMBOL "circle"
				COLOR 0 0 255
				SIZE [Cluster:FeatureCount]
				MINSIZE 10
				MAXSIZE 30
				OPACITY 30
			END
			LABEL
				FONT arial
				TYPE TRUETYPE
				SIZE 7
				COLOR 255 255 255
				ALIGN CENTER
				PRIORITY 10
				BUFFER 1
				PARTIALS TRUE
				POSITION CC
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Street Crime"
			 WFS_TITLE "Street Crime"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "All crimes reported at street level in the given month with one record per crime"
			 "wms_abstract" "All crimes reported at street level in the given month with one record per crime"
		END
		NAME "StreetCrime"
		GROUP Police
		DUMP TRUE
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA 'wkb_geometry FROM street_crimes USING UNIQUE ogc_fid  USING SRID=27700'
		TYPE POINT
		CLASSITEM "crime_type"
		CLASS
			NAME "Crime clusters"
			MAXSCALEDENOM 1
			STYLE
				SYMBOL "circle"
				SIZE 15
				COLOR 0 0 255
				OPACITY 30
			END
		END
		CLASS
			NAME "Bicycle Theft"
			EXPRESSION "Bicycle Theft"
			STYLE
				SYMBOL "circle"
				OUTLINECOLOR 95 30 95
				SIZE 8
			END
		END
		CLASS
			NAME "Burglary"
			EXPRESSION "Burglary"
			STYLE
				SYMBOL "circle"
				COLOR 255 0 0
				SIZE 6
			END
		END
		CLASS
			NAME "Criminal damage and arson"
			EXPRESSION "Criminal damage and arson"
			STYLE
				SYMBOL "circle"
				COLOR 135 30 155
				SIZE 6
			END
		END
		CLASS
			NAME "Drugs"
			EXPRESSION "Drugs"
			STYLE
				SYMBOL "circle"
				COLOR 0 255 255
				SIZE 6
			END
		END
		CLASS
			NAME "Other crime"
			EXPRESSION "Other crime"
			STYLE
				SYMBOL "circle"
				COLOR 132 0 0
				SIZE 6
			END
		END
		CLASS
			NAME "Other theft"
			EXPRESSION "Other theft"
			STYLE
				SYMBOL "circle"
				COLOR 102 51 0
				SIZE 6
			END
		END
		CLASS
			NAME "Possession of weapons"
			EXPRESSION "Possession of weapons"
			STYLE
				SYMBOL "circle"
				COLOR 102 102 255
				SIZE 6
			END
		END
		CLASS
			NAME "Public order"
			EXPRESSION "Public order"
			STYLE
				SYMBOL "circle"
				COLOR 255 255 0
				SIZE 6
			END
		END
		CLASS
			NAME "Robbery"
			EXPRESSION "Robbery"
			STYLE
				SYMBOL "circle"
				COLOR 204 102 0
				SIZE 6
			END
		END
		CLASS
			NAME "Shoplifting"
			EXPRESSION "Shoplifting"
			STYLE
				SYMBOL "circle"
				COLOR 0 0 153
				SIZE 6
			END
		END
		CLASS
			NAME "Theft from the person"
			EXPRESSION "Theft from the person"
			STYLE
				SYMBOL "circle"
				COLOR 96 96 96
				SIZE 6
			END
		END
		CLASS
			NAME "Vehicle crime"
			EXPRESSION "Vehicle crime"
			STYLE
				SYMBOL "circle"
				COLOR 0 153 0
				SIZE 6
			END
		END
		CLASS
			NAME "Violence and sexual offences"
			EXPRESSION "Violence and sexual offences"
			STYLE
				SYMBOL "circle"
				COLOR 102 0 102
				SIZE 6
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Street Outcomes"
			 WFS_TITLE "Street Outcomes"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "All crime outcomes reported at street level in the given month"
			 "wms_abstract" "All crime outcomes reported at street level in the given month"
		END
		NAME "StreetOutcomes"
		GROUP Police
		DUMP TRUE
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA 'wkb_geometry FROM street_outcomes USING UNIQUE ogc_fid  USING SRID=27700'
		TYPE POINT
		CLASS
			STYLE
				SYMBOL "circle"
				OUTLINECOLOR 95 30 155
				SIZE 8
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Neighbourhood Teams"
			 WFS_TITLE "Neighbourhood Teams"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "Police Neighbourhood Team Members"
			 "wms_abstract" "Police Neighbourhood Team Members"
		END
		NAME "Neighbourhood_Teams"
		GROUP Police
		DUMP TRUE
		STATUS OFF
		INCLUDE "pg_police.inc"
				DATA "wkb_geometry from (select * from police_neighb_teams) as subquery using unique ogc_fid using srid=27700"
		TYPE POLYGON
		CLASS
			NAME ''
			STYLE
				OUTLINECOLOR 0 0 255
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Neighbourhood Events"
			 WFS_TITLE "Neighbourhood Events"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "Police Neighbourhood Events"
			 "wms_abstract" "Police Neighbourhood Events"
		END
		NAME "Neighbourhood_Events"
		GROUP Police
		DUMP TRUE
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA 'wkb_geometry from neighbourhood_events USING UNIQUE ogc_fid  USING SRID=27700'
		TYPE POINT
		CLASS
			STYLE
				SYMBOL "police2"
				SIZE 12
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Neighbourhood Crimes"
			 WFS_TITLE "Neighbourhood Crimes"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "All crimes reported per neighbourhood in the given month, mapped to boundary polygon"
			 "wms_abstract" "All crimes reported per neighbourhood in the given month, mapped to boundary polygon"
		END
		NAME "Neighbourhood_Crimes" #ok
		GROUP Police
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA 'wkb_geometry from neighbourhood_crimes USING UNIQUE ogc_fid  USING SRID=27700'
		TYPE POLYGON
		CLASS
			STYLE
				COLOR 54 106 217
				OUTLINECOLOR 41 30 155
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Neighbourhood Boundaries"
			 WFS_TITLE "Neighbourhood Boundaries"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "Police neighbourhood boundary polygons"
			 "wms_abstract" "Police neighbourhood boundary polygons"
		END
		NAME "Neighbourhood_Boundaries"
		GROUP Police
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA "wkb_geometry FROM neighbourhood_boundaries USING UNIQUE ogc_fid  USING SRID=27700"
		TYPE POLYGON
		CLASS
			NAME "Police Neighbourhood Boundaries"
			STYLE
				OUTLINECOLOR 36 11 59
			END
		END
	END

LAYER
		METADATA
			 WMS_TITLE "Police Stations"
			 WFS_TITLE "Police Stations"
			 "gml_featureid" "ogc_fid"
			 "gml_include_items" "all"
			 "wfs_abstract" "Police station locations"
			 "wms_abstract" "Police station locations"
		END
		NAME "Police_Stations"
		GROUP Police
		STATUS OFF
		INCLUDE "pg_police.inc"
		DATA "wkb_geometry FROM (select row_number() OVER() as ogc_fid, * from (select distinct name, address, postcode,type, description, wkb_geometry, force from neighbourhood_locations group by name, address, postcode,type, description, wkb_geometry, force) as subquery2) as subquery USING UNIQUE ogc_fid  USING SRID=27700"
		TYPE POINT
		CLASS
			NAME "Police Station Locations"
			STYLE
				SYMBOL "Police"
				SIZE 12
			END
		END
	END