home

timezones

Custom SQL query

ElementaryGeometries

db_prefix, f_table_name, f_geometry_column, origin_rowid, item_no, geometry

0 rows

SpatialIndex

f_table_name, f_geometry_column, search_frame

0 rows

geometry_columns

f_table_name, f_geometry_column, geometry_type, coord_dimension, srid, spatial_index_enabled

1 row

geometry_columns_auth

f_table_name, f_geometry_column, read_only, hidden

1 row

geometry_columns_field_infos

f_table_name, f_geometry_column, ordinal, column_name, null_values, integer_values, double_values, text_values, blob_values...

0 rows

geometry_columns_statistics

f_table_name, f_geometry_column, last_verified, row_count, extent_min_x, extent_min_y, extent_max_x, extent_max_y

1 row

geometry_columns_time

f_table_name, f_geometry_column, last_insert, last_update, last_delete

1 row

idx_timezones_Geometry

pkid, xmin, xmax, ymin, ymax

414 rows

idx_timezones_Geometry_node

nodeno, data

12 rows

idx_timezones_Geometry_parent

nodeno, parentnode

11 rows

idx_timezones_Geometry_rowid

rowid, nodeno

414 rows

spatial_ref_sys

srid, auth_name, auth_srid, ref_sys_name, proj4text, srtext

4,924 rows

spatial_ref_sys_aux

srid, is_geographic, has_flipped_axes, spheroid, prime_meridian, datum, projection, unit, axis_1_name...

4,873 rows

spatialite_history

event_id, table_name, geometry_column, event, timestamp, ver_sqlite, ver_splite

14 rows

sql_statements_log

id, time_start, time_end, user_agent, sql_statement, success, error_cause

1 row

sqlite_sequence

name, seq

3 rows

timezones

PK_UID, tzid, Geometry

414 rows

views_geometry_columns

view_name, view_geometry, view_rowid, f_table_name, f_geometry_column, read_only

0 rows

views_geometry_columns_auth

view_name, view_geometry, hidden

0 rows

views_geometry_columns_field_infos

view_name, view_geometry, ordinal, column_name, null_values, integer_values, double_values, text_values, blob_values...

0 rows

views_geometry_columns_statistics

view_name, view_geometry, last_verified, row_count, extent_min_x, extent_min_y, extent_max_x, extent_max_y

0 rows

virts_geometry_columns

virt_name, virt_geometry, geometry_type, coord_dimension, srid

0 rows

virts_geometry_columns_auth

virt_name, virt_geometry, hidden

0 rows

virts_geometry_columns_field_infos

virt_name, virt_geometry, ordinal, column_name, null_values, integer_values, double_values, text_values, blob_values...

0 rows

virts_geometry_columns_statistics

virt_name, virt_geometry, last_verified, row_count, extent_min_x, extent_min_y, extent_max_x, extent_max_y

0 rows

Views

Queries

Download SQLite DB: timezones.db

Powered by Datasette · Query took 0.074ms