home

Menu
  • GraphQL API
  • Log in

cryptids

Table actions
  • GraphQL API for cryptids

Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology

Queries

  • Find cryptids with range encompassing a lat/lon

Tables

cryptids

id, name, wikipedia_url, additional_url, description, copyright, first_sighted, last_sighted, geom, range

12 rows

ElementaryGeometries (hidden)

db_prefix, f_table_name, f_geometry_column, origin_rowid, item_no, geometry

0 rows

KNN (hidden)

f_table_name, f_geometry_column, ref_geometry, max_items, pos, fid, distance

0 rows

SpatialIndex (hidden)

f_table_name, f_geometry_column, search_frame

0 rows

data_licenses (hidden)

id, name, url

10 rows

geometry_columns (hidden)

f_table_name, f_geometry_column, geometry_type, coord_dimension, srid, spatial_index_enabled

2 rows

geometry_columns_auth (hidden)

f_table_name, f_geometry_column, read_only, hidden

2 rows

geometry_columns_field_infos (hidden)

f_table_name, f_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

0 rows

geometry_columns_statistics (hidden)

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

2 rows

geometry_columns_time (hidden)

f_table_name, f_geometry_column, last_insert, last_update, last_delete

2 rows

idx_cryptids_geom (hidden)

pkid, xmin, xmax, ymin, ymax

12 rows

idx_cryptids_geom_node (hidden)

nodeno, data

1 row

idx_cryptids_geom_parent (hidden)

nodeno, parentnode

0 rows

idx_cryptids_geom_rowid (hidden)

rowid, nodeno

12 rows

idx_cryptids_range (hidden)

pkid, xmin, xmax, ymin, ymax

12 rows

idx_cryptids_range_node (hidden)

nodeno, data

1 row

idx_cryptids_range_parent (hidden)

nodeno, parentnode

0 rows

idx_cryptids_range_rowid (hidden)

rowid, nodeno

12 rows

spatial_ref_sys (hidden)

srid, auth_name, auth_srid, ref_sys_name, proj4text, srtext

6,215 rows

spatial_ref_sys_aux (hidden)

srid, is_geographic, has_flipped_axes, spheroid, prime_meridian, datum, projection, unit, axis_1_name, axis_1_orientation, axis_2_name, axis_2_orientation

6,164 rows

spatialite_history (hidden)

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

16 rows

sql_statements_log (hidden)

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

0 rows

sqlite_sequence (hidden)

name, seq

2 rows

views_geometry_columns (hidden)

view_name, view_geometry, view_rowid, f_table_name, f_geometry_column, read_only

0 rows

views_geometry_columns_auth (hidden)

view_name, view_geometry, hidden

0 rows

views_geometry_columns_field_infos (hidden)

view_name, view_geometry, ordinal, column_name, null_values, integer_values, double_values, text_values, blob_values, max_size, integer_min, integer_max, double_min, double_max

0 rows

views_geometry_columns_statistics (hidden)

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 (hidden)

virt_name, virt_geometry, geometry_type, coord_dimension, srid

0 rows

virts_geometry_columns_auth (hidden)

virt_name, virt_geometry, hidden

0 rows

virts_geometry_columns_field_infos (hidden)

virt_name, virt_geometry, ordinal, column_name, null_values, integer_values, double_values, text_values, blob_values, max_size, integer_min, integer_max, double_min, double_max

0 rows

virts_geometry_columns_statistics (hidden)

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

0 rows

Views

  • geom_cols_ref_sys
  • spatial_ref_sys_all
  • vector_layers
  • vector_layers_auth
  • vector_layers_statistics
  • vector_layers_field_infos

Download SQLite DB: cryptids.db 8.3 MB

Powered by Datasette · Queries took 40.189ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology