vector_layers_field_infos (view)
4 rows
This data as json, copyable, CSV (advanced)
Suggested facets: text_values, blob_values
layer_type | table_name | geometry_column | ordinal | column_name | null_values | integer_values | double_values | text_values | blob_values | max_size | integer_min | integer_max | double_min | double_max |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SpatialTable | alerts | geometry | 0 | id | 0 | 0 | 0 | 352 | 0 | 36 | ||||
SpatialTable | alerts | geometry | 1 | timestamp | 0 | 0 | 0 | 352 | 0 | 20 | ||||
SpatialTable | alerts | geometry | 2 | description | 0 | 0 | 0 | 352 | 0 | 599 | ||||
SpatialTable | alerts | geometry | 3 | geometry | 0 | 0 | 0 | 0 | 352 | 40004 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW vector_layers_field_infos AS SELECT 'SpatialTable' AS layer_type, f_table_name AS table_name, f_geometry_column AS geometry_column, ordinal AS ordinal, column_name AS column_name, null_values AS null_values, integer_values AS integer_values, double_values AS double_values, text_values AS text_values, blob_values AS blob_values, max_size AS max_size, integer_min AS integer_min, integer_max AS integer_max, double_min AS double_min, double_max double_max FROM geometry_columns_field_infos UNION SELECT 'SpatialView' AS layer_type, view_name AS table_name, view_geometry AS geometry_column, ordinal AS ordinal, column_name AS column_name, null_values AS null_values, integer_values AS integer_values, double_values AS double_values, text_values AS text_values, blob_values AS blob_values, max_size AS max_size, integer_min AS integer_min, integer_max AS integer_max, double_min AS double_min, double_max double_max FROM views_geometry_columns_field_infos UNION SELECT 'VirtualShape' AS layer_type, virt_name AS table_name, virt_geometry AS geometry_column, ordinal AS ordinal, column_name AS column_name, null_values AS null_values, integer_values AS integer_values, double_values AS double_values, text_values AS text_values, blob_values AS blob_values, max_size AS max_size, integer_min AS integer_min, integer_max AS integer_max, double_min AS double_min, double_max double_max FROM virts_geometry_columns_field_infos;