-
Posts
2,178 -
Joined
-
Last visited
-
Days Won
595
Everything posted by darksabersan
-
Good news because I've been waiting for it since a long time. I have already tried it but I was really disappointed. "Input" from merginmap is really far more efficient than QField. I've been using this tool for 2 years now and it's really powerful.
-
Automatic restart of pgAgent job when it fails
darksabersan replied to darksabersan's topic in General
Thanks @rahmansunbeam, I will have look closer. @Lurker, when I said "didn't run properly" I mean that usually I use *.bat file to run Python Script for downloading, converting data and upload them to PostgreSQL. Sometime the process is stopped due to disconnected distant server and obviously it fails. -
Hi Guys, I have several Agents setup on various PostgreSQL 10 databases to run tasks but I would like to know if someone of you knows a tool that can restart an Agent that didn't run properly. I am used to use a query to see the status of every tasks when it fails or success as below, launched from postgres db: SELECT jobid, jobname, jobenabled, lastjob.jlgstatus last_job_status, jstid, jstname, (jstkind, jstonerror) "type->error",lastjobstep.jslstatus last_step_status, jsloutput,jslduration, jstcode jobstepcode FROM pgagent.pga_job LEFT JOIN pgagent.pga_jobstep on jobid = jstjobid LEFT JOIN (SELECT _last.jlgjobid, _last.max_jlgid, jlgstatus, jlgstart FROM pgagent.pga_joblog, (select jlgjobid, max(jlgid) max_jlgid FROM pgagent.pga_joblog group by jlgjobid) _last WHERE jlgid = max_jlgid) lastjob ON jobid = jlgjobid LEFT JOIN (SELECT _last.jsljstid, jslstatus, jslstart, jsloutput, jslduration FROM pgagent.pga_jobsteplog, (select jsljstid, max(jslid) max_jstid from pgagent.pga_jobsteplog group by jsljstid) _last where jslid = max_jstid) lastjobstep ON jstid = jsljstid ORDER BY jobid,jstid Unfortunately this is only possible when I am behind my screen and if something happen after my working hour, I would love also to receive an email alert to be informed. Thanks in advance for your advice. darksabersan
-
Hi remoteguy ! Welcome on board and enjoy your time with us and the community. darksabersan
-
@intertronic, thanks for your input. I found a solution that suite my case better due to the fact that we are using both version of QGIS and also because I was looking for interoperability. Therefore I have decided to use QSphere. Most probably not well known around the globe. https://qgis.projets.developpement-durable.gouv.fr/projects/qsphere GUI quiete ugly but at least is doing the job. 😉 darksabersan
-
Hi guys, Since a very long on ArcGIS, I am used to use Metadata to goes along with my data, like Shapefile, GDB, etc. I add all king of usefull informations that I can provide to it. Using QGIS 3.x is definitely not a hard job regarding Metadata because they are store into a *.qmd file and this works very fine. I am much more trouble to use QGIS 2.x because there is the Metadata tab into the layer properties but I am unable to make it work. I mean, I can't see any *.xml file and when removing the data from the canvas and add it again, everything is gone. Anyone with Metadata experience can tell how to do it with QGIS 2.x ? Thanks ! darksabersan
-
DJI Mavic Air 2 Is a Sleeker and Longer-Flying Drone
darksabersan replied to Lurker's topic in GeoHardware
This is a very awesome improvement for DJI Mavic Air 2 ! @rahmansunbeam I am in love about this one. I worked a long time ago with such kind of device with small Lidar on board. Mix with Arduino and Raspberry Pi and a huge battery 🙂. Very cool stuff ! -
Hi Dante, Welcome to Gis-Area !
-
OK, thanks. I will have look to it. Today, I am also facing another issue. When running my buffer over my points, I am loosing all columns in my table. Here is my query: SELECT st_buffer(geom, 50) INTO gis_osm_pois_buf FROM gis_osm_pois; Is there any way to keep them into the new table ? Thanks !
-
Hi guys, I have the most stupid question for you. From one layer with thousand of points and I have generated buffers. The thing is that I would like to select only the ones that didn't touch or intersect each other. https://imgur.com/a/QtCCD0V Postgis query would be great or any other solution. Thanks in advance for your help
-
Hi guys, I had the opportunity in the past with my previous job to load Oracle Spatial data and everything was fine. Today, I try to scratch the surface by installing Oracle Database 12c Release 2. I created a first database and I managed to make a connection with ArcCatalog without major problem. Now I have created a second empty database but when I want to connect with QGIS, it does not work even using the 'SYS' user. What should I do to create an empty base to connect to? Thanks! darksabersan.
-
How to add GRASS plugin in Windows QGIS
darksabersan replied to Lurker's topic in Spatial Programming
Hi my friend, As far as I can see, it seams that it works only for Linux... Unfortunately. http://www.slopestability.org/software.html darksabersan. -
Hi spacebuggy and welcome on board ! darksabersan.
-
Hi gilmour and welcome on board ! darksabersan.
-
Hi Joy and welcome on board ! darksabersan.
-
Under Cartography Tools > Generalization, you will found "Simplify Polygon" tool. darksabersan.
-
Hi souvik.gis, Can you explain what you try to achieve and maybe provide the input feature example ? darksabersan.
-
Hi Jagster, Welcome to GIS Area. You will definitely enjoy this place and hope to see you sharing knowledge with us. darksabersan.
-
Hi baobab and welcome on board ! darksabersan.
-
This is the best way to avoid general failure on your system and blue screen.. darksabersan.
-
How to design/program specific label?
darksabersan replied to Lost_in_Space's topic in Cartography Design
The second way is to use VB Scripts which allows you to have full control and work perfectly by combining Lurker link and this one. https://desktop.arcgis.com/en/arcmap/10.3/map/working-with-text/about-building-label-expressions.htm darksabersan. -
Before loading your data in QGIS, from the "Browser Panel" or directly with QGIS Browser, you can control the metadata and check the coordinate system of the layer. darksabersan.
-
Forum News/Update or Report Error Function, Post Here
darksabersan replied to EmperoR's topic in Feedback and Introduction
You rock EmperoR ! darksabersan. -
Forum News/Update or Report Error Function, Post Here
darksabersan replied to EmperoR's topic in Feedback and Introduction
I have been out for a while... Now it is time to come back ! Love the new framework, very great. darksabersan. -
Forum News/Update or Report Error Function, Post Here
darksabersan replied to EmperoR's topic in Feedback and Introduction
Great ! Looking forward to see changes and functionalities. darksabersan.