For each Police 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.

The examples below use pg_police.inc to specify the database connection details. You may need to change the INCLUDE value to specify your database connection details.

Police Layers

Layer Name	Snippet	Thumb
StreetCrimeCrosstab	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
StreetCrimeCluster	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
StreetCrime	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
StreetOutcomes	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
Neighbourhood_Teams	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
Neighbourhood_Events	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
Neighbourhood_Crimes	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
Neighbourhood_Boundaries	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
Police Stations	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