Integrating NTv2-transformation in QGIS? Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?How to use gridfiles (*.gsb) in QGISDifferent ways of NTv2-Grid integrationHow to save a joined spatialite table when each table contains PKUID fields?How to set GDAL/cs2cs/proj to use NTv2 grid shift file when using EPSG codes?Coordinate Transformation in Gdal/Ogr (EPSG:4326 to EPSG:3068)Integrate AT_GIS_GRID (NTv2 Transformation) in QGIS 2.8 & 2.10Analyze the extent of a NTv2 gridCoordinate transformation results are different between Proj4JS and pyprojProjNet. Coordinate reference system transformation deviationQGIS 3.2 - Forcing column type when importing csvAdding GDA2020 NTv2 transformation to ArcGIS 10.5Different ways of NTv2-Grid integration
Can an alien society believe that their star system is the universe?
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
What does the "x" in "x86" represent?
How do I stop a creek from eroding my steep embankment?
2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?
What is the escape velocity of a neutron particle (not neutron star)
Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?
How to answer "Have you ever been terminated?"
What is the meaning of the simile “quick as silk”?
How to superpose two composite qubit states?
Maximum summed powersets with non-adjacent items
Tht Aain’t Right... #2
What is this building called? (It was built in 2002)
Is it fair for a professor to grade us on the possession of past papers?
What is the meaning of the new sigil in Game of Thrones Season 8 intro?
Would "destroying" Wurmcoil Engine prevent its tokens from being created?
The logistics of corpse disposal
Wu formula for manifolds with boundary
Why are std::future and std::promise not final?
How do I find out the mythology and history of my Fortress?
How come Sam didn't become Lord of Horn Hill?
3 doors, three guards, one stone
Extracting terms with certain heads in a function
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
Integrating NTv2-transformation in QGIS?
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?How to use gridfiles (*.gsb) in QGISDifferent ways of NTv2-Grid integrationHow to save a joined spatialite table when each table contains PKUID fields?How to set GDAL/cs2cs/proj to use NTv2 grid shift file when using EPSG codes?Coordinate Transformation in Gdal/Ogr (EPSG:4326 to EPSG:3068)Integrate AT_GIS_GRID (NTv2 Transformation) in QGIS 2.8 & 2.10Analyze the extent of a NTv2 gridCoordinate transformation results are different between Proj4JS and pyprojProjNet. Coordinate reference system transformation deviationQGIS 3.2 - Forcing column type when importing csvAdding GDA2020 NTv2 transformation to ArcGIS 10.5Different ways of NTv2-Grid integration
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am wondering what's the correct way to integrate a NTv2-transformation in QGIS.
I have successfully integrated a NTv2-transformation in QGIS but I am not sure if it's done the way it's meant to be.
For integrating NTV2-grids in QGIS I found several information that the name of the grid should be stored in the p1 column of the table tbl_datum_transform of the srs.db:
https://github.com/qgis/QGIS/pull/1502#issuecomment-50580199
https://dragons8mycat.com/2014/03/03/gis-tips-getting-ostn02-to-work-with-qgis-2-2/
https://web.archive.org/web/20140224182157/http://sourcepole.ch/ntv2-transformations-with-qgis
http://isticktoit.net/?p=371

(Screenshot of http://www.gkg-kassel.de/pdf/Praezise_Transformation_im_QGIS_mit_Batchmodus.pdf (german) )
What makes me doubt if that's correct is the fact that the column seems to have a numeric field type:

Isn't the first parameter of a seven-parameter transformation stored in the p1 column of QGIS's tbl_datum_transform table?
According to the sqlite FAQ it's possible to store a string into a numeric column in sqlite ( https://sqlite.org/faq.html#q3 ) but it seems to me like a hack or workaround to store a string into a numeric column.
Is this really the way it's meant to be done?
tl;dr: What's the correct way to integrate a NTv2-transformation in QGIS?
qgis coordinate-system proj epsg
add a comment |
I am wondering what's the correct way to integrate a NTv2-transformation in QGIS.
I have successfully integrated a NTv2-transformation in QGIS but I am not sure if it's done the way it's meant to be.
For integrating NTV2-grids in QGIS I found several information that the name of the grid should be stored in the p1 column of the table tbl_datum_transform of the srs.db:
https://github.com/qgis/QGIS/pull/1502#issuecomment-50580199
https://dragons8mycat.com/2014/03/03/gis-tips-getting-ostn02-to-work-with-qgis-2-2/
https://web.archive.org/web/20140224182157/http://sourcepole.ch/ntv2-transformations-with-qgis
http://isticktoit.net/?p=371

(Screenshot of http://www.gkg-kassel.de/pdf/Praezise_Transformation_im_QGIS_mit_Batchmodus.pdf (german) )
What makes me doubt if that's correct is the fact that the column seems to have a numeric field type:

Isn't the first parameter of a seven-parameter transformation stored in the p1 column of QGIS's tbl_datum_transform table?
According to the sqlite FAQ it's possible to store a string into a numeric column in sqlite ( https://sqlite.org/faq.html#q3 ) but it seems to me like a hack or workaround to store a string into a numeric column.
Is this really the way it's meant to be done?
tl;dr: What's the correct way to integrate a NTv2-transformation in QGIS?
qgis coordinate-system proj epsg
Perhaps the Answer to this gis.stackexchange.com/questions/298011/… can give a hint?
– Jochen Schwarze
Oct 11 '18 at 6:29
@JochenSchwarze: thanks for the link but thats just the way it's done by me and as described in the 4 example links I added in my question. The main point of my question is not how to get it work (as it's already working) but if the way it's done is really the way it is meant to be done and why the name of the gridfile is written in the p1 column ...so probably a question adressed to QGIS devs
– markgraeflerland
Oct 11 '18 at 8:22
then it's perhaps worth raising an issue...
– Jochen Schwarze
Oct 11 '18 at 8:49
I am not a QGIS dev. But this link may help stackoverflow.com/questions/43290487/…. In the spirit of KISS, the QGIS devs probably just repurpose column p1 rather than having to add an extra column which also means extra codes to deal with it. And if you look through QGIS source codes - "Yes"! This was how they had intended for it.
– Ralph Tee
Nov 15 '18 at 5:41
add a comment |
I am wondering what's the correct way to integrate a NTv2-transformation in QGIS.
I have successfully integrated a NTv2-transformation in QGIS but I am not sure if it's done the way it's meant to be.
For integrating NTV2-grids in QGIS I found several information that the name of the grid should be stored in the p1 column of the table tbl_datum_transform of the srs.db:
https://github.com/qgis/QGIS/pull/1502#issuecomment-50580199
https://dragons8mycat.com/2014/03/03/gis-tips-getting-ostn02-to-work-with-qgis-2-2/
https://web.archive.org/web/20140224182157/http://sourcepole.ch/ntv2-transformations-with-qgis
http://isticktoit.net/?p=371

(Screenshot of http://www.gkg-kassel.de/pdf/Praezise_Transformation_im_QGIS_mit_Batchmodus.pdf (german) )
What makes me doubt if that's correct is the fact that the column seems to have a numeric field type:

Isn't the first parameter of a seven-parameter transformation stored in the p1 column of QGIS's tbl_datum_transform table?
According to the sqlite FAQ it's possible to store a string into a numeric column in sqlite ( https://sqlite.org/faq.html#q3 ) but it seems to me like a hack or workaround to store a string into a numeric column.
Is this really the way it's meant to be done?
tl;dr: What's the correct way to integrate a NTv2-transformation in QGIS?
qgis coordinate-system proj epsg
I am wondering what's the correct way to integrate a NTv2-transformation in QGIS.
I have successfully integrated a NTv2-transformation in QGIS but I am not sure if it's done the way it's meant to be.
For integrating NTV2-grids in QGIS I found several information that the name of the grid should be stored in the p1 column of the table tbl_datum_transform of the srs.db:
https://github.com/qgis/QGIS/pull/1502#issuecomment-50580199
https://dragons8mycat.com/2014/03/03/gis-tips-getting-ostn02-to-work-with-qgis-2-2/
https://web.archive.org/web/20140224182157/http://sourcepole.ch/ntv2-transformations-with-qgis
http://isticktoit.net/?p=371

(Screenshot of http://www.gkg-kassel.de/pdf/Praezise_Transformation_im_QGIS_mit_Batchmodus.pdf (german) )
What makes me doubt if that's correct is the fact that the column seems to have a numeric field type:

Isn't the first parameter of a seven-parameter transformation stored in the p1 column of QGIS's tbl_datum_transform table?
According to the sqlite FAQ it's possible to store a string into a numeric column in sqlite ( https://sqlite.org/faq.html#q3 ) but it seems to me like a hack or workaround to store a string into a numeric column.
Is this really the way it's meant to be done?
tl;dr: What's the correct way to integrate a NTv2-transformation in QGIS?
qgis coordinate-system proj epsg
qgis coordinate-system proj epsg
edited Nov 13 '18 at 14:03
markgraeflerland
asked Oct 10 '18 at 13:11
markgraeflerlandmarkgraeflerland
230321
230321
Perhaps the Answer to this gis.stackexchange.com/questions/298011/… can give a hint?
– Jochen Schwarze
Oct 11 '18 at 6:29
@JochenSchwarze: thanks for the link but thats just the way it's done by me and as described in the 4 example links I added in my question. The main point of my question is not how to get it work (as it's already working) but if the way it's done is really the way it is meant to be done and why the name of the gridfile is written in the p1 column ...so probably a question adressed to QGIS devs
– markgraeflerland
Oct 11 '18 at 8:22
then it's perhaps worth raising an issue...
– Jochen Schwarze
Oct 11 '18 at 8:49
I am not a QGIS dev. But this link may help stackoverflow.com/questions/43290487/…. In the spirit of KISS, the QGIS devs probably just repurpose column p1 rather than having to add an extra column which also means extra codes to deal with it. And if you look through QGIS source codes - "Yes"! This was how they had intended for it.
– Ralph Tee
Nov 15 '18 at 5:41
add a comment |
Perhaps the Answer to this gis.stackexchange.com/questions/298011/… can give a hint?
– Jochen Schwarze
Oct 11 '18 at 6:29
@JochenSchwarze: thanks for the link but thats just the way it's done by me and as described in the 4 example links I added in my question. The main point of my question is not how to get it work (as it's already working) but if the way it's done is really the way it is meant to be done and why the name of the gridfile is written in the p1 column ...so probably a question adressed to QGIS devs
– markgraeflerland
Oct 11 '18 at 8:22
then it's perhaps worth raising an issue...
– Jochen Schwarze
Oct 11 '18 at 8:49
I am not a QGIS dev. But this link may help stackoverflow.com/questions/43290487/…. In the spirit of KISS, the QGIS devs probably just repurpose column p1 rather than having to add an extra column which also means extra codes to deal with it. And if you look through QGIS source codes - "Yes"! This was how they had intended for it.
– Ralph Tee
Nov 15 '18 at 5:41
Perhaps the Answer to this gis.stackexchange.com/questions/298011/… can give a hint?
– Jochen Schwarze
Oct 11 '18 at 6:29
Perhaps the Answer to this gis.stackexchange.com/questions/298011/… can give a hint?
– Jochen Schwarze
Oct 11 '18 at 6:29
@JochenSchwarze: thanks for the link but thats just the way it's done by me and as described in the 4 example links I added in my question. The main point of my question is not how to get it work (as it's already working) but if the way it's done is really the way it is meant to be done and why the name of the gridfile is written in the p1 column ...so probably a question adressed to QGIS devs
– markgraeflerland
Oct 11 '18 at 8:22
@JochenSchwarze: thanks for the link but thats just the way it's done by me and as described in the 4 example links I added in my question. The main point of my question is not how to get it work (as it's already working) but if the way it's done is really the way it is meant to be done and why the name of the gridfile is written in the p1 column ...so probably a question adressed to QGIS devs
– markgraeflerland
Oct 11 '18 at 8:22
then it's perhaps worth raising an issue...
– Jochen Schwarze
Oct 11 '18 at 8:49
then it's perhaps worth raising an issue...
– Jochen Schwarze
Oct 11 '18 at 8:49
I am not a QGIS dev. But this link may help stackoverflow.com/questions/43290487/…. In the spirit of KISS, the QGIS devs probably just repurpose column p1 rather than having to add an extra column which also means extra codes to deal with it. And if you look through QGIS source codes - "Yes"! This was how they had intended for it.
– Ralph Tee
Nov 15 '18 at 5:41
I am not a QGIS dev. But this link may help stackoverflow.com/questions/43290487/…. In the spirit of KISS, the QGIS devs probably just repurpose column p1 rather than having to add an extra column which also means extra codes to deal with it. And if you look through QGIS source codes - "Yes"! This was how they had intended for it.
– Ralph Tee
Nov 15 '18 at 5:41
add a comment |
1 Answer
1
active
oldest
votes
For the use of a NTv2 I create a custom CRS.
- Copy NTv2 to .. share proj
- Start QGIS (new)
- Define CRS (Settings-> Custom Projections)
- Check the Settings (Calulate)

Whenever you use coordinates in the DHDN 3GK4 you bind them to the Custum CRS
Btw:
It is better and safer to migrate / save all data to ETRS89_UTM. Then you can work without the "On The Fly" transformation.
1
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f298465%2fintegrating-ntv2-transformation-in-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
For the use of a NTv2 I create a custom CRS.
- Copy NTv2 to .. share proj
- Start QGIS (new)
- Define CRS (Settings-> Custom Projections)
- Check the Settings (Calulate)

Whenever you use coordinates in the DHDN 3GK4 you bind them to the Custum CRS
Btw:
It is better and safer to migrate / save all data to ETRS89_UTM. Then you can work without the "On The Fly" transformation.
1
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
add a comment |
For the use of a NTv2 I create a custom CRS.
- Copy NTv2 to .. share proj
- Start QGIS (new)
- Define CRS (Settings-> Custom Projections)
- Check the Settings (Calulate)

Whenever you use coordinates in the DHDN 3GK4 you bind them to the Custum CRS
Btw:
It is better and safer to migrate / save all data to ETRS89_UTM. Then you can work without the "On The Fly" transformation.
1
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
add a comment |
For the use of a NTv2 I create a custom CRS.
- Copy NTv2 to .. share proj
- Start QGIS (new)
- Define CRS (Settings-> Custom Projections)
- Check the Settings (Calulate)

Whenever you use coordinates in the DHDN 3GK4 you bind them to the Custum CRS
Btw:
It is better and safer to migrate / save all data to ETRS89_UTM. Then you can work without the "On The Fly" transformation.
For the use of a NTv2 I create a custom CRS.
- Copy NTv2 to .. share proj
- Start QGIS (new)
- Define CRS (Settings-> Custom Projections)
- Check the Settings (Calulate)

Whenever you use coordinates in the DHDN 3GK4 you bind them to the Custum CRS
Btw:
It is better and safer to migrate / save all data to ETRS89_UTM. Then you can work without the "On The Fly" transformation.
edited Nov 14 '18 at 13:33
answered Nov 14 '18 at 13:26
MikeMike
9671314
9671314
1
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
add a comment |
1
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
1
1
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
I guess this will fail if you load a WMS that delivers EPSG:31467 (and nothing else).
– AndreJ
Nov 14 '18 at 16:11
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
For me it works this last solution! I will try to add to the QGIS manual
– Roberto Marzocchi
Apr 10 at 7:03
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f298465%2fintegrating-ntv2-transformation-in-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Perhaps the Answer to this gis.stackexchange.com/questions/298011/… can give a hint?
– Jochen Schwarze
Oct 11 '18 at 6:29
@JochenSchwarze: thanks for the link but thats just the way it's done by me and as described in the 4 example links I added in my question. The main point of my question is not how to get it work (as it's already working) but if the way it's done is really the way it is meant to be done and why the name of the gridfile is written in the p1 column ...so probably a question adressed to QGIS devs
– markgraeflerland
Oct 11 '18 at 8:22
then it's perhaps worth raising an issue...
– Jochen Schwarze
Oct 11 '18 at 8:49
I am not a QGIS dev. But this link may help stackoverflow.com/questions/43290487/…. In the spirit of KISS, the QGIS devs probably just repurpose column p1 rather than having to add an extra column which also means extra codes to deal with it. And if you look through QGIS source codes - "Yes"! This was how they had intended for it.
– Ralph Tee
Nov 15 '18 at 5:41