Benchmarking 2011/QGIS notes - Revision history

Wiki-Leo at 11:16, 24 February 2015

2015-02-24T11:16:11Z

Sourcepole: JMeter

2011-09-12T07:35:14Z

JMeter

Sourcepole: QGIS tables

2011-09-08T11:55:04Z

QGIS tables

Sourcepole: QGIS notes

2011-09-07T22:16:17Z

QGIS notes

New page

== Data ==

Same problem with missing/non-unique keys as [[Benchmarking_2011/Cadcorp_notes | Cadcorp GeognoSIS]].

The views were converted to tables, and indexed, as follows:

<pre>
create table osm_railways_gen1_cadcorp as (select * from osm_railways_gen1);
alter table osm_railways_gen1_cadcorp add column cadcorp_id serial;
create index osm_railways_gen1_cadcorp_geometry_sidx on osm_railways_gen1_cadcorp using gist(geometry);
insert into geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") SELECT '', 'public', 'osm_railways_gen1_cadcorp', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry) FROM public.osm_railways_gen1_cadcorp LIMIT 1;
create unique index osm_railways_gen1_cadcorp_unqidx on osm_railways_gen1_cadcorp(cadcorp_id);
</pre>

This was done for the following [[Benchmarking_2011/Imposm|Imposm]] tables:

* osm_railways_gen1
* osm_roads_gen0
* osm_roads_gen1
* osm_roads

Giving the following additional tables:

* osm_railways_gen1_cadcorp
* osm_roads_gen0_cadcorp
* osm_roads_gen1_cadcorp
* osm_roads_cadcorp

=== Raster ===

Create GDAL VRT from tile index:

<pre>
/opt/qgisms/bin/gdalbuildvrt /benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.vrt /benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp
</pre>

[[Category:FOSS4G2011]] [[Category:FOSS4G]]

← Older revision		Revision as of 11:16, 24 February 2015
Line 53:		Line 53:
	</pre>		</pre>

−	[[Category:FOSS4G2011~~]] [[Category:FOSS4G~~]]	+	[[Category:FOSS4G2011]]

@@ Line 39: / Line 39: @@
 <pre>
 /opt/qgisms/bin/gdalbuildvrt /benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.vrt /benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp
 </pre>
 [[Category:FOSS4G2011]] [[Category:FOSS4G]]

@@ Line 1: / Line 1: @@
 == Data ==
-Same problem with missing/non-unique keys as [[Benchmarking_2011/Cadcorp_notes | Cadcorp GeognoSIS]].
+QGIS also requires tables with unique keys like [[Benchmarking_2011/Cadcorp_notes | Cadcorp GeognoSIS]].
 The views were converted to tables, and indexed, as follows:
 <pre>
-create table osm_railways_gen1_cadcorp as (select * from osm_railways_gen1);
+CREATE TABLE osm_roads_ordered AS (SELECT * FROM osm_roads ORDER BY z_order ASC, st_length(geometry) ASC);
-alter table osm_railways_gen1_cadcorp add column cadcorp_id serial;
+ALTER TABLE osm_roads_ordered ADD COLUMN unique_id serial;
-create index osm_railways_gen1_cadcorp_geometry_sidx on osm_railways_gen1_cadcorp using gist(geometry);
+CREATE INDEX osm_roads_ordered_geometry_sidx ON osm_roads_ordered USING gist(geometry);
-insert into geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") SELECT '', 'public', 'osm_railways_gen1_cadcorp', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry) FROM public.osm_railways_gen1_cadcorp LIMIT 1;
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
-create unique index osm_railways_gen1_cadcorp_unqidx on osm_railways_gen1_cadcorp(cadcorp_id);
+SELECT '', 'public', 'osm_roads_ordered', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry)
-</pre>
+FROM public.osm_roads_ordered LIMIT 1;
-This was done for the following [[Benchmarking_2011/Imposm|Imposm]] tables:
+CREATE TABLE osm_roads_gen0_ordered AS (SELECT * FROM osm_roads_gen0 ORDER BY z_order ASC, st_length(geometry) ASC);
-* osm_railways_gen1
+CREATE TABLE osm_roads_gen1_ordered AS (SELECT * FROM osm_roads_gen1 ORDER BY z_order ASC, st_length(geometry) ASC);
-* osm_roads_gen0
+ALTER TABLE osm_roads_gen1_ordered ADD COLUMN unique_id serial;
-* osm_roads_gen1
+CREATE INDEX osm_roads_gen1_ordered_geometry_sidx ON osm_roads_gen1_ordered USING gist(geometry);
-* osm_roads
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'public', 'osm_roads_gen1_ordered', 'geometry', ST_CoordDim(geometry), ST_SRID(geometry), GeometryType(geometry)
-Giving the following additional tables:
+FROM public.osm_roads_gen1_ordered LIMIT 1;
 === Raster ===