CREATE TABLE public.pop_places
(
  gid integer NOT NULL DEFAULT nextval('pop_places_gid_seq'::regclass),
  name character varying(254),
  iso_cc character varying(4),
  type character varying(30),
  rank smallint,
  population character varying(30),
  geom geometry(Point),
  CONSTRAINT pop_places_pkey PRIMARY KEY (gid)
)

CREATE TABLE public.airports
(
  gid integer NOT NULL DEFAULT nextval('airports_gid_seq'::regclass),
  iso_cc character varying(4),
  name character varying(100),
  icao character varying(5),
  iata character varying(5),
  geom geometry(Point,4326),
  CONSTRAINT airports_pkey PRIMARY KEY (gid)
)

CREATE TABLE public.admin
(
  gid integer NOT NULL DEFAULT nextval('admin_gid_seq'::regclass),
  name character varying(44),
  country character varying(50),
  iso_code character varying(6),
  iso_cc character varying(2),
  iso_sub character varying(5),
  admintype character varying(50),
  disputed integer,
  notes character varying(254),
  autonomous integer,
  countryaff character varying(100),
  continent character varying(13),
  land_type character varying(20),
  land_rank integer,
  geom geometry(MultiPolygon,4326),
  CONSTRAINT admin_pkey PRIMARY KEY (gid)
)