--
--


-- Started on 2025-10-15 11:08:20

SET transaction_timeout = 0;

DROP DATABASE db_cibel;
--
-- TOC entry 6189 (class 1262 OID 17575)
-- Name: db_cibel; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE db_cibel WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'French_France.1252';


ALTER DATABASE db_cibel OWNER TO postgres;
SET transaction_timeout = 0;

--
-- TOC entry 11 (class 2615 OID 17588)
-- Name: codelist; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA codelist;


ALTER SCHEMA codelist OWNER TO postgres;

--
-- TOC entry 6190 (class 0 OID 0)
-- Dependencies: 11
-- Name: SCHEMA codelist; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA codelist IS 'Code list table';


--
-- TOC entry 6191 (class 0 OID 0)
-- Dependencies: 7
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pg_database_owner
--

COMMENT ON SCHEMA public IS 'standard public schema table almost created by angular framework';


--
-- TOC entry 10 (class 2615 OID 17589)
-- Name: spatial; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA spatial;


ALTER SCHEMA spatial OWNER TO postgres;

--
-- TOC entry 6192 (class 0 OID 0)
-- Dependencies: 10
-- Name: SCHEMA spatial; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA spatial IS 'Schema for spatial data tables';


--
-- TOC entry 9 (class 2615 OID 17587)
-- Name: tabular; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA tabular;


ALTER SCHEMA tabular OWNER TO postgres;

--
-- TOC entry 6193 (class 0 OID 0)
-- Dependencies: 9
-- Name: SCHEMA tabular; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA tabular IS 'Dynamic tables';


--
-- TOC entry 3 (class 3079 OID 17894)
-- Name: pgcrypto; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;


--
-- TOC entry 6194 (class 0 OID 0)
-- Dependencies: 3
-- Name: EXTENSION pgcrypto; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';


--
-- TOC entry 4 (class 3079 OID 19798)
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- TOC entry 6195 (class 0 OID 0)
-- Dependencies: 4
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry and geography spatial types and functions';


--
-- TOC entry 2 (class 3079 OID 17576)
-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;


--
-- TOC entry 6196 (class 0 OID 0)
-- Dependencies: 2
-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';




--
-- TOC entry 250 (class 1259 OID 19538)
-- Name: collection_methods; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.collection_methods (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.collection_methods OWNER TO postgres;

--
-- TOC entry 236 (class 1259 OID 19012)
-- Name: currency; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.currency (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.currency OWNER TO postgres;

--
-- TOC entry 248 (class 1259 OID 19520)
-- Name: data_formats; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.data_formats (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.data_formats OWNER TO postgres;

--
-- TOC entry 249 (class 1259 OID 19528)
-- Name: data_licences; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.data_licences (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.data_licences OWNER TO postgres;

--
-- TOC entry 235 (class 1259 OID 19004)
-- Name: project_locations; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.project_locations (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.project_locations OWNER TO postgres;

--
-- TOC entry 251 (class 1259 OID 19546)
-- Name: thematic_categories; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.thematic_categories (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.thematic_categories OWNER TO postgres;

--
-- TOC entry 234 (class 1259 OID 18821)
-- Name: user_roles; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.user_roles (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.user_roles OWNER TO postgres;

--
-- TOC entry 232 (class 1259 OID 18762)
-- Name: cache; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.cache (
    key character varying(255) NOT NULL,
    value text NOT NULL,
    expiration integer NOT NULL
);


ALTER TABLE public.cache OWNER TO postgres;

--
-- TOC entry 233 (class 1259 OID 18769)
-- Name: cache_locks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.cache_locks (
    key character varying(255) NOT NULL,
    owner character varying(255) NOT NULL,
    expiration integer NOT NULL
);


ALTER TABLE public.cache_locks OWNER TO postgres;

--
-- TOC entry 231 (class 1259 OID 18751)
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO postgres;

--
-- TOC entry 230 (class 1259 OID 18750)
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres;

--
-- TOC entry 6197 (class 0 OID 0)
-- Dependencies: 230
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


--
-- TOC entry 229 (class 1259 OID 18743)
-- Name: job_batches; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.job_batches (
    id character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    total_jobs integer NOT NULL,
    pending_jobs integer NOT NULL,
    failed_jobs integer NOT NULL,
    failed_job_ids text NOT NULL,
    options text,
    cancelled_at integer,
    created_at integer NOT NULL,
    finished_at integer
);


ALTER TABLE public.job_batches OWNER TO postgres;

--
-- TOC entry 228 (class 1259 OID 18734)
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);


ALTER TABLE public.jobs OWNER TO postgres;

--
-- TOC entry 227 (class 1259 OID 18733)
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.jobs_id_seq OWNER TO postgres;

--
-- TOC entry 6198 (class 0 OID 0)
-- Dependencies: 227
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- TOC entry 224 (class 1259 OID 17591)
-- Name: migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO postgres;

--
-- TOC entry 223 (class 1259 OID 17590)
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.migrations_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres;

--
-- TOC entry 6199 (class 0 OID 0)
-- Dependencies: 223
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


--
-- TOC entry 241 (class 1259 OID 19426)
-- Name: password_reset_tokens; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.password_reset_tokens (
    email character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    created_at timestamp(0) without time zone
);


ALTER TABLE public.password_reset_tokens OWNER TO postgres;

--
-- TOC entry 225 (class 1259 OID 18710)
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.personal_access_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO postgres;

--
-- TOC entry 6200 (class 0 OID 0)
-- Dependencies: 225
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;

--
-- TOC entry 246 (class 1259 OID 19498)
-- Name: refresh_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.refresh_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.refresh_tokens_id_seq OWNER TO postgres;

--
-- TOC entry 6201 (class 0 OID 0)
-- Dependencies: 246
-- Name: refresh_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.refresh_tokens_id_seq OWNED BY public.refresh_tokens.id;


--
-- TOC entry 242 (class 1259 OID 19433)
-- Name: sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);


ALTER TABLE public.sessions OWNER TO postgres;

--
-- TOC entry 239 (class 1259 OID 19402)
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.users_id_seq OWNER TO postgres;

--
-- TOC entry 6202 (class 0 OID 0)
-- Dependencies: 239
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- TOC entry 263 (class 1259 OID 21033)
-- Name: agro_industrial_concession; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.agro_industrial_concession (
    id integer NOT NULL,
    type double precision,
    desc_type character varying(50),
    name character varying(50),
    culture character varying(50),
    departement character varying(50),
    admin_area_ha double precision,
    gis_area_ha double precision,
    country character varying(254),
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.agro_industrial_concession OWNER TO postgres;

--
-- TOC entry 262 (class 1259 OID 21032)
-- Name: agro-industrial concession_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial."agro-industrial concession_gid_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial."agro-industrial concession_gid_seq" OWNER TO postgres;

--
-- TOC entry 6203 (class 0 OID 0)
-- Dependencies: 262
-- Name: agro-industrial concession_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial."agro-industrial concession_gid_seq" OWNED BY spatial.agro_industrial_concession.id;


--
-- TOC entry 261 (class 1259 OID 21016)
-- Name: legend; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.legend (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    "table" character varying(255) NOT NULL,
    type character varying(255) DEFAULT 'POLYGON'::character varying NOT NULL,
    stroke_color character varying(255) NOT NULL,
    stroke_width double precision NOT NULL,
    fill_color character varying(255),
    layer_name character varying(255),
    zindex integer,
    CONSTRAINT legend_type_check CHECK (((type)::text = ANY ((ARRAY['POLYGON'::character varying, 'LINE'::character varying, 'POINT'::character varying])::text[])))
);


ALTER TABLE spatial.legend OWNER TO postgres;

--
-- TOC entry 277 (class 1259 OID 22815)
-- Name: mining_concession; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.mining_concession (
    id integer NOT NULL,
    holder character varying(30),
    ressource character varying(20),
    observation character varying(50),
    admin_area_ha numeric,
    gis_area_ha double precision,
    licence_number character varying(50),
    country character varying(254),
    geom public.geometry(MultiPolygon,3857),
    type character varying(255)
);


ALTER TABLE spatial.mining_concession OWNER TO postgres;

--
-- TOC entry 276 (class 1259 OID 22814)
-- Name: mining_concession_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.mining_concession_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.mining_concession_gid_seq OWNER TO postgres;

--
-- TOC entry 6204 (class 0 OID 0)
-- Dependencies: 276
-- Name: mining_concession_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.mining_concession_gid_seq OWNED BY spatial.mining_concession.id;


--
-- TOC entry 269 (class 1259 OID 22428)
-- Name: municipal_forest; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.municipal_forest (
    id integer NOT NULL,
    type character varying(254),
    attribution_type character varying(50),
    name character varying(50),
    assignee character varying(50),
    operator character varying(50),
    convention_status character varying(50),
    planning_status character varying(50),
    convention_date date,
    creation_date date,
    admin_area_ha double precision,
    gis_area_ha double precision,
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.municipal_forest OWNER TO postgres;

--
-- TOC entry 268 (class 1259 OID 22427)
-- Name: municipal_forest_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.municipal_forest_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.municipal_forest_gid_seq OWNER TO postgres;

--
-- TOC entry 6205 (class 0 OID 0)
-- Dependencies: 268
-- Name: municipal_forest_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.municipal_forest_gid_seq OWNED BY spatial.municipal_forest.id;


--
-- TOC entry 271 (class 1259 OID 22529)
-- Name: planted_area; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.planted_area (
    id integer NOT NULL,
    type character varying(254),
    gis_area_ha double precision,
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.planted_area OWNER TO postgres;

--
-- TOC entry 270 (class 1259 OID 22528)
-- Name: planted_area_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.planted_area_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.planted_area_gid_seq OWNER TO postgres;

--
-- TOC entry 6206 (class 0 OID 0)
-- Dependencies: 270
-- Name: planted_area_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.planted_area_gid_seq OWNED BY spatial.planted_area.id;


--
-- TOC entry 265 (class 1259 OID 21077)
-- Name: protected_area; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.protected_area (
    id integer NOT NULL,
    name character varying(50),
    partenar character varying(50),
    uicn_category character varying(50),
    creation_status character varying(50),
    planning_status character varying(50),
    admin_area_ha double precision,
    gis_area_ha double precision,
    type character varying(50),
    country character varying(50),
    province character varying(254),
    reference_decree character varying(254),
    statut character varying(60),
    source character varying(50),
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.protected_area OWNER TO postgres;

--
-- TOC entry 264 (class 1259 OID 21076)
-- Name: protected_area_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.protected_area_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.protected_area_gid_seq OWNER TO postgres;

--
-- TOC entry 6207 (class 0 OID 0)
-- Dependencies: 264
-- Name: protected_area_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.protected_area_gid_seq OWNED BY spatial.protected_area.id;


--
-- TOC entry 273 (class 1259 OID 22637)
-- Name: road; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.road (
    id integer NOT NULL,
    type character varying(25),
    national_code character varying(6),
    admin_length_km double precision,
    geom public.geometry(MultiLineString,3857)
);


ALTER TABLE spatial.road OWNER TO postgres;

--
-- TOC entry 272 (class 1259 OID 22636)
-- Name: road_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.road_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.road_gid_seq OWNER TO postgres;

--
-- TOC entry 6208 (class 0 OID 0)
-- Dependencies: 272
-- Name: road_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.road_gid_seq OWNED BY spatial.road.id;


--
-- TOC entry 260 (class 1259 OID 20974)
-- Name: tridom; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.tridom (
    id integer NOT NULL,
    name character varying(50),
    admin_area numeric,
    gis_area numeric,
    toponyme character varying(10),
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.tridom OWNER TO postgres;

--
-- TOC entry 259 (class 1259 OID 20973)
-- Name: tridom_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.tridom_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.tridom_gid_seq OWNER TO postgres;

--
-- TOC entry 6209 (class 0 OID 0)
-- Dependencies: 259
-- Name: tridom_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.tridom_gid_seq OWNED BY spatial.tridom.id;


--
-- TOC entry 275 (class 1259 OID 22732)
-- Name: ufa; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.ufa (
    id integer NOT NULL,
    type character varying(50),
    name character varying(50),
    attribution_status character varying(50),
    admin_area_ha double precision,
    gis_area_ha double precision,
    country character varying(254),
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.ufa OWNER TO postgres;

--
-- TOC entry 274 (class 1259 OID 22731)
-- Name: ufa_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.ufa_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.ufa_gid_seq OWNER TO postgres;

--
-- TOC entry 6210 (class 0 OID 0)
-- Dependencies: 274
-- Name: ufa_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.ufa_gid_seq OWNED BY spatial.ufa.id;


--
-- TOC entry 267 (class 1259 OID 21125)
-- Name: watercourse; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.watercourse (
    id integer NOT NULL,
    type character varying(50),
    name character varying(50),
    gis_length_km numeric,
    geom public.geometry(MultiLineString,3857)
);


ALTER TABLE spatial.watercourse OWNER TO postgres;

--
-- TOC entry 266 (class 1259 OID 21124)
-- Name: watercourse_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.watercourse_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.watercourse_gid_seq OWNER TO postgres;

--
-- TOC entry 6211 (class 0 OID 0)
-- Dependencies: 266
-- Name: watercourse_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.watercourse_gid_seq OWNED BY spatial.watercourse.id;


--
-- TOC entry 253 (class 1259 OID 19635)
-- Name: documents; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.documents (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    description text NOT NULL,
    size integer NOT NULL,
    publication_date timestamp(0) without time zone,
    author text,
    edition_year character varying(4),
    path text NOT NULL,
    project_id uuid NOT NULL,
    user_id uuid NOT NULL,
    role_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.documents OWNER TO postgres;

--
-- TOC entry 238 (class 1259 OID 19213)
-- Name: organizations; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.organizations (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    description text,
    logo character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.organizations OWNER TO postgres;

--
-- TOC entry 245 (class 1259 OID 19485)
-- Name: project_objectives; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.project_objectives (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    project_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.project_objectives OWNER TO postgres;

--
-- TOC entry 244 (class 1259 OID 19472)
-- Name: project_results; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.project_results (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    project_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.project_results OWNER TO postgres;

--
-- TOC entry 252 (class 1259 OID 19585)
-- Name: project_thematics; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.project_thematics (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    data_licence_id uuid,
    collection_method_ids json,
    data_format_ids json,
    project_id uuid NOT NULL,
    thematic_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.project_thematics OWNER TO postgres;

--
-- TOC entry 243 (class 1259 OID 19442)
-- Name: projects; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.projects (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    field character varying(255),
    location_id uuid,
    start_date timestamp(0) without time zone,
    end_date timestamp(0) without time zone,
    budget integer,
    currency_id uuid,
    organization_id uuid NOT NULL,
    user_id uuid NOT NULL,
    website character varying(255),
    manager_name character varying(255),
    manager_email character varying(255),
    manager_phone character varying(255),
    focal_point_name character varying(255),
    focal_point_email character varying(255),
    focal_point_phone character varying(255),
    main_objective text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    logo character varying(255),
    logo_copyright character varying(255)
);


ALTER TABLE tabular.projects OWNER TO postgres;

--
-- TOC entry 237 (class 1259 OID 19091)
-- Name: thematics; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.thematics (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    definition text,
    source character varying(255),
    source_link character varying(255),
    category_thematic_id uuid
);


ALTER TABLE tabular.thematics OWNER TO postgres;

--
-- TOC entry 5811 (class 2604 OID 18754)
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass);


--
-- TOC entry 5810 (class 2604 OID 18737)
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);


--
-- TOC entry 5808 (class 2604 OID 17594)
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass);


--
-- TOC entry 5833 (class 2604 OID 21036)
-- Name: agro_industrial_concession id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.agro_industrial_concession ALTER COLUMN id SET DEFAULT nextval('spatial."agro-industrial concession_gid_seq"'::regclass);


--
-- TOC entry 5840 (class 2604 OID 22818)
-- Name: mining_concession id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.mining_concession ALTER COLUMN id SET DEFAULT nextval('spatial.mining_concession_gid_seq'::regclass);


--
-- TOC entry 5836 (class 2604 OID 22431)
-- Name: municipal_forest id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.municipal_forest ALTER COLUMN id SET DEFAULT nextval('spatial.municipal_forest_gid_seq'::regclass);


--
-- TOC entry 5837 (class 2604 OID 22532)
-- Name: planted_area id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.planted_area ALTER COLUMN id SET DEFAULT nextval('spatial.planted_area_gid_seq'::regclass);


--
-- TOC entry 5834 (class 2604 OID 21080)
-- Name: protected_area id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.protected_area ALTER COLUMN id SET DEFAULT nextval('spatial.protected_area_gid_seq'::regclass);


--
-- TOC entry 5838 (class 2604 OID 22640)
-- Name: road id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.road ALTER COLUMN id SET DEFAULT nextval('spatial.road_gid_seq'::regclass);


--
-- TOC entry 5830 (class 2604 OID 20977)
-- Name: tridom id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.tridom ALTER COLUMN id SET DEFAULT nextval('spatial.tridom_gid_seq'::regclass);


--
-- TOC entry 5839 (class 2604 OID 22735)
-- Name: ufa id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.ufa ALTER COLUMN id SET DEFAULT nextval('spatial.ufa_gid_seq'::regclass);


--
-- TOC entry 5835 (class 2604 OID 21128)
-- Name: watercourse id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.watercourse ALTER COLUMN id SET DEFAULT nextval('spatial.watercourse_gid_seq'::regclass);


--
-- TOC entry 6161 (class 0 OID 19538)
-- Dependencies: 250
-- Data for Name: collection_methods; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.collection_methods VALUES ('e7b3e927-a8b0-4e74-a557-292d57dccc98', 'collection_method_interviews', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('5d892af8-8bff-42f6-bcbe-488f3451ce9b', 'collection_method_surveys', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('d3b299a4-2544-4eba-a433-cf110edcda81', 'collection_method_observation', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('94f089e2-8553-42db-8a98-9d095c8769f9', 'collection_method_documents_and_or_records', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('988b85f2-78e0-4c47-b15a-71675117890d', 'collection_method_discussion_group', '2025-06-27 09:42:20', '2025-06-27 09:42:20');


--
-- TOC entry 6147 (class 0 OID 19012)
-- Dependencies: 236
-- Data for Name: currency; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.currency VALUES ('8f52a997-59c9-488b-b2cd-7c8dfa301bb4', 'EURO', '2025-06-24 14:46:26', '2025-06-24 14:46:26');
INSERT INTO codelist.currency VALUES ('2893541d-843a-4f7f-af5c-5a1f8593bf06', 'USD', '2025-06-24 14:46:26', '2025-06-24 14:46:26');
INSERT INTO codelist.currency VALUES ('5a13ed76-a315-4122-845e-2a0a02937675', 'XAF', '2025-06-24 14:46:26', '2025-06-24 14:46:26');


--
-- TOC entry 6159 (class 0 OID 19520)
-- Dependencies: 248
-- Data for Name: data_formats; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.data_formats VALUES ('0fb251de-3206-446d-a58b-7cb2cc6f4da9', 'data_format_technical_report', '2025-06-27 09:41:46', '2025-06-27 09:41:46');
INSERT INTO codelist.data_formats VALUES ('7d784d1f-6cbb-47d6-99da-8150be228bb5', 'data_format_spatial_data', '2025-06-27 09:41:46', '2025-06-27 09:41:46');
INSERT INTO codelist.data_formats VALUES ('23427270-a3c8-4dce-aef9-9ad6ca82f06a', 'data_format_data_table', '2025-06-27 09:41:46', '2025-06-27 09:41:46');


--
-- TOC entry 6160 (class 0 OID 19528)
-- Dependencies: 249
-- Data for Name: data_licences; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.data_licences VALUES ('17f55ee6-0038-4fe3-b845-7770f9df540a', 'data_licence_commercial_name', 'data_licence_commercial_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');
INSERT INTO codelist.data_licences VALUES ('eb9a46d7-c7c7-4d41-8ed4-597370bb2ecb', 'data_licence_copyleft_name', 'data_licence_copyleft_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');
INSERT INTO codelist.data_licences VALUES ('d5b625e5-390b-41c4-87b4-6012f67d63f5', 'data_licence_free_name', 'data_licence_free_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');
INSERT INTO codelist.data_licences VALUES ('06b5188c-445b-46b1-a443-be4bfb67b899', 'data_licence_restricted_name', 'data_licence_restricted_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');


--
-- TOC entry 6146 (class 0 OID 19004)
-- Dependencies: 235
-- Data for Name: project_locations; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.project_locations VALUES ('f1ccfef1-2066-4c5b-903f-ed3212b16a28', 'location_cameroon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('5197d1e6-6442-4bf9-8597-f43db3bb5b8c', 'location_gabon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('079fad94-17ca-4812-9cac-83d77855ae9c', 'location_tridom', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('30504452-2cc6-48a7-8b9c-c961daa7ad26', 'location_cameroon_congo', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('b0433c9d-2370-42c1-a879-a82e155e12f6', 'location_cameroon_gabon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('1e4a6334-ea34-434c-a3bc-935c8038bed5', 'location_congo', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('e9325f73-7969-4da6-9870-41faa20442e5', 'location_congo_gabon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');


--
-- TOC entry 6162 (class 0 OID 19546)
-- Dependencies: 251
-- Data for Name: thematic_categories; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.thematic_categories VALUES ('00466f04-9471-43fc-a3ee-63db5e4ba2d0', 'category_thematic_focus', '2025-06-27 09:42:33', '2025-06-27 09:42:33');
INSERT INTO codelist.thematic_categories VALUES ('8cc0cd04-3bef-416d-8a01-7698cbd61f11', 'category_thematic_threat', '2025-06-27 09:42:33', '2025-06-27 09:42:33');
INSERT INTO codelist.thematic_categories VALUES ('c70981f9-44d7-48d3-ba6c-12623105aeae', 'category_thematic_opportunity', '2025-06-27 09:42:33', '2025-06-27 09:42:33');


--
-- TOC entry 6145 (class 0 OID 18821)
-- Dependencies: 234
-- Data for Name: user_roles; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.user_roles VALUES ('5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf', 'user_role_viewer', '2025-06-23 11:27:31', '2025-06-23 11:27:31');
INSERT INTO codelist.user_roles VALUES ('ca4e388b-b6c6-415a-9b47-3264d8257574', 'user_role_editor', '2025-06-23 11:27:31', '2025-06-23 11:27:31');
INSERT INTO codelist.user_roles VALUES ('883112a8-fed4-4c25-8e8d-e4e77ed46e59', 'user_role_administrator', '2025-06-23 11:27:31', '2025-06-23 11:27:31');


--
-- TOC entry 6143 (class 0 OID 18762)
-- Dependencies: 232
-- Data for Name: cache; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6144 (class 0 OID 18769)
-- Dependencies: 233
-- Data for Name: cache_locks; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6142 (class 0 OID 18751)
-- Dependencies: 231
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6140 (class 0 OID 18743)
-- Dependencies: 229
-- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6139 (class 0 OID 18734)
-- Dependencies: 228
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6135 (class 0 OID 17591)
-- Dependencies: 224
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.migrations VALUES (59, '0001_01_01_000002_create_jobs_table', 3);
INSERT INTO public.migrations VALUES (60, '0001_01_01_000001_create_cache_table', 4);
INSERT INTO public.migrations VALUES (61, '2025_06_20_080127_create_user_roles_table', 5);
INSERT INTO public.migrations VALUES (64, '2025_06_20_071430_create_refresh_tokens_table', 8);
INSERT INTO public.migrations VALUES (68, '2025_06_24_142726_create_project_locations_table', 9);
INSERT INTO public.migrations VALUES (69, '2025_06_24_144011_create_currency_table', 10);
INSERT INTO public.migrations VALUES (80, '2025_06_25_154059_create_organizations_table', 11);
INSERT INTO public.migrations VALUES (85, '2024_06_25_164402_create_users_table', 12);
INSERT INTO public.migrations VALUES (86, '2025_06_24_164635_create_projects_table', 13);
INSERT INTO public.migrations VALUES (87, '2025_06_25_164722_create_project_results_table', 14);
INSERT INTO public.migrations VALUES (88, '2025_06_25_164429_create_project_objectives_table', 15);
INSERT INTO public.migrations VALUES (89, '2025_06_25_071430_create_refresh_tokens_table', 16);
INSERT INTO public.migrations VALUES (90, '2025_06_27_083328_create_data_formats_table', 17);
INSERT INTO public.migrations VALUES (91, '2025_06_27_083338_create_data_licences_table', 18);
INSERT INTO public.migrations VALUES (92, '2025_06_27_083409_create_collection_methods_table', 19);
INSERT INTO public.migrations VALUES (93, '2025_06_27_083852_create_thematic_cathegories_table', 20);
INSERT INTO public.migrations VALUES (95, '2025_06_27_155136_create_project_thematics_table', 21);
INSERT INTO public.migrations VALUES (96, '2025_06_25_153823_create_documents_table', 22);
INSERT INTO public.migrations VALUES (97, '2025_07_03_153823_create_documents_table', 23);
INSERT INTO public.migrations VALUES (100, '2025_10_08_095446_create_legend_table', 24);


--
-- TOC entry 6153 (class 0 OID 19433)
-- Dependencies: 242
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.sessions VALUES ('gxORnKZeeWh3rSyTxmwncHzvvGSTOSKusGgsrRQD', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia1J2Um5CalhtQUNaeGZSbkV4cHc0NG00eHMxaXhaNWxJR0ZhV1NsNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1760516434);
INSERT INTO public.sessions VALUES ('pWW3WJ0mSetTjwAYn02NP4wMnvzbAw72zRdzIV2b', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTG1yQndqcThhbk1RdW1raVVJRTBjU2RPZ000d3MwUVljV0hNek5hciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519360);
INSERT INTO public.sessions VALUES ('5KjiPD5qUuHNHyvtNFwItcLQIRmZv7SKwpG9uMN8', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVNPSks2UXFJa29IYWpiZXpvQjJmMG0wamdXWkl3T1ZmdVl4Rkh1TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760520002);
INSERT INTO public.sessions VALUES ('QkhUnH2WCQ9S2f5148WQ0AHzSkokoFkZLlNVOmG7', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMGpoUUxtWmVHUEVDekZ1TnNWV2cwdkFFYTllVXFhQ21xbnRMWE1ENSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760515653);
INSERT INTO public.sessions VALUES ('4pl2TObaOvYimNLjUtbvOITZ7yubKsdtThl5Idrd', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiREw0WWxTaVBWV0EzaUltdVR6UnpsT2hidVRwWktzemd4VHRPbml0byI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760516444);
INSERT INTO public.sessions VALUES ('NYeAhwXI1sVgm7arjLcYGnc643iui96rx5VuyGyY', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidmhaa1FJNnBpeDVsZDRuOTlLNHBpcEx3ak5QR1pzQ0RzZEk0Rkt1YSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1760519364);
INSERT INTO public.sessions VALUES ('mvLhQ13xFgzIZTrwdDiHAAP0HbR3MK4cfLs3rZ8W', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMzZ0VWg0Mko3bDVsNHNySEh1TnRicFgyaG1QNUNpcmQyWHRpaW5oViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760520610);
INSERT INTO public.sessions VALUES ('T5ogFFC1p6KAslAjw3w8nHc4vdggH5PwkgyOZIiy', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZnVwYUZPWnE3UjdRUkdOODQ2Z0NFZ0lCSElJUGRlc2lIa1lkSnpJbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760515743);
INSERT INTO public.sessions VALUES ('2PiEcka6O4HHZiK79w6oeuxbfay04pJ2QgtOs9f6', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaUk2RUlaZUliUWFXWnJCcGVmakFnUnRYbUJHWFMxSWQwdllpWVNWUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760516829);
INSERT INTO public.sessions VALUES ('vFFgnMpJLyahSweX0GSlAp14SCifiVYUdf5uSgck', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWG5telRNME5NaXBycnhTbHVjSzFtV2FXUGlTWDg5SlV3T1ZzTlBlVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519374);
INSERT INTO public.sessions VALUES ('RCyqoVoIxYO3g1yyQ5734CxeXCz5jmMhfX9ffTup', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTTV6QmI0T0F1cTB6T2NxbTdHT3pCaGd4MnV0ZEdEOHgyYWVKWlVTdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760522582);
INSERT INTO public.sessions VALUES ('e5SOHH6L7RU5ib20UY8LgDTF7qLm1LA8d2uGXQgV', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSHUyUUZSV0N2TkdVN1NXY05KRFQyVVF2RjR0aHRHN3hhOVo5bW9uWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760515796);
INSERT INTO public.sessions VALUES ('LCLBpmL6FC7kHMkioDR2siaB5n5JLeSIJiE0flqh', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQlk2OG9ObFZIelFZZ2ZOV09XNVFJMGx1eDRVNExWOTlWSWp0QlN3VyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519042);
INSERT INTO public.sessions VALUES ('QYAqiuPGonWHoHyCfcPST9zolpydVnzmhWfmkDmg', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidDlMVHZZMWIybXI2SnNId3dZSUFidTJxQjN0Y1pvODNzMXo1YjJEWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1760519690);
INSERT INTO public.sessions VALUES ('BSlWrTXJiZ3bamcWv2LzXEdTvEnpOoGyMS2MwHZ9', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicEZ1SXRkTXp5eUpBMXZNd1lNZGNrMTNxU3FzMXF4dnlwZVlFMjJQRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760522610);
INSERT INTO public.sessions VALUES ('gmX50oCZWkwLNl9PXS5GPRtqtEW2znmxzfc4vXTb', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT3cyRklrUkRlbXlPRHpXc08xaVU4bGJjamJhVEFRUVl1bk53VjFaSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760516201);
INSERT INTO public.sessions VALUES ('nxNqzxkaC7b2fBLaSXLbXGdoP7o9FZqpzyD1IesE', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMWpDbmFYb292eW80Q3gyT3JXS0syREx4Y2FpYm83ZEZOS2RMbUQ0RCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519064);
INSERT INTO public.sessions VALUES ('0Fu9OlMp0ot0RqRrtfsVY7xxuDyssyhoaNYi15Bu', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2daeFNoZzVaMm9ydXFpNVFPbFBlZTd3ZjE1SmVsUFFyMnZRbk53RiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519693);
INSERT INTO public.sessions VALUES ('oSmuu5pJk899wo7fOQXy0DuWg3hnAcl1MdYFJPLA', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieVhHMjg3UHM4Z1lJYk5pc20zZ0o1b29TV1VMbGRBdXowa2Z1SmxGWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760522756);
INSERT INTO public.sessions VALUES ('IxfIXTDlekgbDvUZIZbNlprw4DfzQwJxCP059P1P', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidGRDZjFUV1JGTVdHWHJTUkVmZnBwSW8zUFgwakxYUzdlbjNFTjRoQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760516358);
INSERT INTO public.sessions VALUES ('W69JezndVHHeRUiXvWTRAo2kX6oYJ5gHOCEsvdNX', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieGRGV0VuTlJDZG5NOEgyMXI3SHVBZnAxaUZWaW1NUlpKSURRem5HRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519177);
INSERT INTO public.sessions VALUES ('vNO80g5babAO682JkOuL8I2SFKj9VPFFCTnJPW3h', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUUtiNG5SclBiSzB2anE2MUlnNnRWc0FNNVZkZmlkNTlmWk1TaW1MdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760519833);
INSERT INTO public.sessions VALUES ('xMB1ppdRBE11dVncWLkCw3W1qPbmzRnG4LIYyN7R', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibm50UjZwTnF3bnhWMm9vcWkyNzBJMkFjNE16WXdsYTQzR0pJemNYVCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO319', 1760522574);
INSERT INTO public.sessions VALUES ('h2srjOnndVC1OtO3CW2x8GS3lZYXY6NzV47C01GB', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMmFMdnRndkdHM0sxRzg4UmZLbEJRMkV6U2gyY1M4MWFWZ1hEeEZlUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvc3BhdGlhbC9sZWdlbmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1760522797);


--
-- TOC entry 6169 (class 0 OID 21033)
-- Dependencies: 263
-- Data for Name: agro_industrial_concession; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.agro_industrial_concession VALUES (1, 5110000, 'Plantation agro-industrielle', 'Palmeraie', 'Palmier à huile', 'Sangha', 20094, 20094, 'Congo', '0106000020110F0000010000000103000000010000002400000075677DEDCCF83A41A0E1C9DEF1BB03415177C4CF1CF73A41003871F43CA703419003AF72F3F33A416A67FD53A863034102CC400422F33A41225A9A7B7053034147185D8EAAEA3A41E7DB2BD35B84034129DD29729FE43A4160916097F092034153786C0DECDE3A417ECEC3A78EB30341FF74BA739FD53A4176AF86AD2CB003418E568E6302D13A412127419E3F790341B2C505B1A1CC3A410E7527EBE461034190603D5896C53A4163F091710E8703414892CC01DEBF3A41D02131870C760341E89AE69FA0BC3A41AD74F74A648F0341769D702F29B83A41A1525AEA1AB803419FDCF980EAB33A41DB8AC1867FDA0341638D70DD89AD3A41CF60A68904F303412D4F606A19AB3A410FDEA289A93704411BB918A2ADAC3A41F9DC7E54B2520441B64B7B50A0B33A416521F6613B550441C2C5EBCF72B43A4186E4661693B70441527692167DC63A41D3A1FD18BABA0441D942A3FCC5CD3A4197B6D78FDBC00441AA2B9FD25DCF3A417918778213FF0441BCFB4B1A7ECF3A411444F75D43220541BC4C97423CD83A410355A9E1DC2C05410C4054244ADE3A4108F7CD096F3805411D60E748A2DF3A4149E96E0166380541D64F2A2B1CE73A41423505761FEF04412389408040ED3A414EA211DE25BF0441F19D7FC57EF23A4154642C3FE2880441B32F74F9C9FD3A41292254ADE15704415CF8C48524023B41972A1F39C9320441488C8922AAFF3A413ED3AE05C40E0441DEEA3675F9FD3A4176F31FDAA5F40341E4FCA5AFD2F93A41FDA3F0B0CEE1034175677DEDCCF83A41A0E1C9DEF1BB0341');
INSERT INTO spatial.agro_industrial_concession VALUES (2, 5110000, 'Plantation agro-industrielle', 'Palmeraie', 'Palmier à huile', 'Sangha', 5726, 5726, 'Congo', '0106000020110F000001000000010300000001000000300000000B8658EF421F3B41CF752FDD11CD05416CC58031901D3B417B60482CD2A1054125604639761F3B417C3F8C3124950541592B9213F5243B41126D90B0EEA705414060C9AF17263B41DC0315B9FACB054155D47042CA2B3B416A5A3F3D5AAB0541B18228AB5B2E3B41637F755A3E9905415D23C257C42A3B41C11A66B14D870541E906DA56B5233B41CDC796E2607F05418E5C112BC81F3B41611B91ED3F6F05413E7CD46E31293B41F6A67C61EA780541AD6BB3BD63273B41C6BAD02B015D0541E2F44F4396263B41BAAD72F1ED2F05418AA8BED639243B4190163FBA7119054193DAED0DDE203B41893D77623D1C0541359F7468101F3B4144228DB95300054180D5C13CED1C3B4168AFC0BBEEE804415B6E9C293D1A3B41AE5488E500E90441BEECD81EE6193B412933DF3617DF04414AF2EBFEE2173B41986482DE29E80441FCBCD1476E163B41631226B133E80441EF3DB6E9F9153B416B17EA59FAD7044153BEE2529D123B41055FD25D8ED30441BA773C7B810D3B4182A0F6F3AAB30441C707C3C27D0B3B41AB461E0D54B704414C5872FB750C3B418DA4524B0DE30441D72934693A0A3B41A0A589C926F50441440CDF3B8F083B41691409C828110541F18D6BC701073B415FACA75D16370541039F850B8A033B41E5B5D52F014205415D0DEBD335033B4111CA0437275305414D32D407BFFF3A410358909217670541ABB782E94EFF3A41988F8300767F05418E0BBE1860073B41107E3CF18E85054138601A80DA0A3B411C26F2C5E59305411F324C466B0D3B4135C38708927A05418F05CE6BA9103B41985751B5DA6D05419E19CBF7AD113B413BC3C9A2478505416035AD58B5133B411AC14CD7E4A3054183EDA04E67173B41583B2F38FDA1054113DD138FA0153B416B9C294805C705411F7C0C7FA3153B41C88ADACA14E20541F4062F88C5173B41A1AE91AABFED0541807D9C9C72163B41C47BE3E4B01C06414B7045F5CC173B410A906A66663106411144566B661D3B41FAAA1357573006413E20830A781C3B41AB4EC0E148DE05410B8658EF421F3B41CF752FDD11CD0541');
INSERT INTO spatial.agro_industrial_concession VALUES (3, 5110000, 'Plantation agro-industrielle', 'Palmeraie', 'Palmier à huile', 'Cuvette Ouest', 1460, 1460, 'Congo', '0106000020110F0000060000000103000000010000001100000092E8481E7A353941C0D70968020DA3C099999909B831394161B010C75AF1A6C0FEDD02B9E42F39417135DD2486EAA3C02F4A7B13752C39412F26B29DAF36A5C0D4E53FB4D82A3941306B2CD43A0DA3C052B1DF20C52A39419DF8A5686020A3C07BB844FAA12A39411AA6FA708C31A2C04AC06F43283339413ECE45D4FC938FC0EA5E2C71413539414326B0701F119340B82338FC234039418717C9EBF265A0409371497886463941823AFC13535F9B40DD361AB0B04539413B06B29D2F989840EE5A428E934239419B22E2C718A784403D0378BBDB4039417A775C226CE83EC0887CD083D13E3941F5C02FBBA7E88AC06F3BDFFFBC3A39410A554AEAC48F99C092E8481E7A353941C0D70968020DA3C0010300000001000000040000003060E5603371394167DF238BEDD9B8400CF5B0CF87713941404AD530DC67B8403060E560337139417A7D8EE4226DB8403060E5603371394167DF238BEDD9B8400103000000010000000400000042E2DF9585693941D6FCCFB7ACA3B94033BB273F7F69394154CB88D24E3EB940FAC79BDCF1683941FC2208FE8052B94042E2DF9585693941D6FCCFB7ACA3B94001030000000100000006000000E59AF9D6B56C39417A5277DF951EBA407B0ACE14DC6D3941D6469AC0FEF9B940615986882E6C39418A6C423E780FBA40A1DF9E37D9693941D5E0AF66D103BB40EECE83BB516B39416052B13C4AFEBA40E59AF9D6B56C39417A5277DF951EBA400103000000010000000400000055DB3B89E571394120C2C98418EEBA403060E56033713941FB110F5F6A8DB9403060E56033713941985135035C61BB4055DB3B89E571394120C2C98418EEBA4001030000000100000005000000CAD32B1580703941C2D0718ADEA4BA409DDABE386770394196478E49189CBA406DC6C12D8A703941ABE8D6DCD3CEBB40994DC4E80D713941F81C81E39979BB40CAD32B1580703941C2D0718ADEA4BA40');
INSERT INTO spatial.agro_industrial_concession VALUES (4, 5110000, 'Plantation agro-industrielle', 'Projet Palm', 'Palmier à huile', 'Sangha', 134980, 134980, 'Congo', '[encoded data, 7060 characters]');
INSERT INTO spatial.agro_industrial_concession VALUES (5, 5110000, 'Plantation agro-industrielle', 'Projet Palm', 'Palmier à huile', 'Cuvette Ouest', 72091, 72091, 'Congo', '[encoded data, 5780 characters]');
INSERT INTO spatial.agro_industrial_concession VALUES (6, 5110000, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 191664, 191664, 'Congo', '[encoded data, 17460 characters]');
INSERT INTO spatial.agro_industrial_concession VALUES (7, 5110000, 'Plantation agro-industrielle', 'Zone à défricher ATAMA', NULL, 'Sangha', 4422, 4422, 'Congo', '0106000020110F0000010000000103000000010000000800000030C08FA6DA2A3A41CC4A38CC3ECBE840EBAA05B0422C3A4125EFFFE658CAE840B68B8B5C972E3A415EDB5E4646CAE8407938EEECAA423A4137B555C8C3C7E8409B3C4F21E63A3A4114B3DFCF14E2E44005AF47ABD63A3A41B303D26E3A93E440368E3685E3193A418E6B0F61F3D9E84030C08FA6DA2A3A41CC4A38CC3ECBE840');
INSERT INTO spatial.agro_industrial_concession VALUES (8, 5110000, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 0, 0, 'Congo', '0106000020110F00000100000001030000000100000004000000E1B46564AE4D3A419B0C822E4515E340FC6E2551B84D3A416461A53E9A13E34042354631A74D3A41C9E92C2BCA14E340E1B46564AE4D3A419B0C822E4515E340');
INSERT INTO spatial.agro_industrial_concession VALUES (9, 5110000, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 0, 0, 'Congo', '0106000020110F0000010000000103000000010000000600000030C05D22C8073A418A0A8DB2E5F6E3403D175BE2C8073A417E4D4213B9F5E34089954CBE6E073A41B2F5D9A470F6E340C9016FAB6E073A417BB31EB874F6E340031F29BA76073A41DDF677E300FBE34030C05D22C8073A418A0A8DB2E5F6E340');
INSERT INTO spatial.agro_industrial_concession VALUES (10, 5110000, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 2, 2, 'Congo', '0106000020110F000001000000010300000001000000060000006254462ED7CA3A4122F07F294EEFE44079CDE8C2CDC93A414BCFAF8433E4E440DE39F561D4C93A418C4A2F81CBECE440B31ECCA98CCA3A41266F22FB5DF8E440618F59DD8CCA3A418ED4183861F8E4406254462ED7CA3A4122F07F294EEFE440');
INSERT INTO spatial.agro_industrial_concession VALUES (11, 5110000, 'Plantation à grand echelle', 'Hevea Sud Plantation', 'hevea', NULL, 37763, 37763, 'Cameroun', '0106000020110F0000010000000103000000010000002900000071B37FA738293541C4215B3867E61441D80191CA992E35410F67A1A7C9CE1441A2529851EC303541B7979F49DBCE14410953C82EEF31354173DABCEAAFCD1441281EEF3F2A3335413727C3EEE0CC1441ECDAAD18EA343541902138F7C8D0144159B4C16F69353541DF4B0F5FA8CE14415D538BC916353541ED36DBFFF1C8144133E218BDE1333541DEB59DD88DC014414FDC96DD50333541C815FE5CAEBD1441FF9BA706EE33354103A46AB38EBA1441CC0F12A91236354143BC0F20BEB714416809CCD641383541660EF4215EB614419BF963FFFB393541616BF76B46B41441A58E5E7C463B3541E12644A158B414413E0F10F3AD3D354169F778A78EB514415E6FE223913F3541DF5AE1B5DFB81441C25779EA92413541F87292D4BCBD1441B0675BE54C433541B1C433B53EBD1441B9927AC5AA453541568A102FDCBA1441EAABA56C674835417EF30CAD53BE1441321CD5A1DA493541BFB072E650BE1441D042DFA1454C354164E94F8C07BB1441D6A79407104E354146139C3691B71441EC968B02F34E354172359841A4B31441B5BFED82E04D35417A6C47247EAB144151BDD567D24C3541403E81439FA614410FCC8787D84B3541625A83CF59A1144153DA8000844B35416919B804D89D14413CE01F23844C3541BC9B5CCF44991441877BA253C34D3541B5DD39A82E931441AA417C19914E3541EB98EAB5DD8F14413A44D7A766503541AD21905C699214416D1CF8B9CD5135417B0AC6DB4F8F14419D252E97CA4335419567FA7EBC1113411789CFED643B35411B8651DA9B30134180AB07AEBB0835411C1381A4E0EA1341702D5BA0050D3541D0C7E59EB4E91441FEEED9B11D20354164F7C250E4E914410590B54C37293541ED09D21858EF144171B37FA738293541C4215B3867E61441');
INSERT INTO spatial.agro_industrial_concession VALUES (12, 5110000, 'Plantation à grand echelle', 'Hevea Sud Plantation', 'hevea', NULL, 8274, 8274, 'Cameroun', '0106000020110F000001000000010300000001000000240000004E5DDC2098183541DF253A36FBEF154153392591D71A35419FD60134D1EC1541309E3A068B1C35418CC9DBA849F7154150640EE295213541560DAE0280F81541495321A5E3213541C2FD9961D9F41541CA26918C751F354136CCC49AA8F215410F30DB8E261D3541E4B5015931E81541F990D9255B1A35416B3443A5F1DE1541C1D9CDC15219354142256351CABF15417644B4EC4D1C35418B4787FB12BC154188B732F51E1D3541FDCFA3702DAE1541E39E3DA9A51B354125FD1F77F1A31541613002CE051D3541F5928822F49615411F7D869FC12035411F4AF8451A9A154148BB54B42A203541BAAC1054DE8F154160EFE3396D2235410EC05A34E980154175AAA3E6C8243541B1E77CA76E791541EBF6D24964243541E128CD588F711541B3F68411A81F35415A1FA5800E7515411D703F34721C3541D5C5A949676B1541D1246EE1091C3541E7C581DB97611541B5AFEE76071735413AD5E3853562154107EEBC8B7016354146F388631A50154175E2564E4D0D35411E0996203B48154142144254D7FF3441230924D284361541A9163D65E6F63441466244C2D0611541FBAF45085EFE3441B137DDFF7E751541EA7F2DB047033541F352A1DCA7901541D3E7F64CAC0335414D4F6625E1A71541106B05B5B9003541698EA5175CD41541EA7F2DB047033541CFBD9B8959E11541A28D7B70330C35417F20E7C032F115418CEAFAEF5D1135412E3B470D59041641DEB7F347EE19354107B369D62E041641556EC95D4A183541B92F1519EFFA15414E5DDC2098183541DF253A36FBEF1541');
INSERT INTO spatial.agro_industrial_concession VALUES (13, 5110000, 'Plantation à grand echelle', 'Hevea Sud Plantation', 'hevea', NULL, 29932, 29932, 'Cameroun', '[encoded data, 24628 characters]');


--
-- TOC entry 6167 (class 0 OID 21016)
-- Dependencies: 261
-- Data for Name: legend; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.legend VALUES ('25c63114-9dc5-4cd9-93e9-f8526d5d0b8c', 'mining_reseach_permit', 'spatial.mining_concession', 'POLYGON', '#42B1D7', 1, '#42B1D7', 'mining_permit', 9);
INSERT INTO spatial.legend VALUES ('333894ac-af94-43e5-b019-a904b289402c', 'mining_industrial_operating_permit', 'spatial.mining_concession', 'POLYGON', '#F8A0DF', 1, '#F8A0DF', 'mining_permit', 10);
INSERT INTO spatial.legend VALUES ('5795a81d-dd09-4e65-b42e-5c7226b65fba', 'mining_prospecting_permit', 'spatial.mining_concession', 'POLYGON', '#B176AF', 1, '#B176AF', 'mining_permit', 11);
INSERT INTO spatial.legend VALUES ('c06ad362-e833-4cc3-af98-71c66b0c4051', 'mining_operating_permit', 'spatial.mining_concession', 'POLYGON', '#FFE464', 1, '#FFE464', 'mining_permit', 12);
INSERT INTO spatial.legend VALUES ('607ef61c-b422-4217-98b8-068551dd577f', 'tridom_boundaries', 'spatial.tridom', 'POLYGON', 'rgba(0, 153, 255, 0.4)', 1.25, '#3399CC', 'boundaries', 0);
INSERT INTO spatial.legend VALUES ('1623128e-ffcc-4f01-8448-38e0ba130aed', 'wildlife_reserve', 'spatial.protected_area', 'POLYGON', '#282828', 1, '#55FF00', 'protected_area', 1);
INSERT INTO spatial.legend VALUES ('c7ccfa16-0fc8-4fa7-905d-264f23bb6675', 'national_parc', 'spatial.protected_area', 'POLYGON', '#030800', 1, '#38A800', 'protected_area', 2);
INSERT INTO spatial.legend VALUES ('b0275e9d-0842-4376-851b-05da222c4b1b', 'wildlife_sanctuary', 'spatial.protected_area', 'POLYGON', '#C500FF', 1, '#C500FF', 'protected_area', 3);
INSERT INTO spatial.legend VALUES ('1c11fd38-a921-4d8b-9a40-47da2092c2eb', 'gorilla_sanctuary', 'spatial.protected_area', 'POLYGON', '#FF73DF', 1, '#FF73DF', 'protected_area', 4);
INSERT INTO spatial.legend VALUES ('23add70f-0089-4e5c-9a2d-5aec22f4c326', 'main_road', 'spatial.road', 'LINE', '#8BA5C1', 6, NULL, 'roads', 5);
INSERT INTO spatial.legend VALUES ('925601f9-f8b9-49de-bb1a-4ad87b3497c3', 'others_road', 'spatial.road', 'LINE', '#8BA5C1', 2, NULL, 'roads', 7);
INSERT INTO spatial.legend VALUES ('d052efd8-3c44-4525-b4cc-a26bf6b47bd2', 'secondary_road', 'spatial.road', 'LINE', '#8BA5C1', 4, NULL, 'roads', 6);
INSERT INTO spatial.legend VALUES ('5dd57ecb-2808-4c2e-aa79-d2c05815d581', 'municipal_forest', 'spatial.road', 'POLYGON', '#DBD3D9', 1, '#FFBEE8', 'other_forests_types', 7);
INSERT INTO spatial.legend VALUES ('04185c81-1e24-4229-9f73-2e7c0ef3ef28', 'mining_semi_industrial_operating_permit', 'spatial.mining_concession', 'POLYGON', '#F07373', 1, '#F07373', 'mining_permit', 8);


--
-- TOC entry 6183 (class 0 OID 22815)
-- Dependencies: 277
-- Data for Name: mining_concession; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.mining_concession VALUES (68, 'Distribution Internationale s.', 'Or', 'Permis de recherches', 97657.19875650000, 97657, 'Décret n°2016-130', 'Congo', '0106000020110F00000100000001030000000100000041000000847B26D02E9C3A417F9A7947253A0A4199106A1BA19C3A414CB1521653390A41802FCDC94C9D3A413FA325646D390A41FF98ABBB849D3A41A92DB448B4390A41D6359B43609E3A41AAB820309A360A4186CE81E194A03A416553074E88360A412B0BC6D963A33A41510B4AFC8D420A410231776F48A43A4147C4833B2B440A411795E282C8A43A41FEFF789712450A412BE51D7744A53A4133D80E81F2450A416E41496D6BA53A411431C82E83450A41821826EE67A63A41F13ACA9AB2420A410A31B126D3AF3A4152D2E490D1270A418C19AD1D6EB43A411EBEDDFCAC1A0A41A8EB894D7EB43A41DADBB72FEC170A419811DD72A1B43A4114CB5FF63F150A418EF78B18D0B43A4147EB3166C80F0A4150EBF84E2CB53A41B4A6C8F6AC0B0A41DC2EF33C9CB53A41AD21DDA4B0070A41FBBCD76F06B63A417D5B00EF21050A410C9F9FE86CB63A411EBD324440040A41DD24D85EE3B63A418F3825F51A050A41E61EFE15F1B63A41F23F00A851050A414A1250EA6EB73A412CB9E90F91000A4125B5529F62B93A41066D66595DFD0941904521126CB93A4145F0D1284EFD094181793C0CBFBA3A4189ED7846EF010A41886A0E7481BD3A4186446B40950B0A419CBA3CC6C8C03A413D78FEADE0090A41D3ED92CB06C33A41C26FFECC2E010A4138747E733CC73A411C1DAD87DDF0094129AFD49684C83A412892BE5FF0E60941595F3AAFA7C83A41B67E067085E40941071A627E17C93A414E3FD1118BDF09410691FE2095C93A416AB68FB1DFDA0941E4D31AACE1C93A4164AC278F02D80941A0EEB84A2CCA3A417CA8D18025D50941F8C938085DCA3A41011527629ED30941DF6AEF3540CB3A41AAE5C59509C809412AEDDC87B0CB3A41C16AB9E34EC209415BA716E13CD13A41C44DE912EC960941CC173F0AD1D23A4138FF6125778009416FEBFF7313D33A41F31862EE5B79094146CBB4545AD33A4178A4EAF36D6C0941F499AC4881D33A414B2277ADCF6A0941F0C11D49A8D33A4152DA8E196F69094132C30AF830D43A417879AC1ECF5A0941672DA487BDD93A416DC7CE98D22D0941D023FE7513E33A412CAAFED2E9130941D98B88F790E53A4127577CE7AA080941C34A79BDC0E53A4142436348D3070941587075E640E83A4124EFF12F97EC08415EEF24E482E93A41004272F8E4DE08413B4D18BBB1EB3A410F8CDFF46BD408411BA4BBB54AF23A41CCAD61E152CF0841ECC73821EEF43A41FF473B363BC80841046A5B300AF23A4148159BE3FEEA04410658C1BE9D923A41A81A9BE3FEEA04413B59C1BE9D923A41F89416094B390A41794F787E18933A41DCB21874E24A0A41337161780C973A41FAD4011DFB430A41C226E9AB77993A41EB2D8E5F70400A413E5439E2D39A3A41CE41F30E8C3C0A4158FE08F8969B3A415AE86CD6D83A0A41847B26D02E9C3A417F9A7947253A0A41', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (69, 'Maud Congo s.a', 'Colombo-tantalite', 'Permis de recherches', 45672.45118580000, 45672, 'Décret n°2014-172', 'Congo', '0106000020110F0000010000000103000000010000003A000000D921BCFF964D38415F47EDABD7DBEF4007EF7CDC904B384115BDE74ED7DBEF40D12604BE524938413CD71D4BB3E3EF408FCB2EA63E4C3841B4A668F20502F04085A1C0FF654C3841D6C401C8DF02F040DD123BBA744E3841720FD1AB430EF040219A80E7AF5138413F2DC21F8927F040949CE25D64553841875317764145F0408322A2566B6038418172E5EA2EBEF0407EC785BC826938417B0BB53ADB1BF1401A0418650A6B3841584720101925F140916A9045B56D3841E5090EE5A630F14089C73116BD6D38418C18BCBEC830F1405AC16D78F47138417C7D2AEC0B43F1400B480C39BC6E3841E584DFD13896F1406487CB2F726E384193FA4B72B19DF140A43E9419556E384159C707DEA0A0F1402CDBA2BC3F6B384190BA937F49F0F14089823E67D6663841F8E7E05F4262F2407747AB04DC6738410C080CF1AADCF24006D25A89DC673841AA19AB03E9DCF240BAEEF055F7673841F5E540A872E9F2407B0631D2F767384141C3C1C9ACE9F240AF093412896D38415941811B3B53F34089FDADDFD56E384153B67FBAE06BF340E443D5D4D96E38417C5497C22B6CF340EBC5631936713841A2D223E3EB98F3400126C858DD793841B137AD196218F440D0A79ED86C7C38416F05F1271B3FF44086CB4DE3787E38419C52800A105EF440CDB10DBAD67F384153BDB3F5F58BF440518C1E62FF82384129909FA70CF6F44045F12156A9883841C29125E22147F540228F818C1E8A38418A1BC3D4B553F540FA042A1E528A384124D68EBF7255F540BB1FD21EFB8B384156EADE7AC563F540E862A8DDD58D384149D75054C573F54034E8DE9BFD90384159927EFDFD8EF54079067271D791384119CA88901DA0F540BB39AD1A2092384186318FC0D3A5F54066FC300A4393384129F133A9B6BAF54040F99218C7943841ADF99E6392D6F54034F3A3733E97384132AE322D0A0DF6407931940040993841C44137DF5739F640B4BA5A52F29B3841527D2C59D14CF640A71F546A939D384148B5D00AB458F640B3D32B15729F3841863401EB5766F6407D06D06FF89E38418381AD9EE68EF640F9C708FB57B63841160D788DE68EF640C3784E97F2B638417675868BE68EF64021482E97F2B63841B3EF550D938EF640BF022D97F2B63841404C3CC18F8EF640B9784E97F2B63841FCBBE74ED7DBEF40580C59DD76B63841B13D7A65D7DBEF4069EA02FB57B63841358D146BD7DBEF402798E3C043AB38410293B937D9DBEF40C51F4F08C3A63841A54E0DD3D9DBEF40D921BCFF964D38415F47EDABD7DBEF40', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (71, 'Mac Congo s.a.r.l', 'Or', 'Permis de recherches', 80612.47716330002, 80612, 'Decret n°2016-133
', 'Congo', '0106000020110F000001000000010300000001000000170000002D014DB3E4663841ADBDFF0D06B40D414033B7B3406A384144C234D45FA60D41A32BBC63466F3841B0BF2D1055B00D4149CBAC4DFD7038410FB95D55BBB30D41CB724A14337438414045E8A8D9A80D41DB3206BBB57738413696D865F39C0D414BB8F74D677D384127F1787DB3A50D41FA0187E27C8338410227B2D59B9C0D411790C7C127843841F8F9B3AE31970D41670D2C51378438412393D49A3F000A417B02C2C2427F3841FCFB744F40000A4144F04D44B335384190AA04CB42000A41915F25E6591838414993D49A3F000A4109CBAB3C5B1838413C86FD1B4A400B4185D1AD3C5B183841FB06FBA44B400B413F354F445F1838419E6B772968860D4135C990395D323841E07EE8B1B0890D41431745359237384154B553D3588A0D411010A3EAE64638410C09C128478C0D41BE9ACD727F4C3841ED18ED7C7E6C0D41A39199C8CA53384189732032CE700D411E2AFEB5D9583841C649E31540870D412D014DB3E4663841ADBDFF0D06B40D41', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (72, 'Mac Congo s.a.r.l', 'Or', 'Permis de recherches', 75776.30689610000, 75776, 'Décret n°2016-132', 'Congo', '0106000020110F0000010000000103000000010000000B0000005F0D2C51378438416F23EF3DB5A60641845F25E659183841B023EF3DB5A606411A15B18E591838414D9FE0EB27480741FF89B08E59183841D8EC373A29480741C857516559183841BCE43749B8DA0841CDD3FAA759183841CB24601FE6950941915F25E6591838414993D49A3F000A4144F04D44B335384190AA04CB42000A417B02C2C2427F3841FCFB744F40000A41670D2C51378438412393D49A3F000A415F0D2C51378438416F23EF3DB5A60641', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (4, 'CMTR', 'Cu', 'Autorisation en Mai 2007', 352185.41653300001, 352185, NULL, 'Gabon', '0106000020110F000001000000010300000001000000070000007FE08C37D8F13441E8DA3565EA4AE34087D205B085F33441988910B08295D740A6E933E812A63441AED592BAEEB5D740326F1AA93DA33441F59E4A7F83AFF640335DA7662493354187E80BC96696F640C1096B5F889035410CD02CDBB0A1E3407FE08C37D8F13441E8DA3565EA4AE340', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (5, 'AREVA', 'Mn', 'Autorisation en Mai 2007', 77737.71541860000, 77738, NULL, 'Gabon', '[encoded data, 30644 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (6, 'AREVA', 'Mn', 'Autorisation en Mai 2007', 413681.17754000000, 413681, NULL, 'Gabon', '[encoded data, 86050 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (1, 'ARC MINING', 'Au / EGP', 'Autorisation en Mai 2007', 473735.97983700002, 473736, NULL, 'Gabon', '[encoded data, 9620 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (2, 'CMTR', 'Cu', 'Autorisation en Mai 2007', 49634.46003010000, 49634, NULL, 'Gabon', '0106000020110F000001000000010300000001000000460000006FA1BE6D10823441A34AA7267BAACE40E725A429C7823441966DE7CDB724AA4056F43DC033833441AB3DAB819134AFC0C09FFDEF96833441C096FA6C59E5C4C0A23EC9F7A24834416E3AF55D07B4C4C03D92CB0FB248344147ACA44E68ABC4C0DD0209FADA4A344169F74A59EE5FC4C0809ECDFA874C344168696FF01512C3C032A2B4E7DF4B344124ABC64BBF7AC2C0DC1DA7B8D24A3441CEE9AE25CCF7C0C09BC64BE71D4934417BF197DD937FBDC0F4A7C67BD34934411782855A338BBBC02E1895E45748344191C3DA8ACDB6BAC0AE8BDBF88045344191E2B5843C73BAC011A5BD51FA453441121F63EE1A17B8C04DCA323493483441FB2FBB272F2BB6C00E5839640C48344163CF88D26E39B3C0FDA9F1422F423441DCC39F1A7FF5B1C0F5EBC0E9F44034413E14265355B3B0C04B3F7FAAD6403441FA1319E2FD1BB0C0D3E53F94824034418E044B5986EEACC0314CA6FAAB3D3441022D41F1C34BA5C042014D344E3C3441A5FCD478C9E1A4C0511E161A81393441A942499D809493C093B20CA1AF393441B98039B4487686C0904AEA74133934418455508D976E73C0560B89907338344105CD9F8C640A2CC050158CBA0E3834410C2EAC8BDBA66540C364AA1081353441507C302A2960884043C6DCE5673534418DF0F8A0279C96403EB4C8C6513534413C9AF1D22D26A0400E1B9E8E463334415B27D26FFF1CA540634BC8F74B3234410D03A3925A3AA4408458A88588313441781EFF21DD20A74040E38ACE69313441A9ECCDFC3F56A840D30968D212313441B166BA496CC2AB4081A757FAFA2F3441C2775AD39C33AF407509F9B0362E344124837CD02362B240E1F97EDAF62B344137B0B6624F82B240A1D634DF952B34414F31FF21AD6BB440121B9EAE462D3441E70F58398457B740CD76BE2FEA2F3441176139B4F8BFB840E1839E3D323134416FFB3C9B8586BB400B61C34355333441B5C5073D0BD8BC40E1E00BE3CC353441A87D14AE37BFBC401F4A7B137236344113205A640BFEBD40B5A44E1015343441B6CB6F5FD781BE40A24E40E38B323441D261105809D5BF40D31951CA81303441968148BFE567C140AF847C80D12D3441535C8FC20DF6C140735F07BE3B2C344178DEC798B37FC24085855AC3062C3441F8190456B6ADC340AE6054224D2D3441B32797FF6837C4402C992AE8E92E3441DA97BB9668BEC3402F6519725E2E34414EEED24D4AE2C440E061A186F42F3441820D0BB5EE88C54041AD69AE72313441423F0AD7ABADC5405D5452972D323441C127A089489CC6402D5C8FF2813434413B5A522738D2C640936CE74B66333441C22853057B68C8401DD26F2FEB3334410CF7CBEEF1EAC84011D044C8D332344123F5EDEB98B1C9404CFC18E3F6333441FA2B772D49E6CA406C1283909F3234415692CB7FA0B9CB40658FC205143334418149EA045CE8CC404C499D509B34344130D9E76A7336CD40AD69DEA14332344189EF7C3F9DE5CD4009B5D7BF1232344124E2BFB1BE54CE40CC310F81306534417E318BB48A8BCE406FA1BE6D10823441A34AA7267BAACE40', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (3, 'DOME VENTURE', 'Au / Cu / Ni', 'Autorisation en Mai 2007', 2093.89819481000, 2094, NULL, 'Gabon', '0106000020110F00000100000001030000000100000023000000582AE295BFB13341ECD950FB11FC0541DBC70E35BCB1334121DA763483D2034122C286F754B13341CEE2369A83E30341ED73B585FCAF33413DD881F3FE0804411C1FF45CFDB03341F0DE4F0D861D04411E85EB81B4AF334171BFEC1E863B04415E3BDFBFF5AF33413904C50F845A0441A1F8315659AF334166C3D3ABFF6E044180C729EAF8B0334164BB961061950441C4490C3264B13341EFFCF6F577AC04415F7FD96D74AD334115D42BE5A1C5044132A913C01EAB334157BE9F9A57DF04416239B438AFAA3341277F6A3C71EB044143E17A8423AD3341729CA2A33CEB04412DAB3EE7B1AE334125CD3BCE1AF90441FCB27B824AAE33418AF1D2CD290D0541A167B31AF2AD3341DE3A704EA81E0541B140825250AC334125925C7E311F0541C3E314CDF9AA33415C8B6C67C1180541BEF528CCA2AB33416B3789C15E28054131A91300F9A93341D5F67560F13D0541749318B42FA93341D4E68CA8F45D05410C8A1F3362A73341AC931884FB6F05414C158CBA3CA83341977EFBBA727905418B6CE74B41A933415D03E70C01750541217C61A260AA33411E23DB79B6870541AF7268A1B3A933416B2C439C98A505419D703D1A03A633416415FB4BA3BC0541BDDCB55493A833415F1804D6F0CD05417409F910F1A833414EADD8DFBCE5054122B0721801AA3341D6FEB2FBA5E705411C04567E40AB33418E7DAE36A2DF0541B0EA73E597AC3341262E9020B7F20541D181737607B03341736DC57E17FE0541582AE295BFB13341ECD950FB11FC0541', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (8, 'MOTAPA', 'U / Au / Mn', 'Permis de recherche Mai 2007', 43413.63417650001, 43414, NULL, 'Gabon', '[encoded data, 20500 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (10, 'MOTAPA', 'D', 'Permis de recherche Mai 2007', 153843.00095900000, 153843, NULL, 'Gabon', '[encoded data, 31278 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (7, 'CMTR', 'Fe', 'Permis de recherche Mai 2007', 125.65349784500, 126, NULL, 'Gabon', '0106000020110F0000010000000103000000010000004D00000091A0D07001173641B85807FFCAB4E4C0293A927B001736410B110BB510B8E4C04CEC2F6B1E1736413138674429BFE4C09DDFBE5E6F1736414162A1D688C5E4C00DA5BD11CF1736418B47E17AEAC8E4C097C420C0CF1736414865D5E7F8C8E4C08E3A013DE917364171BE52965DCBE4C01D166A7D2F183641EF67446913D4E4C06E711B9D31183641BD94F6069BD4E4C08D18048641183641480E4FAF22DDE4C059B1BFBC0818364111B27BF2EAE6E4C0FA8095F3FA17364122567DAE56E9E4C01E63EEEAE81736412B5227A083F5E4C07AA7575AE617364138FED47859F6E4C07BF4DB27BD1736419F131DC96BFEE4C067BE9F6A5D173641B1D6E76A7DFEE4C05A5DDC365C17364196131DC96BFEE4C0F9770B34161736415EF01648E0F5E4C0B8EC9E0C04173641E9DBD78171F4E4C098E848FEA516364110D634EF48F1E4C0490E2D82A3163641BC4ED1915AF1E4C0AAC876AE7F163641B0B5847C54F3E4C0FA31E67E5C163641997F26C2FEF9E4C009BE30A974163641F93108AC0A04E5C0DAF21F22C61636412F8B6CE7DF0AE5C015FDF625CE1636414F7AC729920BE5C0A813D074F216364115F697DD130FE5C0F5B27B624C173641B2F675E02014E5C0770B24D856173641ED234A7B6115E5C04BCA32B4761736418E1BEBE2641CE5C0FCC48FC127173641CE5AD3BC1923E5C05E3BDFDF2617364171A4DFBE3223E5C0A659F5891E173641B1E51DA72824E5C0AA1C5A74F11636415E6CE7FBFB2EE5C02FCD3BBEE016364192A245B6B333E5C00B6A4DE3AD163641B7AD69DE3F3EE5C0A535CD2B9A163641695C6DC53E43E5C00748508C781636416664AA60F64EE5C0FB5C6D356E1636419704C58F5358E5C04B8D97FE7B163641D864EE5A8464E5C00E363CCD7F163641BCE5D022156AE5C02D992AE87716364119081B9E5E76E5C0F75C6D356E1636419558CA32A079E5C08D75714B3116364156B6A6798183E5C04C59868830163641B66EA3019E83E5C08BB96BF9F0153641CBC320B0428DE5C0B6749388F0153641A03767444D8DE5C0AC7BF2E0BD153641934CC807EF90E5C07B58A8E55C153641586C09F9FC8FE5C05FF7E4B15B153641EEFE43FA1590E5C096C4200054153641674CC807EF90E5C01A9E5E394B1536415762A1D6EC9AE5C04EAF94F53D153641B333EF3841A7E5C0EB3845D73E1536413AE86A2B0CA8E5C07E58A8E55C15364174E61DA71EB1E5C07FC0CA51BE153641CAAACFD57EB1E5C0A6ADD88FBF153641F7A301BC89B1E5C0BEC117F6E91536418D0B022B55B3E5C0C944D82003163641A155EC2FE9BEE5C0A92E6E73041636417A107A36C3C1E5C0F987F4EB141636417DBF7D1D02CEE5C0169E5E99131636410ADB6800ADCEE5C0BDEC9EACFB153641ACCEAACFA1D4E5C0EEDBD7B19B1536419A0E4FAF76D3E5C0F6A9F1029A153641875AD3BC7DD3E5C016E4834E7715364148CEAACFA1D4E5C0FD31E61E54153641D6C1A8A4BCDFE5C037E17A643A1536412F022B87B0EBE5C05E07CE09281536414BE9043461F0E5C03D3EE8C9E21436417B228E7525F9E5C07A7A7C39D11436415CDE7D2B02FAE5C06416F0E9CD14364140E67B8A32EFE5C0EE85C924E01436417363EE5A54ECE5C01797FFE0D21436416F71689173E3E5C09B357332CA143641FE03757B0FE3E5C08DB27A776D14364122490D7139B4E4C091A0D07001173641B85807FFCAB4E4C0', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (9, 'MOTAPA', 'U / Au / Mn', 'Permis de recherche Mai 2007', 7860.77388787000, 7861, NULL, 'Gabon', '[encoded data, 7342 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (15, 'CAGEME', 'calcaire', 'Permis de recherche', 56572.72870230000, 56573, NULL, 'Cameroun', '0106000020110F0000010000000103000000010000000B000000CBEE0CD3A8C236419892334C8DB11241E06A819D086B36419E82858589B1124128A66F9D086B36416E46B74FD4B11241239F1A9E086B364183DD3869C43F13414CFDD408DC683641560586FE03831341FF8F2370ADC736412616552FD0D3134146FFBD5454EE36418B605D2CD0D31341513D5F5354EE36415D68636C8AB11241F6D05F5354EE364144A20C7C89B11241709B1263B3E536413D66CF898AB11241CBEE0CD3A8C236419892334C8DB11241', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (22, 'Compagnie Miniere du Cameroun', 'fer', 'Permis de recherche', 100447.87007900000, 100448, NULL, 'Cameroun', '0106000020110F00000100000001030000000100000007000000F24C1BC13E0F3841EBEECBE46A9B0D417BB5418FDC083841DDCCA8C161F610415B04ECFBABD43741B5BE788353FC10413DC968D62CD23741CFDD6BF2EBD51141ABF80668D35E3841F0FE5B7E930311413971DE410D603841C66684213ECD0D41F24C1BC13E0F3841EBEECBE46A9B0D41', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (35, 'AUCAM Sarl', 'general', 'Permis de recherche', 75081.39925180000, 75081, NULL, 'Cameroun', '0106000020110F0000010000000103000000010000000A000000C63A664FFA133641655D5B58E1E31241A7F851B7BB133641E009B311930E124186880A30FB31354156D52DBA52071241313C103550D23441B9506E4BC2DC1141A8F699EA09FE344165C0D158B1DA1241ED5266FD233835410AEC03216BC51241D35A690C593935414F14709FEB6B124106D564A430DF354116417D97E27B12414346063C8EDF3541358107610DD01241C63A664FFA133641655D5B58E1E31241', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (41, 'Zamba Holding', 'rutile', 'Permis de recherche', 14.40888939770, 14, NULL, 'Cameroun', '0106000020110F00000100000001030000000100000005000000ADC98E8E51D8344135939608BBCF1641D8066ACB81D73441EC2513C52BC71641CDC5FF1849D63441F6AD311ADFCC1641A323B96CC5D73441531FF4AC31D01641ADC98E8E51D8344135939608BBCF1641', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (47, 'Longsheng Cameroon Sa', 'fer', 'Permis de recherche', 24197.55044780000, 24198, NULL, 'Cameroun', '0106000020110F00000100000001030000000100000046000000EC424A07BC933441F484867F0E1C13417545966AF37B3441A48DA8993619124187F3D786E07B34411330C7F23E191241352EDF3FE8313441576EB059EA3912418770676101323441BF34CE73653B1241D1CCC486893B344149AF09FD2DCB12419DBDC167393C3441BBB35935D1CA1241000000D07D3D344114CCEE89F4C91241335530FA553E3441BFA44E80ABC812412B6519B2EA3E34410854E365EBC7124163EE5A92933F344133D1919C0FC71241DDF97E9AE43F3441945AD3FC19C61241D578E91668403441F1A06773E2C71241E17A147ED440344161FB3AB094C91241A20A46B547413441C39F1AEF98CB1241F20DBEC09F413441B92406C18CCC12411B51DA0B274234419F15FB0B2FCD124185EB51A8C242344101F9A0A7B5CD12416EC5FEC2E544344156BA494C5ACD1241B46054426F4534416F3BDF8F7ACB12414C302AF9AD493441C437F88282D0124115B5A629134A344169779CE28CCF124132C4B13E7F4A3441BE6D34C01ECF1241E1F0F49AFF4A34414D47723902CF12416FAC8B8BCA4B3441F7CF4498A3CF124193635DCC514C34410A2B87D6F3CF12419E1A2F0DD94C3441705374E4B0D01241B4D1004E604D3441F131E6EEE5D0124194C2F5F8D94D34418146943600D11241133FC62C464E3441C9BFECDED8D112417191EDECAB4E3441EE84EB118BD312419F01BCD5D1503441DD5E988C2CDA1241BEC117963852344128CA3204CDDB124105DE0219A0553441B1B6623F41DE12417F7AA5FC3A5734417433A2F4A4DA124161A1D604A25834416B900FBAA8DA1241845149CDEE593441C5BDC1D74CDE124144BD52A6095D3441F611147F23DF124194CB7F583D5E34413E9D80E68DDF124152C807AD83603441A77268D1CCD912417191ED4C276334418A0F7A768BD7124115D7A3408E643441BE2E6E63F6D712414BDA1B2C0F673441B9CFD59632D912412D431C5B07693441B1AACF15DEDE12415EFE434A0F6A3441A413D004E3E0124114143FF6F56A3441706CE7BBB3E11241E2839EDDC36D3441FC6C56BDF0E212418C8785AA446F34413205A35226E21241EE4A59F678713441CAEC9EFCC4E11241EEA7C61B48743441FB3311F646E7124104B37BE226763441E4BB05D26DE8124193F606AF7C78344182EE5A02ACE612412E08ACEC92793441B6ACFA1C09E612410C1B9EEE417A344187666626DAE612418F6588F3617B3441FD92A94274E912411C0DE0FD777C3441F02EDDE41CEA1241B037F8522A7F3441BC1E852B7EE9124112B7D1104C81344136FDF63522EB1241BF1E853B268434417F8CB9AB18F31241E1718A5E5A853441C9EA73F5EFF8124134871609FE8534417E559F6B11001341D2BCE3E407863441008A1F23D2021341F2EBC0E927873441A844D830BF051341ED38457779873441B8E314DD170B13417F48BFCD988834415D6588231112134135D49A56CB883441EBD24D22C31713419CE61D977D8B34412ABD52D63F181341549D8096D28D344194C2F568AC1B13419EC64B675C91344118AF252491201341EC424A07BC933441F484867F0E1C1341', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (57, 'Exploitation minière Yuan Don', 'Or', 'Permis de recherches', 10235.63562570000, 10236, 'Décret n°2015-980', 'Congo', '0106000020110F0000010000000103000000010000000C0000003B587A60D8933741F12513E65CB607419DC6D0F5AF7B3741DD2513E65CB60741A1C6D0F5AF7B374130194934DA5C0941851B2B24C9803741C0F2B66BDA5C09415113C65A0D9537414144B594DA5C094149DFA3810BA0374170194934DA5C0941DD5A427A0BA037417EF9BB7EBF4209414B8269810BA03741604509644AA10841B928B5B5709C3741C9795A704AA10841BE527F760D953741827B536A4AA108413F587A60D89337414C6ADC654AA108413B587A60D8933741F12513E65CB60741', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (80, 'Ossarha Congo Mining', 'Or', 'Permis d''exploitation semi-industrielle', 19035.13816470000, 19035, 'Arrêté n°7655', 'Congo', '0106000020110F00000100000001030000000100000008000000ED880A37E2D1384193C6C4BFF9D7EF40EB5619E776B6384128C6C4BFF9D7EF40580C59DD76B63841B13D7A65D7DBEF40A1AC42DD76B638412CEE6944E0DBEF40F9C708FB57B63841160D788DE68EF640BF022D97F2B63841404C3CC18F8EF640F7880A37E2D1384185B5D71A707FF640ED880A37E2D1384193C6C4BFF9D7EF40', 'Permis d''exploitation semi-industrielle');
INSERT INTO spatial.mining_concession VALUES (81, 'Southland Minerals Congo', 'Or', 'Autorisation de prospection', 79654.83615750000, 79655, 'Arrêté n°16174/MMG/CAB', 'Congo', '0106000020110F0000010000000103000000010000000D00000000CCD5A8E42637411E3CDCD04BA80441C42052FB87BE3641EB3BDCD04BA80441C22052FB87BE3641AAE4F98CEDA5074199A361BBB6C036411883E9D6D5C507415D2673B6FAD9364181DFAFE4263709410BDF3BBCFAD93641AC253A3927370941AE388C68E0EF36419D812A1D2D770A41383821B989F03641AB603D67D7800A4106CCD5A8E4263741A5603D67D7800A412BC07461C5FB364135CA475C003D0841B6ECB207E9F2364185BE3F7DD5C50741383821B989F036417FE4F98CEDA5074100CCD5A8E42637411E3CDCD04BA80441', 'Autorisation de prospection');
INSERT INTO spatial.mining_concession VALUES (82, 'Maud Congo s.a', 'Or', 'Autorisation de prospection', 45630.74300940000, 45631, 'Arrêté n°2627', 'Congo', '0106000020110F00000100000001030000000100000024000000BF022D97F2B63841404C3CC18F8EF640B9784E97F2B63841FCBBE74ED7DBEF40A1AC42DD76B638412CEE6944E0DBEF408EC700FB57B63841B54EDF80E2DBEF40C9B21608C3A63841275F4AEA02DDEF40D12604BE524938413CD71D4BB3E3EF408FCB2EA63E4C3841B4A668F20502F04085A1C0FF654C3841D6C401C8DF02F040DD123BBA744E3841720FD1AB430EF040CB48C1B34F5538412B8689C94145F04045FD9DAC566038412E1D14412FBEF040701CA6126E693841BB2BA093DB1BF1409D8755BBF56A3841AEAD96681925F140980AD7CEDF713841EAA315450C43F14055C7D1122B6B3841DD9A99DC49F0F14088F448BDC1663841BE54D0BD4262F240DE2C3428E367384175F6F829ADE9F2406849A16F217138417F415F48EC98F340416F31AFC8793841BE7030816218F44000ACC539647E38410D4A4B74105EF4404B928510C27F3841AAF5DC60F68BF440B16C96B8EA8238413D0BFA150DF6F440E94BBEAC94883841F055DE512247F540F89FB5F2E8903841B75D0A6FFE8EF54079067271D791384119CA88901DA0F540B6E4ACFBCD9438415D35DC3C92D6F540C60BDF87FE95384183659C5FD8F0F5401F3A98E346993841CCFA8AB75739F640B4BA5A52F29B3841527D2C59D14CF640A71F546A939D384148B5D00AB458F640B3D32B15729F3841863401EB5766F6407D06D06FF89E38418381AD9EE68EF640F9C708FB57B63841160D788DE68EF640C3784E97F2B638417675868BE68EF64021482E97F2B63841B3EF550D938EF640BF022D97F2B63841404C3CC18F8EF640', 'Autorisation de prospection');
INSERT INTO spatial.mining_concession VALUES (83, 'Maud Congo s.a', NULL, 'Permis d''exploitation semi-industrielle', 10830.66571810000, 10831, 'Arrêté n°34435', 'Congo', '0106000020110F00000100000001030000000100000009000000D7EF02FB57B638416CBCE74ED7DBEF40229A4F08C3A63841BCBBE74ED7DBEF40C51F4F08C3A63841A54E0DD3D9DBEF40C9B21608C3A63841275F4AEA02DDEF40229A4F08C3A638418775868BE68EF640F9C708FB57B63841160D788DE68EF6408EC700FB57B63841B54EDF80E2DBEF4069EA02FB57B63841358D146BD7DBEF40D7EF02FB57B638416CBCE74ED7DBEF40', 'Permis d''exploitation semi-industrielle');
INSERT INTO spatial.mining_concession VALUES (84, 'Maud Congo s.a', NULL, 'Permis d''exploitation semi-industrielle', 9103.58247682000, 9104, 'Arrêté n°34434', 'Congo', '0106000020110F00000100000001030000000100000005000000B107A2CF409C3841AA784E0CDEE10741A5004401B38438418D784E0CDEE10741AC004401B38438419B572325ABB90941B807A2CF409C38418C572325ABB90941B107A2CF409C3841AA784E0CDEE10741', 'Permis d''exploitation semi-industrielle');
INSERT INTO spatial.mining_concession VALUES (85, 'Maud Congo s.a', NULL, 'Permis d''exploitation semi-industrielle', 6310.62676384000, 6311, 'Arrêté n°34433', 'Congo', '0106000020110F0000010000000103000000010000000D000000E43E91DECC0738416F6F737AD3AE084146715F283F023841CE9C6768D3AE084143715F283F023841F991473DE5950941974E9BD2CC073841B7E91C96E595094192CB3287601738419044961CE6950941CDD3FAA759183841CB24601FE6950941CE534A2DB335384167B2553DE5950941B7FD00F7B33538419991473DE595094148AB492DB33538410EC22037E0950941C857516559183841BCE43749B8DA0841F34273D060173841AC31221287D4084175A4025777113841CE9C6768D3AE0841E43E91DECC0738416F6F737AD3AE0841', 'Permis d''exploitation semi-industrielle');
INSERT INTO spatial.mining_concession VALUES (78, 'Congo Mining Exploitation', 'Fer', 'Permis de recherches', 107672.25465000000, 107672, 'Décret n°2015-984', 'Congo', '[encoded data, 29844 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (79, 'Exploitation Minière du Congo', 'Diamants bruts', 'Permis de recherches', 14237.07042760000, 14237, 'Décret n°2015-104', 'Congo', '[encoded data, 20052 characters]', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (27, 'Fer du Cameroun', 'p_preciseuse', 'Permis de recherche', 47360.53795650000, 47361, NULL, 'Cameroun', '0106000020110F0000010000000103000000010000002F000000DCEB36999EF0394155E0D0A2D1240C414408172C8FF03941E2F4FB0D93240C415274BF4DDDC439412F7AA205449F0D413130238C2EB8394102C7023A09B80F41F66F493303123A4121A40BE0F83F0F419DA33E16F1113A412DB3DA0A3E280F415F350AB6D3123A41CEC866556CFD0E41E3CB09A7DF133A4197F518F36AE50E41C75EB3491D143A41B351A8B599BA0E41E62F2389F7153A4116A213509FAD0E4109191FF3D2123A41D3A58B5B7C760E41FBFE5EB76B123A4141C4104706630E410C0CD9ADD9163A41A44B272041360E41A7E4A705D1173A415D7561B216240E4146351380E5173A4131422E7F8B070E41D5373E47D9163A413A82D25E8BEF0D41E9EF5C8C69173A41C9D38A7D9FE00D4132203A1128153A41D67F385699D50D41A4B196EFCC153A41BEDA7A943EBE0D414244D1D0CC153A41443CADE906AE0D41ED808EE308153A415B233A12B4A70D4115826CE663143A41BBA9E169F29E0D4175C94D21F4143A41E9BCD3AB06900D414301D7E206143A41A3CFC5ED977B0D419CC1C381D1123A41FE52F539986F0D4103F7903D2E133A4167E16AAB4B620D41476D0239E4113A4104F1E4E106540D417175AE55F5113A41F96C461431380D41E7973C2B5C103A41458185DA4B260D412EA1C66AE00F3A4155BACA21911C0D41AC00F095390E3A41CD6E021A0E0B0D41403AA47EB30D3A41E55DCCDD22FC0C412F183806230D3A41E0998930B4E70C417BD824A5ED0B3A412A19F4EC37D50C4139E8511745093A41B49AF8B192C80C416AA09279E6073A41437E9E4DDFBD0C4179E904137A043A41B83A13E171B50C41D4EC9E9BC0023A4133227E0C38A80C415C13145E3F003A412EF3A0E7E1990C41FD4CC846B9FF394123971125818F0C41A212C73933FF394165D94F0D35820C4126BF743263FD3941055BE5504A730C41E55EB1BEC6FB3941AB2E11B6AB650C417367EED93EFA39418593BB16524E0C41694EBFFC05F739418A6678FA60400C415A35901FCDF33941C83345C7C9310C41DCEB36999EF0394155E0D0A2D1240C41', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (11, 'GEOVIC', 'ni_co', 'Permis d''exploitation', 85722.93175680000, 85723, NULL, 'Cameroun', '0106000020110F0000010000000103000000010000002F0000000BD79C1E2A0B384165F8B3135AFB164102AAA55B8B0B384100EBD91556FA1641244808AD6A0F38418994603859FA16419D3957CB7B0F38416C99995935FA1641702F430DC20F3841F71846A1FDF91641C408BEC0E61138417FEA73754AF81641CFF3A0F71914384125355E7AA8F81641D0EE6CA64615384153EE5A82D2F816417E1F06D10A1738418872685124F716418C0C144F67183841A29BC460FEF51641610F1D194D1A3841E353E3653BF616419D46A6FAF81B38410C27A0C94DF7164143387968B31C38415A6588A322F9164195832B7AC41C3841BDD6D775FDF91641CA393F75CC1C3841FD477FC563FA164162D66531812B38418124A3DC6EFA1641832CA361812B3841D8B8C5C4FCF91641B1247F0DEE2C38417C3DAEE10EB01341D8A3EA6129033841D98D18591BAD13417CD67E6A60B13741311A78DD1F2F134192CF252357B13741970AC312BB6E12412A374F82828B3741A7720EDA81661241CA0CD8B43587374162AD8A931730134182187FE06FB13741B8DB5A0A8730134183F1A1D738033841684521B106AE1341976D21BBF1023841B8A9F9C7A091144112845F9700EF374123959A15600B15419FB53C4DADEE37416502FEF6F0981641A528434CE5EE3741CF5E988C869916411F09E05DCAEF3741A534EFF8929B16411B1D1F84C5F1374138A60A8641A31641BDA19BB4C0F3374135A60A8641A31641BDB5DADABBF537419FBDC1D7CAA416415846EAD46FF63741031CEBA231AB1641B512484065F737410F29CBD0D3B01641CF4E05B33FF93741E841CFA69EB216418BA3C6BBBDFB37412E11367C53BB1641B777610251FC374168559F6BEFBF1641612DE6FE7602384103AB3E1746C91641AF8897BE46033841096744293ACB1641EE251845CA043841CFA4BD0138D516418C00A3E27D063841938AFDA589E116410EECF43A210838415C04C54FF0EF1641C35929BB2C093841448CB9AB66F5164191C2296AEF0A38416D88639DD7FA1641A42A6055180B38412C1EDF8C32FB16410BD79C1E2A0B384165F8B3135AFB1641', 'Permis d''exploitation');
INSERT INTO spatial.mining_concession VALUES (12, 'Midwest Mining & Refinery Co', 'p_preciseuse', 'Permis de recherche', 1180.26507706000, 1180, NULL, 'Cameroun', '0106000020110F0000040000000103000000010000000E000000FDC3F019D5453B411784D648903D0641DE6B86C3AA3B3B412E2F293503E20541A90375CBC1393B4183F565DBDC900641E6EF741B8A393B41C1E0DA96C8A40641076A26220A3C3B41B4394DE66D8B0641FF9F4E4C0A3C3B41F8FAC63A6C8B0641904762DCF63C3B410B9313504A880641348F08879B3F3B41D384551FD985064116743802DE433B41BF0104D68A840641B835EA3055453B414FE37EEAE47C0641375ED7DE54453B41C514F617DA79064157F5F82CE2443B411D5AAC0B4D690641A1D89E68DE443B419B31507C2C480641FDC3F019D5453B411784D648903D06410103000000010000000B000000C7BEC1C3C1383B4190A89F9ABBFE06416F6F2D4499383B41071236CDF4FA064192AFAD8522383B41E16F211674250741D0EC060ADF373B41F80EE6A69B3D07418CC9AD00D1373B416EE63FE9A14207415679BECBFC373B414386A2A36D410741501CC0473F383B41CC16B21DC53C074153C8DC0143383B4199ED558E293C0741F1635DE838393B41386D2FCC25350741F22DFF8DA7393B41F2EA4C0434220741C7BEC1C3C1383B4190A89F9ABBFE064101030000000100000004000000412ADDB0863C3B4133320C820DD00741F0C4A9CA933B3B411A8A595BFDC107412F4E1EF5873C3B41B4019A64A7DA0741412ADDB0863C3B4133320C820DD007410103000000010000000D00000008BE22894BAA3A41BDD39C91283F0A41DACD72F919AB3A4187FAC452D33B0A41821826EE67A63A41F13ACA9AB2420A411795E282C8A43A41FEFF789712450A4143C643F12EA43A412C18A758F3450A41270C9E6C4EA63A41FD06D0C4094F0A415B3A9D4E65A63A4168B0E394AC4E0A41108FCD58E5A63A41FEA203670B4D0A413A01362A6FA73A41161216EADA4A0A41A1E0637A16A83A41EAC9346F2A480A41127BB979D5A83A41E1E15AC229450A41C74D76DD7AA93A413BED7EEAA8420A4108BE22894BAA3A41BDD39C91283F0A41', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (28, 'MINING TECH SARL', 'p_preciseuse', 'Permis de recherche', 3.64699096031, 4, NULL, 'Cameroun', '0106000020110F00000200000001030000000100000006000000792DA09CD0103A41165DD4C33EFF0941F0B52F671D103A413299275206FC09419F3DCE0D34103A417E04CE8656010A419A1E53C445103A41EEB7C197F3FF094135F587735D103A41B08BEDFC9EFF0941792DA09CD0103A41165DD4C33EFF094101030000000100000007000000C2973F51A2953A4154665B8B294A0A41F40613B095953A4174E1AE3972470A41D12FD67591933A419366D5CF1A4D0A416AA21A5DE6933A41CFB539A3C74C0A4127EAD95AB7943A412FECE4E1B24B0A412DF41FA072953A41E3B4CA216F4A0A41C2973F51A2953A4154665B8B294A0A41', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (29, 'Venture Capital PLC', 'general', 'Permis de recherche', 86839.95966330000, 86840, NULL, 'Cameroun', '0106000020110F00000100000001030000000100000015000000DC490233120437411767567A89B11241F9269C32120437412EDE3656765A1241DA9F3E12D0193741D3DE9D54765A12410E7DD811D0193741E55D2212640312411C14DD92C77037415703840B64031241D8820992C7703741224B0048425511414E370C11D01937412217644E4255114197D45510D01937418BC0770124A710415970FB404FEB3641B9B4EEAE25A71041514D9AEC29CA36413C00DC8A24A71041239A8B8FD8C23641C261490724A71041B025E38FD8C23641957A17C132FE104100BA6F5154EE3641CB0720BE32FE1041E3DCD55154EE36414B915B5142551141DF75E46F96D83641564ED752425511410C4D437096D8364162FDBFC352AC11411DD4A090D8C2364137F458C552AC114158A5C491D8C236410BAA3E7F89B11241709B1263B3E536413D66CF898AB11241513D5F5354EE36415D68636C8AB11241DC490233120437411767567A89B11241', 'Permis de recherche');
INSERT INTO spatial.mining_concession VALUES (13, 'Botswana Diamonds', 'general', 'Permis de recherche', 366813.02353000001, 366813, NULL, 'Cameroun', '[encoded data, 10900 characters]', 'Permis de recherche');
