units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 18, DES_TP = 55 and MNG_AGENCY = 73
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- California State Lands Commission · 2 ✖
DES_TP 1
- State Resource Management Area · 2 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4153 | 4153 | 4152 | {"type": "Polygon", "coordinates": [[[-122.83779, 40.22768], [-122.83774, 40.24195], [-122.81931, 40.24226], [-122.81888, 40.22865], [-122.83779, 40.22768]]]} | Unknown Access 4 | 44717 | California State Lands Commission | 16726 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Tehama 18 | 608.074 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 16877 | 16877 | 16876 | {"type": "MultiPolygon", "coordinates": [[[[-121.64937, 40.28726], [-121.63055, 40.28689], [-121.63, 40.2729], [-121.64891, 40.27295], [-121.64937, 40.28726]]], [[[-121.65267, 40.10025], [-121.65256, 40.10793], [-121.63372, 40.10847], [-121.63388, 40.10133], [-121.65267, 40.10025]]], [[[-121.76334, 40.1103], [-121.75869, 40.11031], [-121.75863, 40.10674], [-121.76329, 40.10673], [-121.76334, 40.1103]]], [[[-121.78663, 40.43028], [-121.78661, 40.43389], [-121.78185, 40.43388], [-121.78186, 40.43026], [-121.78663, 40.43028]]], [[[-121.99011, 40.37407], [-121.97106, 40.37409], [-121.97033, 40.35972], [-121.98967, 40.35963], [-121.99011, 40.37407]]], [[[-122.18313, 40.34405], [-122.18313, 40.34431], [-122.1828, 40.34501], [-122.18234, 40.34564], [-122.18213, 40.34641], [-122.18184, 40.34778], [-122.18159, 40.34878], [-122.18135, 40.34954], [-122.18079, 40.35056], [-122.18028, 40.35111], [-122.17949, 40.35142], [-122.1785, 40.35172], [-122.17745, 40.35254], [-122.17681, 40.35294], [-122.177, 40.35189], [-122.17733, 40.35067], [-122.17741, 40.34924], [-122.17771, 40.34692], [-122.17834, 40.34563], [-122.17891, 40.34518], [-122.17982, 40.34472], [-122.18181, 40.34406], [-122.18264, 40.34399], [-122.18313, 40.34405]]], [[[-122.21038, 40.33559], [-122.2104, 40.33686], [-122.2103, 40.33725], [-122.20943, 40.33978], [-122.20937, 40.34033], [-122.20924, 40.34059], [-122.20866, 40.341], [-122.20784, 40.3421], [-122.20754, 40.34265], [-122.207, 40.34311], [-122.20655, 40.34339], [-122.206, 40.34356], [-122.20514, 40.34376], [-122.20456, 40.34351], [-122.20393, 40.34333], [-122.20358, 40.34331], [-122.20318, 40.34345], [-122.20272, 40.34392], [-122.20243, 40.34392], [-122.2018, 40.34368], [-122.20211, 40.34349], [-122.20211, 40.34348], [-122.2015, 40.34325], [-122.20236, 40.34293], [-122.20301, 40.34284], [-122.20309, 40.34297], [-122.20449, 40.34219], [-122.20497, 40.34184], [-122.20504, 40.34149], [-122.20588, 40.34041], [-122.20676, 40.3395], [-122.20798, 40.33809], [-122.20891, 40.33724], [-122.20929, 40.33666], [-122.21038, 40.33559]]], [[[-122.61045, 39.98004], [-122.60584, 39.98015], [-122.60581, 39.98744], [-122.59671, 39.98763], [-122.59659, 39.98037], [-122.60122, 39.98026], [-122.60119, 39.97303], [-122.61044, 39.97294], [-122.61045, 39.98004]]], [[[-122.66576, 40.0299], [-122.64688, 40.03072], [-122.64722, 40.0165], [-122.66545, 40.01534], [-122.66576, 40.0299]]], [[[-122.76542, 40.05505], [-122.76073, 40.05505], [-122.76073, 40.05148], [-122.76541, 40.05147], [-122.76542, 40.05505]]], [[[-122.77482, 40.05504], [-122.77012, 40.05504], [-122.77011, 40.05147], [-122.77481, 40.05147], [-122.77482, 40.05504]]], [[[-122.9503, 40.15105], [-122.93164, 40.15138], [-122.93159, 40.13814], [-122.95027, 40.13752], [-122.9503, 40.15105]]]]} | Open Access 1 | 23157 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Tehama 18 | 3389.103 | SLC | 0 | State Resource Management Area 55 | 3 |
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]);