units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, AGNCY_NAME = 38 and DES_TP = 15
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5037 | 5037 | 5036 | {"type": "MultiPolygon", "coordinates": [[[[-121.64557, 41.00813], [-121.64549, 41.01183], [-121.64071, 41.01185], [-121.64074, 41.00817], [-121.64557, 41.00813]]], [[[-121.64872, 41.01547], [-121.64863, 41.01865], [-121.64381, 41.01864], [-121.64381, 41.01552], [-121.64625, 41.01552], [-121.64872, 41.01547]]]]} | Open Access 1 | 25912 | McArthur-Burney Falls Memorial State Park | 14072 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=455 | Shasta 27 | 76.124 | McArthur-Burney Falls Memorial SP | 1920 | State Park 15 | 4 |
| 12238 | 12238 | 12237 | {"type": "Polygon", "coordinates": [[[-121.79219, 36.25187], [-121.78779, 36.2518], [-121.78779, 36.24823], [-121.78783, 36.24821], [-121.78942, 36.24824], [-121.78943, 36.24912], [-121.79001, 36.24914], [-121.79001, 36.2496], [-121.7912, 36.24963], [-121.79121, 36.25005], [-121.79218, 36.25005], [-121.79219, 36.25187]]]} | Open Access 1 | 25812 | Pfeiffer Big Sur State Park | 14088 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=570 | Monterey 14 | 29.345 | Pfeiffer Big Sur SP | 1933 | State Park 15 | 4 |
| 16622 | 16622 | 16621 | {"type": "Polygon", "coordinates": [[[-120.11174, 38.99104], [-120.1105, 38.99106], [-120.11046, 38.99122], [-120.11015, 38.99165], [-120.1099, 38.99185], [-120.10862, 38.99249], [-120.10848, 38.99272], [-120.10831, 38.99297], [-120.10823, 38.99329], [-120.10821, 38.99379], [-120.10827, 38.99438], [-120.1079, 38.99478], [-120.10761, 38.99483], [-120.10723, 38.99496], [-120.10255, 38.99844], [-120.10197, 39.00101], [-120.10101, 39.00043], [-120.10086, 39.00032], [-120.10039, 39.00012], [-120.1002, 39.00002], [-120.09996, 38.99992], [-120.09989, 38.99987], [-120.09952, 38.99975], [-120.09928, 38.9996], [-120.09903, 38.99936], [-120.09868, 38.9992], [-120.0982, 38.99911], [-120.09783, 38.99908], [-120.09737, 38.99907], [-120.09721, 38.9991], [-120.09674, 38.99927], [-120.09653, 38.99941], [-120.09645, 38.99945], [-120.09613, 38.99946], [-120.09598, 38.99941], [-120.09581, 38.99923], [-120.09581, 38.9992], [-120.09566, 38.99909], [-120.09548, 38.99886], [-120.09545, 38.99878], [-120.09547, 38.99849], [-120.09535, 38.99833], [-120.09517, 38.99818], [-120.09513, 38.99812], [-120.09512, 38.99801], [-120.09519, 38.99789], [-120.09519, 38.99772], [-120.09513, 38.99748], [-120.095, 38.99721], [-120.09494, 38.99716], [-120.09491, 38.99711], [-120.09486, 38.99707], [-120.09479, 38.99694], [-120.09453, 38.99658], [-120.09437, 38.99642], [-120.09407, 38.99615], [-120.09396, 38.99608], [-120.09394, 38.99605], [-120.09384, 38.99592], [-120.09384, 38.99578], [-120.09392, 38.99565], [-120.09408, 38.99552], [-120.09425, 38.99519], [-120.09446, 38.99508], [-120.09449, 38.99503], [-120.0945, 38.99494], [-120.09444, 38.99487], [-120.0944, 38.99481], [-120.09435, 38.99477], [-120.09427, 38.99458], [-120.09426, 38.99445], [-120.09429, 38.99434], [-120.09432, 38.99429], [-120.09445, 38.99411], [-120.0946, 38.99397], [-120.0946, 38.99387], [-120.09452, 38.99375], [-120.09446, 38.9936], [-120.0944, 38.99354], [-120.09435, 38.99344], [-120.09425, 38.99335], [-120.09413, 38.99324], [-120.09398, 38.99321], [-120.09363, 38.993], [-120.09357, 38.99291], [-120.09349, 38.99271], [-120.09346, 38.99268], [-120.09346, 38.99263], [-120.09342, 38.9926], [-120.09342, 38.99257], [-120.09339, 38.99256], [-120.09337, 38.99248], [-120.09346, 38.99221], [-120.09355, 38.99209], [-120.0936, 38.99196], [-120.09363, 38.99151], [-120.0937, 38.99122], [-120.09372, 38.991], [-120.0936, 38.99074], [-120.09358, 38.99068], [-120.09357, 38.99054], [-120.09354, 38.99052], [-120.09353, 38.99031], [-120.09356, 38.99024], [-120.09374, 38.9901], [-120.09401, 38.99002], [-120.09409, 38.98995], [-120.0941, 38.98986], [-120.09407, 38.98984], [-120.09408, 38.98976], [-120.09418, 38.98959], [-120.09431, 38.98942], [-120.09475, 38.98894], [-120.09486, 38.98881], [-120.09497, 38.9886], [-120.09498, 38.98841], [-120.09497, 38.98834], [-120.09489, 38.98821], [-120.0948, 38.98814], [-120.09463, 38.98805], [-120.09459, 38.98802], [-120.09457, 38.98795], [-120.09457, 38.98783], [-120.09455, 38.98774], [-120.09457, 38.98769], [-120.09483, 38.98751], [-120.09488, 38.98745], [-120.09492, 38.98738], [-120.09492, 38.9872], [-120.09488, 38.9871], [-120.09438, 38.9867], [-120.09426, 38.98649], [-120.09397, 38.98627], [-120.09389, 38.98617], [-120.09386, 38.98606], [-120.09384, 38.9858], [-120.09386, 38.9857], [-120.09384, 38.98522], [-120.09382, 38.9852], [-120.09377, 38.98486], [-120.09374, 38.98484], [-120.09371, 38.98456], [-120.09367, 38.98448], [-120.09355, 38.98438], [-120.09352, 38.98432], [-120.09355, 38.98401], [-120.09362, 38.98376], [-120.09364, 38.98337], [-120.09352, 38.98313], [-120.09335, 38.98289], [-120.09335, 38.98287], [-120.09331, 38.98281], [-120.09323, 38.98262], [-120.09317, 38.98254], [-120.09316, 38.98247], [-120.09314, 38.98244], [-120.09312, 38.98209], [-120.09319, 38.9816], [-120.09329, 38.98143], [-120.0934, 38.98134], [-120.09358, 38.98127], [-120.09361, 38.98122], [-120.09361, 38.98109], [-120.09358, 38.98102], [-120.09358, 38.98079], [-120.0936, 38.98077], [-120.09361, 38.98067], [-120.09364, 38.98064], [-120.0937, 38.98025], [-120.09375, 38.98013], [-120.09376, 38.98003], [-120.09379, 38.97984], [-120.09382, 38.97981], [-120.09382, 38.97949], [-120.09397, 38.97893], [-120.09395, 38.97879], [-120.09384, 38.97872], [-120.09383, 38.97844], [-120.09385, 38.9784], [-120.09395, 38.97835], [-120.09401, 38.97821], [-120.09401, 38.97779], [-120.09399, 38.97767], [-120.09393, 38.97757], [-120.09378, 38.97743], [-120.0937, 38.97741], [-120.09362, 38.97735], [-120.09361, 38.9773], [-120.09371, 38.97695], [-120.09374, 38.97676], [-120.09372, 38.97659], [-120.09362, 38.97636], [-120.09359, 38.97625], [-120.09357, 38.9759], [-120.09366, 38.97567], [-120.09371, 38.97561], [-120.09387, 38.97553], [-120.09394, 38.97545], [-120.09401, 38.97524], [-120.09399, 38.97497], [-120.09399, 38.97488], [-120.09401, 38.97478], [-120.0942, 38.97451], [-120.0942, 38.97402], [-120.09421, 38.97394], [-120.0942, 38.97336], [-120.09414, 38.97322], [-120.09403, 38.97312], [-120.09384, 38.97302], [-120.09377, 38.97295], [-120.09377, 38.97291], [-120.09375, 38.97289], [-120.0937, 38.97228], [-120.09367, 38.97216], [-120.09365, 38.97193], [-120.09361, 38.97162], [-120.09341, 38.9715], [-120.09306, 38.9714], [-120.0925, 38.9713], [-120.09233, 38.97124], [-120.09223, 38.97116], [-120.09221, 38.97108], [-120.09217, 38.97103], [-120.09213, 38.9709], [-120.09211, 38.97089], [-120.0921, 38.97081], [-120.09208, 38.9708], [-120.09204, 38.97066], [-120.09203, 38.97053], [-120.09199, 38.97045], [-120.0919, 38.9704], [-120.09158, 38.97028], [-120.0914, 38.9702], [-120.09114, 38.97001], [-120.09104, 38.96991], [-120.09095, 38.9698], [-120.09087, 38.96974], [-120.0908, 38.96973], [-120.09072, 38.96978], [-120.09049, 38.96995], [-120.09039, 38.96997], [-120.09034, 38.96995], [-120.0902, 38.96984], [-120.0901, 38.96974], [-120.08991, 38.96957], [-120.08988, 38.96951], [-120.08985, 38.96949], [-120.08979, 38.96905], [-120.08973, 38.96894], [-120.08968, 38.9689], [-120.08954, 38.96885], [-120.08937, 38.96884], [-120.08929, 38.96887], [-120.09332, 38.96568], [-120.0937, 38.96566], [-120.09798, 38.96568], [-120.10677, 38.96564], [-120.10703, 38.98017], [-120.11155, 38.98019], [-120.11174, 38.99104]], [[-120.10482, 38.9803], [-120.10477, 38.98018], [-120.10345, 38.98019], [-120.10354, 38.98048], [-120.10384, 38.98104], [-120.10408, 38.98141], [-120.10451, 38.98191], [-120.1049, 38.98229], [-120.10525, 38.98253], [-120.10647, 38.98327], [-120.10718, 38.98375], [-120.10767, 38.98426], [-120.10777, 38.98442], [-120.1078, 38.98459], [-120.10778, 38.9848], [-120.10754, 38.98542], [-120.10724, 38.98613], [-120.10711, 38.98683], [-120.10713, 38.98707], [-120.10711, 38.98731], [-120.10846, 38.98732], [-120.10846, 38.98721], [-120.1084, 38.98705], [-120.10838, 38.98687], [-120.10848, 38.98636], [-120.10875, 38.98573], [-120.10903, 38.98498], [-120.10908, 38.98458], [-120.109, 38.98412], [-120.10874, 38.98373], [-120.10815, 38.98311], [-120.10719, 38.98245], [-120.10615, 38.98183], [-120.10572, 38.98154], [-120.10508, 38.98089], [-120.10482, 38.9803]]]} | Open Access 1 | 44364 | D.L. Bliss State Park | 14014 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=505 | El Dorado 34 | 1161.858 | D.L. Bliss SP | 1929 | State Park 15 | 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]);