Optimisation is the act of making things as good as possible with regard to some criterion, eg. more efficient, faster or slimmer.

learn more… | top users | synonyms

2
votes
1answer
55 views

Maximize clusters of points from coordinate data

So I am definitely new to the GIS world, so bear with me if I don't know the best way to articulate my problem. That said, I am ready to learn, I would definitely welcome any direction that you all ...
2
votes
0answers
110 views

Covering a Polygon with Minimum number of circles with fixed locations

In QGIS, I have a vector polygon of a fixed size and shape. I also have a set of circles of a fixed radius and fixed location, which cover part of the polygon. What I would like to do is remove as ...
1
vote
1answer
86 views

Wind turbine placement optimization and loss on surrounding house value

I am doing a geostatistical placement optimization study on where would be the optimal placement of a wind turbine in a Danish region. One of the variables taken into account is the cost on the value ...
1
vote
1answer
474 views

Enhance performance of a join query for mapnik using postgis

I use mapnik to render map with datasources from a postgis database. One query is a join on two table, one with a geometry (a polygon) and the other one with some fields I want to use for rendering. ...
1
vote
0answers
24 views

How to make some constraint to be evaluated first in mysql?

SELECT BusinessID FROM tableauxiliary WHERE MBRContains( GeomFromText ( 'MULTIPOINT(-6.1928749092968 106.7651250907,-6.1771250907032 106.7808749093)' ), ...
0
votes
2answers
32 views

How can I optimize this point-linking query?

I have the following query, and am wondering how it could be optimised to run faster: WITH gps_nodes_1 AS ( SELECT "NODE_ID", "geog" FROM gps_nodes WHERE ST_Distance("geog",ST_GeogFromText('POINT( ...
0
votes
1answer
937 views

CQL Filter in Geoserver very slow?

I am experimenting with CQL filtering in Geoserver. I have two layers, one (A) has 8000 features, the other one (B) has 3000 features or so. I would like to search of layer A for intersection with ...
0
votes
1answer
23 views

Improving speed on pgRouting on table update with many rows: faster to loop on each row than a table update call?

I am updating thousands of rows in a survey table finding shortest path from each place a survey respondent visits. My code below is the query I use to update the blank route column. The function ...
0
votes
0answers
19 views

How to build an optimization model? [duplicate]

I want to make a model using QGIS. Is it possible? Then how can I develop a model. can anyone help me?
0
votes
0answers
77 views

I could use some help with a bit of code optimization

See edit below. I posted here a couple weeks ago looking for some advice on the best way to iterate through data. You can find that post here. I have since done some tweaking to the code, and ...