Skip to content

Instantly share code, notes, and snippets.

@dbauszus-glx
Created November 30, 2018 12:26
Show Gist options
  • Save dbauszus-glx/1815ac64693665f7b1f929ecaeb5748b to your computer and use it in GitHub Desktop.
Save dbauszus-glx/1815ac64693665f7b1f929ecaeb5748b to your computer and use it in GitHub Desktop.
create table if not exists natural_earth_countries__mvts
(
z integer not null,
x integer not null,
y integer not null,
mvt bytea,
tile geometry(Polygon,3857),
constraint dev_natural_earth_countries__mvts_z_x_y_pk
primary key (z, x, y)
)
;
create index if not exists dev_natural_earth_countries__mvts_z_x_y_idx
on natural_earth_countries__mvts (z, x, y)
;
create index if not exists dev_natural_earth_countries__mvts_tile
on natural_earth_countries__mvts (tile)
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment