-------------------------------------------------------------------------------

drop table if exists tbl_geompoint;
create table tbl_geompoint as
select k, random_geompoint(0, 100, 0, 100) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geompointz;
create table tbl_geompointz as
select k, random_geompointz(0, 100, 0, 100, 0, 100) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geompointm;
create table tbl_geompointm as
select k, random_geompointm(0, 100, 0, 100, 0, 100) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geompointzm;
create table tbl_geompointzm as
select k, random_geompointzm(0, 100, 0, 100, 0, 100, 0, 100) as g
from generate_series(1,1e3) k;

-------------------------------------------------------------------------------

drop table if exists tbl_geomlinestring;
create table tbl_geomlinestring as
select k, random_geomlinestring(0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geomlinestringz;
create table tbl_geomlinestringz as
select k, random_geomlinestringz(0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geomlinestringm;
create table tbl_geomlinestringm as
select k, random_geomlinestringm(0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geomlinestringzm;
create table tbl_geomlinestringzm as
select k, random_geomlinestringzm(0, 100, 0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

-------------------------------------------------------------------------------

drop table if exists tbl_geompolygon;
create table tbl_geompolygon as
select k, random_geompolygon(0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geompolygonz;
create table tbl_geompolygonz as
select k, random_geompolygonz(0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geompolygonm;
create table tbl_geompolygonm as
select k, random_geompolygonm(0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geompolygonzm;
create table tbl_geompolygonzm as
select k, random_geompolygonzm(0, 100, 0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

-------------------------------------------------------------------------------

drop table if exists tbl_geommultipoint;
create table tbl_geommultipoint as
select k, random_geommultipoint(0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultipointz;
create table tbl_geommultipointz as
select k, random_geommultipointz(0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultipointm;
create table tbl_geommultipointm as
select k, random_geommultipointm(0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultipointzm;
create table tbl_geommultipointzm as
select k, random_geommultipointzm(0, 100, 0, 100, 0, 100, 0, 100, 10) as g
from generate_series(1,1e3) k;

-------------------------------------------------------------------------------

drop table if exists tbl_geommultilinestring;
create table tbl_geommultilinestring as
select k, random_geommultilinestring(0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultilinestringz;
create table tbl_geommultilinestringz as
select k, random_geommultilinestringz(0, 100, 0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultilinestringm;
create table tbl_geommultilinestringm as
select k, random_geommultilinestringm(0, 100, 0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultilinestringzm;
create table tbl_geommultilinestringzm as
select k, random_geommultilinestringzm(0, 100, 0, 100, 0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

-------------------------------------------------------------------------------

drop table if exists tbl_geommultipolygon;
create table tbl_geommultipolygon as
select k, random_geommultipolygon(0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultipolygonz;
create table tbl_geommultipolygonz as
select k, random_geommultipolygonz(0, 100, 0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultipolygonm;
create table tbl_geommultipolygonm as
select k, random_geommultipolygonm(0, 100, 0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

drop table if exists tbl_geommultipolygonzm;
create table tbl_geommultipolygonzm as
select k, random_geommultipolygonzm(0, 100, 0, 100, 0, 100, 0, 100, 10, 10) as g
from generate_series(1,1e3) k;

-------------------------------------------------------------------------------

drop table if exists tbl_geomcollection_nd;
create table tbl_geomcollection_nd (
	k serial,
	g geometry
);
insert into tbl_geomcollection_nd (g)
(select g from tbl_geompoint limit 100) union
(select g from tbl_geompointz limit 100) union
(select g from tbl_geompointm limit 100) union
(select g from tbl_geompointzm limit 100) union
(select g from tbl_geomlinestring limit 100) union
(select g from tbl_geomlinestringz limit 100) union
(select g from tbl_geomlinestringm limit 100) union
(select g from tbl_geomlinestringzm limit 100) union
(select g from tbl_geompolygon limit 100) union
(select g from tbl_geompolygonz limit 100) union
(select g from tbl_geompolygonm limit 100) union
(select g from tbl_geompolygonzm limit 100) union
(select g from tbl_geommultipoint limit 100) union
(select g from tbl_geommultipointz limit 100) union
(select g from tbl_geommultipointm limit 100) union
(select g from tbl_geommultipointzm limit 100) union
(select g from tbl_geommultilinestring limit 100) union
(select g from tbl_geommultilinestringz limit 100) union
(select g from tbl_geommultilinestringm limit 100) union
(select g from tbl_geommultilinestringzm limit 100) union
(select g from tbl_geommultipolygon limit 100) union
(select g from tbl_geommultipolygonz limit 100) union
(select g from tbl_geommultipolygonm limit 100) union
(select g from tbl_geommultipolygonzm limit 100) ;

-------------------------------------------------------------------------------
