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;








14















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



enter image description here
(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:



enter image description here



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?










share|improve this question
























  • 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


















14















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



enter image description here
(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:



enter image description here



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?










share|improve this question
























  • 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














14












14








14


4






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



enter image description here
(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:



enter image description here



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?










share|improve this question
















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



enter image description here
(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:



enter image description here



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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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


















  • 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











1 Answer
1






active

oldest

votes


















1














For the use of a NTv2 I create a custom CRS.



  1. Copy NTv2 to .. share proj

  2. Start QGIS (new)

  3. Define CRS (Settings-> Custom Projections)

  4. Check the Settings (Calulate)

enter image description here
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.






share|improve this answer




















  • 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











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
);



);













draft saved

draft discarded


















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









1














For the use of a NTv2 I create a custom CRS.



  1. Copy NTv2 to .. share proj

  2. Start QGIS (new)

  3. Define CRS (Settings-> Custom Projections)

  4. Check the Settings (Calulate)

enter image description here
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.






share|improve this answer




















  • 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














For the use of a NTv2 I create a custom CRS.



  1. Copy NTv2 to .. share proj

  2. Start QGIS (new)

  3. Define CRS (Settings-> Custom Projections)

  4. Check the Settings (Calulate)

enter image description here
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.






share|improve this answer




















  • 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








1







For the use of a NTv2 I create a custom CRS.



  1. Copy NTv2 to .. share proj

  2. Start QGIS (new)

  3. Define CRS (Settings-> Custom Projections)

  4. Check the Settings (Calulate)

enter image description here
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.






share|improve this answer















For the use of a NTv2 I create a custom CRS.



  1. Copy NTv2 to .. share proj

  2. Start QGIS (new)

  3. Define CRS (Settings-> Custom Projections)

  4. Check the Settings (Calulate)

enter image description here
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.







share|improve this answer














share|improve this answer



share|improve this answer








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












  • 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

















draft saved

draft discarded
















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Export of reprojected layer from GEE fails 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?Iterate over features and years to export images for each feature-yearEarth engine reproject: why does reprojecting a pixel at 30m scale gives me pixels with an area of ~550?Exporting slope raster for entire country in GEEGEE Landsat SR year composite // mask cloud / shadow out w/ other method than quality pixel"export region contains no valid (un-masked) pixels - Google Earth EgineGoogle Earth Engine, how to distinguish between rivers/streams and ponds/lakes in a water maskPython script tool fails when processing rainfall data from Google Earth EngineGoogle Earth Engine Error: Number of pixels requested from Image.load exceeds the maximum allowedCloudfree images in small area from Sentinel-2Using Image exportToDrive in Google Earth Engine?

Creating closest line along the point''s azimuth using PostgreSQL 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?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given