units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 39, LABEL_NAME = "Lake Oroville SRA" and MNG_AGENCY = 470
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Water Resources · 1 ✖
DES_TP 1
- State Recreation Area · 1 ✖
ACCESS_TYP 1
| Link | rowid ▼ | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16664 | 16664 | 16663 | {"type": "MultiPolygon", "coordinates": [[[[-121.4718, 39.53856], [-121.47165, 39.53846], [-121.47179, 39.53824], [-121.4718, 39.53855], [-121.4718, 39.53856]]], [[[-121.47192, 39.53738], [-121.4718, 39.53782], [-121.47179, 39.5379], [-121.47177, 39.53762], [-121.47192, 39.53738]]], [[[-121.47196, 39.53872], [-121.47186, 39.53878], [-121.47182, 39.53858], [-121.47196, 39.53872], [-121.47196, 39.53872]]], [[[-121.47266, 39.53693], [-121.47265, 39.53695], [-121.47261, 39.53697], [-121.47266, 39.53693], [-121.47266, 39.53693]]], [[[-121.50263, 39.5407], [-121.4956, 39.54076], [-121.50027, 39.53706], [-121.50027, 39.53705], [-121.49992, 39.53678], [-121.4996, 39.53692], [-121.49257, 39.54232], [-121.49207, 39.5426], [-121.49201, 39.54285], [-121.49136, 39.5429], [-121.49046, 39.54259], [-121.49085, 39.54228], [-121.48859, 39.54098], [-121.48397, 39.53775], [-121.47989, 39.53418], [-121.47785, 39.53254], [-121.47755, 39.5326], [-121.47646, 39.53354], [-121.47578, 39.53441], [-121.47501, 39.53508], [-121.47428, 39.53519], [-121.47339, 39.53517], [-121.47312, 39.53549], [-121.47308, 39.53551], [-121.47334, 39.53512], [-121.47361, 39.53508], [-121.47402, 39.53507], [-121.4744, 39.53496], [-121.47463, 39.53462], [-121.47494, 39.53442], [-121.47529, 39.53423], [-121.476, 39.53353], [-121.47671, 39.53313], [-121.47698, 39.53288], [-121.47735, 39.53264], [-121.47762, 39.53254], [-121.47763, 39.5323], [-121.47721, 39.53255], [-121.47654, 39.53287], [-121.47642, 39.53288], [-121.47619, 39.53285], [-121.47604, 39.53279], [-121.47592, 39.53271], [-121.47583, 39.53261], [-121.47577, 39.5325], [-121.47575, 39.53238], [-121.47577, 39.53226], [-121.4758, 39.53218], [-121.47596, 39.53198], [-121.4764, 39.53155], [-121.47669, 39.53132], [-121.47668, 39.5313], [-121.47634, 39.53131], [-121.47631, 39.5307], [-121.47727, 39.52978], [-121.47912, 39.5298], [-121.4811, 39.5262], [-121.48244, 39.52618], [-121.48365, 39.52618], [-121.48363, 39.52739], [-121.49333, 39.52782], [-121.49624, 39.52911], [-121.49687, 39.53025], [-121.49683, 39.53081], [-121.49604, 39.53037], [-121.4956, 39.53014], [-121.49478, 39.53008], [-121.49401, 39.5303], [-121.49345, 39.5304], [-121.4935, 39.53149], [-121.49361, 39.53172], [-121.49274, 39.53171], [-121.49135, 39.53182], [-121.49017, 39.53233], [-121.48979, 39.5326], [-121.48784, 39.53315], [-121.48699, 39.53356], [-121.48698, 39.5339], [-121.48734, 39.53402], [-121.48816, 39.53384], [-121.49165, 39.53267], [-121.49316, 39.53232], [-121.49391, 39.53235], [-121.49434, 39.53325], [-121.49495, 39.53343], [-121.49641, 39.53397], [-121.49699, 39.53422], [-121.49778, 39.53446], [-121.49829, 39.53481], [-121.49929, 39.53536], [-121.50023, 39.53594], [-121.50052, 39.53639], [-121.50112, 39.53675], [-121.5014, 39.53692], [-121.50197, 39.53698], [-121.5013, 39.53742], [-121.50263, 39.5407]]], [[[-121.49325, 39.5442], [-121.49315, 39.54423], [-121.49249, 39.54349], [-121.4924, 39.54317], [-121.49242, 39.54317], [-121.49275, 39.54346], [-121.49325, 39.5442]]]]} | Open Access 1 | 45426 | Lake Oroville State Recreation Area | 28207 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=462 | Butte 42 | 532.58 | Lake Oroville SRA | 1967 | State Recreation Area 39 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);