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

Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221

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