calands

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

Custom SQL query

Tables

ACCESS_TYP

id, value

4 rows

AGNCY_LEV

id, value

8 rows

AGNCY_NAME

id, value

1,184 rows

AGNCY_TYP

id, value

36 rows

COUNTY

id, value

58 rows

CPAD_2020a_SuperUnits

id, ACCESS_TYP, PARK_NAME, PARK_URL, SUID_NMA, MNG_AG_ID, MNG_AGENCY, MNG_AG_LEV, MNG_AG_TYP, AGNCY_WEB, LAYER, ACRES, LABEL_NAME, YR_EST, geometry

15,638 rows

CPAD_2020a_Units

id, ACCESS_TYP, UNIT_ID, UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AGENCY, MNG_AG_LEV, MNG_AG_TYP, PARK_URL, COUNTY, ACRES, LABEL_NAME, YR_EST, DES_TP, GAP_STS, geometry

17,068 rows

DES_TP

id, value

1,427 rows

LAYER

id, value

14 rows

MNG_AGENCY

id, value

1,122 rows

MNG_AG_LEV

id, value

8 rows

MNG_AG_TYP

id, value

34 rows

superunits_with_maps

id, map, ACCESS_TYP, PARK_NAME, PARK_URL, SUID_NMA, MNG_AG_ID, MNG_AGENCY, MNG_AG_LEV, MNG_AG_TYP, AGNCY_WEB, LAYER, ACRES, LABEL_NAME, YR_EST

15,638 rows

units_with_maps

id, map, ACCESS_TYP, UNIT_ID, UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AGENCY, MNG_AG_LEV, MNG_AG_TYP, PARK_URL, COUNTY, ACRES, LABEL_NAME, YR_EST, DES_TP, GAP_STS

17,068 rows

CPAD_2020a_SuperUnits_fts (hidden)

PARK_NAME, CPAD_2020a_SuperUnits_fts, rank

15,638 rows

CPAD_2020a_SuperUnits_fts_config (hidden)

k, v

1 row

CPAD_2020a_SuperUnits_fts_data (hidden)

id, block

57 rows

CPAD_2020a_SuperUnits_fts_docsize (hidden)

id, sz

15,638 rows

CPAD_2020a_SuperUnits_fts_idx (hidden)

segid, term, pgno

48 rows

CPAD_2020a_Units_fts (hidden)

UNIT_NAME, CPAD_2020a_Units_fts, rank

17,068 rows

CPAD_2020a_Units_fts_config (hidden)

k, v

1 row

CPAD_2020a_Units_fts_data (hidden)

id, block

63 rows

CPAD_2020a_Units_fts_docsize (hidden)

id, sz

17,068 rows

CPAD_2020a_Units_fts_idx (hidden)

segid, term, pgno

54 rows

ElementaryGeometries (hidden)

db_prefix, f_table_name, f_geometry_column, origin_rowid, item_no, geometry

0 rows

SpatialIndex (hidden)

f_table_name, f_geometry_column, search_frame

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

pkid, xmin, xmax, ymin, ymax

15,638 rows

idx_CPAD_2020a_SuperUnits_geometry_node (hidden)

nodeno, data

457 rows

idx_CPAD_2020a_SuperUnits_geometry_parent (hidden)

nodeno, parentnode

456 rows

idx_CPAD_2020a_SuperUnits_geometry_rowid (hidden)

rowid, nodeno

15,638 rows

idx_CPAD_2020a_Units_geometry (hidden)

pkid, xmin, xmax, ymin, ymax

17,068 rows

idx_CPAD_2020a_Units_geometry_node (hidden)

nodeno, data

499 rows

idx_CPAD_2020a_Units_geometry_parent (hidden)

nodeno, parentnode

498 rows

idx_CPAD_2020a_Units_geometry_rowid (hidden)

rowid, nodeno

17,068 rows

spatial_ref_sys (hidden)

srid, auth_name, auth_srid, ref_sys_name, proj4text, srtext

4,924 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

4,873 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

1 row

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

Download SQLite DB: calands.db 182.8 MB