calands: units_with_maps: 4 rows where LAYER = 7 and MNG

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

4 rows where LAYER = 7 and MNG_AGENCY = 47

Search:

descending

This data as json, copyable, CSV (advanced)

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
14836	14836	14835	{"type": "Polygon", "coordinates": [[[-120.85541, 38.96626], [-120.85565, 38.96711], [-120.85552, 38.9681], [-120.85515, 38.96927], [-120.8546, 38.97052], [-120.85386, 38.97172], [-120.85317, 38.97268], [-120.85264, 38.97325], [-120.85206, 38.97381], [-120.85165, 38.97415], [-120.85166, 38.96875], [-120.85169, 38.96627], [-120.85541, 38.96626]]]}	Open Access 1	45316	Auburn State Recreation Area	13795	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=502	El Dorado 34	51.127	Auburn SRA	1966	State Recreation Area 39	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]);