calands: units_with_maps: 9 rows where ACCESS

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

9 rows where ACCESS_TYP = 2 and COUNTY = 45

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
2782	2782	2781	{"type": "Polygon", "coordinates": [[[-123.95018, 40.54432], [-123.95, 40.54774], [-123.95168, 40.56229], [-123.94988, 40.57504], [-123.93142, 40.57538], [-123.91977, 40.57531], [-123.91927, 40.56181], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55809], [-123.91986, 40.5472], [-123.92568, 40.54733], [-123.92481, 40.53266], [-123.92997, 40.53268], [-123.94513, 40.53325], [-123.94448, 40.54416], [-123.95018, 40.54432]]]}	Restricted Access 2	21606	Owl Creek Ecological Reserve	23278	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		Humboldt 45	2772.208	Owl Creek ER	0	State Conservation Area 8	2
3318	3318	3317	{"type": "Polygon", "coordinates": [[[-124.16888, 40.85809], [-124.16824, 40.85924], [-124.16227, 40.85914], [-124.16173, 40.85708], [-124.16234, 40.85708], [-124.16253, 40.8578], [-124.16325, 40.85769], [-124.16427, 40.85767], [-124.16438, 40.85809], [-124.16888, 40.85809]]]}	Restricted Access 2	29680	Humboldt Coastal Nature Center	20144	3127	Friends of the Dunes 617	Non Profit 6	Non Profit - Conservation 12	http://www.friendsofthedunes.org/	Non Governmental Organization 10	3127	Friends of the Dunes 606	Non Profit 6	Non Profit - Conservation 12		Humboldt 45	19.441	Humboldt Coastal Nature Ctr.	0	Private Recreation or Education 65	4
3591	3591	3590	{"type": "Polygon", "coordinates": [[[-124.14742, 40.69347], [-124.14559, 40.69346], [-124.14538, 40.69323], [-124.14529, 40.69315], [-124.1453, 40.6929], [-124.14528, 40.69266], [-124.14516, 40.69246], [-124.14439, 40.69244], [-124.14425, 40.69237], [-124.14377, 40.69258], [-124.14337, 40.6929], [-124.14227, 40.69323], [-124.14201, 40.69328], [-124.14184, 40.69325], [-124.14175, 40.69317], [-124.14175, 40.69315], [-124.1408, 40.6924], [-124.14079, 40.6925], [-124.14074, 40.69274], [-124.14083, 40.69303], [-124.14104, 40.69323], [-124.14057, 40.69342], [-124.14053, 40.69198], [-124.13941, 40.69246], [-124.1312, 40.69009], [-124.13037, 40.68982], [-124.1215, 40.68448], [-124.12146, 40.68269], [-124.11355, 40.68077], [-124.10809, 40.6787], [-124.10786, 40.6787], [-124.10721, 40.67735], [-124.0988, 40.67462], [-124.09604, 40.67387], [-124.09406, 40.67463], [-124.09347, 40.67584], [-124.08834, 40.67698], [-124.08359, 40.67528], [-124.08359, 40.67524], [-124.07786, 40.67485], [-124.07651, 40.67401], [-124.07441, 40.67364], [-124.07124, 40.6721], [-124.06831, 40.6679], [-124.06471, 40.66617], [-124.0647, 40.66617], [-124.0647, 40.6662], [-124.06468, 40.66621], [-124.06319, 40.6653], [-124.05956, 40.66442], [-124.05778, 40.66229], [-124.05384, 40.65824], [-124.05365, 40.65509], [-124.05002, 40.6541], [-124.04946, 40.65278], [-124.04812, 40.65258], [-124.0477, 40.65187], [-124.04497, 40.65101], [-124.04491, 40.6495], [-124.04189, 40.64952], [-124.04106, 40.64851], [-124.04073, 40.64823], [-124.03978, 40.648], [-124.03632, 40.64835], [-124.02927, 40.64745], [-124.03058, 40.63728], [-124.02908, 40.63553], [-124.02749, 40.63464], [-124.02498, 40.63367], [-124.02012, 40.63067], [-124.02289, 40.62734], [-124.02636, 40.62391], [-124.02952, 40.6237], [-124.03035, 40.62414], [-124.0314, 40.62386], [-124.03149, 40.62163], [-124.03431, 40.62178], [-124.0349, 40.62231], [-124.03653, 40.62122], [-124.03747, 40.6213], [-124.03813, 40.6188], [-124.04011, 40.61761], [-124.04263, 40.61339], [-124.04458, 40.61226], [-124.04459, 40.6127], [-124.0446, 40.61271], [-124.05363, 40.61225], [-124.05809, 40.6085], [-124.05947, 40.60912], [-124.06172, 40.60889], [-124.06364, 40.60903], [-124.06361, 40.60599], [-124.06804, 40.60592], [-124.06818, 40.60858], [-124.06892, 40.60908], [-124.06935, 40.61206], [-124.07123, 40.61266], [-124.07203, 40.6147], [-124.07427, 40.6156], [-124.07464, 40.61645], [-124.07765, 40.61879], [-124.08288, 40.61806], [-124.08893, 40.61992], [-124.09223, 40.62186], [-124.09333, 40.62235], [-124.09552, 40.62446], [-124.09889, 40.62474], [-124.10109, 40.62456], [-124.10608, 40.62589], [-124.11182, 40.62545], [-124.11188, 40.6276], [-124.11191, 40.62761], [-124.11131, 40.64262], [-124.10174, 40.64225], [-124.10166, 40.64898], [-124.10191, 40.65658], [-124.10231, 40.66392], [-124.10343, 40.67117], [-124.10615, 40.6712], [-124.10602, 40.67272], [-124.1088, 40.67387], [-124.11149, 40.67583], [-124.11218, 40.67742], [-124.11561, 40.67875], [-124.11596, 40.67875], [-124.11815, 40.67964], [-124.1214, 40.68025], [-124.12141, 40.68024], [-124.12138, 40.67879], [-124.13117, 40.68583], [-124.13949, 40.68965], [-124.14155, 40.68971], [-124.14739, 40.69182], [-124.14742, 40.69347]], [[-124.09275, 40.67312], [-124.09494, 40.67244], [-124.09639, 40.67249], [-124.0964, 40.67248], [-124.08994, 40.66756], [-124.08528, 40.66692], [-124.08296, 40.66327], [-124.08295, 40.66294], [-124.08063, 40.65854], [-124.07603, 40.65701], [-124.06997, 40.65189], [-124.06773, 40.64819], [-124.06452, 40.64798], [-124.06454, 40.64939], [-124.064, 40.64939], [-124.05629, 40.64394], [-124.04659, 40.64056], [-124.04485, 40.63975], [-124.04491, 40.64863], [-124.05539, 40.65476], [-124.05584, 40.65772], [-124.06019, 40.66206], [-124.06478, 40.66376], [-124.06478, 40.66394], [-124.06676, 40.66461], [-124.07068, 40.66745], [-124.07235, 40.67098], [-124.07617, 40.67265], [-124.07829, 40.67329], [-124.0835, 40.67367], [-124.08351, 40.67365], [-124.08626, 40.67453], [-124.08786, 40.67522], [-124.09141, 40.67419], [-124.09275, 40.67312]]]}	Restricted Access 2	29210	Headwaters Forest Reserve	29960	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	http://www.blm.gov/ca/st/en/prog/nlcs/Headwaters_ForestReserve.html	Humboldt 45	7609.194	Headwaters Forest Reserve	0	State Conservation Area 8	2
4758	4758	4757	{"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]}	Restricted Access 2	46661	Unnamed site - Humboldt, County of	29996	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	19.487		0	Local Other or Unknown 14	4
7381	7381	7380	{"type": "Polygon", "coordinates": [[[-124.07921, 40.91543], [-124.07916, 40.91219], [-124.08423, 40.91223], [-124.08337, 40.91339], [-124.08297, 40.91427], [-124.08271, 40.9151], [-124.08267, 40.91537], [-124.08199, 40.91665], [-124.07922, 40.91579], [-124.07921, 40.91543]]]}	Restricted Access 2	47595	Riverfront Park	31322	2238	McKinleyville Community Services District 624	Special District 4	Community Services District 19	http://mckinleyvillecsd.com/	Special District 4	2238	McKinleyville Community Services District 613	Special District 4	Community Services District 17		Humboldt 45	36.389	Riverfront Park	0	Local Park 2	4
15616	15616	15615	{"type": "Polygon", "coordinates": [[[-124.27423, 40.69404], [-124.27417, 40.69605], [-124.27373, 40.69604], [-124.27351, 40.69725], [-124.27255, 40.69751], [-124.27151, 40.6975], [-124.27042, 40.69722], [-124.26953, 40.69696], [-124.26924, 40.69754], [-124.26451, 40.6969], [-124.26455, 40.69402], [-124.26422, 40.69401], [-124.26428, 40.68722], [-124.26498, 40.68723], [-124.26503, 40.68727], [-124.26536, 40.68771], [-124.27049, 40.69025], [-124.27134, 40.69119], [-124.27308, 40.69196], [-124.27268, 40.69352], [-124.27363, 40.69412], [-124.27423, 40.69404]]]}	Restricted Access 2	21618	Table Bluff Ecological Reserve	26161	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		Humboldt 45	164.236	Table Bluff ER	0	State Conservation Area 8	2
15717	15717	15716	{"type": "Polygon", "coordinates": [[[-124.17331, 40.75172], [-124.17326, 40.75674], [-124.17267, 40.75675], [-124.17266, 40.7579], [-124.17325, 40.75835], [-124.17324, 40.75892], [-124.17209, 40.75892], [-124.17205, 40.76027], [-124.17127, 40.76027], [-124.17159, 40.76112], [-124.16968, 40.76111], [-124.1685, 40.76167], [-124.16946, 40.76364], [-124.16944, 40.76582], [-124.16925, 40.76559], [-124.16887, 40.76544], [-124.16855, 40.76528], [-124.16829, 40.76502], [-124.16822, 40.76453], [-124.16798, 40.764], [-124.16737, 40.76321], [-124.16702, 40.76273], [-124.16641, 40.76243], [-124.16475, 40.76231], [-124.16432, 40.76181], [-124.16548, 40.76078], [-124.1655, 40.76034], [-124.16627, 40.76005], [-124.16657, 40.75991], [-124.16768, 40.75926], [-124.16845, 40.75729], [-124.16943, 40.7565], [-124.16946, 40.75534], [-124.169, 40.75533], [-124.16901, 40.75473], [-124.1685, 40.75433], [-124.16853, 40.75169], [-124.16961, 40.7517], [-124.17004, 40.75223], [-124.17059, 40.75375], [-124.17132, 40.75336], [-124.17215, 40.75248], [-124.17233, 40.75171], [-124.17331, 40.75172]]]}	Restricted Access 2	47013	Eureka Municipal Golf Course	33119	1419	Eureka, City of 715	City 2	City Agency 2	http://www.ci.eureka.ca.gov/depts/pnr/default.asp	City 2	1419	Eureka, City of 698	City 2	City Agency 2		Humboldt 45	118.464	Eureka Municipal GC	0	Local Recreation Area 3	4
15850	15850	15849	{"type": "MultiPolygon", "coordinates": [[[[-124.16059, 40.87217], [-124.15935, 40.87441], [-124.1591, 40.87482], [-124.15841, 40.8758], [-124.15802, 40.87677], [-124.15793, 40.87692], [-124.15746, 40.8779], [-124.15736, 40.87804], [-124.15705, 40.87896], [-124.15707, 40.87975], [-124.15684, 40.88046], [-124.15643, 40.88132], [-124.1557, 40.88248], [-124.15463, 40.884], [-124.15341, 40.88618], [-124.1531, 40.88736], [-124.15228, 40.88842], [-124.15171, 40.88947], [-124.15081, 40.89237], [-124.14956, 40.89484], [-124.14901, 40.89714], [-124.14853, 40.8981], [-124.14798, 40.89904], [-124.14745, 40.90015], [-124.14717, 40.90077], [-124.14702, 40.90141], [-124.13758, 40.90143], [-124.13747, 40.8996], [-124.13857, 40.90032], [-124.13875, 40.90031], [-124.13832, 40.89956], [-124.1387, 40.89925], [-124.13869, 40.89655], [-124.13937, 40.89642], [-124.13968, 40.896], [-124.14294, 40.89593], [-124.14282, 40.89253], [-124.14069, 40.89256], [-124.14045, 40.89212], [-124.14002, 40.8921], [-124.14009, 40.89181], [-124.14043, 40.8918], [-124.14046, 40.89145], [-124.14131, 40.89143], [-124.14123, 40.89108], [-124.14161, 40.89089], [-124.14199, 40.89065], [-124.14188, 40.88971], [-124.14163, 40.88901], [-124.14138, 40.88848], [-124.14151, 40.88777], [-124.1413, 40.88692], [-124.13952, 40.88691], [-124.13952, 40.88663], [-124.13772, 40.8859], [-124.13786, 40.88519], [-124.13851, 40.88394], [-124.1395, 40.88337], [-124.13944, 40.87877], [-124.14934, 40.87533], [-124.15014, 40.87485], [-124.15078, 40.87451], [-124.15139, 40.87417], [-124.15184, 40.87381], [-124.15229, 40.87315], [-124.15289, 40.87208], [-124.15909, 40.87208], [-124.16059, 40.87217]]], [[[-124.15266, 40.87208], [-124.15216, 40.87294], [-124.15169, 40.8737], [-124.15123, 40.87407], [-124.14996, 40.87485], [-124.14922, 40.87527], [-124.14826, 40.87558], [-124.13943, 40.87863], [-124.13941, 40.87686], [-124.14005, 40.877], [-124.14048, 40.87722], [-124.14068, 40.87736], [-124.14092, 40.87725], [-124.14114, 40.877], [-124.14119, 40.87664], [-124.1414, 40.87629], [-124.14178, 40.87609], [-124.14228, 40.87601], [-124.14287, 40.87601], [-124.14336, 40.87594], [-124.1437, 40.87576], [-124.14384, 40.87549], [-124.1438, 40.87521], [-124.14359, 40.87486], [-124.14354, 40.87454], [-124.14353, 40.87433], [-124.1436, 40.87415], [-124.14359, 40.87401], [-124.1438, 40.87379], [-124.14391, 40.87365], [-124.14399, 40.87357], [-124.1441, 40.8735], [-124.14483, 40.87324], [-124.14558, 40.87319], [-124.14582, 40.87316], [-124.14666, 40.87311], [-124.1468, 40.87307], [-124.14695, 40.87296], [-124.14743, 40.87284], [-124.14768, 40.87267], [-124.14772, 40.87256], [-124.14772, 40.87249], [-124.14739, 40.87235], [-124.14716, 40.87219], [-124.14709, 40.87211], [-124.15266, 40.87208]]], [[[-124.14222, 40.91262], [-124.1418, 40.91338], [-124.14125, 40.91495], [-124.14071, 40.91627], [-124.13945, 40.91626], [-124.13942, 40.91259], [-124.14222, 40.91262]]]]}	Restricted Access 2	29383	Humboldt Bay National Wildlife Refuge	20143	106	United States Fish and Wildlife Service 45	Federal 1	Federal Agency 1	http://www.fws.gov/	US Fish and Wildlife Service 8	106	United States Fish and Wildlife Service 44	Federal 1	Federal Agency 1	https://www.fws.gov/refuge/humboldt_bay/	Humboldt 45	880.169	Humboldt Bay NWR	1971	National Wildlife Refuge 105	2
16518	16518	16517	{"type": "MultiPolygon", "coordinates": [[[[-123.82123, 40.13925], [-123.81466, 40.13936], [-123.81156, 40.13939], [-123.80906, 40.14122], [-123.80928, 40.13941], [-123.80891, 40.13941], [-123.80883, 40.13849], [-123.80858, 40.13733], [-123.80758, 40.13584], [-123.80675, 40.13432], [-123.80657, 40.1341], [-123.80645, 40.13238], [-123.81136, 40.1323], [-123.81124, 40.12797], [-123.81226, 40.12808], [-123.81291, 40.12754], [-123.82106, 40.12717], [-123.82074, 40.12801], [-123.82048, 40.12825], [-123.82008, 40.1285], [-123.82009, 40.12851], [-123.82109, 40.1285], [-123.82107, 40.12901], [-123.82108, 40.13566], [-123.82123, 40.13925]]], [[[-123.85492, 40.12513], [-123.85376, 40.12519], [-123.85009, 40.12519], [-123.84531, 40.12533], [-123.84534, 40.12621], [-123.84561, 40.12957], [-123.83164, 40.12877], [-123.83149, 40.12715], [-123.83249, 40.127], [-123.8338, 40.1263], [-123.83436, 40.1259], [-123.83581, 40.12477], [-123.83615, 40.12454], [-123.83615, 40.12452], [-123.83603, 40.12446], [-123.83632, 40.12418], [-123.83671, 40.12293], [-123.83665, 40.12271], [-123.83659, 40.12217], [-123.8349, 40.12204], [-123.83489, 40.12074], [-123.83563, 40.12077], [-123.83638, 40.12092], [-123.83635, 40.12052], [-123.84012, 40.12111], [-123.83998, 40.11884], [-123.83483, 40.1187], [-123.83477, 40.11851], [-123.83572, 40.11817], [-123.83572, 40.11773], [-123.83561, 40.11757], [-123.83495, 40.11696], [-123.83423, 40.11661], [-123.83362, 40.11628], [-123.8333, 40.11596], [-123.83184, 40.11551], [-123.83108, 40.11522], [-123.83092, 40.11531], [-123.8308, 40.11517], [-123.8306, 40.11502], [-123.83022, 40.1149], [-123.83068, 40.11027], [-123.82515, 40.11039], [-123.82502, 40.10649], [-123.84453, 40.10712], [-123.84865, 40.10686], [-123.84968, 40.12166], [-123.85477, 40.1215], [-123.85492, 40.12513]]], [[[-123.82948, 40.12628], [-123.82806, 40.12582], [-123.8262, 40.12562], [-123.82656, 40.12531], [-123.82727, 40.125], [-123.82786, 40.12509], [-123.82805, 40.12533], [-123.82807, 40.12542], [-123.82876, 40.12548], [-123.82935, 40.12517], [-123.82948, 40.12505], [-123.82948, 40.12628]]], [[[-123.83224, 40.11696], [-123.8313, 40.11723], [-123.83058, 40.11725], [-123.83076, 40.11713], [-123.83094, 40.11704], [-123.83187, 40.11665], [-123.83207, 40.1168], [-123.83223, 40.11688], [-123.83224, 40.11696]]], [[[-123.83477, 40.12005], [-123.83429, 40.12011], [-123.8342, 40.11991], [-123.8337, 40.11999], [-123.83354, 40.1196], [-123.83409, 40.11951], [-123.83406, 40.11931], [-123.83473, 40.11921], [-123.83477, 40.12005]]], [[[-123.8348, 40.12203], [-123.83399, 40.12189], [-123.83399, 40.12134], [-123.83435, 40.12136], [-123.83435, 40.12099], [-123.83397, 40.12095], [-123.83395, 40.12067], [-123.8348, 40.12071], [-123.8348, 40.12203]]]]}	Restricted Access 2	20490	John B. Dewitt Redwoods State Natural Reserve	31547	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		Humboldt 45	1226.346	John B. Dewitt Redwoods SNR	1929	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]);