Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-10 Thread Dennis Burgess via QGIS-User
issolve on each part to reduce the number of features, and then finally dissolve the results into the final one ... Von: QGIS-User im Auftrag von Dennis Burgess via QGIS-User Gesendet: Dienstag, 6. Februar 2024 15:23 An: QGIS-User@lists.osgeo.org Betreff: Re:

Re: [Qgis-user] Optimize QGIS Command_Line

2024-02-06 Thread Dennis Burgess via QGIS-User
What does your CPU, RAM and I/O utilisation look like during those long running processes? Same for the MSSQL database server host system. Cheers, Hannes On 05.02.24 14:46, Dennis Burgess via QGIS-User wrote: I have two command lines, one reads from my MSSQL database and creates a GeoPackage

[Qgis-user] Optimize QGIS Command_Line

2024-02-05 Thread Dennis Burgess via QGIS-User
I have two command lines, one reads from my MSSQL database and creates a GeoPackage on the local disk. This takes WAY too long, just to create it , it uses 5% or less CPU, and is SUPER slow. Looking for methods to speed this up. The data is around 1.2 to 1.4 gig of pop, but it should not take

Re: [Qgis-user] GPKG Multi-Layer to one flat

2023-03-03 Thread Dennis Burgess via QGIS-User
Create Wireless Coverage’s with www.towercoverage.com From: chris hermansen Sent: Friday, March 3, 2023 1:58 PM To: Dennis Burgess Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] GPKG Multi-Layer to one flat Dennis and list On Fri, Mar 3, 2023 at 11:45 AM Dennis Burgess via QGIS-User m

[Qgis-user] GPKG Multi-Layer to one flat

2023-03-03 Thread Dennis Burgess via QGIS-User
Ok, has to be a simple solution. I have a GPKG file that is around 50 meg. This has multiple layers or at least I can see multiple layers. I.e. I have one polygon on top of another What I want is to flatten these, to where ONLY the exact area that is show is displayed in the smallest file pos

Re: [Qgis-user] Looking for application/server etc

2023-01-12 Thread Dennis Burgess via QGIS-User
2023 10:14 AM To: Dennis Burgess Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Looking for application/server etc Vector tiles? Am 2023-01-12 16:43, schrieb Dennis Burgess via QGIS-User: > Looking for something that can take a HUGE, say a 50-75 meg > mutli-polygon (multi-state etc.),

Re: [Qgis-user] Looking for application/server etc

2023-01-12 Thread Dennis Burgess via QGIS-User
im, Co Meath, C15 NX36 -- M +353 87 688 5964 T +353 46 942 2409 https://https://gov.ie/opw<https://www.opw.ie> -- Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/<https://www.opw.ie/en/disclaimer/> From: QGIS-User mailto:qgis-user-boun...@lists.o

[Qgis-user] Looking for application/server etc

2023-01-12 Thread Dennis Burgess via QGIS-User
Looking for something that can take a HUGE, say a 50-75 meg mutli-polygon (multi-state etc.), that has detail level down to 1meter, then parse it and display it within 1meg on top of mapping systems in a web browser ? Options? Not to mention, we have a few thousand of these so we need to be ab

Re: [Qgis-user] QGIS_process not mutli-threaded? or option?

2022-10-21 Thread Dennis Burgess via Qgis-user
ogies, Inc -- Mikrotik & WISP Support Services Office: 314-735-0270 Website: http://www.linktechs.net<http://www.linktechs.net/> Need to Automate MikroTik Backups: https://cloud.linktechs.net Create Wireless Coverage’s with www.towercoverage.com From: Qgis-user On Behalf Of Dennis Burgess

[Qgis-user] QGIS_process not mutli-threaded? or option?

2022-10-21 Thread Dennis Burgess via Qgis-user
Looks like QGIS_process is not multi-threaded ☹ At least what I am seeing in one core taken up? Any method to speed this thing up? [LTI-Full_175px] Dennis Burgess, Mikrotik Certified Trainer MTCNA, MTCRE, MTCWE, MTCTCE, MTCINE, MTCSE, HE IPv6 Sage, Cambium ePMP Certified Author of "Learn Rout

[Qgis-user] ogr2ogr slow

2022-10-17 Thread Dennis Burgess via Qgis-user
Doing a MSSQL extract, takes my machine 36 seconds to get the data remotely, about 40 meg worth .. but when OGR2OGR gets that data, then does whatever it needs to on GPKG file, it only uses about 5% of the CPU, anyway to use more and complete quicker? [LTI-Full_175px] Dennis Burgess Mikrotik

Re: [Qgis-user] Intersect vs extractbylocation

2022-09-14 Thread Dennis Burgess via Qgis-user
n output, hence much faster. Alexandre Neto Dennis Burgess via Qgis-user mailto:qgis-user@lists.osgeo.org>> escreveu no dia quarta, 14/09/2022 à(s) 16:20: I have a shape file and a list of points.. Trying to understand what the difference is between intersect vs exteactbylocation . Ex

[Qgis-user] Intersect vs extractbylocation

2022-09-14 Thread Dennis Burgess via Qgis-user
I have a shape file and a list of points.. Trying to understand what the difference is between intersect vs exteactbylocation . Extract by location takes NO TIME, under a min on all of my runs, but intersection takes quite a bit of time.. In the end, all I want is what lines in the CSV (packa

Re: [Qgis-user] Faster Intersects

2022-09-09 Thread Dennis Burgess via Qgis-user
ain. Answering your question, yes I am pretty sure postgis is much faster than mssql, and yes I think most recent versions of PostgreSQL PostGIS make use of more than one core. Good luck A sexta, 9/09/2022, 17:59, Dennis Burgess via Qgis-user mailto:qgis-user@lists.osgeo.org>> escreveu: I

[Qgis-user] Hire a QGIS Contractor

2022-09-09 Thread Dennis Burgess via Qgis-user
Looking for a contractor that can either speak with us and/or exchange emails in English for QGIS . 😊 Anyone please hit me off-list 😊 [LTI-Full_175px] Dennis Burgess Mikrotik : Trainer, Network Associate, Routing Engineer, Wireless Engineer, Traffic Control Engineer, Inter-Networking Enginee

Re: [Qgis-user] Faster Intersects

2022-09-09 Thread Dennis Burgess via Qgis-user
polygons. Hope this helps. Anyway, it should not need to take this long. Raymond On 09-09-2022 16:28, Dennis Burgess via Qgis-user wrote: > How can I speed up Intersects?  Right now I have a single geometry > file, but then have about 2 million points that I need to understand > wh

Re: [Qgis-user] Faster Intersects

2022-09-09 Thread Dennis Burgess via Qgis-user
port A sexta, 9/09/2022, 15:50, Dennis Burgess via Qgis-user mailto:qgis-user@lists.osgeo.org>> escreveu: How can I speed up Intersects? Right now I have a single geometry file, but then have about 2 million points that I need to understand what intersects that geometry. Right now its ta

[Qgis-user] Faster Intersects

2022-09-09 Thread Dennis Burgess via Qgis-user
How can I speed up Intersects? Right now I have a single geometry file, but then have about 2 million points that I need to understand what intersects that geometry. Right now its taking 3 days? QGIS-bin.exe is only using 11% CPU.. ☹ Dennis ___ Qgi