LAYER

		NAME "preparkplanapps"

		#CONNECTIONTYPE OGR

		#CONNECTION "DevelopmentHistory/preparkplanapps.tab"

		CONNECTIONTYPE POSTGIS

		CONNECTION "dbname=iShareDataNFNP_Live user=postgres password=spatial"

		DATA "wkb_geometry from (select * from _preparkplanapps where st_intersects(wkb_geometry, (select wkb_geometry from address_polygons where uprn::text = '%qstr%') ) ) as apps using unique ogc_fid using srid=27700"

		PROCESSING "CLOSE_CONNECTION=DEFER"

		METADATA

			"qstring_validation_pattern" "."

			"qstr_validation_pattern" "."

		END

		TYPE POLYGON

		STATUS OFF

		LABELITEM "caseref"

		CLASS

			STYLE

				OUTLINECOLOR 30 30 120

				WIDTH 1

			END

			LABEL

				COLOR 30 30 120

				OUTLINECOLOR 255 255 255

				OUTLINEWIDTH 3

				BUFFER 12

				ALIGN center

				FONT "trebucbd"

				TYPE truetype

				SIZE 12

				PARTIALS FALSE

				MAXLENGTH 10

				WRAP ' '

			END

		END

	END