calands: units_with_maps: 5 rows where COUNTY = 20, MNG_AGENCY = 25 and MNG_AG

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

5 rows where COUNTY = 20, MNG_AGENCY = 25 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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
3284	3284	3283	{"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71315, 33.08099], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]}	Open Access 1	23367	Colorado River Access	32132	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		Imperial 20	488.822	Colorado River Access	0	State Recreation Area 39	4
3490	3490	3489	{"type": "MultiPolygon", "coordinates": [[[[-115.13976, 33.41494], [-115.13975, 33.4189], [-115.13539, 33.41889], [-115.13545, 33.41469], [-115.13976, 33.41494]]], [[[-115.19698, 33.413], [-115.18761, 33.41303], [-115.18762, 33.40954], [-115.1968, 33.40952], [-115.19681, 33.40939], [-115.19685, 33.40941], [-115.19698, 33.413]]], [[[-115.21504, 33.39466], [-115.20553, 33.39498], [-115.20542, 33.3912], [-115.21496, 33.39121], [-115.21504, 33.39466]]]]}	No Public Access 3	25902	Tabaseca	32324	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		Imperial 20	215.634	Tabaseca	0	State Resource Management Area 55	3
15569	15569	15568	{"type": "MultiPolygon", "coordinates": [[[[-115.90891, 33.11807], [-115.89199, 33.11825], [-115.89181, 33.105], [-115.89125, 33.10497], [-115.89125, 33.10383], [-115.89179, 33.10383], [-115.89182, 33.10499], [-115.90865, 33.10492], [-115.90891, 33.11807]]], [[[-115.92585, 33.08992], [-115.92581, 33.10387], [-115.90914, 33.10384], [-115.90877, 33.08985], [-115.92585, 33.08992]]], [[[-115.96046, 33.08941], [-115.96045, 33.10392], [-115.94319, 33.10392], [-115.94318, 33.09143], [-115.94312, 33.09009], [-115.96037, 33.08972], [-115.96038, 33.08941], [-115.96046, 33.08941]]]]}	Open Access 1	5573	San Felipe Creek Ecological Reserve	32292	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	https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Felipe-Creek-ER	Imperial 20	1794.365	San Felipe Creek ER	1994	State Conservation Area 8	2
16574	16574	16573	{"type": "MultiPolygon", "coordinates": [[[[-114.95504, 33.26685], [-114.93776, 33.26689], [-114.93775, 33.26702], [-114.93746, 33.26702], [-114.93746, 33.26668], [-114.93718, 33.26668], [-114.93713, 33.2594], [-114.93712, 33.25216], [-114.95448, 33.25207], [-114.95504, 33.26685]]], [[[-114.98888, 33.26647], [-114.98008, 33.26656], [-114.97992, 33.25954], [-114.97989, 33.25216], [-114.98884, 33.25215], [-114.98888, 33.26647]]]]}	No Public Access 3	44921	Smoketree Valley - Chocolate Mountains	32312	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		Imperial 20	990.532	Smoketree Valley - Chocolate Mtns.	0	State Resource Management Area 55	3
16697	16697	16696	{"type": "MultiPolygon", "coordinates": [[[[-115.54403, 33.0963], [-115.54396, 33.10096], [-115.53918, 33.09943], [-115.53686, 33.09817], [-115.53459, 33.09627], [-115.53452, 33.10291], [-115.52318, 33.10278], [-115.52328, 33.09652], [-115.52428, 33.09535], [-115.52227, 33.09321], [-115.52102, 33.09174], [-115.51989, 33.0921], [-115.51875, 33.09043], [-115.51874, 33.08887], [-115.51431, 33.08886], [-115.51428, 33.08362], [-115.51221, 33.08359], [-115.51224, 33.0816], [-115.51036, 33.08174], [-115.51035, 33.08229], [-115.50872, 33.08223], [-115.5059, 33.07844], [-115.50579, 33.07833], [-115.50573, 33.07822], [-115.50492, 33.07712], [-115.5046, 33.07628], [-115.50436, 33.07548], [-115.50443, 33.07469], [-115.50477, 33.07372], [-115.50541, 33.0722], [-115.50759, 33.07057], [-115.50719, 33.07005], [-115.50613, 33.07005], [-115.50546, 33.06981], [-115.50509, 33.06962], [-115.50474, 33.06928], [-115.50424, 33.06856], [-115.50398, 33.068], [-115.50358, 33.06771], [-115.50344, 33.06738], [-115.50342, 33.06644], [-115.50064, 33.06639], [-115.50061, 33.06447], [-115.49635, 33.06441], [-115.4962, 33.05942], [-115.49612, 33.05901], [-115.49181, 33.05894], [-115.49178, 33.0518], [-115.4875, 33.05174], [-115.48856, 33.04958], [-115.49027, 33.04958], [-115.49049, 33.04822], [-115.48758, 33.04622], [-115.48666, 33.04463], [-115.4927, 33.04464], [-115.49628, 33.04542], [-115.49972, 33.04559], [-115.50082, 33.0461], [-115.50089, 33.04639], [-115.50086, 33.04662], [-115.50093, 33.04693], [-115.50126, 33.04714], [-115.5027, 33.04818], [-115.50282, 33.04825], [-115.5029, 33.04969], [-115.50342, 33.0517], [-115.50248, 33.05176], [-115.50243, 33.05186], [-115.50228, 33.0524], [-115.50232, 33.05283], [-115.50229, 33.05319], [-115.50234, 33.05356], [-115.50235, 33.05387], [-115.50265, 33.0543], [-115.50274, 33.05466], [-115.50302, 33.05543], [-115.50315, 33.05593], [-115.5032, 33.05626], [-115.50336, 33.05657], [-115.50353, 33.05679], [-115.50406, 33.05712], [-115.50426, 33.05732], [-115.50449, 33.05776], [-115.50492, 33.05821], [-115.5054, 33.05869], [-115.5056, 33.05914], [-115.50665, 33.05917], [-115.50667, 33.06267], [-115.50905, 33.0627], [-115.50903, 33.06633], [-115.51075, 33.06633], [-115.51075, 33.06596], [-115.51323, 33.06592], [-115.51323, 33.06633], [-115.51351, 33.06634], [-115.51358, 33.06985], [-115.51418, 33.06988], [-115.51416, 33.07004], [-115.51438, 33.07003], [-115.51464, 33.07112], [-115.51569, 33.07233], [-115.51697, 33.07369], [-115.51696, 33.07401], [-115.51699, 33.07479], [-115.52297, 33.07498], [-115.523, 33.08181], [-115.52698, 33.08186], [-115.5269, 33.08549], [-115.52752, 33.08579], [-115.52816, 33.08644], [-115.52881, 33.08688], [-115.52949, 33.0871], [-115.52994, 33.0874], [-115.53064, 33.08812], [-115.53096, 33.08865], [-115.53145, 33.0892], [-115.5318, 33.08946], [-115.53601, 33.0897], [-115.53601, 33.09639], [-115.54403, 33.0963]], [[-115.50412, 33.06721], [-115.50373, 33.06641], [-115.50371, 33.0664], [-115.50362, 33.06651], [-115.50369, 33.06684], [-115.50404, 33.0674], [-115.50406, 33.0674], [-115.50412, 33.06721]]], [[[-115.61839, 33.31096], [-115.61839, 33.31419], [-115.61435, 33.3146], [-115.61438, 33.32181], [-115.609, 33.32183], [-115.60334, 33.31423], [-115.59698, 33.30727], [-115.59154, 33.29999], [-115.58547, 33.2927], [-115.58127, 33.28729], [-115.57569, 33.28037], [-115.5695, 33.27289], [-115.56605, 33.26854], [-115.56541, 33.26768], [-115.56517, 33.2672], [-115.56452, 33.26682], [-115.56365, 33.2662], [-115.56257, 33.26515], [-115.56256, 33.24864], [-115.55348, 33.24842], [-115.55335, 33.2347], [-115.56268, 33.23472], [-115.56263, 33.22769], [-115.57976, 33.22741], [-115.57968, 33.24922], [-115.58835, 33.24925], [-115.58839, 33.26366], [-115.58843, 33.26367], [-115.58844, 33.2637], [-115.59708, 33.26366], [-115.597, 33.28545], [-115.60105, 33.28546], [-115.60105, 33.28863], [-115.60135, 33.28864], [-115.60135, 33.2891], [-115.60539, 33.28912], [-115.60558, 33.29276], [-115.60997, 33.29279], [-115.60981, 33.30313], [-115.61001, 33.30316], [-115.61001, 33.30366], [-115.6143, 33.30368], [-115.61433, 33.31083], [-115.61436, 33.31083], [-115.61436, 33.31093], [-115.61839, 33.31096]]], [[[-115.59708, 33.1839], [-115.59706, 33.19835], [-115.58852, 33.1984], [-115.58851, 33.19841], [-115.57549, 33.19841], [-115.57549, 33.19115], [-115.58406, 33.19115], [-115.58333, 33.18994], [-115.58507, 33.18952], [-115.58509, 33.18907], [-115.58518, 33.18897], [-115.58551, 33.18874], [-115.58571, 33.18873], [-115.58598, 33.18867], [-115.58608, 33.18856], [-115.58618, 33.18826], [-115.58589, 33.18784], [-115.58527, 33.18735], [-115.58424, 33.18707], [-115.58404, 33.18695], [-115.58393, 33.18667], [-115.58369, 33.18651], [-115.58371, 33.18612], [-115.58418, 33.18608], [-115.5849, 33.18588], [-115.58551, 33.18562], [-115.5859, 33.18548], [-115.5861, 33.18532], [-115.58617, 33.1852], [-115.58625, 33.18504], [-115.58629, 33.18467], [-115.58626, 33.1844], [-115.58623, 33.18432], [-115.58618, 33.18389], [-115.59708, 33.1839]]]]}	Open Access 1	1740	Imperial Wildlife Area	30457	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	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Imperial-WA	Imperial 20	7802.975	Imperial Wildlife Area	1951	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]);