BEGIN TRANSACTION;
-- Delete old values
DELETE FROM "tbl_srs" [WHERE "srid" = 310024142 OR "srid" = 310024143  OR "srid" = 310024144 OR "srid" = 310024145 OR "srid" = 310024146 OR "srid" = 310024147 OR "srid" = 310024148 OR "srid" = 310024149 OR "srid" = 310024150 OR "srid" = 310024140]
-- Specify the use of the natgrid, this is useful when reprojecting from RGF93 to NTF
INSERT INTO "tbl_srs" VALUES(100113,'310024142','Projection conique conforme Zone 1','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 1 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=42.000000000 +lon_0=3.000000000 +lat_1=41.250000000 +lat_2=42.750000000 +x_0=1700000.000 +y_0=1200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC42','0','0');
INSERT INTO "tbl_srs" VALUES(100114,'310024143','Projection conique conforme Zone 2','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 2 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=43.000000000 +lon_0=3.000000000 +lat_1=42.250000000 +lat_2=43.750000000 +x_0=1700000.000 +y_0=2200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC43','0','0');
INSERT INTO "tbl_srs" VALUES(100115,'310024144','Projection conique conforme Zone 3','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 3 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=44.000000000 +lon_0=3.000000000 +lat_1=43.250000000 +lat_2=44.750000000 +x_0=1700000.000 +y_0=3200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC44','0','0');
INSERT INTO "tbl_srs" VALUES(100116,'310024145','Projection conique conforme Zone 4','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 4 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=45.000000000 +lon_0=3.000000000 +lat_1=44.250000000 +lat_2=45.750000000 +x_0=1700000.000 +y_0=4200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC45','0','0');
INSERT INTO "tbl_srs" VALUES(100117,'310024146','Projection conique conforme Zone 5','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 5 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=46.000000000 +lon_0=3.000000000 +lat_1=45.250000000 +lat_2=46.750000000 +x_0=1700000.000 +y_0=5200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC46','0','0');
INSERT INTO "tbl_srs" VALUES(100118,'310024147','Projection conique conforme Zone 6','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 6 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=47.000000000 +lon_0=3.000000000 +lat_1=46.250000000 +lat_2=47.750000000 +x_0=1700000.000 +y_0=6200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC47','0','0');
INSERT INTO "tbl_srs" VALUES(100119,'310024148','Projection conique conforme Zone 7','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 7 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=48.000000000 +lon_0=3.000000000 +lat_1=47.250000000 +lat_2=48.750000000 +x_0=1700000.000 +y_0=7200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC48','0','0');
INSERT INTO "tbl_srs" VALUES(100120,'310024149','Projection conique conforme Zone 8','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 8 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=49.000000000 +lon_0=3.000000000 +lat_1=48.250000000 +lat_2=49.750000000 +x_0=1700000.000 +y_0=8200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC49','0','0');
INSERT INTO "tbl_srs" VALUES(100121,'310024150','Projection conique conforme Zone 9','lcc','IGNF:ELG037','+title=Projection conique conforme Zone 9 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=50.000000000 +lon_0=3.000000000 +lat_1=49.250000000 +lat_2=50.750000000 +x_0=1700000.000 +y_0=9200000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','RGF93CC50','0','0');
INSERT INTO "tbl_srs" VALUES(100097,'310024140','Lambert 93','lcc','IGNF:ELG037','+title=Lambert 93 +proj=lcc +towgs84=0.0000,0.0000,0.0000 +a=6378137.0000 +rf=298.2572221010000 +lat_0=46.500000000 +lon_0=3.000000000 +lat_1=44.000000000 +lat_2=49.000000000 +x_0=700000.000 +y_0=6600000.000 +units=m +no_defs +wktext +nadgrids=ntf_r93.gsb,null','IGNF','LAMB93','0','0');
COMMIT;
