| /dports/databases/postgis30/postgis-3.0.4/regress/core/ |
| H A D | regress_brin_index_3d.sql | 39 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
42 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
45 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
55 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
58 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
61 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
76 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
86 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
101 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
111 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
[all …]
|
| H A D | regress_brin_index.sql | 31 CREATE INDEX brin_2d on test using brin (the_geom);
38 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
41 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
44 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
51 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
54 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
57 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
69 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
76 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
88 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
[all …]
|
| H A D | cluster.sql | 39 SELECT '#3612a', ST_ClusterDBSCAN(foo1.the_geom, 20.1, 5)OVER() As result
40 FROM ((SELECT geom As the_geom
47 select '#4100a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3)OVER() As r…
48 FROM ((SELECT ST_Collect(geom) As the_geom
55 select '#4101a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3) OVER() As …
56 FROM ((SELECT ST_GeomFromText('POINT EMPTY',4326) As the_geom
57 UNION ALL SELECT ST_GeomFromText('MULTIPOINT EMPTY',4326) As the_geom
58 UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON EMPTY',4326) As the_geom
59 UNION ALL SELECT ST_GeomFromText('LINESTRING EMPTY',4326) As the_geom
60 …UNION ALL SELECT ST_GeomFromText('MULTILINESTRING EMPTY',4326) As the_geom ) ) As foo1 LIMIT 10) k…
|
| /dports/databases/postgis32/postgis-3.2.0/regress/core/ |
| H A D | regress_brin_index_3d.sql | 39 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
42 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
45 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
55 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
58 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
61 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
76 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
86 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
101 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
111 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
[all …]
|
| H A D | regress_brin_index.sql | 31 CREATE INDEX brin_2d on test using brin (the_geom);
38 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
41 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
44 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
51 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
54 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
57 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
69 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
76 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
88 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
[all …]
|
| H A D | cluster.sql | 39 SELECT '#3612a', ST_ClusterDBSCAN(foo1.the_geom, 20.1, 5)OVER() As result
40 FROM ((SELECT geom As the_geom
47 select '#4100a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3) OVER() As …
48 FROM ((SELECT ST_Collect(geom) As the_geom
55 select '#4101a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3) OVER() As …
56 FROM ((SELECT ST_GeomFromText('POINT EMPTY',4326) As the_geom
57 UNION ALL SELECT ST_GeomFromText('MULTIPOINT EMPTY',4326) As the_geom
58 UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON EMPTY',4326) As the_geom
59 UNION ALL SELECT ST_GeomFromText('LINESTRING EMPTY',4326) As the_geom
60 …UNION ALL SELECT ST_GeomFromText('MULTILINESTRING EMPTY',4326) As the_geom ) ) As foo1 LIMIT 10) k…
|
| /dports/databases/postgis25/postgis-2.5.5/regress/ |
| H A D | regress_brin_index_3d.sql | 39 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
42 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
45 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
55 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
58 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
61 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
76 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
86 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
101 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
111 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
[all …]
|
| H A D | regress_brin_index.sql | 31 CREATE INDEX brin_2d on test using brin (the_geom);
38 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
41 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
44 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
51 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
54 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
57 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
69 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
76 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
88 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
[all …]
|
| H A D | knn.sql | 27 CREATE INDEX test_gist_2d on test using gist (the_geom);
31 (the_geom <-> 'POINT(2.5 2.5)'::geometry)::numeric(10,2),
32 ST_astext(the_geom) from test
33 order by the_geom <-> 'POINT(2.5 2.5)'::geometry LIMIT 1;
39 ST_astext(the_geom) from test
46 UPDATE test set the_geom = ST_MakePoint(
47 ST_X(the_geom), ST_Y(the_geom),
67 (the_geom <<->> 'LINESTRING(0 0,5 5)'::geometry)::numeric(10,2),
68 ST_astext(the_geom) from test
72 ST_astext(the_geom) from test
[all …]
|
| H A D | cluster.sql | 39 SELECT '#3612a', ST_ClusterDBSCAN(foo1.the_geom, 20.1, 5)OVER() As result
40 FROM ((SELECT geom As the_geom
47 select '#4100a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3)OVER() As r…
48 FROM ((SELECT ST_Collect(geom) As the_geom
55 select '#4101a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3) OVER() As …
56 FROM ((SELECT ST_GeomFromText('POINT EMPTY',4326) As the_geom
57 UNION ALL SELECT ST_GeomFromText('MULTIPOINT EMPTY',4326) As the_geom
58 UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON EMPTY',4326) As the_geom
59 UNION ALL SELECT ST_GeomFromText('LINESTRING EMPTY',4326) As the_geom
60 …UNION ALL SELECT ST_GeomFromText('MULTILINESTRING EMPTY',4326) As the_geom ) ) As foo1 LIMIT 10) k…
|
| /dports/databases/postgis31/postgis-3.1.4/regress/core/ |
| H A D | regress_brin_index_3d.sql | 39 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
42 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
45 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
55 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom && 'BOX(125 125,126 126)'::box2d order by…
58 …SELECT num, ST_astext(the_geom) FROM test WHERE 'BOX(125 125,126 126)'::box2d ~ the_geom order by …
61 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom @ 'BOX(125 125,126 126)'::box2d order by …
76 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
86 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
101 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
111 …SELECT num, ST_astext(the_geom) FROM test WHERE the_geom &&& 'BOX3D(125 125 125,126 126 126)'::box…
[all …]
|
| H A D | regress_brin_index.sql | 31 CREATE INDEX brin_2d on test using brin (the_geom);
38 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
41 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
44 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
51 …select num,ST_astext(the_geom) from test where the_geom && 'BOX(125 125,135 135)'::box2d order by …
54 …select num,ST_astext(the_geom) from test where 'BOX(125 125,135 135)'::box2d ~ the_geom order by n…
57 …select num,ST_astext(the_geom) from test where the_geom @ 'BOX(125 125,135 135)'::box2d order by n…
69 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
76 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
88 …select num,ST_astext(the_geom) from test where the_geom &&& 'BOX3D(125 125,135 135)'::box3d order …
[all …]
|
| H A D | cluster.sql | 39 SELECT '#3612a', ST_ClusterDBSCAN(foo1.the_geom, 20.1, 5)OVER() As result
40 FROM ((SELECT geom As the_geom
47 select '#4100a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3) OVER() As …
48 FROM ((SELECT ST_Collect(geom) As the_geom
55 select '#4101a', count(distinct result) from (SELECT ST_ClusterKMeans(foo1.the_geom, 3) OVER() As …
56 FROM ((SELECT ST_GeomFromText('POINT EMPTY',4326) As the_geom
57 UNION ALL SELECT ST_GeomFromText('MULTIPOINT EMPTY',4326) As the_geom
58 UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON EMPTY',4326) As the_geom
59 UNION ALL SELECT ST_GeomFromText('LINESTRING EMPTY',4326) As the_geom
60 …UNION ALL SELECT ST_GeomFromText('MULTILINESTRING EMPTY',4326) As the_geom ) ) As foo1 LIMIT 10) k…
|
| /dports/databases/postgis32/postgis-3.2.0/liblwgeom/cunit/ |
| H A D | cu_effectivearea.c | 44 LWLINE *the_geom; in do_test_lwgeom_effectivearea_lines() local
47 the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(1 1, 0 1, 0 2, -1 4, -1 4)", LW_PARSER_CHECK_NONE); in do_test_lwgeom_effectivearea_lines()
49 do_test_lwgeom_effectivearea(the_geom->points,the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
50 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
52 …the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30… in do_test_lwgeom_effectivearea_lines()
54 do_test_lwgeom_effectivearea(the_geom->points,the_areas2,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
55 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
62 LWPOLY *the_geom; in do_test_lwgeom_effectivearea_polys() local
66 …the_geom = (LWPOLY*)lwgeom_from_wkt("POLYGON((10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30,1… in do_test_lwgeom_effectivearea_polys()
68 do_test_lwgeom_effectivearea(the_geom->rings[0],the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_polys()
[all …]
|
| /dports/databases/postgis31/postgis-3.1.4/liblwgeom/cunit/ |
| H A D | cu_effectivearea.c | 44 LWLINE *the_geom; in do_test_lwgeom_effectivearea_lines() local
47 the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(1 1, 0 1, 0 2, -1 4, -1 4)", LW_PARSER_CHECK_NONE); in do_test_lwgeom_effectivearea_lines()
49 do_test_lwgeom_effectivearea(the_geom->points,the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
50 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
52 …the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30… in do_test_lwgeom_effectivearea_lines()
54 do_test_lwgeom_effectivearea(the_geom->points,the_areas2,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
55 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
62 LWPOLY *the_geom; in do_test_lwgeom_effectivearea_polys() local
66 …the_geom = (LWPOLY*)lwgeom_from_wkt("POLYGON((10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30,1… in do_test_lwgeom_effectivearea_polys()
68 do_test_lwgeom_effectivearea(the_geom->rings[0],the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_polys()
[all …]
|
| /dports/databases/postgis30/postgis-3.0.4/liblwgeom/cunit/ |
| H A D | cu_effectivearea.c | 44 LWLINE *the_geom; in do_test_lwgeom_effectivearea_lines() local
47 the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(1 1, 0 1, 0 2, -1 4, -1 4)", LW_PARSER_CHECK_NONE); in do_test_lwgeom_effectivearea_lines()
49 do_test_lwgeom_effectivearea(the_geom->points,the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
50 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
52 …the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30… in do_test_lwgeom_effectivearea_lines()
54 do_test_lwgeom_effectivearea(the_geom->points,the_areas2,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
55 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
62 LWPOLY *the_geom; in do_test_lwgeom_effectivearea_polys() local
66 …the_geom = (LWPOLY*)lwgeom_from_wkt("POLYGON((10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30,1… in do_test_lwgeom_effectivearea_polys()
68 do_test_lwgeom_effectivearea(the_geom->rings[0],the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_polys()
[all …]
|
| /dports/databases/postgis25/postgis-2.5.5/liblwgeom/cunit/ |
| H A D | cu_effectivearea.c | 44 LWLINE *the_geom; in do_test_lwgeom_effectivearea_lines() local
47 the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(1 1, 0 1, 0 2, -1 4, -1 4)", LW_PARSER_CHECK_NONE); in do_test_lwgeom_effectivearea_lines()
49 do_test_lwgeom_effectivearea(the_geom->points,the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
50 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
52 …the_geom = (LWLINE*)lwgeom_from_wkt("LINESTRING(10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30… in do_test_lwgeom_effectivearea_lines()
54 do_test_lwgeom_effectivearea(the_geom->points,the_areas2,avoid_collaps); in do_test_lwgeom_effectivearea_lines()
55 lwline_free(the_geom); in do_test_lwgeom_effectivearea_lines()
62 LWPOLY *the_geom; in do_test_lwgeom_effectivearea_polys() local
66 …the_geom = (LWPOLY*)lwgeom_from_wkt("POLYGON((10 10,12 8, 15 7, 18 7, 20 20, 15 21, 18 22, 10 30,1… in do_test_lwgeom_effectivearea_polys()
68 do_test_lwgeom_effectivearea(the_geom->rings[0],the_areas1,avoid_collaps); in do_test_lwgeom_effectivearea_polys()
[all …]
|
| /dports/databases/pgrouting/pgrouting-3.2.0/pgtap/topology/ |
| H A D | issue-1074.sql | 16 INSERT INTO original (id, the_geom) VALUES (1, 'SRID=4326;LineString (0 0, 2 1)');
17 INSERT INTO original (id, the_geom) VALUES (2, 'SRID=4326;LineString (0 2, 2 1)');
18 INSERT INTO original (id, the_geom) VALUES (3, 'SRID=4326;LineString (2 1, 5 1)');
19 INSERT INTO original (id, the_geom) VALUES (4, 'SRID=4326;LineString (1 2, 1 0)');
20 INSERT INTO original (id, the_geom) VALUES (5, 'SRID=4326;LineString (3 2, 3 0)');
21 INSERT INTO original (id, the_geom) VALUES (6, 'SRID=4326;LineString (4 2, 4 0)');
22 INSERT INTO original (id, the_geom) VALUES (7, 'SRID=4326;LineString (5 2, 5 0)');
39 the_geom GEOMETRY(LINESTRING, 4326) field
41 INSERT INTO original_noded (old_id, sub_id, source, target, the_geom)
42 SELECT old_id, sub_id, source, target, the_geom FROM original_roads
[all …]
|
| /dports/databases/pgrouting/pgrouting-3.2.0/docqueries/topology/ |
| H A D | doc-pgr_createVerticesTable.result | 55 SELECT pgr_createVerticesTable('edge_table', the_geom:='the_geom', source:='source', target:='targ…
73 …T pgr_createVerticesTable('edge_table', source:='source', target:='target', the_geom:='the_geom');
128 rows_where:='the_geom && (select st_buffer(the_geom,0.5) FROM edge_table WHERE id=5)');
130 …CE: pgr_createVerticesTable('edge_table','the_geom','source','target','the_geom && (select st_buf…
154 NOTICE: pgr_createVerticesTable('edge_table','the_geom','source','target','the_geom && (select st_…
228 the_geom:='mygeom');
267 'mytable', source:='src', target:='tgt', the_geom:='mygeom',
292 NOTICE: Got column "the_geom" does not exist
329 NOTICE: Got column "the_geom" does not exist
340 'mytable',source:='src',target:='tgt',the_geom:='mygeom',
[all …]
|
| H A D | createVertTab-any.test.sql | 11 …SELECT pgr_createVerticesTable('edge_table',the_geom:='the_geom',source:='source',target:='target…
12 …SELECT pgr_createVerticesTable('edge_table',source:='source',target:='target',the_geom:='the_geom…
18 …CREATE TABLE mytable AS (SELECT id AS gid, the_geom AS mygeom,source AS src ,target AS tgt FROM ed…
21 SELECT pgr_createVerticesTable('mytable',the_geom:='mygeom',source:='src',target:='tgt');
22 SELECT pgr_createVerticesTable('mytable',source:='src',target:='tgt',the_geom:='mygeom');
24 …SELECT pgr_createVerticesTable('mytable',source:='src',target:='tgt',the_geom:='mygeom',rows_wher…
27 SELECT pgr_createVerticesTable('mytable',source:='src',target:='tgt',the_geom:='mygeom',
33 SELECT pgr_createVerticesTable('mytable',source:='src',target:='tgt',the_geom:='mygeom',
|
| H A D | doc-pgr_createTopology.result | 31 'the_geom', 'id', 'source', 'target');
50 'id', 'the_geom');
54 NOTICE: ----> PGR ERROR in pgr_createTopology: Wrong type of Column id:the_geom
70 the_geom:='the_geom', id:='id', source:='source', target:='target');
83 source:='source', id:='id', target:='target', the_geom:='the_geom');
112 rows_where:='the_geom && (SELECT st_buffer(the_geom, 0.05) FROM edge_table WHERE id=5)');
123 rows_where:='the_geom && (SELECT st_buffer(other_geom, 1) FROM otherTable WHERE gid=100)');
164 SELECT pgr_createTopology('mytable', 0.001, the_geom:='mygeom', id:='gid', source:='src', target:=…
176 SELECT pgr_createTopology('mytable', 0.001, source:='src', id:='gid', target:='tgt', the_geom:='my…
203 SELECT pgr_createTopology('mytable', 0.001, source:='src', id:='gid', target:='tgt', the_geom:='my…
[all …]
|
| /dports/graphics/qgis/qgis-3.22.3/tests/testdata/ |
| H A D | create_test_tables | 10 SELECT addgeometrycolumn('public','test0','the_geom',4326,'LINESTRING',2);
16 SELECT addgeometrycolumn('public','test1','the_geom',4326,'LINESTRING',2);
23 SELECT addgeometrycolumn('public','test2','the_geom',4326,'LINESTRING',2);
29 SELECT addgeometrycolumn('public','test3','the_geom',4326,'LINESTRING',2);
35 SELECT addgeometrycolumn('public','test4','the_geom',4326,'LINESTRING',2);
41 SELECT addgeometrycolumn('public','test5','the_geom',4326,'LINESTRING',2);
48 SELECT addgeometrycolumn('public','test6','the_geom',4326,'LINESTRING',2);
56 SELECT addgeometrycolumn('public','test7','the_geom',4326,'LINESTRING',2);
63 SELECT addgeometrycolumn('public','test8','the_geom',4326,'LINESTRING',2);
69 SELECT addgeometrycolumn('public','test9','the_geom', 4326, 'LINESTRING',2);
[all …]
|
| /dports/graphics/qgis-ltr/qgis-3.16.16/tests/testdata/ |
| H A D | create_test_tables | 10 SELECT addgeometrycolumn('public','test0','the_geom',4326,'LINESTRING',2);
16 SELECT addgeometrycolumn('public','test1','the_geom',4326,'LINESTRING',2);
23 SELECT addgeometrycolumn('public','test2','the_geom',4326,'LINESTRING',2);
29 SELECT addgeometrycolumn('public','test3','the_geom',4326,'LINESTRING',2);
35 SELECT addgeometrycolumn('public','test4','the_geom',4326,'LINESTRING',2);
41 SELECT addgeometrycolumn('public','test5','the_geom',4326,'LINESTRING',2);
48 SELECT addgeometrycolumn('public','test6','the_geom',4326,'LINESTRING',2);
56 SELECT addgeometrycolumn('public','test7','the_geom',4326,'LINESTRING',2);
63 SELECT addgeometrycolumn('public','test8','the_geom',4326,'LINESTRING',2);
69 SELECT addgeometrycolumn('public','test9','the_geom', 4326, 'LINESTRING',2);
[all …]
|
| /dports/databases/postgis25/postgis-2.5.5/extras/tiger_geocoder/ |
| H A D | tiger_loader_2017.sql | 40 the_geom geometry,
41 CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
42 …CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom I…
43 CONSTRAINT enforce_srid_geom CHECK (st_srid(the_geom) = 4269)
64 the_geom geometry,
65 CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
66 …CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom I…
86 the_geom geometry,
87 CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
88 …CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom I…
[all …]
|
| H A D | tiger_loader_2016.sql | 40 the_geom geometry,
41 CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
42 …CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom I…
43 CONSTRAINT enforce_srid_geom CHECK (st_srid(the_geom) = 4269)
64 the_geom geometry,
65 CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
66 …CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom I…
67 CONSTRAINT enforce_srid_geom CHECK (st_srid(the_geom) = 4269)
86 the_geom geometry,
87 CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
[all …]
|