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
0answers
98 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
241 views

Find nearest neighbours faster in PostGIS

I currently have a query that calculates the number of useful amenities within a certain radius of each town, using OSM data: create table places as select town.name, place, town.way, ( select ...
1
vote
1answer
78 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
440 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
24 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
846 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
0answers
75 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 ...