UPDATE tbl_srs
SET    parameters = '+proj=longlat +ellps=intl +datum=nzgd49 +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 4272
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=nzmg +lat_0=-41 +lon_0=173 +x_0=2510000 +y_0=6023150 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27200
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-36.87986527777778 +lon_0=174.7643393611111 +k=0.9999 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27205
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-37.76124980555556 +lon_0=176.46619725 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27206
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-38.62470277777778 +lon_0=177.8856362777778 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27207
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-39.65092930555556 +lon_0=176.6736805277778 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27208
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-39.13575830555556 +lon_0=174.22801175 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27209
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-39.51247038888889 +lon_0=175.6400368055556 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27210
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-40.24194713888889 +lon_0=175.4880996111111 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27211
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-40.92553263888889 +lon_0=175.6473496666667 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27212
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-41.30131963888888 +lon_0=174.7766231111111 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27213
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-40.71475905555556 +lon_0=172.6720465 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27214
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-41.27454472222222 +lon_0=173.2993168055555 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27215
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-41.28991152777778 +lon_0=172.1090281944444 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27216
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-41.81080286111111 +lon_0=171.5812600555556 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27217
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-42.33369427777778 +lon_0=171.5497713055556 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27218
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-42.68911658333333 +lon_0=173.0101333888889 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27219
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-41.54448666666666 +lon_0=173.8020741111111 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27220
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-42.88632236111111 +lon_0=170.9799935 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27221
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-43.11012813888889 +lon_0=170.2609258333333 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27222
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-43.97780288888889 +lon_0=168.606267 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27223
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-43.59063758333333 +lon_0=172.7271935833333 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27224
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-43.74871155555556 +lon_0=171.3607484722222 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27225
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-44.40222036111111 +lon_0=171.0572508333333 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27226
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-44.73526797222222 +lon_0=169.4677550833333 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27227
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-45.13290258333333 +lon_0=168.3986411944444 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27228
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-45.56372616666666 +lon_0=167.7388617777778 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27229
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-45.81619661111111 +lon_0=170.6285951666667 +k=1 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27230
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-45.86151336111111 +lon_0=170.2825891111111 +k=0.99996 +x_0=300000 +y_0=700000 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27231
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

UPDATE tbl_srs
SET    parameters = '+proj=tmerc +lat_0=-46.60000961111111 +lon_0=168.342872 +k=1 +x_0=300002.66 +y_0=699999.58 +ellps=intl +datum=nzgd49 +units=m +towgs84=59.47,-5.04,187.44,0.47,-0.1,1.024,-4.5993 +nadgrids=nzgd2kgrid0005.gsb +wktext +no_defs'
WHERE  srid = 27232
AND    parameters NOT LIKE '%+towgs84%+nadgrids%';

