-- The ST_AsText function converts the hazardous_sites location point
-- into its text description.

CREATE TABLE hazardous_sites (site_id   integer,
                              name      varchar(40),
                              location  ST_Point);

INSERT INTO hazardous_sites VALUES(
     102, 'W. H. Kleenare Chemical Repository',
     ST_PointFromText('point (1020.12 324.02)',1000)
);

SELECT site_id, name, ST_AsText(location) Location
   FROM hazardous_sites;
