random-test-data.sql

--
-- Polygons in contained in a 10000x10000 
-- square, with just enough size/density to mostly 
-- cover the whole area.
--
DROP TABLE IF EXISTS polygon_table_10000;
CREATE TABLE polygon_table_10000 AS
SELECT ST_Buffer(
    ST_SetSRID(
        ST_MakePoint(random() * 10000, random() * 10000), 
        26910),
        100,32)::geometry(polygon, 26910) AS geom,
generate_series(0, 9999) as id;

--
-- Lines in the 10000x10000 square, we need
-- more of them to generate load because they 
-- are much smaller than the polygons.
--
DROP TABLE IF EXISTS line_table_100000;
CREATE TABLE line_table_100000 AS
SELECT id, ST_SetSRID(ST_MakeLine(
    ST_MakePoint(x1, y1), 
    ST_MakePoint(x1+(0.5-random())*200, y1+(0.5-random())*200)
    ),26910) AS geom
    FROM 
    (SELECT random() * 10000 AS x1, random() * 10000 AS y1, generate_series(0, 99999) as id) a;

--
-- Points in the 10000x10000 square, we need
-- even more of them to generate load because they 
-- are much smaller than the lines.
--
DROP TABLE IF EXISTS pt_table_1000000;
CREATE TABLE pt_table_1000000 AS
SELECT id, ST_SetSRID(ST_MakePoint(x1, y1),26910) AS geom
    FROM 
    (SELECT random() * 10000 AS x1, random() * 10000 AS y1, generate_series(0, 999999) as id) a;