Questions tagged [performance]

Performance concerns how effectively a computing system uses resources.

Filter by
Sorted by
Tagged with
1
vote
1answer
34 views

Speeding up script to flag nodes within 100 feet of segments using PostGIS?

I'm working with two datasets, attempting to flag when an intersection is within 100 feet of a network subset. There are over 40,000 intersections and my network is ~ 1400 segments. The problem with ...
0
votes
0answers
36 views

Hacks to make Python scripts faster? [closed]

I've got a GDAL/OGR-based Python script that's drawing buffers around roads. In any particular area, it goes road by road (feature by feature) drawing a buffer around a road, and appends that road's ...
2
votes
1answer
63 views

Populating layer field with dict.values() in PyQGIS 3?

I've coded the script below in PyQGIS 3 to get the azimuth of starting or ending points for a line layer that touches a border. It works fine, but I want to populate the azimuth field layer with the ...
1
vote
0answers
24 views

Calculating nearest distance between points and Spatial Polygons in R? [closed]

So right now I have pretty large datasets, about 200,000 (lat,long) locations and a Large SpatialPolygonsDataFrame with a polygons list of length 428386 spread in a single city of around 450 square ...
0
votes
0answers
49 views

Improving speed of GeoPandas dissolve?

I am trying to dissolve grid spaces by category using GeoPandas' dissolve function, but it doesn't finish after hours of running and I want to make sure I'm not doing something wrong and/or there isn'...
3
votes
0answers
45 views

Slow loading of QGIS project?

I have a number of standard projects set up for QGIS users. Some of them take more than 5 minutes to load. Things recently got much worse suddenly - and I want to track down why. Are there any ...
-1
votes
1answer
51 views

Making looping through line segments for vertex points faster?

I am trying to speed up some current code that I have for looping through lines, getting their segments and ultimately the vertex points in Python. Can anyone recommend a faster method than what I ...
2
votes
1answer
25 views

Updating field in geodatabase table depending on other field using ArcPy?

I have a table in a file geodatabase that has "FieldA" and "FieldB". I want to update FieldB with one of two values, depending on if there are one or more records with the same value of FieldA. ...
0
votes
1answer
75 views

Which is more performant GeoJSON or WMS/WFS using OpenLayers? [closed]

I'm developing a web application using PostGIS, Laravel, Vue.js and Openlayers, for the moment I generate the GeoJSON from my database using the following code : public function plosWithGeom() { ...
1
vote
0answers
24 views

Creating IDW of up to 20,000 points in ArcGIS Desktop? [closed]

I am create IDW interpolation of 60-70 points in ArcGIS. It takes 2 minutes. But when I create IDW of 20000 points in ArcGIS, it takes at least 4 hours and 30 minutes. I want to ask why takes much ...
1
vote
1answer
67 views

Improve render speed for QGIS canvas (hardware)

I'm using QGIS to build complex maps from OSM-Data (GPKG or PostGIS). I'm wondering, how I should upgrade my system, to speed up rendering in canvas: Intel I5 4x3,2GHz, 16GB DDR3, SSD Or what about ...
1
vote
0answers
99 views

Changing CRS of geometry in geopandas dataframe efficiently?

I have a shapefile which I am converting into a geopandas dataframe. The CRS of this shapefile is epsg:4326 and I want to convert this to epsg:3857. import geopandas as gp file_path = 'zip_poly.shp' ...
11
votes
1answer
113 views

Python Script Performance as an ArcGIS Tool Versus Stand-Alone

Has anyone studied the difference in running a Python script in ArcToolbox versus as a stand-alone script? I had to write a quick-and-dirty script to convert a set of RGB images to single band by ...
1
vote
0answers
52 views

Making ArcPy script quicker? [closed]

The script below is used to update a shp which is missing values from another .shp using a spatial reference. It's taking about 19 minutes to run through ~53,000 rows. Any ideas on how I can make it ...
0
votes
0answers
13 views

Prevent slowing of story map from large data?

I have a building layer that has about 9k polygons and it's slowing my story map. I've tried simplifying the polygon as much as possible, but no luck. Has anyone figured out a method to work with ...
3
votes
1answer
98 views

Spatial Index on 100s of Millions of Records Taking Days in PostGIS? [closed]

I have a table with ~200million spatial records in it, and it is taking days to build a spatial index on the one geometry column: should this be taking so long? The geom column is of the type ...
1
vote
1answer
72 views

Does power of GPU affect performance of analyses by ArcGIS Desktop? [closed]

Does the power of GPU affect the performance of analyses such as Segment Mean Shift, conversion to/from raster, etc? Is the GPU used only for caching GUI elements to give a smoother user interface ...
0
votes
0answers
13 views

Android laggy map after adding vector objects

I'm using GLMap to render over 5000 vector objects in an Android Application. Here is the framework I'm using: https://getyourmap.com/ Currently, I have Shapefiles which I convert with https://...
0
votes
0answers
32 views

Finding and fixing source of repeated seed.TruncateTask for empty string errors using GeoServer and GeoWebCache?

Googling this issue is getting me nowhere so I thought I'd cast a wide net here in the hope of getting an actionable lead on this. Our GeoServer instance is configured for GeoWebCache. While ...
1
vote
1answer
30 views

Downloading or caching web based map service for faster access?

The Western Australia Department of Mine and Petroleum allows access to one of their online systems called Tengraph Web with which I can view tenements, major infrastructure, and topography for the ...
1
vote
1answer
67 views

Is Geometry object intersect faster than Intersect_analysis in ArcPy?

I have a script attempting to identify Many-to-Many matches between two different parcel layers. It is an iterative process, during which I dissolve the selected polygons in layers A and B, intersect ...
1
vote
1answer
65 views

Distance between coordinates computation speed: conversion to UTM vs Great Circle

For a program I am writing I need to calculate the distances between coordinates. Seeing as I need to perform a large number of these calculations for each coordinate (thousands) it makes sense to ...
3
votes
1answer
89 views

QGIS 2.18: Speed up QgsFeatureRequest in Python Script

I have two input layers. The first one is a line-layer named "graph" and the second one is a point-layer named "nodes". The "graph"-layer: The graph layer holds 177350 line features which are ...
0
votes
0answers
187 views

Leaflet Mobile Performance (A Couple of Polygons)

I wrote a small Angular app with leaflet.js. In desktop browser scrolling and dragging speed is good but on mobile browser, performance is painfully. There are 8 polygon and 129 circle marker on the ...
0
votes
0answers
23 views

ArcGIS Modelbuilder model clogs up memory?

I have a model in which a zonal histogram is computed of each line in a feature class, showing the amount of cells each line intersects in a raster file. After this, this column is joined to a table ...
0
votes
1answer
189 views

Calculating euclidian distance in R between lines and points?

I have a large SpatialLinesDataFrame "o" (~500,000 roads) and ~3000 survey points "r", I'd like to calculate the distance to the nearest line for each survey point and extract relevant columns. My ...
2
votes
1answer
277 views

QGIS very slow when browsing files on macOS

QGIS is performing very slowly for me when browsing files and folders recently. I am running macOS Mojave and have no performance issues within QGIS, apart from the times I need to open or save a file....
3
votes
0answers
33 views

Testing a GeoServer “Scrolling” performance

I'm looking for a way to test the responsiveness of various layers when scrolling around the map. So after a layer is loaded and the user is moving around the map looking a specific area or whatever. ...
3
votes
2answers
93 views

Script I made for pyQgis runs slow but can't find another way around it

registry = QgsProject.instance() first_layer = registry.mapLayersByName('buffered')[0] second_layer = registry.mapLayersByName('buffered')[0] areas = [] instrument_number = "tin_ttl_in" proprietor =...
1
vote
0answers
46 views

Controlling CityGML performance?

I tried to convert single LOD3 building using FME. I am able to convert successfully from DGN to cityGML format.But when I tried to view the same in FZKViewer/FME data inspector the performance is ...
3
votes
2answers
82 views

Running arcpy.AlterField_management 2,000 times takes too long?

I am trying to replace field names of a table stored in a file geodatabase using a dictionary as a lookup table. My field names got cut off from the Tabulate Area tool (Tabulate Area Truncates Field ...
0
votes
0answers
37 views

AddRastersToMosaicDataset_management performs slow

I have an enterprise Geodatabase (SQL Server) on my ArcGIS server machine. I perform my computations on several rasters on another machine (80 *.tif s with mean size of 50kb). When I want to add the ...
1
vote
0answers
253 views

Comparing speed of Spatial Analysis with GeoJSON versus shapefile in QGIS?

I have a large dataset that I want to perform spatial analysis on in QGIS. Specifically, I want to perform a polygon intersection analysis between two polygon layers. Given the size of the dataset ...
3
votes
1answer
275 views

PostGIS ST_Intersects is slow and doesn't seem to use spatial index

There are several threads about ST_Intersects being slow (like this one). Main advise is to use spatial index. Well I know that and created spatial index beforehand, but the query is slow nevertheless ...
1
vote
1answer
119 views

Network Has Slow Performance in SDE

I am working with ArcGIS Network Analyst (10.5.1). I created a network in SDE and everything worked fine. The network is versioned on SDE. I updated the source line features of the network in a ...
2
votes
0answers
200 views

Optimizing MySQL query to select all points with in a large polygon using spatial indexes

Re-posting it from stackoverflow as per their suggestion. Link to the thread in stackoverflow https://stackoverflow.com/questions/53182385/optimizing-mysql-query-to-select-all-points-with-in-polygon-...
5
votes
1answer
316 views

Only union/dissolve intersecting features to save time?

I have one table of about 300k polygons, some overlapping but most do not. I need to dissolve the overlapping ones and also keep the non-overlapping ones. I only need the geometries, no attributes. I ...
1
vote
0answers
124 views

QGIS export selection to shapefiles is extremely slow; using only 5 to 10% CPU

I am using QGIS 3.2.3. I am trying to do some simple actions. Selecting by attribute and exporting to shapefiles. I am using a OSM file as a source which is barely 60MB. But for some reason the ...
2
votes
1answer
105 views

Speeding up ST_Value in PostgreSQL?

I am working on a large point file and am looking to get the raster value underneath each point. I am using: UPDATE Locations a SET image3b3_sum = ST_Value(rast, 1, geom) FROM image_sum_sum; 10 ...
5
votes
3answers
265 views

Which ArcGIS Online basemap has the best performance in ArcMap?

My company plans to do demos of ArcMap Add-Ins for some of our clients and we want to make sure ArcMap is performing the best it can. One of the major performance concerns is the speed of the ...
2
votes
1answer
53 views

ArcPy runs slow outside ArcMap?

I'm running a fairly small script to get height differences. The scripts gets the height in a point based on a DTM. Running the script in the ArcMap python window uses 1 min 30 seconds for 1000 points,...
1
vote
0answers
448 views

QGIS 3.4.0 Madeira: unresponsive

I "upgraded" from 3.2.3 to 3.4.0 and it's so unresponsive it's unusable. The startup time is the same as 3.2.3, then it needs half a minute to build its UI. When I click on the UI, the reaction is ...
-1
votes
1answer
48 views

More Pythonic way to loop through UpdateCursor?

I have several sets of fields to populate based on other fields. The code below works, but I am wondering if there is a more Pythonic way to march through the i,j pairs? (Actual fieldnames are not ...
1
vote
1answer
208 views

Speed up intersection, union in PostGIS?

I have three tables: water, wetlands and parcels. I want to update parcel table with area that is covered by water or wetland (they can overlap). So I want to Merge water with wetland Dissolve and ...
2
votes
1answer
94 views

Optimizing workflow for FUSION's PolyClipData?

I have multiple large LiDAR datasets (.laz) from different areas, where I need to extract buildings. I have prepared a shapefile containing a buffer around the buildings I care about, and are using ...
0
votes
0answers
112 views

MS SQL Server STEnvelope() performance

Using MS SQL Server 2012, when we write a query with select GEOM.STEnvelope() from table where table holds approx. 4000 native SQL Server line geometries of type geometry, with 2/6/180 points min/...
0
votes
0answers
73 views

Does Geopackage field length affect performance?

I have moved away from shapefiles, and now store most of my desktop spatial data in a Geopackage. One of my fields is used to store research notes and is 'Type TEXT' with a character limit of 254. I ...
2
votes
0answers
116 views

pgrouting extension slow in PostgreSQL 10?

I am trying to implement routing on my road dataset using pgrouting function pgr_createTopology. It works fine on postgresql 9.6 but gets extremely slow and get stuck as nodes increase in postgresql ...
0
votes
1answer
199 views

Geoserver slow rendering un-cached layers

I have GeoServer connected to a SQL Server datastore. I have a map with 5 Layers, the layers have about 200,000 features total. The features are styled as simple points or lines - not many lines ...
2
votes
1answer
121 views

Leaflet GeoJSON Map Buffering

I am using Leaflet with Custom GeoJSON Layers to display my map. I noticed that the map off-screen is only loaded after releasing the mouse button during a drag. Hopefully, this demo makes it more ...