INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values (3166, 'EPSG', 3166, '+proj=lcc +lat_0=-22.2697222222222 +lon_0=166.4425 +lat_1=-22.2447222222222 +lat_2=-22.2947222222222 +x_0=8.313 +y_0=-2.354 +ellps=intl +towgs84=-166.0684,-154.7826,254.8282,37.546,-7.7018,10.2029,-30.84 +units=m +no_defs +type=crs', 'PROJCS["NEA74 Noumea / Noumea Lambert 2",GEOGCS["NEA74 Noumea",DATUM["NEA74_Noumea",SPHEROID["International 1924",6378388,297],TOWGS84[-166.0684,-154.7826,254.8282,37.546,-7.7018,10.2029,-30.84]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4644"]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["latitude_of_origin",-22.2697222222222],PARAMETER["central_meridian",166.4425],PARAMETER["standard_parallel_1",-22.2447222222222],PARAMETER["standard_parallel_2",-22.2947222222222],PARAMETER["false_easting",8.313],PARAMETER["false_northing",-2.354],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","3166"]]');