
----- 
-- Ajout des zones de sensbilités spécifiques au Langedoc Roussillon

-- Import données zonage de sensibilité du languedoc roussillon

CREATE TABLE gn_sensitivity.zonages_sensibilite (
    geom public.geometry(MultiPolygon,2154),
    cd_nom bigint,
    cd_tax_lr bigint,
    nom_vernac character varying(254),
    nom_latin character varying(254),
    source character varying(254),
    date_enr date,
    lib_zone character varying(254)
);


--
-- TOC entry 5898 (class 0 OID 263420)
-- Dependencies: 609
-- Data for Name: zonages_sensibilite; Type: TABLE DATA; Schema: gn_sensitivity; Owner: -
--

INSERT INTO gn_sensitivity.zonages_sensibilite (geom, cd_nom, cd_tax_lr, nom_vernac, nom_latin, source, date_enr, lib_zone) VALUES ('[encoded data, 189588 characters]', 2852, 42719, 'Gypaète barbu', 'Gypaetus barbatus', 'Contour PNA transmis le 16/09/2015 par Patrick Boudarel (DREAL)', '2015-09-18', 'Zonage PNA du domaine vital');
INSERT INTO gn_sensitivity.zonages_sensibilite (geom, cd_nom, cd_tax_lr, nom_vernac, nom_latin, source, date_enr, lib_zone) VALUES ('01060000206A080000020000000103000000010000001F000000FD38D2AD146E2841C69789E2BAF75741291B5C524F75284138CF30DDF7F75741C2BE6BAE997F284186D3BE043BF8574106F461E1479C2841EB155211E9F8574127991D19E0B72841707C3264B3F957418015DFFF7ECB2841F373C52DF1F85741B005D8EBE7E82841AE63E68A1EF95741B895CA8417EA2841C03A167EA8F55741108FA80FC5EE28413B0A1F9DBDF357410511D54CAFE02841ED42D5BC55F2574168E7A3ADBAD62841D38766CF91F05741FE46E89E33CA28413460566E92EF57410020AA9952C52841D8967AF589EE57419BD5FEEBA0BD2841AE25A030E4ED5741C4C2FE3289B328412402C81354ED57410B3D5680D3A8284109D7ACFE56ED574135B21F57279B28419D19766DC6EE57410283BFC2CD912841325170D47EEF5741B551E75127882841A65BC0C707F0574192599EB8048628410283833CBFEF5741D4B4A004928028417D5FDC7901F057416F598B28397A28417D72A03AD5EE57411FB8B989FA6E284123972DF390EF57417C88331FCC662841A981617023EF5741F36BB85678562841C48F9393B4F05741C7F616CD33522841F1239643D4F057417A0E070A504B28412885CDB519F1574112C7C3A8B8472841F31DDF4AEFF25741A50F05BDC24D2841CCC51F44F3F4574196F6E59E255D28419BB46DCC37F65741FD38D2AD146E2841C69789E2BAF75741010300000001000000150000007BB37423F6252841B17D56BFE8F75741F89587B36F292841DBBC961B92F75741F2DBB199E325284128458E8939F557412063FFADEE242841686B965A69F257412481F6BC0D212841A78CCE949FF15741F7C4D30EE41828416A48170683F05741B7592B4D951028413822A6CF7AF057414888F00E5103284188F7820BDAEF5741EE8FF4FF2CE5274194CF050096EE574192998FFF31D42741D620EEBAF9ED574102A141291DCA2741BE9B591197ED574190E73DE16EC42741652B56989FED5741A948EBADF5C0274161C1A6F9F7ED5741212614663BBB2741B47311D7EAEE5741B215DDCC55B82741AB1E413BB8EF57414DBCE05BECB32741A2B1EE72BAF05741A5F7D77A3EDA2741647475435FF35741F3C60EF603FA27415F4D876483F45741C6C190FFB80A28412D334E90EAF55741B875B5B2EC12284172B7A1F999F757417BB37423F6252841B17D56BFE8F75741', 3129, 42717, 'Glaréole à collier', 'Glareola pratincola', 'Proposition de Patrice Cramm le 29/09/2015 d''après les contours d''unités écologiques diffusés dans le cadre du programme de suivi larolimicoles.', '2015-10-15', 'Petite Camargue fluvio-lacustre, Etang de l''Or');
INSERT INTO gn_sensitivity.zonages_sensibilite (geom, cd_nom, cd_tax_lr, nom_vernac, nom_latin, source, date_enr, lib_zone) VALUES ('[encoded data, 331507 characters]