File: topogeometry_type.sql

package info (click to toggle)
postgis 3.3.2%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 87,748 kB
  • sloc: ansic: 158,671; sql: 91,546; xml: 54,004; cpp: 12,339; sh: 5,187; perl: 5,100; makefile: 3,085; python: 1,205; yacc: 447; lex: 151; javascript: 6
file content (39 lines) | stat: -rw-r--r-- 1,418 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
set client_min_messages to WARNING;

\i :top_builddir/topology/test/load_topology.sql
\i ../load_features.sql
\i ../more_features.sql
\i ../hierarchy.sql

SELECT DISTINCT 'GeometryType(traffic_signs)',
	geometrytype(feature) FROM features.traffic_signs;
SELECT DISTINCT 'ST_GeometryType(traffic_signs)',
	st_geometrytype(feature) FROM features.traffic_signs;

SELECT DISTINCT 'GeometryType(city_streets)',
	geometrytype(feature) FROM features.city_streets;
SELECT DISTINCT 'ST_GeometryType(city_streets)',
	st_geometrytype(feature) FROM features.city_streets;

SELECT DISTINCT 'GeometryType(land_parcels)',
	geometrytype(feature) FROM features.land_parcels;
SELECT DISTINCT 'ST_GeometryType(land_parcels)',
	st_geometrytype(feature) FROM features.land_parcels;

SELECT DISTINCT 'GeometryType(big_signs)',
	geometrytype(feature) FROM features.big_signs;
SELECT DISTINCT 'ST_GeometryType(big_signs)',
	st_geometrytype(feature) FROM features.big_signs;

SELECT DISTINCT 'GeometryType(big_streets)',
	geometrytype(feature) FROM features.big_streets;
SELECT DISTINCT 'ST_GeometryType(big_streets)',
	st_geometrytype(feature) FROM features.big_streets;

SELECT DISTINCT 'GeometryType(big_parcels)',
	geometrytype(feature) FROM features.big_parcels;
SELECT DISTINCT 'ST_GeometryType(big_parcels)',
	st_geometrytype(feature) FROM features.big_parcels;

SELECT topology.DropTopology('city_data');
DROP SCHEMA features CASCADE;