--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

--
-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;


ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: a_pour_parent; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE a_pour_parent (
    code_observatoire character varying(6) NOT NULL,
    fils_sheet_id integer NOT NULL,
    pere_sheet_id integer NOT NULL
);


ALTER TABLE public.a_pour_parent OWNER TO postgres;

--
-- Name: archive_zip; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE archive_zip (
    code_observatoire character varying(6) NOT NULL,
    mtd_sheet_id integer NOT NULL,
    nom_archive character varying(100) NOT NULL,
    taille character varying(30),
    date_maj date,
    heure_maj character varying(30),
    etat_telecharg character varying(6)
);


ALTER TABLE public.archive_zip OWNER TO postgres;

--
-- Name: attrib_elmnt_gabarit; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE attrib_elmnt_gabarit (
    elmnt_mtd_id character varying(50) NOT NULL,
    attrib_name character varying(50) NOT NULL,
    default_value character varying,
    gabarit_name character varying(50) NOT NULL
);


ALTER TABLE public.attrib_elmnt_gabarit OWNER TO postgres;

--
-- Name: attrib_elmnt_mtd; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE attrib_elmnt_mtd (
    elmnt_mtd_id character varying(50) NOT NULL,
    attrib_name character varying(50) NOT NULL,
    default_value character varying
);


ALTER TABLE public.attrib_elmnt_mtd OWNER TO postgres;

--
-- Name: code_list; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE code_list (
    list_short_name character varying(25) NOT NULL,
    list_name character varying(50) NOT NULL,
    is_stand character varying(5) NOT NULL,
    elmnt_name_list character varying(50)
);


ALTER TABLE public.code_list OWNER TO postgres;

--
-- Name: contact_catalogue; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE contact_catalogue (
    id_orga integer NOT NULL,
    nom_orga character varying(200) NOT NULL,
    "role" character varying(50),
    adress_postale character varying(200),
    code_postal character varying(20),
    ville character varying(50),
    pays character varying(50),
    email character varying(100),
    url_orga character varying(200),
    url_catalog character varying(200)
);


ALTER TABLE public.contact_catalogue OWNER TO postgres;

--
-- Name: contacts; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE contacts (
    nom character varying(50) NOT NULL,
    organisation character varying(50),
    phone character varying(20),
    address character varying(250),
    postal_code character varying(50),
    city character varying(50),
    country character varying(50),
    email character varying(50),
    url character varying(250),
    "position" character varying(250),
    prenom character varying(250)
);


ALTER TABLE public.contacts OWNER TO postgres;

--
-- Name: db_version; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE db_version (
    version_name character varying(50) NOT NULL,
    version_date character varying(50) NOT NULL,
    revision_number integer NOT NULL,
    comments character varying
);


ALTER TABLE public.db_version OWNER TO postgres;

--
-- Name: elmnt_code_list; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE elmnt_code_list (
    elmnt_id character varying(40) NOT NULL,
    list_short_name character varying(25) NOT NULL,
    elmnt_name character varying(50) NOT NULL,
    elmnt_code character varying(20),
    is_stand character varying(5)
);


ALTER TABLE public.elmnt_code_list OWNER TO postgres;

--
-- Name: elmnt_gabarit; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE elmnt_gabarit (
    gabarit_name character varying(50) NOT NULL,
    elmnt_mtd_id character varying(50) NOT NULL,
    mandt_code_gab character varying(5) NOT NULL,
    niv_saisie integer,
    max_occ_gab character varying(3) NOT NULL,
    default_val character varying(100),
    num_elmnt_gab character varying(250),
    visibilite integer,
    consult integer,
    visu_consult integer,
    contact character varying(2),
    style character varying(5)
);


ALTER TABLE public.elmnt_gabarit OWNER TO postgres;

--
-- Name: elmnt_liste_interface; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE elmnt_liste_interface (
    elmnt_interf character varying(50) NOT NULL,
    nom_liste character varying(50) NOT NULL,
    code_elmnt character varying(50) NOT NULL
);


ALTER TABLE public.elmnt_liste_interface OWNER TO postgres;

--
-- Name: elmnt_mtd; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE elmnt_mtd (
    elmnt_mtd_id character varying(50) NOT NULL,
    elmnt_name character varying(50) NOT NULL,
    elmnt_short_name character varying(20) NOT NULL,
    stan_name character varying(25) NOT NULL,
    list_short_name character varying(50),
    data_type_code character varying(10) NOT NULL,
    mandt_code character varying(5) NOT NULL,
    max_occ character varying(3) NOT NULL,
    is_core character varying(5),
    is_stand character varying(5),
    data_type character varying(50)
);


ALTER TABLE public.elmnt_mtd OWNER TO postgres;

--
-- Name: est_contenu; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE est_contenu (
    elmnt_fils_id character varying(50) NOT NULL,
    elmnt_pere_id character varying(50) NOT NULL,
    gabarit_name character varying(50) NOT NULL,
    ordre integer NOT NULL
);


ALTER TABLE public.est_contenu OWNER TO postgres;

--
-- Name: est_inclus; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE est_inclus (
    elmnt_fils_id character varying(50) NOT NULL,
    elmnt_pere_id character varying(50) NOT NULL,
    ordre integer
);


ALTER TABLE public.est_inclus OWNER TO postgres;

--
-- Name: fichier_image; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE fichier_image (
    mtd_sheet_id integer NOT NULL,
    code_observatoire character varying(6) NOT NULL,
    nom_fichier character varying(100),
    "type" character varying(5),
    taille character varying(30),
    date_image character varying(10),
    description character varying(50)
);


ALTER TABLE public.fichier_image OWNER TO postgres;

--
-- Name: fichier_ressource; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE fichier_ressource (
    code_observatoire character varying(6) NOT NULL,
    mtd_sheet_id integer NOT NULL,
    id_fichier integer NOT NULL,
    nom_fichier character varying(100) NOT NULL,
    "type" character varying(3),
    taille character varying(30)
);


ALTER TABLE public.fichier_ressource OWNER TO postgres;

--
-- Name: field_control; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE field_control (
    field_id integer NOT NULL,
    ordre_control integer NOT NULL,
    nom_control character varying(30) NOT NULL,
    event_js character varying(30) NOT NULL
);


ALTER TABLE public.field_control OWNER TO postgres;

--
-- Name: field_elmnt; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE field_elmnt (
    field_id integer NOT NULL,
    gabarit_name character varying(50) NOT NULL,
    elmnt_mtd_id character varying(50) NOT NULL,
    field_type character varying(10) NOT NULL,
    hor_size_text integer,
    vert_size_text integer
);


ALTER TABLE public.field_elmnt OWNER TO postgres;

--
-- Name: gabarit_mtd; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE gabarit_mtd (
    gabarit_name character varying(50) NOT NULL,
    gabarit_date date NOT NULL,
    predef_date character varying(10),
    stan_name character varying(25)
);


ALTER TABLE public.gabarit_mtd OWNER TO postgres;

--
-- Name: gabarit_parent; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE gabarit_parent (
    fils_gabarit_name character varying(50) NOT NULL,
    pere_gabarit_name character varying(50) NOT NULL
);


ALTER TABLE public.gabarit_parent OWNER TO postgres;

--
-- Name: import_form; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE import_form (
    code_observatoire character varying(6) NOT NULL,
    mtd_sheet_id integer NOT NULL,
    source_import character varying(25) NOT NULL,
    fichier_xml character varying(100) NOT NULL,
    import_date character varying(10) NOT NULL
);


ALTER TABLE public.import_form OWNER TO postgres;

--
-- Name: index_search; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE index_search (
    sheet_id integer NOT NULL,
    code_observatoire character varying(100) NOT NULL,
    id_orga integer NOT NULL,
    titre_ress character varying NOT NULL,
    resume character varying,
    auteur character varying(500),
    gabarit_name character varying(50),
    begin_date date,
    end_date date,
    private character varying(5),
    titre_ress_2 character varying,
    titre_fiche character varying(80),
    date_ress character varying(10),
    date date,
    xml_sheet character varying,
    format character varying,
    url_data character varying
);


ALTER TABLE public.index_search OWNER TO postgres;

--
-- Name: jeu_val_predef; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE jeu_val_predef (
    param_predef_id integer NOT NULL,
    "login" character varying(20) NOT NULL,
    jeu_val_date_maj character varying(10),
    jeu_val_name character varying(50),
    gabarit_name character varying(50),
    param_predef_name character varying(50),
    jeu_val_default_m character varying(5),
    jeu_val_default_r character varying(5),
    jeu_val_default_d character varying(5)
);


ALTER TABLE public.jeu_val_predef OWNER TO postgres;

--
-- Name: keywords; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE keywords (
    libellemot character varying(250) NOT NULL,
    categoriemot character varying(250),
    user_key character varying(20) NOT NULL
);


ALTER TABLE public.keywords OWNER TO postgres;

--
-- Name: label; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE label (
    id_foreign_table character varying(100) NOT NULL,
    table_name character varying(50) NOT NULL,
    iso_lang_code character varying(3) NOT NULL,
    defn character varying(500),
    type_label character varying(20) NOT NULL,
    label character varying(500)
);


ALTER TABLE public.label OWNER TO postgres;

--
-- Name: label_stand; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE label_stand (
    id_foreign_table character varying(100) NOT NULL,
    table_name character varying(50) NOT NULL,
    iso_lang_code character varying(3) NOT NULL,
    label character varying(250) NOT NULL,
    defn character varying(500),
    type_label character varying(20) NOT NULL
);


ALTER TABLE public.label_stand OWNER TO postgres;

--
-- Name: langue; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE langue (
    iso_lang_code character varying(3) NOT NULL,
    langue character varying(10) NOT NULL,
    char_set_code character varying(10) NOT NULL
);


ALTER TABLE public.langue OWNER TO postgres;

--
-- Name: liste_interface; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE liste_interface (
    nom_liste character varying(50) NOT NULL
);


ALTER TABLE public.liste_interface OWNER TO postgres;

--
-- Name: map_z3950_mdweb; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE map_z3950_mdweb (
    num_attrib_z3950 integer NOT NULL,
    champ_mdweb character varying(200) NOT NULL,
    table_mdweb character varying NOT NULL
);


ALTER TABLE public.map_z3950_mdweb OWNER TO postgres;

--
-- Name: md_og; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE md_og (
    id_geom integer NOT NULL,
    nom character varying(100) NOT NULL,
    sheet_id integer NOT NULL,
    code_observatoire character varying(100) NOT NULL,
    n real,
    w real,
    e real,
    s real
);


ALTER TABLE public.md_og OWNER TO postgres;

--
-- Name: message_interface; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE message_interface (
    nom_message character varying(100) NOT NULL
);


ALTER TABLE public.message_interface OWNER TO postgres;

--
-- Name: mots_cles; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mots_cles (
    sheet_id integer NOT NULL,
    code_observatoire character varying(100) NOT NULL,
    libelle character varying(200) NOT NULL,
    nom_thesaurus character varying(200) NOT NULL
);


ALTER TABLE public.mots_cles OWNER TO postgres;

--
-- Name: mtd_form; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mtd_form (
    mtd_sheet_id integer NOT NULL,
    code_observatoire character varying(6) NOT NULL,
    login_sais character varying(20) NOT NULL,
    login_val character varying(20),
    gabarit_name character varying(50) NOT NULL,
    mtd_nivacces integer,
    update_date character varying(10),
    predef_date character varying(10),
    contact_m_date character varying(10),
    contact_m_name character varying(50),
    titre_fiche character varying(80),
    predef_name character varying(50),
    contact_r_name character varying(50),
    contact_r_date character varying(10),
    contact_d_name character varying(50),
    contact_d_date character varying(10)
);


ALTER TABLE public.mtd_form OWNER TO postgres;

--
-- Name: mtd_value; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE mtd_value (
    mtd_sheet_id integer NOT NULL,
    code_observatoire character varying(6) NOT NULL,
    gabarit_name character varying(50) NOT NULL,
    elmnt_mtd_id character varying(50) NOT NULL,
    num_elmnt character varying(250) NOT NULL,
    mtd_value character varying NOT NULL
);


ALTER TABLE public.mtd_value OWNER TO postgres;

--
-- Name: niv_form; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE niv_form (
    mtd_sheet_id integer NOT NULL,
    code_observatoire character varying(6) NOT NULL,
    niv_saisie integer NOT NULL,
    saisie_complete character varying(5) NOT NULL,
    est_validee character varying(5) NOT NULL,
    date_validation character varying(10),
    default_niv_saisie integer
);


ALTER TABLE public.niv_form OWNER TO postgres;

--
-- Name: observatoire; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE observatoire (
    code_observatoire character varying(6) NOT NULL,
    nom_observatoire character varying(50) NOT NULL,
    pays character varying(50)
);


ALTER TABLE public.observatoire OWNER TO postgres;

--
-- Name: param_control; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE param_control (
    field_id integer NOT NULL,
    ordre_control integer NOT NULL,
    ordre_param integer NOT NULL,
    val_param character varying(50) NOT NULL
);


ALTER TABLE public.param_control OWNER TO postgres;

--
-- Name: param_mdweb; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE param_mdweb (
    version character varying(10) NOT NULL,
    date_version character varying(10) NOT NULL,
    polit_publi integer NOT NULL
);


ALTER TABLE public.param_mdweb OWNER TO postgres;

--
-- Name: standard; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE standard (
    stan_name character varying(25) NOT NULL,
    stan_desc character varying(100) NOT NULL,
    stan_vers character varying(20)
);


ALTER TABLE public.standard OWNER TO postgres;

--
-- Name: user_desc; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE user_desc (
    "login" character varying(20) NOT NULL,
    iso_lang_code character varying(3) NOT NULL,
    nom character varying(50) NOT NULL,
    prenom character varying(50),
    email character varying(50),
    mdp character varying(40),
    nivacces integer NOT NULL,
    coulpref character varying(10),
    code_observatoire character varying(6),
    organisation character varying(50),
    phone character varying(20),
    address character varying(250),
    postal_code character varying(50),
    city character varying(50),
    url character varying(250),
    title character varying(10),
    "position" character varying(250),
    countrycd character varying(10)
);


ALTER TABLE public.user_desc OWNER TO postgres;

--
-- Name: valeur_predefinie; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE valeur_predefinie (
    val_predef_id integer NOT NULL,
    param_predef_id integer NOT NULL,
    gabarit_name character varying(50) NOT NULL,
    elmnt_mtd_id character varying(50) NOT NULL,
    val_predef_value character varying(500),
    val_predef_name character varying(50),
    num_elmnt_predef character varying(250),
    visibilite integer,
    contact character varying(1)
);


ALTER TABLE public.valeur_predefinie OWNER TO postgres;

--
-- Data for Name: a_pour_parent; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- Data for Name: archive_zip; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO archive_zip VALUES ('EMO_CA', 2, 'EMO_CA_2.zip', '719626', '2007-07-05', '17:35', 'prive');


--
-- Data for Name: attrib_elmnt_gabarit; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('code_417', 'xlink:href', NULL, 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('distance_122', 'uom', NULL, 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('code_417', 'xlink:href', NULL, 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('code_417', 'xlink:href', NULL, 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('code_417', 'xlink:href', NULL, 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('code_417', 'xlink:href', NULL, 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('distance_122', 'uom', 'm', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('TimePeriod_501', 'gml:id', 'extent', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'couche_raster');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'base_alpha');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'base_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'carte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'couche_vecteur');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'doc_texte_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'refer_biblio');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'table_num');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'carte_papier');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_ServiceIdentification_69', 'id', NULL, 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:gmx', 'http://www.isotc211.org/2005/gmx', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/srv http://www.isotc211.org/2005/srv/srv.xsd', 'web_service_geo');
INSERT INTO attrib_elmnt_gabarit VALUES ('MD_Metadata_1', 'xmlns:srv', 'http://www.isotc211.org/2005/srv', 'web_service_geo');


--
-- Data for Name: attrib_elmnt_mtd; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1430', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1467', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1504', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1541', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1578', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1615', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1652', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1689', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1726', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1763', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1800', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1837', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1874', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1911', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('valueUnit_1948', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('PT_Locale_886', 'id', 'locale-fr');
INSERT INTO attrib_elmnt_mtd VALUES ('TimePeriod_501', 'gml:id', 'extent');
INSERT INTO attrib_elmnt_mtd VALUES ('TimePeriod_649', 'gml:id', 'extent');
INSERT INTO attrib_elmnt_mtd VALUES ('TimePeriod_688', 'gml:id', 'extent');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xmlns', 'http://www.isotc211.org/2005/gmd');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xmlns:gco', 'http://www.isotc211.org/2005/gco');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xmlns:gmd', 'http://www.isotc211.org/2005/gmd');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xmlns:xlink', 'http://www.w3.org/1999/xlink');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xmlns:gml', 'http://www.opengis.net/gml');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
INSERT INTO attrib_elmnt_mtd VALUES ('MD_Metadata_1', 'xsi:schemaLocation', 'http://www.isotc211.org/2005/gmd');
INSERT INTO attrib_elmnt_mtd VALUES ('code_417', 'xlink:href', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('distance_122', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('PT_Locale_886', 'uuid', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('resolution_370', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('falseEastingNorthingUnits_528', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('axisUnits_520', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('units_599', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('unitOfMeasure_150', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('unitOfMeasure_665', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('unitOfMeasure_695', 'uom', NULL);
INSERT INTO attrib_elmnt_mtd VALUES ('featureTypes_572', 'codeSpace', NULL);


--
-- Data for Name: code_list; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO code_list VALUES ('', '', '', '');
INSERT INTO code_list VALUES ('AscTypeCd', 'DS_AssociationTypeCode', 'true', 'gmd:DS_AssociationTypeCode');
INSERT INTO code_list VALUES ('CellGeoCd', 'MD_CellGeometryCode', 'true', 'gmd:MD_CelGeometryCode');
INSERT INTO code_list VALUES ('CharSetCd', 'MD_CharacterSetCode', 'true', 'gmd:MD_CharacterSetCode');
INSERT INTO code_list VALUES ('ClassificationCd', 'MD_ClassificationCode', 'true', 'gmd:MD_ClassificationCode');
INSERT INTO code_list VALUES ('ContentTypCd', 'MD_CoverageContentTypeCode', 'true', 'gmd:MD_CoverageContentTypeCode');
INSERT INTO code_list VALUES ('CountryCd', 'Country', 'false', 'gmd:Country');
INSERT INTO code_list VALUES ('DateTypCd', 'CI_DateTypeCode', 'true', 'gmd:CI_DateTypeCode');
INSERT INTO code_list VALUES ('DimNameTypCd', 'MD_DimensionNameTypeCode', 'true', 'gmd:MD_DimensioNameTypeCode');
INSERT INTO code_list VALUES ('EvalMethTypeCd', 'DQ_EvaluationMethodTypeCode', 'true', 'gmd:DQ_EvaluationMethodTypeCode');
INSERT INTO code_list VALUES ('GeoObjTypCd', 'MD_GeometricObjectTypeCode', 'true', 'gmd:MD_GeometricObjectTypeCode');
INSERT INTO code_list VALUES ('ImgCondCd', 'MD_ImagingConditionCode', 'true', 'gmd:MD_ImagingConditionCode');
INSERT INTO code_list VALUES ('InitTypeCd', 'DS_InitiativeTypeCode', 'true', 'gmd:DS_InitiativeTypeCode');
INSERT INTO code_list VALUES ('KeyTypCd', 'MD_KeywordTypeCode', 'true', 'gmd:MD_KeywordTypeCode');
INSERT INTO code_list VALUES ('LangCd', 'LanguageCode', 'false', 'gmd:LanguageCode');
INSERT INTO code_list VALUES ('MaintFreqCd', 'MD_MaintenanceFrequencyCode', 'true', 'gmd:MD_MaintenanceFrequencyCode');
INSERT INTO code_list VALUES ('MedFormCd', 'MD_MediumFormatCode', 'true', 'gmd:MD_MediumFormatCode');
INSERT INTO code_list VALUES ('MedNameCd', 'MD_MediumNameCode', 'true', 'gmd:MD_MediumNameCode');
INSERT INTO code_list VALUES ('ObCd', 'MD_ObligationCode', 'true', 'gmd:MD_ObligationCode');
INSERT INTO code_list VALUES ('OnFunctCd', 'CI_OnLineFunctionCode', 'true', 'gmd:CI_OnLineFunctionCode');
INSERT INTO code_list VALUES ('PixOrientCd', 'MD_PixelOrientationCode', 'true', 'gmd:MD_PixelOrientationCode');
INSERT INTO code_list VALUES ('PresFormCd', 'CI_PresentationFormCode', 'true', 'gmd:CI_PresentationFormCode');
INSERT INTO code_list VALUES ('ProgCd', 'MD_ProgressCode', 'true', 'gmd:MD_ProgressCode');
INSERT INTO code_list VALUES ('RefSysCd', 'RO_SystRefCode', 'false', 'gmd:RO_SystRefCode');
INSERT INTO code_list VALUES ('RestrictCd', 'MD_RestrictionCode', 'true', 'gmd:MD_RestrictionCode');
INSERT INTO code_list VALUES ('RoleCd', 'CI_RoleCode', 'true', 'gmd:CI_RoleCode');
INSERT INTO code_list VALUES ('ScopeCd', 'MD_ScopeCode', 'true', 'gmd:MD_ScopeCode');
INSERT INTO code_list VALUES ('SpatRepTypCd', 'MD_SpatialRepresentationTypeCode', 'true', 'gmd:MD_SpatialRepresentationTypeCode');
INSERT INTO code_list VALUES ('TopicCatCd', 'MD_TopicCategoryCode', 'true', 'gmd:MD_TopicCategoryCode');
INSERT INTO code_list VALUES ('TopoLevCd', 'MD_TopologyLevelCode', 'true', 'gmd:MD_TopologyLevelCode');
INSERT INTO code_list VALUES ('DatatypeCd', 'MD_DatatypeCode', 'true', 'gmd:MD_DatatypeCode');
INSERT INTO code_list VALUES ('BoolCd', 'MW_BoolCode', 'false', '');
INSERT INTO code_list VALUES ('uom', 'MW_UomUnitCode', 'false', '');
INSERT INTO code_list VALUES ('DCPList', 'DCPList', 'true', 'srv:DCPList');
INSERT INTO code_list VALUES ('CouplingTypeCd', 'SV_CouplingType', 'true', 'srv:SV_CouplingType');


--
-- Data for Name: contact_catalogue; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO contact_catalogue VALUES (2, 'Nom de l''organisme ', '002', 'Adresse postale ', '', 'Ville ', 'fr', 'adresse@domain.com&&&&&', 'http://www.domain.com/', '');


--
-- Data for Name: contacts; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- Data for Name: db_version; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO db_version VALUES ('1.5', '4/25/2007  10:38:07 AM', 1, 'initialisation des révisions');
INSERT INTO db_version VALUES ('1.5', '4/25/2007  11:57:23 AM', 2, 'suppression de la classe abstraite MD_contentInformation et rattachement des continfo_40 aux classes filles MD_FeatureCatalogueDescription, MD_CoverageDescription, MD_ImageDescription');
INSERT INTO db_version VALUES ('1.5', '5/15/2007  4:09:02 PM', 3, 'modifications des tables elmnt_gabarit (ajout element geographicElement_506) et est_contenu (modification element geographicElement_141 par geographicElement_506) , est_inclus (ajout de la ligne MD_GeometricObject_463, geometryObject_398, 0), suppression des elements CI_Citation_272 et MD_constraints_247 dans elmnt_gabarit');
INSERT INTO db_version VALUES ('1.5', '5/15/2007  5:02:06 PM', 4, 'modification de la table est_contenu pour donner corriger la hierarchie entre EX_extent_118, geographicElement_506 et Ex_GeographicDescription');
INSERT INTO db_version VALUES ('1.5', '5/15/2007  5:13:49 PM', 5, 'correction de la hierarchie entre EX_GeographicDescription_117 et geographicIdentifier_130');
INSERT INTO db_version VALUES ('1.5', '5/15/2007  5:26:39 PM', 6, 'modifications des num_elmnt suite aux corrections sur la hierarchie des révisions 3, 4 et 5');
INSERT INTO db_version VALUES ('1.5', '5/18/2007  2:49:19 PM', 7, 'modification du data_type_code pour les éléments topicCategory_62 obligation_551 et pointInPixel_385, correction de élément RepresentationFraction en RepresentativeFraction dans les tables elmnt_mtd, elmnt_mtd-fra, est_inclus, elmnt_gabarit, elmnt_gabarit-fra, est_contenu');
INSERT INTO db_version VALUES ('1.5', '5/18/2007  3:02:16 PM', 8, 'correction des identifiants elements dans la table label_stand, element portant sur resource (erreur ressource) et ayant des majuscules comme premiere lettre');
INSERT INTO db_version VALUES ('1.5', '5/18/2007  5:31:37 PM', 9, 'ajout de la liste BoolCd, correction sur element tranformationParameterAvailability, ajout du libellé sur distance_122');
INSERT INTO db_version VALUES ('1.5', '5/18/2007  5:46:06 PM', 10, 're modification du data_type_code sur element tranformationParameterAvailability');
INSERT INTO db_version VALUES ('1.5', '5/21/2007  12:36:52 PM', 11, 'suppression des elements Ci_Citation_272 (refer_biblio et do_texte_num) et referenceSystemIdentifier_401 (base_alpha)');
INSERT INTO db_version VALUES ('1.5', '5/22/2007  4:00:41 PM', 12, 'modification pour les elements du profi francais du nom du standard (elmnt_mtd-fra) et dans standard');
INSERT INTO db_version VALUES ('1.5', '5/23/2007  2:48:52 PM', 13, 'ajout de la table attrib_elmnt_gabarit qui est l ancienne table attrib_elmnt_mtd, la table attrib_elmnt_mtd contient les attributs des elements de toute la norme');
INSERT INTO db_version VALUES ('1.5', '5/23/2007  5:14:15 PM', 14, 'modification et correction dans les tables attrib_elmnt_mtd, attrib_elmnt_gabarit');
INSERT INTO db_version VALUES ('1.5', '5/24/2007  11:19:05 AM', 15, 'corrections sur les elements authority_878 (elmnt_mtd), suppression de element CI_Responsibleparty_637 (elmnt_mtd, est_inlcus, label_stand), modification dans est_contenu, field_elmnt, elmnt_gabarit de useLimitation_278 par useLimitation_279');
INSERT INTO db_version VALUES ('1.5', '5/24/2007  5:34:31 PM', 16, 'ajout des elements étendus pour le profil francais, ajout de la table est_inclus-fra, modification des tables label, label_stand,attrib_elmnt_mtd-fra');
INSERT INTO db_version VALUES ('1.5', '5/24/2007  5:42:26 PM', 17, 'corrections sur la table elmnt_mtd-fra');
INSERT INTO db_version VALUES ('1.5', '5/25/2007  3:13:43 PM', 18, 'ajout des différents types hors norme 19115 (voir la complétion dans la feuille Type)');
INSERT INTO db_version VALUES ('1.5', '5/25/2007  3:22:27 PM', 19, 'corrections sur les modifications précédentes');
INSERT INTO db_version VALUES ('1.5', '5/25/2007  3:56:15 PM', 20, 'ajout de la liste LunitCd pour donner une liste des unités de longueur');
INSERT INTO db_version VALUES ('1.5', '5/28/2007  11:18:59 AM', 21, 'modification des identifiants de la liste MW_uomLengthCode');
INSERT INTO db_version VALUES ('1.5', '5/28/2007  4:42:17 PM', 22, 'création des entrées  des elements dans label_stand avec des identifiants sans les incréments');
INSERT INTO db_version VALUES ('1.5', '6/1/2007  11:33:23 AM', 23, 'modification de lelement MD_LegalConstraints_');
INSERT INTO db_version VALUES ('1.5', '6/15/2007  11:33:23 AM', 24, 'correction sur element densityUnit_ shortname et  libellé');


--
-- Data for Name: elmnt_code_list; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO elmnt_code_list VALUES ('AscTypeCd_1', 'AscTypeCd', 'crossReference', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('AscTypeCd_2', 'AscTypeCd', 'largerWorkCitation', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('AscTypeCd_3', 'AscTypeCd', 'partOfSeamlessDatabase', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('AscTypeCd_4', 'AscTypeCd', 'source', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('AscTypeCd_5', 'AscTypeCd', 'stereoMate', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('CellGeoCd_1', 'CellGeoCd', 'point', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('CellGeoCd_2', 'CellGeoCd', 'area', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('CharSetCd_11', 'CharSetCd', '8859part6', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('CharSetCd_21', 'CharSetCd', 'usAscii', '021', 'true');
INSERT INTO elmnt_code_list VALUES ('CharSetCd_4', 'CharSetCd', 'utf8', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('CharSetCd_5', 'CharSetCd', 'utf16', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('CharSetCd_6', 'CharSetCd', '8859part1', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('ClassificationCd_1', 'ClassificationCd', 'unclassified', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('ClassificationCd_2', 'ClassificationCd', 'restricted', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('ClassificationCd_3', 'ClassificationCd', 'confidential', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('ClassificationCd_4', 'ClassificationCd', 'secret', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('ClassificationCd_5', 'ClassificationCd', 'topSecret', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('ContentTypCd_1', 'ContentTypCd', 'image', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('ContentTypCd_2', 'ContentTypCd', 'thematicClassification', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('ContentTypCd_3', 'ContentTypCd', 'physicalMeasurement', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('BoolCd_1', 'BoolCd', 'true', '001', 'false');
INSERT INTO elmnt_code_list VALUES ('BoolCd_2', 'BoolCd', 'false', '002', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_1', 'CountryCd', 'Algeria', 'dz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_10', 'CountryCd', 'Argentina', 'ar', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_100', 'CountryCd', 'Indonesia', 'id', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_101', 'CountryCd', 'Iran', 'ir', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_102', 'CountryCd', 'Iraq', 'iq', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_103', 'CountryCd', 'Ireland', 'ie', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_104', 'CountryCd', 'Israel', 'il', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_105', 'CountryCd', 'Italy', 'it', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_106', 'CountryCd', 'Jamaica', 'jm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_107', 'CountryCd', 'Japan', 'jp', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_108', 'CountryCd', 'Jordan', 'jo', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_109', 'CountryCd', 'Kazakhstan', 'kz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_11', 'CountryCd', 'Armenia', 'am', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_110', 'CountryCd', 'Kenya', 'ke', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_111', 'CountryCd', 'Kiribati', 'ki', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_112', 'CountryCd', 'Democratic People''s Republic of Korea', 'kp', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_113', 'CountryCd', 'Republic of Korea', 'kr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_114', 'CountryCd', 'Kuwait', 'kw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_115', 'CountryCd', 'Kyrgyzstan', 'kg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_116', 'CountryCd', 'Lao People''s Democratic Republic', 'la', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_117', 'CountryCd', 'Latvia', 'lv', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_118', 'CountryCd', 'Lebanon', 'lb', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_119', 'CountryCd', 'Lesotho', 'ls', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_12', 'CountryCd', 'Aruba', 'aw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_120', 'CountryCd', 'Liberia', 'lr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_121', 'CountryCd', 'Libyan Arab Jamahiriya', 'ly', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_122', 'CountryCd', 'Liechtenstein', 'li', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_123', 'CountryCd', 'Lithuania', 'lt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_124', 'CountryCd', 'Luxembourg', 'lu', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_125', 'CountryCd', 'Macao', 'mo', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_126', 'CountryCd', 'The Former Yugoslav Republic of Macedonia', 'mk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_127', 'CountryCd', 'Madagascar', 'mg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_128', 'CountryCd', 'Malawi', 'mw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_129', 'CountryCd', 'Malaysia', 'my', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_13', 'CountryCd', 'Australia', 'au', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_130', 'CountryCd', 'Madives', 'mv', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_131', 'CountryCd', 'Mali', 'ml', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_132', 'CountryCd', 'Malta', 'mt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_133', 'CountryCd', 'Marshall Islands', 'mh', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_134', 'CountryCd', 'Martinique', 'mq', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_135', 'CountryCd', 'Mauritania', 'mr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_136', 'CountryCd', 'Mauritius', 'mu', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_137', 'CountryCd', 'Mayotte', 'yt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_138', 'CountryCd', 'Mexico', 'mx', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_139', 'CountryCd', 'Federated States of Micronesia', 'fm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_14', 'CountryCd', 'Austria', 'at', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_140', 'CountryCd', 'Republic of Moldova', 'md', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_141', 'CountryCd', 'Monaco', 'mn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_142', 'CountryCd', 'Montserrat', 'ms', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_143', 'CountryCd', 'Morocco', 'ma', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_144', 'CountryCd', 'Mozambique', 'mz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_145', 'CountryCd', 'Myanmar', 'mn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_146', 'CountryCd', 'Namibia', 'na', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_147', 'CountryCd', 'Nauru', 'nr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_148', 'CountryCd', 'Nepal', 'np', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_149', 'CountryCd', 'Netherlands', 'nl', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_15', 'CountryCd', 'Azerbaijan', 'az', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_150', 'CountryCd', 'Netherlands Antilles', 'an', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_151', 'CountryCd', 'New Caledonia', 'nc', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_152', 'CountryCd', 'New Zealand', 'nz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_153', 'CountryCd', 'Nicaragua', 'ni', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_154', 'CountryCd', 'Niger', 'ne', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_155', 'CountryCd', 'Nigeria', 'ng', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_156', 'CountryCd', 'Niue', 'nu', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_157', 'CountryCd', 'Norfolk Island', 'nf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_158', 'CountryCd', 'Northern Mariana Islands', 'mp', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_159', 'CountryCd', 'Norway', 'no', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_16', 'CountryCd', 'Bahamas', 'bs', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_160', 'CountryCd', 'Oman', 'om', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_161', 'CountryCd', 'Pakistan', 'pk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_162', 'CountryCd', 'Palau', 'pw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_163', 'CountryCd', 'Pelestinian Territory, Ocuupied', 'ps', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_164', 'CountryCd', 'Panama', 'pa', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_165', 'CountryCd', 'Papua New Guinea', 'pg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_166', 'CountryCd', 'Paraguay', 'py', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_167', 'CountryCd', 'Peru', 'pe', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_168', 'CountryCd', 'Philippines', 'ph', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_169', 'CountryCd', 'Pitcairn', 'pn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_17', 'CountryCd', 'Bahrain', 'bh', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_170', 'CountryCd', 'Poland', 'pl', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_171', 'CountryCd', 'Portugal', 'pt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_172', 'CountryCd', 'Puerto Rico', 'pr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_173', 'CountryCd', 'Qatar', 'qa', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_174', 'CountryCd', 'Réunion', 're', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_175', 'CountryCd', 'Romania', 'ro', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_176', 'CountryCd', 'Russian Federation', 'ru', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_177', 'CountryCd', 'Rwanda', 'rw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_178', 'CountryCd', 'Saint Helena', 'sh', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_179', 'CountryCd', 'Saint Kitts and Nevis', 'kn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_18', 'CountryCd', 'Bangladesh', 'bd', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_180', 'CountryCd', 'Saint Lucia', 'lc', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_181', 'CountryCd', 'Saint Pierre abd Miquelon', 'pm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_182', 'CountryCd', 'Saint Vincent and the Grenadines', 'vc', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_183', 'CountryCd', 'Samoa', 'ws', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_184', 'CountryCd', 'San Marino', 'sm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_185', 'CountryCd', 'Sao Tome and Principe', 'st', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_186', 'CountryCd', 'Saudi Arabia', 'sa', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_187', 'CountryCd', 'Senegal', 'sn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_188', 'CountryCd', 'Serbia and Montenegro', 'cs', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_189', 'CountryCd', 'Seychelles', 'sc', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_19', 'CountryCd', 'Barbados', 'bb', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_190', 'CountryCd', 'Sierra Leone', 'sl', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_191', 'CountryCd', 'Singapore', 'sg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_192', 'CountryCd', 'Slovakia', 'sk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_193', 'CountryCd', 'Slovenia', 'si', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_194', 'CountryCd', 'Solomon Islands', 'sb', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_195', 'CountryCd', 'Somalia', 'so', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_196', 'CountryCd', 'South Africa', 'za', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_197', 'CountryCd', 'South Georgia and the South Sandwich Islands', 'gs', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_198', 'CountryCd', 'Spain', 'es', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_199', 'CountryCd', 'Sri Lanka', 'lk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_2', 'CountryCd', 'Afghanistan', 'af', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_20', 'CountryCd', 'Belarus', 'by', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_200', 'CountryCd', 'Sudan', 'sd', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_201', 'CountryCd', 'Suriname', 'sr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_202', 'CountryCd', 'Svalbard and Jan Mayen', 'sj', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_203', 'CountryCd', 'Swaziland', 'sz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_204', 'CountryCd', 'Sweden', 'se', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_205', 'CountryCd', 'Switzerland', 'ch', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_206', 'CountryCd', 'Syrian Arab Republic', 'sy', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_207', 'CountryCd', 'Taiwan, Province of China', 'tw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_208', 'CountryCd', 'Tajikistan', 'tj', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_209', 'CountryCd', 'Tanzania, United Republic of', 'tz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_21', 'CountryCd', 'Belgium', 'be', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_210', 'CountryCd', 'Thailand', 'th', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_211', 'CountryCd', 'Timor-Leste', 'tl', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_212', 'CountryCd', 'Togo', 'tg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_213', 'CountryCd', 'Trinidad and Tobago', 'tt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_214', 'CountryCd', 'Tunisia', 'tn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_215', 'CountryCd', 'Turkey', 'tr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_216', 'CountryCd', 'Turkmenistan', 'tm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_217', 'CountryCd', 'Turks and Caicos Islands', 'tc', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_218', 'CountryCd', 'Tuvalu', 'tv', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_219', 'CountryCd', 'Uganda', 'ug', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_22', 'CountryCd', 'Belize', 'bz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_220', 'CountryCd', 'Ukraine', 'ua', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_221', 'CountryCd', 'United Arab Emirates', 'ae', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_222', 'CountryCd', 'United Kingdom', 'gb', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_223', 'CountryCd', 'United States', 'us', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_224', 'CountryCd', 'United States Minor Outlying Islands', 'um', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_225', 'CountryCd', 'Uruguay', 'uy', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_226', 'CountryCd', 'Uzbekistan', 'uz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_227', 'CountryCd', 'Vanuatu', 'vu', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_228', 'CountryCd', 'Venezuela', 've', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_229', 'CountryCd', 'Viet Nam', 'vn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_23', 'CountryCd', 'Benin', 'bj', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_230', 'CountryCd', 'Virgin Islands, British', 'vg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_231', 'CountryCd', 'Virgin Islands, U.S.', 'vi', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_232', 'CountryCd', 'Wallis and Futuna', 'wf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_233', 'CountryCd', 'Western Sahara', 'eh', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_234', 'CountryCd', 'Yemen', 'ye', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_235', 'CountryCd', 'Zambia', 'zm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_236', 'CountryCd', 'Zimbabwe', 'zw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_24', 'CountryCd', 'Bermuda', 'bm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_25', 'CountryCd', 'Bhutan', 'bt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_26', 'CountryCd', 'Bolivia', 'bo', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_27', 'CountryCd', 'Bosnia and Herzgovina', 'ba', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_28', 'CountryCd', 'Botswana', 'bw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_29', 'CountryCd', 'Bouvet Island', 'bv', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_3', 'CountryCd', 'Aland Islands', 'ax', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_30', 'CountryCd', 'Brazil', 'br', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_31', 'CountryCd', 'British indian ocean territory', 'io', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_32', 'CountryCd', 'Brunei Darussalam', 'bn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_33', 'CountryCd', 'Bulgaria', 'bg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_34', 'CountryCd', 'Burkina Faso', 'bf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_35', 'CountryCd', 'Burundi', 'bi', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_36', 'CountryCd', 'Cambodia', 'kh', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_37', 'CountryCd', 'Cameroon', 'cm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_38', 'CountryCd', 'Canada', 'ca', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_39', 'CountryCd', 'Cape Verde', 'cv', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_4', 'CountryCd', 'American Samoa', 'as', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_40', 'CountryCd', 'Cayman Islands', 'ky', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_41', 'CountryCd', 'Central African Republic', 'cf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_42', 'CountryCd', 'Chad', 'td', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_43', 'CountryCd', 'Chile', 'cl', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_44', 'CountryCd', 'China', 'cn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_45', 'CountryCd', 'Christmas Island', 'cx', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_46', 'CountryCd', 'Cocos Islands', 'cc', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_47', 'CountryCd', 'Colombia', 'co', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_48', 'CountryCd', 'Comoros', 'km', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_49', 'CountryCd', 'Congo', 'cg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_5', 'CountryCd', 'Andorra', 'ad', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_50', 'CountryCd', 'Democratic Republic of Congo', 'cd', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_51', 'CountryCd', 'Cook Islands', 'ck', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_52', 'CountryCd', 'Costa Rica', 'cr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_53', 'CountryCd', 'Côte d''ivoire', 'ci', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_54', 'CountryCd', 'Croatia', 'hr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_55', 'CountryCd', 'Cuba', 'cu', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_56', 'CountryCd', 'Cyprus', 'cy', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_57', 'CountryCd', 'Czech Republic', 'cz', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_58', 'CountryCd', 'Denmark', 'dk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_59', 'CountryCd', 'Djibouti', 'dj', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_6', 'CountryCd', 'Angola', 'ao', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_60', 'CountryCd', 'Dominica', 'dm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_61', 'CountryCd', 'Dominican Republic', 'do', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_62', 'CountryCd', 'Ecudaor', 'ec', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_63', 'CountryCd', 'Egypt', 'eg', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_64', 'CountryCd', 'El Salvador', 'sv', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_65', 'CountryCd', 'Equatorial Guinea', 'gq', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_66', 'CountryCd', 'Eritrea', 'er', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_67', 'CountryCd', 'Estonia', 'ee', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_68', 'CountryCd', 'Ethiopia', 'et', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_69', 'CountryCd', 'Falkland Islands', 'fk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_7', 'CountryCd', 'Anguilla', 'ai', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_70', 'CountryCd', 'Faroe Islands', 'fo', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_71', 'CountryCd', 'Fiji', 'fj', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_72', 'CountryCd', 'Finland', 'fi', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_73', 'CountryCd', 'France', 'fr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_74', 'CountryCd', 'French Guiana', 'gf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_75', 'CountryCd', 'French Polynesia', 'pf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_76', 'CountryCd', 'French Southern Territories', 'tf', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_77', 'CountryCd', 'Gabon', 'ga', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_78', 'CountryCd', 'Gambia', 'gm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_79', 'CountryCd', 'Georgia', 'ge', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_8', 'CountryCd', 'Antartica', 'aq', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_80', 'CountryCd', 'Germany', 'de', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_81', 'CountryCd', 'Ghana', 'gh', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_82', 'CountryCd', 'Gibraltar', 'gi', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_83', 'CountryCd', 'Greece', 'gr', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_84', 'CountryCd', 'Greenland', 'gl', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_85', 'CountryCd', 'Grenada', 'gd', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_86', 'CountryCd', 'Guadeloupe', 'gp', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_87', 'CountryCd', 'Guam', 'gu', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_88', 'CountryCd', 'Guatemala', 'gt', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_89', 'CountryCd', 'Guinea', 'gn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_9', 'CountryCd', 'Antigua and barbuda', 'ag', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_90', 'CountryCd', 'Guinea-Bissau', 'gw', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_91', 'CountryCd', 'Guyana', 'gy', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_92', 'CountryCd', 'Haiti', 'ht', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_93', 'CountryCd', 'Heard Island and McDonald Islands', 'hm', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_94', 'CountryCd', 'Holy See', 'va', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_95', 'CountryCd', 'Honduras', 'hn', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_96', 'CountryCd', 'Hong Kong', 'hk', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_97', 'CountryCd', 'Hungary', 'hu', 'false');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_1', 'DatatypeCd', 'class', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_10', 'DatatypeCd', 'unionClass', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_11', 'DatatypeCd', 'metaClass', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_12', 'DatatypeCd', 'typeClass', '012', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_13', 'DatatypeCd', 'CharacterString', '013', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_14', 'DatatypeCd', 'integer', '014', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_15', 'DatatypeCd', 'association', '015', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_2', 'DatatypeCd', 'codelist', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_3', 'DatatypeCd', 'enumeration', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_4', 'DatatypeCd', 'codelistElement', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_5', 'DatatypeCd', 'abstractClass', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_6', 'DatatypeCd', 'aggregateClass', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_7', 'DatatypeCd', 'specifiedClass', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_8', 'DatatypeCd', 'datatypeClass', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('DatatypeCd_9', 'DatatypeCd', 'interfaceClass', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('DateTypCd_1', 'DateTypCd', 'creation', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('DateTypCd_2', 'DateTypCd', 'publication', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('DateTypCd_3', 'DateTypCd', 'revision', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_1', 'DimNameTypCd', 'row', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_2', 'DimNameTypCd', 'column', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_3', 'DimNameTypCd', 'vertical', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_4', 'DimNameTypCd', 'track', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_5', 'DimNameTypCd', 'crossTrack', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_6', 'DimNameTypCd', 'line', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_7', 'DimNameTypCd', 'sample', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('DimNameTypCd_8', 'DimNameTypCd', 'time', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('EvalMethTypeCd_1', 'EvalMethTypeCd', 'directInternal', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('EvalMethTypeCd_2', 'EvalMethTypeCd', 'directExternal', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('EvalMethTypeCd_3', 'EvalMethTypeCd', 'indirect', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('GeoObjTypCd_1', 'GeoObjTypCd', 'complex', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('GeoObjTypCd_2', 'GeoObjTypCd', 'composite', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('GeoObjTypCd_3', 'GeoObjTypCd', 'curve', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('GeoObjTypCd_4', 'GeoObjTypCd', 'point', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('GeoObjTypCd_5', 'GeoObjTypCd', 'solid', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('GeoObjTypCd_6', 'GeoObjTypCd', 'surface', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_1', 'ImgCondCd', 'blurredImage', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_10', 'ImgCondCd', 'snow', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_11', 'ImgCondCd', 'terrainMasking', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_2', 'ImgCondCd', 'cloud', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_3', 'ImgCondCd', 'degradingObliquity', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_4', 'ImgCondCd', 'fog', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_5', 'ImgCondCd', 'heavySmokeOrDust', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_6', 'ImgCondCd', 'night', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_7', 'ImgCondCd', 'rain', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_8', 'ImgCondCd', 'semiDarkness', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('ImgCondCd_9', 'ImgCondCd', 'shadow', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_1', 'InitTypeCd', 'campaign', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_10', 'InitTypeCd', 'process', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_11', 'InitTypeCd', 'program', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_12', 'InitTypeCd', 'project', '012', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_13', 'InitTypeCd', 'study', '013', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_14', 'InitTypeCd', 'task', '014', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_15', 'InitTypeCd', 'trial', '015', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_2', 'InitTypeCd', 'collection', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_3', 'InitTypeCd', 'exercise', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_4', 'InitTypeCd', 'experiment', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_5', 'InitTypeCd', 'investigation', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_6', 'InitTypeCd', 'mission', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_7', 'InitTypeCd', 'sensor', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_8', 'InitTypeCd', 'operation', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('InitTypeCd_9', 'InitTypeCd', 'platform', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('KeyTypCd_1', 'KeyTypCd', 'discipline', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('KeyTypCd_2', 'KeyTypCd', 'place', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('KeyTypCd_3', 'KeyTypCd', 'stratum', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('KeyTypCd_4', 'KeyTypCd', 'temporal', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('KeyTypCd_5', 'KeyTypCd', 'theme', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('CountryCd_98', 'CountryCd', 'Iceland', 'is', 'false');
INSERT INTO elmnt_code_list VALUES ('CountryCd_99', 'CountryCd', 'India', 'in', 'false');
INSERT INTO elmnt_code_list VALUES ('LangCd_1', 'LangCd', 'fra', 'fra', 'false');
INSERT INTO elmnt_code_list VALUES ('LangCd_2', 'LangCd', 'spa', 'spa', 'false');
INSERT INTO elmnt_code_list VALUES ('LangCd_3', 'LangCd', 'eng', 'eng', 'false');
INSERT INTO elmnt_code_list VALUES ('LangCd_4', 'LangCd', 'por', 'por', 'false');
INSERT INTO elmnt_code_list VALUES ('LangCd_5', 'LangCd', 'ara', 'ara', 'false');
INSERT INTO elmnt_code_list VALUES ('LangCd_6', 'LangCd', 'ger', 'ger', 'false');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_10', 'MaintFreqCd', 'irregular', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_11', 'MaintFreqCd', 'notPlanned', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_12', 'MaintFreqCd', 'unknown', '012', 'true');
INSERT INTO elmnt_code_list VALUES ('LangCd_7', 'LangCd', 'rus', 'rus', 'false');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_1', 'MaintFreqCd', 'continual', '001', 'false');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_2', 'MaintFreqCd', 'daily', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_3', 'MaintFreqCd', 'weekly', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_4', 'MaintFreqCd', 'fornightly', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_5', 'MaintFreqCd', 'monthly', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_6', 'MaintFreqCd', 'quarterly', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_7', 'MaintFreqCd', 'biannually', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_8', 'MaintFreqCd', 'annually', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_9', 'MaintFreqCd', 'asNeeded', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_1', 'MedFormCd', 'cpio', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_2', 'MedFormCd', 'tar', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_3', 'MedFormCd', 'highSierra', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_4', 'MedFormCd', 'iso9660', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_5', 'MedFormCd', 'iso9660RockRidge', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_6', 'MedFormCd', 'iso9660AppleHFS', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_13', 'MaintFreqCd', 'triennal', '013', 'false');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_1', 'MedNameCd', 'cdRom', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_10', 'MedNameCd', '3580Cartridge', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_11', 'MedNameCd', '4mmCartridgetape', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_12', 'MedNameCd', '8mmCartridgeTape', '012', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_13', 'MedNameCd', '1quarterInchCartridgeTape', '013', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_14', 'MedNameCd', 'digitalLinearTape', '014', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_15', 'MedNameCd', 'onLine', '015', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_16', 'MedNameCd', 'satelite', '016', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_17', 'MedNameCd', 'telephoneLink', '017', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_18', 'MedNameCd', 'hardcopy', '018', 'true');
INSERT INTO elmnt_code_list VALUES ('MaintFreqCd_14', 'MaintFreqCd', 'four-year', '014', 'false');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_2', 'MedNameCd', 'dvd', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_3', 'MedNameCd', 'dvdRom', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_4', 'MedNameCd', '3halfInchFloppy', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_5', 'MedNameCd', '5quarterInchFloppy', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_6', 'MedNameCd', '7trackTape', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_7', 'MedNameCd', '9trackTape', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_8', 'MedNameCd', '3480Cartridge', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_9', 'MedNameCd', '3490Cartridge', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('ObCd_1', 'ObCd', 'mandatory', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('ObCd_2', 'ObCd', 'optional', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('ObCd_3', 'ObCd', 'conditionnal', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('OnFunctCd_1', 'OnFunctCd', 'download', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('OnFunctCd_2', 'OnFunctCd', 'information', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('OnFunctCd_3', 'OnFunctCd', 'offlineAccess', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('OnFunctCd_4', 'OnFunctCd', 'order', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('OnFunctCd_5', 'OnFunctCd', 'search', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('PixOrientCd_1', 'PixOrientCd', 'center', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('PixOrientCd_2', 'PixOrientCd', 'lowerLeft', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('PixOrientCd_3', 'PixOrientCd', 'lowerRight', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('PixOrientCd_4', 'PixOrientCd', 'upperRight', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('PixOrientCd_5', 'PixOrientCd', 'upperLeft', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_1', 'PresFormCd', 'documentDigital', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_11', 'PresFormCd', 'tableDigital', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_12', 'PresFormCd', 'tableHardcopy', '012', 'true');
INSERT INTO elmnt_code_list VALUES ('MedFormCd_7', 'MedFormCd', 'none', '007', 'false');
INSERT INTO elmnt_code_list VALUES ('MedNameCd_19', 'MedNameCd', 'none', '019', 'false');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_15', 'PresFormCd', 'geoDatabase', '015', 'false');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_16', 'PresFormCd', 'database', '016', 'false');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_2', 'PresFormCd', 'documentHardcopy', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_3', 'PresFormCd', 'imageDigital', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_4', 'PresFormCd', 'imageHardcopy', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_5', 'PresFormCd', 'mapDigital', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_6', 'PresFormCd', 'mapHardcopy', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_1', 'ProgCd', 'completed', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_2', 'ProgCd', 'historicalArchive', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_3', 'ProgCd', 'obsolete', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_4', 'ProgCd', 'onGoing', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_5', 'ProgCd', 'planned', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_6', 'ProgCd', 'required', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('ProgCd_7', 'ProgCd', 'underDevelopment', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_17', 'PresFormCd', 'vector theme', '017', 'false');
INSERT INTO elmnt_code_list VALUES ('PresFormCd_18', 'PresFormCd', 'raster layer', '018', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_1', 'RefSysCd', '4326', '4326', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_62', 'RefSysCd', '102022', '102022', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_10', 'RefSysCd', '102030', '102030', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_11', 'RefSysCd', '102001', '102001', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_12', 'RefSysCd', '102002', '102002', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_13', 'RefSysCd', '54027', '54027', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_14', 'RefSysCd', '54002', '54002', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_15', 'RefSysCd', '102013', '102013', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_16', 'RefSysCd', '102031', '102031', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_17', 'RefSysCd', '102014', '102014', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_18', 'RefSysCd', '23028', '23028', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_19', 'RefSysCd', '23029', '23029', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_2', 'RefSysCd', '102023', '102023', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_20', 'RefSysCd', '23030', '23030', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_21', 'RefSysCd', '23031', '23031', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_22', 'RefSysCd', '23032', '23032', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_23', 'RefSysCd', '23033', '23033', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_24', 'RefSysCd', '23034', '23034', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_25', 'RefSysCd', '23035', '23035', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_26', 'RefSysCd', '23036', '23036', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_27', 'RefSysCd', '23037', '23037', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_28', 'RefSysCd', '23038', '23038', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_29', 'RefSysCd', '102007', '102007', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_3', 'RefSysCd', '102024', '102024', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_30', 'RefSysCd', '54004', '54004', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_31', 'RefSysCd', '102008', '102008', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_32', 'RefSysCd', '102010', '102010', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_33', 'RefSysCd', '102009', '102009', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_34', 'RefSysCd', '2154', '2154', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_35', 'RefSysCd', '27581', '27581', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_36', 'RefSysCd', '27582', '27582', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_37', 'RefSysCd', '27593', '27593', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_38', 'RefSysCd', '27583', '27583', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_39', 'RefSysCd', '27584', '27584', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_4', 'RefSysCd', '102006', '102006', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_40', 'RefSysCd', '27571', '27571', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_41', 'RefSysCd', '27572', '27572', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_42', 'RefSysCd', '27573', '27573', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_43', 'RefSysCd', '27574', '27574', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_44', 'RefSysCd', '102033', '102033', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_45', 'RefSysCd', '102032', '102032', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_46', 'RefSysCd', '102015', '102015', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_47', 'RefSysCd', '102003', '102003', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_48', 'RefSysCd', '102005', '102005', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_49', 'RefSysCd', '102004', '102004', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_5', 'RefSysCd', '102025', '102025', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_50', 'RefSysCd', '32628', '32628', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_51', 'RefSysCd', '32629', '32629', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_52', 'RefSysCd', '32630', '32630', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_53', 'RefSysCd', '32631', '32631', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_54', 'RefSysCd', '32632', '32632', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_55', 'RefSysCd', '32633', '32633', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_56', 'RefSysCd', '32634', '32634', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_57', 'RefSysCd', '32635', '32635', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_58', 'RefSysCd', '32636', '32636', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_59', 'RefSysCd', '32637', '32637', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_6', 'RefSysCd', '102026', '102026', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_60', 'RefSysCd', '32638', '32638', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_61', 'RefSysCd', 'unknown', '000', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_7', 'RefSysCd', '102027', '102027', 'false');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_1', 'RestrictCd', 'copyright', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_2', 'RestrictCd', 'patent', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_3', 'RestrictCd', 'patentPending', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_4', 'RestrictCd', 'trademark', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_5', 'RestrictCd', 'license', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_6', 'RestrictCd', 'intellectualPropertyRight', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_7', 'RestrictCd', 'restricted', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('RestrictCd_8', 'RestrictCd', 'otherRestrictions', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_1', 'RoleCd', 'resourceProvider', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_10', 'RoleCd', 'publisher', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_11', 'RoleCd', 'author', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_2', 'RoleCd', 'custodian', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_3', 'RoleCd', 'owner', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_4', 'RoleCd', 'user', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_5', 'RoleCd', 'distributor', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_6', 'RoleCd', 'originator', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_7', 'RoleCd', 'pointOfContact', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_8', 'RoleCd', 'principalInvestigator', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('RoleCd_9', 'RoleCd', 'processor', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('ScopeCd_5', 'ScopeCd', 'dataset', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('ScopeCd_6', 'ScopeCd', 'series', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('SpatRepTypCd_1', 'SpatRepTypCd', 'vector', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('SpatRepTypCd_2', 'SpatRepTypCd', 'grid', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('SpatRepTypCd_3', 'SpatRepTypCd', 'textTable', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('SpatRepTypCd_4', 'SpatRepTypCd', 'tin', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('SpatRepTypCd_5', 'SpatRepTypCd', 'stereoModel', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('SpatRepTypCd_6', 'SpatRepTypCd', 'video', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_1', 'TopicCatCd', 'farming', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_10', 'TopicCatCd', 'imageryBaseMapsEarthCover', '010', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_11', 'TopicCatCd', 'intelligenceMilitary', '011', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_12', 'TopicCatCd', 'inlandWaters', '012', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_13', 'TopicCatCd', 'location', '013', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_14', 'TopicCatCd', 'oceans', '014', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_15', 'TopicCatCd', 'planningCadastre', '015', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_16', 'TopicCatCd', 'society', '016', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_17', 'TopicCatCd', 'structure', '017', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_18', 'TopicCatCd', 'transportation', '018', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_19', 'TopicCatCd', 'utilitiesCommunication', '019', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_2', 'TopicCatCd', 'biota', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_3', 'TopicCatCd', 'boundaries', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_4', 'TopicCatCd', 'climatologyMeteorologyAtmosphere', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_5', 'TopicCatCd', 'economy', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_6', 'TopicCatCd', 'elevation', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_7', 'TopicCatCd', 'environment', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_8', 'TopicCatCd', 'geoscientificInformation', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('TopicCatCd_9', 'TopicCatCd', 'health', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_1', 'TopoLevCd', 'geometryOnly', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_2', 'TopoLevCd', 'topology1D', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_3', 'TopoLevCd', 'planarGraph', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_4', 'TopoLevCd', 'fullPlanarGraph', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_5', 'TopoLevCd', 'surfaceGraph', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_6', 'TopoLevCd', 'fullSurfaceGraph', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_7', 'TopoLevCd', 'topology3D', '007', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_8', 'TopoLevCd', 'fullTopology3D', '008', 'true');
INSERT INTO elmnt_code_list VALUES ('TopoLevCd_9', 'TopoLevCd', 'abstract', '009', 'true');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_8', 'RefSysCd', '102028', '102028', 'false');
INSERT INTO elmnt_code_list VALUES ('RefSysCd_9', 'RefSysCd', '102029', '102029', 'false');
INSERT INTO elmnt_code_list VALUES ('uom_1', 'uom', 'meter', 'm', 'false');
INSERT INTO elmnt_code_list VALUES ('uom_2', 'uom', 'centimeter', 'cm', 'false');
INSERT INTO elmnt_code_list VALUES ('uom_3', 'uom', 'kilometer', 'km', 'false');
INSERT INTO elmnt_code_list VALUES ('uom_4', 'uom', 'mile', 'mi', 'false');
INSERT INTO elmnt_code_list VALUES ('DCPList_1', 'DCPList', 'XML', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('DCPList_2', 'DCPList', 'CORBA', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('DCPList_3', 'DCPList', 'JAVA', '003', 'true');
INSERT INTO elmnt_code_list VALUES ('DCPList_4', 'DCPList', 'COM', '004', 'true');
INSERT INTO elmnt_code_list VALUES ('DCPList_5', 'DCPList', 'SQL', '005', 'true');
INSERT INTO elmnt_code_list VALUES ('DCPList_6', 'DCPList', 'WebServices', '006', 'true');
INSERT INTO elmnt_code_list VALUES ('CouplingTypeCd_1', 'CouplingTypeCd', 'loose', '001', 'true');
INSERT INTO elmnt_code_list VALUES ('CouplingTypeCd_2', 'CouplingTypeCd', 'mixed', '002', 'true');
INSERT INTO elmnt_code_list VALUES ('CouplingTypeCd_3', 'CouplingTypeCd', 'tight', '003', 'true');


--
-- Data for Name: elmnt_gabarit; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_ResponsibleParty_157', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_ResponsibleParty_71', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'EX_Extent_118', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'EX_GeographicBoundingBox_116', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_ReferenceSystem_99', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'RS_Identifier_131', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_ResponsibleParty_157', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_ResponsibleParty_71', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'EX_Extent_118', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'EX_GeographicBoundingBox_116', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_ReferenceSystem_99', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'RS_Identifier_131', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Resolution_115', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Resolution_115', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_LegalConstraints_259', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_LegalConstraints_259', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_RepresentativeFraction_123', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_RepresentativeFraction_123', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_ResponsibleParty_157', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_ResponsibleParty_71', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Series_78', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'EX_Extent_118', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'EX_GeographicBoundingBox_116', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_LegalConstraints_259', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_ReferenceSystem_99', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'RS_Identifier_131', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_RepresentativeFraction_123', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Resolution_115', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'EX_Extent_118', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'EX_GeographicBoundingBox_116', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_GridSpatialRepresentation_98', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_GeometricObjects_463', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_RepresentativeFraction_123', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Resolution_115', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_VectorSpatialRepresentation_102', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'EX_Extent_118', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'EX_GeographicBoundingBox_116', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Resolution_115', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Dimension_367', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_ReferenceSystem_99', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'RS_Identifier_131', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_ReferenceSystem_99', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'RS_Identifier_131', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_MaintenanceInformation_226', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_MaintenanceInformation_226', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_MaintenanceInformation_226', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'EX_Extent_118', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_ResponsibleParty_157', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_ResponsibleParty_71', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_ResponsibleParty_157', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_ResponsibleParty_71', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_ResponsibleParty_157', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_ResponsibleParty_71', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_ResponsibleParty_157', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_ResponsibleParty_71', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'EX_Extent_118', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_LegalConstraints_259', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_MaintenanceInformation_226', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Medium_294', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_BrowseGraphic_509', 'false', 2, '1', NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_BrowseGraphic_509', 'false', 2, '1', NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_BrowseGraphic_509', 'false', 2, '1', NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_BrowseGraphic_509', 'false', 2, '1', NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'DQ_DataQuality_106', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'DQ_Scope_439', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_ResponsibleParty_157', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_ResponsibleParty_71', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Series_78', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'EX_Extent_118', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_Keywords_113', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_LegalConstraints_259', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_MaintenanceInformation_226', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'LI_Lineage_441', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'CI_ResponsibleParty_280', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('doc_texte_num', 'MD_Format_220', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_LegalConstraints_259', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_MaintenanceInformation_226', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Address_177', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Address_75', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Citation_72', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Contact_168', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Contact_73', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Date_76', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_OnlineResource_184', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_OnlineResource_292', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Contact_316', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_ResponsibleParty_280', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_Format_220', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'CI_Address_322', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_Distribution_105', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_alpha', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('base_geo', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_num', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('carte_papier', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_raster', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('couche_vecteur', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('table_num', 'MD_Format_112', 'false', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_OnlineResource_455', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_OnlineResource_77', 'false', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_ResponsibleParty_157', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_ResponsibleParty_71', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'CI_Series_78', 'false', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'EX_Extent_118', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'EX_GeographicDescription_117', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_DataIdentification_68', 'true', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_DigitalTransferOptions_138', 'true', 1, '62', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_Distributor_137', 'true', 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO elmnt_gabarit VALUES ('refer_biblio', 'MD_Identifier_155', 'true', 0, '1', NULL, NULL, NULL, NULL, N