 -- social security, hazard and outcome information
 CREATE TABLE zaf.tbl_ofa_sas (
 	tid serial primary key,
+	the_geom geometry(multipolygon, 201100),
 -- year and month of analysis (unique to each analysis event)
 	ofa_year integer,
 	ofa_month integer,

					"56202: North-central upland cereals and non-farm income (NAUCI)" NUMERIC,
					"56203: Caprivi lowland maize and cattle (NALMC)" NUMERIC
				)
/*	)
TO
	'/Users/Charles/Documents/hea_analysis/namibia/2016.05/pop/outcome_xtab.csv'
WITH (
	FORMAT CSV, DELIMITER ',', HEADER TRUE
	)*/
;

			AND
				hazard = 'Not affected'
;
*/
COMMIT;


/*
--Transaction to present the data in a file and on StdOut
BEGIN;

