calands: units_with_maps: 3 rows where ACCESS_TYP = 2, COUNTY = 39 and MNG_AG

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

3 rows where ACCESS_TYP = 2, COUNTY = 39 and MNG_AG_TYP = 5

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
10050	10050	10049	{"type": "MultiPolygon", "coordinates": [[[[-121.5504, 37.81996], [-121.55037, 37.82003], [-121.55026, 37.82006], [-121.55015, 37.82005], [-121.55003, 37.82001], [-121.5497, 37.81985], [-121.54955, 37.8198], [-121.54921, 37.81974], [-121.54909, 37.81969], [-121.54905, 37.81963], [-121.54906, 37.81953], [-121.54904, 37.81943], [-121.54883, 37.81913], [-121.5488, 37.81906], [-121.54885, 37.81898], [-121.54892, 37.81894], [-121.54902, 37.81894], [-121.54918, 37.81899], [-121.54959, 37.81916], [-121.54998, 37.81948], [-121.55031, 37.81964], [-121.55038, 37.8197], [-121.55038, 37.81981], [-121.5504, 37.81996]]], [[[-121.55519, 37.81644], [-121.5552, 37.81652], [-121.55515, 37.81671], [-121.55508, 37.81681], [-121.55496, 37.8169], [-121.5547, 37.81714], [-121.55391, 37.81771], [-121.55365, 37.81793], [-121.55346, 37.81816], [-121.55327, 37.81857], [-121.55309, 37.81929], [-121.55301, 37.81955], [-121.55289, 37.81981], [-121.55287, 37.81989], [-121.55264, 37.82016], [-121.55244, 37.82024], [-121.5522, 37.82026], [-121.5519, 37.82024], [-121.55144, 37.82011], [-121.55116, 37.81998], [-121.55094, 37.81982], [-121.55077, 37.81964], [-121.55053, 37.81949], [-121.54958, 37.81885], [-121.54934, 37.81872], [-121.55268, 37.8155], [-121.55287, 37.81562], [-121.55298, 37.81575], [-121.55328, 37.81602], [-121.55345, 37.81609], [-121.5538, 37.81617], [-121.55403, 37.8162], [-121.55452, 37.81624], [-121.55477, 37.81622], [-121.55505, 37.8163], [-121.55519, 37.81644]]]]}	Restricted Access 2	17388	Clifton Court Forebay	29182	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	San Joaquin 39	34.457	Clifton Court Forebay		None 867
15547	15547	15546	{"type": "Polygon", "coordinates": [[[-121.27537, 37.70038], [-121.27531, 37.70044], [-121.27489, 37.70053], [-121.27446, 37.70105], [-121.27439, 37.70129], [-121.27435, 37.70153], [-121.2743, 37.70169], [-121.273, 37.70334], [-121.27198, 37.7052], [-121.27185, 37.7052], [-121.27169, 37.70515], [-121.27161, 37.70499], [-121.27158, 37.70481], [-121.27177, 37.70237], [-121.27183, 37.70201], [-121.27198, 37.70166], [-121.2722, 37.70141], [-121.27359, 37.70014], [-121.27383, 37.69976], [-121.27395, 37.69929], [-121.27448, 37.69948], [-121.27471, 37.6995], [-121.27537, 37.70038]]]}	Restricted Access 2	47089	Vernalis Ecological Reserve	30745	219	Central Valley Flood Protection Board 1027	State 5	State Agency 5	http://www.cvfpb.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	San Joaquin 39	20.58	Vernalis ER	0	State Conservation Area 8	2
15623	15623	15622	{"type": "Polygon", "coordinates": [[[-121.29449, 37.72472], [-121.29433, 37.72471], [-121.29406, 37.72428], [-121.29376, 37.72401], [-121.29354, 37.72385], [-121.29301, 37.72354], [-121.29294, 37.72351], [-121.29126, 37.72249], [-121.28998, 37.72168], [-121.28968, 37.72146], [-121.28924, 37.72108], [-121.28872, 37.72048], [-121.28854, 37.72023], [-121.28848, 37.72019], [-121.28717, 37.71812], [-121.28686, 37.7176], [-121.28641, 37.71691], [-121.28628, 37.71675], [-121.28622, 37.71664], [-121.28543, 37.71582], [-121.28517, 37.71557], [-121.28473, 37.7152], [-121.28422, 37.71487], [-121.28388, 37.71467], [-121.28362, 37.71453], [-121.28322, 37.71436], [-121.283, 37.71428], [-121.28293, 37.71428], [-121.27995, 37.7131], [-121.27947, 37.71298], [-121.27924, 37.71294], [-121.27904, 37.71294], [-121.27878, 37.71297], [-121.27865, 37.713], [-121.27841, 37.71308], [-121.27805, 37.71335], [-121.27785, 37.7136], [-121.27772, 37.71386], [-121.27765, 37.71416], [-121.27766, 37.71423], [-121.27765, 37.71431], [-121.27772, 37.71523], [-121.27783, 37.71571], [-121.27793, 37.71595], [-121.27834, 37.71713], [-121.27837, 37.71751], [-121.27832, 37.71789], [-121.27802, 37.71862], [-121.27763, 37.7186], [-121.27807, 37.71782], [-121.27814, 37.7176], [-121.27816, 37.71745], [-121.27813, 37.71723], [-121.27805, 37.71704], [-121.27769, 37.7157], [-121.27711, 37.71451], [-121.27706, 37.71433], [-121.27698, 37.71398], [-121.27689, 37.71345], [-121.27685, 37.7131], [-121.27682, 37.71257], [-121.27684, 37.71168], [-121.27691, 37.71101], [-121.2769, 37.71084], [-121.27692, 37.71071], [-121.27697, 37.71052], [-121.27714, 37.71025], [-121.2773, 37.71009], [-121.2775, 37.70995], [-121.27756, 37.70991], [-121.27785, 37.70981], [-121.27859, 37.7098], [-121.27868, 37.7098], [-121.27885, 37.70987], [-121.27892, 37.7099], [-121.27903, 37.71001], [-121.2792, 37.71038], [-121.27935, 37.71067], [-121.27959, 37.71105], [-121.27979, 37.71133], [-121.28001, 37.71158], [-121.2804, 37.712], [-121.28091, 37.71249], [-121.28118, 37.71266], [-121.28148, 37.71297], [-121.28185, 37.71329], [-121.28311, 37.71408], [-121.28375, 37.7143], [-121.28538, 37.71474], [-121.28608, 37.71482], [-121.2868, 37.71493], [-121.28859, 37.71547], [-121.28973, 37.716], [-121.28997, 37.71619], [-121.2902, 37.71644], [-121.29036, 37.71668], [-121.29047, 37.71691], [-121.29054, 37.71709], [-121.29058, 37.71727], [-121.29068, 37.7181], [-121.29089, 37.71938], [-121.29113, 37.72023], [-121.29134, 37.72079], [-121.29167, 37.72147], [-121.29219, 37.72227], [-121.29316, 37.72324], [-121.29363, 37.72374], [-121.29449, 37.72472]]]}	Restricted Access 2	24421	Vernalis Ecological Reserve	30745	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	San Joaquin 39	92.761	Vernalis ER	0	State Conservation Area 8	2

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]);