Georeference an image by knowing two Lat/Long coordinates? The 2019 Stack Overflow Developer Survey Results Are InConvert x, y position in georeferenced image (with world file) to longitude, latitude?How to find bounding coordinates (lat/long) for UTM zones?GDAL/proj4 equirectangular projection coordinate system units assumed by OGRSpatialReference and GDALDataset::GetGeoTransform()?How to georeference a map - which is in projected coordinate system - using geographic lat long?Converting local Coordinates to lat/long Coordinates using QGIS?Georeferencing LAS files in geographic coordinates (lat/lon) or in cartesian (projected) ones?Georeference a polyygon within a pdf fileConverting UTM to Lat/Long with a geoJSON file in pyprojConverting a shapefile from easting/northing to lat/longTransforming Lat/long data to UTM --2 different UTMSArcPy approach to add lat/long to CSV for multiple sets in one row

Can someone show me how to use the t-table and find p? Hypothesis testing

What do hard-Brexiteers want with respect to the Irish border?

Is it possible to force a package to be called last in the entirety of the LaTeX, when called in the class file?

Statement true because not provable

Why is the maximum length of OpenWrt’s root password 8 characters?

Are children permitted to help build the Beis Hamikdash?

Can someone be penalized for an "unlawful" act if no penalty is specified?

How to notate time signature switching consistently every measure

Resizing object distorts it (Illustrator CC 2018)

Aging parents with no investments

Which Sci-Fi work first showed weapon of galactic-scale mass destruction?

Is three citations per paragraph excessive for undergraduate research paper?

"as much details as you can remember"

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

Why isn't airport relocation done gradually?

How can I autofill dates in Excel excluding Sunday?

Why is my custom API endpoint not working?

Earliest use of the term "Galois extension"?

Multiply Two Integer Polynomials

What is the motivation for a law requiring 2 parties to consent for recording a conversation

What is the formula behind each level spell slot progression that I can use in a spreadsheet?

Where to refill my bottle in India?

Is an up-to-date browser secure on an out-of-date OS?

One word riddle: Vowel in the middle



Georeference an image by knowing two Lat/Long coordinates?



The 2019 Stack Overflow Developer Survey Results Are InConvert x, y position in georeferenced image (with world file) to longitude, latitude?How to find bounding coordinates (lat/long) for UTM zones?GDAL/proj4 equirectangular projection coordinate system units assumed by OGRSpatialReference and GDALDataset::GetGeoTransform()?How to georeference a map - which is in projected coordinate system - using geographic lat long?Converting local Coordinates to lat/long Coordinates using QGIS?Georeferencing LAS files in geographic coordinates (lat/lon) or in cartesian (projected) ones?Georeference a polyygon within a pdf fileConverting UTM to Lat/Long with a geoJSON file in pyprojConverting a shapefile from easting/northing to lat/longTransforming Lat/long data to UTM --2 different UTMSArcPy approach to add lat/long to CSV for multiple sets in one row



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















How can I georeference an unrotated image by knowing two Lat/Lng coordinates?



I tried to transform the coordinates to UTM, but this didn't work (for me), because I also need to rotate it and calculate with the angles, which seems to be complicated.



My aim is to calculate every other coordinate of the image by clicking on it.










share|improve this question









New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.















  • 2





    Which software are you using?

    – ahmadhanb
    Apr 5 at 9:51






  • 3





    Two points determine a line. Three points determine a plane. And five to ten links determine an image transformation with a decent enough RMS error to trust the result. Two points aren't nearly enough.

    – Vince
    Apr 5 at 10:09











  • @ahmadhanb I try to program this in JavaScript. Maybe I'm wrong here, but I thought, here I will get the math I need for it.

    – hideous
    Apr 5 at 10:23












  • If image is not rotated and already rectified (scanned map etc.) then two points is enough. Use for example gdal.org/gdal_translate.html with the option -a_ullr ulx uly lrx lry: Assign/override the georeferenced bounds of the output file. This assigns georeferenced bounds to the output file, ignoring what would have been derived from the source file. So this does not cause reprojection to the specified SRS.

    – user30184
    Apr 5 at 10:30







  • 1





    If you know the coordinates of the top-left pixel and pixel size you can write an ESRI worldfile en.wikipedia.org/wiki/World_file.

    – user30184
    Apr 5 at 10:44

















0















How can I georeference an unrotated image by knowing two Lat/Lng coordinates?



I tried to transform the coordinates to UTM, but this didn't work (for me), because I also need to rotate it and calculate with the angles, which seems to be complicated.



My aim is to calculate every other coordinate of the image by clicking on it.










share|improve this question









New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.















  • 2





    Which software are you using?

    – ahmadhanb
    Apr 5 at 9:51






  • 3





    Two points determine a line. Three points determine a plane. And five to ten links determine an image transformation with a decent enough RMS error to trust the result. Two points aren't nearly enough.

    – Vince
    Apr 5 at 10:09











  • @ahmadhanb I try to program this in JavaScript. Maybe I'm wrong here, but I thought, here I will get the math I need for it.

    – hideous
    Apr 5 at 10:23












  • If image is not rotated and already rectified (scanned map etc.) then two points is enough. Use for example gdal.org/gdal_translate.html with the option -a_ullr ulx uly lrx lry: Assign/override the georeferenced bounds of the output file. This assigns georeferenced bounds to the output file, ignoring what would have been derived from the source file. So this does not cause reprojection to the specified SRS.

    – user30184
    Apr 5 at 10:30







  • 1





    If you know the coordinates of the top-left pixel and pixel size you can write an ESRI worldfile en.wikipedia.org/wiki/World_file.

    – user30184
    Apr 5 at 10:44













0












0








0








How can I georeference an unrotated image by knowing two Lat/Lng coordinates?



I tried to transform the coordinates to UTM, but this didn't work (for me), because I also need to rotate it and calculate with the angles, which seems to be complicated.



My aim is to calculate every other coordinate of the image by clicking on it.










share|improve this question









New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












How can I georeference an unrotated image by knowing two Lat/Lng coordinates?



I tried to transform the coordinates to UTM, but this didn't work (for me), because I also need to rotate it and calculate with the angles, which seems to be complicated.



My aim is to calculate every other coordinate of the image by clicking on it.







coordinate-system georeferencing image utm






share|improve this question









New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited Apr 5 at 12:53









nmtoken

8,10042866




8,10042866






New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Apr 5 at 9:49









hideoushideous

1




1




New contributor




hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






hideous is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







  • 2





    Which software are you using?

    – ahmadhanb
    Apr 5 at 9:51






  • 3





    Two points determine a line. Three points determine a plane. And five to ten links determine an image transformation with a decent enough RMS error to trust the result. Two points aren't nearly enough.

    – Vince
    Apr 5 at 10:09











  • @ahmadhanb I try to program this in JavaScript. Maybe I'm wrong here, but I thought, here I will get the math I need for it.

    – hideous
    Apr 5 at 10:23












  • If image is not rotated and already rectified (scanned map etc.) then two points is enough. Use for example gdal.org/gdal_translate.html with the option -a_ullr ulx uly lrx lry: Assign/override the georeferenced bounds of the output file. This assigns georeferenced bounds to the output file, ignoring what would have been derived from the source file. So this does not cause reprojection to the specified SRS.

    – user30184
    Apr 5 at 10:30







  • 1





    If you know the coordinates of the top-left pixel and pixel size you can write an ESRI worldfile en.wikipedia.org/wiki/World_file.

    – user30184
    Apr 5 at 10:44












  • 2





    Which software are you using?

    – ahmadhanb
    Apr 5 at 9:51






  • 3





    Two points determine a line. Three points determine a plane. And five to ten links determine an image transformation with a decent enough RMS error to trust the result. Two points aren't nearly enough.

    – Vince
    Apr 5 at 10:09











  • @ahmadhanb I try to program this in JavaScript. Maybe I'm wrong here, but I thought, here I will get the math I need for it.

    – hideous
    Apr 5 at 10:23












  • If image is not rotated and already rectified (scanned map etc.) then two points is enough. Use for example gdal.org/gdal_translate.html with the option -a_ullr ulx uly lrx lry: Assign/override the georeferenced bounds of the output file. This assigns georeferenced bounds to the output file, ignoring what would have been derived from the source file. So this does not cause reprojection to the specified SRS.

    – user30184
    Apr 5 at 10:30







  • 1





    If you know the coordinates of the top-left pixel and pixel size you can write an ESRI worldfile en.wikipedia.org/wiki/World_file.

    – user30184
    Apr 5 at 10:44







2




2





Which software are you using?

– ahmadhanb
Apr 5 at 9:51





Which software are you using?

– ahmadhanb
Apr 5 at 9:51




3




3





Two points determine a line. Three points determine a plane. And five to ten links determine an image transformation with a decent enough RMS error to trust the result. Two points aren't nearly enough.

– Vince
Apr 5 at 10:09





Two points determine a line. Three points determine a plane. And five to ten links determine an image transformation with a decent enough RMS error to trust the result. Two points aren't nearly enough.

– Vince
Apr 5 at 10:09













@ahmadhanb I try to program this in JavaScript. Maybe I'm wrong here, but I thought, here I will get the math I need for it.

– hideous
Apr 5 at 10:23






@ahmadhanb I try to program this in JavaScript. Maybe I'm wrong here, but I thought, here I will get the math I need for it.

– hideous
Apr 5 at 10:23














If image is not rotated and already rectified (scanned map etc.) then two points is enough. Use for example gdal.org/gdal_translate.html with the option -a_ullr ulx uly lrx lry: Assign/override the georeferenced bounds of the output file. This assigns georeferenced bounds to the output file, ignoring what would have been derived from the source file. So this does not cause reprojection to the specified SRS.

– user30184
Apr 5 at 10:30






If image is not rotated and already rectified (scanned map etc.) then two points is enough. Use for example gdal.org/gdal_translate.html with the option -a_ullr ulx uly lrx lry: Assign/override the georeferenced bounds of the output file. This assigns georeferenced bounds to the output file, ignoring what would have been derived from the source file. So this does not cause reprojection to the specified SRS.

– user30184
Apr 5 at 10:30





1




1





If you know the coordinates of the top-left pixel and pixel size you can write an ESRI worldfile en.wikipedia.org/wiki/World_file.

– user30184
Apr 5 at 10:44





If you know the coordinates of the top-left pixel and pixel size you can write an ESRI worldfile en.wikipedia.org/wiki/World_file.

– user30184
Apr 5 at 10:44










1 Answer
1






active

oldest

votes


















0














Suppose you know that pixel (50, 75) is at (8.3, 2.3) degrees and pixel (250, 900) is at (12.3, 6.3) degrees.



Then your pixel width W is (12.3-8.3)/(250-50) and your pixel height H is (6.3 - 2.3)/(900-75)



Then your top left corner (centre of pixel (0,0)) is at (8.3 - 50*W, 2.3 - 75*H) - i.e. its 50 pixel widths left of the first reference pixel, and 75 pixel heights above it).



Your bottom right corner pixel centre is at top-left + (W * Number of columns), (H * Number of rows) - i.e. its that number of pixel widths across and down.



Those calculations give you pixel centres. Divide the width and height of the image in ground units by the number of height and width columns to get a pixel width and height, and then add or subtract half of one of those from your corner pixel centres to get pixel edges. Now you have the bounding box.



Now you can write a standard "World file" or other simple georeferencer.



Note this depends on your image being properly rectified and in the correct coordinate system, and north-up, and not subject to any distortions due to camera angle or field of view. But with two reference points you can't do any better.






share|improve this answer























  • Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

    – hideous
    Apr 5 at 14:08











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



);






hideous is a new contributor. Be nice, and check out our Code of Conduct.









draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317888%2fgeoreference-an-image-by-knowing-two-lat-long-coordinates%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









0














Suppose you know that pixel (50, 75) is at (8.3, 2.3) degrees and pixel (250, 900) is at (12.3, 6.3) degrees.



Then your pixel width W is (12.3-8.3)/(250-50) and your pixel height H is (6.3 - 2.3)/(900-75)



Then your top left corner (centre of pixel (0,0)) is at (8.3 - 50*W, 2.3 - 75*H) - i.e. its 50 pixel widths left of the first reference pixel, and 75 pixel heights above it).



Your bottom right corner pixel centre is at top-left + (W * Number of columns), (H * Number of rows) - i.e. its that number of pixel widths across and down.



Those calculations give you pixel centres. Divide the width and height of the image in ground units by the number of height and width columns to get a pixel width and height, and then add or subtract half of one of those from your corner pixel centres to get pixel edges. Now you have the bounding box.



Now you can write a standard "World file" or other simple georeferencer.



Note this depends on your image being properly rectified and in the correct coordinate system, and north-up, and not subject to any distortions due to camera angle or field of view. But with two reference points you can't do any better.






share|improve this answer























  • Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

    – hideous
    Apr 5 at 14:08















0














Suppose you know that pixel (50, 75) is at (8.3, 2.3) degrees and pixel (250, 900) is at (12.3, 6.3) degrees.



Then your pixel width W is (12.3-8.3)/(250-50) and your pixel height H is (6.3 - 2.3)/(900-75)



Then your top left corner (centre of pixel (0,0)) is at (8.3 - 50*W, 2.3 - 75*H) - i.e. its 50 pixel widths left of the first reference pixel, and 75 pixel heights above it).



Your bottom right corner pixel centre is at top-left + (W * Number of columns), (H * Number of rows) - i.e. its that number of pixel widths across and down.



Those calculations give you pixel centres. Divide the width and height of the image in ground units by the number of height and width columns to get a pixel width and height, and then add or subtract half of one of those from your corner pixel centres to get pixel edges. Now you have the bounding box.



Now you can write a standard "World file" or other simple georeferencer.



Note this depends on your image being properly rectified and in the correct coordinate system, and north-up, and not subject to any distortions due to camera angle or field of view. But with two reference points you can't do any better.






share|improve this answer























  • Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

    – hideous
    Apr 5 at 14:08













0












0








0







Suppose you know that pixel (50, 75) is at (8.3, 2.3) degrees and pixel (250, 900) is at (12.3, 6.3) degrees.



Then your pixel width W is (12.3-8.3)/(250-50) and your pixel height H is (6.3 - 2.3)/(900-75)



Then your top left corner (centre of pixel (0,0)) is at (8.3 - 50*W, 2.3 - 75*H) - i.e. its 50 pixel widths left of the first reference pixel, and 75 pixel heights above it).



Your bottom right corner pixel centre is at top-left + (W * Number of columns), (H * Number of rows) - i.e. its that number of pixel widths across and down.



Those calculations give you pixel centres. Divide the width and height of the image in ground units by the number of height and width columns to get a pixel width and height, and then add or subtract half of one of those from your corner pixel centres to get pixel edges. Now you have the bounding box.



Now you can write a standard "World file" or other simple georeferencer.



Note this depends on your image being properly rectified and in the correct coordinate system, and north-up, and not subject to any distortions due to camera angle or field of view. But with two reference points you can't do any better.






share|improve this answer













Suppose you know that pixel (50, 75) is at (8.3, 2.3) degrees and pixel (250, 900) is at (12.3, 6.3) degrees.



Then your pixel width W is (12.3-8.3)/(250-50) and your pixel height H is (6.3 - 2.3)/(900-75)



Then your top left corner (centre of pixel (0,0)) is at (8.3 - 50*W, 2.3 - 75*H) - i.e. its 50 pixel widths left of the first reference pixel, and 75 pixel heights above it).



Your bottom right corner pixel centre is at top-left + (W * Number of columns), (H * Number of rows) - i.e. its that number of pixel widths across and down.



Those calculations give you pixel centres. Divide the width and height of the image in ground units by the number of height and width columns to get a pixel width and height, and then add or subtract half of one of those from your corner pixel centres to get pixel edges. Now you have the bounding box.



Now you can write a standard "World file" or other simple georeferencer.



Note this depends on your image being properly rectified and in the correct coordinate system, and north-up, and not subject to any distortions due to camera angle or field of view. But with two reference points you can't do any better.







share|improve this answer












share|improve this answer



share|improve this answer










answered Apr 5 at 13:28









SpacedmanSpacedman

24.9k23551




24.9k23551












  • Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

    – hideous
    Apr 5 at 14:08

















  • Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

    – hideous
    Apr 5 at 14:08
















Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

– hideous
Apr 5 at 14:08





Thanks, for your answer so far. Will try this. My image is a construction plan, so it is not north up, but I can calculate the correct angle and transform the coordinate system, to get the correct pixel.

– hideous
Apr 5 at 14:08










hideous is a new contributor. Be nice, and check out our Code of Conduct.









draft saved

draft discarded


















hideous is a new contributor. Be nice, and check out our Code of Conduct.












hideous is a new contributor. Be nice, and check out our Code of Conduct.











hideous is a new contributor. Be nice, and check out our Code of Conduct.














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%2f317888%2fgeoreference-an-image-by-knowing-two-lat-long-coordinates%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