calands: units_with_maps: 5 rows where ACCESS_TYP = 1, MNG_AG_TYP = 5 and YR

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

5 rows where ACCESS_TYP = 1, MNG_AG_TYP = 5 and YR_EST = 1973

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
5741	5741	5740	{"type": "Polygon", "coordinates": [[[-122.84215, 38.09048], [-122.83042, 38.09521], [-122.83018, 38.09487], [-122.82977, 38.09435], [-122.82933, 38.09384], [-122.82886, 38.09336], [-122.82817, 38.09274], [-122.82763, 38.09231], [-122.82705, 38.09189], [-122.82604, 38.09126], [-122.82504, 38.09074], [-122.82139, 38.08918], [-122.82227, 38.08715], [-122.82274, 38.08375], [-122.82367, 38.08274], [-122.82541, 38.08212], [-122.82634, 38.08241], [-122.82694, 38.08242], [-122.82704, 38.0815], [-122.8264, 38.08039], [-122.82589, 38.0802], [-122.82596, 38.08008], [-122.82604, 38.07989], [-122.82605, 38.07977], [-122.82605, 38.07957], [-122.82661, 38.0794], [-122.82703, 38.08012], [-122.83048, 38.07864], [-122.84215, 38.09048]]]}	Open Access 1	1661	Tomales Bay Ecological Reserve	32326	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/Tomales-Bay-ER	Marin 23	442.97	Tomales Bay ER	1973	State Conservation Area 8	2
16491	16491	16490	{"type": "MultiPolygon", "coordinates": [[[[-119.3865, 35.86405], [-119.38621, 35.86416], [-119.38482, 35.86235], [-119.38518, 35.86236], [-119.3865, 35.86405]]], [[[-119.38991, 35.86921], [-119.38753, 35.86597], [-119.38645, 35.86448], [-119.38673, 35.86434], [-119.38973, 35.86842], [-119.38991, 35.86921]]], [[[-119.38696, 35.8638], [-119.38571, 35.86208], [-119.38506, 35.86179], [-119.38476, 35.86141], [-119.38477, 35.86061], [-119.39771, 35.86051], [-119.39778, 35.86198], [-119.4021, 35.86194], [-119.4021, 35.86223], [-119.39772, 35.86226], [-119.39776, 35.86424], [-119.39776, 35.86531], [-119.3978, 35.86911], [-119.39793, 35.86912], [-119.39793, 35.86927], [-119.39691, 35.86928], [-119.3969, 35.86913], [-119.39675, 35.86913], [-119.39675, 35.86926], [-119.39068, 35.8693], [-119.39066, 35.86958], [-119.39049, 35.86958], [-119.39018, 35.86913], [-119.38998, 35.86833], [-119.38696, 35.86422], [-119.38719, 35.86412], [-119.38719, 35.8641], [-119.38696, 35.8638]]], [[[-119.41111, 35.87654], [-119.3979, 35.87664], [-119.39788, 35.87587], [-119.39556, 35.87589], [-119.39083, 35.86959], [-119.39692, 35.86952], [-119.41103, 35.86941], [-119.41111, 35.87654]]], [[[-119.41129, 35.89126], [-119.40602, 35.89129], [-119.39617, 35.87716], [-119.39617, 35.87679], [-119.41128, 35.87667], [-119.41129, 35.89126]]]]}	Open Access 1	791	Colonel Allensworth State Historic Park	1482	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=583	Tulare 29	908.553	Colonel Allensworth SHP	1973	State Historic or Cultural Area 132	4
16715	16715	16714	{"type": "MultiPolygon", "coordinates": [[[[-120.24728, 40.54136], [-120.24253, 40.54135], [-120.24248, 40.53404], [-120.24723, 40.53404], [-120.24728, 40.54136]]], [[[-120.3123, 40.54134], [-120.30921, 40.5413], [-120.30917, 40.534], [-120.3103, 40.53399], [-120.31145, 40.53815], [-120.3123, 40.54134]]], [[[-120.32825, 40.5447], [-120.32733, 40.54475], [-120.32705, 40.54483], [-120.32671, 40.545], [-120.3235, 40.54499], [-120.3235, 40.5461], [-120.32317, 40.54631], [-120.32225, 40.54713], [-120.32193, 40.54748], [-120.32178, 40.54769], [-120.32164, 40.54809], [-120.32147, 40.54847], [-120.32131, 40.5486], [-120.31482, 40.54858], [-120.31444, 40.54721], [-120.31409, 40.54622], [-120.31394, 40.54563], [-120.31397, 40.54135], [-120.31285, 40.54132], [-120.312, 40.53818], [-120.3111, 40.53515], [-120.31085, 40.534], [-120.32348, 40.53401], [-120.32346, 40.53764], [-120.32563, 40.53765], [-120.32682, 40.5377], [-120.32822, 40.53766], [-120.32825, 40.5447]]], [[[-120.32352, 40.54861], [-120.32159, 40.5486], [-120.32166, 40.54854], [-120.32185, 40.54814], [-120.32199, 40.54774], [-120.32211, 40.54757], [-120.32242, 40.54723], [-120.32333, 40.54642], [-120.3235, 40.54632], [-120.32352, 40.54861]]], [[[-120.32825, 40.545], [-120.32795, 40.545], [-120.32709, 40.545], [-120.32739, 40.54491], [-120.32825, 40.54487], [-120.32825, 40.545]]]]}	Open Access 1	5910	Biscar Wildlife Area	30417	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/Biscar-WA	Lassen 54	552.223	Biscar Wildlife Area	1973	State Conservation Area 8	2
16727	16727	16726	{"type": "Polygon", "coordinates": [[[-120.94301, 37.12928], [-120.94293, 37.13488], [-120.9429, 37.1384], [-120.94007, 37.13838], [-120.93723, 37.13839], [-120.91627, 37.14373], [-120.90571, 37.14369], [-120.90635, 37.13006], [-120.9064, 37.12916], [-120.90653, 37.12916], [-120.90672, 37.12493], [-120.90689, 37.12342], [-120.90689, 37.1213], [-120.90715, 37.11711], [-120.90715, 37.11549], [-120.9072, 37.11452], [-120.90707, 37.11451], [-120.90728, 37.10736], [-120.93218, 37.1073], [-120.93427, 37.10566], [-120.93428, 37.10552], [-120.93599, 37.10488], [-120.93659, 37.10542], [-120.93624, 37.10627], [-120.93416, 37.10801], [-120.93406, 37.11461], [-120.94296, 37.11466], [-120.94318, 37.11526], [-120.9431, 37.11962], [-120.94307, 37.12234], [-120.94301, 37.12458], [-120.94301, 37.12928]]]}	Open Access 1	17311	Volta Wildlife Area	30513	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Volta-WA	Merced 37	2873.422	Volta Wildlife Area	1973	State Conservation Area 8	2
16763	16763	16762	{"type": "MultiPolygon", "coordinates": [[[[-120.93599, 37.10488], [-120.93428, 37.10552], [-120.93427, 37.10331], [-120.93527, 37.1042], [-120.93599, 37.10488]]], [[[-120.93724, 37.13839], [-120.93717, 37.14381], [-120.92371, 37.14377], [-120.92363, 37.14496], [-120.92348, 37.14886], [-120.92334, 37.15134], [-120.92319, 37.15482], [-120.92308, 37.15733], [-120.92307, 37.15834], [-120.90781, 37.15825], [-120.90514, 37.15822], [-120.90541, 37.15091], [-120.90528, 37.15093], [-120.90021, 37.15091], [-120.89745, 37.15092], [-120.89781, 37.14368], [-120.9053, 37.14369], [-120.91627, 37.14373], [-120.93724, 37.13839]]]]}	Open Access 1	23362	Volta Wildlife Area	30513	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/Volta-WA	Merced 37	919.433	Volta Wildlife Area	1973	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]);