units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, AGNCY_TYP = 1 and PARK_URL = "http://www.parks.ca.gov/default.asp?page_id=639"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14612 | 14612 | 14611 | {"type": "MultiPolygon", "coordinates": [[[[-115.85227, 33.45336], [-115.85225, 33.45601], [-115.84339, 33.45573], [-115.84342, 33.44822], [-115.83486, 33.44796], [-115.83482, 33.44686], [-115.83471, 33.44137], [-115.83467, 33.44135], [-115.83467, 33.44132], [-115.8347, 33.44131], [-115.8347, 33.44126], [-115.83518, 33.44132], [-115.8375, 33.44131], [-115.84217, 33.44138], [-115.84249, 33.44141], [-115.84378, 33.44134], [-115.84467, 33.44136], [-115.85209, 33.44124], [-115.85217, 33.44525], [-115.85227, 33.45336]]], [[[-115.86954, 33.4268], [-115.86954, 33.42685], [-115.86943, 33.42686], [-115.8695, 33.44092], [-115.86815, 33.44098], [-115.85237, 33.44124], [-115.85237, 33.43948], [-115.85247, 33.42767], [-115.8523, 33.42677], [-115.85568, 33.42683], [-115.85569, 33.42686], [-115.86954, 33.4268]]], [[[-115.90464, 33.45563], [-115.90459, 33.47015], [-115.88726, 33.47025], [-115.88714, 33.47491], [-115.88438, 33.47362], [-115.88275, 33.47133], [-115.88276, 33.47016], [-115.88724, 33.4701], [-115.8871, 33.46767], [-115.88727, 33.45568], [-115.87012, 33.45559], [-115.86993, 33.4594], [-115.8697, 33.46293], [-115.86941, 33.46292], [-115.8694, 33.4628], [-115.86545, 33.46062], [-115.8655, 33.45934], [-115.86343, 33.45939], [-115.86122, 33.45801], [-115.86131, 33.45576], [-115.8638, 33.45578], [-115.87011, 33.45558], [-115.87012, 33.44116], [-115.87582, 33.44116], [-115.88726, 33.44099], [-115.88727, 33.45568], [-115.90464, 33.45563]]], [[[-115.90481, 33.48469], [-115.90471, 33.49104], [-115.90464, 33.49502], [-115.90447, 33.49485], [-115.90369, 33.494], [-115.90293, 33.49311], [-115.89935, 33.48832], [-115.90043, 33.4883], [-115.90028, 33.48473], [-115.90481, 33.48469]]], [[[-115.92191, 33.47016], [-115.92185, 33.48464], [-115.91746, 33.48465], [-115.91749, 33.48103], [-115.91321, 33.48096], [-115.91304, 33.48468], [-115.90881, 33.48469], [-115.90883, 33.48116], [-115.90454, 33.48114], [-115.90459, 33.47021], [-115.92191, 33.47016]]], [[[-115.92198, 33.49937], [-115.92182, 33.51089], [-115.91969, 33.51088], [-115.91784, 33.50922], [-115.91728, 33.50874], [-115.91664, 33.50809], [-115.91607, 33.5074], [-115.91549, 33.50657], [-115.91397, 33.50449], [-115.91353, 33.50392], [-115.91307, 33.50337], [-115.91249, 33.50273], [-115.90904, 33.4993], [-115.92198, 33.49937]]]]} | Open Access 1 | 44826 | Salton Sea State Recreation Area | 13840 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=639 | Riverside 10 | 3392.068 | Salton Sea SRA | 1951 | 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]);