...
You may copy the following Snippets into your .MAP file using the Map Editor in Studio.
| Note |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| Code Block |
|---|
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 |
| |
...
