How to get POI in city in OpenStreetMap through Overpass API with cURL? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How to get WKT or GEOJson by country or city name with Overpass API?How can I geocode to a shape instead of a coordinate?Overpass API: Get coordinates of postal boundaryAlternative overpass api for OpenStreetmap locations query?How to get the intersections lat/lng on overpass api?Openstreemap Overpass API to get Couture linesCan you restrict which OSM tags are returned by Overpass API?Using Overpass Turbo to return all cemeteries (nodes, ways and relations) with their municipalityCounting schools with Overpass API?Overpass get Street in City

Didn't get enough time to take a Coding Test - what to do now?

Synthesis of a weinreb amide from an acid

How do you keep chess fun when your opponent constantly beats you?

List only local user accounts with a single command

Change bounding box of math glyphs in LuaTeX

Derivation tree not rendering

The variadic template constructor of my class cannot modify my class members, why is that so?

Windows 10: How to Lock (not sleep) laptop on lid close?

How does this infinite series simplify to an integral?

Finding the path in a graph from A to B then back to A with a minimum of shared edges

Are my PIs rude or am I just being too sensitive?

how can a perfect fourth interval be considered either consonant or dissonant?

How does ice melt when immersed in water

In horse breeding, what is the female equivalent of putting a horse out "to stud"?

Create an outline of font

Was credit for the black hole image misattributed?

RT6224D-based step down circuit yields 0V - why?

verb not working in beamer even though I use [fragile]

Hopping to infinity along a string of digits

Am I ethically obligated to go into work on an off day if the reason is sudden?

Who or what is the being for whom Being is a question for Heidegger?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

What force causes entropy to increase?

How to tell if two pearson correlations from the same sample differ significanly



How to get POI in city in OpenStreetMap through Overpass API with cURL?



The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How to get WKT or GEOJson by country or city name with Overpass API?How can I geocode to a shape instead of a coordinate?Overpass API: Get coordinates of postal boundaryAlternative overpass api for OpenStreetmap locations query?How to get the intersections lat/lng on overpass api?Openstreemap Overpass API to get Couture linesCan you restrict which OSM tags are returned by Overpass API?Using Overpass Turbo to return all cemeteries (nodes, ways and relations) with their municipalityCounting schools with Overpass API?Overpass get Street in City



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








1















I'm very new to OpenStreetMap's Overpass QL API. After digging through its hefty wiki and several tutorials I get the feeling that if I want to query for a city I can use either area[name="Tbilisi"][boundary=administrative] or geocodeArea:Tbilisi. I think [boundary=administrative] helps identify it as a city or at least some kind of official entity like a state or municipality rather than, say, part of the name of a cafe. I don't know if I am right.



Following that, I should be able to get restaurants in Tbilisi with the area[name="Tbilisi"][boundary=administrative] syntax on Overpass Turbo like so:



area[name="Tbilisi"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


However, it returns '"elements": []'. out count returns a total of 0.



I then tried with geocodeArea:Tbilisi:



geocodeArea:Tbilisi->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


This returned a very long list of elements, out count total is 419.



Unfortunately, I can't use geocodeArea:Tbilisi with cURL like this:



curl --globoff 'https://overpass-api.de/api/interpreter?data=[out:json];geocodeArea:Tbilisi->.searchArea;node["amenity"="restaurant"](area.searchArea);out;'


It gives:



...
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: Unknown type "{" </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: An empty query is not allowed </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: ';' expected - '{' found. </p>


(Update 8 Apr 19: As mmd mentions in the comments below, geocodeArea:CITY_NAME is Overpass Turbo syntactic sugar and cannot be used for Overpass API.) Looking into the Network tab of dev tools after running this same query in Overpass Turbo, I find this works on Overpass Turbo because it translates geocodeArea:Tbilisi to area(3601996871). But I'd like to query by city name if possible.



I don't know if I've misunderstood the query structure. If I try the area[name="CITY_NAME"] syntax with Singapore like so:



[out:json];
area[name="Singapore"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


Overpass Turbo returns a total of 2221.



But with the geocodeArea:CITY_NAME syntax like this:



[out:json];
geocodeArea:Singapore->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


The total count is different. It's 2192.



What is the correct way to query for POI in a city? Preferably with cURL and by city name?










share|improve this question









New contributor




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















  • 1





    geocodeArea:Singapore is overpass turbo specific syntactic sugar, which is invalid syntax for Overpass API!

    – mmd
    Apr 8 at 9:02











  • If you want to query by name then you need to perform a geocoding step before to determine the relation ID, for example with the help of Nominatim.

    – scai
    Apr 8 at 9:52











  • ... and that's exactly what overpass turbo's geocodeArea does: it calls Nominatim, converts the relation number to an Overpass area id, and sends the query to the Overpass API backend server. If you don't want to use Nominatim, you need to find the correct tags for the area you're interested, like in area[name="Singapore"][boundary=administrative]. This requires you to spend some time on OSM tagging, which would be beyond the scope of this question.

    – mmd
    Apr 8 at 20:19


















1















I'm very new to OpenStreetMap's Overpass QL API. After digging through its hefty wiki and several tutorials I get the feeling that if I want to query for a city I can use either area[name="Tbilisi"][boundary=administrative] or geocodeArea:Tbilisi. I think [boundary=administrative] helps identify it as a city or at least some kind of official entity like a state or municipality rather than, say, part of the name of a cafe. I don't know if I am right.



Following that, I should be able to get restaurants in Tbilisi with the area[name="Tbilisi"][boundary=administrative] syntax on Overpass Turbo like so:



area[name="Tbilisi"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


However, it returns '"elements": []'. out count returns a total of 0.



I then tried with geocodeArea:Tbilisi:



geocodeArea:Tbilisi->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


This returned a very long list of elements, out count total is 419.



Unfortunately, I can't use geocodeArea:Tbilisi with cURL like this:



curl --globoff 'https://overpass-api.de/api/interpreter?data=[out:json];geocodeArea:Tbilisi->.searchArea;node["amenity"="restaurant"](area.searchArea);out;'


It gives:



...
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: Unknown type "{" </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: An empty query is not allowed </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: ';' expected - '{' found. </p>


(Update 8 Apr 19: As mmd mentions in the comments below, geocodeArea:CITY_NAME is Overpass Turbo syntactic sugar and cannot be used for Overpass API.) Looking into the Network tab of dev tools after running this same query in Overpass Turbo, I find this works on Overpass Turbo because it translates geocodeArea:Tbilisi to area(3601996871). But I'd like to query by city name if possible.



I don't know if I've misunderstood the query structure. If I try the area[name="CITY_NAME"] syntax with Singapore like so:



[out:json];
area[name="Singapore"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


Overpass Turbo returns a total of 2221.



But with the geocodeArea:CITY_NAME syntax like this:



[out:json];
geocodeArea:Singapore->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


The total count is different. It's 2192.



What is the correct way to query for POI in a city? Preferably with cURL and by city name?










share|improve this question









New contributor




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















  • 1





    geocodeArea:Singapore is overpass turbo specific syntactic sugar, which is invalid syntax for Overpass API!

    – mmd
    Apr 8 at 9:02











  • If you want to query by name then you need to perform a geocoding step before to determine the relation ID, for example with the help of Nominatim.

    – scai
    Apr 8 at 9:52











  • ... and that's exactly what overpass turbo's geocodeArea does: it calls Nominatim, converts the relation number to an Overpass area id, and sends the query to the Overpass API backend server. If you don't want to use Nominatim, you need to find the correct tags for the area you're interested, like in area[name="Singapore"][boundary=administrative]. This requires you to spend some time on OSM tagging, which would be beyond the scope of this question.

    – mmd
    Apr 8 at 20:19














1












1








1








I'm very new to OpenStreetMap's Overpass QL API. After digging through its hefty wiki and several tutorials I get the feeling that if I want to query for a city I can use either area[name="Tbilisi"][boundary=administrative] or geocodeArea:Tbilisi. I think [boundary=administrative] helps identify it as a city or at least some kind of official entity like a state or municipality rather than, say, part of the name of a cafe. I don't know if I am right.



Following that, I should be able to get restaurants in Tbilisi with the area[name="Tbilisi"][boundary=administrative] syntax on Overpass Turbo like so:



area[name="Tbilisi"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


However, it returns '"elements": []'. out count returns a total of 0.



I then tried with geocodeArea:Tbilisi:



geocodeArea:Tbilisi->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


This returned a very long list of elements, out count total is 419.



Unfortunately, I can't use geocodeArea:Tbilisi with cURL like this:



curl --globoff 'https://overpass-api.de/api/interpreter?data=[out:json];geocodeArea:Tbilisi->.searchArea;node["amenity"="restaurant"](area.searchArea);out;'


It gives:



...
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: Unknown type "{" </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: An empty query is not allowed </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: ';' expected - '{' found. </p>


(Update 8 Apr 19: As mmd mentions in the comments below, geocodeArea:CITY_NAME is Overpass Turbo syntactic sugar and cannot be used for Overpass API.) Looking into the Network tab of dev tools after running this same query in Overpass Turbo, I find this works on Overpass Turbo because it translates geocodeArea:Tbilisi to area(3601996871). But I'd like to query by city name if possible.



I don't know if I've misunderstood the query structure. If I try the area[name="CITY_NAME"] syntax with Singapore like so:



[out:json];
area[name="Singapore"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


Overpass Turbo returns a total of 2221.



But with the geocodeArea:CITY_NAME syntax like this:



[out:json];
geocodeArea:Singapore->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


The total count is different. It's 2192.



What is the correct way to query for POI in a city? Preferably with cURL and by city name?










share|improve this question









New contributor




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












I'm very new to OpenStreetMap's Overpass QL API. After digging through its hefty wiki and several tutorials I get the feeling that if I want to query for a city I can use either area[name="Tbilisi"][boundary=administrative] or geocodeArea:Tbilisi. I think [boundary=administrative] helps identify it as a city or at least some kind of official entity like a state or municipality rather than, say, part of the name of a cafe. I don't know if I am right.



Following that, I should be able to get restaurants in Tbilisi with the area[name="Tbilisi"][boundary=administrative] syntax on Overpass Turbo like so:



area[name="Tbilisi"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


However, it returns '"elements": []'. out count returns a total of 0.



I then tried with geocodeArea:Tbilisi:



geocodeArea:Tbilisi->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out;


This returned a very long list of elements, out count total is 419.



Unfortunately, I can't use geocodeArea:Tbilisi with cURL like this:



curl --globoff 'https://overpass-api.de/api/interpreter?data=[out:json];geocodeArea:Tbilisi->.searchArea;node["amenity"="restaurant"](area.searchArea);out;'


It gives:



...
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: Unknown type "{" </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: An empty query is not allowed </p>
<p><strong style="color:#FF0000">Error</strong>: line 1: parse error: ';' expected - '{' found. </p>


(Update 8 Apr 19: As mmd mentions in the comments below, geocodeArea:CITY_NAME is Overpass Turbo syntactic sugar and cannot be used for Overpass API.) Looking into the Network tab of dev tools after running this same query in Overpass Turbo, I find this works on Overpass Turbo because it translates geocodeArea:Tbilisi to area(3601996871). But I'd like to query by city name if possible.



I don't know if I've misunderstood the query structure. If I try the area[name="CITY_NAME"] syntax with Singapore like so:



[out:json];
area[name="Singapore"][boundary=administrative]->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


Overpass Turbo returns a total of 2221.



But with the geocodeArea:CITY_NAME syntax like this:



[out:json];
geocodeArea:Singapore->.searchArea;
node["amenity"="restaurant"](area.searchArea);
out count;


The total count is different. It's 2192.



What is the correct way to query for POI in a city? Preferably with cURL and by city name?







openstreetmap overpass-api






share|improve this question









New contributor




nusantara 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




nusantara 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 8 at 9:09







nusantara













New contributor




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









asked Apr 7 at 18:40









nusantaranusantara

63




63




New contributor




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





New contributor





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






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







  • 1





    geocodeArea:Singapore is overpass turbo specific syntactic sugar, which is invalid syntax for Overpass API!

    – mmd
    Apr 8 at 9:02











  • If you want to query by name then you need to perform a geocoding step before to determine the relation ID, for example with the help of Nominatim.

    – scai
    Apr 8 at 9:52











  • ... and that's exactly what overpass turbo's geocodeArea does: it calls Nominatim, converts the relation number to an Overpass area id, and sends the query to the Overpass API backend server. If you don't want to use Nominatim, you need to find the correct tags for the area you're interested, like in area[name="Singapore"][boundary=administrative]. This requires you to spend some time on OSM tagging, which would be beyond the scope of this question.

    – mmd
    Apr 8 at 20:19













  • 1





    geocodeArea:Singapore is overpass turbo specific syntactic sugar, which is invalid syntax for Overpass API!

    – mmd
    Apr 8 at 9:02











  • If you want to query by name then you need to perform a geocoding step before to determine the relation ID, for example with the help of Nominatim.

    – scai
    Apr 8 at 9:52











  • ... and that's exactly what overpass turbo's geocodeArea does: it calls Nominatim, converts the relation number to an Overpass area id, and sends the query to the Overpass API backend server. If you don't want to use Nominatim, you need to find the correct tags for the area you're interested, like in area[name="Singapore"][boundary=administrative]. This requires you to spend some time on OSM tagging, which would be beyond the scope of this question.

    – mmd
    Apr 8 at 20:19








1




1





geocodeArea:Singapore is overpass turbo specific syntactic sugar, which is invalid syntax for Overpass API!

– mmd
Apr 8 at 9:02





geocodeArea:Singapore is overpass turbo specific syntactic sugar, which is invalid syntax for Overpass API!

– mmd
Apr 8 at 9:02













If you want to query by name then you need to perform a geocoding step before to determine the relation ID, for example with the help of Nominatim.

– scai
Apr 8 at 9:52





If you want to query by name then you need to perform a geocoding step before to determine the relation ID, for example with the help of Nominatim.

– scai
Apr 8 at 9:52













... and that's exactly what overpass turbo's geocodeArea does: it calls Nominatim, converts the relation number to an Overpass area id, and sends the query to the Overpass API backend server. If you don't want to use Nominatim, you need to find the correct tags for the area you're interested, like in area[name="Singapore"][boundary=administrative]. This requires you to spend some time on OSM tagging, which would be beyond the scope of this question.

– mmd
Apr 8 at 20:19






... and that's exactly what overpass turbo's geocodeArea does: it calls Nominatim, converts the relation number to an Overpass area id, and sends the query to the Overpass API backend server. If you don't want to use Nominatim, you need to find the correct tags for the area you're interested, like in area[name="Singapore"][boundary=administrative]. This requires you to spend some time on OSM tagging, which would be beyond the scope of this question.

– mmd
Apr 8 at 20:19











0






active

oldest

votes












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



);






nusantara 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%2f318046%2fhow-to-get-poi-in-city-in-openstreetmap-through-overpass-api-with-curl%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes








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









draft saved

draft discarded


















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












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











nusantara 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%2f318046%2fhow-to-get-poi-in-city-in-openstreetmap-through-overpass-api-with-curl%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