Open CPN AIS Integration into QGIS The Next CEO of Stack OverflowWriting data into Esri *.mdb personal geodatabase using QGIS?AIS directly on QGISInstalling QGIS with GRASS plugin on Ubuntu?QGIS Processing - Edge ExtractionVessel Tracking‎ service in qgis or standalonePlotting Density Maps with AIS DataOverlap Analysis of two rasters (heat maps) in QGIS?extshape arrows to show ais vessels. MultiLinestring alternativeLine network integration analysis in QGISHow to create an outline of a ship given the geom of the GPS aerial, ship dimensions, true heading

Inappropriate reference requests from Journal reviewers

If/When UK leaves the EU, can a future goverment conduct a referendum to join the EU?

FBX seems to be empty when imported into Blender

Giving the same color to different shapefiles in QGIS

Which tube will fit a -(700 x 25c) wheel?

Why has the US not been more assertive in confronting Russia in recent years?

Different harmonic changes implied by a simple descending scale

What's the best way to handle refactoring a big file?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

Why didn't Khan get resurrected in the Genesis Explosion?

Is it ever safe to open a suspicious html file (e.g. email attachment)?

Cannot send `--` into tmux panes from vim

Return the Closest Prime Number

Why don't programming languages automatically manage the synchronous/asynchronous problem?

How to make a variable always equal to the result of some calculations?

How to start emacs in "nothing" mode (`fundamental-mode`)

Bold, vivid family

What flight has the highest ratio of time difference to flight time?

Is it professional to write unrelated content in an almost-empty email?

Are there any limitations on attacking while grappling?

Written every which way

Is HostGator storing my password in plaintext?

Is there a way to save my career from absolute disaster?

Can we say or write : "No, it'sn't"?



Open CPN AIS Integration into QGIS



The Next CEO of Stack OverflowWriting data into Esri *.mdb personal geodatabase using QGIS?AIS directly on QGISInstalling QGIS with GRASS plugin on Ubuntu?QGIS Processing - Edge ExtractionVessel Tracking‎ service in qgis or standalonePlotting Density Maps with AIS DataOverlap Analysis of two rasters (heat maps) in QGIS?extshape arrows to show ais vessels. MultiLinestring alternativeLine network integration analysis in QGISHow to create an outline of a ship given the geom of the GPS aerial, ship dimensions, true heading










0















Can AIS marine traffic live vessel data be integrated into QGIS?



I understand this could be possible using an OpenCPN plugin and Grass.










share|improve this question




























    0















    Can AIS marine traffic live vessel data be integrated into QGIS?



    I understand this could be possible using an OpenCPN plugin and Grass.










    share|improve this question


























      0












      0








      0








      Can AIS marine traffic live vessel data be integrated into QGIS?



      I understand this could be possible using an OpenCPN plugin and Grass.










      share|improve this question
















      Can AIS marine traffic live vessel data be integrated into QGIS?



      I understand this could be possible using an OpenCPN plugin and Grass.







      qgis ais






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Aug 16 '18 at 14:44









      PolyGeo

      53.8k1781245




      53.8k1781245










      asked Aug 16 '18 at 8:21









      RichiniRichini

      62




      62




















          1 Answer
          1






          active

          oldest

          votes


















          1














          Sorry for this late answer but want to share this if you still need it. I used Vesselfinder, fairly the same to MarineTraffic, and I think I accomplished what you are trying to achieve.



          I used a python script (with psycopg2 extension) that received the information via an API from Vesselfinder. The script saved the data in a PostgreSQL database (with PostGIS extension) and in QGIS a PostgreSQL/PostGIS database is accessible via the database manager. Every time the script runs (i used a Loop Bat. file, to let it run every 5 min) the data is updated en immediately visible in QGIS.



          this is the python code to get data and store it in a db.



           # Import libraries
          import requests
          import pprint
          import json
          import sys
          import psycopg2
          import datetime

          # Make database connection
          conn = psycopg2.connect("dbname=YOURDBNAME user=YOURUSERNAME password=YOURPASSWORD")

          # Get cursor
          cur = conn.cursor()

          # Define headers
          headers = 'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',
          'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
          'Accept-Charset': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
          'Accept-Encoding': 'none',
          'Accept-Language': 'en-US,en;q=0.8',
          'Connection': 'keep-alive'

          # Build URL
          url = 'YOUR VESSELFINDER/MARINETRAFFIC API URL

          # Execute HTTP request
          print('Get vessel positions from ' + str(url))
          response = requests.get(url, headers=headers)

          # Get result and store in database (point in 4326, convert date 2019-02-01 06:29:43 UTC)
          # Update scheepstrack
          if response.status_code == 200 :
          print ('Request OK')
          if len(response.json()) > 0 :
          i = 0
          while i < len(response.json()):
          YOURCOLLUMNAME = str(response.json()[i]['AIS']['NAME'])
          YOURCOLLUMNAME = int(response.json()[i]['AIS']['MMSI'])
          YOURCOLLUMNAME = float(response.json()[i]['AIS']['LATITUDE'])
          YOURCOLLUMNAME = float(response.json()[i]['AIS']['LONGITUDE'])
          YOURCOLLUMNAME = datetime.datetime.strptime(str(response.json()[i]['AIS']['TIMESTAMP'][:-4]), '%Y-%m-%d %H:%M:%S')

          # Insert new position
          insert_stmt = 'insert into YOURDBNAME ( YOURCOLLUMNAME, YOURCOLLUMNAME, "YOURCOLLUMNAME", "YOURCOLLUMNAME" ) values ( %s, %s, ST_SetSRID(ST_MakePoint(%s, %s),4326), %s )'
          cur.execute ( insert_stmt, ( YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME ) )


          This will create a real-time feed of you vessel(s)
          Hope this is still to some use to you or somebody else that reads this.






          share|improve this answer























            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%2f292959%2fopen-cpn-ais-integration-into-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














            Sorry for this late answer but want to share this if you still need it. I used Vesselfinder, fairly the same to MarineTraffic, and I think I accomplished what you are trying to achieve.



            I used a python script (with psycopg2 extension) that received the information via an API from Vesselfinder. The script saved the data in a PostgreSQL database (with PostGIS extension) and in QGIS a PostgreSQL/PostGIS database is accessible via the database manager. Every time the script runs (i used a Loop Bat. file, to let it run every 5 min) the data is updated en immediately visible in QGIS.



            this is the python code to get data and store it in a db.



             # Import libraries
            import requests
            import pprint
            import json
            import sys
            import psycopg2
            import datetime

            # Make database connection
            conn = psycopg2.connect("dbname=YOURDBNAME user=YOURUSERNAME password=YOURPASSWORD")

            # Get cursor
            cur = conn.cursor()

            # Define headers
            headers = 'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',
            'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
            'Accept-Charset': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
            'Accept-Encoding': 'none',
            'Accept-Language': 'en-US,en;q=0.8',
            'Connection': 'keep-alive'

            # Build URL
            url = 'YOUR VESSELFINDER/MARINETRAFFIC API URL

            # Execute HTTP request
            print('Get vessel positions from ' + str(url))
            response = requests.get(url, headers=headers)

            # Get result and store in database (point in 4326, convert date 2019-02-01 06:29:43 UTC)
            # Update scheepstrack
            if response.status_code == 200 :
            print ('Request OK')
            if len(response.json()) > 0 :
            i = 0
            while i < len(response.json()):
            YOURCOLLUMNAME = str(response.json()[i]['AIS']['NAME'])
            YOURCOLLUMNAME = int(response.json()[i]['AIS']['MMSI'])
            YOURCOLLUMNAME = float(response.json()[i]['AIS']['LATITUDE'])
            YOURCOLLUMNAME = float(response.json()[i]['AIS']['LONGITUDE'])
            YOURCOLLUMNAME = datetime.datetime.strptime(str(response.json()[i]['AIS']['TIMESTAMP'][:-4]), '%Y-%m-%d %H:%M:%S')

            # Insert new position
            insert_stmt = 'insert into YOURDBNAME ( YOURCOLLUMNAME, YOURCOLLUMNAME, "YOURCOLLUMNAME", "YOURCOLLUMNAME" ) values ( %s, %s, ST_SetSRID(ST_MakePoint(%s, %s),4326), %s )'
            cur.execute ( insert_stmt, ( YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME ) )


            This will create a real-time feed of you vessel(s)
            Hope this is still to some use to you or somebody else that reads this.






            share|improve this answer



























              1














              Sorry for this late answer but want to share this if you still need it. I used Vesselfinder, fairly the same to MarineTraffic, and I think I accomplished what you are trying to achieve.



              I used a python script (with psycopg2 extension) that received the information via an API from Vesselfinder. The script saved the data in a PostgreSQL database (with PostGIS extension) and in QGIS a PostgreSQL/PostGIS database is accessible via the database manager. Every time the script runs (i used a Loop Bat. file, to let it run every 5 min) the data is updated en immediately visible in QGIS.



              this is the python code to get data and store it in a db.



               # Import libraries
              import requests
              import pprint
              import json
              import sys
              import psycopg2
              import datetime

              # Make database connection
              conn = psycopg2.connect("dbname=YOURDBNAME user=YOURUSERNAME password=YOURPASSWORD")

              # Get cursor
              cur = conn.cursor()

              # Define headers
              headers = 'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',
              'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
              'Accept-Charset': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
              'Accept-Encoding': 'none',
              'Accept-Language': 'en-US,en;q=0.8',
              'Connection': 'keep-alive'

              # Build URL
              url = 'YOUR VESSELFINDER/MARINETRAFFIC API URL

              # Execute HTTP request
              print('Get vessel positions from ' + str(url))
              response = requests.get(url, headers=headers)

              # Get result and store in database (point in 4326, convert date 2019-02-01 06:29:43 UTC)
              # Update scheepstrack
              if response.status_code == 200 :
              print ('Request OK')
              if len(response.json()) > 0 :
              i = 0
              while i < len(response.json()):
              YOURCOLLUMNAME = str(response.json()[i]['AIS']['NAME'])
              YOURCOLLUMNAME = int(response.json()[i]['AIS']['MMSI'])
              YOURCOLLUMNAME = float(response.json()[i]['AIS']['LATITUDE'])
              YOURCOLLUMNAME = float(response.json()[i]['AIS']['LONGITUDE'])
              YOURCOLLUMNAME = datetime.datetime.strptime(str(response.json()[i]['AIS']['TIMESTAMP'][:-4]), '%Y-%m-%d %H:%M:%S')

              # Insert new position
              insert_stmt = 'insert into YOURDBNAME ( YOURCOLLUMNAME, YOURCOLLUMNAME, "YOURCOLLUMNAME", "YOURCOLLUMNAME" ) values ( %s, %s, ST_SetSRID(ST_MakePoint(%s, %s),4326), %s )'
              cur.execute ( insert_stmt, ( YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME ) )


              This will create a real-time feed of you vessel(s)
              Hope this is still to some use to you or somebody else that reads this.






              share|improve this answer

























                1












                1








                1







                Sorry for this late answer but want to share this if you still need it. I used Vesselfinder, fairly the same to MarineTraffic, and I think I accomplished what you are trying to achieve.



                I used a python script (with psycopg2 extension) that received the information via an API from Vesselfinder. The script saved the data in a PostgreSQL database (with PostGIS extension) and in QGIS a PostgreSQL/PostGIS database is accessible via the database manager. Every time the script runs (i used a Loop Bat. file, to let it run every 5 min) the data is updated en immediately visible in QGIS.



                this is the python code to get data and store it in a db.



                 # Import libraries
                import requests
                import pprint
                import json
                import sys
                import psycopg2
                import datetime

                # Make database connection
                conn = psycopg2.connect("dbname=YOURDBNAME user=YOURUSERNAME password=YOURPASSWORD")

                # Get cursor
                cur = conn.cursor()

                # Define headers
                headers = 'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',
                'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
                'Accept-Charset': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
                'Accept-Encoding': 'none',
                'Accept-Language': 'en-US,en;q=0.8',
                'Connection': 'keep-alive'

                # Build URL
                url = 'YOUR VESSELFINDER/MARINETRAFFIC API URL

                # Execute HTTP request
                print('Get vessel positions from ' + str(url))
                response = requests.get(url, headers=headers)

                # Get result and store in database (point in 4326, convert date 2019-02-01 06:29:43 UTC)
                # Update scheepstrack
                if response.status_code == 200 :
                print ('Request OK')
                if len(response.json()) > 0 :
                i = 0
                while i < len(response.json()):
                YOURCOLLUMNAME = str(response.json()[i]['AIS']['NAME'])
                YOURCOLLUMNAME = int(response.json()[i]['AIS']['MMSI'])
                YOURCOLLUMNAME = float(response.json()[i]['AIS']['LATITUDE'])
                YOURCOLLUMNAME = float(response.json()[i]['AIS']['LONGITUDE'])
                YOURCOLLUMNAME = datetime.datetime.strptime(str(response.json()[i]['AIS']['TIMESTAMP'][:-4]), '%Y-%m-%d %H:%M:%S')

                # Insert new position
                insert_stmt = 'insert into YOURDBNAME ( YOURCOLLUMNAME, YOURCOLLUMNAME, "YOURCOLLUMNAME", "YOURCOLLUMNAME" ) values ( %s, %s, ST_SetSRID(ST_MakePoint(%s, %s),4326), %s )'
                cur.execute ( insert_stmt, ( YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME ) )


                This will create a real-time feed of you vessel(s)
                Hope this is still to some use to you or somebody else that reads this.






                share|improve this answer













                Sorry for this late answer but want to share this if you still need it. I used Vesselfinder, fairly the same to MarineTraffic, and I think I accomplished what you are trying to achieve.



                I used a python script (with psycopg2 extension) that received the information via an API from Vesselfinder. The script saved the data in a PostgreSQL database (with PostGIS extension) and in QGIS a PostgreSQL/PostGIS database is accessible via the database manager. Every time the script runs (i used a Loop Bat. file, to let it run every 5 min) the data is updated en immediately visible in QGIS.



                this is the python code to get data and store it in a db.



                 # Import libraries
                import requests
                import pprint
                import json
                import sys
                import psycopg2
                import datetime

                # Make database connection
                conn = psycopg2.connect("dbname=YOURDBNAME user=YOURUSERNAME password=YOURPASSWORD")

                # Get cursor
                cur = conn.cursor()

                # Define headers
                headers = 'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',
                'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
                'Accept-Charset': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
                'Accept-Encoding': 'none',
                'Accept-Language': 'en-US,en;q=0.8',
                'Connection': 'keep-alive'

                # Build URL
                url = 'YOUR VESSELFINDER/MARINETRAFFIC API URL

                # Execute HTTP request
                print('Get vessel positions from ' + str(url))
                response = requests.get(url, headers=headers)

                # Get result and store in database (point in 4326, convert date 2019-02-01 06:29:43 UTC)
                # Update scheepstrack
                if response.status_code == 200 :
                print ('Request OK')
                if len(response.json()) > 0 :
                i = 0
                while i < len(response.json()):
                YOURCOLLUMNAME = str(response.json()[i]['AIS']['NAME'])
                YOURCOLLUMNAME = int(response.json()[i]['AIS']['MMSI'])
                YOURCOLLUMNAME = float(response.json()[i]['AIS']['LATITUDE'])
                YOURCOLLUMNAME = float(response.json()[i]['AIS']['LONGITUDE'])
                YOURCOLLUMNAME = datetime.datetime.strptime(str(response.json()[i]['AIS']['TIMESTAMP'][:-4]), '%Y-%m-%d %H:%M:%S')

                # Insert new position
                insert_stmt = 'insert into YOURDBNAME ( YOURCOLLUMNAME, YOURCOLLUMNAME, "YOURCOLLUMNAME", "YOURCOLLUMNAME" ) values ( %s, %s, ST_SetSRID(ST_MakePoint(%s, %s),4326), %s )'
                cur.execute ( insert_stmt, ( YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME, YOURCOLLUMNAME ) )


                This will create a real-time feed of you vessel(s)
                Hope this is still to some use to you or somebody else that reads this.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered yesterday









                Cas JulicherCas Julicher

                205




                205



























                    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%2f292959%2fopen-cpn-ais-integration-into-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